SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

Last logon User query

Remeber that I don't use the v_R_system views to determine the last logon user and here is why.

http://smsug.ca/blogs/garth_jones/archive/2007/03/22/224.aspx

http://smsug.ca/blogs/garth_jones/archive/2007/03/23/225.aspx

SELECT  GS.Name0,
 GS.UserName0,
 WS.LastHWScan,
 GS.Domain0,
 OS.Caption0,
 SYS.SystemRole0
FROM
 v_GS_COMPUTER_SYSTEM GS,
 v_GS_OPERATING_SYSTEM OS,
 v_GS_SYSTEM SYS,
 v_GS_WORKSTATION_STATUS WS
WHERE
 GS.ResourceID = SYS.ResourceID
 AND WS.ResourceID = GS.ResourceID
 AND OS.ResourceID = GS.ResourceID
 AND SYS.SystemRole0<>'Server'
 AND Datediff(dd,WS.LastHWScan,getdate()) > -1
 AND (GS.Domain0 = 'gartek.tst'
 OR GS.Domain0 = 'Doghouse')

Published Jun 30 2007, 07:56 AM by Garth
Filed under: , , ,

Comments

 

Garth Jones said:

It has been a while since I did my top 25 post. There are some interesting results.
&amp;nbsp;



...
September 6, 2007 8:04 AM
 

Garth Jones said:










&amp;nbsp;&amp;nbsp;




















 Total
 
 Title...
December 30, 2007 2:06 PM
 

Report for computers in site with last logged on user | keyongtech said:

Pingback from  Report for computers in site with last logged on user | keyongtech

January 21, 2009 11:20 PM

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems