cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
shivendu_pandey
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

6 REPLIES 6
Mercedes_O
Community Manager
Community Manager

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
Engaged Sweeper
Thanks
Hemoco
Lansweeper Alumni
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
Engaged Sweeper III

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
Engaged Sweeper
"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
Lansweeper Alumni
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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now