→ 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: 
Trin
Engaged Sweeper II
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.
1 ACCEPTED SOLUTION
Nick_VDB
Champion Sweeper III
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

View solution in original post

2 REPLIES 2
Trin
Engaged Sweeper II
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
Champion Sweeper III
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