I created a custom SCCM report that has the following inforation:
- 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