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

[maheshpatil]

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!

[CharlesW]

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.