Would anyone please be able to help me with a report that gives me all the computers with there last logged on user and the last logged on time?
I am currently using this but it does not tell me the last logged on time..
SELECT distinct sys.Netbios_Name0ComputerName, sys.user_name0,ipsub.IP_Subnets0, ip.defaultIPGateway0, sys.AD_site_name0 ADSitefrom v_R_system sys inner join v_GS_Network_Adapter_Configur IP on sys.ResourceID=IP.ResourceID inner join v_RA_System_IPSubnets ipsub on sys.ResourceID=ipsub.ResourceIDwhere sys.resource_domain_or_workgr0 ='AUASCARLSON'and sys.obsolete0=0and ip.defaultIPGateway0 isnot NULL and ipsub.IP_Subnets0 isnot NULL;
It is not that important that the last logged on user be extremely up to date as this is to find machines where someone has left and a new user has the laptop so they most likely have been using it for a month or so..
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
Would anyone please be able to help me with a report that gives me all the computers with there last logged on user and the last logged on time?
I am currently using this but it does not tell me the last logged on time..
It is not that important that the last logged on user be extremely up to date as this is to find machines where someone has left and a new user has the laptop so they most likely have been using it for a month or so..
Share this post
Link to post
Share on other sites