The Community is now in read-only mode to prepare for the launch of the new Flexera Community. During this time, you will be unable to register, log in, or access customer resources. Click here for more information.
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
‎Nov 03, 2024 05:51 AM - edited ‎Nov 03, 2024 05:52 AM
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]
‎Nov 04, 2024 02:22 AM - edited ‎Nov 05, 2024 01:56 AM
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]
‎Nov 04, 2024 02:22 AM - edited ‎Nov 05, 2024 01:56 AM