SCCM Report - Hardware - General > Computer Ages

This is an SCCM report to generate a list of computers and their ages with additional info like last boot up time.
This report was created and tested for SCCM 2012 Current Branch

Create these parameters

• Year - default value of %
• OS - I used values of
• %Workstation%
• %Server%
• GroupDomain - absolute values of the domain you are searching. I did this because I had more than one domain. the domain value should be in this format "domain\\" without the quotations/
• AD_Group_Name - value of Domain Users. Default value of %
• collectionID - SCCM computer collection IDs.  Use available values. Also put % as the default value
• Domain - 

Then create this query in the Dataset

SELECT DISTINCT

CS.Name0 as "Computer Name",

CS.User_Name0 as "User Name",

U.Full_User_Name0 as "User",

OS.Caption0 as "OS",

CS.AD_Site_Name0 as "AD Site",

YEAR (BIOS.ReleaseDate0) as Year, 

OS.LastBootUpTime0 as "Last Boot Up Time",

BIOS.SerialNumber0 as "Serial Number",

CU.Model0 as 'Model'

from  

v_R_System CS

FULL join v_GS_PC_BIOS BIOS on BIOS.ResourceID = CS.ResourceID

FULL join v_GS_COMPUTER_SYSTEM CU on CU.ResourceID = CS.ResourceID

FULL join dbo.v_R_User U on U.User_Name0 = CS.User_Name0

FULL join dbo.v_GS_OPERATING_SYSTEM OS on OS.ResourceID = CS.ResourceID

FULL join dbo.v_RA_User_UserGroupName UGN on U.ResourceID = UGN.ResourceID 

WHERE YEAR(BIOS.ReleaseDate0) Like @Year AND

CS.Operating_System_Name_and0 Like @OS AND

UGN.User_Group_Name0 Like ((@GroupDomain) + '%' + (@AD_Group_Name) + '%') AND

CU.Domain0 Like @Domain

ORDER BY

YEAR(BIOS.ReleaseDate0)

Create a table with these fields

• computer Name
• User Name
• User
• AD Site
• Year
• Last Boot Up Time
• Model
• OS
• Serial Number

Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.