This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Filtering OOTB Capacity Reports

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.

Parents
  • 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!

  • 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?

  • 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'

  • 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 '*:\*'

Reply
  • 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 '*:\*'

Children