Forum Discussion
WerickV
Jul 29, 2020Copper Contributor
WMIMonitorID, Convert the userfriedlyname column to human readable format
Hi I am trying to create a query to obtain the MonitorID WMI data. The issue is that the userfriedlyname column is sometimes stored as ASCII values. How do i convert this to human readable fo...
WerickV
Jul 31, 2020Copper Contributor
Michiel Overweel I enabled collecting that standard class. The Win32_DesktopMonitor does not include manufacturer and serial etc.
Michiel Overweel
Jul 31, 2020Former Employee
WerickV So I'm assuming you extended hardware inventory to include the WmiMonitorID class. Many properties of that class are stored not as string values, but as arrays of ASCII character codes. If you insist on using the WmiMonitorID class, that's something you'll have to live with. I don't think you can convert these arrays to strings using WQL, but it should be possible using SQL. You might be interested in this (old) blog article: Reporting Monitor information with Configuration Manager.