Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
Last Reboot Report

Answered Last Reboot Report

  • Sunday, March 04, 2012 10:06 PM
     
     
    Sign In to Vote
    0

    Hi

    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.

    select  distinct
    v_R_System_Valid.ResourceID,
    v_R_System_Valid.Netbios_Name0 AS [Computer Name],
    V_GS_OPERATING_SYSTEM.LastBootUpTime0 AS [Last Boot Time],
    v_R_System_Valid.Resource_Domain_OR_Workgr0 AS [Domain/Workgroup],
    v_Site.SiteCode as [SMS Site Code]
    from v_R_System_Valid
    inner join v_GS_OPERATING_SYSTEM on (v_GS_OPERATING_SYSTEM.ResourceID = v_R_System_Valid.ResourceID)
    inner join v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_R_System_Valid.ResourceID)
    left  join v_Site on (v_FullCollectionMembership.SiteCode = v_Site.SiteCode)
    Where v_FullCollectionMembership.CollectionID = @CollectionID
    Order by v_R_System_Valid.Netbios_Name0

    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
    •  
     

All Replies

  • Sunday, March 04, 2012 10:41 PM
    Moderator
     
     
    Sign In to Vote
    0
    What do you mean by Last Status time? Where do you find this within the console?

    http://www.enhansoft.com/

     
  • Monday, March 05, 2012 12:25 AM
     
     
    Sign In to Vote
    0

    Hi

    Last status time from Advertisment with  Last Status Message ID  = 10008 

     
  • Sunday, March 18, 2012 4:38 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    I don’t know how I missed this one but try this http://tinyurl.com/87yax5j


    http://www.enhansoft.com/

    • Marked As Answer by Vimal80 Monday, March 19, 2012 12:26 AM
    •  
     
  • Monday, March 19, 2012 12:26 AM
     
     
    Sign In to Vote
    0
    Thanks Garth!!.