VM Friendly Name from the database

[FarrukhNaz]

Hi, I've spend quite sometime locating the database table that contains the VM Property > Friendly Name but out of luck.

Apricate your help with mentioning the DB table name that has the [Friendly Name] column?

Thanks

[FarrukhNaz · Accepted solution]

I just found the table that contains the Friendly Name column, its [VirtualMachine_MT] in Compliance Database.

SELECT
CC.[ComputerName]
,VM.[FriendlyName]
,CC.[IPAddress]
,CC.[SerialNo]
,CC.[Manufacturer]
,CC.[MACAddress]
FROM [ComplianceComputer_MT] CC
LEFT JOIN [VirtualMachine_MT] VM ON CC.[ComplianceComputerID] = VM.[ComplianceComputerID]