A new Flexera Community experience is coming on November 18th, click here for more information.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

VM Friendly Name from the database

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

img.png

(1) 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]

 

 

View solution in original post

(1) Reply

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]