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