Scanning Error Report

[chads]

Looking to make different reports for sites from the dashboard report Error: All Scanning errors that includes only a specific IP location so we can have these sent weekly to the sites.

[chads]

Thank you as always works like a charm

[Hemoco · Accepted solution]

Please use the following report. Change the green word with the name of the iplocation that you want to filter on.

Select Top 1000000 tsysIPLocations.IPLocation,
tblAssets.AssetName,
tblAssets.AssetID,
tblAssets.Domain,
'Not scanned' As OS,
tblErrors.CFGname,
tsysasseterrortypes.ErrorMsg As Type,
tblErrors.ErrorText As Message,
tblErrors.Lastchanged,
'notscanned.png' As icon
From tblAssets
Inner Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysasseterrortypes On tblErrors.ErrorType =
tsysasseterrortypes.Errortype
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tsysIPLocations.IPLocation = 'main' And tblAssetCustom.State = 1
And Coalesce(tblAssets.OScode, '') = ''
Order By tblErrors.Lastchanged Desc,
tblAssets.AssetName

To use the report above, do the following:
• Open the report builder under Reports/Create New Report.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.