Getting the computer serial number and more
Recently we've received a number of support cases where customers wanted to get the serial numbers of the computers in Active Directory (AD). While AD does not store this type of information, the serial number and other useful information can usually be retrieved using the WMI class 'Win32_SystemEnclosure'.
Note: WMI is a Hyena Enterprise-only feature. To check the license type, select Tools > Settings > Licensing and verify under the licensing options if WMI Integration is set to 'licensed'. To upgrade from a Standard Edition license, contact firstname.lastname@example.org.
First, to verify that WMI works in your environment, find a typical computer in Hyena's left window, expand it, then expand the WMI node. See if there is an existing query class for "Win32_SystemEnclosure". If you don't find one, right click on the main WMI node, select 'Execute Query...", click the 'New' button, then enter the following:
WMI Query Name - System Enclosure
WMI Namespace - (leave blank)
WMI Class - Win32_SystemEnclosure
Click OK to add the class, then choose the Properties you want to view. Make sure you include the '__SERVER', SerialNumber, Manufacturer, ChassisTypes, and any other properties of interest. You can always add all of the properties to see what is returned and then remove unneeded properties later.
Then click 'Execute Query'.
To execute a WMI query on multiple computers, simply multi-select them in Hyena's right window, select WMI > Execute Query... and select your query to execute. If lengthy delays or errors are returned, try turning on the Ping options under Tools > Settings > View > Ping Options to skip offline computers, or to suppress error messages, select Tools > Settings > Logging and change the error suppression option for the 'WMI - Run Query' setting.
Another useful property in this class is 'ChassisTypes', which can show whether the computer is a tower, laptop, etc.
For more information on the Win32_SystemEnclosure class, click here.
Filtering the right window results
Hyena's Filtering function makes quick work of finding and filtering the right window results from any AD query or system display.
The Filter function can only be accessed by clicking the filter button on the toolbar (shown at left). For example, if the Services for a computer are displayed, clicking the Filter toolbar button will insert a row of 'filtering cells' under the right window column headers. Entering a text value such as "event" in the 'Display Name' column and pressing Enter will filter the results to only those rows where the word 'event' appears in the display name. The filtering is not case sensitive and has a number of options. For a full list of available options using wildcards, exact matching, finding blank values, and more see the "Filtering Data" topic in Hyena's help file under "Using Hyena - Functions > Filtering Data".
While we've mentioned Filtering in our tips before, what's new is that we addressed a limitation recently that now allows the filtering cell to accept a paste (Control-V) operation. This is most useful when trying to retrieve Active Directory or other information where the data to search for comes from an email or external source, and a cut-and-paste operation can be used to save some typing.