4 Replies Latest reply: Jun 21, 2013 10:30 PM by adaikkap RSS

SQL Query for aggregate / disk reporting issue

christop NetApp Employee Cyclist
Currently Being Moderated

Working with a customer to build some SQL queries for reporting against a DFM 4.0.2 instance. 

 

We are doing query joins for disk, plex, raid group, and aggregate to tie disks back to their aggregates, however about 80 of 300 aggregates not reporting anything due to a break in the chain showing NULL values for plex, RG, or aggr. 

 

Here's the query:

 

select distinct a.aggrid

,o.objName

,a.aggrstoragesystemid

,d.disktype

,p.plexaggrid

,r.rgplexid

            ,d.diskrgid

from aggregateview a

left join objectview o on a.aggrid = o.objid

left join plexview p on a.aggrid = p.plexaggrid

left join raidgroupview r on p.plexid = r.rgplexid

left join diskview d on r.rgid = d.diskrgid

 

Could this be a permissions issue between the DFM host and the host login credentials for each storage system?

 

Any guidance would be welcome.

 

Thanks,

Chris

More Like This

  • Retrieving data ...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points