Announcement

Collapse
No announcement yet.

Reporting # of & type of CPUs in each machine?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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!

  • #2
    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.

    Comment


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

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

      Comment


      • #4
        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

        Comment


        • #5
          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

          Comment


          • #6
            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?

            Comment


            • #7
              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.

              Comment


              • #8
                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.
                Kevin Stanush
                SystemTools Software Inc.

                Comment


                • #9
                  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

                  Comment


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

                    Thanks a lot !

                    regards
                    Neme

                    Comment


                    • #11
                      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>

                      Comment


                      • #12
                        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?

                        Comment

                        Working...
                        X