topic Re: DFm report data aggregation in Active IQ Unified Manager Discussions

DFm report data aggregation

antonellotisk — Thu, 05 Jun 2025 07:12:08 GMT

Is it possible to aggregate data from a scheduled dfm report ?

What I need is a drillable list of groups and relative used and total space,

every line being a group i've defined in DFM tree on the left .

I tried some aggregation with perl but no success..

Query the Sybase Anywhere database has been 'til now very hard to build a custom report for me ..

Any hint?

Thanks

Regards

Antonello

Re: DFm report data aggregation

adaikkap — Tue, 13 Jul 2010 12:30:14 GMT

Did you try accessing the dfm db views feature of DFM 3.7 or latter?

Create a db user and do a dfm database query run on the different views.

The TR below gives details on how to access the db.

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

Section

3.1 SCENARIO 1: ACCESSING DATABASE VIEWS THROUGH DATAFABRIC MANAGER’S COMMAND LINE INTERFACE (CLI).............................................................................................................................................8

Regards

adai

Re: DFm report data aggregation

antonellotisk — Tue, 13 Jul 2010 12:40:04 GMT

Hi Adai

Thanks for the suggestion , yes, i read the document from netapp,

i can browse the database with a user i created as suggested,

but i cannot understand completely what view to query data from,

that's the main issue for me .

Antonello

Re: DFm report data aggregation

bipulm — Tue, 13 Jul 2010 12:57:29 GMT

Hi Antonello,

If you are looking for space related data, then you can query on the following views :

1.dfmgroup.aggregateView

2.dfmgroup.volumeView

3. dfmgroup.qtreeView

4. dfmgroup.userQuota

5.dfmgroup.lunView

6. dfmgroup.diskView

Cn you elaborate what exactly space related data you are looking for.

Thanks,

Bipul

Re: DFm report data aggregation

adaikkap — Tue, 13 Jul 2010 13:13:14 GMT

The database schema for the views and its relationship is documented in the online help.

Which can be accessed from the web-ui as follows.

Control Center-> Help-> General help.

Regards

adai

Re: DFm report data aggregation

antonellotisk — Tue, 13 Jul 2010 13:16:31 GMT

Hi Bipul

What I need is a report including the group name and the space used in each group i've defined in the groups tree at the left of the web dfm interface,

I would like to drill down each group, that includes a variable numer of volumes.

Antonello