Business App Hardware EOL / EOS Impact

This query also utilizes the Compute DBB to gather information on all BusinessApp Impacting Devices that are going to hit hardware EOL/EOS.

Use this if you need to analyze any of the changes needed when that EOL/EOS date approaches.

You can easily shift the window or focus on either EOL/EOS by editing the included WHERE filter clause.

TIP: Additional information can easily be pulled in from the compute dbb as well. Please review the data dictionary with Device42 to see what information is available.

Click to expand the code block

SELECT
    ba_comp.device_fk               AS eol_device_fk
    ,compute.device_serial          AS eol_device_serial
    ,ba_comp.impacted_object        AS impacted_device_name
    ,ba_comp.business_app_name      AS impacted_businessapp
    ,ba_comp.businessapplication_fk
    ,ba_comp.impact_reason
    ,ba_comp.relationship_type
    ,ba_comp.component_type
    ,compute.manufacturer
    ,compute.hardware_model
    ,compute.building_name 
    ,compute.room_name
    ,compute.rack_name
    ,compute.hdw_end_of_life
    ,compute.hdw_end_of_support
FROM view_dbb_adm_businessapp_composition_v2 ba_comp
JOIN view_dbb_compute_v2 compute
    ON compute.device_fk = ba_comp.device_fk 
WHERE
    compute.hdw_end_of_life < current_date - 90
    OR compute.hdw_end_of_support < current_date - 90
ORDER BY
    compute.hdw_end_of_life
    ,compute.hdw_end_of_support
    ,ba_comp.impacted_object;