Group¶
Group of users or machines
Fields¶
| Field | Type | Description |
|---|---|---|
| AnalysisExtras | xml | Holds additional analysis data |
| Created | datetime2 | Date/Time this group was created in the database |
| CustomField1 | nvarchar | Custom field 1, not used by OctoSAM logic |
| CustomField2 | nvarchar | Custom field 2, not used by OctoSAM logic |
| CustomField3 | nvarchar | Custom field 3, not used by OctoSAM logic |
| CustomField4 | nvarchar | Custom field 4, not used by OctoSAM logic |
| Description | nvarchar | Description of the group |
| DirectoryPath | nvarchar | For groups imported from Active Directory: holds the distinguishedName of the group |
| DirectoryWhenChanged | datetime2 | Date/Time this group was last modified in Active Directory |
| DirectoryWhenCreated | datetime2 | Date/Time this group was created in Active Directory |
| Domain | nvarchar | Domain of the group if provided by the group scanner |
| EntraIdClassification | nvarchar | classification field from Entra ID |
| EntraIdGroupTypes | nvarchar | Entra ID group types list |
| EntraIdId | nvarchar | Entra ID ID |
| EntraIdOnPremisesDomainName | nvarchar | On premises domain name from Entra ID |
| EntraIdOnPremisesLastSyncDateTime | datetime2 | Entra ID on premises last sync date time |
| EntraIdOnPremisesNetbiosName | nvarchar | On premises netbios name of the group from Entra ID |
| EntraIdOnPremisesSamAccountName | nvarchar | On premises SAMAccountName of the group from Entra ID |
| EntraIdOnPremisesSyncEnabled | bit | Entra ID on premises sync enabled flag for this group |
| EntraIdSecurityEnabled | bit | True if this Entra ID group is a security group |
| EntraIdTenantId | uniqueidentifier | Entra ID Tenant ID |
| Error | bit | True if there was an error enumerating the members of this group |
| ErrorMessage | nvarchar | Error message detailing the problem encountered when trying to enumerate the group |
| ExtraData | nvarchar | Extra data collected for documentation of this machine to signature relation |
| GroupingProviderID | bigint | Internal ID that references the GroupingProvider entity (Foreign Key) |
| GroupTypeID | bigint | Internal ID that references the GroupType entity (Foreign Key) |
| Guid | uniqueidentifier | A unique ID that can be used to link to this object from external applications |
| ID | bigint | Internal ID for the Group entity (Primary Key) |
| Keep | bit | If True, existing groups are not deleted even if they are no longer scanned from the same grouping provider. Do not use this flag without consulting OctoSoft first. |
| LastModification | datetime2 | Date/Time this group object was last modified through the UI |
| LastModifiedBy | nvarchar | OctoSAM Inventory UI user that last modified this object |
| LastScan | datetime2 | Date/Time this group was last scanned |
| MachinesNotFoundInDatabase | bigint | Machines not found in either the Machine or DirectoryMissingMachine table. If not 0, check import service logfile for problems. |
| Name | nvarchar | Name of the group |
| Notes | nvarchar | Notes |
| SID | nvarchar | Group SID for groups imported from Active Directory |
| SoftwarePublishing | bit | True if this group is used to configure software publishing |
| UsersNotFoundInDatabase | bigint | Users not found in either the User or DirectoryMissingUser table. If not 0, check import service logfile for problems. |