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

16 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. A debt of gratitude is in order for the significant data and experiences you have so given here... https://getmoreprivacy.com

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

    ReplyDelete
  8. 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
  9. Your blogs are easily accessible and quite enlightening so keep doing the amazing work guys. https://privacyonline.com.br

    ReplyDelete
  10. If you want to connect multiple devices to your computer, then you will need a USB hub. type c to hdmi

    ReplyDelete
  11. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here keep up the good work microprose

    ReplyDelete
  12. This comment has been removed by a blog administrator.

    ReplyDelete
  13. Wow i can say that this is another great article as expected of this blog.Bookmarked this site.. mining

    ReplyDelete
  14. This is actually the kind of information I have been trying to find. Thank you for writing this information. http://best-hardware-store-singapore.launchrock.com/

    ReplyDelete
  15. This is highly informatics, crisp and clear. I think that everything has been described in systematic manner so that reader could get maximum information and learn many things. check more info about hardware store

    ReplyDelete
  16. I’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article... hardware store singapore online

    ReplyDelete

Note: Only a member of this blog may post a comment.