Reporting # of & type of CPUs in each machine?

Hello. I'm trying to generate a report of the number and type of CPUs in all the machines in our domain. I am able to see this information for individual machines (Right click, Properties, then System Tab, at the top there is CPU information.). Is there a way to have Hyena export this? I've generated Hard Drive space reports in the past, and Hyena did a great job - just wondering if I'm doing something wrong.

Thanks in advance!

[cmccullough]

Re: Reporting # of & type of CPUs in each machine?

This can't be done at this time. We have plans for updated exporting/reporting functions targeted for the 5.1 release of Hyena.

Re: Reporting # of & type of CPUs in each machine?

Wow thanks for the quick response! This board is great.

Re: Reporting # of & type of CPUs in each machine?

Hi

It is possible to generate report, namely how there is of CPU in our waiters(servers) with Hyena 5.7c now.

Thanks

Re: Reporting # of & type of CPUs in each machine?

Hi

It is possible to generate report, namely how there is of CPU in our waiters(servers) with Hyena 5.7c now.

Thanks

Re: Reporting # of & type of CPUs in each machine?

Im looking into 5.7c version to gather CPU speed,model and RAM for whole domain.
Could you please provide me step by step how to do this?

[cmccullough]

Re: Reporting # of & type of CPUs in each machine?

You would have to create some sort of a scripting solution to do this as the Exporter doesn't export this information.

[kstanush]

Re: Reporting # of & type of CPUs in each machine?

You can get most of this information in the registry and use Exporter Pro (part of Hyena v5.7) to export it. You would use the Registry export options in Exporter Pro.

The registry key that has this information is HKEY_LOCAL_MACHINE\Hardware\Description\System\Cen tralProcessor; there are several keys here of interest. Exporter Pro has a template-based registry exporting system so a query can be easily created to do this. The sample "System Configuration" template would be a good example and starting point on how to create this query.

Re: Reporting # of & type of CPUs in each machine?

Below is a script that will give you what you need and a bit more.

Just change the computer name from "sqlserv1" to whatever server you want to run it against.

Then save the script below as a text file and call it processors.vbs . When you run the file it will open a command window with the details you need.

This can also be tweaked to use it as a tool within Hyena to run against seleted computers

Hope it helps

Neil


strComputer = "Sqlserv1"
Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\" & strComputer & "\root\cimv2")
Set colSettings = objWMIService.ExecQuery _
("Select * from Win32_OperatingSystem")
For Each objOperatingSystem in colSettings
Wscript.Echo "OS Name: " & objOperatingSystem.Name
Wscript.Echo "Version: " & objOperatingSystem.Version
Wscript.Echo "Service Pack: " & _
objOperatingSystem.ServicePackMajorVersion _
& "." & objOperatingSystem.ServicePackMinorVersion
Wscript.Echo "OS Manufacturer: " & objOperatingSystem.Manufacturer
Wscript.Echo "Windows Directory: " & _
objOperatingSystem.WindowsDirectory
Wscript.Echo "Locale: " & objOperatingSystem.Locale
Wscript.Echo "Available Physical Memory: " & _
objOperatingSystem.FreePhysicalMemory
Wscript.Echo "Total Virtual Memory: " & _
objOperatingSystem.TotalVirtualMemorySize
Wscript.Echo "Available Virtual Memory: " & _
objOperatingSystem.FreeVirtualMemory
Wscript.Echo "OS Name: " & objOperatingSystem.SizeStoredInPagingFiles
Next
Set colSettings = objWMIService.ExecQuery _
("Select * from Win32_ComputerSystem")
For Each objComputer in colSettings
Wscript.Echo "System Name: " & objComputer.Name
Wscript.Echo "System Manufacturer: " & objComputer.Manufacturer
Wscript.Echo "System Model: " & objComputer.Model
Wscript.Echo "Time Zone: " & objComputer.CurrentTimeZone
Wscript.Echo "Total Physical Memory: " & _
objComputer.TotalPhysicalMemory
Next
Set colSettings = objWMIService.ExecQuery _
("Select * from Win32_Processor")
For Each objProcessor in colSettings
Wscript.Echo "System Type: " & objProcessor.Architecture
Wscript.Echo "CurrentClockSpeed: " & objProcessor.CurrentClockSpeed
Wscript.Echo "Processor: " & objProcessor.Description
Next
Set colSettings = objWMIService.ExecQuery _
("Select * from Win32_BIOS")
For Each objBIOS in colSettings
Wscript.Echo "BIOS Version: " & objBIOS.Version
Next

Re: Reporting # of & type of CPUs in each machine?

Thanks a lot !

regards
Neme

Re: Reporting # of & type of CPUs in each machine?

What would I need to change or do to run this against a range of computers?


<div class="ubbcode-block"><div class="ubbcode-header">Quote:</div><div class="ubbcode-body">Originally posted by NeilTurland:
<span style="font-weight: bold">Below is a script that will give you what you need and a bit more.

Just change the computer name from "sqlserv1" to whatever server you want to run it against.

Then save the script below as a text file and call it processors.vbs . When you run the file it will open a command window with the details you need.

This can also be tweaked to use it as a tool within Hyena to run against seleted computers

Hope it helps

Neil


strComputer = "Sqlserv1"
Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\" & strComputer & "\root\cimv2")
Set colSettings = objWMIService.ExecQuery _
("Select * from Win32_OperatingSystem")
For Each objOperatingSystem in colSettings
Wscript.Echo "OS Name: " & objOperatingSystem.Name
Wscript.Echo "Version: " & objOperatingSystem.Version
Wscript.Echo "Service Pack: " & _
objOperatingSystem.ServicePackMajorVersion _
& "." & objOperatingSystem.ServicePackMinorVersion
Wscript.Echo "OS Manufacturer: " & objOperatingSystem.Manufacturer
Wscript.Echo "Windows Directory: " & _
objOperatingSystem.WindowsDirectory
Wscript.Echo "Locale: " & objOperatingSystem.Locale
Wscript.Echo "Available Physical Memory: " & _
objOperatingSystem.FreePhysicalMemory
Wscript.Echo "Total Virtual Memory: " & _
objOperatingSystem.TotalVirtualMemorySize
Wscript.Echo "Available Virtual Memory: " & _
objOperatingSystem.FreeVirtualMemory
Wscript.Echo "OS Name: " & objOperatingSystem.SizeStoredInPagingFiles
Next
Set colSettings = objWMIService.ExecQuery _
("Select * from Win32_ComputerSystem")
For Each objComputer in colSettings
Wscript.Echo "System Name: " & objComputer.Name
Wscript.Echo "System Manufacturer: " & objComputer.Manufacturer
Wscript.Echo "System Model: " & objComputer.Model
Wscript.Echo "Time Zone: " & objComputer.CurrentTimeZone
Wscript.Echo "Total Physical Memory: " & _
objComputer.TotalPhysicalMemory
Next
Set colSettings = objWMIService.ExecQuery _
("Select * from Win32_Processor")
For Each objProcessor in colSettings
Wscript.Echo "System Type: " & objProcessor.Architecture
Wscript.Echo "CurrentClockSpeed: " & objProcessor.CurrentClockSpeed
Wscript.Echo "Processor: " & objProcessor.Description
Next
Set colSettings = objWMIService.ExecQuery _
("Select * from Win32_BIOS")
For Each objBIOS in colSettings
Wscript.Echo "BIOS Version: " & objBIOS.Version
Next</span></div></div>

Re: Reporting # of & type of CPUs in each machine?

Sorry but my scripting skills are limited.

I can let you know how to set this up as a tool to run against all selected computers, but the results will be in separate windows and not in a nice list. If you need help with using this as a tool, let me know.

Does anyone else out there know the code needed to consolidate the results?