Hello,
just hava a look in table “egw_acl”.
All entries with “phpgw_group” as value in the column “acl_appname” are interresting for you.
“SELECT * FROM <i>EGWDATABASE</i>.egw_acl where acl_appname like ‘phpgw_group’”
The relation is:
egw_accounts [account_id] <-1:n-> egw_acl [acl_account]
egw_acl [acl_location] which represents the group_ids
(groups have negative ids and accounts are positive, as you could have already seen in the egw_accounts table.)
PS:
to resolve the (negative) “groupid” (example id is -7) just go back to
egw_accounts and look for the number (NOT negative here, -7 becomes 7) an
you find the “human” groupname under “account_lid”
Jürgen
