3
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:
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
Prompts:
Name: CollectionID
Prompt Text: Collection
Prompt SQL Statement:
begin if (@__filterwildcard = '') select v_Collection.CollectionID, v_Collection.Name from v_Collection order by v_Collection.Name else select v_Collection.CollectionID, v_Collection.Name from v_Collection WHERE v_Collection.CollectionID like @__filterwildcard order by v_Collection.Name end
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.
Example:
3 Comments
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
thanks for this report
would it possible to have a system boot time report for specific computers?
hi can i know how to know the last reboot of the server without logging into server and without query statements