Community FAQ
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

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now