→ 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: 
SimplyClueless
Engaged Sweeper III
Hello all,

Forgive my obvious ignorance but I am very new to this product and I have what I hope is a very easy goal-

I would like to write a basic report that scans all of my desktop and laptop PC's-and simply spit out a an excel or csv report with computer name, location, and serial number, is this something this forum could give some guidance with? thanks and sorry if this has been covered
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Use the report below to list the information you are after. Note that reports only pull information from the database; they don't "scan" anything. You need to ensure that your machines have been successfully scanned prior to running the report we provided.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssetCustom.Location As CustomLocation,
tblADComputers.Location As ADlocation,
tsysIPLocations.IPLocation,
tblAssetCustom.Serialnumber,
tblAssets.Firstseen,
tblAssets.Lastseen,
tsysOS.Image As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName

To use the specified report, do the following:
• Browse to the Dashboard\Reports\Report Builder section of the web console.
• 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.
• The report will now also be listed under Dashboard\Reports\All Reports.

View solution in original post

2 REPLIES 2
SimplyClueless
Engaged Sweeper III
This is most helpful thank you- and yes Scan was not the right word- I may have some more questions in the future
Hemoco
Lansweeper Alumni
Use the report below to list the information you are after. Note that reports only pull information from the database; they don't "scan" anything. You need to ensure that your machines have been successfully scanned prior to running the report we provided.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssetCustom.Location As CustomLocation,
tblADComputers.Location As ADlocation,
tsysIPLocations.IPLocation,
tblAssetCustom.Serialnumber,
tblAssets.Firstseen,
tblAssets.Lastseen,
tsysOS.Image As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName

To use the specified report, do the following:
• Browse to the Dashboard\Reports\Report Builder section of the web console.
• 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.
• The report will now also be listed under Dashboard\Reports\All Reports.