Last Logged User

[AmrelMahdy]

Dears,

Am having a collection with certain computers

there is a way so i can get the users who logged on those computers ???

regards,

[Rocket Man]

Just right click on system and edit primary users of the system it should show you the users that operate the PC...

[AmrelMahdy]

OK I need to do that in the form of a report , the collection have more than 200 PC

[GarthMJ]

Remember that CM07/CM12 is not a real time product and there is it will be best effort only. And the result of the report will vary based on how to have you Hardware and Heartbeat discovery setup.

 

Try this: http://smsug.ca/blogs/garth_jones/archive/2012/12/07/last-logon-user.aspx

[AmrelMahdy]

But i See there is a report named "Computers for users in a specific domain" and that report generated for the whole users in the domain , so why they dont make a report "Compters for users in specific collection" ???

[GarthMJ]

MS could make a 1 million reports and still there would be reports missing. That is why you have the option to create the report that you want.

[AmrelMahdy]

Yeah u r Right ,, anyway thanks for your quick responses , I really like your forums )))

[AmrelMahdy]

Hey,

I found a way to get the needed report "know users logged on a computers in a specifig collection"

Asset Intelligence > Hardware 01A - Summary of computers in a specific collection

[seamorob]

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

[Dom]

Hello,

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

Any setting to enable to get this information?

Thanks,
Dom