Skip to content

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

Featured Replies

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.

 

post-2397-1234159049_thumb.jpg

 

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.

post-2397-1234159713_thumb.jpg

 

Press on Edit SQL Statement...

post-2397-1234159807_thumb.jpg

 

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

post-2397-1234159984_thumb.jpg

 

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.

post-2397-1234160221_thumb.jpg

 

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

post-2397-1234160344_thumb.jpg

 

All done, hit F5 to refresh your report.

 

Thanks to WMMAYMS that has learned me this!

 

/Tobias

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.