Restore an Edited Report?

[ESIT]

Hi all,

We edited the All Servers report by accident and I was wondering is there a way to restore it back to its default? Can I re-install the Premium Pack to fix there, or is there any other way to recover this?

Thanks!

[Hemoco]

This is the original code

SELECT     dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblComputersystem.Domainrole, dbo.tblComputersystem.Lastchanged
FROM         dbo.tblComputersystem INNER JOIN
                      dbo.tblComputers ON dbo.tblComputersystem.Computername = dbo.tblComputers.Computername
WHERE     (dbo.tblComputersystem.Domainrole > '1')

[ESIT]

Lansweeper wrote:
This is the original code

SELECT     dbo.tblComputers.Computername, dbo.tblComputers.Domain, dbo.tblComputersystem.Domainrole, dbo.tblComputersystem.Lastchanged
FROM         dbo.tblComputersystem INNER JOIN
                      dbo.tblComputers ON dbo.tblComputersystem.Computername = dbo.tblComputers.Computername
WHERE     (dbo.tblComputersystem.Domainrole > '1')

Thank You, this appears to have worked. Based off this code:

SELECT
dbo.tblComputers.Computername,
dbo.tblComputers.Domain,
dbo.tblComputersystem.Domainrole,
dbo.tblComputersystem.Lastchanged
FROM
dbo.tblComputersystem
INNER JOIN dbo.tblComputers ON (dbo.tblComputersystem.Computername = dbo.tblComputers.Computername)
WHERE
dbo.tblComputersystem.Domainrole > '1'

Could you help modify it so that it includes Max CPU?

Thanks!