A new Flexera Community experience is coming on November 18th, 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
User | Count |
---|---|
8 | |
7 | |
3 | |
3 |