→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
LithiumKid1976
Champion Sweeper
hi
Is it possible to get a report of logons with in the last 24 hours?

i would like to see the user that logged on, the PC they logged on to, and the time.

is that possible?
1 ACCEPTED SOLUTION
MikeMc
Champion Sweeper II
This report should get you started.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblCPlogoninfo.Ipaddress,
tblCPlogoninfo.Domain As Userdomain,
tblCPlogoninfo.Username,
tblCPlogoninfo.logontime
From tblCPlogoninfo
Inner Join tblAssets On tblAssets.AssetID = tblCPlogoninfo.AssetID
Where tblCPlogoninfo.logontime >= DateAdd(hh, -24, GetDate())
Order By tblCPlogoninfo.logontime

View solution in original post

1 REPLY 1
MikeMc
Champion Sweeper II
This report should get you started.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblCPlogoninfo.Ipaddress,
tblCPlogoninfo.Domain As Userdomain,
tblCPlogoninfo.Username,
tblCPlogoninfo.logontime
From tblCPlogoninfo
Inner Join tblAssets On tblAssets.AssetID = tblCPlogoninfo.AssetID
Where tblCPlogoninfo.logontime >= DateAdd(hh, -24, GetDate())
Order By tblCPlogoninfo.logontime