This table describes the list of groups in the SAM database of a server (or a PDC). To view groups and user relationships, use the acc_ownership table.
|
Field name |
Data type |
Description |
|
id_snapshot |
number |
snapshots auto-numbering |
|
server_name |
string |
name of the server that owns the group (if the group belongs to a domain, the server_name is the domain name). |
|
group_sid |
string |
group's security identifier (SID) |
|
group_name |
string |
Decorative name of the group. |
|
description |
string |
Short text describing the group. |
|
account_name |
string |
Windows NT full account name that should be used in security relative tables like acc_ownership. |
|
global |
boolean |
True if the group is global or false if the group is local. |
|
|
string |
Currently not used |
To retrieve all the global groups of the domain 'MYDOMAIN', use the following SQL request:
SELECT name , description
FROM groups
WHERE server_name = 'MYDOMAIN' AND global = 1
ORDER BY name