cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MrNico
Engaged Sweeper II

Hello, I need to obtain a list of the users of each Linux server, there is a report that does exactly that, but with Windows. How can I get this list?

Thank you!

1 ACCEPTED SOLUTION
Mister_Nobody
Honored Sweeper II

I use such query

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblLinuxSystem.OSRelease,
  tblassets.IPAddress,
  tblassets.Lastseen,
  tblassets.Lasttried,
  tblLinuxUser.UserName,
  tblLinuxUser.Type,
  tblLinuxUser.Comment,
  tblLinuxUser.HomeDirectory,
  tblLinuxUser.LastChanged,
  tblLinuxUserLogon.Port,
  tblLinuxUserLogon.IpAddress As IpAddress1,
  tblLinuxUserLogon.LogonTime
From tblassets
  Inner Join tblLinuxUser On tblassets.AssetID = tblLinuxUser.AssetId
  Inner Join tblLinuxSystem On tblassets.AssetID = tblLinuxSystem.AssetID
  Left Join tblLinuxUserLogon On tblLinuxUser.Id = tblLinuxUserLogon.Id
Where tblLinuxUser.HomeDirectory Like '/home/%' 

View solution in original post

1 REPLY 1
Mister_Nobody
Honored Sweeper II

I use such query

Select Top 1000000 tblassets.AssetID,
  tblassets.AssetName,
  tblLinuxSystem.OSRelease,
  tblassets.IPAddress,
  tblassets.Lastseen,
  tblassets.Lasttried,
  tblLinuxUser.UserName,
  tblLinuxUser.Type,
  tblLinuxUser.Comment,
  tblLinuxUser.HomeDirectory,
  tblLinuxUser.LastChanged,
  tblLinuxUserLogon.Port,
  tblLinuxUserLogon.IpAddress As IpAddress1,
  tblLinuxUserLogon.LogonTime
From tblassets
  Inner Join tblLinuxUser On tblassets.AssetID = tblLinuxUser.AssetId
  Inner Join tblLinuxSystem On tblassets.AssetID = tblLinuxSystem.AssetID
  Left Join tblLinuxUserLogon On tblLinuxUser.Id = tblLinuxUserLogon.Id
Where tblLinuxUser.HomeDirectory Like '/home/%'