cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
HighlandIT
Engaged Sweeper
Hello,
We are trying out the product and were wondering if there is a way to change the min/max values that the product is reporting as the pc systems meeting.
we did a quick search in the forum and one answer said it was doable but did not mention how.
any help would be great.
2 REPLIES 2
HighlandIT
Engaged Sweeper
Thanks. We finally found it using Management Studio Express...
Hemoco
Lansweeper Alumni
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

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

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