Hello,
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?
Thanks!
‎Jun 04, 2024 06:14 AM
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.
‎Jun 04, 2024 04:21 PM