I've recently been working on some dashboards, and some of the easy requests turn out to be much harder than I thought.
For example, customer wants a list of all volumes listed by server. I tried the Top Volumes and while that gives the volumes, it doesn't sort things well. A server can be listed multiple times because the Resource wants to sort by the space used per volume. I use a filter like this:
Nodes.Caption like 'ServerName%' and Volumes.Caption not Like '%C:\*%' and Volumes.Caption not Like '%memory%'
Then I try the "All Volumes" Resource, figure this is perfect. Except I cannot get the SQL Filter to work. Many of the examples fail. Trying to filter on the Nodes.Caption seems to be the issue.
So does anyone have an idea of what would work? And why is the syntax different?