Default Layout

Schema Octopus.dbo

Table Annotation

Annotations can be used to store user-defined attributes of a source system with any OctoSAM entity. Not to be used to store system defined attributes of source systems (extend the schema to hold such attributes). Annotations are not used for internal data logic within OctoSAM, but can be referenced in custom queries and reports.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	AnnotationClassID	bigint
*	Type	nvarchar(3)	S for strings, I for numbers, M for Money, B for boolean values, D for dates, C for lookup codes
*	Name	nvarchar(64)	Name of the annotation
*	Description	nvarchar(max)	Description
	Regex	nvarchar(265)	For annotations that can be edited through the GUI, a regular expression that specifies acceptable values.
	MaxValue	decimal(18,2)	For Annotations that can be edited through the GUI the Max Value that can be entered
	MinValue	decimal(18,2)	For Annotations that can be edited through the GUI the Max Value that can be entered
*	Hyperlink	bit DEFAULT 0	If true, value of the field should be rendered as Hyperlink
*	MultiSelect	bit DEFAULT 0	For code Annotations, true if multiple codes can be selected
*	MultiLine	bit DEFAULT 0	If true, the text field supports multiple lines
*	Visible	bit DEFAULT 1	Select if this annotation should be initially visible in queries that reference annotations
*	VisibleInColumnChooser	bit DEFAULT 1	Select if this annotation should be visible in the column chooser in queries that reference annotations. If false and Visible is also false, that annotation will not be displayed in queries.
*	LastModification	datetime2	Date/Time this entity was last mondified
*	LastModifiedBy	nvarchar(128) DEFAULT ''	User that last modified this annotation
*	Created	datetime2	Date/Time this entity was created
*	CreatedGUID	uniqueidentifier	GUID of the scan file that created this annotation
*	SortOrder	int DEFAULT 0	Sort Order of Annotations of the same Class
	Section	nvarchar(64)	Optional section name if a dialog or webpage supports multiple sections of extended attributes
	DefaultValue	nvarchar(max)	Optional default value
	DefaultDecimalValue	decimal(18,2)	Optional default value for numeric annotations
*	WebVisible	bit DEFAULT 1	Visibility of this annotation in web grids
*	CurrencyVisible	bit DEFAULT 1	Default visibility of the currency column for Money fields. Allows to hide the Currency column even though the Money column is visible
Indexes
	PK_Annotation	Primary Key ON ID
	IX_Annotation_AnnotationClassID_Name	Unique Index ON AnnotationClassID, Name
Foreign Key
	FK_Annotation_AnnotationClass	AnnotationClassID ↗ ❏ AnnotationClass(ID)
Referring Foreign Key
	FK_AnnotationLabel_Annotation	ID ↙ ❏ AnnotationLabel(AnnotationID)
	FK_AnnotationProperty_Annotation	ID ↙ ❏ AnnotationProperty(AnnotationID)

Table AnnotationClass

Provides a namespace mechanism to prevent clashes of Annotation names, especially if they are generated from other systems where we cannot control the naming. For example VMWare provides a mechanism for custom attributes that we replicate.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier	A uniqe identifier set by the creator of the annotation. Cannot be changed after creation (Name can be changed). Use the GUID in combination with AnnotatedObjectName when referencing annotations in custom queries.
*	Name	nvarchar(128)	Name of the annotation class
*	Created	datetime2	Date/Time the class was created
*	AnnotatedObjectName	nvarchar(128)	Name of the annotated object (table)
*	DefaultVisible	bit DEFAULT 1	Default visibility in grids for new annotations of this class
*	DefaultVisibleInColumnChooser	bit DEFAULT 1	Default visibility in grids column chooser for new annotations of this class
Indexes
	PK_AnnotationClass	Primary Key ON ID
	IX_AnnotationClass_AnnotatedObject_GUID	Unique Index ON Guid, AnnotatedObjectName
	IX_AnnotationClass_AnnotatedObject_Name	Unique Index ON Name, AnnotatedObjectName
Referring Foreign Key
	FK_Annotation_AnnotationClass	ID ↙ ❏ Annotation(AnnotationClassID)

Table AnnotationCode

Lookup codes for annotations, can be used to provide a list of options for an annotation.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	AnnotationID	bigint
*	Value	nvarchar(50)	Annotation code value
Indexes
	PK_AnnotationSelectCode	Primary Key ON ID
Referring Foreign Key
	FK_AnnotationCodeDisplayName_AnnotationCode	ID ↙ ❏ AnnotationCodeLocalizedDisplayName(AnnotationCodeID)
	FK_AnnotationPropertyAnnotationCode_AnnotationCode	ID ↙ ❏ AnnotationPropertyAnnotationCode(AnnotationCodeID)

Table AnnotationCodeLocalizedDisplayName

Localized names of annotation codes.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	AnnotationCodeID	bigint
*	LanguageID	bigint
*	DisplayName	nvarchar(128)	Localized display name of the code
Indexes
	PK_AnnotationCodeDisplayName	Primary Key ON ID
	IX_AnnotationCodeLocalizedDisplayName_Annotation_Language	Unique Index ON AnnotationCodeID, LanguageID
Foreign Key
	FK_AnnotationCodeDisplayName_AnnotationCode	AnnotationCodeID ↗ ❏ AnnotationCode(ID)
	FK_AnnotationCodeDisplayName_Language	LanguageID ↗ ❏ Language(ID)

Table AnnotationLabel

Language specific labels and other text resources per annotation.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	AnnotationID	bigint
*	LanguageID	bigint
*	Type	nvarchar(3) DEFAULT 'L'	Type of Label. 'L' for labels, 'T' for tooltips
*	Text	nvarchar(max)	Text. Depending on the usage, the text can contain HTML formatting.
Indexes
	PK_AnnotationLabel	Primary Key ON ID
	IX_AnnotationLabel_Annotation_Language_Type	Unique Index ON AnnotationID, LanguageID, Type
Foreign Key
	FK_AnnotationLabel_Annotation	AnnotationID ↗ ❏ Annotation(ID)
	FK_AnnotationLabel_Language	LanguageID ↗ ❏ Language(ID)

Table AnnotationProperty

Keeps per instance storage of annotation.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	AnnotationID	bigint
*	AnnotatedObjectID	bigint	ID of the original item the annotation extends
*	Value	nvarchar(max)	Value in string representation. Must be given for all value types
	DecimalValue	decimal(18,2)	Decimal representation of the value for numeric data
	BooleanValue	bit	Boolean representation of the value for boolean data
*	Created	datetime2	Date/Time this property was created
*	CreatedGUID	uniqueidentifier	GUID of the scan file that created this property
*	LastModification	datetime2	Date/Time this property was last modified (typically this is the import time)
*	LastModifiedBy	nvarchar(128) DEFAULT ''	User that last modified this property for properties that are maintained through UI interaction (Extended Attributes)
	LastScan	datetime2	Date/Time this property was last scanned
	LastScanGUID	uniqueidentifier	GUID of the last scan file
	CurrencyID	bigint
Indexes
	PK_AnnotationProperty	Primary Key ON ID
	IX_AnnotationProperty_AnnotatedObjectID	Index ON AnnotatedObjectID
	IX_AnnotationProperty_AnnotationID	Index ON AnnotationID
Foreign Key
	FK_AnnotationProperty_Annotation	AnnotationID ↗ ❏ Annotation(ID)
	FK_AnnotationProperty_Currency	CurrencyID ↗ ❏ Currency(ID)
Referring Foreign Key
	FK_AnnotationPropertyAnnotationCode_AnnotationProperty	ID ↙ ❏ AnnotationPropertyAnnotationCode(AnnotationPropertyID)

Table AnnotationPropertyAnnotationCode

N:m relation for annotation properties that can have multiple values (multi select).

Idx	Column Name	Definition
*	ID	bigint IDENTITY
*	AnnotationPropertyID	bigint
*	AnnotationCodeID	bigint
Indexes
	PK_AnnotationPropertyAnnotationCode	Primary Key ON ID
	IX_AnnotationPropertyAnnotationCode_UniqueSelection	Unique Key ON AnnotationCodeID, AnnotationPropertyID
	IX_AnnotationPropertyAnnotationCode_AnnotationProperty	Index ON AnnotationPropertyID
Foreign Key
	FK_AnnotationPropertyAnnotationCode_AnnotationCode	AnnotationCodeID ↗ ❏ AnnotationCode(ID)
	FK_AnnotationPropertyAnnotationCode_AnnotationProperty	AnnotationPropertyID ↗ ❏ AnnotationProperty(ID)

Table ApplicationLog

Used by various OctoSAM components to write log messages.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	TimeStamp	datetime2	Date/Time this log entry was created
*	Message	nvarchar(255)	Log message
*	UserName	nvarchar(255)	Client user ID of the process that generated the log message
Indexes
	PK_ApplicationLog	Primary Key ON ID

Table AuditDetail

Application audit table for entities that are manually maintained.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	AuditObjectID	bigint
*	ObjectGuid	uniqueidentifier	The Guid of the audited object
*	ObjectDisplayName	nvarchar(128)	The display name for the audited object. This name can change during the lifetime of the object.
*	Operation	nvarchar(16)	Audited operation
*	User	nvarchar(128)	User that performed the operation
*	ChangeSet	nvarchar(max)	A json document that contains the changed attributes and values
*	Info	nvarchar(max)	A json document that may contain additional information about the audit
*	Created	datetime2	Date/Time the audit was created
Indexes
	PK_AuditLog	Primary Key ON ID
	IX_AuditDetail_Created	Index ON Created
	IX_AuditDetail_ObjectGuid	Index ON ObjectGuid
Foreign Key
	FK_AuditDetail_AuditObject	AuditObjectID ↗ ❏ AuditObject(ID)

Table AuditObject

Lookup table for audit objects.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(128)	Name of the audited object
*	Created	datetime2	Date/Time the item got created
Indexes
	PK_AuditObject	Primary Key ON ID
	IX_AuditObject_Name	Unique Key ON Name
Referring Foreign Key
	FK_AuditDetail_AuditObject	ID ↙ ❏ AuditDetail(AuditObjectID)

Table AutoStartType

Lookup table for auto start configuration types.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	OctopusID	nvarchar(50) COLLATE Latin1_General_CI_AS	OctoSAM internal ID
*	Name	nvarchar(255) COLLATE Latin1_General_CI_AS	AutoStart type name
*	Created	datetime2	Date/Time this item was created
Indexes
	PK_AutoStartType	Primary Key ON ID
Referring Foreign Key
	FK_MachineAutoStart_AutoStartType	ID ↙ ❏ MachineAutoStart(AutoStartTypeID)
	FK_MachineUserAutoStart_AutoStartType	ID ↙ ❏ MachineUserAutoStart(AutoStartTypeID)

Table CatalogUpdateLog

Information about OctoSAM catalog updates and statistics sent to the central update service. The table also keeps a license history and log statistics used for java consolidation projects.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Created	datetime2	Date/time this record was created
*	Machine	nvarchar(50)	Name of machine where the update was executed. Usually the OctoSAM Server machine name.
*	MachineCount	bigint	Number of machines in the inventory at time of update
*	UserCount	bigint	Number of users in the inventory at time of update
*	InstallationGuid	uniqueidentifier	Installation Guid at time of update
*	LicenseUnits	bigint	Number of license units at time of update
*	LicenseGraceUnits	bigint	Number of license grace units
*	LicenseOptions	nvarchar(512)	License Options at time of the update
*	DisplayVersion	nvarchar(50)	OctoSAM display version that did the update
*	BuildVersion	nvarchar(50)	OctoSAM build version that did the update
*	BuildDate	datetime2	OctoSAM build date that did the update
*	LicenseValidThrough	datetime2	License Valid Through Date
*	LicenseReadonlyAfter	datetime2	License read-only date
*	LastCatalogUpdate	datetime2	Date the catalog was last updated
*	CatalogUpdateStatus	nvarchar(16)	Status returned by the central update service
*	CatalogUpdateFileName	nvarchar(255)	File name of the used catalog update file
*	ErrorsLast24Hrs	bigint	Total Number of errors encountered in the last 24 hours
*	IncompleteScanFileErrorsLast24Hrs	bigint DEFAULT 0	Number of incomplete scan file errors in the last 24 hours
*	LicenseManagerServerErrorsLast24Hrs	bigint DEFAULT 0	Number of license manager server errors in the last 24 hours
*	WarningsLast24Hrs	bigint	Number of warnings encountered in the last 24 hours
*	ImportsLast24Hrs	bigint	Number of imported files in the last 24 hours
*	CatalogConflicts	bigint	Number of conflicts encountered during catalog update
*	ServerCount	bigint DEFAULT 0	Number of machines with a server operating system
*	LicenseServerUnits	bigint DEFAULT 0	Number of server license units
*	MachinesDeletedInDirectory	bigint DEFAULT 0	Number of machines that are are found as deleted in active directory
*	ServersDeletedInDirectory	bigint DEFAULT 0	Number of machines with a server operating system that are found as deleted in active directory
*	MacMachineCount	bigint DEFAULT 0	Number of Macs
*	EsxMachineCount	bigint DEFAULT 0	Number of Esx machines
*	LinuxMachineCount	bigint DEFAULT 0	Number of Linux machines
*	WindowsWorkstationCount	bigint DEFAULT 0	Number of Windows workstations
*	WindowsServerCount	bigint DEFAULT 0	Number of Windows servers
*	JavaPackages	bigint DEFAULT 0	Number of different Java software packages
*	JavaInstallations	bigint DEFAULT 0	Total number of found Java installations
*	LicensingRelevantJavaInstallations	bigint DEFAULT 0	Number of found Java installations that require an Oracle license (based on version)
*	ApprovedJavaInstallations	bigint DEFAULT 0	Number of approved Java installations that require an Oracle license
*	OracleJavaMsiInstallations	bigint DEFAULT 0	Number of found Oracle Java installations that seem to have used a commercial .MSI installation that requires an Oracle license.
*	ScannerErrorsLast24Hrs	bigint DEFAULT 0	Number of scanner errors encountered in the last 24 hrs
*	ScannerWarningsLast24Hrs	bigint DEFAULT 0	Number of scanner warnings encountered in the last 24 hrs
Indexes
	PK_CatalogUpdateLog	Primary Key ON ID

Table CloudApp

Cloud Application

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	CloudProviderAccountID	bigint
*	Name	nvarchar(50) COLLATE Latin1_General_CI_AS	Name of the application
*	LastScan	datetime2	Date/Time this application got last scanned
*	Created	datetime2	Date/Time this entity got created
Indexes
	PK_CloudApp	Primary Key ON ID
Foreign Key
	FK_CloudApp_CloudProviderAccount	CloudProviderAccountID ↗ ❏ CloudProviderAccount(ID)
Referring Foreign Key
	FK_CloudAppUsage_CloudApp	ID ↙ ❏ CloudAppUsage(CloudAppID)

Table CloudAppUsage

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	CloudAppID	bigint
*	CloudUserID	bigint
*	Date	date	Usage date as reported by the cloud system
Indexes
	PK_CloudAppUsage	Primary Key ON ID
	IX_CloudAppUsage_Unique	Unique Index ON CloudUserID, CloudAppID, Date
Foreign Key
	FK_CloudAppUsage_CloudApp	CloudAppID ↗ ❏ CloudApp(ID)
	FK_CloudAppUsage_CloudUser	CloudUserID ↗ ❏ CloudUser(ID)

Table CloudProvider

Cloud provider information.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	OctopusID	nvarchar(50)	OctoSAM internal name
*	Name	nvarchar(128)	Cloud provider name
*	Created	datetime2	Date/Time this entity got created
Indexes
	PK_CloudProvider	Primary Key ON ID
Referring Foreign Key
	FK_CloudProviderAccount_CloudProvider	ID ↙ ❏ CloudProviderAccount(CloudProviderID)
	FK_CloudProviderService_CloudProvider	ID ↙ ❏ CloudProviderService(CloudProviderID)
	FK_MailboxProvider_CloudProvider	ID ↙ ❏ MailboxProvider(CloudProviderID)

Table CloudProviderAccount

Cloud provider specific account.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	CloudProviderID	bigint
*	Name	nvarchar(128)	Cloud provider account name
*	Created	datetime2	Date/Time this account record got created
*	CreatedGuid	uniqueidentifier	GUID of the scan that created the account record
*	LastScan	datetime2	Date/Time this account got last scanned
*	LastScanGuid	uniqueidentifier	GUID of the last scan
	EntraIdTenantId	uniqueidentifier	Entra ID tenant id
Indexes
	PK_CloudProviderAccount	Primary Key ON ID
Foreign Key
	FK_CloudProviderAccount_CloudProvider	CloudProviderID ↗ ❏ CloudProvider(ID)
Referring Foreign Key
	FK_CloutProviderAccountLicensingPlang_CloudProviderAccount	ID ↙ ❏ CloudProviderAccountLicensingPlan(CloudProviderAccountID)
	FK_CloudProviderAccountScanHistory_CloudProviderAccount	ID ↙ ❏ CloudProviderAccountScanHistory(CloudProviderAccountID)
	FK_EntraIdMissingDevice_CloudProviderAccount	ID ↙ ❏ EntraIdMissingDevice(CloudProviderAccountID)
	FK_Machine_CloudProviderAccount	ID ↙ ❏ Machine(CloudProviderAccountID)
	FK_User_CloudProviderAccount	ID ↙ ❏ User(CloudProviderAccountID)
	FK_CloudApp_CloudProviderAccount	ID ↙ ❏ CloudApp(CloudProviderAccountID)
	FK_CloudUser_CloudProviderAccount	ID ↙ ❏ CloudUser(CloudProviderAccountID)
	FK_EntraIdMissingUser_CloudProviderAccount	ID ↙ ❏ EntraIdMissingUser(CloudProviderAccountID)

Table CloudProviderAccountLicensingPlan

Cloud provider licensing plan information

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	CloudProviderAccountID	bigint
*	Sku	nvarchar(128)	SKU of the licensing plan
*	FriendlyName	nvarchar(255)	Friendly name, code translation from the SKU if available, SKU otherwise
*	ActiveUnits	bigint	Number of active license units
*	ConsumedUnits	bigint	Number of license units consumed
*	WarningUnits	bigint	Number of license units that are in warning state
*	LockedOutUnits	bigint	Number of locked out license units
*	Created	datetime2	Date/Time this record got created
*	CreatedGuid	uniqueidentifier	GUID of the scan that created this record
*	LastScan	datetime2	Date/Time this account licensing plan got last scanned
*	LastScanGuid	uniqueidentifier	GUID of the last scan
Indexes
	PK_CloutProviderAccountLicensingPlang	Primary Key ON ID
Foreign Key
	FK_CloutProviderAccountLicensingPlang_CloudProviderAccount	CloudProviderAccountID ↗ ❏ CloudProviderAccount(ID)
Referring Foreign Key
	FK_UserCloudProviderAccountLicensingPlan_CloudProviderAccountLicensingPlan	ID ↙ ❏ UserCloudProviderAccountLicensingPlan(CloudProviderAccountLicensingPlanID)
	FK_CloudProviderAccountLicensingPlanHistory_CloudProviderAccountLicensingPlan	ID ↙ ❏ CloudProviderAccountLicensingPlanHistory(CloudProviderAccountLicensingPlanID)

Table CloudProviderAccountLicensingPlanCloudProviderService

N:m relation between licensing plan and service.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	CloudProviderAccountLicensingPlanID	bigint
*	CloudProviderServiceID	bigint
*	ProvisioningStatus	nvarchar(50)	Provider dependend provisioning state
*	Created	datetime2	Date/Time this record got created
*	CreatedGuid	uniqueidentifier	GUID of the scan that created this record
*	LastScan	datetime2	Date/Time this relation got last scanned
*	LastScanGuid	uniqueidentifier	GUID of the scan that last scanned this relation
Indexes
	PK_CloudProviderAccountLicensingPlanCloudProviderService	Primary Key ON ID
Foreign Key
	FK_CloudProviderAccountLicensingPlanCloudProviderService_CloudProviderService	CloudProviderServiceID ↗ ❏ CloudProviderService(ID)
Referring Foreign Key
	FK_UserCloudProviderAccountLicensingPlanCloudProviderService_CloudProviderAccountLicensingPlanCloudProviderService	ID ↙ ❏ UserCloudProviderAccountLicensingPlanCloudProviderService(CloudProviderAccountLicensingPlanCloudProviderServiceID)

Table CloudProviderAccountLicensingPlanHistory

Licensing Plan history information

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	CloudProviderAccountLicensingPlanID	bigint
*	Date	date	Date of the history record
*	Created	datetime2	Date/Time the history record got created
*	ActiveUnits	bigint	Number of active licensing units
*	ConsumedUnits	bigint	Number of consumed licensing units
*	WarningUnits	bigint	Number of licensing units that are in warning state
*	LockedOutUnits	bigint	Number of locked-out licensing units
*	ScanGuid	uniqueidentifier
Indexes
	PK_CloudProviderAccountLicensingPlanHistory	Primary Key ON ID
	IX_CloudProviderAccountLicensingPlanHistory_CloudProviderAccountLicensingPlanID	Index ON CloudProviderAccountLicensingPlanID
	IX_CloudProviderAccountLicensingPlanHistory_Created	Index ON Created
Foreign Key
	FK_CloudProviderAccountLicensingPlanHistory_CloudProviderAccountLicensingPlan	CloudProviderAccountLicensingPlanID ↗ ❏ CloudProviderAccountLicensingPlan(ID)

Table CloudProviderAccountScanHistory

Cloud scan history information.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	CloudProviderAccountID	bigint
*	Scan	datetime2	Date/TIme of the scan
*	Import	datetime2	Date/Time the scanfile got imported
*	ScanGUID	uniqueidentifier	GUID of the scan file
*	Build	nvarchar(65)	Build of the scanner that produced the scan file
Indexes
	PK_CloudProviderAccountScanHistory	Primary Key ON ID
Foreign Key
	FK_CloudProviderAccountScanHistory_CloudProviderAccount	CloudProviderAccountID ↗ ❏ CloudProviderAccount(ID)

Table CloudProviderService

Cloud service information.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	CloudProviderID	bigint
*	Sku	nvarchar(128)	SKU of the service,
*	FriendlyName	nvarchar(255)	Friendly name of the service if available by code translation, SKU otherwise
*	TargetClass	nvarchar(50) DEFAULT ''	Target class of the service
Indexes
	PK_CloudProviderService	Primary Key ON ID
Foreign Key
	FK_CloudProviderService_CloudProvider	CloudProviderID ↗ ❏ CloudProvider(ID)
Referring Foreign Key
	FK_CloudProviderAccountLicensingPlanCloudProviderService_CloudProviderService	ID ↙ ❏ CloudProviderAccountLicensingPlanCloudProviderService(CloudProviderServiceID)

Table CloudUser

Provider specific cloud user information

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	CloudProviderAccountID	bigint
*	UserID	bigint
*	LastActivationDate	datetime2	Last activation date of the user as reported by the cloud provider
*	LastActivityDate	datetime2	Last activity date of the user as reported by the cloud provider
*	LastScan	datetime2	Last activity scan of this cloud user
*	Created	datetime2	Date/Time this cloud user object got created
Indexes
	PK_CloudUser	Primary Key ON ID
	IX_CloudUser_UserID	Index ON UserID
Foreign Key
	FK_CloudUser_CloudProviderAccount	CloudProviderAccountID ↗ ❏ CloudProviderAccount(ID)
	FK_CloudUser_User	UserID ↗ ❏ User(ID)
Referring Foreign Key
	FK_CloudAppUsage_CloudUser	ID ↙ ❏ CloudAppUsage(CloudUserID)

Table Cluster

Cluster information.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier DEFAULT newid()
*	Name	nvarchar(255)	Cluster name.
*	Description	nvarchar(255)	Cluster description
*	Created	datetime2	Date/Time the cluster object got created in the database
*	CreatedGUID	uniqueidentifier	GUID of the scan file that created the cluster object in the database
*	ClusterTypeID	bigint
	DatacenterID	bigint
	MoRef	nvarchar(128)	For VMware clusters, contains the managed object ID (relative to vCenter).
*	LastScan	datetime2	Date/Time time the cluster got scanned last
*	LastScanGuid	uniqueidentifier	GUID of the last scan file that contained information about this cluster
	AnalysisExtras	xml	Holds additional analysis data
	ServiceNowSysID	uniqueidentifier	Service Now: sys_id of replicated object
	ServiceNowTargetClass	nvarchar(128)	Service Now: class of replicated object
	ServiceNowLastExport	datetime2	Date/Time of last export to Service Now
	ServiceNowLastImport	datetime2	Date/Time of last import from Service Now
Indexes
	PK_Cluster	Primary Key ON ID
Foreign Key
	FK_Cluster_ClusterType	ClusterTypeID ↗ ❏ ClusterType(ID)
	FK_Cluster_Datacenter	DatacenterID ↗ ❏ Datacenter(ID)
Referring Foreign Key
	FK_MachineCluster_Cluster	ID ↙ ❏ MachineCluster(ClusterID)

Table ClusterType

Lookup table for cluster types.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	OctopusID	nvarchar(16)	Internal ID of this cluster type. Used by OctoSAM to identify cluster types.
*	Name	nvarchar(50)	Cluster type name to show in the UI
*	Description	nvarchar(200)	Cluster type description
Indexes
	PK_ClusterType	Primary Key ON ID
Referring Foreign Key
	FK_Cluster_ClusterType	ID ↙ ❏ Cluster(ClusterTypeID)

Table Code

Used to translate various encoded values into clear text. An example of codes are numeric WMI status values.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	CodeClassID	bigint
*	Key	nvarchar(255) COLLATE Latin1_General_CI_AS	Name used to reference the code from applications and queries
*	Value	nvarchar(max) COLLATE Latin1_General_CI_AS	Translated code value, useually a friendly name for the code.
Indexes
	PK_Code	Primary Key ON ID
	IX_Code_UniqueKey	Index ON CodeClassID, Key
Foreign Key
	FK_Code_CodeClass	CodeClassID ↗ ❏ CodeClass(ID)

Table CodeClass

Used to translate various encoded values into clear text.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(128)	Code Class Name used to reference the code class from OctoSAM application and queries
Indexes
	PK_CodeToClearTextSection	Primary Key ON ID
Referring Foreign Key
	FK_Code_CodeClass	ID ↙ ❏ Code(CodeClassID)

Table ConfigurationInformation

Holds internal configuration information for various OctoSAM components

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(64)	Name of the configuration parameter
*	Value	nvarchar(max)	Value of the configuration parameter as string. Note that some configuration values cannot be represented in string form.
*	LastModification	datetime2	Last modification of this configruation parameter
	XmlValue	xml	Configuration value of type XML document
	BlobValue	varbinary(max)	Binary configuration value
	DateTimeValue	datetime2	For date/time values, holds the information in database internal format (in addition to the string format in the Value column). This facilitates usage of the value in SQL.
	JsonValue	nvarchar(max)	Configuration value of type JSON element
Indexes
	PK_ConfigurationInformation	Primary Key ON ID
	IX_ConfigurationInformation	Index ON Name

Table ConnectedSystem

Records data about systems connected to OctoSAM

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	ConnectedSystemTypeID	bigint
*	Name	nvarchar(128)	Name of the connected system
	Guid	uniqueidentifier	Guid of the connected system, as provided by the scanner or import logic
*	Description	nvarchar(max)	Description of the connected system
*	Created	datetime2	Date/Time this entity got created
*	LastScan	datetime2	Date/Time the connected system got last scanned
	Res1	nvarchar(50)	Reserved for future use
	Res2	nvarchar(50)	Reserved for future use
	AdditionalData	nvarchar(max)	Optionally contains JSON formatted additional information about the system
Indexes
	PK_ConnectedSystem	Primary Key ON ID
Foreign Key
	FK_ConnectedSystem_ConnectedSystemType	ConnectedSystemTypeID ↗ ❏ ConnectedSystemType(ID)
Referring Foreign Key
	FK_ConnectedSystemHistory_ConnectedSystem	ID ↙ ❏ ConnectedSystemHistory(ConnectedSystemID)

Table ConnectedSystemHistory

History about connected systems. This table is used to control and diagnose connections to systems such as ServiceNow, vCenter etc.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	ConnectedSystemID	bigint
*	Scan	datetime2	Date/Time of the scan
	Users	bigint	User count for this scan if provided by the partner system
	Machines	bigint	Machine count for this scan if provided by the partner system
	VirtualMachines	bigint	Virtual machine count for this scan if provided by the partner system
	Groups	bigint	Group count for this scan if provided by the partner system
	Clusters	bigint	Cluster count for this scan if provided by the partner system
	AdditionalData	nvarchar(max)	Additional data for this scan in JSON format
*	Items	bigint	Total number of items for this scan
*	Warnings	bigint	Warnings during import of this scan
*	Errors	bigint	Errors during import of this scan
*	ImportDurationMillis	bigint	Duratioon of the imoprt operation
	ScanDurationMillis	bigint	Duration of the scan operation if provided by the partner system scanner / interface
	ScanGuid	uniqueidentifier	Guid of the scan that created this item if available
	Filename	nvarchar(255)	Filename of the import if available
Indexes
	PK_ConnectedSystemHistory	Primary Key ON ID
	IX_ConnectedSystemHistory_ConnectedSystem	Index ON ConnectedSystemID
	IX_ConnectedSystemHistory_Scan	Index ON Scan
Foreign Key
	FK_ConnectedSystemHistory_ConnectedSystem	ConnectedSystemID ↗ ❏ ConnectedSystem(ID)

Table ConnectedSystemType

Lookup table for connected system types.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(50)	Connected system type
*	OctopusID	nvarchar(50)	Internal program Id
*	Created	datetime2	Date/Time this entity got created
Indexes
	PK_ConnectedSystemType	Primary Key ON ID
Referring Foreign Key
	FK_ConnectedSystem_ConnectedSystemType	ID ↙ ❏ ConnectedSystem(ConnectedSystemTypeID)

Table CostCenter

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(50) COLLATE Latin1_General_CI_AS	Name of the cost center
*	Descripton	nvarchar(512) COLLATE Latin1_General_CI_AS	Description of the cost center
*	Created	datetime2 DEFAULT getdate()	Date/Time this record was created
	ExtraData	nvarchar(max) COLLATE Latin1_General_CI_AS	Reserved for future use
	CustomField1	nvarchar(255) COLLATE Latin1_General_CI_AS	Available for custom data for this machine, not used by OctoSAM Inventory.
	CustomField2	nvarchar(255) COLLATE Latin1_General_CI_AS	Available for custom data for this machine, not used by OctoSAM Inventory.
	CustomField3	nvarchar(255) COLLATE Latin1_General_CI_AS	Available for custom data for this machine, not used by OctoSAM Inventory.
	CustomField4	nvarchar(255) COLLATE Latin1_General_CI_AS	Available for custom data for this machine, not used by OctoSAM Inventory.
Indexes
	PK_CostCenter	Primary Key ON ID

Table Currency

Lookup table for currencies.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(50)	International currency name
Indexes
	PK_Currency	Primary Key ON ID
Referring Foreign Key
	FK_AnnotationProperty_Currency	ID ↙ ❏ AnnotationProperty(CurrencyID)
	FK_SoftwareItem_InitialCostCurrency	ID ↙ ❏ SoftwareItem(InitialCostCurrencyID)
	FK_SoftwareItem_RecurringCostCurrency	ID ↙ ❏ SoftwareItem(RecurringCostCurrencyID)

Table Datacenter

For VMware virtualization: holds vSphere datacenter information.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier DEFAULT newid()
*	Name	nvarchar(255)	Name of the datacenter
*	Notes	nvarchar(max)	Notes
*	Created	datetime2	Date/Time this datacenter object was created in the database
*	CreatedGUID	uniqueidentifier	GUID of the scan file that created this datacenter
*	LastScan	datetime	Date/Time this datacenter got scanned last
*	LastScanGUID	uniqueidentifier	GUID of the last scan file for this datacenter
*	MoRef	nvarchar(128)	VMWare managed object ID of this datacenter, relative to VCenter - or VirtualizationManagementSystem in the database.
*	VirtualizationManagementSystemID	bigint
	ServiceNowSysID	uniqueidentifier	Service Now: sys_id of the replicated object
	ServiceNowTargetClass	nvarchar(128)	Service Now: class of the replicated object
	ServiceNowLastExport	datetime2	Date/Time of last export to Service Now
	ServiceNowLastImport	datetime2	Date/Time of last import from Service Now
Indexes
	PK_Datacenter	Primary Key ON ID
Foreign Key
	FK_Datacenter_VirtualizationManagementSystem	VirtualizationManagementSystemID ↗ ❏ VirtualizationManagementSystem(ID)
Referring Foreign Key
	FK_Cluster_Datacenter	ID ↙ ❏ Cluster(DatacenterID)
	FK_VirtualMachine_Datacenter	ID ↙ ❏ VirtualMachine(DatacenterID)

Table DirectoryMissingMachine

Machines that are in Active Directory but not in the OctoSAM Inventory database. Used to diagnose missing scanner invocation policies.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	OrganizationID	bigint
*	Name	nvarchar(64)	Machine name
*	DomainName	nvarchar(64)	NETBIOS domain name as specified in the import service configuration
*	PrintableName	nvarchar(128)	Combined attributes to use for display and reports
*	Path	nvarchar(255)	Distinguished name of this machine in Active Directory
*	ContainerPath	nvarchar(255)	Distinguished name of the container of this machine. Provided for grouping and export
*	Description	nvarchar(255)	Description attribute from Active Directory
*	Location	nvarchar(255)	Location attribute from Active Directory
*	LastLogonTimestamp	datetime2	LastLogonTimestam attribute from Active Directory
*	UserAccountControl	bigint	UserAccountControl attribute from Active Directory
*	OperatingSystem	nvarchar(50)	OperatingSystem attribute from Active Directory
*	OperatingSystemVersion	nvarchar(32)	OperatingSystemVersion attribute from Active Directory
*	OperatingSystemServicePack	nvarchar(32)	OperatingSystemServicePack attribute from Active Directory
	OperatingSystemServer	bit	True if a server operating system was detected
	OperatingSystemPublisher	nvarchar(128)	Publisher of the OS. Denormalized from SoftwarePublisher.Name
	OperatingSystemFamily	nvarchar(16)	A short name for the operating system family. WIN for Windows, Linux for Linux, ESX for Vmware ESX etc.
*	Disabled	bit	True if UserAccountControl has the computer account disabled flag set
*	Source	nvarchar(255)	Source from where this computer object was read. Refers to import service configuration.
*	Checked	datetime2	Date/Time this machine was last checked from Active Directory with the database
	Ext1	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	Ext2	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	Ext3	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	Ext4	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	ExtensionAttribute1	nvarchar(255)	From Active Directory
	ExtensionAttribute2	nvarchar(255)	From Active Directory
	ExtensionAttribute3	nvarchar(255)	From Active Directory
	ExtensionAttribute4	nvarchar(255)	From Active Directory
	ExtensionAttribute5	nvarchar(255)	From Active Directory
	ExtensionAttribute6	nvarchar(255)	From Active Directory
	ExtensionAttribute7	nvarchar(255)	From Active Directory
	ExtensionAttribute8	nvarchar(255)	From Active Directory
	ExtensionAttribute9	nvarchar(255)	From Active Directory
	ExtensionAttribute10	nvarchar(255)	From Active Directory
	ExtensionAttribute11	nvarchar(255)	From Active Directory
	ExtensionAttribute12	nvarchar(255)	From Active Directory
	ExtensionAttribute13	nvarchar(255)	From Active Directory
	ExtensionAttribute14	nvarchar(255)	From Active Directory
	ExtensionAttribute15	nvarchar(255)	From Active Directory
	WhenCreated	datetime2	From Active Directory
	WhenChanged	datetime2	From Active Directory
	Guid	uniqueidentifier	Active Directory objectGuid
	AccountExpires	datetime2	From Active Directory
	CustomField1	nvarchar(255)	Available for custom data, not used by OctoSAM Inventory.
	CustomField2	nvarchar(255)	Available for custom data, not used by OctoSAM Inventory.
	CustomField3	nvarchar(255)	Available for custom data, not used by OctoSAM Inventory.
	CustomField4	nvarchar(255)	Available for custom data, not used by OctoSAM Inventory.
*	NoScan	bit DEFAULT 0	If true this machine should not be scanned. It is ignored for scan coverage reporting.
	ExtraData	nvarchar(max)	Extra data for this item. OctoSAM internal.
	EntraIdTenantId	uniqueidentifier	Entra ID tenant id
	MappingTag	nvarchar(255) COLLATE Latin1_General_CI_AS	Reserved for organization mapping
Indexes
	PK_DirectoryMissingMachine	Primary Key ON ID
	IX_DirectoryMissingMachine_Guid	Index ON Guid
	IX_DirectoryMissingMachine_OrganizationID	Index ON OrganizationID
Foreign Key
	FK_DirectoryMissingMachine_Organization	OrganizationID ↗ ❏ Organization(ID)
Referring Foreign Key
	FK_DirectoryMissingMachineGroup_DirectoryMissingMachine	ID ↙ ❏ DirectoryMissingMachineGroup(DirectoryMissingMachineID)

Table DirectoryMissingMachineGroup

m:n relation Group to DirectoryMissingMachine

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	GroupID	bigint
*	DirectoryMissingMachineID	bigint
*	Created	datetime2	Date/Time this relation got created in the database
*	LastScan	datetime2	Date/Time this relation got scanned last
Indexes
	PK_DirectoryMissingMachineGroup	Primary Key ON ID
	IX_DirectoryMissingMachineGroup_MissingMachineGroup	Unique Index ON DirectoryMissingMachineID, GroupID
	IX_DirectoryMissingMachineGroup_DirectoryMissingMachineID	Index ON DirectoryMissingMachineID
	IX_DirectoryMissingMachineGroup_GroupID	Index ON GroupID
Foreign Key
	FK_DirectoryMissingMachineGroup_DirectoryMissingMachine	DirectoryMissingMachineID ↗ ❏ DirectoryMissingMachine(ID)
	FK_DirectoryMissingMachineGroup_Group	GroupID ↗ ❏ Group(ID)

Table DirectoryMissingUser

Users that are in Active Directory but not in the OctoSAM database. Used to diagnose missing scanner invocation policies.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	OrganizationID	bigint
*	LoginName	nvarchar(128) COLLATE Latin1_General_CI_AS	sAMAccountName attribute from Active Directory
*	DomainName	nvarchar(128) COLLATE Latin1_General_CI_AS	NETBIOS domain name as specified in the import service configuration
*	UserPrincipalName	nvarchar(128)	UserPrincipalName attribute from Active Directory
*	PrintableName	nvarchar(128)	Combination of attributes for display and reporting
*	Path	nvarchar(255)	DistinguishedName of this user object in Active Directory
*	ContainerPath	nvarchar(255)	DistinguishedName of this objects container. Provided for grouping and export to other applications.
*	DisplayName	nvarchar(255)	DisplayName attribute from Active Directory
*	Description	nvarchar(255)	Description attribute from Active Directory
*	LastLogonTimestamp	datetime2	LastLogonTimestamp attribute from Active Directory
*	UserAccountControl	bigint	UserAccountControl flag from Active Directory
*	Disabled	bit	True if the UserAccountControl attribute has the disable bit set
*	Source	nvarchar(255)	Source from where this user object was read. Refers to import service configuration.
*	Checked	datetime2	Date/Time this user was last checked from AD to the database
	EmployeeID	nvarchar(64)	EmployeeID attribute from Active Directory
	Department	nvarchar(255)	Department attribute from Active Directory
	DepartmentNumber	nvarchar(64)	DepartmentNumber attribute from Active Directory
	Ext1	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	Ext2	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	Ext3	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	Ext4	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	PhysicalDeliveryOfficeName	nvarchar(128)	PhysicalDeliveryOfficeName attribute from Active Directory
	HomeDirectory	nvarchar(255)	HomeDirectory attribute from Active Directory
	HomeDrive	nvarchar(255)	HomeDrive attribute from Active Directory
	Company	nvarchar(128)	Company attribute from Active Directory
	Title	nvarchar(128)	Title (JobTitle) Attribute from Active Directroy
	Mail	nvarchar(255)	Mail attribute from Active Directory
	ProxyAddresses	nvarchar(255)	ProxyAddresses attribute from Active Directory
	TelephoneNumber	nvarchar(255)	TelephoneNumber attribute from Active Directory
	City	nvarchar(255)	City attribute from Active Directory
	PostalCode	nvarchar(50)	PostalCod attribute from Active Directory
	Street	nvarchar(255)	Street attribute from Active Directory
	StreetAddress	nvarchar(255)	StreetAddress attribute from Active Directory
	ExtensionAttribute1	nvarchar(255)	From Active Directory
	ExtensionAttribute2	nvarchar(255)	From Active Directory
	ExtensionAttribute3	nvarchar(255)	From Active Directory
	ExtensionAttribute4	nvarchar(255)	From Active Directory
	ExtensionAttribute5	nvarchar(255)	From Active Directory
	ExtensionAttribute6	nvarchar(255)	From Active Directory
	ExtensionAttribute7	nvarchar(255)	From Active Directory
	ExtensionAttribute8	nvarchar(255)	From Active Directory
	ExtensionAttribute9	nvarchar(255)	From Active Directory
	ExtensionAttribute10	nvarchar(255)	From Active Directory
	ExtensionAttribute11	nvarchar(255)	From Active Directory
	ExtensionAttribute12	nvarchar(255)	From Active Directory
	ExtensionAttribute13	nvarchar(255)	From Active Directory
	ExtensionAttribute14	nvarchar(255)	From Active Directory
	ExtensionAttribute15	nvarchar(255)	From Active Directory
	PreferredLanguage	nvarchar(16)	PreferredLanguage attribute from Active Directory
	WhenChanged	datetime2	whenChanged information from Active Directory
	WhenCreated	datetime2	whenCreated information from Active Directory
	Guid	uniqueidentifier	objectGuid from Active Directory
	AccountExpires	datetime2	accountExpires from ActiveDirectory
	CustomField1	nvarchar(255)	Available for custom data, not used by OctoSAM Inventory.
	CustomField2	nvarchar(255)	Available for custom data, not used by OctoSAM Inventory.
	CustomField3	nvarchar(255)	Available for custom data, not used by OctoSAM Inventory.
	CustomField4	nvarchar(255)	Available for custom data, not used by OctoSAM Inventory.
*	NoScan	bit DEFAULT 0	If True this user should not be scanned. It is ignored for scan coverage reporting.
	ExtraData	nvarchar(max)	Extra data for this item. OctoSAM internal..
	EntraIdTenantId	uniqueidentifier	Entra ID tenant id
	MappingTag	nvarchar(255) COLLATE Latin1_General_CI_AS	Reserved for organization mapping
	MsDSConsistencyGuid	uniqueidentifier	A unique ID used by Microsoft Entra ID to synchronize user information,
Indexes
	PK_DirectoryMissingUser	Primary Key ON ID
	IX_DirectoryMissingUser_Guid	Index ON Guid
	IX_DirectoryMissingUser_OrganizationID	Index ON OrganizationID
Foreign Key
	FK_DirectoryMissingUser_Organization	OrganizationID ↗ ❏ Organization(ID)
Referring Foreign Key
	FK_DirectoryMissingUserGroup_DirectoryMissingUser	ID ↙ ❏ DirectoryMissingUserGroup(DirectoryMissingUserID)

Table DirectoryMissingUserGroup

M:n relation Group to DirectoryMissingUser tables.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	GroupID	bigint
*	DirectoryMissingUserID	bigint
*	Created	datetime2	Date/Time this relation got created in the database
*	LastScan	datetime2	Date/Time this relation was scanned last
Indexes
	PK_DirectoryMissingUserGroup	Primary Key ON ID
	IX_DirectoryMissingUserGroup_MissingUserGroup	Unique Index ON DirectoryMissingUserID, GroupID
	IX_DirectoryMissingUserGroup_DirectoryMissingUserID	Index ON DirectoryMissingUserID
	IX_DirectoryMissingUserGroup_GroupID	Index ON GroupID
Foreign Key
	FK_DirectoryMissingUserGroup_DirectoryMissingUser	DirectoryMissingUserID ↗ ❏ DirectoryMissingUser(ID)
	FK_DirectoryMissingUserGroup_Group	GroupID ↗ ❏ Group(ID)

Table EntraIdMissingDevice

Devices that we found in Entra ID that have not been scanned

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	CloudProviderAccountID	bigint
*	DisplayName	nvarchar(255) COLLATE Latin1_General_CI_AS	The display name for the device
*	AccountEnabled	bit	True if the account is enabled
	ApproximateLastSignInDateTime	datetime2	Approximate date/time this device last signed in to Entra ID
	ComplianceExpirationDateTime	datetime2	The timestamp when the device is no longer deemed compliant
	DeviceCategory	nvarchar(50) COLLATE Latin1_General_CI_AS	User-defined property set by Intune to automatically add devices to groups and simplify managing devices
	DeviceId	nvarchar(255) COLLATE Latin1_General_CI_AS	Unique identifier set by Entra ID device registration service at the time of registration
	DeviceOwnership	nvarchar(255) COLLATE Latin1_General_CI_AS	Ownership of the device. Set by Intune.
	EnrollmentProfileName	nvarchar(255) COLLATE Latin1_General_CI_AS	Entrollment profile applied to the device
	ExtensionAttribute1	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 1 from Entra ID
	ExtensionAttribute2	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 2 from Entra ID
	ExtensionAttribute3	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 3 from Entra ID
	ExtensionAttribute4	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 4 from Entra ID
	ExtensionAttribute5	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 5 from Entra ID
	ExtensionAttribute6	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 6 from Entra ID
	ExtensionAttribute7	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 7 from Entra ID
	ExtensionAttribute8	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 8 from Entra ID
	ExtensionAttribute9	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 9 from Entra ID
	ExtensionAttribute10	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 10 from Entra ID
	ExtensionAttribute11	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 11 from Entra ID
	ExtensionAttribute12	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 12 from Entra ID
	ExtensionAttribute13	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 13 from Entra ID
	ExtensionAttribute14	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 14 from Entra ID
	ExtensionAttribute15	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension Attribute 15 from Entra ID
*	EntraIdId	nvarchar(50) COLLATE Latin1_General_CI_AS	The unique Entra ID identifier of the device object
	IsCompliant	bit	True if the device complies with Mobile Device Management (MDM) policies
	IsManaged	bit	Ture if the device is managed by Mobile Device Management (MDM) policies
	RawManufacturer	nvarchar(255) COLLATE Latin1_General_CI_AS	Raw manufacturer as imported from Entra ID
	Model	nvarchar(255) COLLATE Latin1_General_CI_AS	Model of the device
	OnPremisesLastSyncDateTime	datetime2	The last time at which the object was synced with the on-premises directory.
	OnPremisesSyncEnabled	bit	True if this device object is synced from an on-premises directory, False if the object was originally synced but is no longer synced; Null if this object has never been synced from an on-premises dictionary.
	OperatingSystem	nvarchar(255) COLLATE Latin1_General_CI_AS	The type of operating System of the device as imported from Entra ID
	OperatingSystemFamily	nvarchar(50) COLLATE Latin1_General_CI_AS	OctoSAM OS family name
	OperatingSystemVersion	nvarchar(50) COLLATE Latin1_General_CI_AS	The version of the operating system on the device
	PhysicalIds	nvarchar(max) COLLATE Latin1_General_CI_AS	Entra ID internal device ids
	ProfileType	nvarchar(50) COLLATE Latin1_General_CI_AS	the profile type of the device
	RegistrationDateTime	datetime2	Date/Time when the device was registered
	SystemLabels	nvarchar(max) COLLATE Latin1_General_CI_AS	List of labels applied to the device
	TrustType	nvarchar(50) COLLATE Latin1_General_CI_AS	Type of the trust for the joined device
	DeviceMetadata	nvarchar(max) COLLATE Latin1_General_CI_AS	Device metadata from Entra ID
	DeviceVersion	bigint	Device version from Entra ID
	MdmAppID	nvarchar(255) COLLATE Latin1_General_CI_AS	MDM Appl ID from Entra ID
	FirstScan	datetime2	Date/Time this device was first imported from Entra ID
	LastScan	datetime2	Date/Time this device was last scanned from Entra ID
	Created	datetime2	Date/Time this device entity got created in OctoSAM
	Ext1	nvarchar(255) COLLATE Latin1_General_CI_AS	Reserved for future use
	Ext2	nvarchar(255) COLLATE Latin1_General_CI_AS	Reserved for future use
	Ext3	nvarchar(255) COLLATE Latin1_General_CI_AS	Reserved for future use
	Ext4	nvarchar(255) COLLATE Latin1_General_CI_AS	Reserved for future use
	CustomField1	nvarchar(255) COLLATE Latin1_General_CI_AS	Site specific custom data, not used by OctoSAM
	CustomField2	nvarchar(255) COLLATE Latin1_General_CI_AS	Site specific custom data, not used by OctoSAM
	CustomField3	nvarchar(255) COLLATE Latin1_General_CI_AS	Site specific custom data, not used by OctoSAM
	CustomField4	nvarchar(255) COLLATE Latin1_General_CI_AS	Site specific custom data, not used by OctoSAM
	Checked	datetime2	DateTime this information was last checked against EntraID
	Source	nvarchar(255) COLLATE Latin1_General_CI_AS	OctoSAM scan source name
*	NoScan	bit	This flag can be set for devices where we know that they should not be scanned by OctoSAM
	ExtraData	nvarchar(max) COLLATE Latin1_General_CI_AS	Reserved for future use
	MappingTag	nvarchar(50) COLLATE Latin1_General_CI_AS	Reserved for future use
Indexes
	PK_EntraIDMissingDevice	Primary Key ON ID
	UK_EntraIdMissingDevice_EntraIdId	Unique Key ON EntraIdId
Foreign Key
	FK_EntraIdMissingDevice_CloudProviderAccount	CloudProviderAccountID ↗ ❏ CloudProviderAccount(ID)

Table EntraIdMissingUser

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	CloudProviderAccountID	bigint
	AboutMe	nvarchar(max) COLLATE Latin1_General_CI_AS	A free-form text entry field for the user to describe themselves
*	AccountEnabled	bit	True if the account is enabled
	Birthday	datetime2	Birthday
	BusinessPhones	nvarchar(255) COLLATE Latin1_General_CI_AS	The telephone numbers of the user
	City	nvarchar(255) COLLATE Latin1_General_CI_AS	The city where the user is located
	CompanyName	nvarchar(255) COLLATE Latin1_General_CI_AS	The name of the company the user is associated with
	Country	nvarchar(128) COLLATE Latin1_General_CI_AS	The country or region where the user is located
	CreatedDateTime	datetime2	Date/Time the user was created in Entra ID
	CreationType	nvarchar(128) COLLATE Latin1_General_CI_AS	Indicates the method through which the user account was created
	DeletedDateTime	datetime2	Date/Time the user was deleted in Entra ID
	Department	nvarchar(128) COLLATE Latin1_General_CI_AS	The name of the department in which the user works
*	DisplayName	nvarchar(255) COLLATE Latin1_General_CI_AS	The name displayed in the address book for the user
	EmployeeHireDate	datetime2	Date/Time when the user was hired or will start work in a future hire
	EmployeeLeaveDateTime	datetime2	Date/Time when the user left or will leave the organization
	EmployeeID	nvarchar(128) COLLATE Latin1_General_CI_AS	The employee identifier assigned to the user by the organization
	EmployeeType	nvarchar(128) COLLATE Latin1_General_CI_AS	Captures enterprise worker type
	ExternalUserState	nvarchar(128) COLLATE Latin1_General_CI_AS	For an external user invited to the tenant using the invitation API, this property represents the invited user's invitation status
	ExternalUserStateChangeDateTime	datetime2	Date/Time for the latest change to the ExternalUserState property
	FaxNumber	nvarchar(128) COLLATE Latin1_General_CI_AS	The fax number of the user
	GivenName	nvarchar(128) COLLATE Latin1_General_CI_AS	The given name (first name) of the user
	HireDate	datetime2	The hire date of the user
*	EntraIdId	nvarchar(128) COLLATE Latin1_General_CI_AS	The Entra ID unique identifier for the user
	JobTitle	nvarchar(128) COLLATE Latin1_General_CI_AS	The user's job title
	LastPasswordChangeDateTime	datetime2	Date/Time this Microsoft Entra user last changed their password or when their password was created
	Mail	nvarchar(128) COLLATE Latin1_General_CI_AS	The SMTP mail address for the user
	MailNickname	nvarchar(128) COLLATE Latin1_General_CI_AS	Mail alias for the user
	MobilePhone	nvarchar(128) COLLATE Latin1_General_CI_AS	The primary cellular telephone number for the user
	MySite	nvarchar(128) COLLATE Latin1_General_CI_AS	The URL for the user's site
	OfficeLocation	nvarchar(128) COLLATE Latin1_General_CI_AS	The office location in the user's place of business
	OnPremisesDistinguishedName	nvarchar(256) COLLATE Latin1_General_CI_AS	Contains the on-premises Active Directory distinguished name or DN. The property is only populated for customers who are synchronizing their on-premises directory to Microsoft Entra ID via Microsoft Entra Connect.
	OnPremisesDomainName	nvarchar(128) COLLATE Latin1_General_CI_AS	Contains the on-premises domainFQDN, also called dnsDomainName synchronized from the on-premises directory
	OnPremisesExtensionAttribute1	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is Extension Attribute 1 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute2	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is Extension Attribute 2 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute3	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is Extension Attribute 3 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute4	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is ExtensionAttribute 4 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute5	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is ExtensionAttribute 5 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute6	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is ExtensionAttribute 6 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute7	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is ExtensionAttribute 7 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute8	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is ExtensionAttribute 8 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute9	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is ExtensionAttribute 9 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute10	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is ExtensionAttribute 10 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute11	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is ExtensionAttribute 11 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute12	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is ExtensionAttribute 12 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute13	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is ExtensionAttribute 13 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute14	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is ExtensionAttribute 14 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesExtensionAttribute15	nvarchar(255) COLLATE Latin1_General_CI_AS	For synchronized users this is ExtensionAttribute 15 from the on-premises Active Directory, for non-synchronized users this can be set from Entra ID admin tools.
	OnPremisesImmutableId	nvarchar(128) COLLATE Latin1_General_CI_AS	This property is used to associate an on-premises Active Directory user account to their Microsoft Entra user object. This property must be specified when creating a new user account in the Graph if you're using a federated domain for the user's userPrincipalName (UPN) property.
	OnPremisesLastSyncDateTime	datetime2	Indicates the last time at which the object was synced with the on-premises directory
	OnPremisesSamAccountName	nvarchar(128) COLLATE Latin1_General_CI_AS	Contains the on-premises samAccountName synchronized from the on-premises directory. The property is only populated for customers who are synchronizing their on-premises directory to Microsoft Entra ID via Microsoft Entra Connect.
	OnPremisesSecurityIdentifier	nvarchar(128) COLLATE Latin1_General_CI_AS	Contains the on-premises security identifier (SID) for the user that was synchronized from on-premises to the cloud
	OnPremisesUserPrincipalName	nvarchar(128) COLLATE Latin1_General_CI_AS	Contains the on-premises userPrincipalName synchronized from the on-premises directory. The property is only populated for customers who are synchronizing their on-premises directory to Microsoft Entra ID via Microsoft Entra Connect.
	PasswordPolicies	nvarchar(128) COLLATE Latin1_General_CI_AS	Specifies password policies for the user. This value is an enumeration with one possible value being DisableStrongPassword, which allows weaker passwords than the default policy to be specified. DisablePasswordExpiration can also be specified. The two may be specified together; for example: DisablePasswordExpiration, DisableStrongPassword.
	PostalCode	nvarchar(128) COLLATE Latin1_General_CI_AS	The postal code for the user's postal address. The postal code is specific to the user's country/region.
	PreferredDataLocation	nvarchar(255) COLLATE Latin1_General_CI_AS	The preferred data location for the user.
	RefreshTokensValidFromDateTime	datetime2	Any refresh tokens or sessions tokens (session cookies) issued before this time are invalid, and applications get an error when using an invalid refresh or sessions token to acquire a delegated access token (to access APIs such as Microsoft Graph). If this happens, the application needs to acquire a new refresh token by requesting the authorized endpoint.
	SecurityIdentifier	nvarchar(128) COLLATE Latin1_General_CI_AS	Security identifier (SID) of the user, used in Windows scenarios.
	LastSignInDateTime	datetime2	Date/Time this user last signed in to Entra ID. Not available for some Entra ID license types.
	LastSignInRequestId	nvarchar(255) COLLATE Latin1_General_CI_AS	Request Id of the user's last sign in to Entra ID
	LastNonInteractiveSignInDateTime	datetime2	Date/Time of last non-interactive sign in to Entra ID. Not available for some Entra ID license types.
	LastNonInteractiveSignInRequestId	nvarchar(255) COLLATE Latin1_General_CI_AS	Request Id of the user's last non-interactive sign in to Entra ID
	SignInSessionsValidFromDateTime	datetime2	Any refresh tokens or sessions tokens (session cookies) issued before this time are invalid, and applications get an error when using an invalid refresh or sessions token to acquire a delegated access token (to access APIs such as Microsoft Graph). If this happens, the application needs to acquire a new refresh token by requesting the authorized endpoint.
	State	nvarchar(128) COLLATE Latin1_General_CI_AS	The state or province in the user's address
	StreetAddress	nvarchar(512) COLLATE Latin1_General_CI_AS	The street address of the user's place of business
	Surname	nvarchar(128) COLLATE Latin1_General_CI_AS	The user's surname (family name or last name)
	UsageLocation	nvarchar(16) COLLATE Latin1_General_CI_AS	A two-letter country code (ISO standard 3166). Required for users that are assigned licenses due to legal requirements to check for availability of services in countries. Examples include: US, JP, and GB.
	UserPrincipalName	nvarchar(128) COLLATE Latin1_General_CI_AS	The user principal name (UPN) of the user. The UPN is an Internet-style sign-in name for the user based on the Internet standard RFC 822. By convention, this should map to the user's email name. The general format is alias@domain, where the domain must be present in the tenant's collection of verified domains. This property is required when a user is created. The verified domains for the tenant can be accessed from the verifiedDomains property of organization.
	UserType	nvarchar(128) COLLATE Latin1_General_CI_AS	A string value that can be used to classify user types in your directory, such as Member and Guest.
	FirstScan	datetime2	Date/Time this Entra ID user was first scanned by OctoSAM
	LastScan	datetime2	Date/Time this Entra ID user was first scanned by OctoSAM
	Created	datetime2	Date/Time this entity was created in OctoSAM Inventory
	Checked	datetime2	Date/Time this entity was last checked against Entra ID
	Source	nvarchar(255) COLLATE Latin1_General_CI_AS	OctoSAM scan source name
	NoScan	bit DEFAULT 0	If true, this user should be excluded from scanning.
	ExtraData	nvarchar(max) COLLATE Latin1_General_CI_AS	Reserved for future use
	MappingTag	nvarchar(50) COLLATE Latin1_General_CI_AS	Reserved for future use
	OnPremisesSyncEnabled	bit	true if this user object is currently being synced from an on-premises Active Directory (AD); otherwise the user isn't being synced and can be managed in Microsoft Entra ID.
	PreferredLanguage	nvarchar(50) COLLATE Latin1_General_CI_AS	The preferred language for the user. The preferred language format is based on RFC 4646. The name is a combination of an ISO 639 two-letter lowercase culture code associated with the language and an ISO 3166 two-letter uppercase subculture code associated with the country or region. Example: "en-US", or "es-ES".
	CustomField1	nvarchar(255) COLLATE Latin1_General_CI_AS	Field reserved for customer-specific data. Not used by OctoSAM.
	CustomField2	nvarchar(255) COLLATE Latin1_General_CI_AS	Field reserved for customer-specific data. Not used by OctoSAM.
	CustomField3	nvarchar(255) COLLATE Latin1_General_CI_AS	Field reserved for customer-specific data. Not used by OctoSAM.
	CustomField4	nvarchar(255) COLLATE Latin1_General_CI_AS	Field reserved for customer-specific data. Not used by OctoSAM.
	Ext1	nvarchar(255) COLLATE Latin1_General_CI_AS	Reserved for future use
	Ext2	nvarchar(255) COLLATE Latin1_General_CI_AS	Reserved for future use
	Ext3	nvarchar(255) COLLATE Latin1_General_CI_AS	Reserved for future use
	Ext4	nvarchar(255) COLLATE Latin1_General_CI_AS	Reserved for future use
Indexes
	PK_EntraIdMissingUser	Primary Key ON ID
	UK_EntraIdMissingUser_EntraIdId	Unique Key ON EntraIdId
Foreign Key
	FK_EntraIdMissingUser_CloudProviderAccount	CloudProviderAccountID ↗ ❏ CloudProviderAccount(ID)

Table File

Contains collected files per machine.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	FileTypeID	bigint
*	Filename	nvarchar(512)	File name
*	Path	nvarchar(512)	Original full path of the file
*	LastWriteTime	datetime2	Last write time of the file
*	LastAccessTime	datetime2	Last access time of the file
*	CreationTime	datetime2	CreationTime of the file
*	Data	varbinary(max)	File data
Indexes
	PK_Files	Primary Key ON ID
	IX_Files_MachineID	Index ON MachineID
Foreign Key
	FK_File_FileType	FileTypeID ↗ ❏ FileType(ID)
	FK_File_Machine	MachineID ↗ ❏ Machine(ID)

Table FileType

Lookup table for collected file types.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(50)	Name of the FileType
*	OctopusID	nvarchar(16)	Octopus internal Name of the FileType
*	Description	nvarchar(128)	Description of the FileType
Indexes
	PK_FileType	Primary Key ON ID
Referring Foreign Key
	FK_File_FileType	ID ↙ ❏ File(FileTypeID)

Table Group

Group of users or machines

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	GroupTypeID	bigint
*	GroupingProviderID	bigint
*	Name	nvarchar(255)	Name of the group
*	Domain	nvarchar(50)	Domain of the group if provided by the group scanner
*	DirectoryPath	nvarchar(255)	For groups imported from Active Directory: holds the distinguishedName of the group
*	Description	nvarchar(500)	Description of the group
*	Keep	bit DEFAULT 0	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.
*	UsersNotFoundInDatabase	bigint DEFAULT 0	Users not found in either the User or DirectoryMissingUser table. If not 0, check import service logfile for problems.
*	MachinesNotFoundInDatabase	bigint DEFAULT 0	Machines not found in either the Machine or DirectoryMissingMachine table. If not 0, check import service logfile for problems.
*	Created	datetime2	Date/Time this group was created in the database
*	LastScan	datetime2	Date/Time this group was last scanned
*	LastModification	datetime2	Date/Time this group object was last modified through the UI
*	LastModifiedBy	nvarchar(128)	OctoSAM Inventory UI user that last modified this object
*	Notes	nvarchar(max)	Notes
	SID	nvarchar(200)	Group SID for groups imported from Active Directory
	DirectoryWhenCreated	datetime2	Date/Time this group was created in Active Directory
	DirectoryWhenChanged	datetime2	Date/Time this group was last modified in Active Directory
*	Error	bit DEFAULT 0	True if there was an error enumerating the members of this group
	ErrorMessage	nvarchar(max)	Error message detailing the problem encountered when trying to enumerate the group
*	Guid	uniqueidentifier DEFAULT newid()	A unique ID that can be used to link to this object from external applications
	AnalysisExtras	xml	Holds additional analysis data
	ExtraData	nvarchar(max)	Extra data collected for documentation of this machine to signature relation
	SoftwarePublishing	bit	True if this group is used to configure software publishing
	EntraIdId	nvarchar(128) COLLATE Latin1_General_CI_AS	Entra ID ID
	EntraIdTenantId	uniqueidentifier	Entra ID Tenant ID
	EntraIdClassification	nvarchar(128) COLLATE Latin1_General_CI_AS	classification field from Entra ID
	EntraIdOnPremisesDomainName	nvarchar(128) COLLATE Latin1_General_CI_AS	On premises domain name from Entra ID
	EntraIdOnPremisesLastSyncDateTime	datetime2	Entra ID on premises last sync date time
	EntraIdOnPremisesNetbiosName	datetime2	On premises netbios name of the group from Entra ID
	EntraIdOnPremisesSamAccountName	datetime2	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
	EntraIdGroupTypes	nvarchar(128) COLLATE Latin1_General_CI_AS	Entra ID group types list
	CustomField1	nvarchar(255) COLLATE Latin1_General_CI_AS	Custom field 1, not used by OctoSAM logic
	CustomField2	nvarchar(255) COLLATE Latin1_General_CI_AS	Custom field 2, not used by OctoSAM logic
	CustomField3	nvarchar(255) COLLATE Latin1_General_CI_AS	Custom field 3, not used by OctoSAM logic
	CustomField4	nvarchar(255) COLLATE Latin1_General_CI_AS	Custom field 4, not used by OctoSAM logic
Indexes
	PK_Group	Primary Key ON ID
	UK_Group_Guid	Unique Key ON Guid
Foreign Key
	FK_Group_GroupType	GroupTypeID ↗ ❏ GroupType(ID)
	FK_Group_GroupingProvider	GroupingProviderID ↗ ❏ GroupingProvider(ID)
Referring Foreign Key
	FK_DirectoryMissingMachineGroup_Group	ID ↙ ❏ DirectoryMissingMachineGroup(GroupID)
	FK_DirectoryMissingUserGroup_Group	ID ↙ ❏ DirectoryMissingUserGroup(GroupID)
	FK_GroupScanHistory_Group	ID ↙ ❏ GroupScanHistory(GroupID)
	FK_MachineGroup_Group	ID ↙ ❏ MachineGroup(GroupID)
	FK_PublishedSoftwarePackage_Group	ID ↙ ❏ PublishedSoftwarePackage(GroupID)
	FK_UserGroup_Group	ID ↙ ❏ UserGroup(GroupID)

Table GroupScanHistory

Reserved for future use.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	GroupID	bigint
*	Scan	datetime2	Date/Time of the scan
*	Import	datetime2	Date/Time of the import of the scan file
*	ScanGUID	uniqueidentifier	GUID of the scan file
*	Build	nvarchar(64)	Build information about the scanner that did this group scan
Indexes
	PK_GroupScanHistory	Primary Key ON ID
	IX_GroupScanHistory_GroupID	Index ON GroupID
Foreign Key
	FK_GroupScanHistory_Group	GroupID ↗ ❏ Group(ID)

Table GroupType

Lookup table for group types.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(50)	Group type name
*	OctopusID	nvarchar(16)	Internal ID of this group type. Used by the OctoSAM logic to identify group types.
*	Description	nvarchar(250)	Description
*	PublishedSoftware	bit DEFAULT 0	True if groups of this type are used for software publishing or usage permission
Indexes
	PK_GroupType	Primary Key ON ID
	IX_GroupType_OctopusID	Unique Index ON OctopusID
Referring Foreign Key
	FK_Group_GroupType	ID ↙ ❏ Group(GroupTypeID)

Table GroupingProvider

A uniquely identified source of group information. Used for identification and reorganization (cleanup) of groups.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	DisplayName	nvarchar(255)	Name that the GUI displays
*	ProviderGUID	uniqueidentifier	A uuid that uniquely identifies the grouping provider. Must be set to a distinct value for each provider.
*	Description	nvarchar(255)	Description
*	Notes	nvarchar(max)	Notes
*	Created	datetime2	Date/Time this entity was created in the database
*	LastScan	datetime2	Date/Time this grouping provider did last scan its source information
*	CreatedGUID	uniqueidentifier	GUID of the scan that created this grouping privider
*	LastScanGUID	uniqueidentifier	GUID of the last scan this grouping provider
Indexes
	PK_GroupingProvider	Primary Key ON ID
Referring Foreign Key
	FK_Group_GroupingProvider	ID ↙ ❏ Group(GroupingProviderID)
	FK_GroupingProviderScanHistory_GroupingProviderScanHistory	ID ↙ ❏ GroupingProviderScanHistory(GroupingProviderID)

Table GroupingProviderScanHistory

Scan history of a grouping provider.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	GroupingProviderID	bigint
*	Scan	datetime2	Date/Time this group scan was produced
*	Import	datetime2	Date/Time the scan file was imported (different from Scan for offline capable scanners)
*	ScanGUID	uniqueidentifier	GUID of the scan
*	Build	nvarchar(64)	Scanner technical build information
Indexes
	PK_GroupingProviderScanHistory	Primary Key ON ID
Foreign Key
	FK_GroupingProviderScanHistory_GroupingProviderScanHistory	GroupingProviderID ↗ ❏ GroupingProvider(ID)

Table Image

Reserved for future use.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier
*	Image	varbinary(max)	The binary image
*	Created	datetime2	Date/Time this entity got created in the database
*	LastModification	datetime2	Date/Time this entity got last modified
Indexes
	PK_Image	Primary Key ON ID
	UK_Image_Guid	Unique Key ON Guid

Table ImportControl

Holds the GUIDs of all imported .scan files. This helps to eliminate duplicate imports of the same data, which could influence for example the usage metering information. The table can also be used to collect information about active scanner versions and history.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	ImportGUID	uniqueidentifier	GUID of the imported .scan file.
*	LastModification	datetime2	Date/Time of last write to this entity
*	Error	bit DEFAULT 0	True if the .scan file could not be imported properly. It will be moved to the archive/bad folder structure.
*	LastScan	datetime2	Date/Time of the scan (time from the scanned system - clock may be out of sync with global time)
	LastScanDate	date	Date part of the LastScan field
	OctoscanBuildInfo	nvarchar(128)	Build info about the octoscan2 version that generated the .scan file.
	ImportFolderID	bigint	Can be Null if import was before version 1.9.2
	UserID	bigint	Can be Null if the user was deleted from the database, or if the scan did not provide user information.
	MachineID	bigint	Can be Null if the machine was deleted from the database, or if the scan did not provide machine information.
	Tag	nvarchar(64)	Tag value to identifiy the scanner instance. Can be configured per scanner.
	ScanType	nvarchar(16)	Internal ID to identify different types of scans
	Encoding	nvarchar(16)	XML Encoding of the imported file
	WindowsCodePage	int	Windows Code Page of the imported file
	ContainsUalData	bit	True if the scan contains UAL data
	ContainsMeteringData	bit	True if the scan contains Metering data
	ContainsWmiData	bit	True if the scan contains WMI (Hardware and Configuration) data
	ContainsVirtualizationHostData	bit	True if the scan contains information from a virtualization host
	ContainsVirtualizationGuestData	bit	True if the scan contains information about a virtualization guest
	OctoSAMBuildInfo	nvarchar(128) COLLATE Latin1_General_CI_AS	Scanner build information
	RuntimeInfo	nvarchar(128) COLLATE Latin1_General_CI_AS	Scanner runtime information
Indexes
	PK_ImportControl	Primary Key ON ID
	IX_ImportControl_ImportGUID	Unique Index ON ImportGUID
	IX_ImportControl_LastScan	Index ON LastScan
	IX_ImportControl_LastScanDate	Index ON LastScanDate
	IX_ImportControl_MachineID	Index ON MachineID
	IX_ImportControl_UserID	Index ON UserID
Foreign Key
	FK_ImportControl_ImportFolder	ImportFolderID ↗ ❏ ImportFolder(ID)
	FK_ImportControl_Machine	MachineID ↗ ❏ Machine(ID)
	FK_ImportControl_User	UserID ↗ ❏ User(ID)
Referring Foreign Key
	FK_ImportControlMessage_ImportControl	ID ↙ ❏ ImportControlMessage(ImportControlID)

Table ImportControlMessage

Messages generated by the scanner

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	ImportControlID	bigint
*	SequenceNumber	int	Order in wich the messages were read from the .scan file.
*	MessageID	int DEFAULT 0	Unique message id defined by the scanner
*	Severity	nchar(1)	E for Error, W for Warning.
*	Message	nvarchar(512)	Message generated by the scanner
Indexes
	PK_ImportControlMessage	Primary Key ON ID
	IX_ImportControlMessage_ImportControlID	Index ON ImportControlID
Foreign Key
	FK_ImportControlMessage_ImportControl	ImportControlID ↗ ❏ ImportControl(ID)

Table ImportFolder

Infomation about import folders. Used for statistics and investigation for installations that have multiple import folders.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Path	nvarchar(256)	Import Folder Path
Indexes
	PK_ImportFolder	Primary Key ON ID
Foreign Key
	FK_ImportFolder_ImportFolder	ID ↗ ❏ ImportFolder
Referring Foreign Key
	FK_ImportControl_ImportFolder	ID ↙ ❏ ImportControl(ImportFolderID)
	FK_ImportFolder_ImportFolder	ID ↙ ❏ ImportFolder

Table InformationSource

Defines different information sources in the case that different scanners update information for the same machine.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	OctopusID	nvarchar(16)
*	Name	nvarchar(255)	Information source name
Indexes
	PK_InformationSource	Primary Key ON ID
	IX_InformationSource_OctopusID	Unique Key ON OctopusID
Referring Foreign Key
	FK_MachineSoftwareSignature_InformationSource	ID ↙ ❏ MachineSoftwareSignature(InformationSourceID)
	FK_MachineUserSoftwareSignature_InformationSource	ID ↙ ❏ MachineUserSoftwareSignature(InformationSourceID)
	FK_WmiInstance_InformationSource	ID ↙ ❏ WmiInstance(InformationSourceID)
	FK_WmiInstanceHistory_InformationSource	ID ↙ ❏ WmiInstanceHistory(InformationSourceID)

Table Language

Lookup table for languages.

Idx	Column Name	Definition	Description
*	ID	bigint
*	Code	nvarchar(3)	2 letter language code
*	Name	nvarchar(50)	language name
Indexes
	PK_Language	Primary Key ON ID
Referring Foreign Key
	FK_AnnotationCodeDisplayName_Language	ID ↙ ❏ AnnotationCodeLocalizedDisplayName(LanguageID)
	FK_AnnotationLabel_Language	ID ↙ ❏ AnnotationLabel(LanguageID)

Table LicenseManagerRbacUserFavoriteFeature

User specific selection of favorite license manager features to display.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	RbacUserID	bigint
*	LicenseManagerServerFeatureID	bigint
*	SortOrder	int	OctoSAM Inventory sorts favorite features in ascending sort order by default
*	LastModified	datetime2	Date/Time this entity was last modified
Indexes
	PK_LicenseManagerRbacUserFavoriteFeature	Primary Key ON ID
	UK_LicenseManagerRbacUserFavoriteFeature_RbacUserLicenseManagerServerFeature	Unique Key ON RbacUserID, LicenseManagerServerFeatureID
	IX_LicenseManagerRbacUserFavoriteFeature_LicenseManagerServerFeature	Index ON LicenseManagerServerFeatureID
	IX_LicenseManagerRbacUserFavoriteFeature_RbacUser	Index ON RbacUserID
Foreign Key
	FK_LicenseManagerRbacUserFavoriteFeature_RbacUser	RbacUserID ↗ ❏ RbacUser(ID)
	FK_LicensenManagerRbacUserFavoriteFeature_LicensenseManagerRbacUserFavoriteFeature	LicenseManagerServerFeatureID ↗ ❏ LicenseManagerServerFeature(ID)

Table LicenseManagerServer

Defines a license manager server for use by the OctoSAM Monitor module.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	DisplayName	nvarchar(128)	Name of the LicenseManagerServer object that gets displayed in the UI
*	LmType	nvarchar(32) DEFAULT 'FlexLM'	LicenseMangerServer type
*	Address	nvarchar(512) COLLATE Latin1_General_CI_AS DEFAULT ''	Address of the remote server. Format of this value is specific to each LmType.
*	Parameters	nvarchar(512) DEFAULT ''	Reserved for future use
*	LicenseFileName	nvarchar(1024) DEFAULT ''	License filename as reported by FlexLM
*	Enabled	bit DEFAULT 0	If True, the server gets scanned. Set this flag to false to temporarily disable scanning of this server.
*	OrganizationID	bigint
*	ScanDue	datetime2 DEFAULT getdate()	Date/Time the next statistics scan should take place
*	IntervalMinutes	bigint DEFAULT 15	Interval between scans during normal usage periods
*	Created	datetime2 DEFAULT getdate()	Date/Time this entity got created in the database
*	CreatedBy	nvarchar(50) DEFAULT ''	Client user that created this entity through the UI
*	LastModification	datetime2 DEFAULT getdate()	Date/Time this record was last modified through the UI. Modifications from the scanner do not update this value.
*	LastModifiedBy	nvarchar(128) DEFAULT ''	Client user that modified this entry through the UI
*	Notes	nvarchar(512) DEFAULT ''	Customers notes about this server
*	KeepFeatureStatisticsDays	bigint DEFAULT 720	Number of days that statistics data should be kept
*	KeepUserStatisticsDays	bigint DEFAULT 180	Number of days that detailed user data should be kept
	LastScan	datetime2	Date/Time this server was scanned last
	FirstScan	datetime2	Date/Time this server was scanned first
*	ErrorFlag	bit DEFAULT 0	True if the last scan resulted in an error condition
	LastError	datetime2	Date/Time last scan resulted in an error condition
*	LastErrorMessage	nvarchar(512) DEFAULT ''	Last error message generated from a scan of this server
	LastSuccessfulScan	datetime2	Date/Time the last successful scan occured
*	LastScanDurationMillis	bigint DEFAULT 0	Duration of the last scan in milliseconds
*	HighUsageIntervalMinutes	bigint DEFAULT 1	Interval between scans during high usage periods
*	HighUsageThreshold	float DEFAULT 0.85	Highest usage factor on any feature that defines a period of high usage (between 0 and 1)
*	LowUsageIntervalMinutes	bigint DEFAULT 20	Interval between scans during periods of low usage
*	LowUsageThreshold	float DEFAULT 0.25	Highest usage factor on any feature that defines a period of low usage (between 0 and 1)
*	DiagScanDue	datetime2 DEFAULT getdate()	Date/Time the next diagnostics scan should take place
*	DiagIntervalHours	bigint DEFAULT 24	Interval for diagnostics scans
*	UserStatisticsEnabled	bit DEFAULT 0	True if detailed user statistics are enabled for this Server
*	FeatureLicenseStartEnabled	bit DEFAULT 0	True if the license server supports scan of license start date
*	DenialScanEnabled	bit DEFAULT 0	True if the license server supports scan of license denials
*	DiagScanEnabled	bit DEFAULT 0	True if the license server supports diagnostic scans
*	FeatureLicenseExpiryEnabled	bit DEFAULT 0	True if the license server supports scan of license expiry date
*	LastUsageLevel	int DEFAULT 0	Usge level of last scan. -1 for low, 0 for normal, 1 for high usage.
*	WebShowServer	bit DEFAULT 1	Show this server in the web interface
*	WebShowStatisticsBuffer	bit DEFAULT 1	Show this server's statistics buffer in web interface
*	WebShowDiagnosticsBuffer	bit DEFAULT 1	Show this server's diag buffer in web interface
*	HousekeepingDue	datetime2 DEFAULT getdate()	Date/Time next database housekeeping will be performed for this LicenseManagerServer. If this date is past, the service will begin housekeeping on next cycle.
*	Guid	uniqueidentifier DEFAULT newid()	A unique ID that can be used to link to this object from external applications
	AnalysisData	xml	Reserved for future use
	DebugFlags	nvarchar(50)	Reserved for debug and trace configuration
	LastDiagScan	datetime2	Date/Time of last diagnostics scan
	LastSuccessfulDiagScan	datetime2	Date/Time of last successful diagnostics scan
*	FeatureLicenseCheckOutEnabled	bit DEFAULT 0	True if the scan finds checked out vs reserved licenses
*	FeatureLicenseBorrowEnabled	bit DEFAULT 0	True if the scan detects borrowed licenses
*	FeatureLicenseBorrowableIssuedEnabled	bit DEFAULT 0	True if the license server supports licenses available for borrowing configuration
*	HintFeatureCount	int DEFAULT 0	Hint number of features to avoid join
*	HintShowCheckedOut	bit DEFAULT 0	Hint that at least some features of this server have reservations and checked out should be shown
*	HintShowBorrowed	bit DEFAULT 0	Hint that at least some features of this server have borrowed licenses
	ExtraData	nvarchar(max)	Extra data for this object (JSON)
	HintFirstUsageDataAvailable	datetime2	Date/Time of first usage date available in the database
	HintHasSoftwareItems	bit	True if one or more software items exist for this license manager server
Indexes
	PK_LicenseManagerServer	Primary Key ON ID
	IX_LicenseManagerServer_Guid	Unique Key ON Guid
Foreign Key
	FK_LicenseManagerServer_LicenseManagerServer	OrganizationID ↗ ❏ Organization(ID)
Referring Foreign Key
	FK_LicenseManagerServerBuffer_LicenseManagerServer	ID ↙ ❏ LicenseManagerServerBuffer(LicenseManagerServerID)
	FK_LicenseManagerServerEvent_LicenseManagerServer	ID ↙ ❏ LicenseManagerServerEvent(LicenseManagerServerID)
	FK_LicenseManagerServerFeature_LicenseManagerServer	ID ↙ ❏ LicenseManagerServerFeature(LicenseManagerServerID)
	FK_LicenseManagerServerMachine_LicenseManagerServer	ID ↙ ❏ LicenseManagerServerMachine(LicenseManagerServerID)
	FK_LicenseManagerServerObserverLog_LicenseManagerServer	ID ↙ ❏ LicenseManagerServerObserverLog(LicenseManagerServerID)
	FK_LicenseManagerServerScan_LicenseManagerServer	ID ↙ ❏ LicenseManagerServerScan(LicenseManagerServerID)
	FK_LicenseManagerServerUser_LicenseManagerServer	ID ↙ ❏ LicenseManagerServerUser(LicenseManagerServerID)
	FK_SoftwareItemLicenseManagerServer_LicenseManagerServer	ID ↙ ❏ SoftwareItemLicenseManagerServer(LicenseManagerServerID)

Table LicenseManagerServerBuffer

Holds the text of the response of the LM specific commands that the observer service parsed

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	LicenseManagerServerID	bigint
*	LastScan	datetime2	Date/Time this buffer was scanned
*	Buffer	text	Message returned from the license manager statistics / diagnostics tools
*	Command	nvarchar(16) DEFAULT ''	For FLexLM this can either be 'lmstat' or 'lmdiag'
Indexes
	PK_LicenseManagerServerBuffer	Primary Key ON ID
Foreign Key
	FK_LicenseManagerServerBuffer_LicenseManagerServer	LicenseManagerServerID ↗ ❏ LicenseManagerServer(ID)

Table LicenseManagerServerEvent

Reserved for future use.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	LicenseManagerServerID	bigint
*	Scan	datetime2	Date of the scan
*	Type	nvarchar(50)	Event type
*	Message	nvarchar(max)	Message from the scanned system
*	Res1	nvarchar(255)	Reserved for future use
*	Res2	nvarchar(255)	Reserved for future use
	AnalysisExtra	xml	Reserved for future use
Indexes
	PK_LicenseManagerServerEvent	Primary Key ON ID
	IX_LicenseManagerServerEvent_LicenseMangerServerID	Index ON LicenseManagerServerID
Foreign Key
	FK_LicenseManagerServerEvent_LicenseManagerServer	LicenseManagerServerID ↗ ❏ LicenseManagerServer(ID)

Table LicenseManagerServerFeature

Defines a feature within a license manager server.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	LicenseManagerServerID	bigint
*	Name	nvarchar(128)	Feature name
*	LastScan	datetime2	Date/Time this feature was scanned last
*	LicensesIssued	bigint DEFAULT 0	Number of licenses issued on this feature
*	LicensesIssuedChanged	datetime2 DEFAULT '19000101'	Date/Time the licenses issued value last changed
*	MaxLicensesUsed	bigint DEFAULT 0	Max number of licenses used while scanning the feature (since FirstScan)
*	MaxLicensesUsedChanged	datetime2 DEFAULT '19000101'	Date/Time the MaxLicensesUsed field last changed (this is the date/time that the maximum usage ratio was first reached)
*	BorrowableLicensesIssued	bigint DEFAULT 0	Number of licenses available for borrowing (for servers that support limiting borrowable licenses)
*	FriendlyName	nvarchar(256) DEFAULT ''	Friendly name for this feature
*	Description	nvarchar(256) DEFAULT ''	Description of a features
*	Guid	uniqueidentifier DEFAULT newid()	A unique ID that can be used to link to this object from external applications
*	LastLicensesUsed	int DEFAULT 0	Licenses used at last scan
*	LastLicensesUsedRatio	float DEFAULT 0	LIcenses used/issued ratio at last scan
*	LastLicensesCheckedOut	int DEFAULT 0	Licenses detected as checked out. Reserved licenses show up as used but may not be checked out.
*	LastLicensesCheckedOutRatio	float DEFAULT 0	Checked-out vs issued licenses..
*	LastLicensesBorrowed	int DEFAULT 0	Number of borrowed licenses at last scan
*	LastLicensesBorrowedRatio	float DEFAULT 0	Licenses borrowed/issued ratio at last scan
*	WorkdaysPeakLicensesUsed	int DEFAULT 0	Max licenses used during the last 2 working weeks
*	WorkdaysPeakLicensesUsedRatio	float DEFAULT 0	Peak usage ratio over the last work days, used for usage ranking.
*	WorkdaysAvgLicensesUsedRatio	float DEFAULT 0	Average usage ratio over the last work days, used for usage ranking.
*	WorkdaysPeakLicensesCheckedOut	int DEFAULT 0	Peak checked-out ratio over the last work days, used for usage ranking.
*	WorkdaysAvgLicensesCheckedOutRatio	float DEFAULT 0	Average checked-out ratio over the last work days, used for usage ranking.
*	WorkdaysPeakLicensesBorrowed	int DEFAULT 0	Peak number of borrowed licenses over the last work days
*	WorkdaysPeakLicensesBorrowedRatio	float DEFAULT 0	Peak borrowed ratio over the last work days
*	WorkdaysAvgLicensesBorrowedRatio	float DEFAULT 0	Average borrowed ratio over the last work days
	WorkdaysUsageCalculated	datetime2	Date/Time the work days usage was last calculated
	WorkdaysFirstDate	datetime2	First date used for work days usage calculation
*	IndicatorFeature	bit DEFAULT 0	This feature should be used for summaries about license usage. Indicates usage of the product.
*	ExcludeFromUsageRanking	bit DEFAULT 0	Exclude this feature from usage ranking. Can be set for features that are always 100% checked out due to license structure.
	CustomField1	nvarchar(255)	Available for custom data for this feature, not used by OctoSAM Inventory.
	CustomField2	nvarchar(255)	Available for custom data for this feature, not used by OctoSAM Inventory.
	CustomField3	nvarchar(255)	Available for custom data for this feature, not used by OctoSAM Inventory.
	CustomField4	nvarchar(255)	Available for custom data for this feature, not used by OctoSAM Inventory.
	Res1	nvarchar(255)	Reserved for future use..
	Res2	nvarchar(255)	Reserved for future use
	AnalysisExtras	xml	Reserved for future use
	Starts	datetime2	Start date of the license
	Expires	datetime2	Expiry date of the license
	LastDiagScan	datetime2	Date/Time of last diagnostics scan for this feature
*	HintShowCheckedOut	bit DEFAULT 0	Hint that this feature has reservations / checked-out licenses
*	HintShowBorrowed	bit DEFAULT 0	Hint that this feature has borrowed licenses
Indexes
	PK_LicenseManagerServerFeature	Primary Key ON ID
	IX_LicenseManagerServerFeature_Guid	Index ON Guid
	IX_LicenseManagerServerFeature_LicenseManagerID	Index ON LicenseManagerServerID
	IX_LicenseManagerServerFeature_Name	Index ON Name
Foreign Key
	FK_LicenseManagerServerFeature_LicenseManagerServer	LicenseManagerServerID ↗ ❏ LicenseManagerServer(ID)
Referring Foreign Key
	FK_LicensenManagerRbacUserFavoriteFeature_LicensenseManagerRbacUserFavoriteFeature	ID ↙ ❏ LicenseManagerRbacUserFavoriteFeature(LicenseManagerServerFeatureID)
	FK_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerFeature	ID ↙ ❏ LicenseManagerServerFeatureSessionUsageDetail(LicenseManagerServerFeatureID)
	FK_LicenseManagerServerFeatureUageDetail_LicenseManagerServerFeatureUageDetail	ID ↙ ❏ LicenseManagerServerFeatureUsageDetail(LicenseManagerServerFeatureID)
	FK_LIcenseManagerServerFeatureVersion_LIcenseManagerServerFeature	ID ↙ ❏ LicenseManagerServerFeatureVersion(LicenseManagerServerFeatureID)
	FK_LicenseManagerServerObserverLog_LicenseManagerServerFeature	ID ↙ ❏ LicenseManagerServerObserverLog(LicenseManagerServerFeatureID)

Table LicenseManagerServerFeatureSessionUsageDetail

Used to record license sessions (checkouts) per user.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	LicenseManagerServerFeatureID	bigint
*	LicenseManagerServerMachineID	bigint
*	LicenseManagerServerUserID	bigint
*	StartDate	datetime2 DEFAULT getdate()	Date/Time for the checkout of this feature
*	DurationMinutes	bigint	Duration of the checkout in minutes (from StartDate to LastScan)
*	Version	nvarchar(16)	Client Version
*	Display	nvarchar(64)	Display used when the license was checked out. Depending on the OS of the client, no useful information can be found here.
*	LastScan	datetime2 DEFAULT getdate()	When this session (Checkout) was last scanned
*	LingerSeconds	bigint DEFAULT 0	Linger time for borrowed licenses
*	LicensesUsed	int DEFAULT 1	Licenses used for token based licenses
Indexes
	PK_LicenseManagerServerFeatureSessionUsageDetail	Primary Key ON ID
	IX_LicenseManagerServerFeatureSessionUsageDetail_LastScan	Index ON LastScan
	IX_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerFeatureID	Index ON LicenseManagerServerFeatureID
	IX_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerMachineID	Index ON LicenseManagerServerMachineID
	IX_LicenseManagerServerFeatureSessionUsageDetail_LicenseMangerServerUserID	Index ON LicenseManagerServerUserID
	IX_LicenseManagerServerFeatureSessionUsageDetail_StartDate	Index ON StartDate
Foreign Key
	FK_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerFeature	LicenseManagerServerFeatureID ↗ ❏ LicenseManagerServerFeature(ID)
	FK_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerMachine	LicenseManagerServerMachineID ↗ ❏ LicenseManagerServerMachine(ID)
	FK_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerUser	LicenseManagerServerUserID ↗ ❏ LicenseManagerServerUser(ID)

Table LicenseManagerServerFeatureUsageDetail

Used to record issued/used/filtered used counts per feature.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	LicenseManagerServerFeatureID	bigint
*	LastScan	datetime2	Date/Time this info was obtained
*	LicensesIssued	int	Number of licenses issued
*	LicensesUsed	int	Number of licenses used
	LicensesCheckedOut	int	Number of license that are checked-out
	LicensesBorrowed	int	Number of borrowed licenses
Indexes
	PK_LicenseManagerServerFeatureUageDetail	Primary Key ON ID
	IX_LicenseManagerServerFeatureUsageDetail_FeatureIDLastScan	Unique Index ON LicenseManagerServerFeatureID, LastScan
Foreign Key
	FK_LicenseManagerServerFeatureUageDetail_LicenseManagerServerFeatureUageDetail	LicenseManagerServerFeatureID ↗ ❏ LicenseManagerServerFeature(ID)

Table LicenseManagerServerFeatureUsageDetailShortTerm

See LicenseManagerServerFeatureUsageDetail table. Short term storage for performance.

Idx	Column Name	Definition
*	ID	bigint IDENTITY
*	LicenseManagerServerFeatureID	bigint
*	LastScan	datetime2
*	LicensesIssued	int
*	LicensesUsed	int
	LicensesCheckedOut	int
	LicensesBorrowed	int
Indexes
	PK_LicenseManagerServerFeatureUsageDetailShortTerm	Primary Key ON ID
	IX_LicenseManagerServerFeatureUsageDetailShortTerm_FeatureIDLastScan	Unique Index ON LicenseManagerServerFeatureID, LastScan

Table LicenseManagerServerFeatureVersion

A feature can have multiple versions each with its own starting and expiry date. Mainly used for expiry warnings.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	LicenseManagerServerFeatureID	bigint
*	Version	nvarchar(16)	Feature version
*	Vendor	nvarchar(64) DEFAULT ''	Vendor string
	Starts	datetime2	Date/Time for start of license
	Expires	datetime2	Date/Time for expiration of the license
	DiagMessage	nvarchar(512)	Diagnostics message
	LastDiagScan	datetime2	Date/Time of last diagnostics scan of this feature version
	LastStatisticsScan	datetime2	Date/Time of last statistics scan of this feature version
	Created	datetime2	Date/Time this entity got created in the database
Indexes
	PK_LIcenseManagerServerFeatureVersion_FeatureIDVersion	Primary Key ON ID
	UK_LicenseManagerServerFeatureVersion	Unique Key ON LicenseManagerServerFeatureID, Version
Foreign Key
	FK_LIcenseManagerServerFeatureVersion_LIcenseManagerServerFeature	LicenseManagerServerFeatureID ↗ ❏ LicenseManagerServerFeature(ID)

Table LicenseManagerServerMachine

Used to store machine information for per user statistics (session/checkout statistics).

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	LicenseManagerServerID	bigint
*	Name	nvarchar(255)	Machine name
*	Created	datetime2	Date/Time this entry was created in the database
*	LastScan	datetime2	Date/Time this machine was detected for the last time
	MachineID	bigint
Indexes
	PK_LicenseManagerServerMachine	Primary Key ON ID
	IX_LicenseManagerServerMachine_LicenseManagerID	Index ON LicenseManagerServerID
Foreign Key
	FK_LicenseManagerServerMachine_LicenseManagerServer	LicenseManagerServerID ↗ ❏ LicenseManagerServer(ID)
	FK_LicenseManagerServerMachine_Machine	MachineID ↗ ❏ Machine(ID)
Referring Foreign Key
	FK_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerMachine	ID ↙ ❏ LicenseManagerServerFeatureSessionUsageDetail(LicenseManagerServerMachineID)

Table LicenseManagerServerObserverLog

This table is used to record the activity of the LM observer service.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MessageID	bigint	Reserved for future use
*	LicenseManagerServerID	bigint
	LicenseManagerServerFeatureID	bigint
*	LastActionMilliSeconds	bigint	Can be used for statistical analyses of some areas of license manger server scanning
*	ScanDate	datetime2	Date/Time of the scan
*	Severity	nchar(1)	Severity of the message (I= Info, W=Warning, E=Error, F=Fatal).
*	Message	nvarchar(512)	Message text
Indexes
	PK_LicenseManagerServerObserverLog	Primary Key ON ID
Foreign Key
	FK_LicenseManagerServerObserverLog_LicenseManagerServer	LicenseManagerServerID ↗ ❏ LicenseManagerServer(ID)
	FK_LicenseManagerServerObserverLog_LicenseManagerServerFeature	LicenseManagerServerFeatureID ↗ ❏ LicenseManagerServerFeature(ID)

Table LicenseManagerServerScan

Each statistics scan generates a record here. The Information can be used to observe license manager scan.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	LicenseManagerServerID	bigint
*	LastScan	datetime2	Date/Time this record was created
*	ScanDurationMilliseconds	int	Duration of this scan in milliseconds,
*	Features	int	Number of features scanned,
*	UsageLevel	int DEFAULT 0	Usage Level of this scan (-1 for low, 0 for normal, 1 for high usage),
Indexes
	PK_LicenseManagerServerScan	Primary Key ON ID
	IX_LicenseManagerServerScan_LicenseManagerServerID	Index ON LicenseManagerServerID
Foreign Key
	FK_LicenseManagerServerScan_LicenseManagerServer	LicenseManagerServerID ↗ ❏ LicenseManagerServer(ID)

Table LicenseManagerServerUser

Used to store user information for per user statistics (session/checkout statistics).

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	LicenseManagerServerID	bigint
*	Name	nvarchar(255)	User name,
*	Created	datetime2	Date/Time this user entity was created,
*	LastScan	datetime2	Date/Time this user entity was last detected,
	UserID	bigint
Indexes
	PK_LicenseMangerServerUser	Primary Key ON ID
	IX_LicenseManagerServerUser_LicenseManagerServerID	Index ON LicenseManagerServerID
Foreign Key
	FK_LicenseManagerServerUser_LicenseManagerServer	LicenseManagerServerID ↗ ❏ LicenseManagerServer(ID)
	FK_LicenseManagerServerUser_User	UserID ↗ ❏ User(ID)
Referring Foreign Key
	FK_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerUser	ID ↙ ❏ LicenseManagerServerFeatureSessionUsageDetail(LicenseManagerServerUserID)

Table LifecycleDefinitionType

Lookup table for lifecycle definition types.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	OctopusID	nvarchar(50)	Internal Id used for catalog updates
*	Name	nvarchar(128)	Software life cycle definition type
*	Created	datetime2	Date/Time this entity got created
Indexes
	PK_LifecycleDefinitionType	Primary Key ON ID
	UK_LifecycleDefinitionType_OctopusID	Unique Key ON OctopusID
	UK_LifecycleDefinitionType_Name	Unique Key ON Name
Referring Foreign Key
	FK_MachineSoftwarePackage_LifecycleDefinitionType	ID ↙ ❏ MachineSoftwarePackage(LifecycleDefinitionTypeID)
	FK_SoftwarePackage_LifecycleDefinitionType	ID ↙ ❏ SoftwarePackage(LifecycleDefinitionTypeID)

Table Machine

Basic machine information.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	OrganizationID	bigint
*	LastScan	datetime2	Date/Time of the last imported scan for this machine as reported by the machine (may be out of sync)
*	Name	nvarchar(64)	Machine name (computer name)
	AlternateName	nvarchar(128)	Contains the computer name for systems that may have different host and computer names, such as macOS.
*	OperatingSystemFamily	nvarchar(16)	A short name to identify different operating system families
*	OperatingSystem	nvarchar(255)	Full name of the OS
*	OperatingSystemVersion	nvarchar(255)	Additional version information about the OS
*	OperatingSystemBuild	nvarchar(255)	Build number of the OS
*	OperatingSystemMajor	int	Major version
*	OperatingSystemMinor	int	Minor version
*	OperatingSystemServer	bit DEFAULT 0	True if this OS is a server version
*	FullyQualifiedDomainName	nvarchar(128)	Fully qualified domain name as seen by the scanner through reverse lookup of the network address
*	NetworkAddress	nvarchar(64)	Network address, usually the IP number.
*	LastModification	datetime2	Date/Time of last write to this entity
*	ImportSourceID	bigint	ID of the import module that created the entity. 1=OctoscanImportService.
	CustomField1	nvarchar(255)	Available for custom data for this machine, not used by OctoSAM Inventory.
	CustomField2	nvarchar(255)	Available for custom data for this machine, not used by OctoSAM Inventory.
*	Notes	nvarchar(max) DEFAULT ''	Available for custom notes about this entity
*	DirectoryPath	nvarchar(255)	Path where the machine was found in the directory service. Usually an LDAP path.
*	DirectoryContainerPath	nvarchar(255) DEFAULT ''	Path to the container of this object. Provided for grouping or export to other applications.
*	Description	nvarchar(255)	Description attribute of the directory service or manually entered during offline scan
	AlternateDescription	nvarchar(255)	Alternate description field specific to the scanned machine type. For example locally entered description in macOS.
*	ImporterInstance	nvarchar(16)	Name of the ImporterInstance. Used if you have multiple import module instances writing into the same database.
*	LastScanGUID	uniqueidentifier	GUID of the last imported .scan file for this entity.
	LastHardwareScan	datetime2	Time of the last imported WMI scan
	LastHardwareScanGUID	uniqueidentifier	GUID of the last imported WMI scan
	LastSignatureScan	datetime2	Time of the last imported software signature scan for this machine
	LastSignatureScanGUID	uniqueidentifier	GUID of the last imported software signature scan for this machine
	LastUalScan	datetime2	Time of the last imported User Access Logging scan on this machine. Null for machines that don't support UAL.
	LastUalScanGUID	uniqueidentifier	GUID of the last imported User Access Logging scan on this machine. Null for machines that don't support UAL.
*	ExcludeFromSoftwareInventory	bit DEFAULT 0	If True, the machine is excluded from Software Inventory. Signatures imported for this machine are ignored. This can be useful for development machines used for building of installation packages.
*	IgnoreNewSignatures	bit DEFAULT 0	If true, do not create new software signatures if only seen on this machine or others that have the IgnoreNewSignatures flag set. Can be set for test and development machines.
*	FoundInDirectory	bit DEFAULT 0	True if the object could be found in Active Directory at last check,
	LastFoundInDirectory	datetime	Time the object was last found in the directory service,
*	TerminalServicesInstalled	bit	True, if Terminal Services are installed,
*	Created	datetime2	Time this object was created,
*	CreatedGUID	uniqueidentifier	Scan GUID that created this machine,
	LastUserID	bigint	Last User that generated a scan for this Machine
	MostFrequentUserID	bigint	Most frequent User of this Machine
	CustomField3	nvarchar(255)	Available for custom data for this Machine, not used by OctoSAM Inventory
	CustomField4	nvarchar(255)	Available for custom data for this Machine, not used by OctoSAM Inventory
	SynchTokenID	nvarchar(255)	Can be used for synchronization with another inventory or CMDB system. Holds the key to the identical item in the CMDB. Not used by OctoSAM Inventory
	SynchLastSynch	datetime2	Date/Time of last synchronization of this machine with the partner CMDB. Not used by OctoSAM Inventory
*	LastModifiedBy	nvarchar(128) DEFAULT 'unknown'	Windows User ID that last updated this Machine record through the UI
*	IgnoreForRollout	bit DEFAULT 0	Reserved for future use
	NetworkSubnetMask	nvarchar(64)	Subnet mask if network address is an ip number
	DirectorySiteName	nvarchar(64)	Active Directory Site that the machine belongs to
	NetworkNetworkAddress	nvarchar(64)	Network address calculated from NetworkAddress and NetworkSubnetkMask fields
	NetworkNetworkName	nvarchar(64)	Network name can be set from an external source. Not used by OctoSAM.
	NetworkNetworkCIDR	nvarchar(64)	Network in CIDR notation
	Res2	nvarchar(64)	Reserved for internal use by future versions
	DirectoryLocation	nvarchar(255)	Active Directory location attribute
	DirectoryExt1	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	DirectoryExt2	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	DirectoryExt3	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	DirectoryExt4	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	Res3	nvarchar(64)	Reserved for future use
	Res4	nvarchar(64)	Reserved for future use
*	DomainName	nvarchar(64)	Windows NETBIOS Domain Name
*	PrintableName	nvarchar(128) DEFAULT ''	Use this name in reports for consistency and to avoid having to build the printable name from its parts
*	RawManufacturer	nvarchar(128) COLLATE Latin1_General_CI_AS DEFAULT ''	Manufacturer of the machine as defined in WMI
*	Model	nvarchar(128) DEFAULT ''	Model of the machine as defined in WMI
*	BiosSerialNumber	nvarchar(128) DEFAULT ''	BIOS Serial Number as reported by WMI
*	BiosName	nvarchar(128) DEFAULT ''	BIOS Name as reported by WMI
*	BiosVersion	nvarchar(128) DEFAULT ''	BIOS Version as reported by WMI
*	BiosSmBiosVersion	nvarchar(128) DEFAULT ''	SMBIOS Version as reported by WMI
*	Processor	nvarchar(128) DEFAULT ''	Processor Name as reported by WMI
*	PhysicalMemory	bigint DEFAULT 0	Amount of physical memory in the system as reported by WMI
*	ChassisTypes	nvarchar(50) DEFAULT N'Unknown'	ChassisTypes as reported in WMI in cleartext
	OperatingSystemInstallDate	datetime2	Date/Time this OS instance was installed (as reported by WMI)
*	OperatingSystemLanguage	nvarchar(50) DEFAULT ''	Language of the operating system as reported by WMI in cleartext
	DirectoryLastLogonTimestamp	datetime2	LastLogonTimestamp attribute from Active Directory (updated on import and on housekeeping). Resolution: 14days.
	DirectoryUserAccountControl	bigint	UserAccountControl attribute from Active Directory (updated on import and on housekeeping)
	DirectoryDisabled	bit	True if the UserAccountControl attribute has the disable bit set
	DirectoryGUID	uniqueidentifier	GUID of a machine if joined to active directory and supported by the operating system and scanner
*	NumberOfProcessors	int DEFAULT 0	Number of processors as reported by WMI
*	NumberOfLogicalProcessors	int DEFAULT 0	Number of logical processors as reported by WMI
*	NumberOfCores	int DEFAULT 0	Number of cores as reported by WMI
*	VirtualMachine	bit DEFAULT 0	True if this is a virtual machine
*	VirtualizationHost	bit DEFAULT 0	True if this machine hosts virtual machines
*	FirstScan	datetime2	Date/Time of first scan of this machine
	SID	nvarchar(200)	Computer SID
	MsftDirectAccessConfigured	bit	True if Microsoft Direct Access configuration was found at last scan
	VirtualMachineGUID	uniqueidentifier	Optional. Used for mapping virtual machine information for MS Hyper-V and possibly other systems that use a GUID to identify a virtual machine.
*	PCSystemType	nvarchar(50) DEFAULT N'Unspecified'	PCSystemType as defined in WMI
*	ProcessorFamily	nvarchar(50) DEFAULT N''	ProcessorFamily as defined in WMI
*	Active	bit DEFAULT 1	If true, do not count this machine for installations
	NetworkMacAddress	nvarchar(64)	MAC address of the main interface (corresponds to NetworkNetworkAddress
	Res1	nvarchar(128)	Reserved for future use
	HardwareUniqueID	nvarchar(128)	Unique hardware ID if supported by the hardware. May not change with operating system re-install for physical systems.
	OperatingSystemUniqueID	nvarchar(128)	Unique operating system ID if supported by the operating system. May not change during the lifetime of the operating system instance. May change at re-install of the OS.
	DirectoryExtensionAttribute1	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute2	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute3	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute4	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute5	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute6	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute7	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute8	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute9	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute10	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute11	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute12	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute13	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute14	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute15	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryWhenChanged	datetime2	WhenChanged attribute from Active Directory (updated on import and on housekeeping)
	DirectoryWhenCreated	datetime2	WhenCreated attribute from Active Directory
*	SuggestSoftwareUninstall	bit DEFAULT 1	If true, suggest this machine in reports / queries for software uninstalls.
	HintSoftwarePackageUsageStartDate	datetime2	Min consolidated usage date for this Machine
	HintSoftwarePackageUsageEndDate	datetime2	Max consolidated usage date for this Machine
	HintInGroups	bit	True if the Machine is member in any group
	HintHasWmi	bit	True if there is hardware and configuration data (WMI) available for the machine
	HintHasSoftwareItems	bit	True if software items are linked to this machine
	HintIsClusterMember	bit	True if the machine is member of a custer
*	OperatingSystemRelease	nvarchar(255) DEFAULT ''	An OS specific release marker. For Windows 10 contains the 'Version'.
*	OperatingSystemEdition	nvarchar(255) DEFAULT ''	An OS specific edition marker
*	OperatingSystemProductName	nvarchar(255) DEFAULT ''	For Windows, contains the ProductName value as scanned from the registry.
*	OperatingSystemSuiteMask	bigint DEFAULT 0	For Windows, contains the SuiteMask.
*	OperatingSystemProductInfo	bigint DEFAULT 0	For Windows, contains the result of the GetProductInfo() system call.
*	OperatingSystemBits	int DEFAULT 0	32 or 64 bit
*	OperatingSystemPublisher	nvarchar(128) DEFAULT ''	Publisher of the OS.
*	Guid	uniqueidentifier DEFAULT newid()	A unique ID that can be used to link to this machine object by external applications
*	BiosAssetTag	nvarchar(128) DEFAULT ''	BIOS asset tag if supported
*	DeletedInDirectory	bit DEFAULT 0	True, if directory check detects that the machine is no longer found in directory.
	DeletedInDirectoryFirstDetected	datetime2	Date/Time the delete flag was set
	DirectoryAccountExpires	datetime2	accountExpires attribute from ActiveDirectory
*	OperatingSystemPrintableName	nvarchar(255) DEFAULT ''	Consolidated operating system name for use in queries and reports
	HintHasAccessLog	bit	True if machine has UAL data available
	HintHasAutoStart	bit	True if machine has scanned Windows AutosStart information
	HintHasSwidDocuments	bit	True if machine has scanned SWID documents
	AnalysisExtras	xml	Holds additional analysis data
	VirtualizationManagementSystemID	bigint
*	OracleCoreFactor	float DEFAULT 0	Oracle Core Factor to use for Oracle pricing. Queries should alwas use this field.
*	OracleCoreFactorFromCatalog	float DEFAULT 0	Oracle Core Factor as determined by the OctoSAM catalog
*	OracleCoreFactorManual	float DEFAULT 0	Optional manually entered Oracle Core Factor
*	OracleCoreFactorOverride	bit DEFAULT 0	When True, the manual Oracle Core Factor overrides the factor from the catalog.
*	SoftwareDevelopment	bit DEFAULT 0	This flag can be set to mark machines used for software development. These machines usually have different licensing requirements.
*	ProcessorSpeed	bigint DEFAULT 0	Max speed of the processor in MHz
*	NetworkDefaultGateway	nvarchar(64) DEFAULT ''	Network default gateway
*	NetworkDHCP	bit DEFAULT 0	True if DHCP is enabled on the main interface of the machine
*	NetworkDNS	nvarchar(255) DEFAULT ''	Addresses of configured DNS servers
	OperatingSystemLastBootUpTime	datetime2	DateTime the operating system last booted
	ServiceNowSysID	uniqueidentifier	Service Now: sys_id of the replicated object
	ServiceNowTargetClass	nvarchar(128)	Service Now: target class of the replicated object
	ServiceNowLastExport	datetime2	Date/Time of last export to Service Now
	ServiceNowLastImport	datetime2	Date/time of last import from Service Now
	ManufacturerID	bigint
	ProcessorManufacturerID	bigint
	BiosSmBiosUuid	uniqueidentifier	SMBIOS UUID of the machine
	OperatingSystemDisplayVersion	nvarchar(255)	DisplayVersion for operating systems that support this attribute. Newer Windows versions use this instead of ReleaseID.
	OperatingSystemCsdVersion	nvarchar(255)	CSDVersion field for Windows systems. This file may be interpreted by partner systems such as Flexera One.
	OperatingSystemSoftwarePublisherID	bigint
	ExtraData	nvarchar(max)	Extra data collected for documentation of this machine
	CostCenter	nvarchar(255)	Cost center - typically replicated from another system
	OperatingSystemUpdateBuildRevision	bigint	Windows UBR number
	OperatingSystemExtraData	nvarchar(max)	Extra data collected for operating system identification
	EntraIdTenantId	uniqueidentifier	Entra ID tenant id for machines that are Entra ID joined
	MappingTag	nvarchar(255) COLLATE Latin1_General_CI_AS	This field can be used for custom mapping logic
	HintHasMuiCache	bit	True if this machine has scanned Windows MUI information
	EntraIdDeviceId	nvarchar(255) COLLATE Latin1_General_CI_AS	Device ID from Entra ID
	EntraIdId	nvarchar(50) COLLATE Latin1_General_CI_AS	ID from Entra ID
	CloudProviderAccountID	bigint
	EntraIdDeviceOwnership	nvarchar(50) COLLATE Latin1_General_CI_AS	DeviceOwnership field from Entra ID
	EntraIdEnrollmentProfileName	nvarchar(128) COLLATE Latin1_General_CI_AS	EnrollmentProfileName field from Entra ID
	EntraIdOnPremisesLastSyncDateTime	datetime2	OnPremisesLastSyncDateTime field from Entra ID
	EntraIdTrustType	nvarchar(50) COLLATE Latin1_General_CI_AS	TrustType field from Entra ID
	EntraIdProfileType	nvarchar(50) COLLATE Latin1_General_CI_AS	ProfileType field from Entra ID
	EntraIdRegistrationDateTime	datetime2	RegistrationDateTime field from Entra ID
	LastFoundInEntraId	datetime2	Date/Time this device was last found in Entra ID
	EntraIdApproximateLastSignInDateTime	datetime2	ApproximateLastSignInDateTime field Entra ID
	ObjectStateID	bigint
	EntraIdIsManaged	bit	True if this machine is managed by Entra ID MDM policies
	EntraIdIsCompliant	bit	True if this machine is deemed compliant to Entra ID MDM policies
	LastScannerTag	nvarchar(255) COLLATE Latin1_General_CI_AS	Command-line tag that was specified on the last scan of this machine
	EntraIdOnPremisesSyncEnabled	bit	True if on premises sync is enabled for this machine in Entra ID
	EntraIdExtensionAttribute1	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 1 from Entra ID
	EntraIdExtensionAttribute2	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 2 from Entra ID
	EntraIdExtensionAttribute3	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 3 from Entra ID
	EntraIdExtensionAttribute4	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 4 from Entra ID
	EntraIdExtensionAttribute5	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 5 from Entra ID
	EntraIdExtensionAttribute6	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 6 from Entra ID
	EntraIdExtensionAttribute7	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 7 from Entra ID
	EntraIdExtensionAttribute8	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 8 from Entra ID
	EntraIdExtensionAttribute9	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 9 from Entra ID
	EntraIdExtensionAttribute10	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 10 from Entra ID
	EntraIdExtensionAttribute11	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 11 from Entra ID
	EntraIdExtensionAttribute12	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 12 from Entra ID
	EntraIdExtensionAttribute13	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 13 from Entra ID
	EntraIdExtensionAttribute14	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 14 from Entra ID
	EntraIdExtensionAttribute15	nvarchar(255) COLLATE Latin1_General_CI_AS	Extension attribute 15 from Entra ID
	LastBasicHardwareFromWmi	datetime2	Date/Time basic hardware info was last calculated from WMI for this machine
	HintHasOfficeAddIns	bit	True if this machine has registered Microsoft Office add-ins
	CostCenterID	bigint
Indexes
	PK_Machine	Primary Key ON ID
	UK_Machine_Guid	Unique Key ON Guid
	IX_Machine_BiosSmbiosUuid	Index ON BiosSmBiosUuid
	IX_Machine_HardwareUniqueID	Index ON HardwareUniqueID
	IX_Machine_OrganizationID	Index ON OrganizationID
	IX_Machine_Performance1	Unique Index ON OrganizationID, ID
	IX_Machine_ManufacturerID	Index ON ManufacturerID
Foreign Key
	FK_Machine_Manufacturer	ManufacturerID ↗ ❏ Manufacturer(ID)
	FK_Machine_ProcessorManufacturer	ProcessorManufacturerID ↗ ❏ Manufacturer(ID)
	FK_Machine_Organization	OrganizationID ↗ ❏ Organization(ID)
	FK_Machine_SoftwarePublisher	OperatingSystemSoftwarePublisherID ↗ ❏ SoftwarePublisher(ID)
	FK_Machine_LastUser	LastUserID ↗ ❏ User(ID)
	FK_Machine_MostFrequentUser	MostFrequentUserID ↗ ❏ User(ID)
	FK_Machine_VirtualizationManagementSystem	VirtualizationManagementSystemID ↗ ❏ VirtualizationManagementSystem(ID)
	FK_Machine_ObjectState	ObjectStateID ↗ ❏ ObjectState(ID)
	FK_Machine_CloudProviderAccount	CloudProviderAccountID ↗ ❏ CloudProviderAccount(ID)
Referring Foreign Key
	FK_File_Machine	ID ↙ ❏ File(MachineID)
	FK_ImportControl_Machine	ID ↙ ❏ ImportControl(MachineID)
	FK_LicenseManagerServerMachine_Machine	ID ↙ ❏ LicenseManagerServerMachine(MachineID)
	FK_MachineAutoStart_Machine	ID ↙ ❏ MachineAutoStart(MachineID)
	FK_MachineCluster_Machine	ID ↙ ❏ MachineCluster(MachineID)
	FK_MachineGroup_Machine	ID ↙ ❏ MachineGroup(MachineID)
	FK_MachineRawData_Machine	ID ↙ ❏ MachineRawData(MachineID)
	FK_MachineSoftwarePackage_Machine	ID ↙ ❏ MachineSoftwarePackage(MachineID)
	FK_MachineSoftwareSignature_Machine	ID ↙ ❏ MachineSoftwareSignature(MachineID)
	FK_MachineUsbDevice_Machine	ID ↙ ❏ MachineUsbDevice(MachineID)
	FK_MachineUser_Machine	ID ↙ ❏ MachineUser(MachineID)
	FK_SoftwareItemMachine_Machine	ID ↙ ❏ SoftwareItemMachine(MachineID)
	FK_SoftwarePackageUsageDetail_Machine	ID ↙ ❏ SoftwarePackageUsageDetail(MachineID)
	FK_UalDeviceAccess_ClientMachine	ID ↙ ❏ UalDeviceAccess(ClientMachineID)
	FK_UalDeviceAccess_Machine	ID ↙ ❏ UalDeviceAccess(MachineID)
	FK_UalUserAccess_Machine	ID ↙ ❏ UalUserAccess(MachineID)
	FK_UsageDetail_Machine	ID ↙ ❏ UsageDetail(MachineID)
	FK_User_LastMachine	ID ↙ ❏ User(LastMachineID)
	FK_User_MostFrequentlyUsedMachine	ID ↙ ❏ User(MostFrequentlyUsedMachineID)
	FK_UserMachineAffinity_Machine	ID ↙ ❏ UserMachineAffinity(MachineID)
	FK_VirtualMachine_HostMachine	ID ↙ ❏ VirtualMachine(HostMachineID)
	FK_VirtualMachine_Machine	ID ↙ ❏ VirtualMachine(MachineID)
	FK_VirtualMachineHistory_Machine	ID ↙ ❏ VirtualMachineHistory(MachineID)
	FK_VirtualMachineHistory_VirtualMachineHistory	ID ↙ ❏ VirtualMachineHistory(HostMachineID)
	FK_VirtualMachineMobilityHistory_Machine	ID ↙ ❏ VirtualMachineMobilityHistory(MachineID)
	FK_VirtualMachineMobilityHistory_NewHostMachine	ID ↙ ❏ VirtualMachineMobilityHistory(NewHostMachineID)
	FK_WmiInstance_Machine	ID ↙ ❏ WmiInstance(MachineID)
	FK_MachineOfficeAddIn_Machine	ID ↙ ❏ MachineOfficeAddIn(MachineID)

Table MachineAutoStart

Machine specific auto start configuration.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	AutoStartTypeID	bigint
*	Name	nvarchar(255) COLLATE Latin1_General_CI_AS	Name of the configuration
*	Value	nvarchar(max) COLLATE Latin1_General_CI_AS	Command to run
*	LastScanGUID	uniqueidentifier	GUID of the scan that last scanned this configuration item
*	LastScan	datetime2	Date/Time this item was last scanned
*	FirstScan	datetime2 DEFAULT getdate()	Date/Time this item was first scanned
Indexes
	PK_MachineAutoStart	Primary Key ON ID
	IX_MachineAutoStart_Machine	Index ON MachineID
Foreign Key
	FK_MachineAutoStart_AutoStartType	AutoStartTypeID ↗ ❏ AutoStartType(ID)
	FK_MachineAutoStart_Machine	MachineID ↗ ❏ Machine(ID)

Table MachineCluster

m:n relation between machines and clusters

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	ClusterID	bigint
*	Created	datetime2	Date/Time this relation got created in the database
*	CreatedGUID	uniqueidentifier	GUID of the scan that created this relation
*	LastScan	datetime2	Date/Time this relation got scanned last
*	LastScanGUID	uniqueidentifier	GUID of the last scan for this relations
Indexes
	PK_MachineCluster	Primary Key ON ID
	IX_MachineCluster_ClusterID	Index ON ClusterID
	IX_MachineCluster_MachineID	Index ON MachineID
Foreign Key
	FK_MachineCluster_Cluster	ClusterID ↗ ❏ Cluster(ID)
	FK_MachineCluster_Machine	MachineID ↗ ❏ Machine(ID)

Table MachineGroup

m:n relation between machines and groups

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	GroupID	bigint
*	Created	datetime2	Date/Time this relation got created in the database
*	LastScan	datetime2	LastScan of this relation
Indexes
	PK_MachineGroup	Primary Key ON ID
	IX_MachineGroup_MachineGroup	Unique Index ON MachineID, GroupID
	IX_MachineGroup_Group	Index ON GroupID
	IX_MachineGroup_Machine	Index ON MachineID
Foreign Key
	FK_MachineGroup_Group	GroupID ↗ ❏ Group(ID)
	FK_MachineGroup_Machine	MachineID ↗ ❏ Machine(ID)

Table MachineHardwareHistory

Reserved for future use.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
	SerialNumber	nvarchar(100)	Serial number of the device
	BiosSmBiosUUID	uniqueidentifier	BIOS SMBIOS UUID of the device
*	NetworkMacAddress	nvarchar(100)	MAC address of the primary interface of the device
*	Name	nvarchar(100)	Machine name of the device at the time of the scan
*	FirstScan	datetime2	Date/Time the device was first scanned
*	LastScan	datetime2	Date/Time the device was last scanned
*	Created	datetime2	Date/Time this entity got created in the database
	DirectoryPath	nvarchar(512)	Path to the machine in active directory at time of the scan
*	Guid	uniqueidentifier	Guid of the machine in a directory service at time of the scan
	FullyQualifiedDomainName	nvarchar(512)	FQDN of the machine at time of scan
Indexes
	PK_MachineHardwareHistory	Primary Key ON ID
	IX_MachineHardwareHistory_BiosSmBiosUUID	Index ON BiosSmBiosUUID
	IX_MachineHardwareHistory_NetworkMacAddress	Index ON NetworkMacAddress
	IX_MachineHardwareHistory_SerialNumber	Index ON SerialNumber

Table MachineOfficeAddIn

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	Application	nvarchar(128) COLLATE Latin1_General_CI_AS	Application that this add-in is registered to
*	Bits	int	Whether the add-in component is registered to the 32- or 64 bit vresion of the application
*	Name	nvarchar(128) COLLATE Latin1_General_CI_AS	Name of the add-in
	FriendlyName	nvarchar(256) COLLATE Latin1_General_CI_AS	Friendlier name of the add-in
	Description	nvarchar(512) COLLATE Latin1_General_CI_AS	Description of the add-in
	LoadBehavior	int	Add in load behavior, see Microsoft documentation
	CommandLineSafe	int	See Microsoft documentation
	RegistryKeyLastWriteTime	datetime2	Date/Time of the last write to the Registry key that registers the add-in
	RegistryPath	nvarchar(256) COLLATE Latin1_General_CI_AS	Registry path to the add-in registration
	ProgId	nvarchar(128) COLLATE Latin1_General_CI_AS	COM ProgramID of the add-in
	ClsId	nvarchar(50) COLLATE Latin1_General_CI_AS	COM CLSID of the add-in
	InProcServer	nvarchar(512) COLLATE Latin1_General_CI_AS	Path to the COM server
	ThreadingModel	nvarchar(50) COLLATE Latin1_General_CI_AS	Threading Model
	InProcServerDescription	nvarchar(512) COLLATE Latin1_General_CI_AS	Description from the InProcServer registration
	FileDescription	nvarchar(512) COLLATE Latin1_General_CI_AS	File description from the resource of the registered COM server binary
	FileVersion	nvarchar(128) COLLATE Latin1_General_CI_AS	File version from the resource of the registered COM server binary
	ProductName	nvarchar(256) COLLATE Latin1_General_CI_AS	Product name form the resource of the registered COM server binary
	ProductVersion	nvarchar(128) COLLATE Latin1_General_CI_AS	Product version from the resource of the registered COM server binary
	CompanyName	nvarchar(265) COLLATE Latin1_General_CI_AS	Company name from the resource of the registered COM server binary
	SoftwarePublisherID	bigint
	RawSoftwarePublisher	nvarchar(128) COLLATE Latin1_General_CI_AS	Software publisher as scanned from the resource of the registered COM server binary
	DisplayVersion	nvarchar(128) COLLATE Latin1_General_CI_AS	Display version of the add-in
Indexes
	PK_MachineOfficeAddIn	Primary Key ON ID
	IX_MachineOfficeAddIn_MachineID	Index ON MachineID
	IX_MachineOfficeAddIn_Name	Index ON Name
Foreign Key
	FK_MachineOfficeAddIn_Machine	MachineID ↗ ❏ Machine(ID)
	FK_MachineOfficeAddIn_SoftwarePublisher	SoftwarePublisherID ↗ ❏ SoftwarePublisher(ID)

Table MachineRawData

Reserved for future use.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	DataType	nvarchar(50)	Reserved for future use
*	LastScan	datetime2	Reserved for future use
*	LastScanGuid	uniqueidentifier	Reserved for future use
*	Data	nvarchar(max)	Reserved for future use
Indexes
	PK_MachineRawData	Primary Key ON ID
	IX_MachineRawData_Machine	Index ON MachineID
Foreign Key
	FK_MachineRawData_Machine	MachineID ↗ ❏ Machine(ID)

Table MachineSoftwarePackage

m:n relation between machines and software packages. This is mostly a redundant relation to speed up reports. A relation between machine and software package can also be found via software signature. There are exceptions where a signature does not define installation status of a package (for example left-over SWID tags).

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	SoftwarePackageID	bigint
*	LastModification	datetime2	Date/Time this machine to software package relation was last encountered in a scan, or update time due to updates to packages and signatures.
*	Created	datetime2	Date/Time this relation was created in the database
	CreatedGUID	uniqueidentifier	GUID of the scan that created this relation
	SynchTokenID	nvarchar(255)	Can be used for synchronization with another inventory or CMDB system. Holds the key to the identical item in the CMDB. Currently not used by OctoSAM Inventory.
	SynchLastSynch	datetime2	Timestamp of last synchoronization of this machine software package relation with the partner CMDB. Currently not used by OctoSAM Inventory.
	FirstScan	date	Date/Time this machine to software package relation was first detected
	LastDiscovered	datetime2	Date/Time the SoftwarePackage to Machine relation was last discovered from scan results
	LastUsage	date	Date/Time the SoftwarePackage was last used on the Machine. Redundant information to SoftwarePackageUsageDetail provided for easier querying and performance.
	HintLicensingRelevant	bit	For software packages with licensing type multiple, this indicates that at least one installed signature has the LicensingRelevant flag set.
	InstallDate	datetime2	Max value of all installed signature InstallDate if available. Not all packages provide an install date.
	HintBaseVersion	nvarchar(64)	Consolidated BaseVersion of all signatures for this installation, if the individual BaseVersion fields of the signatures follow SemVer or another standard supported by OctoSAM.
	HintKeyLastWriteTime	datetime2	Newest write to any of the signatures for this installation for registry key based signatures
	AnalysisExtras	xml	Holds additional analysis data
	Features	nvarchar(512)	Installation specific feature information
	ExtraData	nvarchar(max)	Extra data collected for documentation of this machine to signature relation
	ServiceNowSysID	uniqueidentifier	Service Now: sys_id of replicated object
	ServiceNowLastExport	datetime2	Date/Time of last export to Service Now
	ServiceNowLastImport	datetime2	Date/Time of last import from Service Now
*	Guid	uniqueidentifier DEFAULT newid()	A unique id of this relation record
	CustomField1	nvarchar(255)	Custom field available for site-specific per installation data, Not used by OctoSAM logic.
	CustomField2	nvarchar(255)	Custom field available for site-specific per installation data, Not used by OctoSAM logic.
	CustomField3	nvarchar(255)	Custom field available for site-specific per installation data, Not used by OctoSAM logic.
	CustomField4	nvarchar(255)	Custom field available for site-specific per installation data, Not used by OctoSAM logic.
	Notes	nvarchar(max)	Site-specific per installation notes, Not used by OctoSAM logic.
	LifecycleSupportPolicy	nvarchar(50)	Software Publisher specific lifecycle policy name
	LifecycleStartDate	datetime2	Start of software lifecycle
	LifecycleMainstreamEndDate	datetime2	End of mainstream support date
	LifecycleExtendedEndDate	datetime2	End of extended support date
	LifecycleRetirementDate	datetime2	Product retirement date
	LifecycleReleaseStartDate	datetime2	Release start date
	LifecycleReleaseEndDate	datetime2	Release end date
	LastLifecycleLookup	datetime2	Date/Time a life-cycle look-up was last performed on this relation
	LastLifecycleLookupResult	nvarchar(255)	A status comment generated by the last life-cycle look-up on this relation
	LifecycleLongTermSupport	bit	True if the installed release has long term support by the publisher
	LifecycleDefinitionTypeID	bigint
	InstallationApproved	bit	Installation of this package on this machine is approved
	InstallationApprovedChanged	datetime2	Date/Time the approval flag was last changed
	InstallationApprovedChangedBy	nvarchar(50) COLLATE Latin1_General_CI_AS	User that last changed the approval flag
	HintReleaseType	nvarchar(50) COLLATE Latin1_General_CI_AS	Most critical release type for this package installation. This is package-specific. For example for Oracle Java SE this may contain 'BPR' for licensing relevant BPR builds.
Indexes
	PK_MachineSoftwarePackage	Primary Key ON ID
	IX_MachineSoftwarePackage_Unique	Unique Key ON MachineID, SoftwarePackageID
	IX_MachineSoftwarePackage_MachineID	Index ON MachineID
	IX_MachineSoftwarePackage_SoftwarePackage_ID	Index ON SoftwarePackageID
	IX_MachineSoftwarePackage_FilterHintLicensingRelevant	Index ON ID
Foreign Key
	FK_MachineSoftwarePackage_Machine	MachineID ↗ ❏ Machine(ID)
	FK_MachineSoftwarePackage_SoftwarePackage	SoftwarePackageID ↗ ❏ SoftwarePackage(ID)
	FK_MachineSoftwarePackage_LifecycleDefinitionType	LifecycleDefinitionTypeID ↗ ❏ LifecycleDefinitionType(ID)

Table MachineSoftwareSignature

M:n relation between machines and software signatures.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	SoftwareSignatureID	bigint
	InformationSourceID	bigint
*	LastModification	datetime2	Date/Time this machine to software signature was last updated
*	LastScanGUID	uniqueidentifier	GUID of the scan that last updated this relation
*	LastScan	datetime2	Date/Time of last scan that updated this software signature to machine relation
	LastUsage	datetime2	For metering signatures, date/time of last detected usage. Redundant to information in table UsageDetail, provided for easier querying and performance.
*	Created	datetime2	Date/Time this relation was created in the database
	CreatedGUID	uniqueidentifier	Scan GUID that created this object
	InstallDate	datetime2	Date/Time of installation if available. Not all packages provide an install date.
	FirstScan	datetime2	Date/Time of the scan that created this entity. Note that this differs from Created column in case of re-import of old .scan files.
	SoftwareRepackagerInfo	nvarchar(128)	Repackager Info for supported Repackagers
	SoftwareRepackagerID	bigint
	KeyLastWriteTime	datetime2	For registry based signatures, Date/Time the registry key was last written. Note that not only installations may write the registry keys. Typically, windows feature updates will reset this date.
	InstallLocation	nvarchar(512)	The location where a software package is installed on the system - if available
	InstallSource	nvarchar(512)	The source location of the installation package. For windows installer packages the path to the .msi file that was used for the installation.
	AnalysisExtras	xml	Holds additional analysis data
	Features	nvarchar(512)	Installation specific feature information
	ExtraData	nvarchar(max)	Extra data collected for documentation of this machine to signature relation
	CustomField1	nvarchar(255) COLLATE Latin1_General_CI_AS	Available for custom data for this installation not used by OctoSAM Inventory
	CustomField2	nvarchar(255) COLLATE Latin1_General_CI_AS	Available for custom data for this installation not used by OctoSAM Inventory
	CustomField3	nvarchar(255) COLLATE Latin1_General_CI_AS	Available for custom data for this installation not used by OctoSAM Inventory
	CustomField4	nvarchar(255) COLLATE Latin1_General_CI_AS	Available for custom data for this installation not used by OctoSAM Inventory
	Notes	nvarchar(max) COLLATE Latin1_General_CI_AS	Installation notes
	Res1	nvarchar(255) COLLATE Latin1_General_CI_AS	Reserved for future use
	Res2	nvarchar(255) COLLATE Latin1_General_CI_AS	Reserved for future use
	InstallationApproved	bit	Installation of this signature on this machine is approved
	InstallationApprovedChanged	datetime2	Data/Time the installation approval flag was last changed
	InstallationApprovedChangedBy	nvarchar(50) COLLATE Latin1_General_CI_AS	User that last changed the approval flag
	FileHash	nvarchar(50) COLLATE Latin1_General_CI_AS	A hash calculated over the contents of a file if the signature is file based. Not all scan scenarios calculate a hash.
*	Guid	uniqueidentifier DEFAULT newid()
Indexes
	PK_MachineSoftwareSignature	Primary Key ON ID
	IX_MachineSoftwareSignature_MachineSoftware_Unique	Unique Key ON MachineID, SoftwareSignatureID
	IX_MachineSoftwareSignature_LastScanGUID	Index ON LastScanGUID
	IX_MachineSoftwareSignature_MachineID	Index ON MachineID
	IX_MachineSoftwareSignature_SoftwareSignatureID	Index ON SoftwareSignatureID
Foreign Key
	FK_MachineSoftwareSignature_InformationSource	InformationSourceID ↗ ❏ InformationSource(ID)
	FK_MachineSoftwareSignature_Machine	MachineID ↗ ❏ Machine(ID)
	FK_MachineSoftwareSignature_SoftwareRepackager	SoftwareRepackagerID ↗ ❏ SoftwareRepackager(ID)
	FK_MachineSoftwareSignature_SoftwareSignature	SoftwareSignatureID ↗ ❏ SoftwareSignature(ID)
Referring Foreign Key
	FK_MachineSoftwareSignatureInstance_MachineSoftwareSignature	ID ↙ ❏ MachineSoftwareSignatureInstance(MachineSoftwareSignatureID)
	FK_SwidDocument_MachineSoftwareSignature	ID ↙ ❏ SwidDocument(MachineSoftwareSignatureID)

Table MachineSoftwareSignatureInstance

if several instances of MachineSoftwareSignature can be found for the same signature (for example, process started multiple times), This table holds per instance information.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineSoftwareSignatureID	bigint
	CommandLine	nvarchar(max)	CommandLine of the process if available
	Environment	nvarchar(max)	Environment of the process if available
*	LastScan	datetime2	Date/Time of last scan of this process instance
	StartDate	datetime2	StartDate of this process instance
	Features	nvarchar(50)	Instance specific feature information
	AnalysisExtras	xml	Holds additional analysis data
	ExtraData	nvarchar(max)	Extra data collected for documentation of this machine to signature relation
Indexes
	PK_MachineSoftwareSignatureInstance	Primary Key ON ID
	IX_MachineSoftwareSignatureInstance_MachineSoftwareSignatureID	Index ON MachineSoftwareSignatureID
Foreign Key
	FK_MachineSoftwareSignatureInstance_MachineSoftwareSignature	MachineSoftwareSignatureID ↗ ❏ MachineSoftwareSignature(ID)

Table MachineUsbDevice

Reserved for future use

Idx	Column Name	Definition
*	ID	bigint IDENTITY
*	MachineID	bigint
*	UsbDeviceID	bigint
Indexes
	PK_MachineUsbDevice	Primary Key ON ID
Foreign Key
	FK_MachineUsbDevice_Machine	MachineID ↗ ❏ Machine(ID)
	FK_MachineUsbDevice_UsbDevice	UsbDeviceID ↗ ❏ UsbDevice(ID)

Table MachineUser

m:n relation between machines and users

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	UserID	bigint
*	LastModification	datetime2	Date/Time of last write to this relation,
*	LastScanGUID	uniqueidentifier	GUID of the scan that last updated this relation,
*	LastScan	datetime2	Date/Time of last scan that updated this relation,
*	LocalAdministrator	bit	True if the referenced user is member of the referenced machine's Administrators group,
	ScannedAsAdministrator	bit	True if the scan that last scanned this relation was run with administrative privileges,
*	RemoteSession	bit	True if scan was during a remote session,
*	Created	datetime2	Date/Time this object was created in the database,
*	CreatedGUID	uniqueidentifier	GUID of the scan that created this relation in the database,
	SynchTokenID	nvarchar(256)	Can be used for synchronization with another inventory or CMDB system. Holds the key to the identical item in the CMDB. Currently not used by OctoSAM Inventory.
	SynchLastSynch	datetime2	Timestamp of last synchoronization of this machine user relation with the partner CMDB. Currently not used by OctoSAM Inventory,
	AnalysisExtras	xml	Holds additional analysis data
	LastScannerTag	nvarchar(256) COLLATE Latin1_General_CI_AS	Command-line tag that was specified on the last scan of this machine to user relation
Indexes
	PK_MachineUser	Primary Key ON ID
	IX_MachineUser_MachineID	Index ON MachineID
	IX_MachineUser_UserID	Index ON UserID
Foreign Key
	FK_MachineUser_Machine	MachineID ↗ ❏ Machine(ID)
	FK_MachineUser_MachineUser	ID ↗ ❏ MachineUser
	FK_MachineUser_User	UserID ↗ ❏ User(ID)
Referring Foreign Key
	FK_MachineUser_MachineUser	ID ↙ ❏ MachineUser
	FK_MachineUserAutoStart_MachineUser	ID ↙ ❏ MachineUserAutoStart(MachineUserID)
	FK_MachineUserHistory_MachineUser	ID ↙ ❏ MachineUserHistory(MachineUserID)
	FK_MachineUserMUICache_MachineUser	ID ↙ ❏ MachineUserMUICache(MachineUserID)
	FK_MachineUserSecurityGroup_MachineUser	ID ↙ ❏ MachineUserSecurityGroup(MachineUserID)
	FK_MachineUserSoftwareSignature_MachineUser	ID ↙ ❏ MachineUserSoftwareSignature(MachineUserID)
	FK_MachineUserOfficeAddIn_MachineUser	ID ↙ ❏ MachineUserOfficeAddIn(MachineUserID)

Table MachineUserAutoStart

User and Machine specific auto start configuration

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineUserID	bigint
*	AutoStartTypeID	bigint
*	Name	nvarchar(255) COLLATE Latin1_General_CI_AS	Name of the configuration
*	Value	nvarchar(max) COLLATE Latin1_General_CI_AS	Command to run
*	LastScanGUID	uniqueidentifier	GUID of the scan that last scanned this configuration
*	LastScan	datetime2	Date/Time of last scan
*	FirstScan	datetime2 DEFAULT getdate()	Date/Time of first scan of this configuration
Indexes
	PK_MachineUserAutoStart	Primary Key ON ID
	IX_MachineUserAutoStart_MachineUser	Index ON MachineUserID
Foreign Key
	FK_MachineUserAutoStart_AutoStartType	AutoStartTypeID ↗ ❏ AutoStartType(ID)
	FK_MachineUserAutoStart_MachineUser	MachineUserID ↗ ❏ MachineUser(ID)

Table MachineUserHistory

User logon history information

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineUserID	bigint
*	Scan	datetime2	Date/Time this machine to user relation was scanned
*	ScanGUID	uniqueidentifier	GUID of the scan file that scanned this machine to user relation
*	LocalAdministrator	bit	True if the user was member of the machine's local Administrators group at time of logon
	ScannedAsAdministrator	bit	True if the scan run with Administrator privileges,
*	RemoteSession	bit	True if the user was in a remote session with the machine,
	CitrixSession	bit	True if the Scan was made in a Citrix terminal server context. detection of Citrix not always reliable depending on scanner invocation,
	SessionName	nvarchar(32)	Session name of the terminal session,
	OfflineScan	bit	True if this record was generated by an offline scan (OctoOffline.exe),
	MsftDirectAccess	bit	True if the machine was connected to the network via Microsoft Direct Access at time of scan,
*	OctoscanBuildInfo	nvarchar(128) DEFAULT ''	Detailed build information of the scanner that scanned this machine to user relation,
	EntraIdJoinType	nvarchar(50) COLLATE Latin1_General_CI_AS	Entra ID join type for this machine or this user,
	EntraIdDeviceId	uniqueidentifier	Entra ID device id,
	EntraIdTenantId	uniqueidentifier	Entra ID tenant id,
	EntraIdIdpDomain	nvarchar(255) COLLATE Latin1_General_CI_AS	Entra ID identity provider domain,
	EntraIdJoinUserEmail	nvarchar(255) COLLATE Latin1_General_CI_AS	Mail address used to join Entra ID
	EntraIdTenantDisplayName	nvarchar(255) COLLATE Latin1_General_CI_AS	Display name for this Entra ID tenant
	EntraIdUserInfoUserEmail	nvarchar(255) COLLATE Latin1_General_CI_AS	Email from Entra ID join info user info,
	EntraIdUserInfoUserKeyId	uniqueidentifier	User id from Entra ID join info user info,
	EntraIdUserInfoUserKeyName	nvarchar(512) COLLATE Latin1_General_CI_AS	User key name from Entra ID join info user info
	Created	datetime2	Date/Time this relation got created. This is not the scan time but usually the import time.
	ScannerTag	nvarchar(255) COLLATE Latin1_General_CI_AS	Command-line tag that was specified on the scan of this machine to user relation history record
Indexes
	PK_MachineUserHistory	Primary Key ON ID
	IX_MachineUserHistory_GUID	Unique Index ON ScanGUID
	IX_MachineUserHistory	Index ON MachineUserID
Foreign Key
	FK_MachineUserHistory_MachineUser	MachineUserID ↗ ❏ MachineUser(ID)
Referring Foreign Key
	FK_MachineUserHistoryViewClientInformation_MachineUserHistory	ID ↙ ❏ MachineUserHistoryViewClientInformation(MachineUserHistoryID)
	FK_MachineUserHistoryVirtualEnvironment_MachineUserHistory	ID ↙ ❏ MachineUserHistoryVolatileEnvironment(MachineUserHistoryID)
	FK_MachineUserHistoryWTSSessionInformation_MachineUserHistory	ID ↙ ❏ MachineUserHistoryWTSSessionInformation(MachineUserHistoryID)
	FK_WmiInstanceHistory_MachineUserHistory	ID ↙ ❏ WmiInstanceHistory(MachineUserHistoryID)

Table MachineUserHistoryViewClientInformation

For VMware view client

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineUserHistoryID	bigint
*	IpAddress	nvarchar(50)	The IP address of the client system,
*	MacAddress	nvarchar(50)	The MAC address of the client system,
*	MachineName	nvarchar(128)	The machine name of the client system,
*	MachineDomain	nvarchar(128)	The domain of the client system,
*	LoggedOnUserName	nvarchar(128)	The user name that was used to log in to the client system,
*	LoggedOnDomainName	nvarchar(128)	The domain name that was used to log in to the client system,
*	Type	nvarchar(50)	The thin client name or operating system type of the client system,
*	BrokerDnsName	nvarchar(128)	The DNS name of the View Connection Server instance
*	BrokerUrl	nvarchar(128)	The URL of the View Connection Server instance
*	BrokerTunneled	nvarchar(128)	The status of the tunnel connection for the view connection server
*	BrokerTunnelUrl	nvarchar(256)	The URL of the view connection server tunnel connection, if the tunnel connection is enabled.
*	BrokerRemoteIpAddress	nvarchar(50)	The IP address of the client system that is seen by the View Connection Server instance
*	TZID	nvarchar(50)	The Olson time zone ID
*	WindowsTimezone	nvarchar(50)	The GMT standard time
*	BrokerDomainName	nvarchar(50)	Domain name used to authenticate to View Connection Server
*	BrokerUserName	nvarchar(50)	Username used to authenticate to View Connection Server
*	ClientID	nvarchar(128)	Specifies the unique client hardware id used as a link to the license key
*	DisplaysNumber	bigint	Specifies the number of monitors being used on the client
*	DisplaysTopology	nvarchar(128)	Specifies the arrangement, resolution, and dimensions of displays on the client.
*	DisplaysTopologyV2	nvarchar(128)	Specifies the arrangement, resolution, and dimensions of displays on the client.
*	KeyboardType	nvarchar(50)	Specifies the type of keyboard being used on the client
*	KeyboardLayout	nvarchar(50)	Specifies the keyboard layout being used on the client
*	KeyboardSubType	nvarchar(50)	Specifies the keyboard subtype being used on the client
*	SessionType	nvarchar(50)	Specifies the session type. The type can be desktop or application.
*	MouseIdentifier	bigint	Specifies the type of mouse
*	MouseNumButtons	bigint	Specifies the number of buttons supported by the mouse
*	MouseSampleRate	bigint	Specifies the rate, in reports per second, at which input from a PS/2 mouse is sampled.
*	Protocol	nvarchar(50)	Specifies the protocol being used
*	Language	nvarchar(50)	Specifies the operating system language
*	LaunchID	nvarchar(128)	Specifies the desktop pool Unique ID
*	LaunchSessionType	nvarchar(50)	Specifies the launch session type
Indexes
	PK_MachineUserHistoryViewClientInformation	Primary Key ON ID
	IX_MachineUserHistoryViewClientInformation	Unique Index ON MachineUserHistoryID
Foreign Key
	FK_MachineUserHistoryViewClientInformation_MachineUserHistory	MachineUserHistoryID ↗ ❏ MachineUserHistory(ID)

Table MachineUserHistoryVolatileEnvironment

Inventories the volatile environment per machine user scan

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineUserHistoryID	bigint
*	Name	nvarchar(256)	Name of the environment variable
*	Value	nvarchar(max)	Value of the environment variable
Indexes
	PK_MachineUserHistoryVirtualEnvironment	Primary Key ON ID
	IX_MachineUserHistoryVirtualEnvironment	Index ON MachineUserHistoryID
Foreign Key
	FK_MachineUserHistoryVirtualEnvironment_MachineUserHistory	MachineUserHistoryID ↗ ❏ MachineUserHistory(ID)

Table MachineUserHistoryWTSSessionInformation

For remote terminal sessions, records the WTSSessionInformation, see WTSQuerySessionInformation MSDN documentation.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineUserHistoryID	bigint
	InitialProgram	nvarchar(255)	Name of the initial program that Remote Desktop Services runs when the user logs on
	ApplicationName	nvarchar(255)	Published name of the application that the session is running. Not supported on all Windows versions.
	WorkingDirectory	nvarchar(255)	Default directory used when launching the initial program
*	SessionID	bigint	ID of the terminal server session
*	UserName	nvarchar(64)	Name of the user associated with the session
	WinStationName	nvarchar(64)	Name of the Remote Desktop Services session
*	DomainName	nvarchar(64)	Contains the name of the domain to which the logged-on user belongs
*	ClientName	nvarchar(64)	Contains the name of the client..
	ClientAddress	nvarchar(64)	Contains the client's IP Address
	ClientDirectory	nvarchar(255)	Contains the directory in which the client is installed
	ClientProductID	int	Contains a client specific product identifier
*	ClientProtocolType	nvarchar(16)	Console, ICA or RDP.
Indexes
	PK_MachineUserHistoryWTSSessionInformation	Primary Key ON ID
	IX_MachineUserHistoryWTSSessionInformation_MachineUserHistoryID	Unique Index ON MachineUserHistoryID
Foreign Key
	FK_MachineUserHistoryWTSSessionInformation_MachineUserHistory	MachineUserHistoryID ↗ ❏ MachineUserHistory(ID)

Table MachineUserMUICache

Windows MUI cache information.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineUserID	bigint
*	Signature	nvarchar(max) COLLATE Latin1_General_CI_AS	Windows MUI signature
*	Company	nvarchar(255) COLLATE Latin1_General_CI_AS	Company information from the Windows MUI cache.
*	FriendlyAppName	nvarchar(255) COLLATE Latin1_General_CI_AS	Friendly application name from the Windows MUI cache
*	FirstScan	datetime2	First scan of this MUI cache entity in OctoSAM Inventory
*	LastScan	datetime2	Last scan of this MUI cache entity in OctoSAM Inventory
	Description	nvarchar(max) COLLATE Latin1_General_CI_AS	Description from the Windows MUI cache
	DisplayVersion	nvarchar(255) COLLATE Latin1_General_CI_AS	Display Version
	FileVersion	nvarchar(255) COLLATE Latin1_General_CI_AS	File Version from the version resource
	InternalName	nvarchar(255) COLLATE Latin1_General_CI_AS	Internal name of the executable from the version resource
	RawPublisher	nvarchar(255) COLLATE Latin1_General_CI_AS	Raw publisher name from the version resource
	Path	nvarchar(512) COLLATE Latin1_General_CI_AS	Path of the executable
	OriginalFilename	nvarchar(512) COLLATE Latin1_General_CI_AS	Original file name from the version resource
Indexes
	PK_MachineUserMUICache	Primary Key ON ID
Foreign Key
	FK_MachineUserMUICache_MachineUser	MachineUserID ↗ ❏ MachineUser(ID)

Table MachineUserOfficeAddIn

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineUserID	bigint
*	Application	nvarchar(128) COLLATE Latin1_General_CI_AS	Application that this add-in is registered to
*	Bits	int	Whether the add-in component is registered to the 32- or 64-bit version of the application
*	Name	nvarchar(128) COLLATE Latin1_General_CI_AS	Name of the add-in
	FriendlyName	nvarchar(256) COLLATE Latin1_General_CI_AS	Friendlier name of the add-in if provided
	Description	nvarchar(512) COLLATE Latin1_General_CI_AS	Description of the add-in
	LoadBehavior	int	Add-in load behaviour, see Microsoft documentation
	CommandLineSafe	int	See Microsoft documentation
	RegistryKeyLastWriteTime	datetime2	Date/Time of last write to the Registry key that registers the add-in
	RegistryPath	nvarchar(256) COLLATE Latin1_General_CI_AS	Registry path of the add-in registration
	ProgId	nvarchar(128) COLLATE Latin1_General_CI_AS	COM ProgramID of the add-in
	ClsId	nvarchar(50) COLLATE Latin1_General_CI_AS	COM CLSID of the add-in
	InProcServer	nvarchar(512) COLLATE Latin1_General_CI_AS	Path to the COM server
	ThreadingModel	nvarchar(50) COLLATE Latin1_General_CI_AS	Threading Model
	InProcServerDescription	nvarchar(512) COLLATE Latin1_General_CI_AS	Description of the InProcServer registration
	FileDescription	nvarchar(512) COLLATE Latin1_General_CI_AS	File description from the resource of the registered COM server binary
	FileVersion	nvarchar(128) COLLATE Latin1_General_CI_AS	File version from the resource of the registered COM server binary
	ProductName	nvarchar(256) COLLATE Latin1_General_CI_AS	Product name from the resource of the registered COM server binary
	ProductVersion	nvarchar(128) COLLATE Latin1_General_CI_AS	Product version from the resource of the registered COM server binary
	CompanyName	nvarchar(256) COLLATE Latin1_General_CI_AS	Company name from the resource of the registered COM server binary
	RawSoftwarePublisher	nvarchar(128) COLLATE Latin1_General_CI_AS	Software publisher as scanned from the resource of the registered COM server binary
	SoftwarePublisherID	bigint
	DisplayVersion	nvarchar(128) COLLATE Latin1_General_CI_AS	Display version of the add-in
Indexes
	PK_MachineUserOfficeAddIn	Primary Key ON ID
	IX_MachineUserOfficeAddIn_MachineUserID	Index ON MachineUserID
	IX_MachineUserOfficeAddIn_Name	Index ON Name
Foreign Key
	FK_MachineUserOfficeAddIn_MachineUser	MachineUserID ↗ ❏ MachineUser(ID)
	FK_MachineUserOfficeAddIn_SoftwarePublisher	SoftwarePublisherID ↗ ❏ SoftwarePublisher(ID)

Table MachineUserSecurityGroup

Reserved for use in future versions of OctoSAM Inventory.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineUserID	bigint
*	Name	nvarchar(512)	Name of the security group
*	Resolved	bit	True, if group name could be resolved, otherwise the group name usually contains the SID.
Indexes
	PK_MachineUserSecurityGroups	Primary Key ON ID
Foreign Key
	FK_MachineUserSecurityGroup_MachineUser	MachineUserID ↗ ❏ MachineUser(ID)

Table MachineUserSoftwareSignature

M:n relation between MachineUser and SoftwareSignature for per user signatures.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineUserID	bigint
*	SoftwareSignatureID	bigint
*	InformationSourceID	bigint
*	LastModification	datetime2	Date/Time of last write to this entity
*	LastScanGUID	uniqueidentifier	GUID of the scan that created this relation
*	LastScan	datetime2	Date/Time of the last scan that updated this relation
*	LastUsage	datetime2	For Metering signatures, date/time of last detected usage. Redundant to information in UsageDetail, provided for ease of querying and performance.
*	Created	datetime2	Date/Time this relation was created in the database
	InstallDate	datetime2	Date/Time of installation (if available)
*	FirstScan	datetime2	Date/Time of the scan that created this relation
	KeyLastWriteTime	datetime2	Date/Time the Registry for this signature was last updated
	AnalysisExtras	xml	Holds additional analysis data
	ScanHint	nvarchar(50) COLLATE Latin1_General_CI_AS	Additional information from the scanner for this machine to signature relation
Indexes
	PK_MachineUserSoftwareSignature	Primary Key ON ID
	IX_MachineUserSoftwareSignature_MachineUserID	Index ON MachineUserID
	IX_MachineUserSoftwareSignature_SoftwareSignature	Index ON SoftwareSignatureID
Foreign Key
	FK_MachineUserSoftwareSignature_InformationSource	InformationSourceID ↗ ❏ InformationSource(ID)
	FK_MachineUserSoftwareSignature_MachineUser	MachineUserID ↗ ❏ MachineUser(ID)
	FK_MachineUserSoftwareSignature_SoftwareSignature	SoftwareSignatureID ↗ ❏ SoftwareSignature(ID)

Table MailboxProvider

Mailbox provider information.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MailboxProviderTypeID	bigint
*	CloudProviderID	bigint
*	Name	nvarchar(128)	Name of the mailbox provider
*	Created	datetime2	Date/Time this entity got created in the database
*	CreatedGuid	datetime2	Guid of the scan that created this mailbox provider
Indexes
	PK_MailboxProvider	Primary Key ON ID
Foreign Key
	FK_MailboxProvider_CloudProvider	CloudProviderID ↗ ❏ CloudProvider(ID)
	FK_MailboxProvider_MailboxProviderType	MailboxProviderTypeID ↗ ❏ MailboxProviderType(ID)

Table MailboxProviderType

Type of mailbox provider

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(128)	Mailbox provider name
*	OctopusID	nvarchar(50)	OctoSAM internal name of the mailbox provider
Indexes
	PK_MailboxProviderType	Primary Key ON ID
Referring Foreign Key
	FK_MailboxProvider_MailboxProviderType	ID ↙ ❏ MailboxProvider(MailboxProviderTypeID)

Table Manufacturer

Provides normalized hardware manufacturer info

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier
*	Name	nvarchar(50)	Normalized hardware manufacturer name
*	Notes	nvarchar(max)	Custom notes
*	MasterNotes	nvarchar(max)	Notes from the master catalog
*	Url	nvarchar(128)	Url to the manufacturers website
*	AutoAssignRegex	nvarchar(1024)	Regular expression to discover manufacturer from hardware strings
	AutoAssignTestLikePattern	nvarchar(128)	SQL like pattern and/or regular expression to build test data for this manufacturer
*	PredefinedByOctopus	bit	True if the manufaturer definition is maintained by Octosoft..
*	Created	datetime2	Date/Time this object was created
*	CreatedBy	nvarchar(128)	User that created this object
*	LastModification	datetime2	Date/Time this manufacturer was last modified
*	LastModifiedBy	nvarchar(128)	User that modified this object
	MasterLastModdified	datetime2	Last modification timestamp of the manufacturer in the master catalog
	LastUpdateFromMaster	datetime2	Date/Time this manufacturer definition was last updated from master
	LastSynchWithMaster	datetime2	Date/Time this manufacturer definition was last synchronized with master
	CustomField1	nvarchar(255)	Custom field 1, not used by OctoSAM.
	CustomField2	nvarchar(255)	Custom field 2, not used by OctoSAM.
	CustomField3	nvarchar(255)	Custom field 3, not used by OctoSAM.
	CustomField4	nvarchar(255)	Custom field 4, not used by OctoSAM.
	ExtraData	nvarchar(max)	Extra data for this manufacturer
Indexes
	PK_Manufacturer	Primary Key ON ID
	UK_Manufacturer_Guid	Unique Key ON Guid
	UK_Manufacturer_Name	Unique Key ON Name
Referring Foreign Key
	FK_Machine_Manufacturer	ID ↙ ❏ Machine(ManufacturerID)
	FK_Machine_ProcessorManufacturer	ID ↙ ❏ Machine(ProcessorManufacturerID)

Table ObjectState

Reserved for future use.

Idx	Column Name	Definition	Description
*	ID	bigint
*	OctopusID	nvarchar(16) COLLATE Latin1_General_CI_AS	Octopus technical name of this state
*	Name	nvarchar(50) COLLATE Latin1_General_CI_AS	Object state name
*	Description	nvarchar(255) COLLATE Latin1_General_CI_AS	Object state description
Indexes
	PK_ObjectState	Primary Key ON ID
Referring Foreign Key
	FK_Machine_ObjectState	ID ↙ ❏ Machine(ObjectStateID)
	FK_SoftwarePublisher_ObjectState	ID ↙ ❏ SoftwarePublisher(ObjectStateID)
	FK_SoftwareSignature_ObjectState	ID ↙ ❏ SoftwareSignature(ObjectStateID)
	FK_User_ObjectState	ID ↙ ❏ User(ObjectStateID)

Table OptionalColumn

This table allows to show/hide columns in queries that use fieldsets. Columns that are not enabled are omitted from the query. This can be used to improve performance and readability of the column choosers.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(255) COLLATE Latin1_General_CI_AS	Name of the column
*	Enabled	bit	If False, the column is omitted from queries that use fieldsets
*	Created	datetime2	Date/Time this record got created
*	Build	nvarchar(50) COLLATE Latin1_General_CI_AS	OctoSAM build that created this record
Indexes
	PK_OptionalColumn	Primary Key ON ID
	UK_OptionalColumn_Name	Index ON Name

Table Organization

Defines the organizations of this OctoSAM installation.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier DEFAULT newid()
*	Name	nvarchar(128)	Name of the organization
*	Description	nvarchar(255) DEFAULT ''	Description
*	Notes	nvarchar(max) DEFAULT ''	Custom notes
*	LastModification	datetime2	Date/Time this record was last modified through the UI
*	LastModifiedBy	nvarchar(128)	Client user that last modified this record
	CustomField1	nvarchar(255) COLLATE Latin1_General_CI_AS	Available for custom data, not used by OctoSAM Inventory,
	CustomField2	nvarchar(255) COLLATE Latin1_General_CI_AS	Available for custom data, not used by OctoSAM Inventory,
	CustomField3	nvarchar(255) COLLATE Latin1_General_CI_AS	Available for custom data, not used by OctoSAM Inventory,
	CustomField4	nvarchar(255) COLLATE Latin1_General_CI_AS	Available for custom data, not used by OctoSAM Inventory,
Indexes
	PK_Organization	Primary Key ON ID
	IX_Organization	Unique Key ON Name
	UK_Organization_Guid	Unique Index ON Guid
Referring Foreign Key
	FK_DirectoryMissingMachine_Organization	ID ↙ ❏ DirectoryMissingMachine(OrganizationID)
	FK_DirectoryMissingUser_Organization	ID ↙ ❏ DirectoryMissingUser(OrganizationID)
	FK_LicenseManagerServer_LicenseManagerServer	ID ↙ ❏ LicenseManagerServer(OrganizationID)
	FK_Machine_Organization	ID ↙ ❏ Machine(OrganizationID)
	FK_OrganizationToken_Organization	ID ↙ ❏ OrganizationToken(OrganizationID)
	FK_SoftwareItemOrganization_Organization	ID ↙ ❏ SoftwareItemOrganization(OrganizationID)
	FK_User_Organization	ID ↙ ❏ User(OrganizationID)
	FK_StatisticsSummary_Organization	ID ↙ ❏ StatisticsSummary(OrganizationID)
	FK_RbacUserOrganization_Organization	ID ↙ ❏ RbacUserOrganization(OrganizationID)
	FK_RbacUserSelectedOrganization_Organization	ID ↙ ❏ RbacUserSelectedOrganization(OrganizationID)

Table OrganizationToken

Defines tokens for organization mapping

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	OrganizationID	bigint
*	Token	nvarchar(64)	A string that matches the token defined in the corresponding mapping rule
*	Notes	nvarchar(max) DEFAULT ''	Custom notes
Indexes
	PK_OrganizationToken	Primary Key ON ID
	IX_OrganizationToken_TokenUniqueConstraint	Unique Key ON Token
	IX_OrganizationToken_OrganizationID	Index ON OrganizationID
Foreign Key
	FK_OrganizationToken_Organization	OrganizationID ↗ ❏ Organization(ID)

Table PublishedSoftwarePackage

M:n relation between groups and software packages. Used for modelling published applications.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	SoftwarePackageID	bigint
*	GroupID	bigint
*	LastModification	datetime2	Date/Time this relation was last modified
*	LastModifiedBy	nvarchar(50)	Client user that last modified this relation
Indexes
	PK_PublishedSoftwarePackage	Primary Key ON ID
Foreign Key
	FK_PublishedSoftwarePackage_Group	GroupID ↗ ❏ Group(ID)
	FK_PublishedSoftwarePackage_SoftwarePackage	SoftwarePackageID ↗ ❏ SoftwarePackage(ID)

Table QueryPerformance

This table contains performance information for executed OctoSAM queries

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier	GUID of the query. Each query definition has a unique GUID.
*	Path	nvarchar(512) COLLATE Latin1_General_CI_AS	Repository path of the query at the time of execution
*	StartDateTime	datetime2	Date/Time the Query was started
*	DurationMillis	bigint	Duration of the Query
*	Rows	bigint	Number of rows the query returned
*	User	nvarchar(128) COLLATE Latin1_General_CI_AS	User that executed the query
*	Parameters	nvarchar(max) COLLATE Latin1_General_CI_AS	A JSON document containing the query parameters
*	Frontend	nvarchar(50) COLLATE Latin1_General_CI_AS	OctoSAM frontend / application that started the query
Indexes
	PK_QueryPerformance	Primary Key ON ID
	IX_QueryPerformance_Guid	Index ON Guid
	IX_QueryPerformance_User	Index ON User

Table RbacGroup

RBAC groups.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(128)	Name of the group
*	MailAddress	nvarchar(128)	Mail address of this group in Active Directory
*	DirectoryGUID	uniqueidentifier	Object-Guid attribute of this gorup in Active Directory
*	DirectoryDistinguishedName	nvarchar(512) DEFAULT ''	DN of this group in Active Directory
*	Created	datetime2	Date/Time the group object was created in the database
*	CreatedBy	nvarchar(128)	OctoSAM user that created the group
*	LastModification	datetime2	Date/Time the group object was last modified in the database
*	LastModifiedBy	nvarchar(128)	OctoSAM user that modified the group
*	PredefinedGroup	nvarchar(50)	Reserved for future use
	LastFoundInDirectory	datetime2	Date/Time the group was last found in Active Directory
	DirectoryWhenChanged	datetime2	whenChanged attribute from Active Directory
	DirectoryWhenCreated	datetime2	whenCreated attribute from Active Directory
	EntraIdTenantId	uniqueidentifier	Tenant ID for groups imported from Entra ID
	EntraIdId	nvarchar(128) COLLATE Latin1_General_CI_AS	EntraID ID for groups imported from Entra ID
	Description	nvarchar(512) COLLATE Latin1_General_CI_AS	Description of the group
	EntraIdOnPremisesSyncEnabled	bit	True,if this group was synchronized from an on premises Active Directory to Entra ID
	EntraIdOnPremisesLastSyncDateTime	datetime2	Date/Time the group was last synchronized
	EntraIdClassification	nvarchar(128) COLLATE Latin1_General_CI_AS	classification property from Entra ID
	EntraIdOnPremisesNetbiosName	nvarchar(128) COLLATE Latin1_General_CI_AS	NETBIOS name of the on premises Group
	EntraIdOnPremisesSamAccountName	nvarchar(128) COLLATE Latin1_General_CI_AS	SAMAccount name of the on premises Group
	EntraIdGroupTypes	nvarchar(128) COLLATE Latin1_General_CI_AS	List of group types from Entra ID
	EntraIdSecurityEnabled	bit	True if this group is an Entra ID security group
Indexes
	PK_RbacGroup	Primary Key ON ID
	IX_RbacGroup_DirectoryGUID	Unique Index ON DirectoryGUID
	UK_RbacGroup_Name	Unique Key ON Name
Referring Foreign Key
	FK_RbacGroupRole_RbacRole1	ID ↙ ❏ RbacGroupRole(RbacGroupID)
	FK_RbacUserGroup_RbacUserGroup	ID ↙ ❏ RbacUserGroup(RbacGroupID)

Table RbacGroupRole

M:n relation between group and role. A user can be directly in a role (via RbacUserRole) or indirectly via RbacUsergroup and RbacGroupRole

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	RbacGroupID	bigint
*	RbacRoleID	bigint
*	Created	datetime2	Date/TIme the relation was created
	CreatedByRbacUserID	bigint
Indexes
	PK_RbacGroupRole	Primary Key ON ID
	UK_RbacGroupRole_GroupIDRoleID	Unique Key ON RbacGroupID, RbacRoleID
	IX_RbacGroupRole_RbacRoleID	Index ON RbacRoleID
Foreign Key
	FK_RbacGroupRole_RbacRole1	RbacGroupID ↗ ❏ RbacGroup(ID)
	FK_RbacGroupRole_RbacRole	RbacRoleID ↗ ❏ RbacRole(ID)
	FK_RbacGroupRole_RbacUser	CreatedByRbacUserID ↗ ❏ RbacUser(ID)

Table RbacObject

Lookup table for object names for RbacRolePrivilegeConstraint

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(128)	Name of the rbac object
Indexes
	PK_RbacObject	Primary Key ON ID
	UK_RbacObject_Name	Unique Key ON Name
Referring Foreign Key
	FK_RbacPrivilege_RbacObject	ID ↙ ❏ RbacPrivilege(ConstrainedRbacObjectID)

Table RbacPrivilege

Contains database representation of single privileges

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(256)	Name of the privilege. This name is internal to OctoSAM and cannot be changed.
*	Description	nvarchar(256)	Descritpion of the privilege. Displayed in RBAC related user interfaces.
*	ConstrainedRbacObjectID	bigint
*	Created	datetime2	Date/Time this privilege object was created
*	CreatedBy	nvarchar(128)	OctoSAM user that created this privilege
*	LastModification	datetime2	Date/Time this privilege object was last modified
*	LastModifiedBy	nvarchar(128)	OctoSAM user that last modified this entity
Indexes
	PK_RbacPrivilege	Primary Key ON ID
Foreign Key
	FK_RbacPrivilege_RbacObject	ConstrainedRbacObjectID ↗ ❏ RbacObject(ID)
Referring Foreign Key
	FK_RbacRolePrivilege_RbacRolePrivilege	ID ↙ ❏ RbacRolePrivilege(RbacPrivilegeID)

Table RbacRole

A role is a collection of privileges

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(128)	Name of the Role
*	Description	nvarchar(256)	Description of the Role
*	Notes	nvarchar(max)	Notes
*	Created	datetime2	Date/Time the role object was created
*	LastModification	datetime2	Date/Time the role object was last modified
*	CreatedBy	nvarchar(128)	OctoSAM user that created the object
*	LastModifiedBy	nvarchar(128)	OctoSAM user that last modified the object
*	PredefinedByOctopus	bit DEFAULT 0	True for OctoSAM predefined Roles, these roles cannot be deleted.
Indexes
	PK_RbacRole	Primary Key ON ID
Referring Foreign Key
	FK_RbacGroupRole_RbacRole	ID ↙ ❏ RbacGroupRole(RbacRoleID)
	FK_RbacRolePrivilege_RbacRole	ID ↙ ❏ RbacRolePrivilege(RbacRoleID)
	FK_RbacUserRole_RbacRole	ID ↙ ❏ RbacUserRole(RbacRoleID)

Table RbacRolePrivilege

M:n relation between Privileges and Roles

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	RbacRoleID	bigint
*	RbacPrivilegeID	bigint
*	Created	datetime2	Date/Time the object was created,
*	CreatedBy	nvarchar(128)	OctoSAM user that created the object
*	LastModification	datetime2	Date/Time the object was last modified,
*	LastModifiedBy	nvarchar(128)	OctoSAM user that last modified the object,
Indexes
	PK_RbacRolePrivilege	Primary Key ON ID
	UK_RbacRolePrivilege_RoleIDPrivilegeID	Unique Key ON RbacRoleID, RbacPrivilegeID
	IX_RbacRolePrivilege_RbacPrivilegeID	Index ON RbacPrivilegeID
Foreign Key
	FK_RbacRolePrivilege_RbacRolePrivilege	RbacPrivilegeID ↗ ❏ RbacPrivilege(ID)
	FK_RbacRolePrivilege_RbacRole	RbacRoleID ↗ ❏ RbacRole(ID)

Table RbacUser

User object for RBAC. Typically replicated from Active Directory

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(128)	Unique user name
*	PrintableName	nvarchar(256)	Printable name showed for this user in the user interface
*	DirectoryGUID	uniqueidentifier	Object-GUID attribute from Active Directory
*	DirectoryDistinguishedName	nvarchar(512) DEFAULT ''	DN of this user in Active Directory
*	TelephoneNumber	nvarchar(256) DEFAULT ''	telephoneNumber attribute of this user in ActiveDirectory
*	UserPrincipalName	nvarchar(256)	userPrincipalName attribute of this user in Active Directory
*	MailAddress	nvarchar(256)	mail attribute of this user in Active Directory,
	UserID	bigint	Optional, ID of OctoSAM Inventory user object if one can be mapped.
*	Enabled	bit	True if the user is enabled in Active Directory
*	Created	datetime2	Date/Time this object was created
*	CreatedBy	nvarchar(128)	OctoSAM user that created the object
*	LastModification	datetime2	Date/Time this object was last modified
*	LastModifiedBy	nvarchar(128)	OctoSAM user that last modified the object
*	LastFoundInDirectory	datetime2	Date/Time this object was last found in Active Directory
	DirectoryWhenCreated	datetime2	whenCreated attribute from Active Directory
	DirectoryWhenChanged	datetime2	whenChanged attribute from Active Directory
*	DeletedInDirectory	bit DEFAULT 0	True if the account was deleted in Active Directory but cannot be removed from the database due to referential integrity. For example if set as SoftwareItem owner.
	DeletedInDirectoryFirstDetected	datetime2	Date/Time the Deleted in Directory flag was set
	DirectoryAccountExpires	datetime2	accountExpires attribute from ActiveDirectory
	PasswordLastSet	datetime2	Date/Time the password was last set in Active Directory
	PasswordNeverExpires	bit	True if the Password Never Expires flag is set in Active Directory
	UserPasswordExpiryTime	datetime2	Calculated date/time the password will expire
	EntraIdTenantId	uniqueidentifier	Entra ID tenant ID of this RBAC user
	EntraIdId	nvarchar(128) COLLATE Latin1_General_CI_AS	Entra ID ID of this RBAC user
	Notes	nvarchar(max) COLLATE Latin1_General_CI_AS	Notes for this RBAC user
	HashedKey	nvarchar(max) COLLATE Latin1_General_CI_AS	Reserved for future use
	ExtraData	nvarchar(max) COLLATE Latin1_General_CI_AS	Extra data in JSON format
	DirectoryMsDSConsistencyGuid	uniqueidentifier	A unique ID used by Microsoft Entra ID to synchronize user information,
	Res1	nvarchar(256) COLLATE Latin1_General_CI_AS	Reserved for future use
	Res2	nvarchar(256) COLLATE Latin1_General_CI_AS	Reserved for future use
	Res3	nvarchar(256) COLLATE Latin1_General_CI_AS	Reserved for future use
	Res4	nvarchar(256) COLLATE Latin1_General_CI_AS	Reserved for future use
	EntraIdOnPremisesSyncEnabled	bit	True if the Entra ID user was synchronized from an on premises active directory
	EntraIdOnPremisesLastSyncDateTime	datetime2	Date/Time the user was last synchronized
	EntraIdLastSignInDateTime	datetime2	Date/Time the user last signed in with Microsoft Entra ID
Indexes
	PK_RbacUser	Primary Key ON ID
	IX_RbacUser_DirectoryGUID	Unique Index ON DirectoryGUID
	UK_RbacUser_Name	Unique Key ON Name
	IX_RbacUser_UserID	Index ON UserID	access rbac user via inventory user id
	IX_RbacUser_EntraIdId	Index ON EntraIdId
Foreign Key
	FK_RbacUser_User	UserID ↗ ❏ User(ID)
Referring Foreign Key
	FK_LicenseManagerRbacUserFavoriteFeature_RbacUser	ID ↙ ❏ LicenseManagerRbacUserFavoriteFeature(RbacUserID)
	FK_RbacGroupRole_RbacUser	ID ↙ ❏ RbacGroupRole(CreatedByRbacUserID)
	FK_RbacUserGroup_RbacUser	ID ↙ ❏ RbacUserGroup(RbacUserID)
	FK_RbacUserPreferences_RbacUser	ID ↙ ❏ RbacUserPreferences(RbacUserID)
	FK_RbacUserRole_RbacUser	ID ↙ ❏ RbacUserRole(RbacUserID)
	FK_RbacUserRole_RbacUser_Created	ID ↙ ❏ RbacUserRole(CreatedByRbacUserID)
	FK_RecentlyUsedObject_RbacUser	ID ↙ ❏ RecentlyUsedObject(RbacUserID)
	FK_SoftwareItemOwner_RbacUser	ID ↙ ❏ SoftwareItemOwner(RbacUserID)
	FK_RbacUserOrganization_RbacUser	ID ↙ ❏ RbacUserOrganization(RbacUserID)
	FK_RbacUserSelectedOrganization_RbacUser	ID ↙ ❏ RbacUserSelectedOrganization(RbacUserID)

Table RbacUserGroup

M:n User to Group relation. Replicated from Active Directory

Idx	Column Name	Definition
*	ID	bigint IDENTITY
*	RbacUserID	bigint
*	RbacGroupID	bigint
Indexes
	PK_RbacUserGroup	Primary Key ON ID
	UK_RbacUserGroup_UserIDGroupID	Unique Key ON RbacUserID, RbacGroupID
	IX_RbacUserGroup_RbacGroupID	Index ON RbacGroupID
Foreign Key
	FK_RbacUserGroup_RbacUserGroup	RbacGroupID ↗ ❏ RbacGroup(ID)
	FK_RbacUserGroup_RbacUser	RbacUserID ↗ ❏ RbacUser(ID)

Table RbacUserOrganization

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

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	RbacUserID	bigint
*	OrganizationID	bigint
*	UpdateEnabled	bit	If True, the RBAC user has update privileges in this organization. Update privileges for objects and fields are also required.
Indexes
	PK_RbacUserOrganization	Primary Key ON ID
	UK_RbacUserOrganization_RbacUser_Organization	Unique Key ON RbacUserID, OrganizationID
Foreign Key
	FK_RbacUserOrganization_Organization	OrganizationID ↗ ❏ Organization(ID)
	FK_RbacUserOrganization_RbacUser	RbacUserID ↗ ❏ RbacUser(ID)
	FK_RbacUserOrganization_RbacUserOrganization	ID ↗ ❏ RbacUserOrganization
Referring Foreign Key
	FK_RbacUserOrganization_RbacUserOrganization	ID ↙ ❏ RbacUserOrganization

Table RbacUserPreferences

Stores user preferences for web applications.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	RbacUserID	bigint
*	Name	nvarchar(64)	Name of the preference setting
*	LastModification	datetime2	Date/Time this setting was last modified
*	Value	nvarchar(max)	String representation of the value
	XmlValue	xml	Optional for Xml Values that need to be referenced by SQL
	BlobValue	varbinary(max)	Optional for binary settings values
	DateTimeValue	datetime2	Date/Time representation of the value
	BooleanValue	bit	Boolean representation of the value
	IntegerValue	bigint	Integer representation of the value
Indexes
	PK_RbacUserPreferences	Primary Key ON ID
	UK_RbacUserPreferences_RbacUserID_Name	Unique Key ON RbacUserID, Name
Foreign Key
	FK_RbacUserPreferences_RbacUser	RbacUserID ↗ ❏ RbacUser(ID)

Table RbacUserRole

M:n User to Role relation for users with directly assigned roles.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	RbacUserID	bigint
*	RbacRoleID	bigint
*	Created	datetime2	Date/Time this relation got created
	CreatedByRbacUserID	bigint	Rbac User that created this relationship
Indexes
	PK_RbacUserRole	Primary Key ON ID
	UK_RbacUserRole_UserIDRoleID	Unique Key ON RbacUserID, RbacRoleID
	IX_RbacUserRole_RbacRoleID	Index ON RbacRoleID
Foreign Key
	FK_RbacUserRole_RbacRole	RbacRoleID ↗ ❏ RbacRole(ID)
	FK_RbacUserRole_RbacUser	RbacUserID ↗ ❏ RbacUser(ID)
	FK_RbacUserRole_RbacUser_Created	CreatedByRbacUserID ↗ ❏ RbacUser(ID)

Table RbacUserSelectedOrganization

Idx	Column Name	Data Type
*	ID	bigint IDENTITY
*	RbacUserID	bigint
*	OrganizationID	bigint
Indexes
	PK_RbacUserSelectedOrganization	Primary Key ON ID
	UK_RbacUserSelectedOrganization_RbacUser_Organization	Unique Key ON RbacUserID, OrganizationID
Foreign Key
	FK_RbacUserSelectedOrganization_Organization	OrganizationID ↗ ❏ Organization(ID)
	FK_RbacUserSelectedOrganization_RbacUser	RbacUserID ↗ ❏ RbacUser(ID)

Table RecentlyUsedObject

Per user recently used objects.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	RbacUserID	bigint
*	RecentlyUsedObjectTypeID	bigint
*	ObjectGuid	uniqueidentifier
*	FirstUsed	datetime2	Date/Time the object was first used
*	LastUsed	datetime2	Date/Time the object was last used
*	UsageCount	bigint	Number of times the object was used
	Favorite	bit	True if the user selected this object as a favorite
	ExtraData	nvarchar(max)	Extra data for this recently used object
Indexes
	PK_RecentlyUsedObject	Primary Key ON ID
	UK_RecentlyUsedObject_RbacUserIDRecentyUsedObjctTypeIDObjectGuid	Unique Key ON RbacUserID, RecentlyUsedObjectTypeID, ObjectGuid
Foreign Key
	FK_RecentlyUsedObject_RbacUser	RbacUserID ↗ ❏ RbacUser(ID)
	FK_RecentlyUsedObject_RecentlyUsedObjectType	RecentlyUsedObjectTypeID ↗ ❏ RecentlyUsedObjectType(ID)

Table RecentlyUsedObjectType

Lookup table for recently used object types.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	ObjectName	nvarchar(50)	Name of the recently used object type
*	DisplayName	nvarchar(50)	Display name of the recently used object type
Indexes
	PK_RecentlyUsedObjectType	Primary Key ON ID
	UK_RecentlyUsedObjectType_ObjectName	Unique Key ON ObjectName
Referring Foreign Key
	FK_RecentlyUsedObject_RecentlyUsedObjectType	ID ↙ ❏ RecentlyUsedObject(RecentlyUsedObjectTypeID)

Table Repository

Centrally store queries, reports and scripts that can be used by multiple components.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	GUID	uniqueidentifier	GUID if supported by the content type stored in the repository item
	CustomerID	uniqueidentifier	A Guid that identifies the customer for customer specific items
	InstallationID	uniqueidentifier	Reserved for future use
*	Enabled	bit DEFAULT 1	This item is selectable in the gui / runnable in services
*	Path	nvarchar(256)	A logical path name that optionally specifies the position of this item in tree structures
*	Blob	varbinary(max)	Contents of this repository item
*	Description	nvarchar(max)	Description if supported by the repository type
*	Created	datetime2	Date/Time this item was created
*	CreatedBy	nvarchar(64)	User that created this item
*	LastModification	datetime2	Date/Time this item was last modified
*	LastModifiedBy	nvarchar(128)	User that last modified this item
*	RepositoryGroup	nvarchar(16)	An identification string that can be be referenced when loading repository items
*	SourceLastModified	datetime2 DEFAULT CONVERT([datetime2],'0001-01-01',(0))	Last write time of the source file
*	SupportWeb	bit DEFAULT 1	This resource can be used by web applications
*	SupportDesktop	bit DEFAULT 1	This resource can be used by desktop applications
	RequiredPrivileges	nvarchar(max)	List of rbac privileges required to enable this item
	Hash	nvarchar(128)	Hash calculated over the repository binary contents
	ExtraData	nvarchar(max) COLLATE Latin1_General_CI_AS	Extra data for this repository item
	RequiredModules	nvarchar(256) COLLATE Latin1_General_CI_AS	Required modules to enable this item
	DocumentationPath	nvarchar(256) COLLATE Latin1_General_CI_AS	Path into online documentation of this item
Indexes
	PK_Repository	Primary Key ON ID
	IX_Repository_Path	Unique Index ON Path
	IX_Repository	Index ON GUID

Table SerilogEvent

Contains events from the Serilog logging framework, see Serilog documentation.

Idx	Column Name	Definition
*	Id	bigint IDENTITY
	Message	nvarchar(max)
	MessageTemplate	nvarchar(max)
	Level	nvarchar(128)
*	TimeStamp	datetime
	Exception	nvarchar(max)
	Properties	nvarchar(max)
	SourceContext	nvarchar(max)
Indexes
	PK_SerilogEvent	Primary Key ON Id
	IX_SerilogEvent_Timestamp	Index ON TimeStamp

Table SoftwareCatalogConflict

Contains conflicts detected by the software catalog update mechanism.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Created	datetime2	Date/Time the entry was created
*	SoftwareSignatureID	bigint
	SoftwarePackageID	bigint
	SoftwarePackageGuid	uniqueidentifier
*	Action	nvarchar(50) DEFAULT ''	Catalog action that causes the conflict
*	CatalogVersion	nvarchar(128)	Version info of used catalog
*	Notes	nvarchar(max)	Notes written during the catalog update process
Indexes
	PK_SoftwareCatalogConflict	Primary Key ON ID
Foreign Key
	FK_SoftwareCatalogConflict_SoftwarePackage	SoftwarePackageID ↗ ❏ SoftwarePackage(ID)
	FK_SoftwareCatalogConflict_SoftwareSignature	SoftwareSignatureID ↗ ❏ SoftwareSignature(ID)

Table SoftwareCategory

Defines the software categories.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(32)	Name of the software category
*	Description	nvarchar(255) DEFAULT ''	Description
*	SortOrder	int DEFAULT 0	OctoSAM Inventory sorts categories in ascending sort order by default
*	Junk	bit DEFAULT 0	Flag to signal a category as junk. junk categories can be ignored on some reports and queries.
	Custom1	nvarchar(255)	Custom Field 1, not used by OctoSAM.
	Custom2	nvarchar(255)	Custom Field 2, not used by OctoSAM.
*	Notes	nvarchar(max) DEFAULT ''	Notes
*	LastModification	datetime2	Date/Time the category was last modified
*	LastModifiedBy	nvarchar(128)	Client user that last modified this Software category
*	OctopusID	nvarchar(32)	Internal ID for predefined software categories, used for catalog updates.
Indexes
	PK_SoftwareCategory	Primary Key ON ID
	IX_SoftwareCategory_Name	Unique Index ON Name
	IX_SoftwareCategory_OctopusID	Index ON OctopusID
Referring Foreign Key
	FK_SoftwarePackage_SoftwareCategory	ID ↙ ❏ SoftwarePackage(SoftwareCategoryID)

Table SoftwareItem

Software items hold customer specific information about software objects.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
	SoftwarePublisherID	bigint
*	Guid	uniqueidentifier	Unique ID of the item, can be used for export/import or for the web UI.
	SiteUniqueID	nvarchar(128)	A site defined unique id for each item. Must be unique if not empty.
*	Name	nvarchar(128)	Name of the software Item
*	Version	nvarchar(128)	Version of the software item
	StartDate	datetime2	Start date of the software item
	EndDate	datetime2	End date of the software item
	AdditionalInfoLink	nvarchar(256)	Can contain a link to additional information
*	Description	nvarchar(max)	Description of the item. Can be html formatted.
*	Notes	nvarchar(max)	Remarks that are visible to all users that have read access to the item
	InitialCost	decimal(18,2)	Initial Cost
	InitialCostCurrencyID	bigint
	CustomField1	nvarchar(max)	Custom field 1, not used by OctoSAM.
	CustomField2	nvarchar(max)	Custom field 2, not used by OctoSAM.
	CustomField3	nvarchar(max)	Custom field 3, not used by OctoSAM.
	CustomField4	nvarchar(max)	Custom field 4, not used by OctoSAM.
	CustomField5	nvarchar(max)	Custom field 5, not used by OctoSAM.
	CustomField6	nvarchar(max)	Custom field 6, not used by OctoSAM.
	Res1	nvarchar(max)	Reserved for future use
	Res2	nvarchar(max)	Reserved for future use
*	Created	datetime2	Date/Time the item got created
*	LastModification	datetime2	Date/Time the item was last modified
*	CreatedByRbacUserID	bigint	RBAC user that created the item
*	LastModifiedByRbacUserID	bigint	RBAC user that last modified the item
*	VisibleStartDate	datetime2	Item becomes automatically visible after this date
*	Visible	bit	Item is visible
*	Enabled	bit	If not enabled, the Item cannot be edited.
*	OwnerNotes	nvarchar(max) DEFAULT ''	Remarks that can only be read by software package owners
	RecurringCost	decimal(18,2)	Recurring Cost
	RecurringCostCurrencyID	bigint
*	PrintableName	nvarchar(255) DEFAULT ''	Name of this item for reports and queries
*	Active	bit DEFAULT 1	Mark the Item as active. Inactive items can be hidden from most lists.
*	AdministratorNotes	nvarchar(max) DEFAULT ''	Remarks that can only be read by a small group of users
	Units	decimal(18,0)	A universal field that can contain a number
	ExtraData	nvarchar(max)	Extra data for this software item
	SoftwareInstallationApproval	bit	Installation approval logic is active for this software item
	Spla	bit	True, if the Software Item describes a Microsoft SPLA item
Indexes
	PK_SoftwareItem	Primary Key ON ID
	UK_SoftwareItem_Guid	Unique Key ON Guid
	UK_SoftwareItem_UniqueNameVersion	Unique Key ON Name, Version
	IX_SoftwareItem_SoftwarePublisherID	Index ON SoftwarePublisherID
	IX_SoftwareItem_SiteUniqueID	Unique Index ON SiteUniqueID
Foreign Key
	FK_SoftwareItem_InitialCostCurrency	InitialCostCurrencyID ↗ ❏ Currency(ID)
	FK_SoftwareItem_RecurringCostCurrency	RecurringCostCurrencyID ↗ ❏ Currency(ID)
	FK_SoftwareItem_SoftwarePublisher	SoftwarePublisherID ↗ ❏ SoftwarePublisher(ID)
Referring Foreign Key
	FK_SoftwareItemLicenseManagerServer_SoftwareItem	ID ↙ ❏ SoftwareItemLicenseManagerServer(SoftwareItemID)
	FK_SoftwareItemMachine_SoftwareItem	ID ↙ ❏ SoftwareItemMachine(SoftwareItemID)
	FK_SoftwareItemOrganization_SoftwareItem	ID ↙ ❏ SoftwareItemOrganization(SoftwareItemID)
	FK_SoftwareItemSoftwarePackage_SoftwareItem	ID ↙ ❏ SoftwareItemSoftwarePackage(SoftwareItemID)
	FK_SoftwareItemUser_SoftwareItem	ID ↙ ❏ SoftwareItemUser(SoftwareItemID)

Table SoftwareItemLicenseManagerServer

M:n relation between SoftwareItem and LicenseManagerServer tables

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	SoftwareItemID	bigint
*	LicenseManagerServerID	bigint
*	Created	datetime2	Date/Time this entity got created in the database
	CreatedBy	nvarchar(50)	User that created this relation
Indexes
	PK_SoftwareItemLicenseManagerServer	Primary Key ON ID
	IX_SoftwareItemLicenseManagerServer_LicenseManagerServerID	Index ON LicenseManagerServerID
	IX_SoftwareItemLicenseManagerServer_SoftawareItemID	Index ON SoftwareItemID
Foreign Key
	FK_SoftwareItemLicenseManagerServer_LicenseManagerServer	LicenseManagerServerID ↗ ❏ LicenseManagerServer(ID)
	FK_SoftwareItemLicenseManagerServer_SoftwareItem	SoftwareItemID ↗ ❏ SoftwareItem(ID)

Table SoftwareItemMachine

M:n SoftwareItem to Machine relation, for Items that are linked to specific machines

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	SoftwareItemID	bigint
*	MachineID	bigint
*	Created	datetime2	Date/Time this relation got created
*	CreatedBy	nvarchar(128)	User that created this relation
*	LastModification	datetime2	Date/Time this relation got last modified
*	LastModifiedBy	nvarchar(128)	User that last modified this relation
	ExtraData	nvarchar(max) COLLATE Latin1_General_CI_AS	Reserved for future use
	Res1	nvarchar(128) COLLATE Latin1_General_CI_AS	Reserved for future use
	Res2	nvarchar(128) COLLATE Latin1_General_CI_AS	Reserved for future use
Indexes
	PK_SoftwareItemMachine	Primary Key ON ID
Foreign Key
	FK_SoftwareItemMachine_Machine	MachineID ↗ ❏ Machine(ID)
	FK_SoftwareItemMachine_SoftwareItem	SoftwareItemID ↗ ❏ SoftwareItem(ID)

Table SoftwareItemOrganization

M:n SoftwareItem to Organization relation for Items that are linked to specific organizattions

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	OrganizationID	bigint
*	SoftwareItemID	bigint
*	Visible	bit	Reserved for future use
*	MachineEntitled	bit	True if machines of the organizations are entitled
*	UserEntitled	bit	True if users of the organization are entitled
Indexes
	PK_SoftwareItemOrganization	Primary Key ON ID
Foreign Key
	FK_SoftwareItemOrganization_Organization	OrganizationID ↗ ❏ Organization(ID)
	FK_SoftwareItemOrganization_SoftwareItem	SoftwareItemID ↗ ❏ SoftwareItem(ID)

Table SoftwareItemOwner

M:n relation between SoftwareItem and RBAC User. Models software item ownership. Software Item Owners can be assigned special privileges on their owned products.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	RbacUserID	bigint
*	SoftwareItemID	bigint
*	Created	datetime	Date/Time this relation got created
*	CreatedByRbacUserID	bigint	Rbac User that created the relation
Indexes
	PK_SoftwareListOwner	Primary Key ON ID
	IX_SoftwareItemOwner_RbacUserID	Index ON RbacUserID
	IX_SoftwareItemOwner_SoftwareItemID	Index ON SoftwareItemID
Foreign Key
	FK_SoftwareItemOwner_RbacUser	RbacUserID ↗ ❏ RbacUser(ID)
	FK_SoftwareItemOwner_SoftwareItemOwner	ID ↗ ❏ SoftwareItemOwner
Referring Foreign Key
	FK_SoftwareItemOwner_SoftwareItemOwner	ID ↙ ❏ SoftwareItemOwner

Table SoftwareItemSoftwarePackage

M:n relation between SoftwareItem and SoftwarePackage

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	SoftwarePackageID	bigint
*	SoftwareItemID	bigint
	Created	datetime2	Date/Time this entity got created
	CreatedBy	nvarchar(50) COLLATE Latin1_General_CI_AS	User who created this entity
Indexes
	PK_SoftwareListSoftwarePackage	Primary Key ON ID
	IX_SoftwareItemSoftwarePackage_SoftwareItemID	Index ON SoftwareItemID
	IX_SoftwareItemSoftwarePackage_SoftwarePackageID	Index ON SoftwarePackageID
Foreign Key
	FK_SoftwareItemSoftwarePackage_SoftwareItem	SoftwareItemID ↗ ❏ SoftwareItem(ID)
	FK_SoftwareItemSoftwarePackage_SoftwarePackage	SoftwarePackageID ↗ ❏ SoftwarePackage(ID)

Table SoftwareItemUser

M:n relation between SoftwareItem and User for items that are linked to specific users

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	SoftwareItemID	bigint
*	UserID	bigint
*	Created	datetime2	Date/Time this relation got created
*	CreatedBy	nvarchar(128)	User that created the relation
*	LastModification	datetime2	Date/Time this relation got last updated
*	LastModifiedBy	nvarchar(128)	User that last modified the relation
Indexes
	PK_SoftwareItemUser	Primary Key ON ID
	IX_SoftwareItemUser_SoftwareItemID	Index ON SoftwareItemID
	IX_SoftwareItemUser_UserID	Index ON UserID
Foreign Key
	FK_SoftwareItemUser_SoftwareItem	SoftwareItemID ↗ ❏ SoftwareItem(ID)
	FK_SoftwareItemUser_User	UserID ↗ ❏ User(ID)

Table SoftwareLicensingType

Licensing Type (Freware, Shareware, Commercial etc.).

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	OctopusID	nvarchar(32)	Internal Id used for catalog updates
*	Name	nvarchar(50)	Name
*	LicensingRelevant	bit	True for commercial licensing types
Indexes
	PK_SoftwareLicensingType	Primary Key ON ID
	IX_SoftwareLicensingType_Name	Unique Index ON Name
Referring Foreign Key
	FK_SoftwarePackage_SoftwareLicensingType	ID ↙ ❏ SoftwarePackage(SoftwareLicensingTypeID)

Table SoftwarePackage

A software package defines a logical software entity. A software package can own 0 to n software signatures.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(255)	Name of the software package
*	Notes	nvarchar(max) DEFAULT ''	Custom notes
*	SoftwareCategoryID	bigint
*	SoftwarePublisherID	bigint
*	LastModification	datetime2	Date/Time of last write to this software package
	DeploymentGroup	nvarchar(255)	Can be used to assign security groups to machine objects in the directory. Some software deployment systems use this to determine what package to install on what machine (or for which user).
*	MeteringEnabled	bit DEFAULT 0	True, if the software package definition supports package metering.
	CustomField1	nvarchar(255)	Custom data not used by OctoSAM
	CustomField2	nvarchar(255)	Custom data not used by OctoSAM
*	PredefinedByOctopus	bit DEFAULT 0	The package definition is maintained through OctoSAM master catalog updates
*	PredefinedSiteSpecific	bit DEFAULT 0	The package definition is maintained by Octosoft through OctoSAM site specific master catalog updates
	CustomField3	nvarchar(255)	Custom Data - not used by OctoSAM Inventory
	CustomField4	nvarchar(255)	Custom Data - not used by OctoSAM Inventory
	SynchTokenID	nvarchar(255)	Can be used for synchronization with another inventory or CMDB system. Holds the key to the identical item in the CMDB. Not used by OctoSAM Inventory.
	SynchLastSynch	datetime2	Date/Time of last synchronization of this SoftwarePackage with the partner CMDB. Not used by OctoSAM Inventory.
*	AutoAssignEnabled	bit DEFAULT 0	Auto assign rules for new signatures enabled
*	AutoAssignRegex	nvarchar(2048)	A regular expression that is used to automatically assign new signatures to this software package
	AutoAssignTestLikePattern	nvarchar(128)	SQL LIKE and/or regular expression pattern used to select signatures for auto assign testing
*	LastModifiedBy	nvarchar(128)	Client User that last modified this software package through the Octopus UI
*	DeploymentAction	nchar(1) DEFAULT N'U'	Used for deployment consolidation. Can be 'U' for Unknown, 'A' for Approved, 'R' for Replace with, or 'I' for Ignored.
	DeploymentReplacementSoftwarePackageID	bigint	If DeploymentAction = 'R', this Field holds the PackageID of the replacement package
	Res1	nvarchar(64)	Reserved for internal use by future versions
	Res2	nvarchar(64)	Reserved for internal use by future versions
*	Created	datetime2	Date/Time package was created in the database
*	CreatedBy	nvarchar(64)	User that created the package
	CreatedGuid	uniqueidentifier	Reserved for future use
*	KeepDynamicMachineSignatureRelations	bit DEFAULT 0	Prevents automatic dynamic signature to machine reorg. Dynamic signatures (processes) to machine relations are cleared after 10 days if they are not in a software package with static signature relations to the same machine or this flag set.
*	Guid	uniqueidentifier	GUID used for catalog updates. Stays the same for all OctoSAM defined software packages through the lifecycle of the package definition. Allows rename and delete of packages during catalog update.. Do not set if definig your own custom packages directly in the database.
*	SoftwareLicensingTypeID	bigint
	LastUpdateFromMaster	datetime2	Date/Time a software catalog update last updated this package
	LastSynchWithMaster	datetime2	Date/Time time a software catalog update contained this package
	MasterLastModified	datetime2	Date/Time master definition was updated. by Octosoft.
	MasterLastModifiedBy	nvarchar(128)	User that updated the softwrae catalog
*	MasterNotes	nvarchar(max) DEFAULT ''	Package master catalog notes
*	AutoAssignNotes	nvarchar(max) DEFAULT ''	Notes about quirks in the AutoAssign rules
*	SwidTagMayRemainOnUninstall	bit DEFAULT 0	Set to true for software that routinely leaves the swid tag file behind on uninstall. Adobe is known for this behaviour.
*	IgnoreSignaturePublishers	bit DEFAULT 0	If set to true, OcoSAM Inventory does not try to find the package publisher based on signature publishers.
	MeteringRegex	nvarchar(2048)	Reserved for future use
	MeteringTestLikePattern	nvarchar(128)	Reserved for future use
	AuxiliaryRegex	nvarchar(2048)	Reserved for future use
	AuxiliaryTestLikePattern	nvarchar(128)	Reserved for future use
	SoftwareProductVersionID	bigint	Reserved for future use
	EditionName	nvarchar(128)	Reserved for future use
*	EditionPriority	int DEFAULT 0	Reserved for future use
	HintSoftwarePackageUsageStartDate	datetime2	Min consolidated usage date for this software package
	HintSoftwarePackageUsageEndDate	datetime2	Max consolidated usage date for this Package
	HintHasSoftwareItems	bit	True if the Software Package is linked to at least one SoftwareItem
	CustomerID	uniqueidentifier	A guid that indicates the customer for client specific packages
	InstallationID	uniqueidentifier	Reserved for future use,
	AnalysisExtras	xml	Holds additional analysis data,
	ServiceNowSysID	uniqueidentifier	Service Now: sys_id of replicated object,
	ServiceNowLastExport	datetime2	Date/Time of last export to ServiceNow,
	ServiceNowLastImport	datetime2	Date/Time of last import from ServiceNow,
	ExtraData	nvarchar(max)	Extra data for this object (JSON),
	LifecycleSupportPolicy	nvarchar(50)	For package specific software life cycle: contains a publisher specific life cycle policy name,
	LifecycleStartDate	datetime2	For package specific software life cycle: life cycle start date,
	LifecycleMainstreamEndDate	datetime2	For package specific software life cycle: mainstream support end date,
	LifecycleExtendedEndDate	datetime2	For package specific software life cycle: extended support end date,
	LifecycleRetirementDate	datetime2	Reserved for future use,
	LifecycleReleaseStartDate	datetime2	Reserved for future use,
	LifecycleReleaseEndDate	datetime2	Reserved for future use,
	LifecycleLongTermSupport	bit	for package specific software life cycle: true if a long term support release
	LifecycleDefinitionTypeID	bigint
	LifecycleNotes	nvarchar(max) COLLATE Latin1_General_CI_AS	Notes from the lifcycle definition for packages that have a package specific lifecycle definition,
	AlwaysCreatePackage	bit DEFAULT 0	If true, the package always gets created in the database regardless of installation status,
Indexes
	PK_SoftwarePackage	Primary Key ON ID
	IX_SoftwarePackage	Unique Key ON Name
	UK_SoftwarePackage_Guid	Unique Key ON Guid
	IX_SoftwarePackage_Category	Index ON SoftwareCategoryID
	IX_SoftwarePackage_Publisher	Index ON SoftwarePublisherID
Foreign Key
	FK_SoftwarePackage_SoftwareCategory	SoftwareCategoryID ↗ ❏ SoftwareCategory(ID)
	FK_SoftwarePackage_SoftwareLicensingType	SoftwareLicensingTypeID ↗ ❏ SoftwareLicensingType(ID)
	FK_SoftwarePackage_SoftwarePackage1	ID ↗ ❏ SoftwarePackage
	FK_SoftwarePackage_SoftwarePackage_DeploymentReplacementSoftwarePackageID	DeploymentReplacementSoftwarePackageID ↗ ❏ SoftwarePackage(ID)
	FK_SoftwarePackage_SoftwarePublisher	SoftwarePublisherID ↗ ❏ SoftwarePublisher(ID)
	FK_SoftwarePackage_LifecycleDefinitionType	LifecycleDefinitionTypeID ↗ ❏ LifecycleDefinitionType(ID)
Referring Foreign Key
	FK_MachineSoftwarePackage_SoftwarePackage	ID ↙ ❏ MachineSoftwarePackage(SoftwarePackageID)
	FK_PublishedSoftwarePackage_SoftwarePackage	ID ↙ ❏ PublishedSoftwarePackage(SoftwarePackageID)
	FK_SoftwareCatalogConflict_SoftwarePackage	ID ↙ ❏ SoftwareCatalogConflict(SoftwarePackageID)
	FK_SoftwareItemSoftwarePackage_SoftwarePackage	ID ↙ ❏ SoftwareItemSoftwarePackage(SoftwarePackageID)
	FK_SoftwarePackage_SoftwarePackage1	ID ↙ ❏ SoftwarePackage
	FK_SoftwarePackage_SoftwarePackage_DeploymentReplacementSoftwarePackageID	ID ↙ ❏ SoftwarePackage(DeploymentReplacementSoftwarePackageID)
	FK_SoftwarePackageAppVGuid_SoftwarePackage	ID ↙ ❏ SoftwarePackageAppVGuid(SoftwarePackageID)
	FK_SoftwarePackageUsageDetail_SoftwarePackage	ID ↙ ❏ SoftwarePackageUsageDetail(SoftwarePackageID)
	FK_SoftwareSignature_SoftwarePackage	ID ↙ ❏ SoftwareSignature(SoftwarePackageID)

Table SoftwarePackageAppVGuid

Allows site-specific Mapping of Microsoft AppV Guids to Software Packages

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	SoftwarePackageID	bigint
*	AppVGuid	uniqueidentifier	Guid as defined in App-V
*	Created	datetime2	Date/Time this entity got created
*	CreatedBy	nvarchar(50)	User that created this entity
Indexes
	PK_SoftwarePackageAppVGuid	Primary Key ON ID
	IX_SoftwarePackageAppVGuid_AppVGuid	Index ON AppVGuid
	IX_SoftwarePackageAppVGuid_SoftwarePackageID	Index ON SoftwarePackageID
Foreign Key
	FK_SoftwarePackageAppVGuid_SoftwarePackage	SoftwarePackageID ↗ ❏ SoftwarePackage(ID)

Table SoftwarePackageUsageDetail

Consolidated usage information per software package per user per machine per day. Perform OctoSAM Inventory housekeeping to update this table from UsageDetail.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	UserID	bigint
*	SoftwarePackageID	bigint
*	UsageDate	datetime2	Date the usage was detected. Note that the time portion of this column is always 00:00:00,000, This is because .net and older versions of SQL Server do not have a dedicated Date datatype. May change to Date in the future.
*	Minutes	int	Consolidated usage time in minutes per day-
Indexes
	PK_SoftwarePackageUsageDetail	Primary Key ON ID
	IX_SoftwarePackageUsageDetail_MachineID_Clustered	Index ON MachineID
	IX_SoftwarePackageUsageDetail_PackageID	Index ON SoftwarePackageID
	IX_SoftwarePackageUsageDetail_UserID	Index ON UserID
Foreign Key
	FK_SoftwarePackageUsageDetail_Machine	MachineID ↗ ❏ Machine(ID)
	FK_SoftwarePackageUsageDetail_SoftwarePackage	SoftwarePackageID ↗ ❏ SoftwarePackage(ID)
	FK_SoftwarePackageUsageDetail_User	UserID ↗ ❏ User(ID)

Table SoftwarePublisher

Normalized publisher information from the catalog.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier	Unique identifier for objects that are synchronized with the master catalog
*	PredefinedByOctopus	bit	True if publisher is to be synchronized with the master catalog
*	Name	nvarchar(128)	Software publisher's name
*	Url	nvarchar(128)	Link to the Website
*	Notes	nvarchar(max)	Customers notes to the publisher. Not synchronized from the master catalog.
*	MasterNotes	nvarchar(max)	Notes that are synchronized from the master catalog,
*	AutoAssignEnabled	bit DEFAULT 0	True if signture publisher are to be discovered,
*	AutoAssignRegex	nvarchar(1024)	Regex to discover the publisher in signtures,
	AutoAssignTestLikePattern	nvarchar(128)	SQL LIKE type filter used to select signatures for auto assign testing
*	AutoAssignNotes	nvarchar(max)	Notes about the discovery rules from master catalog,
*	JunkFilterEnabled	bit DEFAULT 0	True if junk signatures are to be discovered,
*	JunkFilterRegex	nvarchar(1024) DEFAULT ''	Regex to discover junk signatures per publisher,
	JunkFilterTestLikePattern	nvarchar(128)	SQL LIKE type filter used to select signatures for junk filter testing
*	Created	datetime2	DateTime this entity got created,
*	CreatedBy	nvarchar(50)	User that created the entity,
*	LastModification	datetime2	DateTime this entity got last modified,
*	LastModifiedBy	nvarchar(128)	User that last modified the entity,
	MasterLastModified	datetime2	DateTime the master catalog entity got last modified,
	MasterLastModifiedBy	nvarchar(128)	User that last modified the master catalog information (not replicated),
	LastUpdateFromMaster	datetime2	DateTime the entity got last updated from master,
	LastSynchWithMaster	datetime2	DateTime the entity last synchronized with master,
	CustomField1	nvarchar(255)	Not used by OctoSAM,
	CustomField2	nvarchar(255)	Not used by OctoSAM,
	CustomField3	nvarchar(50)	Not used by OctoSAM,
	CustomField4	nvarchar(50)	Not used by OctoSAM,
*	HintHasSoftwareItems	bit DEFAULT 0	True if software items assigned to this publisher exist,
	ObjectStateID	bigint
Indexes
	PK_SoftwarePublisher	Primary Key ON ID
	UK_SoftwarePublisher_Guid	Unique Key ON Guid
	UK_SoftwarePublisher_Name	Unique Key ON Name
Foreign Key
	FK_SoftwarePublisher_ObjectState	ObjectStateID ↗ ❏ ObjectState(ID)
Referring Foreign Key
	FK_Machine_SoftwarePublisher	ID ↙ ❏ Machine(OperatingSystemSoftwarePublisherID)
	FK_SoftwareItem_SoftwarePublisher	ID ↙ ❏ SoftwareItem(SoftwarePublisherID)
	FK_SoftwarePackage_SoftwarePublisher	ID ↙ ❏ SoftwarePackage(SoftwarePublisherID)
	FK_SoftwarePublisherSwidRegid_SoftwarePublisher	ID ↙ ❏ SoftwarePublisherSwidRegid(SoftwarePublisherID)
	FK_SoftwareSignature_SoftwarePublisher	ID ↙ ❏ SoftwareSignature(SoftwarePublisherID)
	FK_MachineOfficeAddIn_SoftwarePublisher	ID ↙ ❏ MachineOfficeAddIn(SoftwarePublisherID)
	FK_MachineUserOfficeAddIn_SoftwarePublisher	ID ↙ ❏ MachineUserOfficeAddIn(SoftwarePublisherID)

Table SoftwarePublisherSwidRegid

Reserved for future use

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	SoftwarePublisherID	bigint
*	Regid	nvarchar(128)
*	Created	datetime2	Date/Time this entity got created in the database
*	CreatedBy	nvarchar(64)	User that created this entity
*	LastModification	datetime2	Date/Time this entity got last modified
*	LastModifiedBy	nvarchar(128)	User that last modified this entity
Indexes
	PK_SoftwarePublisherSwidRegid	Primary Key ON ID
Foreign Key
	FK_SoftwarePublisherSwidRegid_SoftwarePublisher	SoftwarePublisherID ↗ ❏ SoftwarePublisher(ID)

Table SoftwareRepackager

Detected software repackagers. Relies on the Import Service detecting special signatures that software repackagers add to the install.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(50)	Name of a detected repackager
*	Description	nvarchar(250)	Description of a detected repackager
*	Created	datetime2	Date/Time a repackager was first detected
Indexes
	PK_SoftwareRepackager	Primary Key ON ID
Referring Foreign Key
	FK_MachineSoftwareSignature_SoftwareRepackager	ID ↙ ❏ MachineSoftwareSignature(SoftwareRepackagerID)

Table SoftwareSignature

A software signature is a unique pattern detected by software scan, like a fingerprint that a particular software leaves on on machines.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
	MD5Hash	char(16)	Reserved for future use. Unique Hash over multiple columns, used to speed up the import service and to discern software signatures in future versions.
	SoftwarePackageID	bigint
*	Signature	nvarchar(350)	Signature after signature rewriting process. Used to uniquely identify a software signature object.
*	Dynamic	bit	A dynamic signature is a signature that is not present on every scan. For example information about running processes. Dynamic signature relations to machines are not immdiately removed if not found in a .single scan file.
*	RawPublisher	nvarchar(64) COLLATE Latin1_General_CI_AS	Publisher of the software (raw information as seen by the scan, see SoftwarePublisher table for normalized publisher information).
*	Version	nvarchar(128)	Version Information from the MSI registry (if known)
*	Notes	nvarchar(max) DEFAULT ''	Custom notes
*	Created	datetime2	Time this object was created
*	CreatedGUID	uniqueidentifier	Scan GUID that created this Software Signature
*	ScanSignature	nvarchar(350)	The Signature as reported by Octoscan2 (without signature rewriting)
	ScanHint	nvarchar(32)	Octoscan can place additional information about found software signatures that can be used for rewriting
	CustomField1	nvarchar(255)	Custom Data - not used by OctoSAM Inventory
	CustomField2	nvarchar(255)	Custom Data - not used by OctoSAM Inventory
	LastModification	datetime2	Date/Time this Signature record was last modified through the OctoSAM Inventory UI
	Comments	nvarchar(255)	Comment field from the Windows installer registry,
	Contact	nvarchar(255)	Contact field from the Windows Installer Registry
	ProductCode	nvarchar(255)	ProductCode from the Windows Installer Registry
	ProductName	nvarchar(255)	ProductName from either the Windows Installer Registry or from process version resource
	VersionMajor	bigint	VersionMajor Field from the Windows installer fegistry
	VersionMinor	bigint	VersionMinor Field from the Windows installer registry
	HelpLink	nvarchar(255)	HelpLink Field from the Windows Installer Registry
	UrlInfoAbout	nvarchar(255)	UrlInfoAbout Field from the Windows Installer Registry
	UrlUpdateInfo	nvarchar(255)	UrlUpdateInfo Field from the Windows Installer Registry
*	SystemComponent	bit DEFAULT 0	SystemComponent Flag from the Windows Installer Registry
	Language	bigint	Language code from the Windows Installer Registry
	Info	nvarchar(255)	Info field from Windows Registry and Mac system_profiler
	Res1	nvarchar(64)	Reserved for internal use of future versions
	Res2	nvarchar(64)	Reserved for internal use of future versions
	Path	nvarchar(255)	Installation location of a software component
	Architecture	nvarchar(16)	Architecture field from the Windows Installer Registry or from process executable information
*	MayRemainAfterUninstall	bit DEFAULT 0	This can be used for static signatures that are left behind on product uninstall. For example some Adobe products leave the SWID tag file on uninstall.
	Rewritten	bit	True if the Signature field was rewritten by signature rewriting rules
	RewritingRuleName	nvarchar(128)	Name of the last rule that was applied at signature rewriting
*	SwidSignature	bit DEFAULT 0	True if the signature was generated from an SWID tag file
	SoftwarePublisherID	bigint
*	Junk	bit DEFAULT 0	True if the signature is considered junk by junk filter rules
	ReportedToCentral	datetime2	For installations with central reporting of new signatures, timestamp when the signature was reported.
*	Virtualized	bit DEFAULT 0	True if a signature stems from a virtualization system such as App-V
	LicensingRelevant	bit	For software packages with licensing type multiple, this can indicate a commercial signature. Requires additional detection Logic in OctoSAM. Used for example for Java Packages that have free and paid update levels.
	BaseVersion	nvarchar(64)	Signature version determined by per-product logic within OctoSAM for signatures where uniform versioning has a speical relevance such as Java
	AnalysisExtras	xml	Holds extra data that is used internally by OctoSAM
	ExtraData	nvarchar(max)	Extra data for this software signature that is used internally by OctoSAM
	InstallationApproved	bit	If true, installation of this signature is approved on all machines.
	InstallationApprovedChanged	datetime2	Date/Time the installation approval flag was last changed
	InstallationApprovedChangedBy	nvarchar(50) COLLATE Latin1_General_CI_AS	User that last changed the installation approval flag
	ExactVersion	nvarchar(128) COLLATE Latin1_General_CI_AS	Some scanners provide a detailed signature version for special signatures such as Java, where exact build version can be of interest.
	ReleaseType	nvarchar(50) COLLATE Latin1_General_CI_AS	Some software such as Oracle Java is available in different release types. The values in this field are specific to the software or publisher.
	LastScan	datetime2	Date/Time this signature was last scanned on any machine
*	Guid	uniqueidentifier DEFAULT newid()	A unique ID that can be used to link to this object by external applications
	ObjectStateID	bigint
	CustomField3	nvarchar(255) COLLATE Latin1_General_CI_AS	Custom Data - not used by OctoSAM Inventory
	CustomField4	nvarchar(255) COLLATE Latin1_General_CI_AS	Custom Data - not used by OctoSAM Inventory
Indexes
	PK_SoftwareSignature	Primary Key ON ID
	IX_SoftwareSignatureSignature	Unique Key ON Signature
	IX_SoftwareSignature_Dynamic	Index ON Dynamic
	IX_SoftwareSignature_MD5Hash	Index ON MD5Hash
	IX_SoftwareSignature_PackageID	Index ON SoftwarePackageID
	IX_SoftwareSignature_ScanSignature	Index ON ScanSignature
	IX_SoftwareSignature_SoftwarePublisher	Index ON SoftwarePublisherID
	UK_SoftwareSignature_Guid	Unique Key ON Guid
	IX_SoftwareSignature_FilterLicensingRelevant	Index ON ID
Foreign Key
	FK_SoftwareSignature_SoftwarePackage	SoftwarePackageID ↗ ❏ SoftwarePackage(ID)
	FK_SoftwareSignature_SoftwarePublisher	SoftwarePublisherID ↗ ❏ SoftwarePublisher(ID)
	FK_SoftwareSignature_ObjectState	ObjectStateID ↗ ❏ ObjectState(ID)
Referring Foreign Key
	FK_MachineSoftwareSignature_SoftwareSignature	ID ↙ ❏ MachineSoftwareSignature(SoftwareSignatureID)
	FK_MachineUserSoftwareSignature_SoftwareSignature	ID ↙ ❏ MachineUserSoftwareSignature(SoftwareSignatureID)
	FK_SoftwareCatalogConflict_SoftwareSignature	ID ↙ ❏ SoftwareCatalogConflict(SoftwareSignatureID)
	FK_UsageDetail_SoftwareSignature	ID ↙ ❏ UsageDetail(SoftwareSignatureID)

Table StatisticsSummary

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
	OrganizationID	bigint
*	Created	datetime2	Date/Time this statistics summary was created
*	BuildVersion	nvarchar(50) COLLATE Latin1_General_CI_AS	OctoSAM build version
*	BuildDate	datetime2	OctoSAM build date
*	Machines	bigint	Number of machines
*	Servers	bigint	Number of machines with a server operating system
*	WindowsServers	bigint	Number of Windows servers
*	WindowsMachines	bigint	Number of Windows machines
*	MacMachines	bigint	Number of Macs
*	EsxMachines	bigint	Number of ESX hosts
*	LinuxMachines	bigint	Number of Linux machines
*	Users	bigint	Number of users
*	LicenseUnits	bigint	Assigned license units (machines)
*	LicenseServerUnits	bigint	Assigned server license units
*	LicenseGraceUnits	bigint	Grace license that allow operation of OctoSAM even if the license units are exceeded
*	LicenseServerGraceUnits	bigint	Grace server license units
*	LicenseReadOnlyAfter	datetime2	After this date, OctoSAM can only be used in read-only mode
*	LicenseValidThru	datetime2	License expiry date
*	LicenseOptions	nvarchar(512) COLLATE Latin1_General_CI_AS	License options
*	OracleJavaApprovedJavaInstallations	bigint	Number of approved Oracle Java SE installations that might consume a license
*	OracleJavaMsiInstallations	bigint	Number of Oracle Java SE installations that were made using a .MSI installaion that may require a paid license
*	OracleJavaLicensingRelevantInstallations	bigint	Number of Oracle Java SE installations that require a paid subscription
*	JavaInstallations	bigint	Total number of detected Java installations of any type
*	JavaPackages	bigint	Number of different Java packages installed
*	ServersDeletedInDirectory	bigint	Number of servers that we detected as deleted in directory
*	MachinesDeletedInDirectory	bigint	Number of machines that we detected as deleted in directory
*	CatalogConflicts	bigint	Number of conflicts in the software catalog at last catalog update
*	ErrorsLast24Hrs	bigint	Number of logged errors in the last 24 hrs
*	WarningsLast24Hrs	bigint	Number of logged warnings in the last 24 hrs
*	IncompleteScanFileErrorsLast24Hrs	bigint	Number of logged incomplete scan file errors in the last 24 hrs
*	LicenseManagerServersErrorsLast24Hrs	bigint	Number of logged license manager server observer errors in the last 24 hrs
*	CustomCounter1	bigint DEFAULT 0	Not used by OctoSAM
*	CustomCounter2	bigint DEFAULT 0	Not used by OctoSAM
*	CustomCounter3	bigint DEFAULT 0	Not used by OctoSAM
*	CustomCounter4	bigint DEFAULT 0	Not used by OctoSAM
	CustomField1	nvarchar(50) COLLATE Latin1_General_CI_AS	Not used by OctoSAM
	CustomField2	nvarchar(50) COLLATE Latin1_General_CI_AS	Not used by OctoSAM
	CustomField3	nvarchar(50) COLLATE Latin1_General_CI_AS	Not used by OctoSAM
	CustomField4	nvarchar(50) COLLATE Latin1_General_CI_AS	Not used by OctoSAM
	ResCounter1	bigint DEFAULT 0	Reserved for future use
*	ResCounter2	bigint DEFAULT 0	Reserved for future use
*	ResCounter3	bigint DEFAULT 0	Reserved for future use
*	ResCounter4	bigint DEFAULT 0	Reserved for future use
	Res1	nvarchar(50) COLLATE Latin1_General_CI_AS	Reserved for future use
	Res2	nvarchar(50) COLLATE Latin1_General_CI_AS	Reserved for future use
	Res3	nvarchar(50) COLLATE Latin1_General_CI_AS	Reserved for future use
*	ImportsLast24Hrs	bigint DEFAULT 0	Total number of imports in the last 24 hrs
*	MacImportsLast24Hrs	bigint DEFAULT 0	Number of imported Mac scans in the last 24 hrs
*	LinuxImportsLast24Hrs	bigint DEFAULT 0	Number of imported Linux scans in the last 24 hrs
*	WindowsWorkstations	bigint DEFAULT 0	Number of Windows Workstations
	Date	date	Date this entity got created
*	SoftwarePackages	bigint DEFAULT 0	Number of software packages in the database
*	SoftwareSignatures	bigint DEFAULT 0	Number of software signatures in the database
*	MachineSoftwareSignatures	bigint DEFAULT 0	Size of the machine to software signature relation
*	UsageDetails	bigint DEFAULT 0	Number of software metering detail records
*	SoftwarePackageUsageDetails	bigint DEFAULT 0	Number of software package metering records
*	WmiInstanceProperties	bigint DEFAULT 0	Number of WMI instance properties
*	ScannerErrorsLast24Hrs	bigint DEFAULT 0	Number of reported scanner errors in the last 24 hrs
*	ScannerWarningsLast24Hrs	bigint DEFAULT 0	Number of reported scanner warnings in the last 24 hrs
	LastHousekeepingStart	datetime2	Date/Time the last housekeeping got started
	LastHousekeepingEnd	datetime2	Date/Time the last housekeeping ended
Indexes
	PK_StatisticsSummary	Primary Key ON ID
	IX_StatisticsSummary_Organization	Index ON OrganizationID
	IX_StatisticsSummary_Created	Index ON Created
Foreign Key
	FK_StatisticsSummary_Organization	OrganizationID ↗ ❏ Organization(ID)

Table SwidDocument

Used to hold scanned SWID Tag XML documents.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineSoftwareSignatureID	bigint
*	SwidDocument	xml	Contents of the tag file
*	Path	nvarchar(255)	Absolute path of the tag file on the client machine
*	Created	datetime2 DEFAULT getdate()	Date/Time this entry was created
*	CreatedGUID	uniqueidentifier	GUID of the scan that created this entry
*	LastScan	datetime2	Date/Time this SWID Tag was last found in a scan
*	LastScanGUID	uniqueidentifier	GUID of the scan file that last detected this SWID tag
	ProductTitle	nvarchar(250)	SWID product_title
	ProductVersion	nvarchar(50)	SWID product_version
	SoftwareCreator	nvarchar(255)	SWID software_creator name
	SoftwareCreatorRegID	nvarchar(50)	SWID software_creator regid
	SoftwareLicensor	nvarchar(255)	SWID software_licensor name
	SoftwareLicensorRegID	nvarchar(50)	SWID software_creator regid
	TagCreator	nvarchar(255)	SWID tag_creator name
	TagCreatorRegID	nvarchar(50)	SWID tag_creator regid
	UniqueID	nvarchar(255)	SWID software_id unique_id
	EntitlementRequiredIndicator	bit	SWID entitlement_required
	ActivationStatus	nvarchar(50)	SWID activation_status
	ChannelType	nvarchar(50)	SWID channel_type
	CustomerType	nvarchar(50)	SWID customer_type
	SerialNumber	nvarchar(255)	SWID serial_number element
	LicenseLinkage	bit	true if SWID document contains a license_linkage element
Indexes
	PK_SwidDocument	Primary Key ON ID
	IX_SwidDocument_MachineSoftwareSignatureID	Index ON MachineSoftwareSignatureID
Foreign Key
	FK_SwidDocument_MachineSoftwareSignature	MachineSoftwareSignatureID ↗ ❏ MachineSoftwareSignature(ID)

Table UalDeviceAccess

Microsoft User Access Log device access data.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	UalRoleID	bigint
	ClientMachineID	bigint
*	IPAddress	nvarchar(50)	Microsoft UAL Device Access IP address
*	ClientFQDN	nvarchar(128)	Hostname of the client through DNS reverse lookup or OctoSAM Inventory lookup
*	ActivityCount	bigint	The number of times a particular device accessed the role or service
*	FirstSeen	datetime2	The date and time when an IP address was first used to access a role or service
*	LastSeen	datetime2	The date and time when an IP address was last used to access a role or service
Indexes
	PK_UalDeviceAccess	Primary Key ON ID
	IX_UalDeviceAccess_ClientMachineID	Index ON ClientMachineID
	IX_UalDeviceAccess_MachineID	Index ON MachineID
	IX_UalDeviceAccess_RoleID	Index ON UalRoleID
Foreign Key
	FK_UalDeviceAccess_ClientMachine	ClientMachineID ↗ ❏ Machine(ID)
	FK_UalDeviceAccess_Machine	MachineID ↗ ❏ Machine(ID)
	FK_UalDeviceAccess_UalRole	UalRoleID ↗ ❏ UalRole(ID)

Table UalRole

Holds Microsoft User Access Log application/role Names and GUIDs

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier	Microsoft User Access Logging role GUID
*	ProductName	nvarchar(256)	Microsoft User Access Logging product name
*	RoleName	nvarchar(256)	Microsoft User Access Logging role name
Indexes
	PK_UalRole	Primary Key ON ID
	IX_UalRoleGuid	Unique Index ON Guid, ProductName
Referring Foreign Key
	FK_UalDeviceAccess_UalRole	ID ↙ ❏ UalDeviceAccess(UalRoleID)
	FK_UalUserAccess_UalRole	ID ↙ ❏ UalUserAccess(UalRoleID)

Table UalUserAccess

Holds Microsoft User Access Log user access data.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	UalRoleID	bigint
	UserID	bigint	Set to Octosoft user id for users that could be mapped
*	UserName	nvarchar(256)	The user name on the client that accompanies the UAL entries from installed roles and products, if applicable.
*	TenantIdentifier	nvarchar(64)	A unique GUID for a tenant client of an installed role or product that accompanies the UAL data, if applicable.
*	ActivityCount	bigint	The number of times a particular user accessed a role or service
*	FirstSeen	datetime2	The date and time when a user first accesses a role or service
*	LastSeen	datetime2	The date and time when a user last accessed a role or service
Indexes
	PK_UalUserAccess	Primary Key ON ID
	IX_UalUserAccess_MachineID	Index ON MachineID
	IX_UalUserAccess_UalRoleID	Index ON UalRoleID
	IX_UalUserAccess_UserID	Index ON UserID
Foreign Key
	FK_UalUserAccess_Machine	MachineID ↗ ❏ Machine(ID)
	FK_UalUserAccess_UalRole	UalRoleID ↗ ❏ UalRole(ID)
	FK_UalUserAccess_User	UserID ↗ ❏ User(ID)

Table UsageDetail

Holds detailed usage information as imported from octoscan scan files. This table should usually not be referenced directly by reports and queries. Use the consolidated SoftwarePackageUsageDetail table instead.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	SoftwareSignatureID	bigint
*	UserID	bigint
*	MachineID	bigint
*	ScanGUID	uniqueidentifier	GUID of the .scan file that created this record.
*	Minutes	int	Usage in minutes
*	ScanDateTime	datetime2	Date/Time of the .scan file.
*	UsageDate	datetime2	Date this usage was detected. Note that the time portion of this column is always 00:00:00,000.
Indexes
	PK_UsageDetail	Primary Key ON ID
	IX_UsageDetail_MachineID	Index ON MachineID
	IX_UsageDetail_ScanGUID	Index ON ScanGUID
	IX_UsageDetail_SoftwareSignatureID	Index ON SoftwareSignatureID
	IX_UsageDetail_UsageDate	Index ON UsageDate
	IX_UsageDetail_UserID	Index ON UserID
Foreign Key
	FK_UsageDetail_Machine	MachineID ↗ ❏ Machine(ID)
	FK_UsageDetail_SoftwareSignature	SoftwareSignatureID ↗ ❏ SoftwareSignature(ID)
	FK_UsageDetail_User	UserID ↗ ❏ User(ID)

Table UsbDevice

Reserved for future use.

Idx	Column Name	Definition
*	ID	bigint IDENTITY
*	UsbDeviceVendorID	bigint
*	UsbDeviceCode	bigint
*	Description	nvarchar(512)
*	Remarks	nvarchar(512)
Indexes
	PK_UsbDevice	Primary Key ON ID
	IX_UsbDevice	Unique Index ON UsbDeviceVendorID, UsbDeviceCode
Foreign Key
	FK_UsbDevice_UsbDeviceVendor	UsbDeviceVendorID ↗ ❏ UsbDeviceVendor(ID)
Referring Foreign Key
	FK_MachineUsbDevice_UsbDevice	ID ↙ ❏ MachineUsbDevice(UsbDeviceID)

Table UsbDeviceVendor

Reserved for future use.

Idx	Column Name	Definition
*	ID	bigint IDENTITY
*	UsbDeviceVendorCode	bigint
*	Name	nvarchar(512)
*	Remarks	nvarchar(512)
Indexes
	PK_UsbDeviceVendor	Primary Key ON ID
	IX_UsbDeviceVendor	Unique Index ON UsbDeviceVendorCode
Referring Foreign Key
	FK_UsbDevice_UsbDeviceVendor	ID ↙ ❏ UsbDevice(UsbDeviceVendorID)

Table User

Basic user Information.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	OrganizationID	bigint
*	LoginName	nvarchar(128)	sAMAccount name,
*	DomainName	nvarchar(128)	Domain of the logged on user,
*	DisplayName	nvarchar(255) COLLATE Latin1_General_CI_AS	DisplayName attribute from the directory service,
*	UserPrincipalName	nvarchar(255) COLLATE Latin1_General_CI_AS	UserPrincipalName from the directory service,
*	Description	nvarchar(255) COLLATE Latin1_General_CI_AS	Description attribute from the directory service,
*	DnsDomain	nvarchar(255) COLLATE Latin1_General_CI_AS	The user's DNS domain
*	ImportSourceID	bigint	Always 1 for current version of OctoSAM Inventory,
*	LastModification	datetime2	Time of last write to the entity,
	CustomField1	nvarchar(255)	Available for custom data, not used by OctoSAM Inventory,
	CustomField2	nvarchar(255)	Available for custom data, not used by OctoSAM Inventory,
*	Notes	nvarchar(max) DEFAULT ''	Custom notes,
*	DirectoryPath	nvarchar(255)	Path of the user object in the directory service
*	DirectoryContainerPath	nvarchar(255) DEFAULT ''	Path to the container objct of this user
*	ImporterInstance	nvarchar(16)	Import instance name if multiple import modules write to the same database..
*	LastScanGUID	uniqueidentifier	GUID of last scan file that updated this entity
*	LastScan	datetime2	Date/Time of last scan of this user. User info may stem from multiple sources. Time can by out of sync for users scanned on client machines.
*	SID	nvarchar(200)	Security Identifier
*	ExcludeFromSoftwareInventory	bit DEFAULT 0	If true, software signatures reported by this user are ignored.
*	IgnoreNewSignatures	bit DEFAULT 0	If true, new signatures reported by this user are ignored.
*	FoundInDirectory	bit	True if the user was found in Active Directory at the last check (usually within 1 day)
	LastFoundInDirectory	datetime2	Date/Time the user object was last found in Active Directory,
*	Created	datetime2	Date/Time this object was created,
*	CreatedGUID	uniqueidentifier	Scan GUID that created this object
	LastMachineID	bigint	Last machine that delivered a scan for this user,
	MostFrequentlyUsedMachineID	bigint	Machine that this User uses most frequently
	CustomField3	nvarchar(255)	Custom Data - not used by OctoSAM Inventory
	CustomField4	nvarchar(255)	Custom Data - not used by OctoSAM Inventory
	SynchTokenID	nvarchar(255)	Can be used for synchronization with another inventory or CMDB system. Holds the key to the identical item in the CMDB. Not used by OctoSAM Inventory.
	SynchLastSynch	datetime2	Timestamp of last synchoronization of this User with the partner CMDB. Not used by OctoSAM Inventory.
*	LastModifiedBy	nvarchar(128) DEFAULT 'unknown'	Windows User that last modified this User record through the OctoSAM UI
	Res1	nvarchar(64)	Reserved for internal use by future versions
	Res2	nvarchar(64)	Reserved for internal use by future versions
	DirectoryExt1	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	DirectoryExt2	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	DirectoryExt3	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
	DirectoryExt4	nvarchar(128)	Site specific data, can optionally be used to load site-specific extended schema properties.
*	PrintableName	nvarchar(128) DEFAULT ''	Combination of attributes for consisten naming on screen or in reports
	DirectoryLastLogonTimestamp	datetime2	LastLogonTimestamp attribute from Active Directory (updated on import and housekeeping). Resolution: 14 days.
	DirectoryUserAccountControl	bigint	UserAccountControl attribute from Active Directory (updated on import and housekeeping)
	DirectoryDisabled	bit	True if the UserAccountControl attribute has the disable bit set
	DirectoryEmployeeID	nvarchar(64)	EmployeeID attribute from Active Directory (updated on import and housekeeping)
	DirectoryDepartmentNumber	nvarchar(64)	DepartmentNumber from Active Drectory
	DirectoryDepartment	nvarchar(255)	Department from Active Directory
*	FirstScan	datetime2	Date/Time of first scan
	DirectoryPhysicalDeliveryOfficeName	nvarchar(128)	PhysicalDeliveryOfficeName attribute from Active Directory
	DirectoryHomeDirectory	nvarchar(255)	HomeDirectoy attribute from Active Directory
	DirectoryHomeDrive	nvarchar(16)	HomeDrive attribute from Active Directory
	DirectoryTitle	nvarchar(128)	Title (JobTitle) attribute from Active Directory
*	Active	bit DEFAULT 1	Reserved for future use
	DirectoryCompany	nvarchar(128)	Directory attribute from Active Directory
	DirectoryTelephoneNumber	nvarchar(255)	TelephoneNumber attribute from Active Directory
	DirectoryMail	nvarchar(255)	Mail attribute from Active Directory
	DirectoryProxyAddresses	nvarchar(255)	ProxyAddresses attribute from Active Directory
	DirectoryCity	nvarchar(255)	City attribute from Active Directory
	DirectoryPostalCode	nvarchar(255)	PostalCode attribute from Active Directory
	DirectoryStreet	nvarchar(255)	Street attribute from Active Directory
	DirectoryStreetAddress	nvarchar(255)	StreetAddress attribute from Active Directory
	DirectoryExtensionAttribute1	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute2	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute3	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute4	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute5	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute6	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute7	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute8	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute9	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute10	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute11	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute12	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute13	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute14	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryExtensionAttribute15	nvarchar(255)	ExtensionAttribute from Active Directory
	DirectoryGUID	uniqueidentifier	objectGuid attribute from Active Directory
	DirectoryPreferredLanguage	nvarchar(16)	User's preferred language from ActiveDirectory
	DirectoryWhenChanged	datetime2	whenChanged attribute from Active Directory (updated on import and housekeeping)
	DirectoryWhenCreated	datetime2	whenCreated attribute from Active Directory
*	SuggestSoftwareUninstall	bit DEFAULT 1	If true, suggest this user in reports / queries for software uninstalls.
	HintSoftwarePackageUsageStartDate	datetime2	Min consolidated usage date for this User
	HintSoftwarePackageUsageEndDate	datetime2	Max consolidated usage date for this User
	HintInGroups	bit	True if the User is member in any Group
	HintCloudServices	bit	True if the user has any assigned cloud services,
	MacFullName	nvarchar(256)	For users scanned on Mac, contains the users FullName as seen by system_profiler,
	NumericUserID	bigint	For users scanned on Unix/Linux/macOS contains the numeric user id
*	Guid	uniqueidentifier DEFAULT newid()	A unique ID that can be used to link to this user object by external applications,
	DirectoryMsDSConsistencyGuid	uniqueidentifier	A unique ID used by Microsoft Entra ID to synchronize user information,
*	DeletedInDirectory	bit DEFAULT 0	True, if the user object was deleted from the directory.
	DeletedInDirectoryFirstDetected	datetime2	Date/Time the DeletedInDirectory flag was set,
	DirectoryAccountExpires	datetime2	accountExpires attribute from Active Directory (updated on import and housekeeping),
	HintHasAccessLog	bit	True if user has UAL data available,
	AnalysisExtras	xml	Holds additional analysis data,
	ServiceNowSysID	uniqueidentifier	Service Now: sys_id of the replicated object,
	ServiceNowLastExport	datetime2	Date/Time of last export to ServiceNow,
	ServiceNowLastImport	datetime2	Date/Time of last import from Service Now
	HintOwnsSoftwareItems	bit	True if the user owns any software Items,
	HintHasRelevantSoftwareItems	bit	True if there are software items relevant for this user,
	ExtraData	nvarchar(max)	Extra data collected for this user,
	DirectoryType	nvarchar(16) COLLATE Latin1_General_CI_AS	Directory type that this user was found in.,
	EntraIdTenantId	uniqueidentifier	Entra ID tenant Id
	EntraIdOnPremisesDistinguishedName	nvarchar(255) COLLATE Latin1_General_CI_AS	Distinguished name that got replicated from on-site to Entra ID
	EntraIdOnPremisesDomainName	nvarchar(255) COLLATE Latin1_General_CI_AS	Domain name that got replicated from on-site to Entra ID
	EntraIdOnPremisesLastSyncDateTime	datetime2	Date/Time this object was last synchronized from on-site AD
	EntraIdOnPremisesSID	nvarchar(200) COLLATE Latin1_General_CI_AS	SID of the on-prem user
	EntraIdOnPremisesSyncEnabled	bit	If true the user object gets synchronized from an on-size AD
	EntraIdOnPremisesUserPrincipalName	nvarchar(256) COLLATE Latin1_General_CI_AS	UPN that got synchronized from on-prem AD
	EntraIdUserType	nvarchar(50) COLLATE Latin1_General_CI_AS	Entra ID user type
	EntraIdEmployeeLeaveDateTime	datetime2	Date/Time this employee was left or will leave
	EntraIdEmployeeHireDate	datetime2	Date this employee was hired
	EntraIdDeletedDateTime	datetime2	Date/Time this user object was deleted in Azure AD
	EntraIdGivenName	nvarchar(255) COLLATE Latin1_General_CI_AS	Given name of the user
	EntraIdSurname	nvarchar(255) COLLATE Latin1_General_CI_AS	Surname of the user
	EntraIdCreationType	nvarchar(255) COLLATE Latin1_General_CI_AS	Entra ID creation type
	EntraIdCostCenter	nvarchar(255) COLLATE Latin1_General_CI_AS	Cost center from Entra ID
	EntraIdPreferredDataLocation	nvarchar(255) COLLATE Latin1_General_CI_AS	Preferred data location from Entra ID
	EntraIdDivision	nvarchar(255) COLLATE Latin1_General_CI_AS	Division from Entra ID
	MappingTag	nvarchar(255) COLLATE Latin1_General_CI_AS	A field that can be used for custom organization mapping
	HintHasAutoStart	bit	True if the user has scanned Windows auto start information
	HintHasMuiCache	bit	True if the user has scanned MUI cache information
	CloudProviderAccountID	bigint
	LastFoundInEntraId	datetime2	Date/Time this user was last found in EntraID
	ObjectStateID	bigint
	EntraIdLastSignInDateTime	datetime2	Date/Time this user last signed in to Entra ID. This information may not be available depending on your Entra ID license.
	EntraIdLastSignInRequestId	nvarchar(255) COLLATE Latin1_General_CI_AS	Request id of the last Entra ID sign in. This information may not be available depending on your Entra ID license.
	EntraIdLastNonInteractiveSignInDateTime	datetime2	Date/Time of the last non-interactive sign in to Entra ID. This information may not be available depending on your Entra ID license.
	EntraIdLastNonInteractiveSignInRequestId	nvarchar(255) COLLATE Latin1_General_CI_AS	Request id of the last non-interactive sign in to Entra ID. This information may not be available depending on your Entra ID license.
	HintHasCloudAppUsage	bit	True if Microsoft 365 usage data is available in the OctoSAM inventory
	EntraIdId	nvarchar(128) COLLATE Latin1_General_CI_AS	Microsoft EntraID ID of this user
	LastScannerTag	nvarchar(255) COLLATE Latin1_General_CI_AS	Command-line tag that was specified on the last scan of this user
	HintHasOfficeAddIns	bit	True, if Microsoft Office add-ins have been detected on this machine
	ScannedDistinguishedName	nvarchar(255) COLLATE Latin1_General_CI_AS	Distinguished user name as scanned from Octoscan2. Modern Windows that are joined to an Active Directory provide this information locally.
	EntraIdAccountEnabled	bit	Entra ID AccountEnabled
	EntraIdSyncDiagnostics	nvarchar(255) COLLATE Latin1_General_CI_AS	Diagnostics message from the OctoSAM Graph Entra ID importer
Indexes
	PK_User	Primary Key ON ID
	UK_User_Guid	Unique Key ON Guid
	IX_User	Index ON OrganizationID	Access
	IX_User_SID	Index ON SID
	IX_User_Performance1	Unique Index ON OrganizationID, ID
Foreign Key
	FK_User_LastMachine	LastMachineID ↗ ❏ Machine(ID)
	FK_User_MostFrequentlyUsedMachine	MostFrequentlyUsedMachineID ↗ ❏ Machine(ID)
	FK_User_Organization	OrganizationID ↗ ❏ Organization(ID)
	FK_User_CloudProviderAccount	CloudProviderAccountID ↗ ❏ CloudProviderAccount(ID)
	FK_User_ObjectState	ObjectStateID ↗ ❏ ObjectState(ID)
Referring Foreign Key
	FK_ImportControl_User	ID ↙ ❏ ImportControl(UserID)
	FK_LicenseManagerServerUser_User	ID ↙ ❏ LicenseManagerServerUser(UserID)
	FK_Machine_LastUser	ID ↙ ❏ Machine(LastUserID)
	FK_Machine_MostFrequentUser	ID ↙ ❏ Machine(MostFrequentUserID)
	FK_MachineUser_User	ID ↙ ❏ MachineUser(UserID)
	FK_RbacUser_User	ID ↙ ❏ RbacUser(UserID)
	FK_SoftwareItemUser_User	ID ↙ ❏ SoftwareItemUser(UserID)
	FK_SoftwarePackageUsageDetail_User	ID ↙ ❏ SoftwarePackageUsageDetail(UserID)
	FK_UalUserAccess_User	ID ↙ ❏ UalUserAccess(UserID)
	FK_UsageDetail_User	ID ↙ ❏ UsageDetail(UserID)
	FK_UserCloudProviderAccountLicensingPlan_User	ID ↙ ❏ UserCloudProviderAccountLicensingPlan(UserID)
	FK_UserGroup_User	ID ↙ ❏ UserGroup(UserID)
	FK_UserMachineAffinity_User	ID ↙ ❏ UserMachineAffinity(UserID)
	FK_CloudUser_User	ID ↙ ❏ CloudUser(UserID)

Table UserCloudProviderAccountLicensingPlan

User assigned account licensing plan relation Information.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	UserID	bigint
*	CloudProviderAccountLicensingPlanID	bigint
*	Created	datetime2	Date/Time this relation got created
*	LastScan	datetime2	Date/Time this relation got last scanned
*	LastScanGuid	uniqueidentifier	GUID of the last scan that scanned this relation
	LastUserActivityDetected	datetime2	Date/Time of the last user activity concerning this licensing plan (if supported)
Indexes
	PK_UserCloudProviderAccountLicensingPlan	Primary Key ON ID
	UK_UserCloudProviderAccountLicensingPlan_UserIDCloudProviderAccountLicensingPlanID	Unique Key ON UserID, CloudProviderAccountLicensingPlanID
	IX_UserCloudProviderAccountLicensingPlan_CloudProviderAccountLicensingPlanID	Index ON CloudProviderAccountLicensingPlanID
	IX_UserCloudProviderAccountLicensingPlan_UserID	Index ON UserID
Foreign Key
	FK_UserCloudProviderAccountLicensingPlan_CloudProviderAccountLicensingPlan	CloudProviderAccountLicensingPlanID ↗ ❏ CloudProviderAccountLicensingPlan(ID)
	FK_UserCloudProviderAccountLicensingPlan_User	UserID ↗ ❏ User(ID)
Referring Foreign Key
	FK_UserCloudProviderAccountLicensingPlanCloudProviderService_CloudProviderAccountLicensingPlan	ID ↙ ❏ UserCloudProviderAccountLicensingPlanCloudProviderService(UserCloudProviderAccountLicensingPlanID)

Table UserCloudProviderAccountLicensingPlanCloudProviderService

User assigned account licensing plan service rlation status Information.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	UserCloudProviderAccountLicensingPlanID	bigint
*	CloudProviderAccountLicensingPlanCloudProviderServiceID	bigint
*	Created	datetime2	Date/Time this relation got created,
*	CreatedGuid	uniqueidentifier	GUID of the scan that created this relation,
*	LastScan	datetime2	Date/Time this relation got last scanned,
*	LastScanGuid	uniqueidentifier	GUID of the last scan,
*	ProvisioningStatus	nvarchar(50)	Provider dependent provisioning status,
	LastUserActivityDetected	datetime2	Last detected user activity for this service (if supported),
Indexes
	PK_UserCloudProviderAccountLicensingPlanCloudProviderService	Primary Key ON ID
	UK_UserCloudProviderAccountLicensingPlanCloudProviderService	Unique Key ON UserCloudProviderAccountLicensingPlanID, CloudProviderAccountLicensingPlanCloudProviderServiceID
	IX_UserCloudProviderAccountLicensingPlanCloudProviderService_CloudProviderAccountLicensingPlanCloudProviderServiceID	Index ON CloudProviderAccountLicensingPlanCloudProviderServiceID
	IX_UserCloudProviderAccountLicensingPlanCloudProviderService_UserCloudProviderAccountLicensingPlanID	Index ON UserCloudProviderAccountLicensingPlanID
Foreign Key
	FK_UserCloudProviderAccountLicensingPlanCloudProviderService_CloudProviderAccountLicensingPlanCloudProviderService	CloudProviderAccountLicensingPlanCloudProviderServiceID ↗ ❏ CloudProviderAccountLicensingPlanCloudProviderService(ID)
	FK_UserCloudProviderAccountLicensingPlanCloudProviderService_CloudProviderAccountLicensingPlan	UserCloudProviderAccountLicensingPlanID ↗ ❏ UserCloudProviderAccountLicensingPlan(ID)

Table UserGroup

M:n relation between User and Group tables.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	UserID	bigint
*	GroupID	bigint
*	Created	datetime2	Date/Time this relation was created in the database
*	LastScan	datetime2	Date/Time this relation was last scanned
Indexes
	PK_UserGroup	Primary Key ON ID
	IX_UserGroup_UserGroup	Unique Key ON UserID, GroupID
	IX_UserGroup_Group	Index ON GroupID
	IX_UserGroup_User	Index ON UserID
Foreign Key
	FK_UserGroup_Group	GroupID ↗ ❏ Group(ID)
	FK_UserGroup_User	UserID ↗ ❏ User(ID)

Table UserImage

Store thumbnail images of users

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	UserObjectGUID	uniqueidentifier	the objectGuid of the user,
*	LastSync	datetime2	Date/Time the image was last synchronized,
*	LastModification	datetime2	Date/Time the image was last updated,
*	Image	varbinary(max)	The binary image,
Indexes
	PK_UserImage	Primary Key ON ID
	IX_UserImage_UserObjectGuid	Unique Index ON UserObjectGUID

Table UserMachineAffinity

Used to replicate User Device Affinity from other systems such as Microsoft SCCM.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	UserMachineAffinityProviderID	bigint
*	UserID	bigint
*	MachineID	bigint
*	Created	datetime2	Date/Time this affinity relation got created-
*	LastScan	datetime2	Date/Time this affinity relation got last scanned-
Indexes
	PK_UserMachineAffinity	Primary Key ON ID
	IX_UserMachineAffinity_UK	Unique Index ON UserMachineAffinityProviderID, UserID, MachineID
Foreign Key
	FK_UserMachineAffinity_Machine	MachineID ↗ ❏ Machine(ID)
	FK_UserMachineAffinity_User	UserID ↗ ❏ User(ID)
	FK_UserMachineAffinity_UserMachineAffinity	UserMachineAffinityProviderID ↗ ❏ UserMachineAffinityProvider(ID)

Table UserMachineAffinityProvider

Holds information about different Providers of user device affinity information

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	DisplayName	nvarchar(128)	Display Name of the affinity provider
*	ProviderGUID	uniqueidentifier
*	Description	nvarchar(255)	Description for the affinity provider
*	Notes	nvarchar(max)	Notes
*	Created	datetime2	Date/Time this UserMachineAffinityProvider got created
*	LastScan	datetime2	Date/Time of the last scan. On file based imports, this is the write time of the imported file.
*	CreatedGUID	uniqueidentifier	GUID of the scan that created the provider
*	LastScanGUID	uniqueidentifier	GUID of the last scan. For import based scans, this is a synthetic GUID.
Indexes
	PK_UserMachineAffinityProvider	Primary Key ON ID
Referring Foreign Key
	FK_UserMachineAffinity_UserMachineAffinity	ID ↙ ❏ UserMachineAffinity(UserMachineAffinityProviderID)
	FK_UserMachineAffinityProviderScanHistory_UserMachineAffinityProviderScanHistory	ID ↙ ❏ UserMachineAffinityProviderScanHistory(UserMachineAffinityProviderID)

Table UserMachineAffinityProviderScanHistory

History for user device affinity imports

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	UserMachineAffinityProviderID	bigint
*	Scan	datetime2	Date/Time of the scan
*	Import	datetime2	Date/Time of Import
*	ScanGUID	uniqueidentifier	GUID of the scan
*	Build	nvarchar(255)	Scanner Build Information
Indexes
	PK_UserMachineAffinityProviderScanHistory	Primary Key ON ID
Foreign Key
	FK_UserMachineAffinityProviderScanHistory_UserMachineAffinityProviderScanHistory	UserMachineAffinityProviderID ↗ ❏ UserMachineAffinityProvider(ID)
	FK_UserMachineAffinityProviderScanHistory_UserMachineAffinityProviderScanHistory1	ID ↗ ❏ UserMachineAffinityProviderScanHistory
Referring Foreign Key
	FK_UserMachineAffinityProviderScanHistory_UserMachineAffinityProviderScanHistory1	ID ↙ ❏ UserMachineAffinityProviderScanHistory

Table VirtualMachine

Holds information for virtual machines.For Hyper-V specific columns see MSDN WMI Msvm_ComputerSystem class.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
	VirtualizationManagementSystemID	bigint
	MachineID	bigint
*	Name	nvarchar(128)	Name of the virtual machine
	GuestHostName	nvarchar(128)	The guests host name
	GuestHostFullyQualifiedDomainName	nvarchar(128)	The guests fully qualified domain name. Used for guest machine to VM mapping.
	GuestOperatingSystem	nvarchar(128)	Dectected Guest operating system as seen from the hypervisor. This usually requires some guest tools to be installed in the guest operating system.
	GuestOperatingSystemFamily	nvarchar(16)	Family of the detected guest operating system,
	HostMachineID	bigint
*	Hypervisor	nvarchar(16)	Name of the hypervisor,
*	HostOperatingSystemFamily	nvarchar(16) DEFAULT N'ESX'	Family of the operatingsystem the hypervisor runs on,
	HostFullyQualifiedDomainName	nvarchar(128)	Fully qualified domain name of the host that this vm is running on,
*	Notes	nvarchar(max)	Notes
*	PoweredOn	bit	True if the VM was powered on at time of scan
	VirtualCores	bigint	Virtual cores or virtual processors that the hypervisor provides
	MemoryMB	bigint	RAM that the hypervisor provides
	UsedSpaceGB	decimal(18,4) DEFAULT 0	Used disc space
*	ProvisionedSpaceGB	decimal(18,4) DEFAULT 0	Disc space provisioned to this VM
*	Created	datetime2	Date/Time this VM entity was created in the database
*	CreatedGUID	uniqueidentifier	GUID of the scan file that created this VM
*	LastScan	datetime2	Date/Time this VM was last scanned
*	LastScanGUID	uniqueidentifier	uuid of the last scan file
*	LastHostChange	datetime2	Timestamp this VM migrated last from another host to the current host (v-motion etc)
*	LastHostChangeGUID	uniqueidentifier	GUID of the scan file that indicated the host change
*	InstanceUUID	uniqueidentifier	A unique identifier of the vm. This id should not change in case of rename or move of a vm.
	MoRef	nvarchar(128)	For VMWare the object name of the vm
	DatacenterID	bigint
*	FirstScan	datetime2	Date/Time this vm was first scanned
*	FirstScanGUID	uniqueidentifier	GUID of the first scan that scanned this VM
	GuestToolsVersion	nvarchar(50) DEFAULT ''	Version of installed VMWare guest tools
	GuestToolsCurrent	bit	True if guest tools were current at scan time
	InstallDate	datetime2	The date and time the virtual machine configuration was created for a virtual machine
	ElementName	nvarchar(128)	A display name for the object. This property is inherited from CIM_ManagedElement, and it is always set to the display name of the computer for a virtual machine.
	InstanceId	nvarchar(128)	Hyper-V Instance Id
	OperationalStatus	bigint	Operational Status of the virtual Machine. For values see MSDN Documentation.
	StatusDescriptions	nvarchar(128)	Operational Status of the virtual Machine
	Status	nvarchar(50)	Hyper-V
	HealthState	bigint	Specifies the current health of the element. This attribute expresses the health of this element but not necessarily that of its subcomponents.
	EnabledState	bigint	The enabled and disabled states of an element. This property can also indicate the transitions between these requested states.
	RequestedState	bigint	The last requested or desired state for the virtual machine as passed to theRequestStateChange method, or 12 (Not Applicable) if no state change is in progress. The actual state of the element is represented by EnabledState. This property is provided to compare the last requested and current enabled or disabled states.
	EnabledDefault	bigint	An administrator's default or startup configuration for the enabled state of an element
	TimeOfLastStateChange	datetime2	The date and time when the enabled state of the element last changed
	OnTimeInMilliseconds	bigint	For the virtual machine, this property indicates the time, in milliseconds, since the machine was last turned on, reset, or restored at scan time. This time excludes the time the virtual machine was in the paused state.
	ProcessID	bigint	The identifier of the process under which this virtual machine was running at scan time. This value can be used to uniquely identify the instance of Vmwp.exe on the system that is running the virtual machine.
	TimeOfLastConfigurationChange	datetime2	The date and time the configuration of this virutal machine last changed
	NumberOfNumaNodes	bigint	Hyper-V: See MSDN Documentation
	ReplicationState	bigint	Replication State of the virtual machine. For values see MSDN documentation.
	ReplicationHealth	bigint	The replication health for the virtual machine. For values see MSDN documentation.
	ReplicationMode	bigint	Hyper-V: See MSDN documentation
	FailedOverReplicationType	bigint	Hyper-V: See MSDN Documentation
	LastReplicationType	bigint	Hyper-V: See MSDN documentation
	LastReplicationTime	datetime2	Hyper-V: See MSDN documentation
	EnhancedSessionModeState	bigint	Hyper-V: See MSDN documentation
	LastApplicationConsistentReplicationTime	datetime2	The time at which the last application-consistent replication was received for the virtual machine
	GuestConfiguredOperatingSystem	nvarchar(128)	Guest operating system as configured for the VM for hypervisors that support this
	AnalysisExtras	xml	Holds additional analysis data
	GuestToolsVersionStatus2	nvarchar(128)	Guest Tools VersionStatus2 field for VMware virtual machines
	GuestToolsRunningStatus	nvarchar(128)	GuestTools RunningStatus field for VMware virtual machines
	ServiceNowSysId	uniqueidentifier	Service Now: sys_id of the replciated object
	ServiceNowTargetClass	nvarchar(128)	Service Now: class of the replicated object
	ServiceNowLastExport	datetime2	Date/Time of last export to Service Now
	ServiceNowLastImport	datetime2	Date/Time of last import from Service Now
	UUID	uniqueidentifier	A unique identifier of the vm. For VMware this is equal to the hardware serial number and used for vm to host mapping.
	ExtraData	nvarchar(max)	Extra data for this object (JSON)
	Container	bit	True if the virtual machine is a container
Indexes
	PK_VirtualMachine	Primary Key ON ID
	IX_VirtualMachine_HostMachineID	Index ON HostMachineID
	IX_VirtualMachine_MachineID	Index ON MachineID
	IX_VirtualMachine_UUID	Index ON UUID
	IX_VirtualMachine_InstanceUUID	Index ON InstanceUUID
Foreign Key
	FK_VirtualMachine_Datacenter	DatacenterID ↗ ❏ Datacenter(ID)
	FK_VirtualMachine_HostMachine	HostMachineID ↗ ❏ Machine(ID)
	FK_VirtualMachine_Machine	MachineID ↗ ❏ Machine(ID)
Referring Foreign Key
	FK_VirtualMachineHistory_VirtualMachine	ID ↙ ❏ VirtualMachineHistory(VirtualMachineID)
	FK_VirtualMachineMobilityHistory_VirtualMachine	ID ↙ ❏ VirtualMachineMobilityHistory(VirtualMachineID)

Table VirtualMachineHistory

Holds information about the scan history of a virtual machine. Mainly used to detect frequent change of host (license mobility).

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	VirtualMachineID	bigint
*	Created	datetime2	Date/Time this history entity got created
*	Scan	datetime2	Date/Time this history entity got scanned
*	GuestScan	bit	True if update to history is caused by a guest scan
*	ScanGUID	uniqueidentifier	Uuid of the scan that created this entity
	MachineID	bigint
	HostMachineID	bigint
	VirtualCores	bigint	Virtual cores at time of scan
	MemoryMB	bigint	Configured memory at time of scan
	UsedSpace	decimal(18,4)	Used disc space at time of scan
*	PoweredOn	bit	True if virtual machine was powered on during this scan
*	HostChange	bit	Host machine changed between prior scan and this scan
	DaysSinceLastHostChange	bigint	Number of days since this virtual machine was last migrated from another host
Indexes
	PK_VirtualMachineHistory	Primary Key ON ID
	IX_VirtualMachineHistoryVirtualMachine	Index ON VirtualMachineID
Foreign Key
	FK_VirtualMachineHistory_Machine	MachineID ↗ ❏ Machine(ID)
	FK_VirtualMachineHistory_VirtualMachineHistory	HostMachineID ↗ ❏ Machine(ID)
	FK_VirtualMachineHistory_VirtualMachine	VirtualMachineID ↗ ❏ VirtualMachine(ID)

Table VirtualMachineMobilityHistory

History of virtual machine to host relation changes.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	VirtualMachineID	bigint
*	ChangeDate	datetime2	Date/Time of the host change
*	Created	datetime2	Date/Time the change this entity got created
	MachineID	bigint
	MachineName	nvarchar(255)	Redundant machine name, in case the relation to the machine via id gets deleted.
	NewHostMachineID	bigint
*	NewHostName	nvarchar(255)	Redundant machine name, in case the relation to the machine via id gets deleted.
	Res1	nvarchar(255)	Reserved for future use
	Res2	nvarchar(255)	Reserved for future use
	AdditionalData	nvarchar(max)	Reserved for future use
Indexes
	PK_VirtualMachineMobilityHistory	Primary Key ON ID
Foreign Key
	FK_VirtualMachineMobilityHistory_Machine	MachineID ↗ ❏ Machine(ID)
	FK_VirtualMachineMobilityHistory_NewHostMachine	NewHostMachineID ↗ ❏ Machine(ID)
	FK_VirtualMachineMobilityHistory_VirtualMachine	VirtualMachineID ↗ ❏ VirtualMachine(ID)

Table VirtualizationManagementSystem

Source system for virtualization information. For VMware: corresponds to a vCenter.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier DEFAULT newid()
*	Name	nvarchar(255)	Name
*	InstanceUUID	uniqueidentifier	The unique ID of this ManagementSystem. Used to identify the source of scans and to remove objects no longer scanned..
*	Created	datetime2	Date/Time this object got created
*	CreatedGUID	uniqueidentifier	GUID of the scan file that created this object
*	LastScan	datetime2	Date/Time this object got last scanned
*	LastScanGUID	uniqueidentifier	GUID of the last scan file that for this object
*	ManagementSystem	nvarchar(50)	Name of the Manament System
*	ManagementSystemVersion	nvarchar(16)	Version of the Management System
	ServerUniqueID	bigint
	ServiceNowSysID	uniqueidentifier	Service Now: sys_id of the replicated object
	ServiceNowTargetClass	nvarchar(128)	Service Now: class of the replicated object
	ServiceNowLastExport	datetime2	Date/Time of last export to Service Now
	ServiceNowLastImport	datetime2	Date/Time of last import from Service Now
Indexes
	PK_VirtualizationManagementSystem	Primary Key ON ID
	UK_VirtualizationManagementSystem	Unique Key ON InstanceUUID, ServerUniqueID
Referring Foreign Key
	FK_Datacenter_VirtualizationManagementSystem	ID ↙ ❏ Datacenter(VirtualizationManagementSystemID)
	FK_Machine_VirtualizationManagementSystem	ID ↙ ❏ Machine(VirtualizationManagementSystemID)
	FK_VirtualizationManagementSystemScanHistory_VirtualizationManagementSystem	ID ↙ ❏ VirtualizationManagementSystemScanHistory(VirtualizationManagementSystemID)
	FK_VirtualizationManagementSystemSetting_VirtualizationManagementSystem	ID ↙ ❏ VirtualizationManagementSystemSetting(VirtualizationManagementSystemID)

Table VirtualizationManagementSystemScanHistory

Scan history per VirtualizationManagementSystem.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	VirtualizationManagementSystemID	bigint
*	Scan	datetime2	Date/Time the scan file got produced
*	Import	datetime2	Date/Time the scan file got imported
*	ScanGUID	uniqueidentifier	GUID of the scan
*	Build	nvarchar(64)	Build of the scanner that generated the scan file
Indexes
	PK_VirtualizationManagementSystemenScanHistory	Primary Key ON ID
Foreign Key
	FK_VirtualizationManagementSystemScanHistory_VirtualizationManagementSystem	VirtualizationManagementSystemID ↗ ❏ VirtualizationManagementSystem(ID)

Table VirtualizationManagementSystemSetting

Contains additional data for a virtualization management system that does not fit into the standardized table.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	VirtualizationManagementSystemID	bigint
*	Name	nvarchar(255)	Name of the setting
*	Value	nvarchar(max)	Value of the setting - string representation
	IntegerValue	bigint	Integer representation for numeric settings
	DateTimeValue	datetime	DateTime representation for datetime settings
	BooleanValue	bit	Boolean representation for boolean settings
Indexes
	PK_VirtualizationManagementSystemSettings	Primary Key ON ID
	UK_VirtualizationManagementSystemSettings_1	Unique Index ON VirtualizationManagementSystemID, Name
Foreign Key
	FK_VirtualizationManagementSystemSetting_VirtualizationManagementSystem	VirtualizationManagementSystemID ↗ ❏ VirtualizationManagementSystem(ID)

Table WmiClass

Holds a row for each unique WMI class scanned

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(256)	Name of the WMI class. See Microsoft WMI documentation. Names beginning with X_ are Octopus extension classes.
*	Enabled	bit DEFAULT 1	If this flag is set to false, the import service does no longer import information for this wmi class into the database. Can be used to conserve database space if certain WMI data is not essential.
Indexes
	PK_WmiClass	Primary Key ON ID
	IX_WmiClass_Name	Unique Key ON Name
Referring Foreign Key
	FK_WmiClassProperty_WmiClass	ID ↙ ❏ WmiClassProperty(WmiClassID)
	FK_WmiInstance_WmiClass	ID ↙ ❏ WmiInstance(WmiClassID)
	FK_WmiInstanceHistory_WmiClass	ID ↙ ❏ WmiInstanceHistory(WmiClassID)

Table WmiClassProperty

Holds a row for each unique property per class scanned

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	WmiClassID	bigint
*	Name	nvarchar(64)	Name of the Property as defined by WMI or Octopus for Octopus extension classes
*	Type	nchar(1) DEFAULT N'S'	S for String, I for Integer, B for Boolean
*	Array	bit DEFAULT 0	true if the property is multivalued (array)
Indexes
	PK_WmiClassProperty	Primary Key ON ID
	IX_WmiClassProperty_WmiClassID_WmiName	Index ON Name, WmiClassID
Foreign Key
	FK_WmiClassProperty_WmiClass	WmiClassID ↗ ❏ WmiClass(ID)
Referring Foreign Key
	FK_WmiInstanceHistoryProperty_WmiClassProperty	ID ↙ ❏ WmiInstanceHistoryProperty(WmiClassPropertyID)
	FK_WmiInstanceProperty_WmiClassProperty	ID ↙ ❏ WmiInstanceProperty(WmiClassPropertyID)

Table WmiInstance

Each entity is an instance of a WMI class scanned on a particular machine

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier DEFAULT newid()
*	MachineID	bigint
*	WmiClassID	bigint
	InformationSourceID	bigint
*	Name	nvarchar(512)	Instance Name
	ImportSourceID	bigint	Id of the import module. 1 for OctoscanImportService or OctoscanImportUtil.
	ImporterInstance	nvarchar(16)	Name of the importer Instance if multiple importers are active
*	LastScanGUID	uniqueidentifier	GUID of .scan file that generated the instance information
*	LastScan	datetime2	Date/Time of last scan that generated the instance information
	BulkInsertID	bigint	Internal ID used for bulk insert operations
	ServiceNowSysID	uniqueidentifier
	ServiceNowTargetClass	nvarchar(128)	Service Now: class of the replicated object
	ServiceNowLastExport	datetime2	Date/Time of last export to Service Now
	ServiceNowLastImport	datetime2	Date/TIme of last import from ServiceNow
Indexes
	PK_WmiInstance	Primary Key ON ID
	IX_WmiInstance_Guid	Unique Index ON Guid
	IX_WmiInstance_MachineID	Index ON MachineID
	IX_WmiInstance_ClassID	Index ON WmiClassID
Foreign Key
	FK_WmiInstance_InformationSource	InformationSourceID ↗ ❏ InformationSource(ID)
	FK_WmiInstance_Machine	MachineID ↗ ❏ Machine(ID)
	FK_WmiInstance_WmiClass	WmiClassID ↗ ❏ WmiClass(ID)
	FK_WmiInstance_WmiInstance	ID ↗ ❏ WmiInstance
Referring Foreign Key
	FK_WmiInstance_WmiInstance	ID ↙ ❏ WmiInstance
	FK_WmiInstanceProperty_WmiInstance	ID ↙ ❏ WmiInstanceProperty(WmiInstanceID)

Table WmiInstanceHistory

Each entity is an instance of a WMI class scanned in a particular MachineUserHistory context.
This table together with WmiInstanceHistoryProperty holds historized WMI data for each scan.
See WmiInstance for description of the columns.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineUserHistoryID	bigint
*	WmiClassID	bigint
	InformationSourceID	bigint
*	LastScan	datetime2	Date/Time this instance history item was scanned
*	LastScanGUID	uniqueidentifier	UUID of the scan of this history item
*	Name	nvarchar(512)	Instance name
	ImportSourceID	bigint
	ImporterInstance	nvarchar(16)	Name of the importer instance that created this entry
	BulkInsertID	bigint	Internal ID used for bulk inserts
Indexes
	PK_WmiInstanceHistory	Primary Key ON ID
	IX_WmiInstanceHistory_MachineUserHistoryID	Index ON MachineUserHistoryID
Foreign Key
	FK_WmiInstanceHistory_InformationSource	InformationSourceID ↗ ❏ InformationSource(ID)
	FK_WmiInstanceHistory_MachineUserHistory	MachineUserHistoryID ↗ ❏ MachineUserHistory(ID)
	FK_WmiInstanceHistory_WmiClass	WmiClassID ↗ ❏ WmiClass(ID)
Referring Foreign Key
	FK_WmiInstanceHistoryProperty_WmiInstanceHistory	ID ↙ ❏ WmiInstanceHistoryProperty(WmiInstanceHistoryID)

Table WmiInstanceHistoryProperty

See WmiInstanceProperty for description of the columns.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	WmiInstanceHistoryID	bigint
*	WmiClassPropertyID	bigint
*	Value	nvarchar(256)	The value of the property
	IntegerValue	bigint	Integer representation of the value or null. Provided for easier use in queries, for calculations etc.
	BooleanValue	bigint	Boolean representation of the value or null. Provided for easier use in queries, for calculations etc.
	DateTimeValue	datetime2	DateTime representation of the value or null. Provided for easier use in queries, for calculations etc.
Indexes
	PK_WmiInstanceHistoryProperty	Primary Key ON ID
	IX_WmiInstanceHistoryProperty_WmiInstanceHistoryID	Index ON WmiInstanceHistoryID
	IX_WmiInstanceHistoryPropertyValue	Index ON Value
Foreign Key
	FK_WmiInstanceHistoryProperty_WmiClassProperty	WmiClassPropertyID ↗ ❏ WmiClassProperty(ID)
	FK_WmiInstanceHistoryProperty_WmiInstanceHistory	WmiInstanceHistoryID ↗ ❏ WmiInstanceHistory(ID)
Referring Foreign Key
	FK_WmiInstanceHistoryPropertyArray_WmiInstanceHistoryProperty	ID ↙ ❏ WmiInstanceHistoryPropertyArray(WmiInstanceHistoryPropertyID)

Table WmiInstanceHistoryPropertyArray

For multi-valued (array) properties, each entity is an item in the array.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	WmiInstanceHistoryPropertyID	bigint
*	Sequence	bigint	Specifies the relative order within the array
*	Value	nvarchar(256)	The value of the item
	IntegerValue	bigint	If the property is an array of numeric values, this contains an integer representation for easier querying and calculations.
Indexes
	PK_WmiInstanceHistoryPropertyArray	Primary Key ON ID
	IX_WmiInstanceHistoryPropertyArray_WmiInstanceHistoryPropertyID	Index ON WmiInstanceHistoryPropertyID
Foreign Key
	FK_WmiInstanceHistoryPropertyArray_WmiInstanceHistoryProperty	WmiInstanceHistoryPropertyID ↗ ❏ WmiInstanceHistoryProperty(ID)

Table WmiInstanceProperty

Each entity is a property scanned for a particular instance of a WMI class per machine.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	WmiInstanceID	bigint
*	WmiClassPropertyID	bigint
*	Value	nvarchar(256)	String representation of the value. This column is always filled with a string representation.
	IntegerValue	bigint	Integer representation of the value or null. Provided for easier use in queries, for calculations etc.
	BooleanValue	bit	Boolean representation of the value or null. Provided for easier use in queries.
	DateTimeValue	datetime2	DateTime representation of the value or null. Provided for easier use in queries, DateTime calculations etc.
Indexes
	PK_WmiInstanceProperty	Primary Key ON ID
	IX_WmiInstanceProperty_CombinedIndex	Index ON WmiInstanceID, WmiClassPropertyID
	IX_WmiInstanceProperty_Value	Index ON Value
	IX_WmiInstanceProperty_WmiClassPropertyID	Index ON WmiClassPropertyID
	IX_WmiInstanceProperty_WmiInstanceID	Index ON WmiInstanceID
Foreign Key
	FK_WmiInstanceProperty_WmiClassProperty	WmiClassPropertyID ↗ ❏ WmiClassProperty(ID)
	FK_WmiInstanceProperty_WmiInstance	WmiInstanceID ↗ ❏ WmiInstance(ID)
Referring Foreign Key
	FK_WmiInstancePropertyArray_WmiInstanceProperty	ID ↙ ❏ WmiInstancePropertyArray(WmiInstancePropertyID)

Table WmiInstancePropertyArray

For WMI multi-valued (array) properties, each entity is an item in the array.

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	WmiInstancePropertyID	bigint
*	Sequence	bigint	Specifies the relative order within the array
*	Value	nvarchar(256)	The value of the item
	IntegerValue	bigint	If the property is an array of numeric values, this contains an integer representation for easier querying.
Indexes
	PK_WmiInstancePropertyArray	Primary Key ON ID
	IX_WmiInstancePropertyArray_WmiInstancePropertyID	Index ON WmiInstancePropertyID
Foreign Key
	FK_WmiInstancePropertyArray_WmiInstanceProperty	WmiInstancePropertyID ↗ ❏ WmiInstanceProperty(ID)