Cool. There's a PS script here to extract data from OCUM DB
https://community.netapp.com/t5/Developer-Network-Articles-and-Resources/Query-OCUM6-Database-using-PowerShell/ta-p/98184
To create a user with read only access to the reporting table. You can use this command line:
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe" -u root -p
CREATE USER 'Read_OCUMdb_For_Scripts'@'%' IDENTIFIED BY 'my_password';
GRANT SELECT ON *.* TO 'Read_OCUMdb_For_Scripts'@'%';
Also adding below some queries i have in one of my reporting scripts
$OntapClusters = Invoke-MySQLQuery -Query "select * from cluster" -ConnectionString $connectionString
$OntapClustersAggregates = Invoke-MySQLQuery -Query "select * from aggregate" -ConnectionString $connectionString
$OntapClustersvolumes = Invoke-MySQLQuery -Query "select * from volume" -ConnectionString $connectionString
$OntapClustersluns = Invoke-MySQLQuery -Query "select * from lun" -ConnectionString $connectionString
$OntapClustersQtrees = Invoke-MySQLQuery -Query "select * from qtree" -ConnectionString $connectionString
$OntapClustersqtreequota = Invoke-MySQLQuery -Query "select * from qtreequota" -ConnectionString $connectionString
Good luck...