Re: [ovirt-users] ovirt report portal question
Hi, Anybody can help me? Thanks a lot. Regards, Tibor - Eredeti üzenet - 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@ovirt.org http://lists.ovirt.orgmailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
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 üzenet - 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 sra...@redhat.com To: Demeter Tibor tdeme...@itsmart.hu Cc: users@ovirt.org List users@ovirt.org, Yaniv Dary yd...@redhat.com 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 tdeme...@itsmart.hu To: users@ovirt.org List users@ovirt.org 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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] ovirt report portal question
- Original Message - From: Demeter Tibor tdeme...@itsmart.hu To: Yaniv Dary yd...@redhat.com Cc: users@ovirt.org List users@ovirt.org, Shirly Radco sra...@redhat.com 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 advance 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 üzenet - 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 sra...@redhat.com To: Demeter Tibor tdeme...@itsmart.hu Cc: users@ovirt.org List users@ovirt.org, Yaniv Dary yd...@redhat.com 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 tdeme...@itsmart.hu To: users@ovirt.org List users@ovirt.org 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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] ovirt report portal question
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 tdeme...@itsmart.hu To: Yaniv Dary yd...@redhat.com Cc: users@ovirt.org List users@ovirt.org, Shirly Radco sra...@redhat.com 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 üzenet - 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 sra...@redhat.com To: Demeter Tibor tdeme...@itsmart.hu Cc: users@ovirt.org List users@ovirt.org, Yaniv Dary yd...@redhat.com 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 tdeme...@itsmart.hu To: users@ovirt.org List users@ovirt.org 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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
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 tdeme...@itsmart.hu To: users@ovirt.org List users@ovirt.org 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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] ovirt report portal question
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 sra...@redhat.com To: Demeter Tibor tdeme...@itsmart.hu Cc: users@ovirt.org List users@ovirt.org, Yaniv Dary yd...@redhat.com 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 tdeme...@itsmart.hu To: users@ovirt.org List users@ovirt.org 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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users