Netezza resource group ?

Run  _v_group view and apply filter as grorsgpercent<>0 .

Example : Select * from _v_group where grorsgpercent<>0 ;

View "_v_group" will also give you all available group (after removing filter condition )



List of Group and Users in Netezza ?
Run view "_V_GROUPUSERS". This will give you list of all users and corresponding group/s. If user fall under multiple group, it will show all possible combination.