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.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 [/sourcecode]   Prompts: Name: CollectionID Prompt Text: Collection Prompt SQL Statement: [sourcecode language=”SQL”] begin if (@__filterwildcard = ”) select v_Collection.CollectionID, v_Collection.Name from v_Collection order by v_Collection.Name else select v_Collection.CollectionID,

Continue reading
%d bloggers like this: