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.
    Blogger Comment

10 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. Good post but I was wondering if you could write a litte more on this subject? I’d be very thankful if you could elaborate a little bit further. Appreciate it..! Learn more

    ReplyDelete
  3. One present why galore businesses opt for postcards is because they are overmuch cheaper to be prefab and this can forbear a lot of expenses on the lengthened run.  scopri di piu

    ReplyDelete
  4. Awesome review, I am a major devotee to remarking on web journals to educate the web journal scholars realize that they've added something beneficial to the internet!..  diebestenvpn

    ReplyDelete
  5. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own BlogEngine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it. mejoresvpn.com

    ReplyDelete
  6. I truly welcome this superb post that you have accommodated us. I guarantee this would be valuable for the vast majority of the general population. privacyenbescherming

    ReplyDelete
  7. A debt of gratitude is in order for the significant data and experiences you have so given here... https://getmoreprivacy.com

    ReplyDelete
  8. A computer gets contribution through info gadgets, for example, the console and mouse (equipment).Chaktty PC diagnostic test

    ReplyDelete
  9. In the event that you are a general client, so different mouses isn't superior to the standard two-catch, three-catch mouse. www.mouse-pad.cn;

    ReplyDelete
  10. Your blogs are easily accessible and quite enlightening so keep doing the amazing work guys. https://privacyonline.com.br

    ReplyDelete