SoftwareTitle Table
The SoftwareTitle
table contains the application titles managed by FlexNet Manager Suite.
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.
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 |
SoftwareTitleProductID
|
Type: integer. Key The application product, which also may specify a publisher. Foreign key to the |
SoftwareTitleVersionID
|
Type: integer. Key. Nullable The application version. Foreign key to the |
SoftwareTitleEditionID
|
Type: integer. Key. Nullable The application edition. Foreign key to the |
OperatorManageStateID
|
Type: integer. Key The management responsibility for this information. Foreign key to the |
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 |
IsMonitoringSessions
|
Type: boolean Set this field to |
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 |
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 |
CategoryID
|
Type: text (max 128 characters). Key. Nullable Any enterprise category associated with this application title. Foreign key to the |
IsLicensable
|
Type: boolean Set this field to |
ReleaseDate
|
Type: datetime. Nullable The date the application was released. |
IsSharableToLibrary
|
Type: boolean Set this field to |
AutoManageLicensePriority
|
Type: boolean Set this field to |
TitleRequiresStrict Matching
|
Type: boolean Set this field to |
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 |
HasInstalls
|
Type: boolean If this field is |
SoftwareLifeCycleID
|
Type: integer. Key. Nullable Foreign key to the |
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 |