Today, I will use the SCCM Report to List the Not Rebooted Workstations. This beneficial report lists the workstations that have not been rebooted for a specific time period.
SCCM custom report is used to find out which machines have been rebooted for a long time.
Table of Contents
SQL Query – Not Rebooted Workstations
SQL Query (Change the constants (TOP 10, GETDATE()) > 7) as per your requirement)
- ConfigMgr Reports Site Infrastructure Related | SCCM | Default Configuration Manager
- List of SCCM Default Reports | Configuration Manager
- ConfigMgr Reports Application Package Distribution | Default | SCCM | Configuration Manager
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()) > 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)
Original Post http://scug.dk/blogs/configurationmanager/archive/2009/10/02/report-all-workstations-that-haven-t-rebooted-the-last-7-days.aspx
We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.
Author
Anoop C Nair is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is a Blogger, Speaker, and Local User Group HTMD Community leader. His primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.
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………..
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