Groupe des Utilisateurs Altiris Suisses et Francophones Group

SELECT     vComputer.[Guid],
        vComputer.Name,
        vComputer.[User],
        vComputer.[OS Name],
        vComputer.IsManaged,
        vComputer.[OS Revision],
        Inv_HW_Logical_Device.Description,
        Inv_HW_Logical_Device.Model,
        Inv_HW_Logical_Device.Manufacturer,
        Inv_HW_Logical_Device.[Device Class],
        Inv_HW_Baseboard.[Part Number],
        Inv_HW_Baseboard.[Serial Number]
FROM Inv_HW_Logical_Device
    INNER JOIN vComputer ON Inv_HW_Logical_Device._ResourceGuid = vComputer.Guid
    INNER JOIN Inv_HW_Baseboard ON Inv_HW_Logical_Device._ResourceGuid = Inv_HW_Baseboard._ResourceGuid
WHERE
    (Inv_HW_Logical_Device.[Device Class] = 2176)
    AND (Inv_HW_Logical_Device.Description NOT LIKE 'Base Board')
    AND (Inv_HW_Logical_Device.Description NOT LIKE 'System Enclosure')