Summary
Software end of support life (EOSL) data for applications that are recognized as installed on at least one computer are exposed through various columns available on the License Compliance > Installed Applications grid in the FlexNet Manager Suite UI:
Additional EOSL data (including data for applications that are not recognized as installed) can be found by directly querying the database of FlexNet Manager Suite On-premises installations.
Accessing EOSL data directly in the database
A SQL query like the following can be executed against a FlexNet Manager Suite On-premises compliance database to review applications in the currently installed ARL version that have an End of Life Support Date or Extended Support Until date:
SELECT st.SoftwareTitleID, stpub.PublisherName, st.FullName, Classification = stc.DefaultValue, st.ReleaseDate, st.SupportedUntil, st.ExtendedSupportUntil FROM SoftwareTitle st JOIN SoftwareTitleClassification stc ON st.SoftwareTitleClassificationID = stc.SoftwareTitleClassificationID LEFT OUTER JOIN SoftwareTitleProduct stp ON st.SoftwareTitleProductID = stp.SoftwareTitleProductID LEFT OUTER JOIN SoftwareTitlePublisher stpub ON stp.SoftwareTitlePublisherID = stpub.SoftwareTitlePublisherID WHERE st.SoftwareTitleID < 0 AND (st.ExtendedSupportUntil IS NOT NULL OR st.SupportedUntil IS NOT NULL)
If you are licensed for and have the EOSL data pack installed, a query like the following can be used to obtain EOSL data from this data pack:
SELECT st.SoftwareTitleID, stpub.PublisherName, st.FullName, Classification = stc.DefaultValue, st.ReleaseDate, eosl.StartOfLifeDate, eosl.EndOfSalesDate, eosl.EndOfLifeDate, eosl.SupportedUntil, eosl.ExtendedSupportUntil FROM SoftwareTitle st JOIN SoftwareTitleClassification stc ON st.SoftwareTitleClassificationID = stc.SoftwareTitleClassificationID LEFT OUTER JOIN SoftwareTitleProduct stp ON st.SoftwareTitleProductID = stp.SoftwareTitleProductID LEFT OUTER JOIN SoftwareTitlePublisher stpub ON stp.SoftwareTitlePublisherID = stpub.SoftwareTitlePublisherID JOIN SoftwareTitleEOSL eosl ON eosl.SoftwareTitleID = st.SoftwareTitleID
Additional Information
An enhancement request to expose EOSL data in additional parts of the FlexNet Manager Suite UI has been opened with reference # IOJ-1815981.
Related Articles
The installed application recognition library (ARL) is incompatible with this release of FlexNet Manager Platform 5Number of Views Why some SQL Server components such as Reporting Service / Integration Service / Analysis Service are classified as Commer… 8Number of Views "Import ManageSoft application recognition library" scheduled task fails with 0x1 error code 5Number of Views Alert shows End of life and End of support for Snow Inventory Agent Powershell script Scan-Swid 7Number of Views How to Suggest Changes to the ARL SKU Library or PURL? 16Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago