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:
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