Run a report to see currently active PC's

[llondono20]

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.

[Nick_VDB · Accepted solution]

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