Skip to content

Organization

Defines the organizations of this OctoSAM installation.

erDiagram
    Organization ||--o{ DirectoryMissingMachine : "OrganizationID"
    Organization ||--o{ DirectoryMissingUser : "OrganizationID"
    Organization ||--o{ LicenseManagerServer : "OrganizationID"
    Organization ||--o{ Machine : "OrganizationID"
    Organization ||--o{ OrganizationToken : "OrganizationID"
    Organization ||--o{ RbacUserOrganization : "OrganizationID"
    Organization ||--o{ RbacUserSelectedOrganization : "OrganizationID"
    Organization ||--o{ SoftwareItemOrganization : "OrganizationID"
    Organization ||--o{ StatisticsSummary : "OrganizationID"
    Organization ||--o{ User : "OrganizationID"

Fields

Field Type Description
CustomField1 string Available for custom data, not used by OctoSAM Inventory
CustomField2 string Available for custom data, not used by OctoSAM Inventory
CustomField3 string Available for custom data, not used by OctoSAM Inventory
CustomField4 string Available for custom data, not used by OctoSAM Inventory
Description string Description
Guid guid Internal unique identifier for this organization that can be used for links from external systems
ID numeric Internal ID for the Organization entity (Primary Key)
LastModification datetime Date/Time this record was last modified through the UI
LastModifiedBy string Client user that last modified this record
Name string Name of the organization
Notes string Custom notes

Referenced by

Table Column Name Description
DirectoryMissingMachine OrganizationID Machines that are in Active Directory but not in the OctoSAM Inventory database. Used to diagnose missing scanner invocation policies.
DirectoryMissingUser OrganizationID Users that are in Active Directory but not in the OctoSAM database. Used to diagnose missing scanner invocation policies.
LicenseManagerServer OrganizationID Defines a license manager server for use by the OctoSAM Monitor module
Machine OrganizationID Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet.
OrganizationToken OrganizationID Defines tokens for organization mapping
RbacUserOrganization OrganizationID This n:m relation table models the RBAC User to Organization Privilege in a way that's easy to integrate into SQL Queries. The information is redundant to the Organization privileges assigned to the user.
RbacUserSelectedOrganization OrganizationID This table contains the per user selected organization for OctoSAM web applications. This selection is used to preselect the organization when the user logs in.
SoftwareItemOrganization OrganizationID M:n SoftwareItem to Organization relation for Items that are linked to specific organizations
StatisticsSummary OrganizationID This table contains summary statistics about the current state of the OctoSAM Inventory installation. It is updated by the OctoSAM Inventory housekeeping process.
User OrganizationID Basic user Information