This query will show you how to find all of the machines in your SMS site that have a 400 MHZ or less processor speed. You can also easily modify the query by changing the < 400 for the 400MHZ to something like is greater (>) than 166 etc.
SQL Query:
Select Distinct
ComputerSystem.Name0 'Machine Name',
ProcessorData.CurrentClockSpeed0 'Processor Speed'
From
Computer_System_DATA ComputerSystem,
Processor_Data ProcessorData
Where
ProcessorData.CurrentClockSpeed0 < 400
Hi Don,
i tried to create report using your query and i get an error:
An error occurred when the report was run. The details are as follows:
The SELECT permission was denied on the object 'Processor_DATA', database 'SMS_C00', schema 'dbo'.
Error Number: -2147217911
Source: Microsoft OLE DB Provider for SQL Server
Native Error: 229
Do you have any idea why i am getting this error. Any other report is running fine
thx,
emp
NM i got it - silly me answer was right in front of me but i though there is something wrong with the query. sorry
thx again
Glad you figured it out!
For those that may have similar issues here is the fix he is speaking of:
myitforum.com/.../granting-sms-web-reports-users-access-to-new-or-existing-views-using-sql-scripts.aspx