We recently migrated our SCCM environment and stood up a separate App Portal instance. We used a script to perform a bulk import of our existing catalog items, but some of them did not come over with the correct visibility settings. Most of our objects have visibility settings restricted by SCCM collection. However, one of those collections did not exist when we did the bulk import and this has lead to some of the packages not being visible to most users.
Since we have 1K+ packages, I need some way to pull a report to show which ones have broken visibility so that we can correct them. There probably are not very many still out there, but I know there are some.
I have found the WD_WebPackages table contains most of the data I'm looking for, however I cannot find where the visibility group collection names or IDs are stored in the DB.
Any idea where the visibility collection names/IDs might be located?