EOL/EOS reports

[kathy_allen]

Is there a way to pull a report from FNMS that shows EOL or EOS for applications if it is populated?  I could not find those fields when creating a new report.

If not, can someone provide the SQL statement that would be needed to pull it from the actual database?

[kclausen · Accepted solution]

@kathy_allen  - If you go into the Column Chooser in the Installed Applications view, you will find the EOL dates available to be added to the view.  You can then save this off as a Custom Management View.

[mfranz]

Something like this?

SELECT
	st.FullName
	,st.SupportedUntil
	,st.ExtendedSupportUntil
	,st.EndOfLifeDate
FROM SoftwareTitle st
WHERE
	st.SupportedUntil IS NOT NULL
	OR st.ExtendedSupportUntil IS NOT NULL
	OR st.EndOfLifeDate IS NOT NULL
ORDER BY st.FullName