Hi everyone,
I'm working on a reporting requirement and need some help creating a Database View. The goal is to create a report that pulls specific tag information associated with our VMI (VMware virtual machine instance) records, along with other key details.
I need to include the following fields from VMI records: AppID, AppName, ENV, and Sys#. These fields are stored as tags in the cmdb_key_value table.
The challenge is creating the proper joins. I have the main table, cmdb_ci_vm_instance, and I need to join it to the cmdb_key_value table multiple times to pull the different tags (AppID, AppName, ENV, Sysid).
I have tried to create as below but its not working please let me know where i am doing mistake & how to achieve this
Any help would be greatly appreciated.
Thank you
