Creating New Queries

[Guest]

I've been doing a lot of digging to no avail on how to create new queries within Hyena.

Here's my issue - I want to be able to query the Service Tag (serial number) off of my systems along with the system name.

Hyena out of the box does not have this as part of the Exporter Pro set of queries.

I have found another tool which can do this query but on only 1 box at a time ... not to interested in spending the next couple of months doing it that way ...

So my question is this - where can I find documentation that walks someone through the process of creating a new query when they know the WMI that will do it?

Thanks ...

[cmccullough]

Re: Creating New Queries

What WMI class has the info you are looking for?

[Guest]

Re: Creating New Queries

<div class="ubbcode-block"><div class="ubbcode-header">Quote:</div><div class="ubbcode-body">Originally posted by cmccullough:
<span style="font-weight: bold">What WMI class has the info you are looking for?</span></div></div>

Win32_SystemBIOS.PartComponent and within there is SerialNumber, _SERVER & Manufacture.

[cmccullough]

Re: Creating New Queries

You'll have to export the Win32_SystemBIOS class, then parse PartComponent separately from the output using something like Excel or Access.

To add this you'll right-click on a computer or selection of computers and choose WMI->Execute Query. Click the New button and enter in Win32_SystemBIOS for both the WMI Query Name and the WMI Class and click OK. Add the fields you want to see, then click Execute.

[Guest]

Re: Creating New Queries

<div class="ubbcode-block"><div class="ubbcode-header">Quote:</div><div class="ubbcode-body">Originally posted by cmccullough:
<span style="font-weight: bold">You'll have to export the Win32_SystemBIOS class, then parse PartComponent separately from the output using something like Excel or Access.

To add this you'll right-click on a computer or selection of computers and choose WMI->Execute Query. Click the New button and enter in Win32_SystemBIOS for both the WMI Query Name and the WMI Class and click OK. Add the fields you want to see, then click Execute.</span></div></div>

Got it ... Thanks ...

[kstanush]

Re: Creating New Queries

In case you have not figured this out, you can run this query for multiple computers when selected from the right window.