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" > To: "Yaniv Dary" > Cc: "users@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 ü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" > > > To: "Demeter Tibor" > > > Cc: "users@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@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@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" > To: "Yaniv Dary" > Cc: "users@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 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" > > > To: "Demeter Tibor" > > > Cc: "users@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@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@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, 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" > > To: "Demeter Tibor" > > Cc: "users@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@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@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, 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
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@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@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@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" > To: "users@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@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
