Software Lifecycle Data

Software lifecycle

Get software lifecycle data by querying the Release attribute on the ASSET node.

The following table describes the software lifecycle attributes:

Table 1. Software lifecycle Attributes

AttributeData TypeDescription
support_end_of_life_datedatetimeThe last date (YYYY-MM-DD) that full support for a product is provided by the vendor. Partial support might still be available.
end_of_life_exceptionstringThe reason why the end-of-life date is not available or a caveat on the date value that is provided.
general_availability_datedatetimeThe date in which the product is generally available through official vendor distributions as published by the vendor.
general_availability_exceptionstringThe reason the general availability date is not available or a caveat on the date value that is provided.
support_obsolete_datedatetimeThe last date (YYYY-MM-DD) that any support is provided by the vendor. The only support that might be available after this date, if applicable, is self-help online support.
obsolete_exceptionstringA reason why the obsolete date is not available or a caveat on the date value that is provided.

Date formats in lifecycle queries

Use the following format to specify dates :
<YYYY-MM-DD> for example,

2017-02-31
2018-10-28

To include a time, use the following format:

<YYYY-MM-DDTHH:MM:SSZ> for example,

2017-02-31T05:21:59Z
2017-02-31T06:22:58Z

Note: the hours, minutes, and seconds can be expressed as any time value.

Query example one

Return assets with an end-of-life date between 2018-08-07 and 2018-12-31, and include the product, version, and end-of-life date for each asset.

MATCH (a:ASSET) WHERE a.support_end_of_life_date >= "2018-08-07T00:00:00Z" AND a.support_end_of_life_date <= "2018-12-31T00:00:00Z" RETURN a.support_end_of_life_date, a.product, a.version LIMIT 10

The following image shows query results for support_end_of_life_date, product, and version:

Figure 1. Query results for end-of-life date, product, and version

Query example two

Return assets that have an end-of-life date that is between '2018-11-31' and ‘2018-12-31’.

MATCH (eol:ASSET) WHERE eol.support_end_of_life_date < "2018-12-31" AND eol.support_end_of_life_date > "2018-11-31" RETURN eol.release, eol.support_end_of_life_date, eol.support_obsolete_date LIMIT 5

The following image shows five results for the query:

Figure 2. Query results for products with end-of-life date between specific dates

Query example three

Find assets that have a general availability date after 2003-03-01 and an end-of-life date before 2020-09-07.

MATCH (a:ASSET) WHERE a.general_availability_date > "2003-03-01" AND a.support_end_of_life_date < "2020-09-07" RETURN a.support_end_of_life_date, a.general_availability_date, a.title LIMIT 5

The following image shows five results for the query:

Figure 3. Query results for end-of-life and general availability criteria

More query examples

To use the MATCH statements in the following examples, you add the MATCH statement to the following /tql endpoint and make a GET request from an API client or use cURL.

https://data.technopedia.com/tql?q=<MATCH Statement>

MATCH (a:ASSET) WHERE a.support_end_of_life_date = "2018-09-23T00:00:00Z" RETURN a LIMIT 2

RESPONSE

{
    "results": [
        {
            "a.class": "Software",
            "a.created_at": "2013-05-30T13:36:13Z",
            "a.general_availability_date": "2013-09-23T00:00:00Z",
            "a.is_suite": "FALSE",
            "a.modified_at": "2018-06-27T18:03:05Z",
            "a.owner": "Adobe Systems",
            "a.product": "Photoshop Elements",
            "a.release": "Adobe Systems Photoshop Elements 12.0",
            "a.support_end_of_life_date": "2018-09-23T00:00:00Z",
            "a.support_obsolete_date": "2020-09-23T00:00:00Z",
            "a.technopedia_id": "e716c464-12d3-4667-b6aa-0ca9d11a846b",
            "a.title": "Adobe Systems Photoshop Elements 12.0",
            "a.type": "Release",
            "a.url": "http://www.softwarevoucher.com/adobe-elements-12-release-date/",
            "a.version": "12.0",
            "a.version_group": "12.0",
            "a.version_order": "18"
        },
        {
            "a.class": "Software",
            "a.created_at": "2014-07-30T13:08:56Z",
            "a.general_availability_date": "2014-03-07T00:00:00Z",
            "a.is_suite": "FALSE",
            "a.modified_at": "2017-07-26T15:52:02Z",
            "a.owner": "Adobe Systems",
            "a.product": "Photoshop Elements",
            "a.release": "Adobe Systems Photoshop Elements 12.1",
            "a.support_end_of_life_date": "2018-09-23T00:00:00Z",
            "a.support_obsolete_date": "2020-09-23T00:00:00Z",
            "a.technopedia_id": "d4c2b17c-e0ca-4a7e-9a1a-ecba1d585989",
            "a.title": "Adobe Systems Photoshop Elements 12.1",
            "a.type": "Release",
            "a.url": "http://atr935.blogspot.hk/2014/03/pe12-update-121-released.html",
            "a.version": "12.1",
            "a.version_group": "12.0",
            "a.version_order": "19"
        }
    ]
}
MATCH (a:ASSET) WHERE a.support_end_of_life_date >= "2017-01-01T00:00:00Z" 
AND a.support_end_of_life_date <= "2019-02-28T00:00:00Z" RETURN a LIMIT 2

RESPONSE

{
    "results": [
        {
            "a.class": "Software",
            "a.created_at": "2016-06-23T10:32:26Z",
            "a.desupported_flag": true,
            "a.end_of_life_exception": "Exact date unknown: a date range is provided",
            "a.general_availability_date": "2005-09-01T00:00:00Z",
            "a.modified_at": "2017-10-10T14:52:15Z",
            "a.owner": "ACI Worldwide",
            "a.product": "Communication Services",
            "a.release": "ACI Worldwide Communication Services 4.2",
            "a.support_end_of_life_date": "2017-01-01T00:00:00Z",
            "a.support_obsolete_date": "2017-01-01T00:00:00Z",
            "a.technopedia_id": "ac0630f2-1e30-4a3e-a85e-514d0ea905c3",
            "a.title": "ACI Worldwide Communication Services 4.2",
            "a.type": "Release",
            "a.url": "https://bdnacorp.atlassian.net/secure/attachment/11218/ICE4.2%20ICE-XS1.1%20SafeTGate%201.1%20WebGate%204.2%20sunset%20announcement.pdf",
            "a.version": "4.2",
            "a.version_group": "4",
            "a.version_order": "2"
        },
        {
            "a.class": "Software",
            "a.created_at": "2016-06-23T10:31:46Z",
            "a.desupported_flag": true,
            "a.end_of_life_exception": "Exact date unknown: a date range is provided",
            "a.general_availability_date": "2003-03-01T00:00:00Z",
            "a.modified_at": "2017-10-10T14:52:15Z",
            "a.owner": "ACI Worldwide",
            "a.product": "Communication Services",
            "a.release": "ACI Worldwide Communication Services 4.1",
            "a.support_end_of_life_date": "2017-01-01T00:00:00Z",
            "a.support_obsolete_date": "2017-01-01T00:00:00Z",
            "a.technopedia_id": "0af0dd25-684d-4470-bf7e-6e9629cf9f57",
            "a.title": "ACI Worldwide Communication Services 4.1",
            "a.type": "Release",
            "a.url": "https://bdnacorp.atlassian.net/secure/attachment/11218/ICE4.2%20ICE-XS1.1%20SafeTGate%201.1%20WebGate%204.2%20sunset%20announcement.pdf",
            "a.version": "4.1",
            "a.version_group": "4",
            "a.version_order": "1"
        }
    ]
}
MATCH (a:ASSET {type: 'Release', product: 'Windows XP', owner: 'Microsoft'}) RETURN a.product, a.version, a.support_end_of_life_date, a.edition LIMIT 10

RESPONSE

{
    "results": [
        {
            "a.edition": "Media Center",
            "a.product": "Windows XP",
            "a.support_end_of_life_date": "2010-07-13T00:00:00Z",
            "a.version": "2002"
        },
        {
            "a.edition": "Media Center",
            "a.product": "Windows XP",
            "a.support_end_of_life_date": "2006-10-10T00:00:00Z",
            "a.version": "2002"
        },
        {
            "a.edition": "Media Center",
            "a.product": "Windows XP",
            "a.support_end_of_life_date": "2006-10-10T00:00:00Z",
            "a.version": "2004"
        },
        {
            "a.edition": "Professional",
            "a.product": "Windows XP",
            "a.support_end_of_life_date": "2009-04-14T00:00:00Z",
            "a.version": "2002"
        },
        {
            "a.edition": "Home",
            "a.product": "Windows XP",
            "a.support_end_of_life_date": "2009-04-14T00:00:00Z",
            "a.version": "2002"
        },
        {
            "a.edition": "64-bit (Itanium)",
            "a.product": "Windows XP",
            "a.support_end_of_life_date": "2009-04-14T00:00:00Z",
            "a.version": "2002"
        },
        {
            "a.edition": "Media Center",
            "a.product": "Windows XP",
            "a.support_end_of_life_date": "2009-04-14T00:00:00Z",
            "a.version": "2002"
        },
        {
            "a.edition": "Media Center",
            "a.product": "Windows XP",
            "a.support_end_of_life_date": "2009-04-14T00:00:00Z",
            "a.version": "2004"
        },
        {
            "a.edition": "Tablet PC",
            "a.product": "Windows XP",
            "a.support_end_of_life_date": "2009-04-14T00:00:00Z",
            "a.version": "2004"
        },
        {
            "a.edition": "Media Center",
            "a.product": "Windows XP",
            "a.support_end_of_life_date": "2010-07-13T00:00:00Z",
            "a.version": "2004"
        }
    ]
}
MATCH (a:ASSET {type: 'Release'}) WHERE a.support_obsolete_date > '2017-04-14T00:00:00Z' AND a.support_obsolete_date < "2018-04-14T00:00:00Z" RETURN a.support_obsolete_date, a.product, a.title LIMIT 5

RESPONSE

{
    "results": [
        {
            "a.product": "Transformation Services for Documents (Document Transformation)",
            "a.support_obsolete_date": "2017-08-10T00:00:00Z",
            "a.title": "Actuate Xenos Transformation Services for Documents (Document Transformation) 3.3"
        },
        {
            "a.product": "Transformation Services for Documents (Document Transformation)",
            "a.support_obsolete_date": "2017-08-10T00:00:00Z",
            "a.title": "Actuate Xenos Transformation Services for Documents (Document Transformation) 3.4"
        },
        {
            "a.product": "Enterprise Server",
            "a.support_obsolete_date": "2017-08-10T00:00:00Z",
            "a.title": "Actuate Xenos Enterprise Server 3.1"
        },
        {
            "a.product": "Enterprise Server",
            "a.support_obsolete_date": "2017-08-10T00:00:00Z",
            "a.title": "Actuate Xenos Enterprise Server 3.0"
        },
        {
            "a.product": "Content Services Process Manager",
            "a.support_obsolete_date": "2017-08-10T00:00:00Z",
            "a.title": "Actuate BIRT Content Services Process Manager 3.1"
        }
    ]
}
MATCH (a:ASSET {type: 'Release'}) where a.general_availability_date > "2010-01-01T00:00:00Z" RETURN a.general_availability_date, a.title LIMIT 10

RESPONSE

{
    "results": [
        {
            "a.general_availability_date": "2015-06-18T00:00:00Z",
            "a.title": "20-20 Technologies 2020 Cap 2015"
        },
        {
            "a.general_availability_date": "2015-09-02T00:00:00Z",
            "a.title": "20-20 Technologies 2020 Cap 2015.1"
        },
        {
            "a.general_availability_date": "2016-02-02T00:00:00Z",
            "a.title": "20-20 Technologies 2020 Cap 2015.3"
        },
        {
            "a.general_availability_date": "2015-11-06T00:00:00Z",
            "a.title": "20-20 Technologies 2020 Cap 2015.2"
        },
        {
            "a.general_availability_date": "2017-02-07T00:00:00Z",
            "a.title": "20-20 Technologies 2020 Cap 2016.3"
        },
        {
            "a.general_availability_date": "2016-11-01T00:00:00Z",
            "a.title": "20-20 Technologies 2020 Cap 2016.2"
        },
        {
            "a.general_availability_date": "2016-07-29T00:00:00Z",
            "a.title": "20-20 Technologies 2020 Cap 2016.1"
        },
        {
            "a.general_availability_date": "2016-05-24T00:00:00Z",
            "a.title": "20-20 Technologies 2020 Cap 2016"
        },
        {
            "a.general_availability_date": "2014-10-31T00:00:00Z",
            "a.title": "20-20 Technologies 2020 Cap 10.3"
        },
        {
            "a.general_availability_date": "2015-06-18T00:00:00Z",
            "a.title": "20-20 Technologies WorkSheet 2015"
        }
    ]
}
MATCH (a:ASSET) WHERE a.end_of_life_exception <> "Date in the past: exact date unknown" AND a.support_end_of_life_date >= "2018-08-07T00:00:00Z" 
AND a.support_end_of_life_date <= "2019-02-07T00:00:00Z" RETURN a LIMIT 2

RESPONSE

{
    "results": [
        {
            "a.class": "Software",
            "a.created_at": "2018-05-29T16:06:29Z",
            "a.desupported_flag": true,
            "a.end_of_life_exception": "Exact date unknown: a date range is provided",
            "a.family": "BIRT",
            "a.general_availability_date": "2014-10-27T00:00:00Z",
            "a.is_suite": "FALSE",
            "a.modified_at": "2018-09-01T18:27:55Z",
            "a.obsolete_exception": "Exact date unknown: a date range is provided",
            "a.owner": "Actuate",
            "a.product": "Process Designer",
            "a.release": "Actuate BIRT Process Designer 5.1",
            "a.support_end_of_life_date": "2018-09-01T00:00:00Z",
            "a.support_obsolete_date": "2018-09-01T00:00:00Z",
            "a.technopedia_id": "55ac85de-e46c-4ff2-84fb-85ec1b014f23",
            "a.title": "Actuate BIRT Process Designer 5.1",
            "a.type": "Release",
            "a.url": "http://blogs.opentext.com/announcing-the-actuate-customer-communication-suite-release-5-1/",
            "a.version": "5.1",
            "a.version_group": "5",
            "a.version_order": "11"
        },
        {
            "a.class": "Software",
            "a.created_at": "2014-12-18T15:41:06Z",
            "a.end_of_life_exception": "Exact date unknown: a date range is provided",
            "a.is_suite": "TRUE",
            "a.modified_at": "2014-12-18T15:41:52Z",
            "a.owner": "BMC Software",
            "a.product": "Middleware Management",
            "a.release": "BMC Software Middleware Management 1.0",
            "a.support_end_of_life_date": "2018-12-31T00:00:00Z",
            "a.support_obsolete_date": "2018-12-31T00:00:00Z",
            "a.technopedia_id": "b8e7fdb6-65bd-4db7-b540-4ac611691af8",
            "a.title": "BMC Software Middleware Management 1.0",
            "a.type": "Release",
            "a.url": "https://webapps.bmc.com/support/faces/az/prodallversions.jsp?seqid=182028",
            "a.version": "1.0",
            "a.version_group": "1",
            "a.version_order": "1"
        }
    ]
}
MATCH (a:ASSET {type:"Release"})
WHERE a.support_end_of_life_date > '2019-01-01' 
AND a.support_end_of_life_date < '2030-01-01'
AND a.owner contains 'Microsoft'
RETURN a.title, a.owner, a.general_availability_date, a.support_end_of_life_date, a.support_obsolete_date LIMIT 10

RESPONSE

{
    "results": [
        {
            "a.general_availability_date": "2018-05-07T00:00:00Z",
            "a.owner": "Microsoft",
            "a.support_end_of_life_date": "2022-04-12T00:00:00Z",
            "a.support_obsolete_date": "2027-04-13T00:00:00Z",
            "a.title": "Microsoft Visual Studio Build Tools 15.7"
        },
        {
            "a.general_availability_date": "2018-03-05T00:00:00Z",
            "a.owner": "Microsoft",
            "a.support_end_of_life_date": "2022-04-12T00:00:00Z",
            "a.support_obsolete_date": "2027-04-13T00:00:00Z",
            "a.title": "Microsoft Visual Studio Build Tools 15.6"
        },
        {
            "a.general_availability_date": null,
            "a.owner": "Microsoft",
            "a.support_end_of_life_date": "2022-04-12T00:00:00Z",
            "a.support_obsolete_date": "2027-04-13T00:00:00Z",
            "a.title": "Microsoft Visual Studio Build Tools 15.5"
        },
        {
            "a.general_availability_date": "2017-03-07T00:00:00Z",
            "a.owner": "Microsoft",
            "a.support_end_of_life_date": "2022-04-12T00:00:00Z",
            "a.support_obsolete_date": "2027-04-13T00:00:00Z",
            "a.title": "Microsoft Visual Studio Build Tools 15.0"
        },
        {
            "a.general_availability_date": "2016-12-07T00:00:00Z",
            "a.owner": "Microsoft",
            "a.support_end_of_life_date": "2019-01-01T00:00:00Z",
            "a.support_obsolete_date": "2019-01-01T00:00:00Z",
            "a.title": "Microsoft Machine Learning Server 9.0"
        },
        {
            "a.general_availability_date": "2017-04-19T00:00:00Z",
            "a.owner": "Microsoft",
            "a.support_end_of_life_date": "2019-05-01T00:00:00Z",
            "a.support_obsolete_date": "2019-05-01T00:00:00Z",
            "a.title": "Microsoft Machine Learning Server 9.1"
        },
        {
            "a.general_availability_date": null,
            "a.owner": "Microsoft",
            "a.support_end_of_life_date": "2021-10-12T00:00:00Z",
            "a.support_obsolete_date": "2021-10-12T00:00:00Z",
            "a.title": "Microsoft Silverlight for Developers 5.0"
        },
        {
            "a.general_availability_date": "2017-03-07T00:00:00Z",
            "a.owner": "Microsoft",
            "a.support_end_of_life_date": "2019-06-27T00:00:00Z",
            "a.support_obsolete_date": "2019-06-27T00:00:00Z",
            "a.title": "Microsoft .NET Core SDK 1.0"
        },
        {
            "a.general_availability_date": "2017-09-21T00:00:00Z",
            "a.owner": "Microsoft",
            "a.support_end_of_life_date": "2019-06-27T00:00:00Z",
            "a.support_obsolete_date": "2019-06-27T00:00:00Z",
            "a.title": "Microsoft .NET Core SDK 1.1"
        },
        {
            "a.general_availability_date": "2017-12-04T00:00:00Z",
            "a.owner": "Microsoft",
            "a.support_end_of_life_date": "2020-08-14T00:00:00Z",
            "a.support_obsolete_date": "2020-08-14T00:00:00Z",
            "a.title": "Microsoft .NET Core SDK 2.1"
        }
    ]
}

Updated about a year ago

Software Lifecycle Data


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.