Solved: AppPortal SQL Table for Visibility Collections Applied to Catalog Item

joan_mckinley · ‎Aug 08, 2019

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

jdempsey · ‎Aug 08, 2019

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

jdempsey · ‎Aug 08, 2019

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".

joan_mckinley · ‎Aug 08, 2019

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

DanRussell · ‎Aug 08, 2019

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