Client Management Suite

Hi all

Can anyone tell me what equals inventory 6 [AeX HW Serial Number].[Computer Model] in the version 7 Inventory ?

I'm trying to use it in CMDB rules for computers.

Best Regards bkcbkc11

Hi,

You can use vHWChassis.

you can fin a sample below:

select vComputer.[Name],

        vComputer.[User],

    vHWComputerSystem.Manufacturer as [System Manufacturer],

    CASE Chassis.[Chassis Package Type]

        WHEN 1 THEN 'Other'

        WHEN 2 THEN 'Unknown'

        WHEN 3 THEN 'Desktop'

        WHEN 4 THEN 'Low Profile Desktop'

        WHEN 5 THEN 'Pizza Box'

        WHEN 6 THEN 'Mini Tower'

        WHEN 7 THEN 'Tower'

        WHEN 8 THEN 'Portable'

        WHEN 9 THEN 'Laptop'

        WHEN 10 THEN 'Notebook'

        WHEN 11 THEN 'Hand Held'

        WHEN 12 THEN 'Docking Station'

        WHEN 13 THEN 'All in One'

        WHEN 14 THEN 'Sub Notebook'

        WHEN 15 THEN 'Space-Saving'

        WHEN 16 THEN 'Lunch Box'

        WHEN 17 THEN 'Main System Chassis'

        WHEN 18 THEN 'Expansion Chassis'

        WHEN 19 THEN 'SubChassis'

        WHEN 20 THEN 'Bus Expansion Chassis'

        WHEN 21 THEN 'Peripheral Chassis'

        WHEN 22 THEN 'Storage Chassis'

        WHEN 23 THEN 'Rack Mount Chassis'

        WHEN 24 THEN 'Sealed-Case PC'

    END AS TYPE,

    vHWComputerSystem.[Identifying Number] as [Hardware Serial Number],

    vHWComputerSystem.[Model] as [Hardware Model Number]





From vComputer

inner join vHWComputerSystem

on vComputer.[guid] = vHWComputerSystem.[_Resourceguid]

inner join vHWChassis as chassis

on vComputer.[guid] = chassis.[_ResourceGuid]



Where vComputer.ismanaged = 1

Best Regards,

vHWComputerSystem.Maufacturer and vHWComputerSystem.Model are analagous to the dataclases you requested.

Since this is a view, in case you're curious, the view is created from Inv_HW_Logical_Device and Inv_HW_Computer_System and are joined by device ID. You can see the manufacturer and model information in Inv_HW_Logical_Device, but it's there with a lot of other logica device info, so the identifier from Inv_HW_Computer_System is what allows it to retrieve the correct information.

Hi,

I create this script with CMS 7 without SP1 and SP2, and I don't have this information for all models in vHWComputerSystem, I always use this after ..

But, I agree, the view vHWComputerSystemis better

Best Regards,