→ 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: 
warlock1663
Engaged Sweeper
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
1 REPLY 1
AZHockeyNut
Champion Sweeper III
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