SCCM report of computers with serial, user and last login time

I created a custom SCCM report that has the following inforation:

  • Computername
  • Serial number
  • Last logged in user
  • Last logged in time

Here is the SQL query needed for the dataset in Report Builder.

select dbo.v_R_System.Netbios_Name0 AS [Computer Name], dbo.v_GS_SYSTEM_ENCLOSURE.SerialNumber0 AS [Serial Number],
dbo.v_R_System.User_Name0 [Last Logon User Name], dbo.v_R_System.Last_Logon_Timestamp0 [Last logged in time]
FROM dbo.v_R_System
LEFT JOIN dbo.v_GS_SYSTEM_ENCLOSURE ON dbo.v_GS_SYSTEM_ENCLOSURE.ResourceID = dbo.v_R_System.ResourceID

Anders Rødland

Anders Rødland started his IT career in 2006. My main focus is MS Configuration Manager and client management, and I currently hold active 15 Microsoft certifications. Certified on Windows Server, Windows Client, SQL, Exchange and System Center Configuration Manager. Anders Rødland also holds an ITIL Foundation certification. This is my private blog and do not represent my employer. I use this to share information that I find useful. Sharing is caring.