Report for last 90 days

[warlock1663]

Hi everyone,

I would like to get Lansweeper data that shows everything on the network in the last 90 days. Also, can this be exported to a CSV file? I know this seems like something that would be straight forward to most of you but Im still fairly new with LS.


Thanks All'

Mike

[AZHockeyNut]

you could take the canned assets last scan times report and add a condition to the where clause
"tblassets.LastActiveScan >= (GetDate() - 90)"

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 tblAssetCustom.State = 1 and
tblassets.LastActiveScan >= (GetDate() - 90)
Order By tblAssets.AssetName Desc