
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-07-2008 10:41 PM
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.
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.
Labels:
- Labels:
-
Archive
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-08-2008 01:07 AM
Thanks. We finally found it using Management Studio Express...

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-07-2008 10:52 PM
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
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
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
