LicenseManagerServerFeature

Defines a feature within a license manager server.

erDiagram
    LicenseManagerServer ||--o{ LicenseManagerServerFeature : "LicenseManagerServerID"
    LicenseManagerServerFeature ||--o{ LicenseManagerRbacUserFavoriteFeature : "LicenseManagerServerFeatureID"
    LicenseManagerServerFeature ||--o{ LicenseManagerServerFeatureSessionUsageDetail : "LicenseManagerServerFeatureID"
    LicenseManagerServerFeature ||--o{ LicenseManagerServerFeatureUsageDetail : "LicenseManagerServerFeatureID"
    LicenseManagerServerFeature ||--o{ LicenseManagerServerFeatureUsageDetailShortTerm : "LicenseManagerServerFeatureID"
    LicenseManagerServerFeature ||--o{ LicenseManagerServerFeatureVersion : "LicenseManagerServerFeatureID"
    LicenseManagerServerFeature ||--o{ LicenseManagerServerObserverLog : "LicenseManagerServerFeatureID"

Fields

Field	Type	Description
AnalysisExtras	xml	Reserved for future use
BorrowableLicensesIssued	numeric	Number of licenses available for borrowing (for servers that support limiting borrowable licenses)
CustomField1	string	Available for custom data for this feature, not used by OctoSAM Inventory
CustomField2	string	Available for custom data for this feature, not used by OctoSAM Inventory
CustomField3	string	Available for custom data for this feature, not used by OctoSAM Inventory
CustomField4	string	Available for custom data for this feature, not used by OctoSAM Inventory
Description	string	Description of a feature
ExcludeFromUsageRanking	boolean	Exclude this feature from usage ranking. Can be set for features that are always 100% checked out due to license structure.
Expires	datetime	Expiry date of the license
FriendlyName	string	Friendly name for this feature
Guid	guid	A unique ID that can be used to link to this object from external applications
HintShowBorrowed	boolean	Hint that this feature has borrowed licenses
HintShowCheckedOut	boolean	Hint that this feature has reservations / checked-out licenses
ID	numeric	Internal ID for the LicenseManagerServerFeature entity (Primary Key)
IndicatorFeature	boolean	This feature should be used for summaries about license usage. Indicates usage of the product.
LastDiagScan	datetime	Date/Time of last diagnostics scan for this feature
LastLicensesBorrowed	numeric	Number of borrowed licenses at last scan
LastLicensesBorrowedRatio	float	Licenses borrowed/issued ratio at last scan
LastLicensesCheckedOut	numeric	Licenses detected as checked out. Reserved licenses show up as used but may not be checked out.
LastLicensesCheckedOutRatio	float	Checked-out vs issued licenses
LastLicensesUsed	numeric	Licenses used at last scan
LastLicensesUsedRatio	float	Licenses used/issued ratio at last scan
LastScan	datetime	Date/Time this feature was scanned last
LicenseManagerServerID	numeric	Internal ID that references the LicenseManagerServer entity (Foreign Key)
LicensesIssued	numeric	Number of licenses issued on this feature
LicensesIssuedChanged	datetime	Date/Time the licenses issued value last changed
MaxLicensesUsed	numeric	Max number of licenses used while scanning the feature (since FirstScan)
MaxLicensesUsedChanged	datetime	Date/Time the MaxLicensesUsed field last changed (this is the date/time that the maximum usage ratio was first reached)
Name	string	Feature name
Res1	string	Reserved for future use
Res2	string	Reserved for future use
Starts	datetime	Start date of the license
WorkdaysAvgLicensesBorrowedRatio	float	Average borrowed ratio over the last work days
WorkdaysAvgLicensesCheckedOutRatio	float	Average checked-out ratio over the last work days, used for usage ranking
WorkdaysAvgLicensesUsedRatio	float	Average usage ratio over the last work days, used for usage ranking
WorkdaysFirstDate	datetime	First date used for work days usage calculation
WorkdaysPeakLicensesBorrowed	numeric	Peak number of borrowed licenses over the last work days
WorkdaysPeakLicensesBorrowedRatio	float	Peak borrowed ratio over the last work days
WorkdaysPeakLicensesCheckedOut	numeric	Peak checked-out ratio over the last work days, used for usage ranking
WorkdaysPeakLicensesUsed	numeric	Max licenses used during the last 2 working weeks
WorkdaysPeakLicensesUsedRatio	float	Peak usage ratio over the last work days, used for usage ranking
WorkdaysUsageCalculated	datetime	Date/Time the work days usage was last calculated

References

Column Name	Referenced Table	Description
LicenseManagerServerID	LicenseManagerServer	Defines a license manager server for use by the OctoSAM Monitor module

Referenced by

Table	Column Name	Description
LicenseManagerRbacUserFavoriteFeature	LicenseManagerServerFeatureID	User specific selection of favorite license manager features to display
LicenseManagerServerFeatureSessionUsageDetail	LicenseManagerServerFeatureID	Used to record license sessions (checkouts) per user
LicenseManagerServerFeatureUsageDetail	LicenseManagerServerFeatureID	Used to record issued/used/filtered used counts per feature
LicenseManagerServerFeatureUsageDetailShortTerm	LicenseManagerServerFeatureID	See LicenseManagerServerFeatureUsageDetail table. Short term storage for performance.
LicenseManagerServerFeatureVersion	LicenseManagerServerFeatureID	A feature can have multiple versions each with its own starting and expiry date. Mainly used for expiry warnings.
LicenseManagerServerObserverLog	LicenseManagerServerFeatureID	This table is used to record the activity of the LM observer service