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

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

Created: 03 Jul 2013 | 1 comment

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]


Comments 1 CommentJump to latest comment

Thomas Baird's picture

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

Thomas Baird
Enthusiast for making things better!