shwstppr commented on pull request #4789:
URL: https://github.com/apache/cloudstack/pull/4789#issuecomment-796662828
@weizhouapache with above SQL create view statement we will have a single
entry for each host with multiple tags comma-separated. Something like,
```
*************************** 1. row ***************************
id: 1
uuid: 4937aa4f-6f27-4dc8-af70-2335279edf27
name: pr4710-t3640-kvm-centos7-kvm1
status: Disconnected
disconnected: NULL
type: Routing
private_ip_address: 10.10.3.146
version: 4.15.1.0-SNAPSHOT
hypervisor_type: KVM
hypervisor_version: NULL
capabilities: hvm,snapshot
last_ping: 1577598635
created: 2021-03-03 06:09:26
removed: NULL
resource_state: Enabled
mgmt_server_id: NULL
cpu_sockets: 3
cpus: 3
speed: 2350
ram: 7277121536
cluster_id: 1
cluster_uuid: 881c01ec-7a4b-4c55-af5c-d53de5880b5e
cluster_name: p1-c1
cluster_type: CloudManaged
data_center_id: 1
data_center_uuid: 3f4d015c-7d6b-4b5e-86b0-79552910f77b
data_center_name: pr4710-t3640-kvm-centos7
data_center_type: Advanced
pod_id: 1
pod_uuid: 496029eb-411a-4736-954d-73d5a8d15e56
pod_name: Pod1
tag: test,ha
guest_os_category_id: NULL
guest_os_category_uuid: NULL
guest_os_category_name: NULL
memory_used_capacity: 268435456
memory_reserved_capacity: 0
cpu_used_capacity: 500
cpu_reserved_capacity: 0
job_id: NULL
job_uuid: NULL
job_status: NULL
job_account_id: NULL
oobm_enabled: NULL
oobm_power_state: NULL
ha_enabled: NULL
ha_state: NULL
ha_provider: NULL
annotation: NULL
last_annotated: NULL
username: NULL
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
