SMS SQL for Computers and their Advertisement Status
Computers and their Advertisement Status
----Begin SQL----
SELECT SYS.Netbios_Name0, ADV.AdvertisementID, ADV.AdvertisementName,
COL.Name AS TargetedCollection, CAS.LastStatusMessageIDName
FROM v_ClientAdvertisementStatus CAS INNER JOIN v_R_System SYS
ON CAS.ResourceID = SYS.ResourceID INNER JOIN v_Advertisement ADV
ON CAS.AdvertisementID = ADV.AdvertisementID INNER JOIN
v_Collection COL ON ADV.CollectionID = COL.CollectionID
ORDER BY SYS.Netbios_Name0, ADV.AdvertisementID
----End SQL----
----Begin SQL----
SELECT SYS.Netbios_Name0, ADV.AdvertisementID, ADV.AdvertisementName,
COL.Name AS TargetedCollection, CAS.LastStatusMessageIDName
FROM v_ClientAdvertisementStatus CAS INNER JOIN v_R_System SYS
ON CAS.ResourceID = SYS.ResourceID INNER JOIN v_Advertisement ADV
ON CAS.AdvertisementID = ADV.AdvertisementID INNER JOIN
v_Collection COL ON ADV.CollectionID = COL.CollectionID
ORDER BY SYS.Netbios_Name0, ADV.AdvertisementID
----End SQL----
About the Author
Emmanuel Tsouris is a Systems Management veteran and Developer Advocate specializing in PowerShell and Cloud Automation. He maintains DotVBS to preserve legacy knowledge for the "archaeologist admin."
Ready to move from VBScript to the Cloud? Check out his book, Pro PowerShell for Amazon Web Services.
Visit EmmanuelTsouris.com for his latest projects.
As an Amazon Associate, I earn from qualifying purchases at no cost to you.
Comments