Last Logged User

[GarthMJ]

20 hours ago, Dom said:

I checked the view v_GS_NETWORK_LOGIN_PROFILE and it is empty!!!

Any setting to enable to get this information?

 

 

This WMI class is not enabled by default within hardware inventory. You would enable it as you would any other class. 

[Imraz]

On 3/1/2013 at 3:07 AM, seamorob said:

GarthMJ's report gives a nice list of machines and their last logon user.

Here is one that will give the machine, all logged on users, and when they logged on.

 

Select

V_GS_SYSTEM.Name0 as [ComputerName],

V_GS_NETWORK_LOGIN_PROFILE.LastLogon0 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

AND

V_GS_SYSTEM.SystemRole0='Workstation'

Order by V_GS_SYSTEM.Name0

is this WQL or SQL? where do you apply this code?

Thanks again.

[GarthMJ]

it is a SQL query.