:::: MENU ::::

SCCM Report for List of advertisements Advertisment status

This below report will be usefull when your trying to generate the report with mutiple advertisement in single execution

SELECT DISTINCT v_R_System.Name0 AS [System Name], v_R_System.User_Name0 AS [User Name],
vSMS_ClientAdvertisementStatus.AdvertisementID AS [Advertisemnt ID],
v_Advertisement.AdvertisementName,
v_Advertisement.ProgramName,vSMS_ClientAdvertisementStatus.LastStatusMessageIDName AS [Last Status Message],
vSMS_ClientAdvertisementStatus.LastStateName AS [Last Status], vSMS_ClientAdvertisementStatus.Lastexecutionresult
FROM vSMS_ClientAdvertisementStatus INNER JOIN
v_R_System ON vSMS_ClientAdvertisementStatus.ResourceID = v_R_System.ResourceID INNER JOIN
V_Advertisement ON vSMS_ClientAdvertisementStatus.AdvertisementID = v_Advertisement.AdvertisementID INNER JOIN
v_RA_System_SMSAssignedSites ON v_R_System.ResourceID = v_RA_System_SMSAssignedSites.ResourceID
WHERE    v_Advertisement.AdvertisementID in(‘ADVERTID1′,’ADVERTID2’)
ORDER BY v_Advertisement.ProgramName


So, what do you think ?