→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
etsmarines
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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]

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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]

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now