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

Document ID : KB000103250
Last Modified Date : 25/06/2018
Show Technical Document Details
Question:
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
 
Answer:
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.