Reporting on a Target Filter Membership

Products

• IT Management Suite
• Client Management Suite
• Server Management Suite

Issue/Introduction

There is a need to report on a Target membership.

Environment

Release: 8.x

Resolution

1. Navigate to Manage > Computers. In the Target area
2. Locate the target you want to report on.
3. Right-click the target and select Properties in the context menu
4. Copy the GUID (exclude the brackets)
5. Paste the GUID into the last line of this query:

select
     i.name as 'Target',
     vc.name as 'Computer'
from  ResourceTargetMembershipCache mc
join item i on i.guid = mc.ResourceTargetGuid
join vcomputer vc on vc.guid = mc.ResourceGuid
where mc.ResourceTargetGuid = 'TARGET GUID'

To add this report as a custom report in the console:

1. Navigate to Reports > All Reports
2. Right-click a folder where you want to store the report and select New > Report > SQL Report
3. Delete the initial query seen in the Data Source > Parametrized Query tab
4. Paste in the above query with the GUID of the desired target
5. Click Save Changes