→ 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: 
DriesBeweging
Engaged Sweeper II
On the lansweeper dashboard there is a widget that shows the last seen users, but I couldn't find a report for this.

We would like to clean up our AD a bit and would want to create a report to find users not seen in X days, much like the widget on the dashboard.

Could anyone point me in the right direction to make a report for this?
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
The following report lists you AD users which were not detected to be logged on to any computer in the last 60 days.

Note: Lansweeper creates an entry in tblCPlogoninfo if during scanning a user is logged on to a computer. If a user has logged on and off while the computer wasn't scanned, Lansweeper will not generate a logon event. In order to make this report reliable, we recommend creating a scheduled task on your client computers which executes LsPush.exe after logon and immediately scans the computer.


Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain
From tblADusers
Where tblADusers.Username Not In (Select tblCPlogoninfo.Username
From tblCPlogoninfo Where tblCPlogoninfo.logontime > GetDate() - 60)
Order By tblADusers.Username

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
The following report lists you AD users which were not detected to be logged on to any computer in the last 60 days.

Note: Lansweeper creates an entry in tblCPlogoninfo if during scanning a user is logged on to a computer. If a user has logged on and off while the computer wasn't scanned, Lansweeper will not generate a logon event. In order to make this report reliable, we recommend creating a scheduled task on your client computers which executes LsPush.exe after logon and immediately scans the computer.


Select Top 1000000 tblADusers.Username,
tblADusers.Userdomain
From tblADusers
Where tblADusers.Username Not In (Select tblCPlogoninfo.Username
From tblCPlogoninfo Where tblCPlogoninfo.logontime > GetDate() - 60)
Order By tblADusers.Username

New to Lansweeper?

Try Lansweeper For Free

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

Try Now