Require a report of Scan Times and Failures

[Trin]

Hi,

I am trying to get a report of all our Windows Servers showing the OS, with Scan Time information, along with any Scanning errors.
I've been trying to 'merge' 2 of your in-built reports - 'All scanning errors' & 'Last scan times of Windows servers' but am not getting any results.

What I need in results is, Windows Servers and OS information, Lastseen, Lasttried, and Scanning Error information if any e.g. Type: Error, Ping failed...

Thank you for any advice on this please.

Trin.

[Trin]

Thank you for this. Much appreciated. The results do not seem to be showing scanning error reasons though.

Here's example of section of report results:

ServiceVersion |Error |Item | Message
---------------------------------------------------
6.0.0.22 |Mailing | | pcname.domain.com |
6.0.0.22 |IP range scanning | | pcname2.domain.com |
6.0.0.22 |Active scanning | | pcname3.domain.com |
6.0.0.22 |Mailing | | pcname4.domain.com |
6.0.0.22 |IP range scanning | | pcname5.domain.com |
6.0.0.22 |Mailing | | pcname6.domain.com |
6.0.0.22 |Active scanning | | pcname7.domain.com |
6.0.0.22 |Mailing | | pcname8.domain.com |

Kind regards,
Catherine.

[Nick_VDB · Accepted solution]

We added a report below that give the scan time information and scanning errors. You can follow the information found here to add the report to Lansweeper.

Select Top 1000000 tblAssets.AssetID,
  tsysOS.Image As icon,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tblAssets.IPAddress,
  tblOperatingsystem.Caption As OS,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssets.Lasttriggered,
  tblAssets.LastScheduled,
  tblAssets.LastActiveScan,
  tblAssets.LastIPScan,
  tblAssets.LastLsPush,
  tblAssets.LastSaved,
  tblAssets.Scanserver,
  tblAssets.ServiceVersion,
  tsyserrortype.Errorname As Error,
  tblErrors.CFGname As Item,
  tblErrors.ErrorText As Message
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Left Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
  Inner Join tsyserrortype On tblErrors.ErrorType = tsyserrortype.ErrorType
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  Error