SCCM Report to List down the not rebooted workstations

This is a very useful report to list down the not rebooted workstations for a specific time. SCCM custom report to find out machines which are rebooted wince long time.

========================================================

SQL Query – Not Rebooted Workstations

SQL Query (Change the constants (TOP 10, GETDATE()) > 7) as per your requirement)

Patch My PC
SELECT TOP (100) PERCENT dbo.v_R_System.Name0, dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, DATEDIFF(Day,<br><br><br>dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, GETDATE()) AS [Days since last boot], dbo.v_GS_OPERATING_SYSTEM.Caption0<br><br><br>FROM dbo.v_GS_OPERATING_SYSTEM INNER JOIN<br><br><br>dbo.v_R_System ON dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_R_System.ResourceID<br><br><br>WHERE (DATEDIFF(Day, dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0, GETDATE()) &gt; 7) AND (dbo.v_GS_OPERATING_SYSTEM.Caption0 LIKE '%xp%') OR<br><br><br>(dbo.v_GS_OPERATING_SYSTEM.Caption0 LIKE '%Windows 7%') OR<br><br><br>(dbo.v_GS_OPERATING_SYSTEM.Caption0 LIKE '%vista%')<br><br><br>ORDER BY [Days since last boot]

========================================================

WQL Query – Not Rebooted Workstations

WQL collection based Query (Change the constants (GETDATE()) > 7) as per your requirement)

select distinct SMS_R_System.Name, SMS_G_System_OPERATING_SYSTEM.LastBootUpTime, SMS_G_System_OPERATING_SYSTEM.Caption from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where (SMS_G_System_OPERATING_SYSTEM.Caption like “%xp%” or SMS_G_System_OPERATING_SYSTEM.Caption like “%vista%” or SMS_G_System_OPERATING_SYSTEM.Caption like “%windows 7%”) and (DateDiff(day, SMS_G_System_OPERATING_SYSTEM.LastBootUpTime, GetDate()) >7)

1E Nomad

========================================================

Original Post http://scug.dk/blogs/configurationmanager/archive/2009/10/02/report-all-workstations-that-haven-t-rebooted-the-last-7-days.aspx

Anoop is Microsoft MVP! He is a Solution Architect on enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is Blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, Intune. He writes about technologies like ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.…

2 thoughts on “SCCM Report to List down the not rebooted workstations”

  1. SQL query does not work, syntax error, cannot create a report in SCCM

    WQL does not work, syntax error, cannot create a collection or query in SCCM.

    Job well done………..

    Reply
  2. The issue is the formatting of the text on the webpage. If you do a find a replace of the ’ and replace them with ‘ then it works great.

    Here is it fixed.

    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

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.