cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Filtering OOTB Capacity Reports

Jump to solution

Hello every one.

I am the Capacity Process manager, along with SolarWinds tool administrator for our agency.

I am needing a capacity forecast report for different IT services in my department. i.e. IT Software deployment Service, IT Access Management Service, IT Backup and Delivery Service, IT Email and Messaging service... theres a couple more.

I already have groups created for each of the services, and have placed the servers that are owned by those services, in their respective groups. (this is just for visual organization, and easy searching)

I also created a custom property called "IT_Service" which then has drop down options in the property for each independent service in our agency. So when a server is created, I can go to the custom property section, and select the group that owns the server I just added.

I would like to send a capacity forecast to each IT Service, but can figure out how to "filter" the resource to get the results I need. It gives an example of "Nodes.City = 'Atlanta'" if I added a custom property named "city" and had it as atlanta. basically what I have is the exact same thing, except I have drop downs for the property vs. just entering in the service manually each time (I did this to prevent typos, different variations of typing out teams, etc)

How do I filter it to have my custom property for IT_Service to get the results I need ?

If someone could help me on this small piece I can get the rest of the report built, ive got a good idea of what needs to happen. I just cant figure out how to manipulate the data, to get the results that I need.

hopefully this all made sense.

0 Kudos
1 Solution
Product Manager
Product Manager

There is a bug in the Top XX Capacity Widget when attempting to filter however there is a workaround.  For example if I were filtering a Top XX Nodes by Response Time widget I may use the following syntax:  IT_Service = 'Service 1'

In the Top XX Capacity Widget, you will need to enter something similar to the following:  1 = 1 WHERE Nodes.CustomProperties.IT_Service = 'Service 1'

Hopefully that helps!

View solution in original post

8 Replies
Product Manager
Product Manager

There is a bug in the Top XX Capacity Widget when attempting to filter however there is a workaround.  For example if I were filtering a Top XX Nodes by Response Time widget I may use the following syntax:  IT_Service = 'Service 1'

In the Top XX Capacity Widget, you will need to enter something similar to the following:  1 = 1 WHERE Nodes.CustomProperties.IT_Service = 'Service 1'

Hopefully that helps!

View solution in original post

How would you go about adding multiple filters.

Traditionally you'd use (Nodes.CustomProperty = 'ABC') OR (Nodes.CustomProperty = 'XYZ').

following that logic i tried: (1 = 1 WHERE Nodes.CustomProperties.IT_Service = 'Service 1') OR (1 = 1 WHERE Nodes.CustomProperties.IT_Service = 'Service 2')

and

1 = 1 (WHERE Nodes.CustomProperties.IT_Service = 'Service 1') OR (WHERE Nodes.CustomProperties.IT_Service = 'Service 2')

and

1 = 1 WHERE (Nodes.CustomProperties.IT_Service = 'Service 1') OR (Nodes.CustomProperties.IT_Service = 'Service 2')

​none of which return the desired results

EDIT: And how would you include a third filter for VolumeType = 'Fixed Disk' following the two custom property filters in the same filter string?

0 Kudos

have you tried the where statement without the parenthesis?

1 = 1 WHERE Nodes.CustomProperties.IT_Service = 'Service 1' OR Nodes.CustomProperties.IT_Service = 'Service 2'

0 Kudos

Thanks, that worked!

Although I am struggling to get the volume type filter added to the end of it.

I have tried the following but it doesn't respect the filter and keeps showing Virtual Memory in the list:

1 = 1 WHERE Nodes.CustomProperties.IT_Service = 'Service 1' OR Nodes.CustomProperties.IT_Service = 'Service 2' AND ForecastCapacity.InstanceCaption LIKE '*:\*'

0 Kudos

Spoke to soon. On closer inspection, the nodes whose CP is Service 2 are not listed!

0 Kudos

How about like this?

1 = 1 WHERE (Nodes.CustomProperties.IT_Service = 'Service 1' OR Nodes.CustomProperties.IT_Service = 'Service 2' AND (ForecastCapacity.InstanceCaption NOT LIKE '*Memory*'))

0 Kudos
Level 8

jblankjblank​ the syntax 1 = 1 WHERE Nodes.CustomProperties.IT_Service = 'Service 1' worked. thank you for that!!! very very helpful

0 Kudos

jblankjblank​ thank you for the response. would you mind explaining this syntax? I am just curious as to how this works.

0 Kudos