Create a Filter / SQL query to retrieve the resources in a specific Organizational Group

book

Article ID: 180470

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Use the following SQL query, also you can create a new filter with Query Mode: Raw SQL and paste the following query in it:

Select s.resourceguid from ScopeMembership S join vNonResourceItem V on s.ScopeCollectionGuid = v.Guid
where v.Name = 'Organizational Group Name'