ImportedFOSMLicenseDetails Table

The ImportedFOSMLicenseDetails table holds license details from FOSM API.

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 `ImportedFOSMLicenseDetails` table
Database Column	Details
`ID`	Type: text (max 256 characters). Key License Id
`Name`	Type: text (max 256 characters) License name
`Vendorname`	Type: text (max 256 characters). Nullable Publisher name
`Purchased`	Type: integer. Nullable Total purchased quantity
`Version`	Type: text (max 256 characters). Nullable Version
`IsFree`	Type: boolean. Nullable Unlimited subscription?
`IsHybrid`	Type: boolean. Nullable 0=NamedUser, 1=SaaS
`Expirydate`	Type: datetime. Nullable Expirydate
`Threshold`	Type: integer. Nullable Threshold
`SourceId`	Type: text (max 256 characters). Nullable The value is sourced from DIS Subscription Source ID
`SKU`	Type: text (max 256 characters). Nullable SKU
`ImportedDate`	Type: datetime ImportedDate
`ComplianceConnectionID`	Type: integer. Key ComplianceConnectionID