#Report specific volume capacity from one vserver?

1 messages · Page 1 of 1 (latest)

haughty shale
#

AIQUM 9.14. I'm trying to create a capacity report for a specific list of volumes, which are all in one vserver.
In this case, it's 16 volumes that a given individual is responsible for.

I can't figure out how to make a save-able View that can then be scheduled as a report.

The volume names do not have a common filter string in their name, so I can't filter on name. I can filter for vserver name (and not the matching SVMDR name) but that gets me hundreds of volumes and filters are only additive, not OR. Yyou can't select the volume ( ✅ ) in the Capacity view to narrow it down that way either.

What I've done is make a Group (Storage Management -> Groups) whose rules pick out the 16 volumes and vserver I need. It then says I have 32 applicable volumes - clicking that [32] gets me a Custom view under Volume Health. (32 = both the desired vserver plus SVMDR, the Group Rules won't filter that)

However you can't save this view, no 💾 save icon in the drop-down.

I've gone through the online docs about views, filters, and reports and I'm not seeing anything else. Do I have in-app options beyond "use the API" or "use SQL directly"?

#

Can't select the Group in the Filter either. Exporting as Excel from the Custom view gives me exactly what I see in-app but re-uploading it gets me nothing.

regal seal
#

Unfortunately groups or annotations are not something you can filter on.

haughty shale
#

as in, are there other AIQUM experts who'd field the ticket and have suggestions?

regal seal
#

There are definitely ways to do it via sql query. REST will be more limited.

Assuming your vserver names are unique

select objid,name from netapp_model_view.vserver;

Retrieve the objid for your vserver.

select objid,name,vserverid from netapp_model_view.volume;

Retrieve your volume object ids.

You can then retrieve all of the data for the 16 volumes using something like the example below with a comma separated list.

select * from netapp_model_view.volume where objid in (229174,232174);
or alternatively

select * from netapp_model_view.volume where objid in (229174,232174) \G

haughty shale
#

That's more involved than we want to do (and then have to maintain), but thanks.

#

I think I'm going to push to do Harvest/NAbox sooner and then maybe we can build our user a dashboard there. That's what he really wants anyway.

#

The web dashboard that was built in-house here years ago is in some way broken and nobody on that team knows how to maintain it (or, doesn't want to / doesn't have time to). Which is why I've been trying to do this "natively."

#

Though I appreciate that the DB query there is fairly straightforward.

white jewel
brisk musk
#

Could also do some trickery with ssh.
Ssh admin@cluster “set -showsep , -unit bytes ; vol show -fields volume,vserver, size, used, avail “ > vols.csv

I suspect the escaping of the , may need to be fixed but I hope you get the idea

Just run the command then play in excel

woeful vault
#

The lack of being able to filter views in AIQUM using annotations is frustrating ... custom powershell to connect to MySQL and run your own queries is the best automation solution we've come up with so far for automatic emailed reports in cases like this. It's frustrating, but is what it is for now