Sunday, March 04, 2012 10:06 PM
I got this SQL Report from this link http://blog.tyang.org/2011/07/26/sccm-report-system-boot-time-for-computers-in-a-specific-collection/, I would like to get 2 more columns with it.
[SMS Site Code]
(v_GS_OPERATING_SYSTEM.ResourceID = v_R_System_Valid.ResourceID)
(v_FullCollectionMembership.ResourceID = v_R_System_Valid.ResourceID)
(v_FullCollectionMembership.SiteCode = v_Site.SiteCode)
v_FullCollectionMembership.CollectionID = @CollectionID
I would like to get last status time for that collection and difference between last status time and last boot up time which will provide whether machine is rebooted or not. Thanks
- Edited by Vimal80 Sunday, March 04, 2012 10:07 PM
Sunday, March 04, 2012 10:41 PMModeratorWhat do you mean by Last Status time? Where do you find this within the console?
Monday, March 05, 2012 12:25 AM
Last status time from Advertisment with Last Status Message ID = 10008
Sunday, March 18, 2012 4:38 PMModerator
I don’t know how I missed this one but try this http://tinyurl.com/87yax5j
- Marked As Answer by Vimal80 Monday, March 19, 2012 12:26 AM
Monday, March 19, 2012 12:26 AMThanks Garth!!.