→ 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: 
mde
Engaged Sweeper

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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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.