DFM Reports Portal for non-storage IT

[fabian213]

We've been looking into creating a DFM Reporting Portal. So that the DBA's or Business Analysts can generate their own reports (for their specifc volumes and data), on the fly and without having to ask. DFM can do reports by email, but getting others to open the email, download the zip, unzip, and open the file isn't feasible. We can generate reports via "dfm report view", but the html formart is very incomplete and having to massage the data and add charts via perl isn't something we'd want to jump into.

So far, we have the reports running, and then having a script copy the last modified report to the web folder while changing the name of the report to fit our static link.

Is there a better way to to this? Is there a way to create the reports with static names? Is there a way to generate better html code via "dfm report view" or another cli command (we'd like it to include graphs and such". Is there a way to create read only DFM accounts so that other users can generate reports but not have any control over the FAS units?

Will the next DFM (3.9 or possible 4.0) address any of these topics?

Thanks.

[BrendonHiggins]

Hi

The future of DFM is on this link.

http://communities.netapp.com/message/21891#21891

Bren

[adaikkap]

Have you explored the option of DFM db access ?

If not pls take a look @ the TR

http://media.netapp.com/documents/tr-3690.pdf

Regards

adai

[fabian213]

Thanks, I've looked into using Crystal Reports, but it seems to only pull the Filer ID's and not the Filer names. It does the same thing to volumes and qtrees. Is there a way to have it display the name and not ID?

Thanks.

[shridhar]

To get the required information, you may have to reference 2 or more Views

Example: LUN and corresponding host information can be obtained using ObjectView and lunView.See below listed query

[root@lnx186-48 ~]# dfm database query run "select objectView.objName as LUN,host.objName as hostname,lunView.lunSize from objectView,lunView,objectView host where lunView.lunId=objectView.objId and lunView.lunHostId = host.objId "

"LUN","hostname","lunSize"

"DB_DON_DEL/dfm_db","f3050-200-01","10742215680"

"vol_186_40/lun1","f3050-200-01","53694627840"

Thanks,

Shridhar

[sivar]

Hello Sridhar,
I was able to run your dfm database query from the DFM server and get the results.

How do I run  a similar query from applications like CrystalReports?

I am trying to reference 2 views in Crystal Reports.

Do you have a document or screenshot that could help me to reference 2 views in Crystal Reports?

Does crystal report support the same SQL query that you have given below?

Regards,
Siva Ramanathan

PSE-NetApp Inc

[adaikkap]

I am not an expert in Crystal Reports, but it should have some way to join two db view.

IIRC you can drag columns from two views and create what you need.

regards

adai

[sivar]

Thank you Adai.