Hardware Lifecycle Data

Hardware lifecycle

You can access hardware lifecycle data by querying the hardware model on the ASSET node.

The following table describes the lifecycle attributes:

Table 1. Hardware lifecycle attributes

AttributeData TypeDescription
end_of_sales_datedatetimeThe last date to order the product through manufacturer point-of-sale mechanisms.
general_availability_datestringThe date that the product is generally available through official vendor distributions as published by the vendor.
general_availability_exceptionstringThe reason why the general availability date is not available or a caveat on the date value that is provided.
support_obsolete_datedateLast date when any support is available from the manufacturer.
obsolete_exceptionstringThe reason why the support-obsolete date is not available or a caveat on the date value that is provided.
support_end_of_life_datedatetimeThe date when a device is announced as discontinued or legacy by the manufacturer.

NOTE: no data is available currently for this attribute.
end_of_life_exceptionstringThe reason the support end of life date is not available or a caveat on the date value that is provided.

NOTE: no data is available currently for this attribute.

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 hardware assets that have an end-of-life date between 1980-08-07 and 2018-08-31, and include the product, model, and general-availability date for each asset.

MATCH (a:ASSET {type: 'Model'}) WHERE a.general_availability_date >"1980-08-07" AND a.general_availability_date <"2018-08-31" RETURN a.general_availability_date, a.product, a.model LIMIT 10

The following image shows query results for general_availability_date, product, and model:

Figure 1. Query results for general availability date, product, and model

Query example two

Return five hardware assets that have a support_obsolete_date that is greater than '1900-01-01T00:00:00Z'
MATCH (a:ASSET {class: 'Hardware'}) WHERE a.support_obsolete_date > '1900-01-01T00:00:00Z' RETURN a.support_obsolete_date, a.model LIMIT 5

The following image shows five results from the query:

Figure 2. Query results for five hardware models where the support obsolete date is greater than 1900-01-01

Query example three

Find five assets that have a general availability date after 2003-03-01 and return the model, and title.
MATCH (a:ASSET {class: 'Hardware'}) WHERE a.general_availability_date > '2003-03-01' RETURN a.model, a.title LIMIT 5
The following image shows five results for the query:

Figure 3. Results from query that uses general availability date 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 {class: 'Hardware'}) WHERE a.general_availability_date >= "2015-01-01T00:00:00Z" 
AND a.support_obsolete_date <= "2019-02-28T00:00:00Z" RETURN a LIMIT 1

RESPONSE

{
    "results": [
        {
            "a.class": "Hardware",
            "a.created_at": "2017-03-23T15:16:15Z",
            "a.end_of_sales_date": "Not Available",
            "a.general_availability_date": "2015-10-01T00:00:00Z",
            "a.general_availability_exception": "Date not published by vendor",
            "a.model": "MP C306SPF",
            "a.modified_at": "2018-06-08T18:41:22Z",
            "a.owner": "Ricoh Americas",
            "a.product": "Aficio Multifunction (Networked)",
            "a.support_obsolete_date": "2018-12-01T00:00:00Z",
            "a.technopedia_id": "52a6154f-70cb-4528-8a1f-1712753f4e4e",
            "a.title": "Ricoh Americas Aficio Multifunction (Networked) MP C306SPF",
            "a.type": "Model",
            "a.url": "http://copyfaxes.com/product/6931/Ricoh-Aficio-MP-C306SPF-Color-MultiFunction-Printer"
       
        }
    ]
}
MATCH (a:ASSET {class: 'Hardware', type: 'Model'}) RETURN a.product, a.general_availability_date, a.end_of_sales_date, a.model LIMIT 10

RESPONSE

{
    "results": [
        {
            "a.end_of_sales_date": null,
            "a.general_availability_date": "2005-09-01T00:00:00Z",
            "a.model": "VGP-WMS50",
            "a.product": "VAIO Wireless Presentation Mouse"
        },
        {
            "a.end_of_sales_date": null,
            "a.general_availability_date": null,
            "a.model": "VSW600",
            "a.product": "W600 Walkman Camera Phone"
        },
        {
            "a.end_of_sales_date": null,
            "a.general_availability_date": null,
            "a.model": "VSW800I",
            "a.product": "W800 Walkman Camera Phone"
        },
        {
            "a.end_of_sales_date": null,
            "a.general_availability_date": null,
            "a.model": "P-334WH",
            "a.product": "802.11g Wireless Firewall Router"
        },
        {
            "a.end_of_sales_date": null,
            "a.general_availability_date": "2005-11-08T00:00:00Z",
            "a.model": "P-320W",
            "a.product": "802.11g Wireless Firewall Router"
        },
        {
            "a.end_of_sales_date": null,
            "a.general_availability_date": "2004-12-08T00:00:00Z",
            "a.model": "P-334WT",
            "a.product": "802.11g Wireless Firewall Router"
        },
        {
            "a.end_of_sales_date": null,
            "a.general_availability_date": null,
            "a.model": "P-334",
            "a.product": "Broadband Router with Firewall"
        },
        {
            "a.end_of_sales_date": null,
            "a.general_availability_date": null,
            "a.model": "AG-220",
            "a.product": "Dual-band Universal Wireless Network Access"
        },
        {
            "a.end_of_sales_date": null,
            "a.general_availability_date": null,
            "a.model": "AG-120",
            "a.product": "Dual-band Universal Wireless Network Access"
        },
        {
            "a.end_of_sales_date": null,
            "a.general_availability_date": null,
            "a.model": "AG-320",
            "a.product": "Dual-band Universal Wireless Network Access"
        }
    ]
}
MATCH (a:ASSET{type:'Model'}) where a.owner = 'Sun Microsystems' and a.support_obsolete_date < '2011-09-01' and a.support_obsolete_date > '1900-01-02' return a LIMIT 2

RESPONSE

{
    "results": [
        {
            "a.alias": null,
            "a.class": "Hardware",
            "a.clock_rate": null,
            "a.component": null,
            "a.cores": null,
            "a.cpu_sockets": null,
            "a.cpu_url": null,
            "a.create_date": null,
            "a.delete_reason": null,
            "a.desupported_flag": "TRUE",
            "a.discontinued_flag": null,
            "a.edition": null,
            "a.edition_order": null,
            "a.end_of_sales_date": "2/4/2005",
            "a.family": null,
            "a.general_availability_date": "2002-01-01T00:00:00Z",
            "a.general_availability_exception": null,
            "a.is_major": null,
            "a.is_suite": null,
            "a.isa_bit_mode": null,
            "a.label": null,
            "a.last_modified_date": null,
            "a.model": "15K",
            "a.multithreaded": null,
            "a.num_threads": null,
            "a.obsolete_exception": null,
            "a.owner": "Sun Microsystems",
            "a.patch_level": null,
            "a.product": "Fire Server",
            "a.release": null,
            "a.replacement_id": null,
            "a.support_end_of_life_date": null,
            "a.support_end_of_life_exception": null,
            "a.support_obsolete_date": "2010-05-06T00:00:00Z",
            "a.supported_os": null,
            "a.technopedia_id": "0d1dac2f-1128-4c4c-9b26-4c4b594e8760",
            "a.title": "Sun Microsystems Fire Server 15K",
            "a.to_be_deleted_flag": null,
            "a.to_be_deleted_on": null,
            "a.type": "Model",
            "a.url": "http://www.tridentusa.com/service/support/sun/products/sunfire_15k.html",
            "a.version": null,
            "a.version_group": null,
            "a.version_order": null
        },
        {
            "a.alias": null,
            "a.class": "Hardware",
            "a.clock_rate": null,
            "a.component": null,
            "a.cores": null,
            "a.cpu_sockets": null,
            "a.cpu_url": null,
            "a.create_date": null,
            "a.delete_reason": null,
            "a.desupported_flag": "TRUE",
            "a.discontinued_flag": null,
            "a.edition": null,
            "a.edition_order": null,
            "a.end_of_sales_date": "1/26/2005",
            "a.family": null,
            "a.general_availability_date": "2001-10-01T00:00:00Z",
            "a.general_availability_exception": null,
            "a.is_major": null,
            "a.is_suite": null,
            "a.isa_bit_mode": null,
            "a.label": null,
            "a.last_modified_date": null,
            "a.model": "20",
            "a.multithreaded": null,
            "a.num_threads": null,
            "a.obsolete_exception": null,
            "a.owner": "Sun Microsystems",
            "a.patch_level": null,
            "a.product": "Netra Server",
            "a.release": null,
            "a.replacement_id": null,
            "a.support_end_of_life_date": null,
            "a.support_end_of_life_exception": null,
            "a.support_obsolete_date": "2010-01-26T00:00:00Z",
            "a.supported_os": null,
            "a.technopedia_id": "209f83c6-1c38-4044-b87f-dd7a0e63ff5c",
            "a.title": "Sun Microsystems Netra Server 20",
            "a.to_be_deleted_flag": null,
            "a.to_be_deleted_on": null,
            "a.type": "Model",
            "a.url": "http://web.archive.org/web/20040406141121/www.sun.com/products-n-solutions/hw/networking/netrat/netra20/datasheet.pdf",
            "a.version": null,
            "a.version_group": null,
            "a.version_order": null
        }
    ]
}
MATCH (a:ASSET {class: 'Hardware'}) 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": "2010-03-16T00:00:00Z",
            "a.title": "Silicon Graphics International Origin 400"
        },
        {
            "a.general_availability_date": "2013-10-25T00:00:00Z",
            "a.title": "Lenovo Group ThinkPlus Preferred Pro USB Fingerprint Keyboard 0C52683"
        },
        {
            "a.general_availability_date": "2013-10-25T00:00:00Z",
            "a.title": "Lenovo Group ThinkPlus Preferred Pro USB Fingerprint Keyboard 0C52707"
        },
        {
            "a.general_availability_date": "2012-02-01T00:00:00Z",
            "a.title": "NETGEAR ProSafe 24 Port Gigabit L2 Managed Switch GSM7224P"
        },
        {
            "a.general_availability_date": "2010-12-01T00:00:00Z",
            "a.title": "NETGEAR ProSafe 24 Port Gigabit L2 Managed Switch XSM7224S"
        },
        {
            "a.general_availability_date": "2011-03-28T00:00:00Z",
            "a.title": "IBM Infoprint MFP (Networked) C2075"
        },
        {
            "a.general_availability_date": "2011-08-01T00:00:00Z",
            "a.title": "Hewlett-Packard Company Compaq t5000 Thin Client t5740e"
        },
        {
            "a.general_availability_date": "2011-01-10T00:00:00Z",
            "a.title": "Hewlett-Packard Company Compaq t5000 Thin Client t5550"
        },
        {
            "a.general_availability_date": "2011-01-10T00:00:00Z",
            "a.title": "Hewlett-Packard Company Compaq t5000 Thin Client t5565"
        },
        {
            "a.general_availability_date": "2011-01-10T00:00:00Z",
            "a.title": "Hewlett-Packard Company Compaq t5000 Thin Client t5570"
        }
    ]
}
MATCH (a:ASSET) where a.end_of_sales_date CONTAINS '2005' return  a.model, a.owner, a.end_of_sales_date LIMIT 10

RESPONSE

{
    "results": [
        {
            "a.end_of_sales_date": "8/30/2005",
            "a.model": "420-24T",
            "a.owner": "Nortel Networks"
        },
        {
            "a.end_of_sales_date": "9/30/2005",
            "a.model": "8100",
            "a.owner": "Nortel Networks"
        },
        {
            "a.end_of_sales_date": "7/29/2005",
            "a.model": "1700",
            "a.owner": "Nortel Networks"
        },
        {
            "a.end_of_sales_date": "8/2005",
            "a.model": "2500",
            "a.owner": "Sun Microsystems"
        },
        {
            "a.end_of_sales_date": "8/2005",
            "a.model": "1500",
            "a.owner": "Sun Microsystems"
        },
        {
            "a.end_of_sales_date": "2/2005",
            "a.model": "12K",
            "a.owner": "Sun Microsystems"
        },
        {
            "a.end_of_sales_date": "2/4/2005",
            "a.model": "15K",
            "a.owner": "Sun Microsystems"
        },
        {
            "a.end_of_sales_date": "1/2005",
            "a.model": "280R",
            "a.owner": "Sun Microsystems"
        },
        {
            "a.end_of_sales_date": "6/2005",
            "a.model": "4800",
            "a.owner": "Sun Microsystems"
        },
        {
            "a.end_of_sales_date": "7/2005",
            "a.model": "V20z",
            "a.owner": "Sun Microsystems"
        }
    ]
}
MATCH (a:ASSET) where a.end_of_sales_date = "7/29/2005" RETURN a.model, a.owner, a.end_of_sales_date LIMIT 2

{
    "results": [
        {
            "a.end_of_sales_date": "7/29/2005",
            "a.model": "1700",
            "a.owner": "Nortel Networks"
        },
        {
            "a.end_of_sales_date": "7/29/2005",
            "a.model": "1700",
            "a.owner": "Avaya"
        }
    ]
}

📘

NOTE

The examples that are used on this page are for demonstration purposes only.

Updated about a year ago

Hardware 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.