Report to find last logon details of each computer using ConfigMgr 2007

image 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

Hope this helps,

Arnab Mitra | Configuration Manager Support Engineer