Hi all,
admitting in the first stage: it's the first time I try to set up automated (scheduled) reports within UIM
I've got a task of setting up daily/monthly CSV reports on specific UIM QOS data metrics but can't seem to find a proper solution.
There are several reporting utilities and terms related to UIM making it - to be honest - quite confusing to me:
- Unified Reporter
- iReport
- Reports Portlet
- Report Scheduler Portlet
- Performance Reports
- List Reports
- Performance Report Designer
- List Designer
- CABI
The very basic needs:
- select one or multiple sources
- select one or multiple targets
- select one or multiple QoS
- select a relative timeframe like "last month"
- select an execuation interval like "at 06.00 on first day of each month"
- cool optional addon feature: specific sources and targets by wildcard
Within UMP Reporting utilities, I'm able to get on demand QoS data display and manual export, but no scheduling.
While I don't even see how to launch The Report Scheduler Portlet, it is documented to deliver PDF format only.
We've got a CABI (JasperReports) ingtegrated with UIM, where I managed to define a report (based on an adhoc view) showing the required data. It would be easy to schedule repeated execution, but I can't seem to find a way to get parameter input controls to specify relative time ranges, e.g. "previous month". Furthermore, the timestamps just show day/month/year but no hour/minute/second.
I'm sure it would be technically possible to create a script issueing SQL queries to the UIM database directly. However, a preferred solution would make use of existing product features.
Any hints would be greatly appriciated.
regards,
Raphael