Create a report that shows all user accounts on each server

[etsmarines]

How can i create a report in lansweeper that shows all the user accounts that are active on each server.

All windows servers
All Linux servers
All AIX servers

Thanks!

-Erik

[Daniel_B · Accepted solution]

User logons on Windows computers are only scanned if the user is logged on during scanning. If a user logs on and off while the computer isn't being scanned, Lansweeper won't get to know this. In order to make this report reliable we recommend scanning your computers with LsPush in a logon script.

On Linux/Unix and Mac computers, no list of logged on user accounts is being scanned.

The following report lists users who were scanned as logged onto servers running on Windows:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Lastseen,
  tUserLogons.Username As [Logged on user account]
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join (Select Distinct tblCPlogoninfo.AssetID,
    tblCPlogoninfo.Username
  From tblCPlogoninfo) tUserLogons On tUserLogons.AssetID = tblAssets.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssetCustom.State = 1 And tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName,
  [Logged on user account]