Report: All collections for a specific computer
Posted
Monday, April 13, 2009 9:53 AM
by
bwilms
The SMS 2003 web report query below returns the collection membership for a specific computer name. It also displays whether the collection has an advertisement associated with it. I've found it very helpful when trying to determine what advertisements a client should be receiving as well as if the client has ended up in some "funny" collections. It is similar to the canned report "All advertisements for a specific computer".
SELECT fcm.Name,
col.Name,
adv.AdvertisementName,
col.CollectionID
FROM v_Collection col JOIN
v_FullCollectionMembership fcm ON col.CollectionID=fcm.CollectionID LEFT JOIN
v_Advertisement adv ON col.CollectionID=adv.CollectionID
WHERE fcm.Name LIKE @name
ORDER BY col.Name
Copy and paste the above query into SMS web reporting, remembering to create a prompt. Or simply download the attached TXT file, rename it to a MOF and import it into SMS Reporting.
All collections for a specific computer (custom).mof.txt