-
-
Save dandcp/ea42a7181fe42f3b415c67187233495f to your computer and use it in GitHub Desktop.
Timeline Vega
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "$schema": "https://vega.github.io/schema/vega/v5.json", | |
| "padding": 5, | |
| "config": { | |
| "background": "#f5f5f5", | |
| "range": { | |
| "category": { | |
| "scheme": "elastic" | |
| } | |
| }, | |
| "arc": { | |
| "fill": "#54B399" | |
| }, | |
| "area": { | |
| "fill": "#54B399" | |
| }, | |
| "line": { | |
| "stroke": "#54B399" | |
| }, | |
| "path": { | |
| "stroke": "#54B399" | |
| }, | |
| "rect": { | |
| "fill": "#54B399" | |
| }, | |
| "rule": { | |
| "stroke": "#54B399" | |
| }, | |
| "shape": { | |
| "stroke": "#54B399" | |
| }, | |
| "symbol": { | |
| "fill": "#54B399" | |
| }, | |
| "trail": { | |
| "fill": "#54B399" | |
| }, | |
| "title": { | |
| "color": "#343741" | |
| }, | |
| "style": { | |
| "guide-label": { | |
| "fill": "#69707d" | |
| }, | |
| "guide-title": { | |
| "fill": "#343741" | |
| }, | |
| "group-title": { | |
| "fill": "#343741" | |
| }, | |
| "group-subtitle": { | |
| "fill": "#343741" | |
| } | |
| }, | |
| "axis": { | |
| "tickColor": "#eef0f3", | |
| "domainColor": "#eef0f3", | |
| "gridColor": "#eef0f3" | |
| } | |
| }, | |
| "data": [ | |
| { | |
| "name": "source", | |
| "format": { | |
| "property": "hits.hits" | |
| }, | |
| "transform": [ | |
| { | |
| "type": "filter", | |
| "expr": "datum._source['it_debt_applies'] != null &&datum._source['it_debt_end_extended_support'] != null &&datum._source['it_debt_end_standard_support_date'] != null " | |
| }, | |
| { | |
| "type": "project", | |
| "fields": [ | |
| "_source.name", | |
| "_source['it_debt_applies']", | |
| "_source['it_debt_asset_class']", | |
| "_source['it_debt_comments']", | |
| "_source['it_debt_cost_of_no_action']", | |
| "_source['it_debt_current_version']", | |
| "_source['it_debt_end_extended_support']", | |
| "_source['it_debt_end_standard_support_date']", | |
| "_source['it_debt_existing_support_level']", | |
| "_source['it_debt_latest_version']", | |
| "_source['it_debt_number_of_devices']", | |
| "_source['it_debt_version_gap']" | |
| ], | |
| "as": [ | |
| "Name", | |
| "Applies", | |
| "Asset_Class", | |
| "Comments", | |
| "Cost_Of_No_Action", | |
| "Current_Version", | |
| "End_Extended_Support", | |
| "End_Standard_Support_Date", | |
| "Existing_Support_Level", | |
| "Latest_Version", | |
| "Number_Of_Devices", | |
| "Version_Gap" | |
| ] | |
| } | |
| ], | |
| "url": { | |
| "index": "test_XYZ_custom_itdebt", | |
| "body": { | |
| "size": 10000, | |
| "query": { | |
| "bool": { | |
| "must": [], | |
| "filter": [ | |
| { | |
| "match_all": {} | |
| }, | |
| { | |
| "match_phrase": { | |
| "it_debt_applies.name.keyword": "Yes" | |
| } | |
| }, | |
| { | |
| "exists": { | |
| "field": "it_debt_end_extended_support" | |
| } | |
| } | |
| ], | |
| "should": [], | |
| "must_not": [] | |
| } | |
| } | |
| } | |
| }, | |
| "values": { | |
| "took": 2, | |
| "timed_out": false, | |
| "_shards": { | |
| "total": 1, | |
| "successful": 1, | |
| "skipped": 0, | |
| "failed": 0 | |
| }, | |
| "hits": { | |
| "total": 10, | |
| "max_score": 0, | |
| "hits": [ | |
| { | |
| "_index": "test_XYZ_custom_itdebt", | |
| "_type": "_doc", | |
| "_id": "F5WqXXoBQW0aKLd6CkhE", | |
| "_score": 0, | |
| "_source": { | |
| "it_debt_asset_class": { | |
| "name": "Server OS", | |
| "value": 1 | |
| }, | |
| "application_type": { | |
| "name": "TBD", | |
| "value": 4 | |
| }, | |
| "node_technology_service.name": [ | |
| "Endpoints" | |
| ], | |
| "technology_service.name": [ | |
| "Endpoints" | |
| ], | |
| "technology_function.name": [ | |
| "Server OS" | |
| ], | |
| "element_type": "ArchiMate:TechnologySystemSoftware", | |
| "it_debt_number_of_devices": 0, | |
| "it_debt_version_gap": { | |
| "name": "Major", | |
| "value": 4 | |
| }, | |
| "systemsoftware_aggby_compositelocation.name": [], | |
| "technical_poc": "", | |
| "contract_end_date": null, | |
| "disposition_plan": "", | |
| "model_name": null, | |
| "portfolio": { | |
| "name": "IT", | |
| "value": 14 | |
| }, | |
| "node_aggby_compositelocation.name": [], | |
| "vendor": "Microsoft", | |
| "it_debt_applies": { | |
| "name": "Yes", | |
| "value": 2 | |
| }, | |
| "bv_criticality": { | |
| "name": "Tier 4", | |
| "value": 5 | |
| }, | |
| "it_debt_cost_of_no_action": 0, | |
| "functional_poc": "", | |
| "browser_compatibility_comments": "", | |
| "end_of_life": null, | |
| "local_id": "bb80169e-f2b5-e811-89a3-d481d7d21e1b", | |
| "node_technology_function.name": [ | |
| "Server OS" | |
| ], | |
| "parent_or_child": { | |
| "name": "Standalone", | |
| "value": 3 | |
| }, | |
| "it_debt_current_version": "2008", | |
| "it_debt_latest_version": "2022", | |
| "it_org": { | |
| "name": "TBD", | |
| "value": 11 | |
| }, | |
| "business_poc": "", | |
| "url": "", | |
| "it_debt_comments": "", | |
| "disposition": { | |
| "name": "TBD", | |
| "value": 7 | |
| }, | |
| "user_count": 0, | |
| "parent_id": "c003045c-d8b5-e811-89a3-d481d7d21e1b", | |
| "name": "Microsoft Windows Server 2008", | |
| "current_status": { | |
| "name": "Run and Mantain", | |
| "value": 2 | |
| }, | |
| "it_debt_end_extended_support": "2020-01-14", | |
| "it_debt_end_standard_support_date": "2018-01-14", | |
| "it_debt_existing_support_level": { | |
| "name": "Supported", | |
| "value": 1 | |
| }, | |
| "sub_portfolio": "Endpoints" | |
| } | |
| }, | |
| { | |
| "_index": "test_XYZ_custom_itdebt", | |
| "_type": "_doc", | |
| "_id": "FpWqXXoBQW0aKLd6CkhE", | |
| "_score": 0, | |
| "_source": { | |
| "it_debt_asset_class": { | |
| "name": "Server OS", | |
| "value": 1 | |
| }, | |
| "application_type": { | |
| "name": "TBD", | |
| "value": 4 | |
| }, | |
| "node_technology_service.name": [ | |
| "Endpoints" | |
| ], | |
| "technology_service.name": [ | |
| "Endpoints" | |
| ], | |
| "technology_function.name": [ | |
| "Server OS" | |
| ], | |
| "element_type": "ArchiMate:TechnologySystemSoftware", | |
| "it_debt_number_of_devices": 0, | |
| "it_debt_version_gap": { | |
| "name": "Moderate", | |
| "value": 3 | |
| }, | |
| "systemsoftware_aggby_compositelocation.name": [], | |
| "technical_poc": "", | |
| "contract_end_date": null, | |
| "disposition_plan": "", | |
| "model_name": null, | |
| "portfolio": { | |
| "name": "IT", | |
| "value": 14 | |
| }, | |
| "node_aggby_compositelocation.name": [], | |
| "vendor": "Microsoft", | |
| "it_debt_applies": { | |
| "name": "Yes", | |
| "value": 2 | |
| }, | |
| "bv_criticality": { | |
| "name": "Tier 4", | |
| "value": 5 | |
| }, | |
| "it_debt_cost_of_no_action": 0, | |
| "functional_poc": "", | |
| "browser_compatibility_comments": "", | |
| "end_of_life": null, | |
| "local_id": "bd80169e-f2b5-e811-89a3-d481d7d21e1b", | |
| "node_technology_function.name": [ | |
| "Server OS" | |
| ], | |
| "parent_or_child": { | |
| "name": "Standalone", | |
| "value": 3 | |
| }, | |
| "it_debt_current_version": "2016", | |
| "it_debt_latest_version": "2022", | |
| "it_org": { | |
| "name": "TBD", | |
| "value": 11 | |
| }, | |
| "business_poc": "", | |
| "url": "", | |
| "it_debt_comments": "", | |
| "disposition": { | |
| "name": "TBD", | |
| "value": 7 | |
| }, | |
| "user_count": 0, | |
| "parent_id": "c003045c-d8b5-e811-89a3-d481d7d21e1b", | |
| "name": "Microsoft Windows Server 2016", | |
| "current_status": { | |
| "name": "Run and Mantain", | |
| "value": 2 | |
| }, | |
| "it_debt_end_extended_support": "2027-01-12", | |
| "it_debt_end_standard_support_date": "2022-01-11", | |
| "it_debt_existing_support_level": { | |
| "name": "Supported", | |
| "value": 1 | |
| }, | |
| "sub_portfolio": "Endpoints" | |
| } | |
| }, | |
| { | |
| "_index": "test_XYZ_custom_itdebt", | |
| "_type": "_doc", | |
| "_id": "HZWqXXoBQW0aKLd6CkhE", | |
| "_score": 0, | |
| "_source": { | |
| "it_debt_asset_class": { | |
| "name": "Server OS", | |
| "value": 1 | |
| }, | |
| "application_type": { | |
| "name": "TBD", | |
| "value": 4 | |
| }, | |
| "node_technology_service.name": [ | |
| "Endpoints" | |
| ], | |
| "technology_service.name": [ | |
| "Endpoints" | |
| ], | |
| "technology_function.name": [ | |
| "Server OS" | |
| ], | |
| "element_type": "ArchiMate:TechnologySystemSoftware", | |
| "it_debt_number_of_devices": 0, | |
| "it_debt_version_gap": { | |
| "name": "Moderate", | |
| "value": 3 | |
| }, | |
| "systemsoftware_aggby_compositelocation.name": [], | |
| "technical_poc": "", | |
| "contract_end_date": null, | |
| "disposition_plan": "", | |
| "model_name": null, | |
| "portfolio": { | |
| "name": "IT", | |
| "value": 14 | |
| }, | |
| "node_aggby_compositelocation.name": [], | |
| "vendor": "Microsoft", | |
| "it_debt_applies": { | |
| "name": "Yes", | |
| "value": 2 | |
| }, | |
| "bv_criticality": { | |
| "name": "Tier 4", | |
| "value": 5 | |
| }, | |
| "it_debt_cost_of_no_action": 0, | |
| "functional_poc": "", | |
| "browser_compatibility_comments": "", | |
| "end_of_life": null, | |
| "local_id": "bc80169e-f2b5-e811-89a3-d481d7d21e1b", | |
| "node_technology_function.name": [ | |
| "Server OS" | |
| ], | |
| "parent_or_child": { | |
| "name": "Standalone", | |
| "value": 3 | |
| }, | |
| "it_debt_current_version": "2012", | |
| "it_debt_latest_version": "2022", | |
| "it_org": { | |
| "name": "TBD", | |
| "value": 11 | |
| }, | |
| "business_poc": "", | |
| "url": "", | |
| "it_debt_comments": "", | |
| "disposition": { | |
| "name": "TBD", | |
| "value": 7 | |
| }, | |
| "user_count": 0, | |
| "parent_id": "c003045c-d8b5-e811-89a3-d481d7d21e1b", | |
| "name": "Microsoft Windows Server 2012", | |
| "current_status": { | |
| "name": "Run and Mantain", | |
| "value": 2 | |
| }, | |
| "it_debt_end_extended_support": "2023-10-10", | |
| "it_debt_end_standard_support_date": "2018-10-09", | |
| "it_debt_existing_support_level": { | |
| "name": "Extended Support", | |
| "value": 2 | |
| }, | |
| "sub_portfolio": "Endpoints" | |
| } | |
| }, | |
| { | |
| "_index": "test_XYZ_custom_itdebt", | |
| "_type": "_doc", | |
| "_id": "W5WqXXoBQW0aKLd6CklE", | |
| "_score": 0, | |
| "_source": { | |
| "it_debt_asset_class": { | |
| "name": "Database", | |
| "value": 3 | |
| }, | |
| "application_type": { | |
| "name": "TBD", | |
| "value": 4 | |
| }, | |
| "node_technology_service.name": [], | |
| "technology_service.name": [], | |
| "technology_function.name": [], | |
| "element_type": "ArchiMate:TechnologySystemSoftware", | |
| "it_debt_number_of_devices": 0, | |
| "it_debt_version_gap": { | |
| "name": "Moderate", | |
| "value": 3 | |
| }, | |
| "systemsoftware_aggby_compositelocation.name": [], | |
| "technical_poc": "", | |
| "contract_end_date": null, | |
| "disposition_plan": "", | |
| "model_name": null, | |
| "portfolio": { | |
| "name": "TBD", | |
| "value": 18 | |
| }, | |
| "node_aggby_compositelocation.name": [], | |
| "vendor": "Microsoft", | |
| "it_debt_applies": { | |
| "name": "Yes", | |
| "value": 2 | |
| }, | |
| "it_debt_cost_of_no_action": 0, | |
| "functional_poc": "", | |
| "browser_compatibility_comments": "", | |
| "end_of_life": null, | |
| "local_id": "96454938-e9ca-eb11-b347-f8e4e37112b2", | |
| "node_technology_function.name": [], | |
| "parent_or_child": { | |
| "name": "Standalone", | |
| "value": 3 | |
| }, | |
| "it_debt_current_version": "2016", | |
| "it_debt_latest_version": "2019", | |
| "it_org": { | |
| "name": "TBD", | |
| "value": 11 | |
| }, | |
| "business_poc": "", | |
| "url": "", | |
| "it_debt_comments": "", | |
| "disposition": { | |
| "name": "TBD", | |
| "value": 7 | |
| }, | |
| "user_count": 0, | |
| "parent_id": "b383af1c-11b1-e811-89a3-d481d7d21e1b", | |
| "name": "Microsoft SQL Server 2016", | |
| "current_status": { | |
| "name": "Run and Mantain", | |
| "value": 2 | |
| }, | |
| "it_debt_end_extended_support": "2026-07-14", | |
| "it_debt_end_standard_support_date": "2021-07-13", | |
| "it_debt_existing_support_level": { | |
| "name": "Extended Support", | |
| "value": 2 | |
| }, | |
| "sub_portfolio": "" | |
| } | |
| }, | |
| { | |
| "_index": "test_XYZ_custom_itdebt", | |
| "_type": "_doc", | |
| "_id": "WZWqXXoBQW0aKLd6CklE", | |
| "_score": 0, | |
| "_source": { | |
| "it_debt_asset_class": { | |
| "name": "Database", | |
| "value": 3 | |
| }, | |
| "application_type": { | |
| "name": "TBD", | |
| "value": 4 | |
| }, | |
| "node_technology_service.name": [], | |
| "technology_service.name": [], | |
| "technology_function.name": [], | |
| "element_type": "ArchiMate:TechnologySystemSoftware", | |
| "it_debt_number_of_devices": 0, | |
| "it_debt_version_gap": { | |
| "name": "None", | |
| "value": 1 | |
| }, | |
| "systemsoftware_aggby_compositelocation.name": [], | |
| "technical_poc": "", | |
| "contract_end_date": null, | |
| "disposition_plan": "", | |
| "model_name": null, | |
| "portfolio": { | |
| "name": "TBD", | |
| "value": 18 | |
| }, | |
| "node_aggby_compositelocation.name": [], | |
| "vendor": "Microsoft", | |
| "it_debt_applies": { | |
| "name": "Yes", | |
| "value": 2 | |
| }, | |
| "it_debt_cost_of_no_action": 0, | |
| "functional_poc": "", | |
| "browser_compatibility_comments": "", | |
| "end_of_life": null, | |
| "local_id": "98454938-e9ca-eb11-b347-f8e4e37112b2", | |
| "node_technology_function.name": [], | |
| "parent_or_child": { | |
| "name": "Standalone", | |
| "value": 3 | |
| }, | |
| "it_debt_current_version": "2017", | |
| "it_debt_latest_version": "2019", | |
| "it_org": { | |
| "name": "TBD", | |
| "value": 11 | |
| }, | |
| "business_poc": "", | |
| "url": "", | |
| "it_debt_comments": "", | |
| "disposition": { | |
| "name": "TBD", | |
| "value": 7 | |
| }, | |
| "user_count": 0, | |
| "parent_id": "b383af1c-11b1-e811-89a3-d481d7d21e1b", | |
| "name": "Microsoft SQL Server 2017", | |
| "current_status": { | |
| "name": "Run and Mantain", | |
| "value": 2 | |
| }, | |
| "it_debt_end_extended_support": "2027-10-12", | |
| "it_debt_end_standard_support_date": "2022-10-11", | |
| "it_debt_existing_support_level": { | |
| "name": "Supported", | |
| "value": 1 | |
| }, | |
| "sub_portfolio": "" | |
| } | |
| }, | |
| { | |
| "_index": "test_XYZ_custom_itdebt", | |
| "_type": "_doc", | |
| "_id": "WpWqXXoBQW0aKLd6CklE", | |
| "_score": 0, | |
| "_source": { | |
| "it_debt_asset_class": { | |
| "name": "Database", | |
| "value": 3 | |
| }, | |
| "application_type": { | |
| "name": "TBD", | |
| "value": 4 | |
| }, | |
| "node_technology_service.name": [], | |
| "technology_service.name": [], | |
| "technology_function.name": [], | |
| "element_type": "ArchiMate:TechnologySystemSoftware", | |
| "it_debt_number_of_devices": 0, | |
| "it_debt_version_gap": { | |
| "name": "Moderate", | |
| "value": 3 | |
| }, | |
| "systemsoftware_aggby_compositelocation.name": [], | |
| "technical_poc": "", | |
| "contract_end_date": null, | |
| "disposition_plan": "", | |
| "model_name": null, | |
| "portfolio": { | |
| "name": "TBD", | |
| "value": 18 | |
| }, | |
| "node_aggby_compositelocation.name": [], | |
| "vendor": "Microsoft", | |
| "it_debt_applies": { | |
| "name": "Yes", | |
| "value": 2 | |
| }, | |
| "it_debt_cost_of_no_action": 0, | |
| "functional_poc": "", | |
| "browser_compatibility_comments": "", | |
| "end_of_life": null, | |
| "local_id": "94454938-e9ca-eb11-b347-f8e4e37112b2", | |
| "node_technology_function.name": [], | |
| "parent_or_child": { | |
| "name": "Standalone", | |
| "value": 3 | |
| }, | |
| "it_debt_current_version": "2014", | |
| "it_debt_latest_version": "2019", | |
| "it_org": { | |
| "name": "TBD", | |
| "value": 11 | |
| }, | |
| "business_poc": "", | |
| "url": "", | |
| "it_debt_comments": "", | |
| "disposition": { | |
| "name": "TBD", | |
| "value": 7 | |
| }, | |
| "user_count": 0, | |
| "parent_id": "b383af1c-11b1-e811-89a3-d481d7d21e1b", | |
| "name": "Microsoft SQL Server 2014", | |
| "current_status": { | |
| "name": "Run and Mantain", | |
| "value": 2 | |
| }, | |
| "it_debt_end_extended_support": "2024-07-09", | |
| "it_debt_end_standard_support_date": "2019-07-29", | |
| "it_debt_existing_support_level": { | |
| "name": "Extended Support", | |
| "value": 2 | |
| }, | |
| "sub_portfolio": "" | |
| } | |
| }, | |
| { | |
| "_index": "test_XYZ_custom_itdebt", | |
| "_type": "_doc", | |
| "_id": "XJWqXXoBQW0aKLd6CklE", | |
| "_score": 0, | |
| "_source": { | |
| "it_debt_asset_class": { | |
| "name": "Various", | |
| "value": 5 | |
| }, | |
| "local_id": "6318cd41-dfca-eb11-b347-f8e4e37112b2", | |
| "it_debt_current_version": "", | |
| "element_type": "ArchiMate:IMGap", | |
| "it_debt_number_of_devices": 0, | |
| "it_debt_latest_version": "", | |
| "it_debt_version_gap": { | |
| "name": "None", | |
| "value": 1 | |
| }, | |
| "it_debt_comments": "Deadline to replace SP 2010 workflows with Power Automate is Dec. 31, 2021. No further exceptions. \n\n All other Microsoft customers had until 3/31/21 to complete this effort. XYZ was allowed to extend until the end of this year.", | |
| "model_name": null, | |
| "parent_id": "6418cd41-dfca-eb11-b347-f8e4e37112b2", | |
| "it_debt_applies": { | |
| "name": "Yes", | |
| "value": 2 | |
| }, | |
| "name": "Migrate from SP 2010 to Power Automate", | |
| "it_debt_end_extended_support": "2021-12-31", | |
| "it_debt_end_standard_support_date": "2021-12-31", | |
| "it_debt_cost_of_no_action": 0, | |
| "it_debt_existing_support_level": { | |
| "name": "Supported", | |
| "value": 1 | |
| }, | |
| "browser_compatibility_comments": "Deadline to replace SP 2010 workflows with Power Automate is Dec. 31, 2021. No further exceptions. \n\n All other Microsoft customers had until 3/31/21 to complete this effort. XYZ was allowed to extend until the end of this year." | |
| } | |
| }, | |
| { | |
| "_index": "test_XYZ_custom_itdebt", | |
| "_type": "_doc", | |
| "_id": "XZWqXXoBQW0aKLd6CklE", | |
| "_score": 0, | |
| "_source": { | |
| "it_debt_asset_class": { | |
| "name": "Database", | |
| "value": 3 | |
| }, | |
| "application_type": { | |
| "name": "TBD", | |
| "value": 4 | |
| }, | |
| "node_technology_service.name": [], | |
| "technology_service.name": [], | |
| "technology_function.name": [], | |
| "element_type": "ArchiMate:TechnologySystemSoftware", | |
| "it_debt_number_of_devices": 0, | |
| "it_debt_version_gap": { | |
| "name": "None", | |
| "value": 1 | |
| }, | |
| "systemsoftware_aggby_compositelocation.name": [], | |
| "technical_poc": "", | |
| "contract_end_date": null, | |
| "disposition_plan": "", | |
| "model_name": null, | |
| "portfolio": { | |
| "name": "TBD", | |
| "value": 18 | |
| }, | |
| "node_aggby_compositelocation.name": [], | |
| "vendor": "Microsoft", | |
| "it_debt_applies": { | |
| "name": "Yes", | |
| "value": 2 | |
| }, | |
| "it_debt_cost_of_no_action": 0, | |
| "functional_poc": "", | |
| "browser_compatibility_comments": "", | |
| "end_of_life": null, | |
| "local_id": "9a454938-e9ca-eb11-b347-f8e4e37112b2", | |
| "node_technology_function.name": [], | |
| "parent_or_child": { | |
| "name": "Standalone", | |
| "value": 3 | |
| }, | |
| "it_debt_current_version": "2019", | |
| "it_debt_latest_version": "2019", | |
| "it_org": { | |
| "name": "TBD", | |
| "value": 11 | |
| }, | |
| "business_poc": "", | |
| "url": "", | |
| "it_debt_comments": "", | |
| "disposition": { | |
| "name": "TBD", | |
| "value": 7 | |
| }, | |
| "user_count": 0, | |
| "parent_id": "b383af1c-11b1-e811-89a3-d481d7d21e1b", | |
| "name": "Microsoft SQL Server 2019", | |
| "current_status": { | |
| "name": "Run and Mantain", | |
| "value": 2 | |
| }, | |
| "it_debt_end_extended_support": "2030-01-08", | |
| "it_debt_end_standard_support_date": "2025-01-07", | |
| "it_debt_existing_support_level": { | |
| "name": "Supported", | |
| "value": 1 | |
| }, | |
| "sub_portfolio": "" | |
| } | |
| }, | |
| { | |
| "_index": "test_XYZ_custom_itdebt", | |
| "_type": "_doc", | |
| "_id": "XpWqXXoBQW0aKLd6CklE", | |
| "_score": 0, | |
| "_source": { | |
| "it_debt_asset_class": { | |
| "name": "Database", | |
| "value": 3 | |
| }, | |
| "application_type": { | |
| "name": "TBD", | |
| "value": 4 | |
| }, | |
| "node_technology_service.name": [], | |
| "technology_service.name": [], | |
| "technology_function.name": [], | |
| "element_type": "ArchiMate:TechnologySystemSoftware", | |
| "it_debt_number_of_devices": 0, | |
| "it_debt_version_gap": { | |
| "name": "Major", | |
| "value": 4 | |
| }, | |
| "systemsoftware_aggby_compositelocation.name": [], | |
| "technical_poc": "", | |
| "contract_end_date": null, | |
| "disposition_plan": "", | |
| "model_name": null, | |
| "portfolio": { | |
| "name": "TBD", | |
| "value": 18 | |
| }, | |
| "node_aggby_compositelocation.name": [], | |
| "vendor": "Microsoft", | |
| "it_debt_applies": { | |
| "name": "Yes", | |
| "value": 2 | |
| }, | |
| "it_debt_cost_of_no_action": 0, | |
| "functional_poc": "", | |
| "browser_compatibility_comments": "", | |
| "end_of_life": null, | |
| "local_id": "91454938-e9ca-eb11-b347-f8e4e37112b2", | |
| "node_technology_function.name": [], | |
| "parent_or_child": { | |
| "name": "Standalone", | |
| "value": 3 | |
| }, | |
| "it_debt_current_version": "2012", | |
| "it_debt_latest_version": "2019", | |
| "it_org": { | |
| "name": "TBD", | |
| "value": 11 | |
| }, | |
| "business_poc": "", | |
| "url": "", | |
| "it_debt_comments": "", | |
| "disposition": { | |
| "name": "TBD", | |
| "value": 7 | |
| }, | |
| "user_count": 0, | |
| "parent_id": "b383af1c-11b1-e811-89a3-d481d7d21e1b", | |
| "name": "Microsoft SQL Server 2012", | |
| "current_status": { | |
| "name": "Run and Mantain", | |
| "value": 2 | |
| }, | |
| "it_debt_end_extended_support": "2022-07-12", | |
| "it_debt_end_standard_support_date": "2017-07-11", | |
| "it_debt_existing_support_level": { | |
| "name": "Extended Support", | |
| "value": 2 | |
| }, | |
| "sub_portfolio": "" | |
| } | |
| }, | |
| { | |
| "_index": "test_XYZ_custom_itdebt", | |
| "_type": "_doc", | |
| "_id": "EJWqXXoBQW0aKLd6D0vA", | |
| "_score": 0, | |
| "_source": { | |
| "it_debt_asset_class": { | |
| "name": "Client OS", | |
| "value": 2 | |
| }, | |
| "application_type": { | |
| "name": "TBD", | |
| "value": 4 | |
| }, | |
| "node_technology_service.name": [ | |
| "Endpoints" | |
| ], | |
| "technology_service.name": [ | |
| "Endpoints" | |
| ], | |
| "technology_function.name": [ | |
| "Desktop OS" | |
| ], | |
| "element_type": "ArchiMate:TechnologySystemSoftware", | |
| "it_debt_number_of_devices": 0, | |
| "it_debt_version_gap": { | |
| "name": "Moderate", | |
| "value": 3 | |
| }, | |
| "systemsoftware_aggby_compositelocation.name": [], | |
| "technical_poc": "", | |
| "contract_end_date": null, | |
| "disposition_plan": "", | |
| "model_name": null, | |
| "portfolio": { | |
| "name": "IT", | |
| "value": 14 | |
| }, | |
| "node_aggby_compositelocation.name": [], | |
| "vendor": "Microsoft", | |
| "it_debt_applies": { | |
| "name": "Yes", | |
| "value": 2 | |
| }, | |
| "bv_criticality": { | |
| "name": "Tier 4", | |
| "value": 5 | |
| }, | |
| "it_debt_cost_of_no_action": 0, | |
| "functional_poc": "", | |
| "browser_compatibility_comments": "", | |
| "end_of_life": null, | |
| "local_id": "b580169e-f2b5-e811-89a3-d481d7d21e1b", | |
| "node_technology_function.name": [ | |
| "Desktop OS" | |
| ], | |
| "parent_or_child": { | |
| "name": "Standalone", | |
| "value": 3 | |
| }, | |
| "it_debt_current_version": "8", | |
| "it_debt_latest_version": "10", | |
| "it_org": { | |
| "name": "TBD", | |
| "value": 11 | |
| }, | |
| "business_poc": "", | |
| "url": "", | |
| "it_debt_comments": "", | |
| "disposition": { | |
| "name": "TBD", | |
| "value": 7 | |
| }, | |
| "user_count": 0, | |
| "parent_id": "c003045c-d8b5-e811-89a3-d481d7d21e1b", | |
| "name": "Microsoft Windows 8", | |
| "current_status": { | |
| "name": "Run and Mantain", | |
| "value": 2 | |
| }, | |
| "it_debt_end_extended_support": "2023-01-10", | |
| "it_debt_end_standard_support_date": "2018-01-09", | |
| "it_debt_existing_support_level": { | |
| "name": "Extended Support", | |
| "value": 2 | |
| }, | |
| "sub_portfolio": "Endpoints" | |
| } | |
| } | |
| ] | |
| } | |
| } | |
| } | |
| ], | |
| "scales": [ | |
| { | |
| "name": "yscale", | |
| "type": "band", | |
| "range": [ | |
| 0, | |
| { | |
| "signal": "height" | |
| } | |
| ], | |
| "domain": { | |
| "data": "source", | |
| "field": "Name" | |
| } | |
| }, | |
| { | |
| "name": "xscale", | |
| "type": "time", | |
| "range": "width", | |
| "round": true, | |
| "domain": { | |
| "data": "source", | |
| "fields": [ | |
| "End_Standard_Support_Date", | |
| "End_Extended_Support" | |
| ] | |
| } | |
| } | |
| ], | |
| "axes": [ | |
| { | |
| "orient": "bottom", | |
| "scale": "xscale", | |
| "format": "%Y %M" | |
| } | |
| ], | |
| "marks": [ | |
| { | |
| "type": "text”, | |
| "from": { | |
| "data": "source" | |
| }, | |
| "encode": { | |
| "enter": { | |
| "x": { | |
| "scale": "xscale", | |
| "field": "End_Extended_Support" | |
| }, | |
| "y": { | |
| "scale": "yscale", | |
| "field": "Name", | |
| "offset": -3 | |
| }, | |
| "fill": { | |
| "value": "#000" | |
| }, | |
| "text": { | |
| "field": "name" | |
| }, | |
| "fontSize": { | |
| "value": 10 | |
| } | |
| } | |
| } | |
| } | |
| ], | |
| "width": "container", | |
| "height": "container", | |
| "autosize": { | |
| "type": "fit", | |
| "contains": "padding" | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment