User: Logontime on Machine

[mde]

Hello

I am trying to create a new report which gets every logon on every machine.

Now i've put an SQL string together with those infomation:

Select Top 1000000 tblAssets.AssetID,
tblCPlogoninfo.logontime,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Username,
tblADusers.Displayname
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblCPlogoninfo On tblAssets.AssetID = tblCPlogoninfo.AssetID
Inner Join tblADusers On tblADusers.Username = tblAssets.Username
Where tblAssetCustom.State = 1
Order By tblCPlogoninfo.logontime Desc

Now the logons over Citrix aren't displayed in the report.

has anybody a suggestion what the problem could be?

thanks and kind regards

[Hemoco · Accepted solution]

Lansweeper by default only scans logon events of users logged into the console. We recommend deploying our LsPush scanning agent in a logon script, so that each user logon is written into the database. (Lansweeper logs an event when a user is found to be logged onto a computer during a scan.) More info on this scanning method can be found on page 73 and beyond of our online documentation: http://www.lansweeper.com/documentation.pdf

Also note that tblADusers is incorrectly linked in your report. You need to link this table to tblAssets on *both* the Username and Userdomain fields.