OctoSAM 1.10.5 Schema

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
Indexes
	PK_Annotation	Primary Key ON ID
	IX_Annotation_AnnotationClassID_Name	Unique Key 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 Key ON Guid, AnnotatedObjectName
	IX_AnnotationClass_AnnotatedObject_Name	Unique Key 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 DisplayName
Indexes
	PK_AnnotationCodeDisplayName	Primary Key ON ID
	IX_AnnotationCodeLocalizedDisplayName_Annotation_Language	Unique Key ON AnnotationCodeID, LanguageID
Foreign Key
	FK_AnnotationCodeDisplayName_AnnotationCode	AnnotationCodeID ↗ ❏ AnnotationCode(ID)
	FK_AnnotationCodeDisplayName_Language	LanguageID ↗ ❏ Language(ID)

Table AnnotationLabel

Holds 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 Key ON AnnotationID, LanguageID, Type
Foreign Key
	FK_AnnotationLabel_Annotation	AnnotationID ↗ ❏ Annotation(ID)
	FK_AnnotationLabel_Language	LanguageID ↗ ❏ Language(ID)

Table AnnotationProperty

Per instance storage of annotations. See 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 CatalogUpdateLog

Information about OctoSAM catalog updates and statistics sent to the central update service. The table also keeps a License history and log statistics.

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 ReadOnly 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
Indexes
	PK_CatalogUpdateLog	Primary Key ON 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
	AzureAdTenantId	uniqueidentifier	Azure AD 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)

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)

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 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 Cluster

Cluster object, holds member machines through MachineCluster relation.

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(50)	Name used to reference the code from applications and queries
*	Value	nvarchar(200)	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 ColumnConfiguration

Contains configuration settings for optional columns

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(255)	Name of the column
*	ShowInQueries	bit	Column should be available in queries.
*	UserEditable	bit	Contents can be edited by the User
*	EditEnabled	bit	Edit of the column is enabled
*	Created	datetime2	Date/Time this configuration was created
*	Modified	datetime2	Date/Time this configuration was last modified
*	ModifiedBy	nvarchar(255)	User that last modified this configuration
Indexes
	PK_ColumnConfiguration	Primary Key ON ID
	UK_ColumnConfiguration	Unique Key ON Name

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

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

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(50)	Connected system type
*	OctopusID	nvarchar(50)	Internal 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 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.
	AzureAdTenantId	uniqueidentifier	Azure AD tenant id
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 Key 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.
	AzureAdTenantId	uniqueidentifier	Azure AD tenant id
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

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 Key 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 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 files

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
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
Indexes
	PK_GroupType	Primary Key ON ID
	IX_GroupType_OctopusID	Unique Key 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)
*	Created	datetime2	Date/Time this entity got created in the database
*	LastModification	datetime2
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
Indexes
	PK_ImportControl	Primary Key ON ID
	IX_ImportControl_ImportGUID	Unique Key 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
*	ID	bigint IDENTITY
*	OctopusID	nvarchar(16)
*	Name	nvarchar(255)
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 favourite 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 LicenseManagerServer that is observed by the OctopusLicenseManagerServerObserver service

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(128) 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
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

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 (Checkout) 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
	LicensesBorrowed	int
Indexes
	PK_LicenseManagerServerFeatureUageDetail	Primary Key ON ID
	IX_LicenseManagerServerFeatureUsageDetail_FeatureIDLastScan	Unique Key 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 Key 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 LicenseManagerServerObserver 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
*	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

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 Mac OS X.
*	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 reverese 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 Mac OS X.
*	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 synchoronization 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	Not used
	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.
*	Manufacturer	nvarchar(128) 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. Denormalized from SoftwarePublisher.Name
*	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
	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
	AzureAdTenantId	uniqueidentifier	Azure AD tenant id for machines that Azure AD joined
	ObjectStateID	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 Key ON OrganizationID, ID
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)
Referring Foreign Key
	FK_File_Machine	ID ↙ ❏ File(MachineID)
	FK_ImportControl_Machine	ID ↙ ❏ ImportControl(MachineID)
	FK_LicenseManagerServerMachine_Machine	ID ↙ ❏ LicenseManagerServerMachine(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)

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 dtabase
*	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 Key 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)
	BiosSmBiosUUID	uniqueidentifier
*	NetworkMacAddress	nvarchar(100)
*	Name	nvarchar(100)
*	FirstScan	datetime2
*	LastScan	datetime2
*	Created	datetime2	Date/Time this entity got created in the database
	DirectoryPath	nvarchar(512)
*	Guid	uniqueidentifier
	FullyQualifiedDomainName	nvarchar(512)
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 MachineRawData

Reserved for future use

Idx	Column Name	Definition
*	ID	bigint IDENTITY
*	MachineID	bigint
*	DataType	nvarchar(50)
*	LastScan	datetime2
*	LastScanGuid	uniqueidentifier
*	Data	nvarchar(max)
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
	LifecycleMainstreamDate	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
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
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
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 Octopus.
	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
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_MachineUserHistory_MachineUser	ID ↙ ❏ MachineUserHistory(MachineUserID)
	FK_MachineUserSecurityGroup_MachineUser	ID ↙ ❏ MachineUserSecurityGroup(MachineUserID)
	FK_MachineUserSoftwareSignature_MachineUser	ID ↙ ❏ MachineUserSoftwareSignature(MachineUserID)

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 tp 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 Terminalserver 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
	AzureAdJoinType	nvarchar(50) COLLATE Latin1_General_CI_AS	Azure AD join type for this machine or this user
	AzureAdDeviceId	uniqueidentifier	Azure AD device id
	AzureAdTenantId	uniqueidentifier	Azure AD tenant id
	AzureAdIdpDomain	nvarchar(255) COLLATE Latin1_General_CI_AS	Azure AD identity provider domain
	AzureAdJoinUserEmail	nvarchar(255) COLLATE Latin1_General_CI_AS	Mail address used to join Azure AD
	AzureAdTenantDisplayName	nvarchar(255) COLLATE Latin1_General_CI_AS	Display name for this Azure AD tenant
	AzureAdUserInfoUserEmail	nvarchar(255) COLLATE Latin1_General_CI_AS	Email from Azure AD join info user info
	AzureAdUserInfoUserKeyId	uniqueidentifier	User id from Azure AD join info user info
	AzureAdUserInfoUserKeyName	nvarchar(512) COLLATE Latin1_General_CI_AS	User key name from Azure AD join info user info
Indexes
	PK_MachineUserHistory	Primary Key ON ID
	IX_MachineUserHistory_GUID	Unique Key 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, which can be either true (enabled) or false (disabled)
*	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 HardwareId 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 Key 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 Key ON MachineUserHistoryID
Foreign Key
	FK_MachineUserHistoryWTSSessionInformation_MachineUserHistory	MachineUserHistoryID ↗ ❏ MachineUserHistory(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
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)
*	Created	datetime2	Date/Time this entity got created in the database
*	CreatedGuid	datetime2
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
*	ID	bigint IDENTITY
*	Name	nvarchar(128)
*	OctopusID	nvarchar(50)
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)	Regex to discover manufacturer from hardware strings
	AutoAssignTestLikePattern	nvarchar(128)	SQL Likepattern and/or Regex 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 catalogue
	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 collected for documentation of this machine to signature relation
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

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

Table Organization

Defines the organizations of this octopus installation

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	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
Indexes
	PK_Organization	Primary Key ON ID
	IX_Organization	Unique Key ON Name
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)

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 (Citrix).

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 RbacGroup

RBAC group table

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
Indexes
	PK_RbacGroup	Primary Key ON ID
	IX_RbacGroup_DirectoryGUID	Unique Key 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

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
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

n:m 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 modidied
*	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 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 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
Indexes
	PK_RbacUser	Primary Key ON ID
	IX_RbacUser_DirectoryGUID	Unique Key ON DirectoryGUID
	UK_RbacUser_Name	Unique Key ON Name
	IX_RbacUser_UserID	Index ON UserID	access rbac user via inventory user id
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)

Table RbacUserGroup

n:m 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 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
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

n:m 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 RecentlyUsedObject

Idx	Column Name	Data Type
*	ID	bigint IDENTITY
*	RbacUserID	bigint
*	RecentlyUsedObjectTypeID	bigint
*	ObjectGuid	uniqueidentifier
*	FirstUsed	datetime2
*	LastUsed	datetime2
*	UsageCount	bigint
	Favorite	bit
	ExtraData	nvarchar(max)
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

Idx	Column Name	Data Type
*	ID	bigint IDENTITY
*	ObjectName	nvarchar(50)
*	DisplayName	nvarchar(50)
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
Indexes
	PK_Repository	Primary Key ON ID
	IX_Repository_Path	Unique Key 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
	Custom2	nvarchar(255)	Custom Field 2
*	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 pre-defined software categories, Used for satalog updates.
Indexes
	PK_SoftwareCategory	Primary Key ON ID
	IX_SoftwareCategory_Name	Unique Key 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
	CustomField2	nvarchar(max)	Custom Field 2
	CustomField3	nvarchar(max)	Custom Field 3
	CustomField4	nvarchar(max)	Custom Field 4
	CustomField5	nvarchar(max)	Custom Field 5
	CustomField6	nvarchar(max)	Custom Field 6
	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 who 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
Indexes
	PK_SoftwareItem	Primary Key ON ID
	IX_SoftwareItem_SiteUniqueID	Unique Key ON SiteUniqueID
	UK_SoftwareItem_Guid	Unique Key ON Guid
	UK_SoftwareItem_UniqueNameVersion	Unique Key ON Name, Version
	IX_SoftwareItem_SoftwarePublisherID	Index ON SoftwarePublisherID
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

n:m relation between SoftwareItem and LicenseManagerServer

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

n:m Software Item 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
Indexes
	PK_SoftwareItemMachine	Primary Key ON ID
Foreign Key
	FK_SoftwareItemMachine_Machine	MachineID ↗ ❏ Machine(ID)
	FK_SoftwareItemMachine_SoftwareItem	SoftwareItemID ↗ ❏ SoftwareItem(ID)

Table SoftwareItemOrganization

n:m Software Item 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

n:m 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

n:m relation between SoftwareItem and SoftwarePackage

Idx	Column Name	Definition
*	ID	bigint IDENTITY
*	SoftwarePackageID	bigint
*	SoftwareItemID	bigint
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

n:m 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 Key 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 type filter 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
*	Imported	bit DEFAULT 0	Deprecated. True if this package definition was imported from a signature and package definition file.
*	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 nottes
*	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 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 Service Now
	ServiceNowLastImport	datetime2	Date/Time of last import from Service Now
	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
	LifecycleMainstreamDate	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)
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
Indexes
	PK_SoftwarePublisher	Primary Key ON ID
	UK_SoftwarePublisher_Guid	Unique Key ON Guid
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)

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
*	LastModifiedBy	nvarchar(128)
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.
*	Publisher	nvarchar(64)	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 Registry
	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
*	Imported	bit DEFAULT 0	Deprecated. Set to true if the signature was imported by a signature / software package definition import rather than created from a scan file.
*	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 signatures 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
	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
Foreign Key
	FK_SoftwareSignature_SoftwarePackage	SoftwarePackageID ↗ ❏ SoftwarePackage(ID)
	FK_SoftwareSignature_SoftwarePublisher	SoftwarePublisherID ↗ ❏ SoftwarePublisher(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 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

MS UAL DevcieAccess Data

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	UalRoleID	bigint
	ClientMachineID	bigint
*	IPAddress	nvarchar(50)	MS UAL DeviceAccess 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

Hold MS UAL Application/Role Names and GUID

Idx	Column Name	Definition	Description
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier	MS UAL Role GUID
*	ProductName	nvarchar(256)	MS UAL Product Name
*	RoleName	nvarchar(256)	MS UAL Role Name
Indexes
	PK_UalRole	Primary Key ON ID
	IX_UalRoleGuid	Unique Key ON Guid, ProductName
Referring Foreign Key
	FK_UalDeviceAccess_UalRole	ID ↙ ❏ UalDeviceAccess(UalRoleID)
	FK_UalUserAccess_UalRole	ID ↙ ❏ UalUserAccess(UalRoleID)

Table UalUserAccess

MS UAL UserAccess 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, since .net and older versions of SQL Server did not have a Date datatype.
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 Key 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 Key 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 - and by other users or machines that have the IgnoreNewSignatures flag set - 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 Azure to replicate 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 Service Now
	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.
	AzureAdTenantId	uniqueidentifier	Azure AD tenant Id
	AzureAdOnPremisesDistinguishedName	nvarchar(255) COLLATE Latin1_General_CI_AS	Distinguished name that got replicated from on-site to Azure AD
	AzureAdOnPremisesDomainName	nvarchar(255) COLLATE Latin1_General_CI_AS	Domain name that got replicated from on-site to Azure AD
	AzureAdOnPremisesLastSyncDateTime	datetime2	Date/Time this object was last synchronized from on-site AD
	AzureAdOnPremisesSID	nvarchar(200) COLLATE Latin1_General_CI_AS	SID of the on-prem user
	AzureAdOnPremisesSyncEnabled	bit	If true the user object gets synchronized from an on-size AD
	AzureAdOnPremisesUserPrincipalName	nvarchar(256) COLLATE Latin1_General_CI_AS	UPN that got synchronized from on-prem AD
	AzureAdUserType	nvarchar(50) COLLATE Latin1_General_CI_AS	Azure AD user type
	AzureAdEmployeeLeaveDateTime	datetime2	Date/Time this employee was left or will leave
	AzureAdEmployeeHireDate	datetime2	Date this employee was hired
	AzureAdDeletedDateTime	datetime2	Date/Time this user object was deleted in Azure AD
	AzureAdGivenName	nvarchar(255) COLLATE Latin1_General_CI_AS	Given name of the user
	AzureAdSurname	nvarchar(255) COLLATE Latin1_General_CI_AS	Surname of the user
	AzureAdCreationType	nvarchar(255) COLLATE Latin1_General_CI_AS	Azure AD creation type
	AzureAdCostCenter	nvarchar(255) COLLATE Latin1_General_CI_AS	Cost center from Azure AD
	AzureAdPreferredDataLocation	nvarchar(255) COLLATE Latin1_General_CI_AS	Preferred data location from Azure AD
	AzureAdDivision	nvarchar(255) COLLATE Latin1_General_CI_AS	Division from Azure AD
	ObjectStateID	bigint
Indexes
	PK_User	Primary Key ON ID
	UK_User_Guid	Unique Key ON Guid
	IX_User	Index ON OrganizationID	Access
	IX_User_Performance1	Unique Key ON OrganizationID, ID
	IX_User_SID	Index ON SID
Foreign Key
	FK_User_LastMachine	LastMachineID ↗ ❏ Machine(ID)
	FK_User_MostFrequentlyUsedMachine	MostFrequentlyUsedMachineID ↗ ❏ Machine(ID)
	FK_User_Organization	OrganizationID ↗ ❏ Organization(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)

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 Relation 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 users and groups

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 synched
*	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 Key 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 Key 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)
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
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
	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 Key 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.
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 Key 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 i
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 multivalued (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 multivalued (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)

Default Layout

Schema Octopus.dbo

Table Annotation

Table AnnotationClass

Table AnnotationCode

Table AnnotationCodeLocalizedDisplayName

Table AnnotationLabel

Table AnnotationProperty

Table AnnotationPropertyAnnotationCode

Table ApplicationLog

Table AuditDetail

Table AuditObject

Table CatalogUpdateLog

Table CloudProvider

Table CloudProviderAccount

Table CloudProviderAccountLicensingPlan

Table CloudProviderAccountLicensingPlanCloudProviderService

Table CloudProviderAccountScanHistory

Table CloudProviderService

Table Cluster

Table ClusterType

Table Code

Table CodeClass

Table ColumnConfiguration

Table ConfigurationInformation

Table ConnectedSystem

Table ConnectedSystemHistory

Table ConnectedSystemType

Table Currency

Table Datacenter

Table DirectoryMissingMachine

Table DirectoryMissingMachineGroup

Table DirectoryMissingUser

Table DirectoryMissingUserGroup

Table File

Table FileType

Table Group

Table GroupScanHistory

Table GroupType

Table GroupingProvider

Table GroupingProviderScanHistory

Table Image

Table ImportControl

Table ImportControlMessage

Table ImportFolder

Table InformationSource

Table Language

Table LicenseManagerRbacUserFavoriteFeature

Table LicenseManagerServer

Table LicenseManagerServerBuffer

Table LicenseManagerServerEvent

Table LicenseManagerServerFeature

Table LicenseManagerServerFeatureSessionUsageDetail

Table LicenseManagerServerFeatureUsageDetail

Table LicenseManagerServerFeatureUsageDetailShortTerm

Table LicenseManagerServerFeatureVersion

Table LicenseManagerServerMachine

Table LicenseManagerServerObserverLog

Table LicenseManagerServerScan

Table LicenseManagerServerUser

Table LifecycleDefinitionType

Table Machine

Table MachineCluster

Table MachineGroup

Table MachineHardwareHistory

Table MachineRawData

Table MachineSoftwarePackage

Table MachineSoftwareSignature

Table MachineSoftwareSignatureInstance

Table MachineUsbDevice

Table MachineUser

Table MachineUserHistory

Table MachineUserHistoryViewClientInformation

Table MachineUserHistoryVolatileEnvironment

Table MachineUserHistoryWTSSessionInformation

Table MachineUserSecurityGroup

Table MachineUserSoftwareSignature

Table MailboxProvider

Table MailboxProviderType

Table Manufacturer