For getting performance data, you need to be at least at UM 7.3 and above, this is where we have opened up the Unified Manager DB. For a detailed schema documentaion, you can follow the following guides:
- Unified Manager 7.3 schema documentation:
- Unified Manager 9.4 schema documentation:
Please bear in mind that UM polls every 5 mins for performance. Hence the netapp_performance schema which contains most of the performance tables has suffixes of summary_* or sample_* where:
sample tables have 5 min intervals for 30 days
summary tables are hourly stats which contains 5 min samples rolled upto 1 hour samples and stored for 13 months
I will be releasing a TR soon which has some details on performance usecases along with requisite examples. But the DB schema documentaiton should help you with most of your queries. Hope this helps!