Skip to content

Group

Group of users or machines.

erDiagram
    GroupingProvider ||--o{ Group : "GroupingProviderID"
    GroupType ||--o{ Group : "GroupTypeID"
    Group ||--o{ DirectoryMissingMachineGroup : "GroupID"
    Group ||--o{ DirectoryMissingUserGroup : "GroupID"
    Group ||--o{ EntraIdMissingDeviceGroup : "GroupID"
    Group ||--o{ EntraIdMissingUserGroup : "GroupID"
    Group ||--o{ GroupScanHistory : "GroupID"
    Group ||--o{ MachineGroup : "GroupID"
    Group ||--o{ PublishedSoftwarePackage : "GroupID"
    Group ||--o{ SoftwareItemGroup : "GroupID"
    Group ||--o{ UserGroup : "GroupID"

Fields

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

References

Column Name Referenced Table Description
GroupingProviderID GroupingProvider A uniquely identified source of group information. Used for identification and reorganization (cleanup) of groups.
GroupTypeID GroupType Lookup table for group types

Referenced by

Table Column Name Description
DirectoryMissingMachineGroup GroupID m:n relation Group to DirectoryMissingMachine
DirectoryMissingUserGroup GroupID M:n relation between Group and DirectoryMissingUser tables
EntraIdMissingDeviceGroup GroupID Groups membership of devices that are not yet imported from Entra ID
EntraIdMissingUserGroup GroupID Entra ID group information for users that are not yet imported from Entra ID
GroupScanHistory GroupID Reserved for future use
MachineGroup GroupID m:n relation between machines and groups
PublishedSoftwarePackage GroupID M:n relation between groups and software packages. Used for modelling published applications.
SoftwareItemGroup GroupID Relation between SoftwareItem and Group entities
UserGroup GroupID M:n relation between User and Group tables