How many applications in the ARL have an end of life support dates?

How many applications in the ARL have an end of life support dates?

Summary

How to pull End of life support dates from ARL

Question

How many applications in the ARL have an end of life support dates?

Answer

Currently there is no reports in the Web UI to provide this information

You can run the following SQL query to review any Applications that have an End of life Support Date or Extended Support Until date in the current ARL.

----
select st.SoftwareTitleID, stpub.PublisherName, st.FullName AS SoftwareName, stc.DefaultValue AS Classification, st.ReleaseDate, st.SupportedUntil, st.ExtendedSupportUntil, st.Comments 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
-----

Additional Information

There is a current Enhancement request to include a report for end of life support dates.

Reference #: FNMS-43432
Was this article helpful? Yes No
No ratings
Version history
Revision #:
1 of 1
Last update:
‎Jun 09, 2018 02:09 AM
Updated by: