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
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?
The diskRole field gives the details of the disk role, like data, parity, spare etc. Unfortunately, an unowned disk is never discovered by OCUM or for that matter system manager as well. Only owned disk is reported in case of OCUM and SM as well and aggr can only be created using owned disk.