Extend "All advertisement for a specific computer" with latest runtime

[Tobie]

Extend "All advertisement for a specific computer" with latest runtime

 

If you want to add a new column with Last Status Time in your SMS Report, fallow the steps below.

 

 

Expand Site Database, Computer Management, Reporting and mark Reports. Right click on report All advertisement for a specific computer and and choose Properties. Report ID 126.

 

Press on Edit SQL Statement...

 

Replace SQL Statement with the contect below (CODE), press OK.

 

SELECT  adv.AdvertisementName,
						 stat.LastStateName,
						 DATEADD(ss,@__timezoneoffset,LastStatusTime) as LastStatusTime,
						 adv.Comment AS C072, 
						 pkg.Name AS C062,
						 adv.ProgramName AS C071,
						 adv.SourceSite,
						 adv.AdvertisementID
FROM v_Advertisement adv
JOIN v_Package pkg ON adv.PackageID = pkg.PackageID
JOIN v_ClientAdvertisementStatus stat ON stat.AdvertisementID = adv.AdvertisementID
JOIN v_R_System sys ON stat.ResourceID=sys.ResourceID
WHERE sys.Netbios_Name0=@ComputerName

 

Go to Links tab and mark AdvertID and press on Edit.

 

Change the value "AdvertID" to Column = "8" instead of "7", press OK.

 

All done, hit F5 to refresh your report.

 

Thanks to WMMAYMS that has learned me this!

 

/Tobias