OctoSAM DB 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	Field Name	Data Type	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	ON ID
	IX_Annotation_AnnotationClassID_Name	ON AnnotationClassID, Name
Foreign Keys
	FK_Annotation_AnnotationClass	(AnnotationClassID) → AnnotationClass(ID)
Referring Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_AnnotationClass_AnnotatedObject_GUID	ON Guid, AnnotatedObjectName
	IX_AnnotationClass_AnnotatedObject_Name	ON Name, AnnotatedObjectName
Referring Foreign Keys
	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	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	AnnotationID	bigint
*	Value	nvarchar(50)	Annotation code value
Indexes
	PK_AnnotationSelectCode	ON ID
Referring Foreign Keys
	FK_AnnotationCodeDisplayName_AnnotationCode	(ID) ← AnnotationCodeLocalizedDisplayName(AnnotationCodeID)
	FK_AnnotationPropertyAnnotationCode_AnnotationCode	(ID) ← AnnotationPropertyAnnotationCode(AnnotationCodeID)

Table AnnotationCodeLocalizedDisplayName

Localized names of Annotation Codes

[ ]

Idx	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	AnnotationCodeID	bigint
*	LanguageID	bigint
*	DisplayName	nvarchar(128)	Localized DisplayName
Indexes
	PK_AnnotationCodeDisplayName	ON ID
	IX_AnnotationCodeLocalizedDisplayName_Annotation_Language	ON AnnotationCodeID, LanguageID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_AnnotationLabel_Annotation_Language_Type	ON AnnotationID, LanguageID, Type
Foreign Keys
	FK_AnnotationLabel_Annotation	(AnnotationID) → Annotation(ID)
	FK_AnnotationLabel_Language	(LanguageID) → Language(ID)

Table AnnotationProperty

Per instance storage of annotations. See Annotation.

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_AnnotationProperty_AnnotatedObjectID	ON AnnotatedObjectID
	IX_AnnotationProperty_AnnotationID	ON AnnotationID
Foreign Keys
	FK_AnnotationProperty_Annotation	(AnnotationID) → Annotation(ID)
	FK_AnnotationProperty_Currency	(CurrencyID) → Currency(ID)
Referring Foreign Keys
	FK_AnnotationPropertyAnnotationCode_AnnotationProperty	(ID) ← AnnotationPropertyAnnotationCode(AnnotationPropertyID)

Table AnnotationPropertyAnnotationCode

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

[ ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	AnnotationPropertyID	bigint
*	AnnotationCodeID	bigint
Indexes
	PK_AnnotationPropertyAnnotationCode	ON ID
	IX_AnnotationPropertyAnnotationCode_UniqueSelection	ON AnnotationCodeID, AnnotationPropertyID
	IX_AnnotationPropertyAnnotationCode_AnnotationProperty	ON AnnotationPropertyID
Foreign Keys
	FK_AnnotationPropertyAnnotationCode_AnnotationCode	(AnnotationCodeID) → AnnotationCode(ID)
	FK_AnnotationPropertyAnnotationCode_AnnotationProperty	(AnnotationPropertyID) → AnnotationProperty(ID)

Table ApplicationLog

Used by various OctoSAM components to write log messages

[ ]

Idx	Field Name	Data Type	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	ON ID

Table AuditDetail

Application audit table for entities that are manually maintained.

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_AuditDetail_Created	ON Created
	IX_AuditDetail_ObjectGuid	ON ObjectGuid
Foreign Keys
	FK_AuditDetail_AuditObject	(AuditObjectID) → AuditObject(ID)

Table AuditObject

Lookup table for audit objects

[ ]

Idx	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(128)	Name of the audited object
*	Created	datetime2	Date/Time the item got created
Indexes
	PK_AuditObject	ON ID
	IX_AuditObject_Name	ON Name
Referring Foreign Keys
	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	Field Name	Data Type	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	ON ID

Table CloudProvider

Cloud provider information

[ ]

Idx	Field Name	Data Type	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	ON ID
Referring Foreign Keys
	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	Field Name	Data Type	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
Indexes
	PK_CloudProviderAccount	ON ID
Foreign Keys
	FK_CloudProviderAccount_CloudProvider	(CloudProviderID) → CloudProvider(ID)
Referring Foreign Keys
	FK_CloutProviderAccountLicensingPlang_CloudProviderAccount	(ID) ← CloudProviderAccountLicensingPlan(CloudProviderAccountID)
	FK_CloudProviderAccountScanHistory_CloudProviderAccount	(ID) ← CloudProviderAccountScanHistory(CloudProviderAccountID)

Table CloudProviderAccountLicensingPlan

Cloud provider licensing plan information

[ ]

Idx	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_CloutProviderAccountLicensingPlang_CloudProviderAccount	(CloudProviderAccountID) → CloudProviderAccount(ID)
Referring Foreign Keys
	FK_UserCloudProviderAccountLicensingPlan_CloudProviderAccountLicensingPlan	(ID) ← UserCloudProviderAccountLicensingPlan(CloudProviderAccountLicensingPlanID)

Table CloudProviderAccountLicensingPlanCloudProviderService

n:m relation between licensing plan and service

[ ]

Idx	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	CloudProviderAccountLicensingPlanID	bigint
*	CloudProvierServiceID	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	ON ID
Foreign Keys
	FK_CloudProviderAccountLicensingPlanCloudProviderService_CloudProviderService	(CloudProvierServiceID) → CloudProviderService(ID)
Referring Foreign Keys
	FK_UserCloudProviderAccountLicensingPlanCloudProviderService_CloudProviderAccountLicensingPlanCloudProviderService	(ID) ← UserCloudProviderAccountLicensingPlanCloudProviderService(CloudProviderAccountLicensingPlanCloudProviderServiceID)

Table CloudProviderAccountScanHistory

Cloud scan history information

[ ]

Idx	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_CloudProviderAccountScanHistory_CloudProviderAccount	(CloudProviderAccountID) → CloudProviderAccount(ID)

Table CloudProviderService

Cloud service information

[ ]

Idx	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_CloudProviderService_CloudProvider	(CloudProviderID) → CloudProvider(ID)
Referring Foreign Keys
	FK_CloudProviderAccountLicensingPlanCloudProviderService_CloudProviderService	(ID) ← CloudProviderAccountLicensingPlanCloudProviderService(CloudProvierServiceID)

Table Cluster

Cluster object, holds member machines through MachineCluster relation.

[ ]

Idx	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_Cluster_ClusterType	(ClusterTypeID) → ClusterType(ID)
	FK_Cluster_Datacenter	(DatacenterID) → Datacenter(ID)
Referring Foreign Keys
	FK_MachineCluster_Cluster	(ID) ← MachineCluster(ClusterID)

Table ClusterType

Lookup table for cluster types

[ ]

Idx	Field Name	Data Type	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	ON ID
Referring Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_Code_UniqueKey	ON CodeClassID, Key
Foreign Keys
	FK_Code_CodeClass	(CodeClassID) → CodeClass(ID)

Table CodeClass

Used to translate various encoded values into clear text

[ ]

Idx	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(128)	Code Class Name used to reference the code class from OctoSAM application and queries
Indexes
	PK_CodeToClearTextSection	ON ID
Referring Foreign Keys
	FK_Code_CodeClass	(ID) ← Code(CodeClassID)

Table ColumnConfiguration

Contains configuration settings for optional columns

[ ]

Idx	Field Name	Data Type	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	ON ID
	UK_ColumnConfiguration	ON Name

Table ConfigurationInformation

Holds internal configuration information for various OctoSAM components

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_ConfigurationInformation	ON Name

Table ConnectedSystem

Records data about systems connected to OctoSAM

[ ]

Idx	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_ConnectedSystem_ConnectedSystemType	(ConnectedSystemTypeID) → ConnectedSystemType(ID)
Referring Foreign Keys
	FK_ConnectedSystemHistory_ConnectedSystem	(ID) ← ConnectedSystemHistory(ConnectedSystemID)

Table ConnectedSystemHistory

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_ConnectedSystemHistory_ConnectedSystem	ON ConnectedSystemID
	IX_ConnectedSystemHistory_Scan	ON Scan
Foreign Keys
	FK_ConnectedSystemHistory_ConnectedSystem	(ConnectedSystemID) → ConnectedSystem(ID)

Table ConnectedSystemType

[ ]

Idx	Field Name	Data Type	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	ON ID
Referring Foreign Keys
	FK_ConnectedSystem_ConnectedSystemType	(ID) ← ConnectedSystem(ConnectedSystemTypeID)

Table Currency

Lookup table for currencies

[ ]

Idx	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(50)	International currency name
Indexes
	PK_Currency	ON ID
Referring Foreign Keys
	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	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_Datacenter_VirtualizationManagementSystem	(VirtualizationManagementSystemID) → VirtualizationManagementSystem(ID)
Referring Foreign Keys
	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	Field Name	Data Type	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.
Indexes
	PK_DirectoryMissingMachine	ON ID
	IX_DirectoryMissingMachine_Guid	ON Guid
	IX_DirectoryMissingMachine_OrganizationID	ON OrganizationID
Foreign Keys
	FK_DirectoryMissingMachine_Organization	(OrganizationID) → Organization(ID)
Referring Foreign Keys
	FK_DirectoryMissingMachineGroup_DirectoryMissingMachine	(ID) ← DirectoryMissingMachineGroup(DirectoryMissingMachineID)

Table DirectoryMissingMachineGroup

m:n relation Group to DirectoryMissingMachine

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_DirectoryMissingMachineGroup_MissingMachineGroup	ON DirectoryMissingMachineID, GroupID
	IX_DirectoryMissingMachineGroup_DirectoryMissingMachineID	ON DirectoryMissingMachineID
	IX_DirectoryMissingMachineGroup_GroupID	ON GroupID
Foreign Keys
	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	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	OrganizationID	bigint
*	LoginName	nvarchar(64)	sAMAccountName attribute from Active Directory
*	DomainName	nvarchar(64)	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.
Indexes
	PK_DirectoryMissingUser	ON ID
	IX_DirectoryMissingUser_Guid	ON Guid
	IX_DirectoryMissingUser_OrganizationID	ON OrganizationID
Foreign Keys
	FK_DirectoryMissingUser_Organization	(OrganizationID) → Organization(ID)
Referring Foreign Keys
	FK_DirectoryMissingUserGroup_DirectoryMissingUser	(ID) ← DirectoryMissingUserGroup(DirectoryMissingUserID)

Table DirectoryMissingUserGroup

m:n relation Group to DirectoryMissingUser

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_DirectoryMissingUserGroup_MissingUserGroup	ON DirectoryMissingUserID, GroupID
	IX_DirectoryMissingUserGroup_DirectoryMissingUserID	ON DirectoryMissingUserID
	IX_DirectoryMissingUserGroup_GroupID	ON GroupID
Foreign Keys
	FK_DirectoryMissingUserGroup_DirectoryMissingUser	(DirectoryMissingUserID) → DirectoryMissingUser(ID)
	FK_DirectoryMissingUserGroup_Group	(GroupID) → Group(ID)

Table File

Contains collected files per machine

[ ]

Idx	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	MachineID	bigint
*	FileTypeID	bigint
*	Filename	nvarchar(512)
*	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	ON ID
	IX_Files_MachineID	ON MachineID
Foreign Keys
	FK_File_FileType	(FileTypeID) → FileType(ID)
	FK_File_Machine	(MachineID) → Machine(ID)

Table FileType

Lookup table for collected files

[ ]

Idx	Field Name	Data Type	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	ON ID
Referring Foreign Keys
	FK_File_FileType	(ID) ← File(FileTypeID)

Table Group

Group of users or machines

[ ]

Idx	Field Name	Data Type	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)
Indexes
	PK_Group	ON ID
	UK_Group_Guid	ON Guid
Foreign Keys
	FK_Group_GroupType	(GroupTypeID) → GroupType(ID)
	FK_Group_GroupingProvider	(GroupingProviderID) → GroupingProvider(ID)
Referring Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_GroupScanHistory_GroupID	ON GroupID
Foreign Keys
	FK_GroupScanHistory_Group	(GroupID) → Group(ID)

Table GroupType

Lookup table for group types

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_GroupType_OctopusID	ON OctopusID
Referring Foreign Keys
	FK_Group_GroupType	(ID) ← Group(GroupTypeID)

Table GroupingProvider

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

[ ]

Idx	Field Name	Data Type	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	ON ID
Referring Foreign Keys
	FK_Group_GroupingProvider	(ID) ← Group(GroupingProviderID)
	FK_GroupingProviderScanHistory_GroupingProviderScanHistory	(ID) ← GroupingProviderScanHistory(GroupingProviderID)

Table GroupingProviderScanHistory

Scan history of a grouping provider

[ ]

Idx	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_GroupingProviderScanHistory_GroupingProviderScanHistory	(GroupingProviderID) → GroupingProvider(ID)

Table Image

[ ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	Guid	uniqueidentifier
*	Image	varbinary(max)
*	Created	datetime2
*	LastModification	datetime2
Indexes
	PK_Image	ON ID
	UK_Image_Guid	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	Field Name	Data Type	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
	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	ON ID
	IX_ImportControl_ImportGUID	ON ImportGUID
	IX_ImportControl_LastScan	ON LastScan
	IX_ImportControl_LastScanDate	ON LastScanDate
	IX_ImportControl_MachineID	ON MachineID
	IX_ImportControl_UserID	ON UserID
Foreign Keys
	FK_ImportControl_ImportFolder	(ImportFolderID) → ImportFolder(ID)
	FK_ImportControl_Machine	(MachineID) → Machine(ID)
	FK_ImportControl_User	(UserID) → User(ID)
Referring Foreign Keys
	FK_ImportControlMessage_ImportControl	(ID) ← ImportControlMessage(ImportControlID)

Table ImportControlMessage

Messages generated by the scanner

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_ImportControlMessage_ImportControlID	ON ImportControlID
Foreign Keys
	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	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	Path	nvarchar(256)	Import Folder Path
Indexes
	PK_ImportFolder	ON ID
Foreign Keys
	FK_ImportFolder_ImportFolder	(ID) → ImportFolder
Referring Foreign Keys
	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	Field Name	Data Type
*	ID	bigint IDENTITY
*	OctopusID	nvarchar(16)
*	Name	nvarchar(255)
Indexes
	PK_InformationSource	ON ID
	IX_InformationSource_OctopusID	ON OctopusID
Referring Foreign Keys
	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	Field Name	Data Type	Description
*	ID	bigint
*	Code	nvarchar(3)	2 letter language code
*	Name	nvarchar(50)	language name
Indexes
	PK_Language	ON ID
Referring Foreign Keys
	FK_AnnotationCodeDisplayName_Language	(ID) ← AnnotationCodeLocalizedDisplayName(LanguageID)
	FK_AnnotationLabel_Language	(ID) ← AnnotationLabel(LanguageID)

Table LicenseManagerRbacUserFavoriteFeature

[ ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	RbacUserID	bigint
*	LicenseManagerServerFeatureID	bigint
*	SortOrder	int
*	LastModified	datetime2
Indexes
	PK_LicenseManagerRbacUserFavoriteFeature	ON ID
	UK_LicenseManagerRbacUserFavoriteFeature_RbacUserLicenseManagerServerFeature	ON RbacUserID, LicenseManagerServerFeatureID
	IX_LicenseManagerRbacUserFavoriteFeature_LicenseManagerServerFeature	ON LicenseManagerServerFeatureID
	IX_LicenseManagerRbacUserFavoriteFeature_RbacUser	ON RbacUserID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_LicenseManagerServer_Guid	ON Guid
Foreign Keys
	FK_LicenseManagerServer_LicenseManagerServer	(OrganizationID) → Organization(ID)
Referring Foreign Keys
	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	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_LicenseManagerServerBuffer_LicenseManagerServer	(LicenseManagerServerID) → LicenseManagerServer(ID)

Table LicenseManagerServerEvent

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_LicenseManagerServerEvent_LicenseMangerServerID	ON LicenseManagerServerID
Foreign Keys
	FK_LicenseManagerServerEvent_LicenseManagerServer	(LicenseManagerServerID) → LicenseManagerServer(ID)

Table LicenseManagerServerFeature

Defines a feature within a License Manager Server

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_LicenseManagerServerFeature_Guid	ON Guid
	IX_LicenseManagerServerFeature_LicenseManagerID	ON LicenseManagerServerID
	IX_LicenseManagerServerFeature_Name	ON Name
Foreign Keys
	FK_LicenseManagerServerFeature_LicenseManagerServer	(LicenseManagerServerID) → LicenseManagerServer(ID)
Referring Foreign Keys
	FK_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerFeature	(ID) ← LicenseManagerServerFeatureSessionUsageDetail(LicenseManagerServerFeatureID)
	FK_LicenseManagerServerFeatureUageDetail_LicenseManagerServerFeatureUageDetail	(ID) ← LicenseManagerServerFeatureUsageDetail(LicenseManagerServerFeatureID)
	FK_LIcenseManagerServerFeatureVersion_LIcenseManagerServerFeature	(ID) ← LicenseManagerServerFeatureVersion(LicenseManagerServerFeatureID)
	FK_LicenseManagerServerObserverLog_LicenseManagerServerFeature	(ID) ← LicenseManagerServerObserverLog(LicenseManagerServerFeatureID)
	FK_LicensenManagerRbacUserFavoriteFeature_LicensenseManagerRbacUserFavoriteFeature	(ID) ← LicenseManagerRbacUserFavoriteFeature(LicenseManagerServerFeatureID)

Table LicenseManagerServerFeatureSessionUsageDetail

Used to record license sessions (Checkout) per user.

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_LicenseManagerServerFeatureSessionUsageDetail_LastScan	ON LastScan
	IX_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerFeatureID	ON LicenseManagerServerFeatureID
	IX_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerMachineID	ON LicenseManagerServerMachineID
	IX_LicenseManagerServerFeatureSessionUsageDetail_LicenseMangerServerUserID	ON LicenseManagerServerUserID
	IX_LicenseManagerServerFeatureSessionUsageDetail_StartDate	ON StartDate
Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_LicenseManagerServerFeatureUsageDetail_FeatureIDLastScan	ON LicenseManagerServerFeatureID, LastScan
Foreign Keys
	FK_LicenseManagerServerFeatureUageDetail_LicenseManagerServerFeatureUageDetail	(LicenseManagerServerFeatureID) → LicenseManagerServerFeature(ID)

Table LicenseManagerServerFeatureUsageDetailShortTerm

See LicenseManagerServerFeatureUsageDetail table. Short term storage for performance.

[ ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	LicenseManagerServerFeatureID	bigint
*	LastScan	datetime2
*	LicensesIssued	int
*	licensesUsed	int
	LicensesCheckedOut	int
	LicensesBorrowed	int
Indexes
	PK_LicenseManagerServerFeatureUsageDetailShortTerm	ON ID
	IX_LicenseManagerServerFeatureUsageDetailShortTerm_FeatureIDLastScan	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	Field Name	Data Type	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
Indexes
	PK_LIcenseManagerServerFeatureVersion_FeatureIDVersion	ON ID
	UK_LicenseManagerServerFeatureVersion	ON LicenseManagerServerFeatureID, Version
Foreign Keys
	FK_LIcenseManagerServerFeatureVersion_LIcenseManagerServerFeature	(LicenseManagerServerFeatureID) → LicenseManagerServerFeature(ID)

Table LicenseManagerServerMachine

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

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_LicenseManagerServerMachine_LicenseManagerID	ON LicenseManagerServerID
Foreign Keys
	FK_LicenseManagerServerMachine_LicenseManagerServer	(LicenseManagerServerID) → LicenseManagerServer(ID)
	FK_LicenseManagerServerMachine_Machine	(MachineID) → Machine(ID)
Referring Foreign Keys
	FK_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerMachine	(ID) ← LicenseManagerServerFeatureSessionUsageDetail(LicenseManagerServerMachineID)

Table LicenseManagerServerObserverLog

This table is used to record the activity of the LicenseManagerServerObserver service.

[ ]

Idx	Field Name	Data Type	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	ON ID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_LicenseManagerServerScan_LicenseManagerServerID	ON LicenseManagerServerID
Foreign Keys
	FK_LicenseManagerServerScan_LicenseManagerServer	(LicenseManagerServerID) → LicenseManagerServer(ID)

Table LicenseManagerServerUser

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

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_LicenseManagerServerUser_LicenseManagerServerID	ON LicenseManagerServerID
Foreign Keys
	FK_LicenseManagerServerUser_LicenseManagerServer	(LicenseManagerServerID) → LicenseManagerServer(ID)
	FK_LicenseManagerServerUser_User	(UserID) → User(ID)
Referring Foreign Keys
	FK_LicenseManagerServerFeatureSessionUsageDetail_LicenseManagerServerUser	(ID) ← LicenseManagerServerFeatureSessionUsageDetail(LicenseManagerServerUserID)

Table LifecycleDefinitionType

[ ]

Idx	Field Name	Data Type	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	ON ID
	UK_LifecycleDefinitionType_OctopusID	ON OctopusID
	UK_LifecycleDefinitionType_Name	ON Name
Referring Foreign Keys
	FK_MachineSoftwarePackage_LifecycleDefinitionType	(ID) ← MachineSoftwarePackage(LifecycleDefinitionTypeID)
	FK_SoftwarePackage_LifecycleDefinitionType	(ID) ← SoftwarePackage(LifecycleDefinitionTypeID)

Table Machine

Basic machine information.

[ 3 4 ]

Idx	Field Name	Data Type	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
Indexes
	PK_Machine	ON ID
	UK_Machine_Guid	ON Guid
	IX_Machine_BiosSmbiosUuid	ON BiosSmBiosUuid
	IX_Machine_HardwareUniqueID	ON HardwareUniqueID
	IX_Machine_OrganizationID	ON OrganizationID
	IX_Machine_Performance1	ON OrganizationID, ID
Foreign Keys
	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 Keys
	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_MachineSoftwarePackage_Machine	(ID) ← MachineSoftwarePackage(MachineID)
	FK_MachineSoftwareSignature_Machine	(ID) ← MachineSoftwareSignature(MachineID)
	FK_MachineUsbDevice_Machine	(ID) ← MachineUsbDevice(MachineID)
	FK_MachineUser_Machine	(ID) ← MachineUser(MachineID)
	FK_SoftwareItemMachine_Machine	(ID) ← SoftwareItemMachine(MachineID)
	FK_SoftwarePackageUsageDetail_Machine	(ID) ← SoftwarePackageUsageDetail(MachineID)
	FK_UalDeviceAccess_ClientMachine	(ID) ← UalDeviceAccess(ClientMachineID)
	FK_UalDeviceAccess_Machine	(ID) ← UalDeviceAccess(MachineID)
	FK_UalUserAccess_Machine	(ID) ← UalUserAccess(MachineID)
	FK_UsageDetail_Machine	(ID) ← UsageDetail(MachineID)
	FK_User_LastMachine	(ID) ← User(LastMachineID)
	FK_User_MostFrequentlyUsedMachine	(ID) ← User(MostFrequentlyUsedMachineID)
	FK_UserMachineAffinity_Machine	(ID) ← UserMachineAffinity(MachineID)
	FK_VirtualMachine_HostMachine	(ID) ← VirtualMachine(HostMachineID)
	FK_VirtualMachine_Machine	(ID) ← VirtualMachine(MachineID)
	FK_VirtualMachineHistory_Machine	(ID) ← VirtualMachineHistory(MachineID)
	FK_VirtualMachineHistory_VirtualMachineHistory	(ID) ← VirtualMachineHistory(HostMachineID)
	FK_VirtualMachineMobilityHistory_Machine	(ID) ← VirtualMachineMobilityHistory(MachineID)
	FK_VirtualMachineMobilityHistory_NewHostMachine	(ID) ← VirtualMachineMobilityHistory(NewHostMachineID)
	FK_WmiInstance_Machine	(ID) ← WmiInstance(MachineID)
	FK_MachineRawData_Machine	(ID) ← MachineRawData(MachineID)

Table MachineCluster

m:n relation between machines and clusters

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_MachineCluster_ClusterID	ON ClusterID
	IX_MachineCluster_MachineID	ON MachineID
Foreign Keys
	FK_MachineCluster_Cluster	(ClusterID) → Cluster(ID)
	FK_MachineCluster_Machine	(MachineID) → Machine(ID)

Table MachineGroup

m:n relation between machines and groups

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_MachineGroup_MachineGroup	ON MachineID, GroupID
	IX_MachineGroup_Group	ON GroupID
	IX_MachineGroup_Machine	ON MachineID
Foreign Keys
	FK_MachineGroup_Group	(GroupID) → Group(ID)
	FK_MachineGroup_Machine	(MachineID) → Machine(ID)

Table MachineHardwareHistory

[ ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	MachineID	bigint
	SerialNumber	nvarchar(100)
	BiosSmBiosUUID	uniqueidentifier
*	NetworkMacAddress	nvarchar(100)
*	Name	nvarchar(100)
*	FirstScan	datetime2
*	LastScan	datetime2
*	Created	datetime2
	DirectoryPath	nvarchar(512)
*	Guid	uniqueidentifier
	FullyQualifiedDomainName	nvarchar(512)
Indexes
	PK_MachineHardwareHistory	ON ID
	IX_MachineHardwareHistory_BiosSmBiosUUID	ON BiosSmBiosUUID
	IX_MachineHardwareHistory_NetworkMacAddress	ON NetworkMacAddress
	IX_MachineHardwareHistory_SerialNumber	ON SerialNumber

Table MachineRawData

[ ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	MachineID	bigint
*	DataType	nvarchar(50)
*	LastScan	datetime2
*	LastScanGuid	uniqueidentifier
*	Data	nvarchar(max)
Indexes
	PK_MachineRawData	ON ID
	IX_MachineRawData_Machine	ON MachineID
Foreign Keys
	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).

[ 3 ]

Idx	Field Name	Data Type	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
Indexes
	PK_MachineSoftwarePackage	ON ID
	IX_MachineSoftwarePackage_Unique	ON MachineID, SoftwarePackageID
	IX_MachineSoftwarePackage_MachineID	ON MachineID
	IX_MachineSoftwarePackage_SoftwarePackage_ID	ON SoftwarePackageID
Foreign Keys
	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

[ 3 ]

Idx	Field Name	Data Type	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
Indexes
	PK_MachineSoftwareSignature	ON ID
	IX_MachineSoftwareSignature_MachineSoftware_Unique	ON MachineID, SoftwareSignatureID
	IX_MachineSoftwareSignature_LastScanGUID	ON LastScanGUID
	IX_MachineSoftwareSignature_MachineID	ON MachineID
	IX_MachineSoftwareSignature_SoftwareSignatureID	ON SoftwareSignatureID
Foreign Keys
	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 Keys
	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.

[ 3 ]

Idx	Field Name	Data Type	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	ON ID
	IX_MachineSoftwareSignatureInstance_MachineSoftwareSignatureID	ON MachineSoftwareSignatureID
Foreign Keys
	FK_MachineSoftwareSignatureInstance_MachineSoftwareSignature	(MachineSoftwareSignatureID) → MachineSoftwareSignature(ID)

Table MachineUsbDevice

Reserved for future use

[ ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	MachineID	bigint
*	UsbDeviceID	bigint
Indexes
	PK_MachineUsbDevice	ON ID
Foreign Keys
	FK_MachineUsbDevice_Machine	(MachineID) → Machine(ID)
	FK_MachineUsbDevice_UsbDevice	(UsbDeviceID) → UsbDevice(ID)

Table MachineUser

m:n relation between machines and users

[ 3 4 ]

Idx	Field Name	Data Type	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	ON ID
	IX_MachineUser_MachineID	ON MachineID
	IX_MachineUser_UserID	ON UserID
Foreign Keys
	FK_MachineUser_Machine	(MachineID) → Machine(ID)
	FK_MachineUser_MachineUser	(ID) → MachineUser
	FK_MachineUser_User	(UserID) → User(ID)
Referring Foreign Keys
	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

[ 4 ]

Idx	Field Name	Data Type	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
Indexes
	PK_MachineUserHistory	ON ID
	IX_MachineUserHistory_GUID	ON ScanGUID
	IX_MachineUserHistory	ON MachineUserID
Foreign Keys
	FK_MachineUserHistory_MachineUser	(MachineUserID) → MachineUser(ID)
Referring Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_MachineUserHistoryViewClientInformation	ON MachineUserHistoryID
Foreign Keys
	FK_MachineUserHistoryViewClientInformation_MachineUserHistory	(MachineUserHistoryID) → MachineUserHistory(ID)

Table MachineUserHistoryVolatileEnvironment

Inventories the volatile environment per machine user scan

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_MachineUserHistoryVirtualEnvironment	ON MachineUserHistoryID
Foreign Keys
	FK_MachineUserHistoryVirtualEnvironment_MachineUserHistory	(MachineUserHistoryID) → MachineUserHistory(ID)

Table MachineUserHistoryWTSSessionInformation

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

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_MachineUserHistoryWTSSessionInformation_MachineUserHistoryID	ON MachineUserHistoryID
Foreign Keys
	FK_MachineUserHistoryWTSSessionInformation_MachineUserHistory	(MachineUserHistoryID) → MachineUserHistory(ID)

Table MachineUserSecurityGroup

Reserved for use in future versions of OctoSAM Inventory.

[ ]

Idx	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_MachineUserSecurityGroup_MachineUser	(MachineUserID) → MachineUser(ID)

Table MachineUserSoftwareSignature

m:n relation between MachineUser and SoftwareSignature for per user signatures

[ 3 ]

Idx	Field Name	Data Type	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	ON ID
	IX_MachineUserSoftwareSignature_MachineUserID	ON MachineUserID
	IX_MachineUserSoftwareSignature_SoftwareSignature	ON SoftwareSignatureID
Foreign Keys
	FK_MachineUserSoftwareSignature_InformationSource	(InformationSourceID) → InformationSource(ID)
	FK_MachineUserSoftwareSignature_MachineUser	(MachineUserID) → MachineUser(ID)
	FK_MachineUserSoftwareSignature_SoftwareSignature	(SoftwareSignatureID) → SoftwareSignature(ID)

Table MailboxProvider

Mailbox provider information

[ ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	MailboxProviderTypeID	bigint
*	CloudProviderID	bigint
*	Name	nvarchar(128)
*	Created	datetime2
*	CreatedGuid	datetime2
Indexes
	PK_MailboxProvider	ON ID
Foreign Keys
	FK_MailboxProvider_CloudProvider	(CloudProviderID) → CloudProvider(ID)
	FK_MailboxProvider_MailboxProviderType	(MailboxProviderTypeID) → MailboxProviderType(ID)

Table MailboxProviderType

Type of mailbox provider

[ ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	Name	nvarchar(128)
*	OctopusID	nvarchar(50)
Indexes
	PK_MailboxProviderType	ON ID
Referring Foreign Keys
	FK_MailboxProvider_MailboxProviderType	(ID) ← MailboxProvider(MailboxProviderTypeID)

Table Manufacturer

Provides normalized hardware manufacturer info

[ ]

Idx	Field Name	Data Type	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)
Indexes
	PK_Manufacturer	ON ID
	UK_Manufacturer_Guid	ON Guid
	UK_Manufacturer_Name	ON Name
Referring Foreign Keys
	FK_Machine_Manufacturer	(ID) ← Machine(ManufacturerID)
	FK_Machine_ProcessorManufacturer	(ID) ← Machine(ProcessorManufacturerID)

Table Organization

Defines the organizations of this octopus installation

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_Organization	ON Name
Referring Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_OrganizationToken_TokenUniqueConstraint	ON Token
	IX_OrganizationToken_OrganizationID	ON OrganizationID
Foreign Keys
	FK_OrganizationToken_Organization	(OrganizationID) → Organization(ID)

Table PublishedSoftwarePackage

m:n relation between groups and software packages. Used for modelling published applications (Citrix).

[ 3 ]

Idx	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_PublishedSoftwarePackage_Group	(GroupID) → Group(ID)
	FK_PublishedSoftwarePackage_SoftwarePackage	(SoftwarePackageID) → SoftwarePackage(ID)

Table RbacGroup

RBAC group table

[ 2 ]

Idx	Field Name	Data Type	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	ON ID
	IX_RbacGroup_DirectoryGUID	ON DirectoryGUID
	UK_RbacGroup_Name	ON Name
Referring Foreign Keys
	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

[ 2 ]

Idx	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	RbacGroupID	bigint
*	RbacRoleID	bigint
*	Created	datetime2	Date/TIme the relation was created
	CreatedByRbacUserID	bigint
Indexes
	PK_RbacGroupRole	ON ID
	UK_RbacGroupRole_GroupIDRoleID	ON RbacGroupID, RbacRoleID
	IX_RbacGroupRole_RbacRoleID	ON RbacRoleID
Foreign Keys
	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	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	Name	nvarchar(128)	Name of the rbac object
Indexes
	PK_RbacObject	ON ID
	UK_RbacObject_Name	ON Name
Referring Foreign Keys
	FK_RbacPrivilege_RbacObject	(ID) ← RbacPrivilege(ConstrainedRbacObjectID)

Table RbacPrivilege

Contains database representation of single privileges

[ 2 ]

Idx	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_RbacPrivilege_RbacObject	(ConstrainedRbacObjectID) → RbacObject(ID)
Referring Foreign Keys
	FK_RbacRolePrivilege_RbacRolePrivilege	(ID) ← RbacRolePrivilege(RbacPrivilegeID)

Table RbacRole

A role is a collection of privileges

[ 2 ]

Idx	Field Name	Data Type	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	ON ID
Referring Foreign Keys
	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

[ 2 ]

Idx	Field Name	Data Type	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	ON ID
	UK_RbacRolePrivilege_RoleIDPrivilegeID	ON RbacRoleID, RbacPrivilegeID
	IX_RbacRolePrivilege_RbacPrivilegeID	ON RbacPrivilegeID
Foreign Keys
	FK_RbacRolePrivilege_RbacRolePrivilege	(RbacPrivilegeID) → RbacPrivilege(ID)
	FK_RbacRolePrivilege_RbacRole	(RbacRoleID) → RbacRole(ID)

Table RbacUser

User object for RBAC. Typically replicated from Active Directory

[ 2 ]

Idx	Field Name	Data Type	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
Indexes
	PK_RbacUser	ON ID
	IX_RbacUser_DirectoryGUID	ON DirectoryGUID
	UK_RbacUser_Name	ON Name
	IX_RbacUser_UserID	ON UserID	access rbac user via inventory user id
Foreign Keys
	FK_RbacUser_User	(UserID) → User(ID)
Referring Foreign Keys
	FK_RbacGroupRole_RbacUser	(ID) ← RbacGroupRole(CreatedByRbacUserID)
	FK_RbacUserGroup_RbacUser	(ID) ← RbacUserGroup(RbacUserID)
	FK_RbacUserPreferences_RbacUser	(ID) ← RbacUserPreferences(RbacUserID)
	FK_RbacUserRole_RbacUser	(ID) ← RbacUserRole(RbacUserID)
	FK_RbacUserRole_RbacUser_Created	(ID) ← RbacUserRole(CreatedByRbacUserID)
	FK_RecentlyUsedObject_RbacUser	(ID) ← RecentlyUsedObject(RbacUserID)
	FK_SoftwareItemOwner_RbacUser	(ID) ← SoftwareItemOwner(RbacUserID)
	FK_LicenseManagerRbacUserFavoriteFeature_RbacUser	(ID) ← LicenseManagerRbacUserFavoriteFeature(RbacUserID)

Table RbacUserGroup

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

[ 2 ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	RbacUserID	bigint
*	RbacGroupID	bigint
Indexes
	PK_RbacUserGroup	ON ID
	UK_RbacUserGroup_UserIDGroupID	ON RbacUserID, RbacGroupID
	IX_RbacUserGroup_RbacGroupID	ON RbacGroupID
Foreign Keys
	FK_RbacUserGroup_RbacUserGroup	(RbacGroupID) → RbacGroup(ID)
	FK_RbacUserGroup_RbacUser	(RbacUserID) → RbacUser(ID)

Table RbacUserPreferences

Stores user preferences for web applications

[ ]

Idx	Field Name	Data Type	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	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.
	BooleanValue	bit
Indexes
	PK_RbacUserPreferences	ON ID
	UK_RbacUserPreferences_RbacUserID_Name	ON RbacUserID, Name
Foreign Keys
	FK_RbacUserPreferences_RbacUser	(RbacUserID) → RbacUser(ID)

Table RbacUserRole

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

[ 2 ]

Idx	Field Name	Data Type	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	ON ID
	UK_RbacUserRole_UserIDRoleID	ON RbacUserID, RbacRoleID
	IX_RbacUserRole_RbacRoleID	ON RbacRoleID
Foreign Keys
	FK_RbacUserRole_RbacRole	(RbacRoleID) → RbacRole(ID)
	FK_RbacUserRole_RbacUser	(RbacUserID) → RbacUser(ID)
	FK_RbacUserRole_RbacUser_Created	(CreatedByRbacUserID) → RbacUser(ID)

Table RecentlyUsedObject

[ ]

Idx	Field 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	ON ID
	UK_RecentlyUsedObject_RbacUserIDRecentyUsedObjctTypeIDObjectGuid	ON RbacUserID, RecentlyUsedObjectTypeID, ObjectGuid
Foreign Keys
	FK_RecentlyUsedObject_RbacUser	(RbacUserID) → RbacUser(ID)
	FK_RecentlyUsedObject_RecentlyUsedObjectType	(RecentlyUsedObjectTypeID) → RecentlyUsedObjectType(ID)

Table RecentlyUsedObjectType

[ ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	ObjectName	nvarchar(50)
*	DisplayName	nvarchar(50)
Indexes
	PK_RecentlyUsedObjectType	ON ID
	UK_RecentlyUsedObjectType_ObjectName	ON ObjectName
Referring Foreign Keys
	FK_RecentlyUsedObject_RecentlyUsedObjectType	(ID) ← RecentlyUsedObject(RecentlyUsedObjectTypeID)

Table Repository

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

[ ]

Idx	Field Name	Data Type	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)
	Hash	nvarchar(128)
Indexes
	PK_Repository	ON ID
	IX_Repository_Path	ON Path
	IX_Repository	ON GUID

Table SerilogEvent

[ ]

Idx	Field Name	Data Type
*	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	ON Id
	IX_SerilogEvent_Timestamp	ON TimeStamp

Table SoftwareCatalogConflict

Contains conflicts detected by the software catalog update mechanism

[ 3 ]

Idx	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	Created	datetime2	Date/Time the entry was created.
*	SoftwareSignatureID	bigint
	SoftwarePackageID	bigint
	SoftwarePackageGuid	uniqueidentifier
*	Action	nvarchar(50) DEFAULT ''
*	CatalogVersion	nvarchar(128)	Version info of used catalog
*	Notes	nvarchar(max)	Notes written during the catalog update process
Indexes
	PK_SoftwareCatalogConflict	ON ID
Foreign Keys
	FK_SoftwareCatalogConflict_SoftwarePackage	(SoftwarePackageID) → SoftwarePackage(ID)
	FK_SoftwareCatalogConflict_SoftwareSignature	(SoftwareSignatureID) → SoftwareSignature(ID)

Table SoftwareCategory

Defines the software categories.

[ 3 ]

Idx	Field Name	Data Type	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	ON ID
	IX_SoftwareCategory_Name	ON Name
	IX_SoftwareCategory_OctopusID	ON OctopusID
Referring Foreign Keys
	FK_SoftwarePackage_SoftwareCategory	(ID) ← SoftwarePackage(SoftwareCategoryID)

Table SoftwareItem

Software Items hold customer specific information about software objects

[ ]

Idx	Field Name	Data Type	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)
Indexes
	PK_SoftwareItem	ON ID
	IX_SoftwareItem_SiteUniqueID	ON SiteUniqueID
	UK_SoftwareItem_Guid	ON Guid
	UK_SoftwareItem_UniqueNameVersion	ON Name, Version
	IX_SoftwareItem_SoftwarePublisherID	ON SoftwarePublisherID
Foreign Keys
	FK_SoftwareItem_InitialCostCurrency	(InitialCostCurrencyID) → Currency(ID)
	FK_SoftwareItem_RecurringCostCurrency	(RecurringCostCurrencyID) → Currency(ID)
	FK_SoftwareItem_SoftwarePublisher	(SoftwarePublisherID) → SoftwarePublisher(ID)
Referring Foreign Keys
	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	Field Name	Data Type
*	ID	bigint IDENTITY
*	SoftwareItemID	bigint
*	LicenseManagerServerID	bigint
*	Created	datetime2
	CreatedBy	nvarchar(50)
Indexes
	PK_SoftwareItemLicenseManagerServer	ON ID
	IX_SoftwareItemLicenseManagerServer_LicenseManagerServerID	ON LicenseManagerServerID
	IX_SoftwareItemLicenseManagerServer_SoftawareItemID	ON SoftwareItemID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_SoftwareItemOwner_RbacUserID	ON RbacUserID
	IX_SoftwareItemOwner_SoftwareItemID	ON SoftwareItemID
Foreign Keys
	FK_SoftwareItemOwner_RbacUser	(RbacUserID) → RbacUser(ID)
	FK_SoftwareItemOwner_SoftwareItemOwner	(ID) → SoftwareItemOwner
Referring Foreign Keys
	FK_SoftwareItemOwner_SoftwareItemOwner	(ID) ← SoftwareItemOwner

Table SoftwareItemSoftwarePackage

n:m relation between SoftwareItem and SoftwarePackage

[ ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	SoftwarePackageID	bigint
*	SoftwareItemID	bigint
Indexes
	PK_SoftwareListSoftwarePackage	ON ID
	IX_SoftwareItemSoftwarePackage_SoftwareItemID	ON SoftwareItemID
	IX_SoftwareItemSoftwarePackage_SoftwarePackageID	ON SoftwarePackageID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_SoftwareItemUser_SoftwareItemID	ON SoftwareItemID
	IX_SoftwareItemUser_UserID	ON UserID
Foreign Keys
	FK_SoftwareItemUser_SoftwareItem	(SoftwareItemID) → SoftwareItem(ID)
	FK_SoftwareItemUser_User	(UserID) → User(ID)

Table SoftwareLicensingType

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

[ 3 ]

Idx	Field Name	Data Type	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	ON ID
	IX_SoftwareLicensingType_Name	ON Name
Referring Foreign Keys
	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.

[ 3 ]

Idx	Field Name	Data Type	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
Indexes
	PK_SoftwarePackage	ON ID
	IX_SoftwarePackage	ON Name
	UK_SoftwarePackage_Guid	ON Guid
	IX_SoftwarePackage_Category	ON SoftwareCategoryID
	IX_SoftwarePackage_Publisher	ON SoftwarePublisherID
Foreign Keys
	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 Keys
	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	Field Name	Data Type	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	ON ID
	IX_SoftwarePackageAppVGuid_AppVGuid	ON AppVGuid
	IX_SoftwarePackageAppVGuid_SoftwarePackageID	ON SoftwarePackageID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_SoftwarePackageUsageDetail_MachineID_Clustered	ON MachineID
	IX_SoftwarePackageUsageDetail_PackageID	ON SoftwarePackageID
	IX_SoftwarePackageUsageDetail_UserID	ON UserID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
	UK_SoftwarePublisher_Guid	ON Guid
Referring Foreign Keys
	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	Field Name	Data Type
*	ID	bigint IDENTITY
*	SoftwarePublisherID	bigint
*	Regid	nvarchar(128)
*	Created	datetime2
*	CreatedBy	nvarchar(64)
*	LastModification	datetime2
*	LastModifiedBy	nvarchar(128)
Indexes
	PK_SoftwarePublisherSwidRegid	ON ID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
Referring Foreign Keys
	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.

[ 3 ]

Idx	Field Name	Data Type	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)
Indexes
	PK_SoftwareSignature	ON ID
	IX_SoftwareSignatureSignature	ON Signature
	IX_SoftwareSignature_Dynamic	ON Dynamic
	IX_SoftwareSignature_MD5Hash	ON MD5Hash
	IX_SoftwareSignature_PackageID	ON SoftwarePackageID
	IX_SoftwareSignature_ScanSignature	ON ScanSignature
	IX_SoftwareSignature_SoftwarePublisher	ON SoftwarePublisherID
Foreign Keys
	FK_SoftwareSignature_SoftwarePackage	(SoftwarePackageID) → SoftwarePackage(ID)
	FK_SoftwareSignature_SoftwarePublisher	(SoftwarePublisherID) → SoftwarePublisher(ID)
Referring Foreign Keys
	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.

[ 3 ]

Idx	Field Name	Data Type	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	ON ID
	IX_SwidDocument_MachineSoftwareSignatureID	ON MachineSoftwareSignatureID
Foreign Keys
	FK_SwidDocument_MachineSoftwareSignature	(MachineSoftwareSignatureID) → MachineSoftwareSignature(ID)

Table UalDeviceAccess

MS UAL DevcieAccess Data

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_UalDeviceAccess_ClientMachineID	ON ClientMachineID
	IX_UalDeviceAccess_MachineID	ON MachineID
	IX_UalDeviceAccess_RoleID	ON UalRoleID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_UalRoleGuid	ON Guid, ProductName
Referring Foreign Keys
	FK_UalDeviceAccess_UalRole	(ID) ← UalDeviceAccess(UalRoleID)
	FK_UalUserAccess_UalRole	(ID) ← UalUserAccess(UalRoleID)

Table UalUserAccess

MS UAL UserAccess Data

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_UalUserAccess_MachineID	ON MachineID
	IX_UalUserAccess_UalRoleID	ON UalRoleID
	IX_UalUserAccess_UserID	ON UserID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_UsageDetail_MachineID	ON MachineID
	IX_UsageDetail_ScanGUID	ON ScanGUID
	IX_UsageDetail_SoftwareSignatureID	ON SoftwareSignatureID
	IX_UsageDetail_UsageDate	ON UsageDate
	IX_UsageDetail_UserID	ON UserID
Foreign Keys
	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	Field Name	Data Type
*	ID	bigint IDENTITY
*	UsbDeviceVendorID	bigint
*	UsbDeviceCode	bigint
*	Description	nvarchar(512)
*	Remarks	nvarchar(512)
Indexes
	PK_UsbDevice	ON ID
	IX_UsbDevice	ON UsbDeviceVendorID, UsbDeviceCode
Foreign Keys
	FK_UsbDevice_UsbDeviceVendor	(UsbDeviceVendorID) → UsbDeviceVendor(ID)
Referring Foreign Keys
	FK_MachineUsbDevice_UsbDevice	(ID) ← MachineUsbDevice(UsbDeviceID)

Table UsbDeviceVendor

Reserved for future use

[ ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	UsbDeviceVendorCode	bigint
*	Name	nvarchar(512)
*	Remarks	nvarchar(512)
Indexes
	PK_UsbDeviceVendor	ON ID
	IX_UsbDeviceVendor	ON UsbDeviceVendorCode
Referring Foreign Keys
	FK_UsbDevice_UsbDeviceVendor	(ID) ← UsbDevice(UsbDeviceVendorID)

Table User

Basic user Information

[ ]

Idx	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	OrganizationID	bigint
*	LoginName	nvarchar(128)	sAMAccount name
*	DomainName	nvarchar(128)	Domain of the logged on user
*	DisplayName	nvarchar(256)	DisplayName attribute from the directory service
*	UserPrincipalName	nvarchar(256)	UserPrincipalName from the directory service
*	Description	nvarchar(128)	Description attribute from the directory service
*	DnsDomain	nvarchar(128)	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
Indexes
	PK_User	ON ID
	UK_User_Guid	ON Guid
	IX_User	ON OrganizationID	Access
	IX_User_Performance1	ON OrganizationID, ID
Foreign Keys
	FK_User_LastMachine	(LastMachineID) → Machine(ID)
	FK_User_MostFrequentlyUsedMachine	(MostFrequentlyUsedMachineID) → Machine(ID)
	FK_User_Organization	(OrganizationID) → Organization(ID)
Referring Foreign Keys
	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	Field Name	Data Type	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	ON ID
	UK_UserCloudProviderAccountLicensingPlan_UserIDCloudProviderAccountLicensingPlanID	ON UserID, CloudProviderAccountLicensingPlanID
	IX_UserCloudProviderAccountLicensingPlan_CloudProviderAccountLicensingPlanID	ON CloudProviderAccountLicensingPlanID
	IX_UserCloudProviderAccountLicensingPlan_UserID	ON UserID
Foreign Keys
	FK_UserCloudProviderAccountLicensingPlan_CloudProviderAccountLicensingPlan	(CloudProviderAccountLicensingPlanID) → CloudProviderAccountLicensingPlan(ID)
	FK_UserCloudProviderAccountLicensingPlan_User	(UserID) → User(ID)
Referring Foreign Keys
	FK_UserCloudProviderAccountLicensingPlanCloudProviderService_CloudProviderAccountLicensingPlan	(ID) ← UserCloudProviderAccountLicensingPlanCloudProviderService(UserCloudProviderAccountLicensingPlanID)

Table UserCloudProviderAccountLicensingPlanCloudProviderService

User Assigned Account Licensing Plan Service Relation Status Information

[ ]

Idx	Field Name	Data Type	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	ON ID
	UK_UserCloudProviderAccountLicensingPlanCloudProviderService	ON UserCloudProviderAccountLicensingPlanID, CloudProviderAccountLicensingPlanCloudProviderServiceID
	IX_UserCloudProviderAccountLicensingPlanCloudProviderService_CloudProviderAccountLicensingPlanCloudProviderServiceID	ON CloudProviderAccountLicensingPlanCloudProviderServiceID
	IX_UserCloudProviderAccountLicensingPlanCloudProviderService_UserCloudProviderAccountLicensingPlanID	ON UserCloudProviderAccountLicensingPlanID
Foreign Keys
	FK_UserCloudProviderAccountLicensingPlanCloudProviderService_CloudProviderAccountLicensingPlanCloudProviderService	(CloudProviderAccountLicensingPlanCloudProviderServiceID) → CloudProviderAccountLicensingPlanCloudProviderService(ID)
	FK_UserCloudProviderAccountLicensingPlanCloudProviderService_CloudProviderAccountLicensingPlan	(UserCloudProviderAccountLicensingPlanID) → UserCloudProviderAccountLicensingPlan(ID)

Table UserGroup

m:n relation between users and groups

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_UserGroup_UserGroup	ON UserID, GroupID
	IX_UserGroup_Group	ON GroupID
	IX_UserGroup_User	ON UserID
Foreign Keys
	FK_UserGroup_Group	(GroupID) → Group(ID)
	FK_UserGroup_User	(UserID) → User(ID)

Table UserImage

Store thumbnail images of users

[ ]

Idx	Field Name	Data Type	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)
Indexes
	PK_UserImage	ON ID
	IX_UserImage_UserObjectGuid	ON UserObjectGUID

Table UserMachineAffinity

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

[ ]

Idx	Field Name	Data Type	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	ON ID
	IX_UserMachineAffinity_UK	ON UserMachineAffinityProviderID, UserID, MachineID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
Referring Foreign Keys
	FK_UserMachineAffinity_UserMachineAffinity	(ID) ← UserMachineAffinity(UserMachineAffinityProviderID)
	FK_UserMachineAffinityProviderScanHistory_UserMachineAffinityProviderScanHistory	(ID) ← UserMachineAffinityProviderScanHistory(UserMachineAffinityProviderID)

Table UserMachineAffinityProviderScanHistory

History for user device affinity imports

[ ]

Idx	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_UserMachineAffinityProviderScanHistory_UserMachineAffinityProviderScanHistory	(UserMachineAffinityProviderID) → UserMachineAffinityProvider(ID)
	FK_UserMachineAffinityProviderScanHistory_UserMachineAffinityProviderScanHistory1	(ID) → UserMachineAffinityProviderScanHistory
Referring Foreign Keys
	FK_UserMachineAffinityProviderScanHistory_UserMachineAffinityProviderScanHistory1	(ID) ← UserMachineAffinityProviderScanHistory

Table VirtualMachine

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

[ ]

Idx	Field Name	Data Type	Description
*	ID	bigint IDENTITY
	VirtualizationManagementSystemID	bigint
	MachineID	bigint
*	Name	nvarchar(128)	Name of the virtual machine
	GuestHostName	nvarchar(128)
	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	ON ID
	IX_VirtualMachine_HostMachineID	ON HostMachineID
	IX_VirtualMachine_MachineID	ON MachineID
	IX_VirtualMachine_UUID	ON UUID
	IX_VirtualMachine_InstanceUUID	ON InstanceUUID
Foreign Keys
	FK_VirtualMachine_Datacenter	(DatacenterID) → Datacenter(ID)
	FK_VirtualMachine_HostMachine	(HostMachineID) → Machine(ID)
	FK_VirtualMachine_Machine	(MachineID) → Machine(ID)
Referring Foreign Keys
	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	Field Name	Data Type	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	ON ID
	IX_VirtualMachineHistoryVirtualMachine	ON VirtualMachineID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
	UK_VirtualizationManagementSystem	ON InstanceUUID, ServerUniqueID
Referring Foreign Keys
	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	Field Name	Data Type	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	ON ID
Foreign Keys
	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	Field Name	Data Type	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	ON ID
	UK_VirtualizationManagementSystemSettings_1	ON VirtualizationManagementSystemID, Name
Foreign Keys
	FK_VirtualizationManagementSystemSetting_VirtualizationManagementSystem	(VirtualizationManagementSystemID) → VirtualizationManagementSystem(ID)

Table WmiClass

Holds a row for each unique WMI class scanned

[ 4 ]

Idx	Field Name	Data Type	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	ON ID
	IX_WmiClass_Name	ON Name
Referring Foreign Keys
	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

[ 4 ]

Idx	Field Name	Data Type	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	ON ID
	IX_WmiClassProperty_WmiClassID_WmiName	ON Name, WmiClassID
Foreign Keys
	FK_WmiClassProperty_WmiClass	(WmiClassID) → WmiClass(ID)
Referring Foreign Keys
	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

[ 4 ]

Idx	Field Name	Data Type	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
	ServiceNowSysID	uniqueidentifier
	ServiceNowTargetClass	nvarchar(128)
	ServiceNowLastExport	datetime2
	ServiceNowLastImport	datetime2
Indexes
	PK_WmiInstance	ON ID
	IX_WmiInstance_Guid	ON Guid
	IX_WmiInstance_MachineID	ON MachineID
	IX_WmiInstance_ClassID	ON WmiClassID
Foreign Keys
	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 Keys
	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.

[ 4 ]

Idx	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	MachineUserHistoryID	bigint
*	WmiClassID	bigint
	InformationSourceID	bigint
*	LastScan	datetime2
*	LastScanGUID	uniqueidentifier
*	Name	nvarchar(512)
	ImportSourceID	bigint
	ImporterInstance	nvarchar(16)	Name of the importer instance that created this entry
	BulkInsertID	bigint
Indexes
	PK_WmiInstanceHistory	ON ID
	IX_WmiInstanceHistory_MachineUserHistoryID	ON MachineUserHistoryID
Foreign Keys
	FK_WmiInstanceHistory_InformationSource	(InformationSourceID) → InformationSource(ID)
	FK_WmiInstanceHistory_MachineUserHistory	(MachineUserHistoryID) → MachineUserHistory(ID)
	FK_WmiInstanceHistory_WmiClass	(WmiClassID) → WmiClass(ID)
Referring Foreign Keys
	FK_WmiInstanceHistoryProperty_WmiInstanceHistory	(ID) ← WmiInstanceHistoryProperty(WmiInstanceHistoryID)

Table WmiInstanceHistoryProperty

See WmiInstanceProperty for description of the columns.

[ 4 ]

Idx	Field Name	Data Type
*	ID	bigint IDENTITY
*	WmiInstanceHistoryID	bigint
*	WmiClassPropertyID	bigint
*	Value	nvarchar(256)
	IntegerValue	bigint
	BooleanValue	bigint
	DateTimeValue	datetime2
Indexes
	PK_WmiInstanceHistoryProperty	ON ID
	IX_WmiInstanceHistoryProperty_WmiInstanceHistoryID	ON WmiInstanceHistoryID
	IX_WmiInstanceHistoryPropertyValue	ON Value
Foreign Keys
	FK_WmiInstanceHistoryProperty_WmiClassProperty	(WmiClassPropertyID) → WmiClassProperty(ID)
	FK_WmiInstanceHistoryProperty_WmiInstanceHistory	(WmiInstanceHistoryID) → WmiInstanceHistory(ID)
Referring Foreign Keys
	FK_WmiInstanceHistoryPropertyArray_WmiInstanceHistoryProperty	(ID) ← WmiInstanceHistoryPropertyArray(WmiInstanceHistoryPropertyID)

Table WmiInstanceHistoryPropertyArray

For multivalued (array) properties, each entity is an item in the array

[ 4 ]

Idx	Field Name	Data Type	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	ON ID
	IX_WmiInstanceHistoryPropertyArray_WmiInstanceHistoryPropertyID	ON WmiInstanceHistoryPropertyID
Foreign Keys
	FK_WmiInstanceHistoryPropertyArray_WmiInstanceHistoryProperty	(WmiInstanceHistoryPropertyID) → WmiInstanceHistoryProperty(ID)

Table WmiInstanceProperty

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

[ 4 ]

Idx	Field Name	Data Type	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	ON ID
	IX_WmiInstanceProperty_CombinedIndex	ON WmiInstanceID, WmiClassPropertyID
	IX_WmiInstanceProperty_Value	ON Value
	IX_WmiInstanceProperty_WmiClassPropertyID	ON WmiClassPropertyID
	IX_WmiInstanceProperty_WmiInstanceID	ON WmiInstanceID
Foreign Keys
	FK_WmiInstanceProperty_WmiClassProperty	(WmiClassPropertyID) → WmiClassProperty(ID)
	FK_WmiInstanceProperty_WmiInstance	(WmiInstanceID) → WmiInstance(ID)
Referring Foreign Keys
	FK_WmiInstancePropertyArray_WmiInstanceProperty	(ID) ← WmiInstancePropertyArray(WmiInstancePropertyID)

Table WmiInstancePropertyArray

For WMI multivalued (array) properties, each entity is an item in the array

[ 4 ]

Idx	Field Name	Data Type	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	ON ID
	IX_WmiInstancePropertyArray_WmiInstancePropertyID	ON WmiInstancePropertyID
Foreign Keys
	FK_WmiInstancePropertyArray_WmiInstanceProperty	(WmiInstancePropertyID) → WmiInstanceProperty(ID)

Schema Octopus.dbo

Table Machine

Basic machine information.

[ 1 4 ]

Idx	Field Name	Data Type	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
Indexes
	PK_Machine	ON ID
	UK_Machine_Guid	ON Guid
	IX_Machine_BiosSmbiosUuid	ON BiosSmBiosUuid
	IX_Machine_HardwareUniqueID	ON HardwareUniqueID
	IX_Machine_OrganizationID	ON OrganizationID
	IX_Machine_Performance1	ON OrganizationID, ID
Foreign Keys
	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 Keys
	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_MachineSoftwarePackage_Machine	(ID) ← MachineSoftwarePackage(MachineID)
	FK_MachineSoftwareSignature_Machine	(ID) ← MachineSoftwareSignature(MachineID)
	FK_MachineUsbDevice_Machine	(ID) ← MachineUsbDevice(MachineID)
	FK_MachineUser_Machine	(ID) ← MachineUser(MachineID)
	FK_SoftwareItemMachine_Machine	(ID) ← SoftwareItemMachine(MachineID)
	FK_SoftwarePackageUsageDetail_Machine	(ID) ← SoftwarePackageUsageDetail(MachineID)
	FK_UalDeviceAccess_ClientMachine	(ID) ← UalDeviceAccess(ClientMachineID)
	FK_UalDeviceAccess_Machine	(ID) ← UalDeviceAccess(MachineID)
	FK_UalUserAccess_Machine	(ID) ← UalUserAccess(MachineID)
	FK_UsageDetail_Machine	(ID) ← UsageDetail(MachineID)
	FK_User_LastMachine	(ID) ← User(LastMachineID)
	FK_User_MostFrequentlyUsedMachine	(ID) ← User(MostFrequentlyUsedMachineID)
	FK_UserMachineAffinity_Machine	(ID) ← UserMachineAffinity(MachineID)
	FK_VirtualMachine_HostMachine	(ID) ← VirtualMachine(HostMachineID)
	FK_VirtualMachine_Machine	(ID) ← VirtualMachine(MachineID)
	FK_VirtualMachineHistory_Machine	(ID) ← VirtualMachineHistory(MachineID)
	FK_VirtualMachineHistory_VirtualMachineHistory	(ID) ← VirtualMachineHistory(HostMachineID)
	FK_VirtualMachineMobilityHistory_Machine	(ID) ← VirtualMachineMobilityHistory(MachineID)
	FK_VirtualMachineMobilityHistory_NewHostMachine	(ID) ← VirtualMachineMobilityHistory(NewHostMachineID)
	FK_WmiInstance_Machine	(ID) ← WmiInstance(MachineID)
	FK_MachineRawData_Machine	(ID) ← MachineRawData(MachineID)

Table MachineSoftwarePackage

[ 1 ]

Idx	Field Name	Data Type	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
Indexes
	PK_MachineSoftwarePackage	ON ID
	IX_MachineSoftwarePackage_Unique	ON MachineID, SoftwarePackageID
	IX_MachineSoftwarePackage_MachineID	ON MachineID
	IX_MachineSoftwarePackage_SoftwarePackage_ID	ON SoftwarePackageID
Foreign Keys
	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

[ 1 ]

Idx	Field Name	Data Type	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
Indexes
	PK_MachineSoftwareSignature	ON ID
	IX_MachineSoftwareSignature_MachineSoftware_Unique	ON MachineID, SoftwareSignatureID
	IX_MachineSoftwareSignature_LastScanGUID	ON LastScanGUID
	IX_MachineSoftwareSignature_MachineID	ON MachineID
	IX_MachineSoftwareSignature_SoftwareSignatureID	ON SoftwareSignatureID
Foreign Keys
	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 Keys
	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.

[ 1 ]

Idx	Field Name	Data Type	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	ON ID
	IX_MachineSoftwareSignatureInstance_MachineSoftwareSignatureID	ON MachineSoftwareSignatureID
Foreign Keys
	FK_MachineSoftwareSignatureInstance_MachineSoftwareSignature	(MachineSoftwareSignatureID) → MachineSoftwareSignature(ID)

Table MachineUser

m:n relation between machines and users

[ 1 4 ]

Idx	Field Name	Data Type	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	ON ID
	IX_MachineUser_MachineID	ON MachineID
	IX_MachineUser_UserID	ON UserID
Foreign Keys
	FK_MachineUser_Machine	(MachineID) → Machine(ID)
	FK_MachineUser_MachineUser	(ID) → MachineUser
	FK_MachineUser_User	(UserID) → User(ID)
Referring Foreign Keys
	FK_MachineUser_MachineUser	(ID) ← MachineUser
	FK_MachineUserHistory_MachineUser	(ID) ← MachineUserHistory(MachineUserID)
	FK_MachineUserSecurityGroup_MachineUser	(ID) ← MachineUserSecurityGroup(MachineUserID)
	FK_MachineUserSoftwareSignature_MachineUser	(ID) ← MachineUserSoftwareSignature(MachineUserID)

Table MachineUserSoftwareSignature

m:n relation between MachineUser and SoftwareSignature for per user signatures

[ 1 ]

Idx	Field Name	Data Type	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	ON ID
	IX_MachineUserSoftwareSignature_MachineUserID	ON MachineUserID
	IX_MachineUserSoftwareSignature_SoftwareSignature	ON SoftwareSignatureID
Foreign Keys
	FK_MachineUserSoftwareSignature_InformationSource	(InformationSourceID) → InformationSource(ID)
	FK_MachineUserSoftwareSignature_MachineUser	(MachineUserID) → MachineUser(ID)
	FK_MachineUserSoftwareSignature_SoftwareSignature	(SoftwareSignatureID) → SoftwareSignature(ID)

Table PublishedSoftwarePackage

m:n relation between groups and software packages. Used for modelling published applications (Citrix).

[ 1 ]

Idx	Field Name	Data Type	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	ON ID
Foreign Keys
	FK_PublishedSoftwarePackage_Group	(GroupID) → Group(ID)
	FK_PublishedSoftwarePackage_SoftwarePackage	(SoftwarePackageID) → SoftwarePackage(ID)

Table SoftwareCatalogConflict

Contains conflicts detected by the software catalog update mechanism

[ 1 ]

Idx	Field Name	Data Type	Description
*	ID	bigint IDENTITY
*	Created	datetime2	Date/Time the entry was created.
*	SoftwareSignatureID	bigint
	SoftwarePackageID	bigint
	SoftwarePackageGuid	uniqueidentifier
*	Action	nvarchar(50) DEFAULT ''
*	CatalogVersion	nvarchar(128)	Version info of used catalog
*	Notes	nvarchar(max)	Notes written during the catalog update process
Indexes
	PK_SoftwareCatalogConflict	ON ID
Foreign Keys
	FK_SoftwareCatalogConflict_SoftwarePackage	(SoftwarePackageID) → SoftwarePackage(ID)
	FK_SoftwareCatalogConflict_SoftwareSignature	(SoftwareSignatureID) → SoftwareSignature(ID)

Table SoftwareCategory

Defines the software categories.

[ 1 ]

Idx	Field Name	Data Type	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	ON ID
	IX_SoftwareCategory_Name	ON Name
	IX_SoftwareCategory_OctopusID	ON OctopusID
Referring Foreign Keys
	FK_SoftwarePackage_SoftwareCategory	(ID) ← SoftwarePackage(SoftwareCategoryID)

Table SoftwareLicensingType

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

[ 1 ]

Idx	Field Name	Data Type	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	ON ID
	IX_SoftwareLicensingType_Name	ON Name
Referring Foreign Keys
	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.

[ 1 ]

Idx	Field Name	Data Type	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
Indexes
	PK_SoftwarePackage	ON ID
	IX_SoftwarePackage	ON Name
	UK_SoftwarePackage_Guid	ON Guid
	IX_SoftwarePackage_Category	ON SoftwareCategoryID
	IX_SoftwarePackage_Publisher	ON SoftwarePublisherID
Foreign Keys
	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 Keys
	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 SoftwareSignature

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

[ 1 ]

Idx	Field Name	Data Type	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)
Indexes
	PK_SoftwareSignature	ON ID
	IX_SoftwareSignatureSignature	ON Signature
	IX_SoftwareSignature_Dynamic	ON Dynamic
	IX_SoftwareSignature_MD5Hash	ON MD5Hash
	IX_SoftwareSignature_PackageID	ON SoftwarePackageID
	IX_SoftwareSignature_ScanSignature	ON ScanSignature
	IX_SoftwareSignature_SoftwarePublisher	ON SoftwarePublisherID
Foreign Keys
	FK_SoftwareSignature_SoftwarePackage	(SoftwarePackageID) → SoftwarePackage(ID)
	FK_SoftwareSignature_SoftwarePublisher	(SoftwarePublisherID) → SoftwarePublisher(ID)
Referring Foreign Keys
	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.

[ 1 ]

Idx	Field Name	Data Type	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	ON ID
	IX_SwidDocument_MachineSoftwareSignatureID	ON MachineSoftwareSignatureID
Foreign Keys
	FK_SwidDocument_MachineSoftwareSignature	(MachineSoftwareSignatureID) → MachineSoftwareSignature(ID)