ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How can I Report on a Target Filter Membership?

book

Article ID: 236970

calendar_today

Updated On:

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