DFm report data aggregation

[antonellotisk]

Hi

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

[adaikkap]

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

[antonellotisk]

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

[bipulm]

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

[antonellotisk]

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

[adaikkap]

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