 Rank: Administration Groups: Administration, Premium Users
Posts: 10,379
|
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. Quote: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
|
