Deployment Solution

 View Only
Back to discussions
Expand all | Collapse all

How to get LogicalDevice CD-ROM Manufacture Name or Model Name ?

  • 1.  How to get LogicalDevice CD-ROM Manufacture Name or Model Name ?

    Posted Jul 03, 2013 05:34 AM

    Dear All,

     

    Is possible to get LogicalDevice's Manufacture Name or Model Name ???

    SELECT     TOP (100) PERCENT UPPER(dbo.Inv_AeX_AC_Identification.Name) AS PCName, dbo.vHWLogicalDisk.[Device ID], dbo.vHWLogicalDisk.Description
    FROM         dbo.Inv_AeX_AC_Identification INNER JOIN
                          dbo.vHWLogicalDisk ON dbo.Inv_AeX_AC_Identification._ResourceGuid = dbo.vHWLogicalDisk._ResourceGuid
    WHERE     (dbo.vHWLogicalDisk.Description LIKE N'%ROM%') AND (UPPER(dbo.Inv_AeX_AC_Identification.Name) LIKE '%Computer%')
    ORDER BY dbo.Inv_AeX_AC_Identification.Name, dbo.vHWLogicalDisk.[Device ID]

     

    Thanks



  • 2.  RE: How to get LogicalDevice CD-ROM Manufacture Name or Model Name ?

    Posted Jul 11, 2013 09:03 AM

    I don't fully understand your question.  Can you show us the output you're getting and what you WANT it to be?