cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Wes
Engaged Sweeper

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

3 REPLIES 3
Hendrik_VE
Champion Sweeper III

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

  

Wes
Engaged Sweeper

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.

rom
Champion Sweeper III

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!