I don't know how good your sql knowledge is.
These reports are configured using these 2 views:
web30repRequirementsMinimum
web30repRequirementsRecommended
Let's take a look at web30repRequirementsMinimum
Code:SELECT TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description,
dbo.web30ProcessorCapacity.[total Proc Capacity] AS [Total Mhz], dbo.web30memory.Memory, dbo.tblComputersystem.Manufacturer,
dbo.tblComputersystem.Model, dbo.tblComputers.Lastseen
FROM dbo.tblComputers INNER JOIN
dbo.web30ProcessorCapacity ON dbo.tblComputers.Computername = dbo.web30ProcessorCapacity.Computername INNER JOIN
dbo.web30memory ON dbo.tblComputers.Computername = dbo.web30memory.Computer INNER JOIN
dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername INNER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE (dbo.web30ProcessorCapacity.[total Proc Capacity] < 1000) OR
(dbo.web30memory.Memory < 240)
ORDER BY dbo.tblComputers.Computername
Most important parameters are:
dbo.web30ProcessorCapacity.[total Proc Capacity] < 1000 Total Mhz lower than 1000
(dbo.web30memory.Memory < 240) or total memory below 240 MB
You can directly change this view using the sql management console or you can load a sqlscript in lsmanage.exe
sample script to change parameters to 1500 Mhz and 500 MB
Code:alter VIEW dbo.web30repRequirementsMinimum
AS
SELECT TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description,
dbo.web30ProcessorCapacity.[total Proc Capacity] AS [Total Mhz], dbo.web30memory.Memory, dbo.tblComputersystem.Manufacturer,
dbo.tblComputersystem.Model, dbo.tblComputers.Lastseen
FROM dbo.tblComputers INNER JOIN
dbo.web30ProcessorCapacity ON dbo.tblComputers.Computername = dbo.web30ProcessorCapacity.Computername INNER JOIN
dbo.web30memory ON dbo.tblComputers.Computername = dbo.web30memory.Computer INNER JOIN
dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername INNER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE (dbo.web30ProcessorCapacity.[total Proc Capacity] < 1500) OR
(dbo.web30memory.Memory < 500)
ORDER BY dbo.tblComputers.Computername
