DQL Query to list dm_groups in a tree format

JohnSmithMan

Hi guys,

Is there a way to list dm_groups in a tree format using a dql query?

I can list subgroups using that dql query:

Select group_name from dm_group where any i_supergroups_names='mysubgroup'

Now I have this:

Select 'supergroup' as issupergroup, group_name from dm_group where any i_supergroups_names in (select group_name from dm_group where group_name not like 'grp_owner%');

But it can differentiate supergroups and subgroups.

Yes, I tried "describe hierachy dm_group" in samson but that only works with types and groups are objects.

Thanks

DCTM_Guru

Have you tried using group by clause?