Some users may have issues creating a community account. For more information, please click here.

Where can I access end of support life (EOSL) data for applications in the application recognition library (ARL)?

Where can I access end of support life (EOSL) data for applications in the application recognition library (ARL)?

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:

image.png

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
	t.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
	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.

Was this article helpful? Yes No
No ratings
Comments

Is this still the most accurate query to get this information? I'm seeing 5028 titles that have EOSL data and want to confirm this is accurate.

@dbeckner - The query in this article gives insight into the limited EOSL data that is contained within the ARL. If you are licensed for the EOSL data pack and have that data installed, the query discussed in the following thread may be helpful to give insight into the shape of that EOSL data: EOSL information needed.

I've refreshed this article to provide some further clarity and another sample query to access EOSL data pack data.

Version history
Revision #:
3 of 3
Last update:
‎Apr 06, 2021 09:22 PM
Updated by:
 
Contributors