cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

EOL/EOS reports

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?

(1) 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.

View solution in original post

(2) Replies

@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
By Level 17 Champion
Level 17 Champion

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