Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog

Rapport pour afficher les PC modeles avec part number

Created: 27 Jan 2012 • Updated: 24 Apr 2012 • 2 comments
Pascal KOTTE's picture
+4 4 Votes
Login to vote
Name User OS Name OS Revision Model Manufacturer Part Number Serial Number
PC-001 user1 Microsoft Windows XP Service Pack 3 HP xw4400 Workstation Hewlett-Packard 0A68h CZC7285600
PC-002 user2 Microsoft Windows XP Service Pack 3 DSDT Hewlett-Packard 0864h CZC3490N00

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')

 

Comments 2 CommentsJump to latest comment

pbSCS2012's picture

Is there a way to incorporate BIOS information (version, vendor, release date) to this query from Inv_AMT_BIOS?

 Patrick Barcia

US Patents & Trademarks Office

0
Login to vote
pbSCS2012's picture

Disregard! Thanks

 Patrick Barcia

US Patents & Trademarks Office

0
Login to vote