List of users on Linux servers

[MrNico]

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!

[Mister_Nobody · Accepted solution]

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/%'