From tdemeter at itsmart.hu Thu Nov 27 10:26:18 2014 Content-Type: multipart/mixed; boundary="===============2160071435799288398==" MIME-Version: 1.0 From: Demeter Tibor To: users at ovirt.org Subject: [ovirt-users] ovirt report portal question Date: Thu, 27 Nov 2014 16:26:12 +0100 Message-ID: <136099813.10449993.1417101972489.JavaMail.zimbra@itsmart.hu> In-Reply-To: 22033823.10449217.1417101831942.JavaMail.zimbra@itsmart.hu --===============2160071435799288398== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable ------=3D_Part_10449992_1173093560.1417101972488 Content-Type: text/plain; charset=3Dutf-8 Content-Transfer-Encoding: 7bit Hi all, = How can I make own querys in engine reports? = I would like to see the CONSUMED disk usage of a VM /day or /month. = Is it possible? = Thanks in advance, = Tibor = ------=3D_Part_10449992_1173093560.1417101972488 Content-Type: text/html; charset=3Dutf-8 Content-Transfer-Encoding: 7bit

Hi all,

How can I make own querys in engine reports?

I would like to see the CONSUMED disk usage of a VM /day or /mon= th.

Is it possible?

Thanks in advance,

Tibor

------=3D_Part_10449992_1173093560.1417101972488-- --===============2160071435799288398== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" LS0tLS0tPV9QYXJ0XzEwNDQ5OTkyXzExNzMwOTM1NjAuMTQxNzEwMTk3MjQ4OApDb250ZW50LVR5 cGU6IHRleHQvcGxhaW47IGNoYXJzZXQ9dXRmLTgKQ29udGVudC1UcmFuc2Zlci1FbmNvZGluZzog N2JpdAoKCkhpIGFsbCwgCgpIb3cgY2FuIEkgbWFrZSBvd24gcXVlcnlzIGluIGVuZ2luZSByZXBv cnRzPyAKCkkgd291bGQgbGlrZSB0byBzZWUgdGhlIENPTlNVTUVEIGRpc2sgdXNhZ2Ugb2YgYSBW TSAvZGF5IG9yIC9tb250aC4gCgpJcyBpdCBwb3NzaWJsZT8gClRoYW5rcyBpbiBhZHZhbmNlLCAK ClRpYm9yIAoKCgotLS0tLS09X1BhcnRfMTA0NDk5OTJfMTE3MzA5MzU2MC4xNDE3MTAxOTcyNDg4 CkNvbnRlbnQtVHlwZTogdGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04CkNvbnRlbnQtVHJhbnNmZXIt RW5jb2Rpbmc6IDdiaXQKCjxodG1sPjxib2R5PjxkaXYgc3R5bGU9ImZvbnQtZmFtaWx5OiB0aW1l cyBuZXcgcm9tYW4sIG5ldyB5b3JrLCB0aW1lcywgc2VyaWY7IGZvbnQtc2l6ZTogMTJwdDsgY29s b3I6ICMwMDAwMDAiPjxkaXY+PGJyPjwvZGl2PjxkaXY+SGkgYWxsLDwvZGl2PjxkaXY+PGJyPjwv ZGl2PjxkaXY+SG93IGNhbiBJIG1ha2Ugb3duIHF1ZXJ5cyBpbiBlbmdpbmUgcmVwb3J0cz88L2Rp dj48ZGl2Pjxicj48L2Rpdj48ZGl2Pkkgd291bGQgbGlrZSB0byBzZWUgdGhlIENPTlNVTUVEIGRp c2sgdXNhZ2Ugb2YgYSBWTSAvZGF5IG9yIC9tb250aC48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2 PklzIGl0IHBvc3NpYmxlPzwvZGl2PjxkaXY+VGhhbmtzIGluIGFkdmFuY2UsPC9kaXY+PGRpdj48 YnI+PC9kaXY+PGRpdj5UaWJvcjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+PHNwYW4gbmFtZT0i eCI+PC9zcGFuPjxicj48L2Rpdj48L2Rpdj48L2JvZHk+PC9odG1sPgotLS0tLS09X1BhcnRfMTA0 NDk5OTJfMTE3MzA5MzU2MC4xNDE3MTAxOTcyNDg4LS0K --===============2160071435799288398==-- From sradco at redhat.com Sun Nov 30 03:54:47 2014 Content-Type: multipart/mixed; boundary="===============3996927971504733927==" MIME-Version: 1.0 From: Shirly Radco To: users at ovirt.org Subject: Re: [ovirt-users] ovirt report portal question Date: Sun, 30 Nov 2014 03:54:42 -0500 Message-ID: <1341450591.4708658.1417337682415.JavaMail.zimbra@redhat.com> In-Reply-To: 136099813.10449993.1417101972489.JavaMail.zimbra@itsmart.hu --===============3996927971504733927== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Hi Tibor, You can't make your own queries using the reports portal, but you can query directly from the ovirt_egine_history database using the = API views. There are the v3_5_statistics_vms_disks_resources_usage_samples /hourly /da= ily views, They include vm disks usage data. And join them with the other relevant views like v3_5_configuration_history= _vms and v3_5_configuration_history_vms_disks. We also plan on adding in 3.6 the vms disk usage including templates and sn= apshots. Best regards, --- = Shirly Radco = BI Software Engineer = Red Hat Israel Ltd. ----- Original Message ----- > From: "Demeter Tibor" > To: "users(a)ovirt.org List" > Sent: Thursday, November 27, 2014 5:26:12 PM > Subject: [ovirt-users] ovirt report portal question > = > = > Hi all, > = > How can I make own querys in engine reports? > = > I would like to see the CONSUMED disk usage of a VM /day or /month. > = > Is it possible? > Thanks in advance, > = > Tibor > = > = > = > _______________________________________________ > Users mailing list > Users(a)ovirt.org > http://lists.ovirt.org/mailman/listinfo/users >=20 --===============3996927971504733927==-- From ydary at redhat.com Sun Nov 30 05:20:53 2014 Content-Type: multipart/mixed; boundary="===============3049794040374655864==" MIME-Version: 1.0 From: Yaniv Dary To: users at ovirt.org Subject: Re: [ovirt-users] ovirt report portal question Date: Sun, 30 Nov 2014 05:20:47 -0500 Message-ID: <917324242.20105239.1417342847271.JavaMail.zimbra@redhat.com> In-Reply-To: 1341450591.4708658.1417337682415.JavaMail.zimbra@redhat.com --===============3049794040374655864== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable You can use JasperReports Studio to create reports and they will be saved i= f you use the "Saved Reports" folder. You can find guide to use this tool in the JasperSoft community website. Yaniv ----- Original Message ----- > From: "Shirly Radco" > To: "Demeter Tibor" > Cc: "users(a)ovirt.org List" , "Yaniv Dary" > Sent: Sunday, November 30, 2014 10:54:42 AM > Subject: Re: [ovirt-users] ovirt report portal question > = > Hi Tibor, > = > = > You can't make your own queries using the reports portal, > but you can query directly from the ovirt_egine_history database using the > API views. > = > There are the v3_5_statistics_vms_disks_resources_usage_samples /hourly > /daily views, They include vm disks usage data. > And join them with the other relevant views like > v3_5_configuration_history_vms > and v3_5_configuration_history_vms_disks. > = > = > We also plan on adding in 3.6 the vms disk usage including templates and > snapshots. > = > Best regards, > --- > Shirly Radco > BI Software Engineer > Red Hat Israel Ltd. > = > = > ----- Original Message ----- > > From: "Demeter Tibor" > > To: "users(a)ovirt.org List" > > Sent: Thursday, November 27, 2014 5:26:12 PM > > Subject: [ovirt-users] ovirt report portal question > > = > > = > > Hi all, > > = > > How can I make own querys in engine reports? > > = > > I would like to see the CONSUMED disk usage of a VM /day or /month. > > = > > Is it possible? > > Thanks in advance, > > = > > Tibor > > = > > = > > = > > _______________________________________________ > > Users mailing list > > Users(a)ovirt.org > > http://lists.ovirt.org/mailman/listinfo/users > > = >=20 --===============3049794040374655864==-- From tdemeter at itsmart.hu Mon Dec 1 05:38:10 2014 Content-Type: multipart/mixed; boundary="===============8734239999535579418==" MIME-Version: 1.0 From: Demeter Tibor To: users at ovirt.org Subject: Re: [ovirt-users] ovirt report portal question Date: Mon, 01 Dec 2014 11:38:03 +0100 Message-ID: <1517583932.11072572.1417430283747.JavaMail.zimbra@itsmart.hu> In-Reply-To: 136099813.10449993.1417101972489.JavaMail.zimbra@itsmart.hu --===============8734239999535579418== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable ------=3D_Part_11072571_1751732665.1417430283745 Content-Type: text/plain; charset=3Dutf-8 Content-Transfer-Encoding: quoted-printable Hi,=3D20 Anybody can help me?=3D20 Thanks a lot.=3D20 Regards,=3D20 Tibor=3D20 ----- Eredeti =3DC3=3DBCzenet ----- > Hi all, > How can I make own querys in engine reports? > I would like to see the CONSUMED disk usage of a VM /day or /month. > Is it possible? > Thanks in advance, > Tibor > _______________________________________________ > Users mailing list > Users(a)ovirt.org > http://lists.ovirt.orgmailman/listinfo/users ------=3D_Part_11072571_1751732665.1417430283745 Content-Type: text/html; charset=3Dutf-8 Content-Transfer-Encoding: quoted-printable

Hi,

Any= =3D body can help me?

Thanks a lot.

Regards,

Tibor

<= hr=3D id=3D3D"zwchr">

Hi all,

How can I make own querys in engine reports?

I w= =3D ould like to see the CONSUMED disk usage of a VM /day or /month.

= =3D

Is it possible?

Thanks in advance,

<= =3D /div>

Tibor

_= =3D ______________________________________________
Users mailing list
Use= =3D rs(a)ovirt.org
http://lists.ovirt.orgmailman/listinfo/users

------=3D_Part_11072571_1751732665.1417430283745-- --===============8734239999535579418== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" LS0tLS0tPV9QYXJ0XzExMDcyNTcxXzE3NTE3MzI2NjUuMTQxNzQzMDI4Mzc0NQpDb250ZW50LVR5 cGU6IHRleHQvcGxhaW47IGNoYXJzZXQ9dXRmLTgKQ29udGVudC1UcmFuc2Zlci1FbmNvZGluZzog cXVvdGVkLXByaW50YWJsZQoKSGksPTIwCgpBbnlib2R5IGNhbiBoZWxwIG1lPz0yMAoKVGhhbmtz IGEgbG90Lj0yMAoKUmVnYXJkcyw9MjAKClRpYm9yPTIwCgotLS0tLSBFcmVkZXRpID1DMz1CQ3pl bmV0IC0tLS0tCgo+IEhpIGFsbCwKCj4gSG93IGNhbiBJIG1ha2Ugb3duIHF1ZXJ5cyBpbiBlbmdp bmUgcmVwb3J0cz8KCj4gSSB3b3VsZCBsaWtlIHRvIHNlZSB0aGUgQ09OU1VNRUQgZGlzayB1c2Fn ZSBvZiBhIFZNIC9kYXkgb3IgL21vbnRoLgoKPiBJcyBpdCBwb3NzaWJsZT8KPiBUaGFua3MgaW4g YWR2YW5jZSwKCj4gVGlib3IKCj4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX18KPiBVc2VycyBtYWlsaW5nIGxpc3QKPiBVc2Vyc0BvdmlydC5vcmcKPiBodHRw Oi8vbGlzdHMub3ZpcnQub3JnbWFpbG1hbi9saXN0aW5mby91c2VycwoKLS0tLS0tPV9QYXJ0XzEx MDcyNTcxXzE3NTE3MzI2NjUuMTQxNzQzMDI4Mzc0NQpDb250ZW50LVR5cGU6IHRleHQvaHRtbDsg Y2hhcnNldD11dGYtOApDb250ZW50LVRyYW5zZmVyLUVuY29kaW5nOiBxdW90ZWQtcHJpbnRhYmxl Cgo8aHRtbD48Ym9keT48ZGl2IHN0eWxlPTNEImZvbnQtZmFtaWx5OiB0aW1lcyBuZXcgcm9tYW4s IG5ldyB5b3JrLCB0aW1lcywgc2U9CnJpZjsgZm9udC1zaXplOiAxMnB0OyBjb2xvcjogIzAwMDAw MCI+PGRpdj5IaSw8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PkFueT0KYm9keSBjYW4gaGVscCBt ZT88L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PlRoYW5rcyBhIGxvdC48L2Rpdj48ZGl2Pjxicj48 L2RpPQp2PjxkaXY+UmVnYXJkcyw8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PlRpYm9yPC9kaXY+ PGRpdj48YnI+PC9kaXY+PGRpdj48YnI9Cj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pjxicj48 L2Rpdj48ZGl2PjxzcGFuIG5hbWU9M0QieCI+PC9zcGFuPjxwIHN0eWxlPQo9M0QiZm9udC1mYW1p bHk6ICdUaW1lcyBOZXcgUm9tYW4nOyBmb250LXNpemU6IG1lZGl1bTsgbWFyZ2luOiAwcHg7IiBk YXRhLW09CmNlLXN0eWxlPTNEImZvbnQtZmFtaWx5OiAnVGltZXMgTmV3IFJvbWFuJzsgZm9udC1z aXplOiBtZWRpdW07IG1hcmdpbjogMHB4Oz0KIj48c3Ryb25nPjxzcGFuIHN0eWxlPTNEImZvbnQt c2l6ZTogbWVkaXVtOyIgZGF0YS1tY2Utc3R5bGU9M0QiZm9udC1zaXplOiBtPQplZGl1bTsiPjxz cGFuIHNpemU9M0QiNSIgY29sb3I9M0QiIzJENjdCMCIgc3R5bGU9M0QiY29sb3I6IHJnYig0NSwg MTAzLCAxNzY9Cik7IiBkYXRhLW1jZS1zdHlsZT0zRCJjb2xvcjogIzJkNjdiMDsiPjwvc3Bhbj48 L3NwYW4+PC9zdHJvbmc+PC9wPjwvZGl2Pjxocj0KIGlkPTNEInp3Y2hyIj48YmxvY2txdW90ZSBz dHlsZT0zRCJib3JkZXItbGVmdDoycHggc29saWQgIzEwMTBGRjttYXJnaW4tbGVmPQp0OjVweDtw YWRkaW5nLWxlZnQ6NXB4O2NvbG9yOiMwMDA7Zm9udC13ZWlnaHQ6bm9ybWFsO2ZvbnQtc3R5bGU6 bm9ybWFsO3RleHQ9Ci1kZWNvcmF0aW9uOm5vbmU7Zm9udC1mYW1pbHk6SGVsdmV0aWNhLEFyaWFs LHNhbnMtc2VyaWY7Zm9udC1zaXplOjEycHQ7Ij48ZD0KaXYgc3R5bGU9M0QiZm9udC1mYW1pbHk6 IHRpbWVzIG5ldyByb21hbiwgbmV3IHlvcmssIHRpbWVzLCBzZXJpZjsgZm9udC1zaXplPQo6IDEy cHQ7IGNvbG9yOiAjMDAwMDAwIj48ZGl2Pjxicj48L2Rpdj48ZGl2PkhpIGFsbCw8L2Rpdj48ZGl2 Pjxicj48L2Rpdj48ZGk9CnY+SG93IGNhbiBJIG1ha2Ugb3duIHF1ZXJ5cyBpbiBlbmdpbmUgcmVw b3J0cz88L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2Pkkgdz0Kb3VsZCBsaWtlIHRvIHNlZSB0aGUg Q09OU1VNRUQgZGlzayB1c2FnZSBvZiBhIFZNIC9kYXkgb3IgL21vbnRoLjwvZGl2PjxkaXY+PQo8 YnI+PC9kaXY+PGRpdj5JcyBpdCBwb3NzaWJsZT88L2Rpdj48ZGl2PlRoYW5rcyBpbiBhZHZhbmNl LDwvZGl2PjxkaXY+PGJyPjw9Ci9kaXY+PGRpdj5UaWJvcjwvZGl2PjxkaXY+PGJyPjwvZGl2Pjxk aXY+PHNwYW4+PC9zcGFuPjxicj48L2Rpdj48L2Rpdj48YnI+Xz0KX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fXzxicj5Vc2VycyBtYWlsaW5nIGxpc3Q8YnI+VXNl PQpyc0BvdmlydC5vcmc8YnI+aHR0cDovL2xpc3RzLm92aXJ0Lm9yZ21haWxtYW4vbGlzdGluZm8v dXNlcnM8YnI+PC9ibG9ja3F1b3Q9CmU+PGRpdj48YnI+PC9kaXY+PC9kaXY+PC9ib2R5PjwvaHRt bD4KLS0tLS0tPV9QYXJ0XzExMDcyNTcxXzE3NTE3MzI2NjUuMTQxNzQzMDI4Mzc0NS0tCg== --===============8734239999535579418==-- From tdemeter at itsmart.hu Mon Dec 1 05:49:03 2014 Content-Type: multipart/mixed; boundary="===============6061826494679022418==" MIME-Version: 1.0 From: Demeter Tibor To: users at ovirt.org Subject: Re: [ovirt-users] ovirt report portal question Date: Mon, 01 Dec 2014 11:48:58 +0100 Message-ID: <1397973508.11078808.1417430938094.JavaMail.zimbra@itsmart.hu> In-Reply-To: 917324242.20105239.1417342847271.JavaMail.zimbra@redhat.com --===============6061826494679022418== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Hi, I'm sorry for my last email:( I didn't see your emails. Thank you for the tips. = Need to know programming for use jasper studio? Thanks Tibor ----- Eredeti =C3=BCzenet ----- > You can use JasperReports Studio to create reports and they will be saved= if > you use the "Saved Reports" folder. > You can find guide to use this tool in the JasperSoft community website. > = > = > = > = > Yaniv > = > ----- Original Message ----- > > From: "Shirly Radco" > > To: "Demeter Tibor" > > Cc: "users(a)ovirt.org List" , "Yaniv Dary" > > > > Sent: Sunday, November 30, 2014 10:54:42 AM > > Subject: Re: [ovirt-users] ovirt report portal question > > = > > Hi Tibor, > > = > > = > > You can't make your own queries using the reports portal, > > but you can query directly from the ovirt_egine_history database using = the > > API views. > > = > > There are the v3_5_statistics_vms_disks_resources_usage_samples /hourly > > /daily views, They include vm disks usage data. > > And join them with the other relevant views like > > v3_5_configuration_history_vms > > and v3_5_configuration_history_vms_disks. > > = > > = > > We also plan on adding in 3.6 the vms disk usage including templates and > > snapshots. > > = > > Best regards, > > --- > > Shirly Radco > > BI Software Engineer > > Red Hat Israel Ltd. > > = > > = > > ----- Original Message ----- > > > From: "Demeter Tibor" > > > To: "users(a)ovirt.org List" > > > Sent: Thursday, November 27, 2014 5:26:12 PM > > > Subject: [ovirt-users] ovirt report portal question > > > = > > > = > > > Hi all, > > > = > > > How can I make own querys in engine reports? > > > = > > > I would like to see the CONSUMED disk usage of a VM /day or /month. > > > = > > > Is it possible? > > > Thanks in advance, > > > = > > > Tibor > > > = > > > = > > > = > > > _______________________________________________ > > > Users mailing list > > > Users(a)ovirt.org > > > http://lists.ovirt.org/mailman/listinfo/users > > > = > > = >=20 --===============6061826494679022418==-- From ydary at redhat.com Mon Dec 1 06:23:59 2014 Content-Type: multipart/mixed; boundary="===============6603478614037131262==" MIME-Version: 1.0 From: Yaniv Dary To: users at ovirt.org Subject: Re: [ovirt-users] ovirt report portal question Date: Mon, 01 Dec 2014 06:23:53 -0500 Message-ID: <303881662.20501979.1417433033092.JavaMail.zimbra@redhat.com> In-Reply-To: 1397973508.11078808.1417430938094.JavaMail.zimbra@itsmart.hu --===============6603478614037131262== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable ----- Original Message ----- > From: "Demeter Tibor" > To: "Yaniv Dary" > Cc: "users(a)ovirt.org List" , "Shirly Radco" > Sent: Monday, December 1, 2014 12:48:58 PM > Subject: Re: [ovirt-users] ovirt report portal question > = > Hi, > = > I'm sorry for my last email:( I didn't see your emails. > = > Thank you for the tips. > = > Need to know programming for use jasper studio? You need to know SQL to query the database and basic java for some more adv= ance stuff. RHEV comes with JasperReports Server Pro that has ad hoc reporting that don= 't require any prior knowledge of SQL, but JasperReports Server CE doesn't = include this feature. Yaniv > = > Thanks > = > Tibor > = > = > = > = > = > ----- Eredeti =C3=BCzenet ----- > > You can use JasperReports Studio to create reports and they will be sav= ed > > if > > you use the "Saved Reports" folder. > > You can find guide to use this tool in the JasperSoft community website. > > = > > = > > = > > = > > Yaniv > > = > > ----- Original Message ----- > > > From: "Shirly Radco" > > > To: "Demeter Tibor" > > > Cc: "users(a)ovirt.org List" , "Yaniv Dary" > > > > > > Sent: Sunday, November 30, 2014 10:54:42 AM > > > Subject: Re: [ovirt-users] ovirt report portal question > > > = > > > Hi Tibor, > > > = > > > = > > > You can't make your own queries using the reports portal, > > > but you can query directly from the ovirt_egine_history database using > > > the > > > API views. > > > = > > > There are the v3_5_statistics_vms_disks_resources_usage_samples /hour= ly > > > /daily views, They include vm disks usage data. > > > And join them with the other relevant views like > > > v3_5_configuration_history_vms > > > and v3_5_configuration_history_vms_disks. > > > = > > > = > > > We also plan on adding in 3.6 the vms disk usage including templates = and > > > snapshots. > > > = > > > Best regards, > > > --- > > > Shirly Radco > > > BI Software Engineer > > > Red Hat Israel Ltd. > > > = > > > = > > > ----- Original Message ----- > > > > From: "Demeter Tibor" > > > > To: "users(a)ovirt.org List" > > > > Sent: Thursday, November 27, 2014 5:26:12 PM > > > > Subject: [ovirt-users] ovirt report portal question > > > > = > > > > = > > > > Hi all, > > > > = > > > > How can I make own querys in engine reports? > > > > = > > > > I would like to see the CONSUMED disk usage of a VM /day or /month. > > > > = > > > > Is it possible? > > > > Thanks in advance, > > > > = > > > > Tibor > > > > = > > > > = > > > > = > > > > _______________________________________________ > > > > Users mailing list > > > > Users(a)ovirt.org > > > > http://lists.ovirt.org/mailman/listinfo/users > > > > = > > > = > > = > --===============6603478614037131262==-- From sradco at redhat.com Mon Dec 1 06:24:34 2014 Content-Type: multipart/mixed; boundary="===============6387310479935637208==" MIME-Version: 1.0 From: Shirly Radco To: users at ovirt.org Subject: Re: [ovirt-users] ovirt report portal question Date: Mon, 01 Dec 2014 06:24:29 -0500 Message-ID: <1430799909.4901155.1417433069247.JavaMail.zimbra@redhat.com> In-Reply-To: 1397973508.11078808.1417430938094.JavaMail.zimbra@itsmart.hu --===============6387310479935637208== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Hi Tibor, You need to know sql in order to create the data sets that the reports are = based on. Best regards, --- = Shirly Radco = BI Software Engineer = Red Hat Israel Ltd. ----- Original Message ----- > From: "Demeter Tibor" > To: "Yaniv Dary" > Cc: "users(a)ovirt.org List" , "Shirly Radco" > Sent: Monday, December 1, 2014 12:48:58 PM > Subject: Re: [ovirt-users] ovirt report portal question > = > Hi, > = > I'm sorry for my last email:( I didn't see your emails. > = > Thank you for the tips. > = > Need to know programming for use jasper studio? > = > Thanks > = > Tibor > = > = > = > = > = > ----- Eredeti =C3=BCzenet ----- > > You can use JasperReports Studio to create reports and they will be sav= ed > > if > > you use the "Saved Reports" folder. > > You can find guide to use this tool in the JasperSoft community website. > > = > > = > > = > > = > > Yaniv > > = > > ----- Original Message ----- > > > From: "Shirly Radco" > > > To: "Demeter Tibor" > > > Cc: "users(a)ovirt.org List" , "Yaniv Dary" > > > > > > Sent: Sunday, November 30, 2014 10:54:42 AM > > > Subject: Re: [ovirt-users] ovirt report portal question > > > = > > > Hi Tibor, > > > = > > > = > > > You can't make your own queries using the reports portal, > > > but you can query directly from the ovirt_egine_history database using > > > the > > > API views. > > > = > > > There are the v3_5_statistics_vms_disks_resources_usage_samples /hour= ly > > > /daily views, They include vm disks usage data. > > > And join them with the other relevant views like > > > v3_5_configuration_history_vms > > > and v3_5_configuration_history_vms_disks. > > > = > > > = > > > We also plan on adding in 3.6 the vms disk usage including templates = and > > > snapshots. > > > = > > > Best regards, > > > --- > > > Shirly Radco > > > BI Software Engineer > > > Red Hat Israel Ltd. > > > = > > > = > > > ----- Original Message ----- > > > > From: "Demeter Tibor" > > > > To: "users(a)ovirt.org List" > > > > Sent: Thursday, November 27, 2014 5:26:12 PM > > > > Subject: [ovirt-users] ovirt report portal question > > > > = > > > > = > > > > Hi all, > > > > = > > > > How can I make own querys in engine reports? > > > > = > > > > I would like to see the CONSUMED disk usage of a VM /day or /month. > > > > = > > > > Is it possible? > > > > Thanks in advance, > > > > = > > > > Tibor > > > > = > > > > = > > > > = > > > > _______________________________________________ > > > > Users mailing list > > > > Users(a)ovirt.org > > > > http://lists.ovirt.org/mailman/listinfo/users > > > > = > > > = > > = > --===============6387310479935637208==--