‎11-24-2022 05:06 PM
We have computers reporting in using lspush, I'd also like to perform a daily active scan, is there a way to report on the last time a computer had an active scan? I found reference to tblAssets.LastActiveScan and I can save this in a report but it's blank for all assets.
Thanks
‎11-25-2022 04:47 PM
Hi Wes,
I use this report which shows me all possible scans (for my configuration) and the last time it was executed.
Maybe it can help you further.
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
Order By tblAssets.AssetName Desc
‎11-30-2022 04:55 PM
Thank you I've tried the report and LastActiveScan is empty for all assets, I've checked the Lansweeper environment I'm migrating away from (rebuilt from scratch) and that has data which correlates to the last AD domain scan or IP range scan but I'm not using these options in the new setup.
A manual scan also doesn't populate this data so I'm wondering if my approach to minimise scanned items and building up what we require as and when is somehow excluding this data from being gathered.
‎11-30-2022 07:59 PM
Here's Hendrik_VE's report but with LSAgent scan info on it - I'm in competition with him currently, so I had to add that 🙂 if last active scan is blank, it means active scanning is not enabled (or has ever been enabled since the assets where created) or it's broken - maybe it can't authenticate to the domain controller...
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,
tblAssets.LastLsAgent As [Last LsAgent Scan],
tblLsAgentGroup.Name As [LsAgent Group],
tblAssets.LsAgentVersion
From tblAssets
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tblLsAgentAsset On tblLsAgentAsset.AssetID = tblAssets.AssetID
Left Join tblLsAgentGroup On tblLsAgentGroup.LsAgentGroupID =
tblLsAgentAsset.LsAgentGroupID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName Desc
If last active scan is not populated, then (if its not broken for some reason) active scanning is not enabled nor has ever been enabled.... if its broken, it could be that LS can't authenticate to the domain or domain controller to find out which computer objects have authenticated lately, for it to scan... but I'm not sure on that one.
That report just showed me that lsAgent ignores scanning interval for active scanning - which is problematic for an installation I am working on for a company - I'll put in a new post on that!
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now