Lansweeper successfully scanned assets report

[shivendu_pandey]

Hi Team,

How to make a report that lists all windows assets that are successfully scanned for over a period of time, say a month ?

Thanks in advance

[Mercedes_O]

Hi @dlafleur  due to the age of this thread I recommend starting a new topic here in our Reports and Analytics forum instead https://community.lansweeper.com/t5/reports-analytics/bd-p/LansweeperReports

[shivendu_pandey]

Thanks

[Hemoco · Accepted solution]

You can filter in any report on the field tblAssets.Lastseen. E.g. the report below or you can create a dynamic report by filtering on tblAssets.Lastseen > getdate() - 30 to always filter on the assets successfully scanned in the past 30 days.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypename As [Asset Type],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Scanserver,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Lasttriggered,
tblAssets.LastScheduled,
tblAssets.LastActiveScan,
tblAssets.LastIPScan,
tblAssets.LastLsPush,
tblAssets.ServiceVersion,
tblAssets.LsPushVersion
From tblAssets
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssets.Lastseen >= '10 / 01 / 2013'
Order By tblAssets.AssetName Desc

[dlafleur]

Hello.  The report above is great and all, but to me, it does not reflect what was Successful!.  from what I see, all the options above are looking for last tried, last triggered, last seen, first seen, last scheduled, etc.  Nothing for "Last Successful Scan" which is what I am looking for.  How do I find that expression to add to the report?

[shivendu_pandey]

"for over a period of time" means suppose i want to make a report for october month about how many windows assets have been successfully scanned till date in this month.

[Hemoco]

Could you clarify what you mean by "for over a period of time". The Lastseen field of the tblAssets table stores the date/time of the last successful scan, so you need to build a report based on this information.