Some users may have issues creating a community account See more here.

kathy_allen
Frequent contributor

EOL/EOS reports

Jump to solution

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?

0 Kudos
1 Solution
kclausen
Flexera
Flexera

@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

0 Kudos
2 Replies
kclausen
Flexera
Flexera

@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

0 Kudos
mfranz
Trusted advisor

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
Softline Group is Europe's leading independent expert in Software Asset Management.