cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ESIT
Engaged Sweeper
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!
2 REPLIES 2
Hemoco
Lansweeper Alumni
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
Engaged Sweeper
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!