Report: I need a report which shows all machines, the Last Logged on user and Date.

[narangricky22]

Hi,

I have an urgent requirement to pull out information for all machines including the Last Logged on User Name and the Date. I have been through lots of online reports which are available but none of them worked for me.

 

I even saw a MS Blogpost

http://social.technet.mic...ng-configmgr-2007.aspx

 

However, this report is urgent, so I cannot wait for all the machines to start responding back. The Hardware Inventory schedule that we have set is for every 3 days.

 

 

 

I would appreciate if someone could please help me with this.

 

 

Thanks

Ricky

[Eswar Koneti]

There are many forums which gives this information i guess but here is you go with last logged on user with timestamp :

 

select  Name0,UserName0 as 'Top console user' ,TimeStamp from v_GS_COMPUTER_SYSTEM
order by name0