→ 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: 
llondono20
Engaged Sweeper
Would like to be able to run a report of all the currently active PC's. I was trying to see if it would be able to ping them first or use the last seen column and report those that were last seen in the last 24 hours or so.
1 ACCEPTED SOLUTION
Nick_VDB
Champion Sweeper III
Lansweeper does not store a value in real time that will give back if an asset can be pinged. What is possible it to run a report such as the one below that will give back all your asset and to the click on the 'Ping Assets' option under the Report Options on the left of the report output. This option will then ping all the assets and give back if they are pingable or not.

As for the 'LastSeen' field, this will give back the date/time of the last successfull scan of the asset.

Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:
  • Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  • Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1

View solution in original post

1 REPLY 1
Nick_VDB
Champion Sweeper III
Lansweeper does not store a value in real time that will give back if an asset can be pinged. What is possible it to run a report such as the one below that will give back all your asset and to the click on the 'Ping Assets' option under the Report Options on the left of the report output. This option will then ping all the assets and give back if they are pingable or not.

As for the 'LastSeen' field, this will give back the date/time of the last successfull scan of the asset.

Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:
  • Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  • Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1