Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Query to list Catalog items with visibility restrictions and associated groups/users


Requesting help to build SQL query to list application catalog items within App Portal that have visibility restrictions set along with the group/individuals that the visibility is restricted.

I think " VisibleGroup = 1" property in WD_WebPackages will help in listing out the Catalog Items with Visibility restrictions but how to get the groups/users associated?


(1) Reply
By Level 12 Flexeran
Level 12 Flexeran

This can't really be done by a SQL query. App Broker only stores the AD GUID for users and groups in the DB. The name is looked up directly, when required, by a call into AD.. Note that visibility conditions are stored in WD_VPackageProperty.