Client Management Suite

 View Only
Back to Library

How to Find What Filters a Computer Is a Member Of 

Nov 27, 2014 05:48 AM

There are three ways to find this information:

1) From the SMP Console you can simply add the machine's resource GUID value at the end of the link below:
 
 
2) From the Console go to Manage > Computers search for the computer Name then Right-click, select
Resource Manager for that particular system, and go to Summaries > Filter Summary.
 
3) From SQL Server Management Studio
you can look at the CollectionMembership and connect this with item and/or vcomputer table, for example with the following query:

SELECT v.Name AS 'Computer Name', i.Name AS 'Filter Name', p.Name AS 'Solution', i.CreatedDate AS 'CreatedDate', i.ModifiedDate AS 'ModifiedDate'
FROM vcomputer v INNER JOIN CollectionMembership c
ON v.Guid = c.ResourceGuid
INNER JOIN vItem i
ON i.Guid = c.CollectionGuid
INNER JOIN vNonResourceItem n
ON c.CollectionGuid = n.Guid
INNER JOIN vProduct p
ON p.Guid = n.ProductGuid
WHERE v.Name like '<type Computer name here>'

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.