SQL Query : Active Clients with last logged on user / domain / OS (not server)

October 9, 2017October 9, 2017 JonMoss

SELECT [Name0]
     ,[Active0]
     ,[Client0]
     ,[Client_Version0]
     ,[User_Domain0]
     ,[User_Name0]
     ,[lastLogon0]
     ,[operatingSystem0]
 FROM [osdp232a].[dbo].[v_R_System]
 where operatingSystem0 not like '%server%'
     and Client0 = '1'
     and Active0 = '1'
 order by Name0

Sample OUTPUT

Leave a Comment Cancel reply