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

Leave a Comment

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

Scroll to Top