joan_mckinley
Level 6

AppPortal SQL Table for Visibility Collections Applied to Catalog Item

Jump to solution

Does anyone happen to know that SQL table/view for AppPortal that stores the Visibility Collections applied to catalog items?

We have a few hundred catalog items and need to verify/change the SCCM collection that is applied to our catalog items.

I have searched through all the tables and views and can not find it.

Thank you!

Joan

0 Kudos
1 Solution
jdempsey
Moderator Moderator
Moderator

Look at WD_VPackageProperty.  All visibility conditions will be stored in that table, but collections will be stored by collection ID rather than by name. 

Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".

View solution in original post

3 Replies
jdempsey
Moderator Moderator
Moderator

Look at WD_VPackageProperty.  All visibility conditions will be stored in that table, but collections will be stored by collection ID rather than by name. 

Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".

View solution in original post

Thank you! That was so fast. Exactly what I was looking for. 🙂
0 Kudos

I’ve met same problem, I did it in the same way and everything worked perfect. Thanks for sharing.

0 Kudos