Logon Report

[LithiumKid1976]

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?

[MikeMc · Accepted solution]

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