oqueck (Flexera Software) asked a question.
Hi,
we would need all EOSL information and dates exported into excel and would like to know how to best achieve this. Is there a view available for this, or could a new report being created, which contains the following information for each software application:
- Start Of Life
- Release Date
- End Of Sales
- End Of Support
- End Of Extended Support
- End Of Life
Thanks & best regards
Oliver
Try going to the Installed Applications view and adding these as optional columns to the view. You can then download to Excel.
Kirk
I viewed the end of life in our instance and not one record has any end of life information in it. Is there some condition where some folks get end of life and some folks don't?
Also, if we aren't licensed to get end of life, how can we update this ourselves, if the ARL is not editable? We should have some way to maintain this ourselves if we choose.
The Flexera help states that we could update the end of life dates ourselves if the product does not exist .
So how can we update these dates? We should be able to do this ourselves. There should be a dropdown that provides a calendar in order to do the update.
Excerpt from Oracle lifetime doc showing end of life for License Server. Wanted to update the end of life to the premier support end date.
Hi,
Have you purchased the Service Life Data Pack or subscribed to Data Platforms with the End of Life Content Pack?
If you check the FNMS license, via the cog menu at the top right hand side of the FNMS interface and select FlexNet Manager Suite License, you need to have the Service Life Data Pack option enabled. The below image would be a white box if it was enabled.
The EOSL data pack enriches the ARL data with all the available service life dates that have been curated by Flexera. There will be some dates in the standard ARL but the majority of dates are available via the content pack. If products you need dates on are not covered by the ARL data, I recommend getting a demo of the End of Life Data Pack from Flexera or your SAM service provider partner and organising a purchase if it meets your needs.
One of our customers has purchased 'Service life data pack', we can see that enabled in FNMS license page.
In installed apps page, we can see 30207 installed applications, but only 1417 applications got 'End Of support' updated.
When we looked at 'commercial' only apps, out of 3033 installed apps, only 840 apps got the 'end of support' information.
To mention, the top installed applications are from IBM, Microsoft, Oracle, Adobe, Red Hat, Oracle, Cent OS. Many of these applications (includes most widely used commercial products) do not have this information at all. We do not see any major updates to this information either.
Having the datapack module purchased, the customer not satisfied with the coverage of the EOSL info for atleast the top vendors.
- Does the DP product covers the EOSL for the same vendors better than FNMS ?
- Does Flexera publishes the count of applications which have this infromation updated some thing similar to SKU count or ARL count ?
- Is there any way to know for which applications/publishers - the EOSL information being updated regularly similar to ARL update notifications ?
Any other suggestions, comments here please ?
So you have perspective.
Flexera was doing the EOSL on a best effort basis as an added value proposition to begin with in FNMS. They found that it was important to there user community. The made the strategic decision to be BDNA and have rebranded it as Data Platform. When they announced the added cost to the ITUG group they received some push back but had to show ROI for BDNA and have moved to integrating it into their product offerings.
Options.
If you want the integrated data, you will need to purchase the Data Platform. If you are more interested in the data itself, check with you security professionals. Most of their tools also include EOSL data since that is explicitly a security concern (and more than a few vendors are getting there data from the Data Platform)
Jeff
Hi @ImIronMan ,
We are planning increases for the coverage to bring it up to parity with Data Platform in 2021. That said, the ARL will continue to be curated for purposes of software license management - for many use cases including security as @JeffVoss mentions, you'll need the finer recognition granularity that Data Platform provides compared to FlexNet Manager.
@kclausen understand and have done that in the past. The specific requirement has other column headers involved that are not available in that specific view. That's the reason I'm trying to build a report to cover all of the column header requirements. The column headers I need are below. I'm stuck on the lifecycle fields now.
After importing the EOSL package into FNMS, you will see an additional table named [SoftwareTitleEOSL] in the [FNMSCompliance] database.
When joining this table with the [SoftwareTitle] table as shown in the SQL below, you can retrieve additional application related properties for your report, including
With the current ARL and EOSL package, the statement below should return about 19.500 rows where the [EndOfLifeDate] is not empty.
- SELECT st.FullName ,st.SoftwareTitleID ,stp.ProductName ,stv.VersionName AS Version ,ste.EditionName As Edition ,stc.DefaultValue AS SoftwareTitleClassification ,ge.Path AS Category ,st.IsLicensable ,st.ReleaseDate ,st.IsSharableToLibrary ,st.AutoManageLicensePriority ,st.TitleRequiresStrictMatching ,st.HasInstalls ,eosl.StartOfLifeDate ,eosl.EndOfSalesDate ,eosl.EndOfLifeDate ,eosl.SupportedUntil ,eosl.ExtendedSupportUntil FROM [SoftwareTitle] st JOIN [SoftwareTitleType] stt ON st.[SoftwareTitleTypeID] = stt.[SoftwareTitleTypeID] JOIN [SoftwareTitleProduct] stp ON st.[SoftwareTitleProductID] = stp.[SoftwareTitleProductID] LEFT JOIN [SoftwareTitleVersion] stv ON st.[SoftwareTitleVersionID] = stv.[SoftwareTitleVersionID] LEFT JOIN [SoftwareTitleEdition] ste ON st.SoftwareTitleEditionID = ste.SoftwareTitleEditionID JOIN [OperatorManageState] oms ON st.[OperatorManageStateID] = oms.OperatorManageStateID JOIN [SoftwareTitleClassification] stc ON st.SoftwareTitleClassificationID = stc.SoftwareTitleClassificationID JOIN [GroupEX] ge ON ge.GroupExID = st.CategoryID JOIN [SoftwareTitleEOSL] eosl ON eosl.SoftwareTitleID = st.SoftwareTitleID
@jhanes - The end of life dates in the ARL are currently not available in the Report Builder data models. Your option is to build a standard Installation Report by device that includes the Application Name and download to Excel. Go to the Installed Applications View and add your end of life dates there and download to Excel. Merge the 2 Excel spreadsheets together on the Application Name.
If you have FNMS On-Premises, you can do as @erwinlindemann , which is to build a report/view in SQL that has the information that you need.
For reference, the following article may also help with some more insight on accessing EOSL data: Where can I access end of support life (EOSL) data for applications in the application recognition library (ARL)?
Try going to the Installed Applications view and adding these as optional columns to the view. You can then download to Excel.
Kirk