SCCM Report: “System Boot Time for Computers in a Specific Collection

This is a report I wrote last week:

“System Boot Time for Computers in a Specific Collection”.

SQL Statement:

[sourcecode language=”SQL”]

select  distinct
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



Name: CollectionID

Prompt Text: Collection

Prompt SQL Statement:

[sourcecode language=”SQL”]
if (@__filterwildcard = ”)
select v_Collection.CollectionID, v_Collection.Name from v_Collection order by v_Collection.Name
select v_Collection.CollectionID, v_Collection.Name from v_Collection
WHERE v_Collection.CollectionID like @__filterwildcard
order by v_Collection.Name

Please note the system boot time is collected from LastBootUpTime in Win32_OperatingSystem via SCCM client hardware inventory. Therefore the information is as current as SCCM client’s last hardware inventory.




  1. Hi

    Great report mate..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

  2. thanks for this report 🙂 would it possible to have a system boot time report for specific computers?

  3. hi can i know how to know the last reboot of the server without logging into server and without query statements

Leave a Reply

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

%d bloggers like this: