I hope the format above stays like it appears on my screen
At any rate, the closest I've come in identifying the number of disks in an aggregate is looking at the disk group member in the Inventory package, but the aggr name is enclosed within "filer name:/", followed by "/plexX/rgX' number(ex: filer1:/aggr1/plex1/rg0). If this were a scripting language I'd just split by a delimiter;in this case I'd use "/", but I don't yet have enough Cognos-Fu to pull that off, and I'm not sure if that's the appropriate approach here.
Is there a simpler way to count the number of HDDs/SDDs in an aggregate(and know the type? 7200rpm, 10k, SDD)?
Thanks for that. That's a part of OCI I haven't quite grasped. I had used substring method outside of SQL/OCI before but I didn't quite know how to use it here. Anyway, I was able to pull the numbers I needed together(somewhat). I got the HDD count of aggrs. I also got the SDD count for flashpool aggrs, but I can't seem to do an "Or" type of query when I join those two queries together. I've got 9 aggrs and 2 of them are flash pool aggrs. When I join the queries, The only output I get are the 2 aggrs with both types of disks. I guess it makes sense in that the output is something that has data in all the data items, but this seems like an "AND" type of join. I poked around with union and allowing outer-join but that didn't quite do the trick for me.