NateLowery
Level 2

App Portal SQL Query to Get Catalog Item Visibility Groups

Jump to solution

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?

0 Kudos
1 Solution
NateLowery
Level 2

Never mind, I finally found the table I was looking for: WD_VPackageProperty

View solution in original post

This thread has been automatically locked due to inactivity.

To continue the discussion, please start a new thread.

1 Reply
NateLowery
Level 2

Never mind, I finally found the table I was looking for: WD_VPackageProperty