How do I create a Dynamic group in USM based on a SQL query

book

Article ID: 103250

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction



Is there an option to configure nis_server or USM to build automatic groups and sub groups based on select from the DB? I have application name for each server in the user_tag_1 attribute, and I want to discover all application and under each application add the relevant servers, and do that for specific Account.

Environment

UIM 9.0 and earlier
UMP 9.0 and Earlier
 

Resolution

You can setup a USM group to create a dynamic group based on a SQL query.
in the filter section the second to last option is SQL.
You can choose this to enter a SQL query for the group.

There is no way to dynamically make groups and subgroups automatically based on a SQL query.