How to use an API call to get free space of all Windows Nodes Volumes

Question

I am currently using Postman and a GET command that successfully returns the "Caption" and "VolumeSpaceAvailable" for all nodes. I use the following statement to do so:

localhost:17778/.../Query Caption, VolumeSpaceAvailable FROM Orion.Volumes

This is great and works, but I'd like to be able to return only my Windows nodes. I've tried things like:

localhost:17778/.../Query Caption, VolumeSpaceAvailable FROM Orion.Volumes WHERE Vendor like 'Microsoft'

But this does not work since this info is pulled FROM Orion.Nodes so it can't access the Vendor info. (Reference here: SolarWinds Information Service v3.0 Schema Documentation Index ) So my question is how do I get info from both Orion.Volumes and Orion.Nodes with my API call?

Thanks!

smoore_gbx · Accepted Answer

Nevermind, got it! Thanks SW SELECT V.Caption,V.VolumeSpaceAvailable, N.Vendor FROM Orion.Volumes V INNER JOIN Orion.Nodes AS N ON V.NodeID = N.NodeID WHERE N.Vendor = 'Windows'

How to use an API call to get free space of all Windows Nodes Volumes

Top Replies