I get asked about this every once in a while so I thought I would post it here in case it’s something you might find helpful as well. This report will contain the last login time on a particular computer along with the user who logged in to it as well as some additional details.
To create the report follow the steps below:
1. Edit the SMS_DEF.mof file to enable the following class:
Network Login Profile
Also enable the sub class:
LastLogon
2. Create a report with the below query:
Select
V_GS_SYSTEM.Name0 as [ComputerName],
V_GS_NETWORK_LOGIN_PROFILE.TimeStamp as [Last Login Time],
V_GS_NETWORK_LOGIN_PROFILE.Name0 as [Logon User],
V_GS_SYSTEM.Domain0 as [Logon Domain],
V_GS_SYSTEM.SystemRole0 as [System Role],
V_GS_SYSTEM.SystemType0 as [System Type]
from V_GS_NETWORK_LOGIN_PROFILE
left JOIN v_GS_SYSTEM ON V_GS_NETWORK_LOGIN_PROFILE.ResourceID =
v_GS_SYSTEM.ResourceID
where V_GS_NETWORK_LOGIN_PROFILE.LastLogon0 is not NULL
Note: This information was originally contributed by Arnab Mitra, Configuration Manager Support Engineer, on the Configuration Manager Support Team blog: