<div dir="ltr"><div>Thanks!!<br></div>Only, I can't execute the query.. I added it to the reports as a SQL query, but I can't execute it... I never added a new one before... So maybe that will be the problem... :-)<br></div><div class="gmail_extra"><br><div class="gmail_quote">2015-03-16 13:29 GMT+01:00 Shirly Radco <span dir="ltr"><<a href="mailto:sradco@redhat.com" target="_blank">sradco@redhat.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Koen,<br>
<br>
I believe you can use this query:<br>
<br>
SELECT v3_5_latest_configuration_hosts_interfaces.vlan_id,<br>
v3_5_latest_configuration_hosts.host_id,<br>
v3_5_statistics_vms_resources_usage_samples.vm_id<br>
FROM v3_5_latest_configuration_hosts_interfaces<br>
LEFT JOIN v3_5_latest_configuration_hosts ON<br>
v3_5_latest_configuration_hosts_interfaces.host_id =<br>
v3_5_latest_configuration_hosts.host_id<br>
LEFT JOIN v3_5_statistics_vms_resources_usage_samples ON<br>
v3_5_latest_configuration_hosts.history_id =<br>
v3_5_statistics_vms_resources_usage_samples.current_host_configuration_version<br>
LEFT JOIN v3_5_latest_configuration_vms ON<br>
v3_5_latest_configuration_vms.history_id =<br>
v3_5_statistics_vms_resources_usage_samples.vm_configuration_version<br>
LEFT JOIN v3_5_latest_configuration_vms_interfaces ON<br>
v3_5_latest_configuration_vms.history_id =<br>
v3_5_latest_configuration_vms_interfaces.vm_configuration_version<br>
WHERE v3_5_statistics_vms_resources_usage_samples.vm_status = 1<br>
AND v3_5_latest_configuration_hosts_interfaces.vlan_id IS NOT NULL<br>
AND v3_5_latest_configuration_vms_interfaces.logical_network_name =<br>
v3_5_latest_configuration_hosts_interfaces.logical_network_name<br>
GROUP BY v3_5_latest_configuration_hosts_interfaces.vlan_id,<br>
v3_5_latest_configuration_hosts.host_id,<br>
v3_5_statistics_vms_resources_usage_samples.vm_id<br>
ORDER BY v3_5_latest_configuration_hosts_interfaces.vlan_id,<br>
v3_5_latest_configuration_hosts.host_id,<br>
v3_5_statistics_vms_resources_usage_samples.vm_id<br>
<br>
If you need more details please let me know.<br>
<br>
Best regards,<br>
---<br>
Shirly Radco<br>
BI Software Engineer<br>
Red Hat Israel Ltd.<br>
<div><div class="h5"><br>
<br>
----- Original Message -----<br>
> From: "Koen Vanoppen" <<a href="mailto:vanoppen.koen@gmail.com">vanoppen.koen@gmail.com</a>><br>
> To: <a href="mailto:users@ovirt.org">users@ovirt.org</a><br>
> Sent: Friday, March 13, 2015 9:17:29 AM<br>
> Subject: [ovirt-users] DWH Question<br>
><br>
> Dear all,<br>
><br>
> Is it possible to pull a list of all VMS who are in vlanX?<br>
><br>
> Kind regards,<br>
><br>
> Koen<br>
><br>
</div></div>> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
> <a href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
><br>
</blockquote></div><br></div>