Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Group Seletion via Dynamic Query against two Object field types??

I have a need to construct a Group based on several object properties from the Volumes and Nodes fields together. It seems that in the Dynamic Query builder, you can only select conditions based on a single field type at a time?? Does anyone see a workaround, or perhaps an alternate way to produce the same group selection??

In this case, I'm trying to generate a group that contains only windows Hard drive volumes that belong to specific classes of device from a specific region. The group will be used to narrow down Volume utilization reports to be delivered to specific IT sub groups.

This is an example of what I'm trying to get my group to select:

From Volumes:

"Volume name" contains "_:\"

From Nodes:

"Region" contains "NAM" (Region is a custom field)

"Device Function" equals "Server" (Device Function is a custom field)

I can select from Volumes or Nodes, but not both..

Find more posts tagged with

Accepted answers

All comments

adeimel

I had the same issue and at least in APM custom fields are not supported. My workaround was to copy the data into one of the unused supported fields within the db manager. Certainly not ideal but got the groups I needed created until they add this type of support.

mmunford

Actually, my question was more about the fact that I could not select matching criteria from multiple criteria types, like a Volume criteria AND an Interface criteria to create the specific group selection I need. My original group selection dynamic query just looked for a custom checkbox I added volumes, but that requires me manually check or uncheck the boxes as servers are removed or added. So it seems that custom fields are actually useable in my case.

The goal of the new Group selection I listed in the first post is to allow the group to dynamically populate the correct target volumes into the group with minimal intervention..

adeimel

I don't disagree with the need for enhancements to the dynamic policies just offering what I've done as a temp workaround until the options we need get added

AlexSoul

bump up! This is my most desirable feature. If anyone has any elegant workarounds - please let me know. All I need is to be able to populate groups with applications, based on node custom properties these applications are attached to

Example: show all applications which are assigned to node where node's custom property "Environment" = 'LIVE'

HolyGuacamole

Alex Soul

I'm not sure about elegant, but a workaround alright.

If you had a Node custom property called NodeTest, you create an Application custom property (say) NodeTestCopy of the same data type. The Node property can have a drop down of values but the Application one need not

Create a SQL Trigger using the following trigger definition and modify the property names in italics as appropriate

CREATE TRIGGER [dbo].[CopyNodeCPtoAppCP]

ON [dbo].[Nodes]

AFTER UPDATE, INSERT

BEGIN

UPDATE APM_ApplicationCustomProperties

SET APM_ApplicationCustomProperties.NodeTestCopy = b.NodeTest

FROM APM_ApplicationCustomProperties a, Nodes b, APM_Application c

WHERE a.ApplicationID=c.ID AND b.NodeID=c.NodeID

END

This trigger will update copy over the Node custom property to all the application monitors on the corresponding node, whenever you update your Node custom property. So, you only need to manage this custom property once. Whenever (in the future) all the node custom properties are made available to select for Application objects as well, it should be an easy change to swap the dynamic query definition and delete this Application custom property & the trigger

p.s: This would fall in the unsupported category for sure, but this one shouldn't cause any issues.

AlexSoul

Thanks HolyGuacamole

very interesting approach, thanks for sharing and for SQL trigger statement. I will be looking at this within the next few weeks to implement.

I only have one slight concern - what happens when I add new application? I think I will just need to remember to update this "NodeTestCopy" field manually... which is obviously prone to inconsistencies and user error

HolyGuacamole

Good point. I didn't think of that.

You can have a second trigger that does the same thing upon updates/inserts to the application monitor table (I will need to browse the database to see the exact table name)

Did I miss covering any other bases?

FormerMember

Did this ever get implemented? I want to add a dynamic query to a group based upon a custom field.

mesverrum

Nope, same as it ever was