Report Help

[Srikanth08]

Hi,

I need query for the following report
Asset Name
UserName
IP Address
Display name
Last Seen

[Hemoco]

Can you please try the following:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssets.IPAddress,
tblADusers.Displayname,
tblAssets.Lastseen
From tblAssets
Left Join tblADusers On tblAssets.Username = tblADusers.Username And
tblAssets.Userdomain = tblADusers.Userdomain

[Srikanth08]

Hi,

Thanks for the report. But when i tried it i showing only 2875 assets, but my actual scanned assets are 3075. where is remaining one.i want full list

[Hemoco]

Please use the following report:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssets.IPAddress,
tblADusers.Displayname,
tblAssets.Lastseen
From tblAssets
Inner Join tblADusers On tblAssets.Username = tblADusers.Username And
tblAssets.Userdomain = tblADusers.Userdomain

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.