cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mydurian
Engaged Sweeper II
Hi.
I'm looking for the tables to pull up the relevant report.

AssetName LoginDomainUsername LastLoginDateTime LastAssetScanned


Kindly please advise.

Thank you.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please use the following report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssets.Userdomain,
tblCPlogoninfo.logontime,
tblAssets.Lastseen
From tblAssets
Inner Join tblCPlogoninfo On tblAssets.AssetID = tblCPlogoninfo.AssetID
Where tblCPlogoninfo.logontime In (Select Max(log.logontime)
From tblCPlogoninfo As log Where log.AssetID = tblAssets.AssetID)

To use the report above, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
Please use the following report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssets.Userdomain,
tblCPlogoninfo.logontime,
tblAssets.Lastseen
From tblAssets
Inner Join tblCPlogoninfo On tblAssets.AssetID = tblCPlogoninfo.AssetID
Where tblCPlogoninfo.logontime In (Select Max(log.logontime)
From tblCPlogoninfo As log Where log.AssetID = tblAssets.AssetID)

To use the report above, do the following:
•Open the report builder under Reports/Create New Report.
•Paste the SQL code we provided at the bottom of the page.
•Left-click somewhere in the upper section of the page so the code applies.
•Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now