Dash board report "Computer scanning errors"

[john_e_wagner]

I would like to customize the Dash board report "Computer scanning errors." It is more inclusive than WMI scanning errors. What is the base report or sql for this report? I would like to add the ip to this report, or make a custom report with this field included.
JW

[john_e_wagner]

Thank you, that worked nicely.

[Hemoco · Accepted solution]

Are you referring to the "Computer scanning errors" page linked in the web console under "Reporting"? You cannot easily change how this webpage behaves.

If you want to add to the information on this page, you will have to create a new, separate report. Use the SQL code below as a base.

Select Top 1000000 tblerrors.Computername, tblComputers.Computer,
tblComputers.Domain, tblComputers.LastknownIP, tblerrors.CFGname,
tblerrors.ErrorText, Max(tblerrors.Lastchanged) As [Last changed]
From tblerrors Inner Join
tblComputers On tblerrors.Computername = tblComputers.Computername Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Left Outer Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername
Where tblOperatingsystem.Computername Is Null
Group By tblerrors.Computername, tblComputers.Computer, tblComputers.Domain,
tblComputers.LastknownIP, tblerrors.CFGname, tblerrors.ErrorText
Order By Max(tblerrors.Lastchanged) Desc