‎04-07-2008 10:41 PM
‎04-08-2008 01:07 AM
‎04-07-2008 10:52 PM
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
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now