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

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 have passed 17 Microsoft certifications since then. My main expertise is on client management with Microsoft Endpoint Manager: Intune and Configuration Manager. I also do a lot of work on the security side with Microsoft Defender for Endpoint. In addition to my Microsoft certification, I also have an ITIL v3 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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.