topic Re: OCUM 7.1 Custom Reports in Active IQ Unified Manager Discussions

OCUM 7.1 Custom Reports

GTNDADABO — Wed, 04 Jun 2025 15:17:05 GMT

Greetings,

Does anyone have some sample reports or instructions for creating a custom report for OCUM 7.1?

The Admin guide runs you through setting up eclipse and creating data sets but glosses over the actual creation of SQL queries. As I'm not a SQL pro this is the part I really need.

Re: OCUM 7.1 Custom Reports

rolfh — Fri, 21 Apr 2017 15:25:51 GMT

I posted a Vido explaining how to create reports including a template. https://www.youtube.com/watch?v=IcyZbjcs-sE&t=3s

Re: OCUM 7.1 Custom Reports

CompressionQuic — Thu, 18 May 2017 19:28:07 GMT

Hallo,

thank for creating this Great Clip! May I ask you to Share the link for the Template file again? The Provided Link Seems to be Not valid Anemone. Thanks in advance.

regards

Matthias

Re: OCUM 7.1 Custom Reports

rolfh — Fri, 19 May 2017 06:01:31 GMT

The link to the template should still be valid: https://dl.dropboxusercontent.com/u/324207336/Netapp/OCUMTemplate.rptdesign.

Regards, Rolf

Re: OCUM 7.1 Custom Reports

Mike_Pedigo — Mon, 09 Oct 2017 22:31:10 GMT

Got it to work at the following link which was on the YouTube video:

https://www.youtube.com/redirect?q=https%3A%2F%2Fwww.dropbox.com%2Fs%2F1w2w9sfcbsrkqv9%2FOCUMTemplate.rptdesign%3Fdl%3D0&redir_token=Ot613qe1XunLlYz8pgZF4TgEytx8MTUwNzY3NDMwN0AxNTA3NTg3OTA3&event=video_description&v=IcyZbjcs-sE

Re: OCUM 7.1 Custom Reports

Dhiman — Thu, 12 Oct 2017 06:09:47 GMT

Hi,

Please use the TR: https://www.netapp.com/us/media/tr-4565.pdf as a guide for building your custom reports. The TR guides you through creating a custom report with some examples.

Hope this helps.

Thanks,

Dhiman

Re: OCUM 7.1 Custom Reports

udo_braunschweiger — Thu, 30 Nov 2017 12:06:15 GMT

Hello Rolf

do you have an actual link for the file?

I get an error message when in click it!

https://dl.dropboxusercontent.com/u/324207336/Netapp/OCUMTemplate.rptdesign.

Thank you!!

Kind Reagrds Udo

Re: OCUM 7.1 Custom Reports

Mike_Pedigo — Thu, 30 Nov 2017 17:50:56 GMT

The following link works or see my post above: https://www.youtube.com/redirect?q=https%3A%2F%2Fwww.dropbox.com%2Fs%2F1w2w9sfcbsrkqv9%2FOCUMTemplate.rptdesign%3Fdl%3D0&redir_token=Ot613qe1XunLlYz8p...

Re: OCUM 7.1 Custom Reports

gmilazzoitag — Tue, 12 Dec 2017 15:13:25 GMT

Hi!

I think I've followed the instructions with no errors: I've got the connections, I can browse from dataset the categories and so on.
Then I've tested the sample query in the video but my testing preview give me the colums with zero result.

What is going wrong?

Thanks a lot

Re: OCUM 7.1 Custom Reports

rolfh — Fri, 15 Dec 2017 06:30:03 GMT

Hard to say without your query. But If you get all the database fields under available items in the query window, your datasource is set up correctly.

If you get no error but empty fields, you should look at the "join" and "where" statements. If no values return, the error might be there.

Regards,

Rolf

Re: OCUM 7.1 Custom Reports

darraghos — Mon, 08 Oct 2018 15:08:23 GMT

I saw a blog entry this year around a custom appliance that bundled everything you need to create custom reports. Can't find the ref for it but was tentatively due in May 2018 from recollection. I'll have another look.

Re: OCUM 7.1 Custom Reports

Tamas92 — Mon, 01 Apr 2019 11:35:30 GMT

Dear All,

The video was very helpful, thank you!

Is it possible to create report which shows the volume comments? I checked and couldn't find any related object for this.

Can you help me here?

Thanks in advance,

Tamas