Sort User groups

[mpasha06]

Hi,

I am using MySQL workbench to pull data from zabbix database.

I have pulled out the host group details by using below sql command

select groupid,name from zabbix.groups;

the above command sorted the hostgroups, the same way I was trying to pull the user groups. but getting error.

Could you please anyone provide the how to pull user groulps details from zabbix SQL database.

Thanks.

[coreychristian]

Sorry if I am missing something, but are you just looking for the following?

select * from zabbix.usrgrp;

[mpasha06]

yes, its working fine.Thanks you.

Can we pull data that, which user group are associated with which host group.?

I meen,
user group --> associated --> host group