SoftwareTitle Table

The SoftwareTitle table contains the application titles managed by FlexNet Manager Suite.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for SoftwareTitle table

Database Column

Details

SoftwareTitleID

Type: integer. Key. Generated ID

A unique identifier for a software record.

SoftwareTitleTypeID

Type: integer. Key

The application type. Foreign key to the SoftwareTitleType table.

SoftwareTitleProductID

Type: integer. Key

The application product, which also may specify a publisher. Foreign key to the SoftwareTitleProduct table.

SoftwareTitleVersionID

Type: integer. Key. Nullable

The application version. Foreign key to the SoftwareTitleVersion table.

SoftwareTitleEditionID

Type: integer. Key. Nullable

The application edition. Foreign key to the SoftwareTitleEdition table.

OperatorManageStateID

Type: integer. Key

The management responsibility for this information. Foreign key to the OperatorManageState table.

FullName

Type: text (max 512 characters)

By default, the full name of the application is the concatenation of the product, version, and edition fields. The operator may overwrite this with any preferred value.

SoftwareTitle ClassificationID

Type: integer. Nullable

The classification of the title. Defaults to None. Foreign key to the SoftwareTitleClassification table.

IsMonitoringSessions

Type: boolean

Set this field to True if sessions are being monitored.

UsageSessions

Type: integer

An application is considered used if it is opened more than this many times within the monitoring period.

IsMonitoringActiveTime

Type: boolean

Set this field to True if active time is being monitored.

UsageActiveTime

Type: integer

An application is considered used if the application active time (time it is in the foreground) exceeds this value during the monitoring period.

UsagePeriod

Type: integer

The period in months over which to consider usage.

Comments

Type: text. Nullable

Stores any comments an operator wants to make about a particular application title.

SKU

Type: text (max 200 characters). Nullable

Deprecated: now use LicensePartNo of the PurchaseOrderDetail table. Stock Keeping Unit (SKU) for the application.

CategoryID

Type: text (max 128 characters). Key. Nullable

Any enterprise category associated with this application title. Foreign key to the GroupEx table.

IsLicensable

Type: boolean

Set this field to True if this application needs a license. If False, the application doesn’t need a license.

ReleaseDate

Type: datetime. Nullable

The date the application was released.

IsSharableToLibrary

Type: boolean

Set this field to True if the application is sharable to the FlexNet Manager Suite ARL library.

AutoManageLicensePriority

Type: boolean

Set this field to True if the application should automatically manage the priority of attached licenses.

TitleRequiresStrict Matching

Type: boolean

Set this field to True if the application should use stricter matching rules, requiring all evidence of all types to be present.

SupportedUntil

Type: datetime. Nullable

The date the application will be supported

ExtendedSupportUntil

Type: datetime. Nullable

The date the application will be supported, in extended case

StartOfLifeDate

Type: datetime. Nullable

Start of life Date

EndOfSalesDate

Type: datetime. Nullable

End of sales Date

EndOfLifeDate

Type: datetime. Nullable

End of life Date

SoftwareTitleActionID

Type: integer

A categorization for the application in the enterprise. Defaults to New.Foreign key to the SoftwareTitleAction table.

HasInstalls

Type: boolean

If this field is True this application has at least one installation. If False, the application has no installations.

SoftwareLifeCycleID

Type: integer. Key. Nullable

Foreign key to the SoftwareLifeCycle table.

HasCustomEndOfSupportLife

Type: boolean. Nullable

Set this field to indicate custom end of support life for this application.

CustomEndOfSupportLife Date

Type: datetime. Nullable

Custom end of support life date.

IsShared

Type: boolean