DWH reports in 4.X ?

Hi, I see the DWH reports disappeared in 3.5 or maybe 3.6, there seems to be no substitute por 4.X Is there some alternative to have some pre-made reports from the DWH on 4.X ? Maybe not something on the oVirt project itself but from someone on the community? Thanks in advance! -- Eduardo Mayoral Jimeno (emayoral@arsys.es) Administrador de sistemas. Departamento de Plataformas. Arsys internet. +34 941 620 145 ext. 5153

Hi Eduardo, DWH still exists, and if you have a reports tool that supports sql you can use it with it. Reports was deprecated in 3.6. We are now working on adding a new metrics store solution for oVirt. For more details you can have a look at: http://www.ovirt.org/develop/release-management/features/ engine/metrics-store/ Currently in 4.1 the hosts and engine include Collectd and Fluentd. In 4.2 we expect to have the metrics store ready. You can try setting up the metrics store side from upstream for now. https://github.com/sradco/ovirt-metrics-conf <https://github.com/sradco/ovirt-metrics-conf> <https://github.com/sradco/ovirt-metrics-conf> The Fluent and Collectd configuration are handled at: https://github.com/oVirt/ovirt-engine-metrics Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109 On Tue, Mar 7, 2017 at 12:29 PM, Eduardo Mayoral <emayoral@arsys.es> wrote:
Hi,
I see the DWH reports disappeared in 3.5 or maybe 3.6, there seems to be no substitute por 4.X
Is there some alternative to have some pre-made reports from the DWH on 4.X ? Maybe not something on the oVirt project itself but from someone on the community?
Thanks in advance!
-- Eduardo Mayoral Jimeno (emayoral@arsys.es) Administrador de sistemas. Departamento de Plataformas. Arsys internet. +34 941 620 145 ext. 5153
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

This is a multi-part message in MIME format. --------------E7C4D6F2E7D02461F4DD218B Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Thanks for your answer! Looks certainly interesting. I am using collectd with virt plugin + carbon + graphite + grafana for performance graphs of the hosts and the VMs right now ( oVirt 4.1 with nodes in CentOS 7.3) I like the idea of using fluentd for this instead of a relational database. Will it handle metrics and logs as well? I am asking because of the kibana component. Best regards, Eduardo Mayoral Jimeno (emayoral@arsys.es) Administrador de sistemas. Departamento de Plataformas. Arsys internet. +34 941 620 145 ext. 5153 On 08/03/17 14:51, Shirly Radco wrote:
Hi Eduardo,
DWH still exists, and if you have a reports tool that supports sql you can use it with it. Reports was deprecated in 3.6.
We are now working on adding a new metrics store solution for oVirt.
For more details you can have a look at: http://www.ovirt.org/develop/release-management/features/engine/metrics-stor... <http://www.ovirt.org/develop/release-management/features/engine/metrics-store/>
Currently in 4.1 the hosts and engine include Collectd and Fluentd. In 4.2 we expect to have the metrics store ready.
You can try setting up the metrics store side from upstream for now. https://github.com/sradco/ovirt-metrics-conf <https://github.com/sradco/ovirt-metrics-conf>
<https://github.com/sradco/ovirt-metrics-conf>
<https://github.com/sradco/ovirt-metrics-conf> The Fluent and Collectd configuration are handled at: https://github.com/oVirt/ovirt-engine-metrics
Best regards, Shirly Radco BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109
On Tue, Mar 7, 2017 at 12:29 PM, Eduardo Mayoral <emayoral@arsys.es <mailto:emayoral@arsys.es>> wrote:
Hi,
I see the DWH reports disappeared in 3.5 or maybe 3.6, there seems to be no substitute por 4.X
Is there some alternative to have some pre-made reports from the DWH on 4.X ? Maybe not something on the oVirt project itself but from someone on the community?
Thanks in advance!
-- Eduardo Mayoral Jimeno (emayoral@arsys.es <mailto:emayoral@arsys.es>) Administrador de sistemas. Departamento de Plataformas. Arsys internet. +34 941 620 145 ext. 5153 <tel:%2B34%20941%20620%20145%20ext.%205153>
_______________________________________________ Users mailing list Users@ovirt.org <mailto:Users@ovirt.org> http://lists.ovirt.org/mailman/listinfo/users <http://lists.ovirt.org/mailman/listinfo/users>
--------------E7C4D6F2E7D02461F4DD218B Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit <html> <head> <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> </head> <body text="#000000" bgcolor="#FFFFFF"> <p>Thanks for your answer!</p> <p>Looks certainly interesting. I am using collectd with virt plugin + carbon + graphite + grafana for performance graphs of the hosts and the VMs right now ( oVirt 4.1 with nodes in CentOS 7.3)</p> <p>I like the idea of using fluentd for this instead of a relational database. Will it handle metrics and logs as well? I am asking because of the kibana component.</p> <p>Best regards,<br> </p> <pre class="moz-signature" cols="72">Eduardo Mayoral Jimeno (<a class="moz-txt-link-abbreviated" href="mailto:emayoral@arsys.es">emayoral@arsys.es</a>) Administrador de sistemas. Departamento de Plataformas. Arsys internet. +34 941 620 145 ext. 5153</pre> <div class="moz-cite-prefix">On 08/03/17 14:51, Shirly Radco wrote:<br> </div> <blockquote cite="mid:CAP=MDkB=8FOq9hPo=T6ymHb_DgzMmEpRKQwW26RGHt-fbjvzMQ@mail.gmail.com" type="cite"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <div dir="ltr">Hi Eduardo, <div><br> </div> <div>DWH still exists, and if you have a reports tool that supports sql you can use it with it.</div> <div>Reports was deprecated in 3.6.</div> <div><br> </div> <div>We are now working on adding a new metrics store solution for oVirt.</div> <div><br> </div> <div>For more details you can have a look at:</div> <div><a moz-do-not-send="true" href="http://www.ovirt.org/develop/release-management/features/engine/metrics-stor..." target="_blank">http://www.ovirt.org/develop/<wbr>release-management/features/<wbr>engine/metrics-store/</a></div> <div><br> </div> <div>Currently in 4.1 the hosts and engine include Collectd and Fluentd.</div> <div>In 4.2 we expect to have the metrics store ready.</div> <div><br> </div> <div>You can try setting up the metrics store side from upstream for now.</div> <div><a moz-do-not-send="true" href="https://github.com/sradco/ovirt-metrics-conf" target="_blank">https://github.com/sradco/<wbr>ovirt-metrics-conf<br> </a></div> <div><a moz-do-not-send="true" href="https://github.com/sradco/ovirt-metrics-conf" target="_blank"><br> </a></div> <div><a moz-do-not-send="true" href="https://github.com/sradco/ovirt-metrics-conf" target="_blank"><br> </a></div> <div>The Fluent and Collectd configuration are handled at:</div> <div><a moz-do-not-send="true" href="https://github.com/oVirt/ovirt-engine-metrics">https://github.com/oVirt/ovirt-engine-metrics<br> </a></div> <div><br> </div> </div> <div class="gmail_extra"><br clear="all"> <div> <div class="gmail_signature" data-smartmail="gmail_signature"> <div dir="ltr"> <div> <div dir="ltr"> <div> <div dir="ltr"> <div> <div dir="ltr"> <pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif;font-size:12.8px">Best regards,</span></pre> <pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif;font-size:12.8px">Shirly Radco</span></pre> <pre cols="72" style="white-space:pre-wrap;color:rgb(80,0,80)"><span style="font-family:arial,helvetica,sans-serif">BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109</span></pre> </div> </div> </div> </div> </div> </div> </div> </div> </div> <br> <div class="gmail_quote">On Tue, Mar 7, 2017 at 12:29 PM, Eduardo Mayoral <span dir="ltr"><<a moz-do-not-send="true" href="mailto:emayoral@arsys.es" target="_blank">emayoral@arsys.es</a>></span> wrote:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br> Hi,<br> <br> I see the DWH reports disappeared in 3.5 or maybe 3.6, there seems<br> to be no substitute por 4.X<br> <br> Is there some alternative to have some pre-made reports from the DWH<br> on 4.X ? Maybe not something on the oVirt project itself but from<br> someone on the community?<br> <br> Thanks in advance!<br> <span class="HOEnZb"><font color="#888888"><br> --<br> Eduardo Mayoral Jimeno (<a moz-do-not-send="true" href="mailto:emayoral@arsys.es">emayoral@arsys.es</a>)<br> Administrador de sistemas. Departamento de Plataformas. Arsys internet.<br> <a moz-do-not-send="true" href="tel:%2B34%20941%20620%20145%20ext.%205153" value="+34941620145">+34 941 620 145 ext. 5153</a><br> <br> ______________________________<wbr>_________________<br> Users mailing list<br> <a moz-do-not-send="true" href="mailto:Users@ovirt.org">Users@ovirt.org</a><br> <a moz-do-not-send="true" href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br> </font></span></blockquote> </div> <br> </div> </blockquote> <br> </body> </html> --------------E7C4D6F2E7D02461F4DD218B--

Yes. We are working to integrate our engine and vdsm logs as well. Hope you will find it helpful and would appreciate your input once we have the metrics store in production. -- Shirly Radco BI Software Engineer Red Hat Israel Ltd. On Wed, Mar 8, 2017 at 4:44 PM, Eduardo Mayoral <emayoral@arsys.es> wrote:
Thanks for your answer!
Looks certainly interesting. I am using collectd with virt plugin + carbon + graphite + grafana for performance graphs of the hosts and the VMs right now ( oVirt 4.1 with nodes in CentOS 7.3)
I like the idea of using fluentd for this instead of a relational database. Will it handle metrics and logs as well? I am asking because of the kibana component.
Best regards,
Eduardo Mayoral Jimeno (emayoral@arsys.es) Administrador de sistemas. Departamento de Plataformas. Arsys internet.+34 941 620 145 ext. 5153 <+34%20941%2062%2001%2045>
On 08/03/17 14:51, Shirly Radco wrote:
Hi Eduardo,
DWH still exists, and if you have a reports tool that supports sql you can use it with it. Reports was deprecated in 3.6.
We are now working on adding a new metrics store solution for oVirt.
For more details you can have a look at: http://www.ovirt.org/develop/release-management/features/eng ine/metrics-store/
Currently in 4.1 the hosts and engine include Collectd and Fluentd. In 4.2 we expect to have the metrics store ready.
You can try setting up the metrics store side from upstream for now. https://github.com/sradco/ovirt-metrics-conf
<https://github.com/sradco/ovirt-metrics-conf>
<https://github.com/sradco/ovirt-metrics-conf> The Fluent and Collectd configuration are handled at: https://github.com/oVirt/ovirt-engine-metrics
Best regards,
Shirly Radco
BI Software Engineer Red Hat Israel Ltd. 34 Jerusalem Road Building A, 4th floor Ra'anana, Israel 4350109
On Tue, Mar 7, 2017 at 12:29 PM, Eduardo Mayoral <emayoral@arsys.es> wrote:
Hi,
I see the DWH reports disappeared in 3.5 or maybe 3.6, there seems to be no substitute por 4.X
Is there some alternative to have some pre-made reports from the DWH on 4.X ? Maybe not something on the oVirt project itself but from someone on the community?
Thanks in advance!
-- Eduardo Mayoral Jimeno (emayoral@arsys.es) Administrador de sistemas. Departamento de Plataformas. Arsys internet. +34 941 620 145 ext. 5153
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (2)
-
Eduardo Mayoral
-
Shirly Radco