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----