Skip to content

Last Logged User

Featured Replies

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. 

  • 2 years later...
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.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.