Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: Current Year Control
| Current Year   |
|:---------------|
| Yes            |
| No             |


Table: JIRA_Projects
|   jira_proj_dwkey | jira_proj_name                 | jira_proj_category_name   | jira_proj_type_desc   | jira_proj_lead   | jira_proj_key_cd   | product_owner_name   |   source_jira_proj_id | proj_active_indicator   |   created_by_id | created_dt              |   modified_by_id | modified_dt             | active_flg   |
|------------------:|:-------------------------------|:--------------------------|:----------------------|:-----------------|:-------------------|:---------------------|----------------------:|:------------------------|----------------:|:------------------------|-----------------:|:------------------------|:-------------|
|                64 | Windows Infrastructure         |                           | software              | pwilhel          | WI                 |                      |                 11905 | Y                       |  20161222123108 | 2016-12-22 20:31:11.030 |   20180327083217 | 2018-03-27 15:32:24.563 | Y            |
|               142 | Storage Team                   | Infrastructure Services   | software              | csimmon54        | STOR               |                      |                 11906 | Y                       |  20161222123108 | 2016-12-22 20:31:11.030 |   20170823064216 | 2017-08-23 13:42:20.486 | Y            |
|               222 | Infrastructure Unix Operations |                           | software              | vstapon          | INFUOP             |                      |                 13100 | Y                       |  20170419075211 | 2017-04-19 14:52:14.106 |   20171027142218 | 2017-10-27 21:22:23.956 | Y            |
|               317 | Infrastructure AIX Operations  |                           | software              | spadiya1         | INFAOP             |                      |                 15200 | Y                       |  20171113125214 | 2017-11-13 20:52:18.290 |   20180327084211 | 2018-03-27 15:42:16.656 | Y            |
|               426 | Network Attached Storage       |                           | software              | scostan          | NAS                |                      |                 19601 | Y                       |  20180627092207 | 2018-06-27 16:22:10.940 |   20180705115212 | 2018-07-05 18:52:18.653 | Y            |


Table: LastRefresh
| LastRefresh_ServerTime   | LastRefresh_Local       |
|:-------------------------|:------------------------|
| 2018-12-21 09:29:54.453  | 2018-12-21 09:28:48.000 |


Table: ManagerToProject
| Manager   | Project   |
|:----------|:----------|
| Phil      | WI        |
| Kathy     | NAS       |
| Kathy     | STOR      |
| Virgil    | INFAOP    |
| Virgil    | INFUOP    |


Table: PierHighStatuses
| Status_Group   |   Sort_Order |
|:---------------|-------------:|
| To Do          |            5 |
| In Progress    |            7 |
| Closed         |            9 |


Table: PierTickets
| Application   | Assignee_Group      | requested_by   | Created_By      | Config_Item   | Assignee            | Assignee_Group2     | tt_description                                                                                                                                                            | short_description   | status_desc   | priority_description   | resolution_comments                                         | Closed_By       |   SLA |   Duration |   Row |   Task_Number | Task_Created_Date       | Task_Opened_Date        | Task_Closed_Date        |   Duration (hr) | Aged         | grp_sht_description   | Category    | TicketURL                                                               |   PriorityLevel | Project   | Queue Manager   | Queue Display   |   Past_SLA |   SortOrder | status_group   |   YearControl |
|:--------------|:--------------------|:---------------|:----------------|:--------------|:--------------------|:--------------------|:--------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:--------------------|:--------------|:-----------------------|:------------------------------------------------------------|:----------------|------:|-----------:|------:|--------------:|:------------------------|:------------------------|:------------------------|----------------:|:-------------|:----------------------|:------------|:------------------------------------------------------------------------|----------------:|:----------|:----------------|:----------------|-----------:|------------:|:---------------|--------------:|
| PIER          | EIT Inf Ops Support | ocuser         | NTM ServiceUser | PRDASETLX007  | EIT Inf Ops Support | EIT Inf Ops Support | PRDASETLX007::CPU  CPU Utilization exceeds the defined threshold, Metrics in Critical State:                                                                              | Degraded Service    | Closed        | P4                     | PRDASETLX007 reduced average CPU Load Percentage of :  4.5  | NTM ServiceUser | 10080 |          5 |     1 |      16757572 | 2017-07-13 14:46:46.040 | 2017-07-13 14:46:46.040 | 2017-07-13 14:51:06.453 |               1 | Over 30 Days | Performance           | Performance | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=16757572 |               4 | WI        | Phil            | IO Support      |          0 |           6 | Closed         |          2017 |
|               |                     |                |                 |               |                     |                     |  utilization: 100% Metrics in Major State: , FullMonitorName: SiteScope\Shared Services S3\WinBaseLine\prdasetlx007:WinBaseLineProd\prdasetlx007:WinCPUUtil Not Available |                     |               |                        |                                                             |                 |       |            |       |               |                         |                         |                         |                 |              |                       |             |                                                                         |                 |           |                 |                 |            |             |                |               |
| PIER          | EIT Inf Ops Support | ocuser         | NTM ServiceUser | PRDASETLX007  | EIT Inf Ops Support | EIT Inf Ops Support | PRDASETLX007::CPU  CPU Utilization exceeds the defined threshold, Metrics in Critical State:                                                                              | Degraded Service    | Closed        | P4                     | PRDASETLX007 reduced average CPU Load Percentage of :  6.5  | NTM ServiceUser | 10080 |          5 |     1 |      16769653 | 2017-07-14 15:46:53.226 | 2017-07-14 15:46:53.226 | 2017-07-14 15:51:06.643 |               1 | Over 30 Days | Performance           | Performance | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=16769653 |               4 | WI        | Phil            | IO Support      |          0 |           6 | Closed         |          2017 |
|               |                     |                |                 |               |                     |                     |  utilization: 100% Metrics in Major State: , FullMonitorName: SiteScope\Shared Services S3\WinBaseLine\prdasetlx007:WinBaseLineProd\prdasetlx007:WinCPUUtil Not Available |                     |               |                        |                                                             |                 |       |            |       |               |                         |                         |                         |                 |              |                       |             |                                                                         |                 |           |                 |                 |            |             |                |               |
| PIER          | EIT Inf Ops Support | ocuser         | NTM ServiceUser | PRDASETLX007  | EIT Inf Ops Support | EIT Inf Ops Support | PRDASETLX007::CPU  CPU Utilization exceeds the defined threshold, Metrics in Critical State:                                                                              | Degraded Service    | Closed        | P4                     | PRDASETLX007 reduced average CPU Load Percentage of :  5.25 | NTM ServiceUser | 10080 |          5 |     1 |      16777312 | 2017-07-15 10:46:47.336 | 2017-07-15 10:46:47.336 | 2017-07-15 10:51:09.343 |               1 | Over 30 Days | Performance           | Performance | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=16777312 |               4 | WI        | Phil            | IO Support      |          0 |           6 | Closed         |          2017 |
|               |                     |                |                 |               |                     |                     |  utilization: 100% Metrics in Major State: , FullMonitorName: SiteScope\Shared Services S3\WinBaseLine\prdasetlx007:WinBaseLineProd\prdasetlx007:WinCPUUtil Not Available |                     |               |                        |                                                             |                 |       |            |       |               |                         |                         |                         |                 |              |                       |             |                                                                         |                 |           |                 |                 |            |             |                |               |
| PIER          | EIT Inf Ops Support | ocuser         | NTM ServiceUser | PRDASETLX007  | EIT Inf Ops Support | EIT Inf Ops Support | PRDASETLX007::CPU  CPU Utilization exceeds the defined threshold, Metrics in Critical State:                                                                              | Degraded Service    | Closed        | P4                     | PRDASETLX007 reduced average CPU Load Percentage of :  12   | NTM ServiceUser | 10080 |          5 |     1 |      16786165 | 2017-07-16 21:46:46.873 | 2017-07-16 21:46:46.873 | 2017-07-16 21:51:06.470 |               1 | Over 30 Days | Performance           | Performance | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=16786165 |               4 | WI        | Phil            | IO Support      |          0 |           6 | Closed         |          2017 |
|               |                     |                |                 |               |                     |                     |  utilization: 100% Metrics in Major State: , FullMonitorName: SiteScope\Shared Services S3\WinBaseLine\prdasetlx007:WinBaseLineProd\prdasetlx007:WinCPUUtil Not Available |                     |               |                        |                                                             |                 |       |            |       |               |                         |                         |                         |                 |              |                       |             |                                                                         |                 |           |                 |                 |            |             |                |               |
| PIER          | EIT Inf Ops Support | ocuser         | NTM ServiceUser | PRDASETLX007  | EIT Inf Ops Support | EIT Inf Ops Support | PRDASETLX007::CPU  CPU Utilization exceeds the defined threshold, Metrics in Critical State:                                                                              | Degraded Service    | Closed        | P4                     | PRDASETLX007 reduced average CPU Load Percentage of :  7    | NTM ServiceUser | 10080 |          5 |     1 |      16790373 | 2017-07-17 14:46:53.650 | 2017-07-17 14:46:53.650 | 2017-07-17 14:51:06.396 |               1 | Over 30 Days | Performance           | Performance | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=16790373 |               4 | WI        | Phil            | IO Support      |          0 |           6 | Closed         |          2017 |
|               |                     |                |                 |               |                     |                     |  utilization: 100% Metrics in Major State: , FullMonitorName: SiteScope\Shared Services S3\WinBaseLine\prdasetlx007:WinBaseLineProd\prdasetlx007:WinCPUUtil Not Available |                     |               |                        |                                                             |                 |       |            |       |               |                         |                         |                         |                 |              |                       |             |                                                                         |                 |           |                 |                 |            |             |                |               |
| PIER          | EIT Inf Ops Support | ocuser         | NTM ServiceUser | PRDASETLX007  | EIT Inf Ops Support | EIT Inf Ops Support | PRDASETLX007::CPU  CPU Utilization exceeds the defined threshold, Metrics in Critical State:                                                                              | Degraded Service    | Closed        | P4                     | PRDASETLX007 reduced average CPU Load Percentage of :  1.75 | NTM ServiceUser | 10080 |          5 |     1 |      16801521 | 2017-07-18 12:46:04.990 | 2017-07-18 12:46:04.990 | 2017-07-18 12:51:17.633 |               1 | Over 30 Days | Performance           | Performance | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=16801521 |               4 | WI        | Phil            | IO Support      |          0 |           6 | Closed         |          2017 |
|               |                     |                |                 |               |                     |                     |  utilization: 100% Metrics in Major State: , FullMonitorName: SiteScope\Shared Services S3\WinBaseLine\prdasetlx007:WinBaseLineProd\prdasetlx007:WinCPUUtil Not Available |                     |               |                        |                                                             |                 |       |            |       |               |                         |                         |                         |                 |              |                       |             |                                                                         |                 |           |                 |                 |            |             |                |               |
| PIER          | EIT Inf Ops Support | ocuser         | NTM ServiceUser | PRDASETLX007  | EIT Inf Ops Support | EIT Inf Ops Support | PRDASETLX007::CPU  CPU Utilization exceeds the defined threshold, Metrics in Critical State:                                                                              | Degraded Service    | Closed        | P4                     | PRDASETLX007 reduced average CPU Load Percentage of :  8    | NTM ServiceUser | 10080 |          5 |     1 |      16808765 | 2017-07-18 22:46:52.803 | 2017-07-18 22:46:52.803 | 2017-07-18 22:51:10.133 |               1 | Over 30 Days | Performance           | Performance | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=16808765 |               4 | WI        | Phil            | IO Support      |          0 |           6 | Closed         |          2017 |
|               |                     |                |                 |               |                     |                     |  utilization: 100% Metrics in Major State: , FullMonitorName: SiteScope\Shared Services S3\WinBaseLine\prdasetlx007:WinBaseLineProd\prdasetlx007:WinCPUUtil Not Available |                     |               |                        |                                                             |                 |       |            |       |               |                         |                         |                         |                 |              |                       |             |                                                                         |                 |           |                 |                 |            |             |                |               |
| PIER          | EIT Inf Ops Support | ocuser         | NTM ServiceUser | PRDASETLX007  | EIT Inf Ops Support | EIT Inf Ops Support | PRDASETLX007::CPU  CPU Utilization exceeds the defined threshold, Metrics in Critical State:                                                                              | Degraded Service    | Closed        | P4                     | PRDASETLX007 reduced average CPU Load Percentage of :  2.75 | NTM ServiceUser | 10080 |          5 |     1 |      16810245 | 2017-07-19 01:46:50.300 | 2017-07-19 01:46:50.300 | 2017-07-19 01:51:06.620 |               1 | Over 30 Days | Performance           | Performance | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=16810245 |               4 | WI        | Phil            | IO Support      |          0 |           6 | Closed         |          2017 |
|               |                     |                |                 |               |                     |                     |  utilization: 100% Metrics in Major State: , FullMonitorName: SiteScope\Shared Services S3\WinBaseLine\prdasetlx007:WinBaseLineProd\prdasetlx007:WinCPUUtil Not Available |                     |               |                        |                                                             |                 |       |            |       |               |                         |                         |                         |                 |              |                       |             |                                                                         |                 |           |                 |                 |            |             |                |               |
| PIER          | EIT Inf Ops Support | ocuser         | NTM ServiceUser | PRDASETLX007  | EIT Inf Ops Support | EIT Inf Ops Support | PRDASETLX007::CPU  CPU Utilization exceeds the defined threshold, Metrics in Critical State:                                                                              | Degraded Service    | Closed        | P4                     | PRDASETLX007 reduced average CPU Load Percentage of :  6.75 | NTM ServiceUser | 10080 |          5 |     1 |      16823089 | 2017-07-20 11:46:50.896 | 2017-07-20 11:46:50.896 | 2017-07-20 11:51:33.890 |               1 | Over 30 Days | Performance           | Performance | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=16823089 |               4 | WI        | Phil            | IO Support      |          0 |           6 | Closed         |          2017 |
|               |                     |                |                 |               |                     |                     |  utilization: 100% Metrics in Major State: , FullMonitorName: SiteScope\Shared Services S3\WinBaseLine\prdasetlx007:WinBaseLineProd\prdasetlx007:WinCPUUtil Not Available |                     |               |                        |                                                             |                 |       |            |       |               |                         |                         |                         |                 |              |                       |             |                                                                         |                 |           |                 |                 |            |             |                |               |
| PIER          | EIT Inf Ops Support | ocuser         | NTM ServiceUser | PRDASETLX007  | EIT Inf Ops Support | EIT Inf Ops Support | PRDASETLX007::CPU  CPU Utilization exceeds the defined threshold, Metrics in Critical State:                                                                              | Degraded Service    | Closed        | P4                     | PRDASETLX007 reduced average CPU Load Percentage of :  23   | NTM ServiceUser | 10080 |          5 |     1 |      16826647 | 2017-07-20 17:46:47.970 | 2017-07-20 17:46:47.970 | 2017-07-20 17:51:09.423 |               1 | Over 30 Days | Performance           | Performance | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=16826647 |               4 | WI        | Phil            | IO Support      |          0 |           6 | Closed         |          2017 |
|               |                     |                |                 |               |                     |                     |  utilization: 100% Metrics in Major State: , FullMonitorName: SiteScope\Shared Services S3\WinBaseLine\prdasetlx007:WinBaseLineProd\prdasetlx007:WinCPUUtil Not Available |                     |               |                        |                                                             |                 |       |            |       |               |                         |                         |                         |                 |              |                       |             |                                                                         |                 |           |                 |                 |            |             |                |               |


Table: PierTicketsCurrentSprint_Counts
| jira_proj_key_cd   | DayByDay                |   DayRecords | RemainingTickets   | OpenedToday   |   ClosedToday | NetAdd   |
|:-------------------|:------------------------|-------------:|:-------------------|:--------------|--------------:|:---------|
| INFUOP             | 2018-12-19 00:00:00.000 |           79 | 76                 | 1             |             3 | -2       |
| INFUOP             | 2018-12-20 00:00:00.000 |           96 | 69                 | 29            |            27 | 2        |
| INFUOP             | 2018-12-21 00:00:00.000 |           75 | 58                 | 15            |            17 | -2       |
| INFUOP             | 2018-12-22 00:00:00.000 |           58 |                    |               |             0 |          |
| INFUOP             | 2018-12-23 00:00:00.000 |           58 |                    |               |             0 |          |
| INFUOP             | 2018-12-24 00:00:00.000 |           58 |                    |               |             0 |          |
| INFUOP             | 2018-12-25 00:00:00.000 |           58 |                    |               |             0 |          |
| INFUOP             | 2018-12-26 00:00:00.000 |           58 |                    |               |             0 |          |
| INFUOP             | 2018-12-27 00:00:00.000 |           58 |                    |               |             0 |          |
| INFUOP             | 2018-12-28 00:00:00.000 |           58 |                    |               |             0 |          |


Table: PierTickets_AllGroups_CurrentSprint_Marked
| Application   |   Task_Number | Assignee_Group      | requested_by   | Created_By      | Task_Created_Date       | Config_Item    | Assignee            | Assignee_Group2     | Task_Opened_Date        | Task_Closed_Date        | tt_description                                                                                                                                            | short_description   | status_desc   | priority_description   | resolution_comments                                    | Closed_By       |   SLA |   Duration |   Row | TicketURL                                                               |   PriorityLevel |   Duration (hr) | Aged         | Category   | Project   | jira_proj_key_cd   | Sprint_Start_Date   | Sprint_End_Date   | Check_Sprint_Start_dt   | Check_Sprint_End_dt   | KeepDiscard   | DayByDay                | KeepDiscard_DayByDay   |   Closed_Today |   Opened_Today | Queue Manager   | Queue Display   |   Past_SLA |   SortOrder | status_group   |   YearControl |
|:--------------|--------------:|:--------------------|:---------------|:----------------|:------------------------|:---------------|:--------------------|:--------------------|:------------------------|:------------------------|:----------------------------------------------------------------------------------------------------------------------------------------------------------|:--------------------|:--------------|:-----------------------|:-------------------------------------------------------|:----------------|------:|-----------:|------:|:------------------------------------------------------------------------|----------------:|----------------:|:-------------|:-----------|:----------|:-------------------|:--------------------|:------------------|:------------------------|:----------------------|:--------------|:------------------------|:-----------------------|---------------:|---------------:|:----------------|:----------------|-----------:|------------:|:---------------|--------------:|
| PIER          |      21855004 | EIT Inf Ops Support | ocuser         | NTM ServiceUser | 2018-12-15 00:00:00.000 | PRDPWEACR00001 | EIT Inf Ops Support | EIT Inf Ops Support | 2018-12-15 00:00:00.000 | 2018-12-15 00:00:00.000 | PRDPWEACR00001::Event_Agent_Down  OpC_Internal_Msg - prdpweacr00001.gsm1900.org is not communicating with the Operations Manager - agent restart required | Degraded Service    | Resolved      | P4                     | Automation: PRDPWEACR00001 responds to RDP Port pings. | NTM ServiceUser | 10080 |         11 |     1 | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=21855004 |               4 |               1 | Under 7 Days | Agent Down | WI        | WI                 |                     |                   | 12/8/2018               | 12/21/2018            | Keep          | 2018-12-08 00:00:00.000 | Keep                   |              0 |              0 | Phil            | IO Support      |          0 |           4 | Closed         |          2018 |
| PIER          |      21855004 | EIT Inf Ops Support | ocuser         | NTM ServiceUser | 2018-12-15 00:00:00.000 | PRDPWEACR00001 | EIT Inf Ops Support | EIT Inf Ops Support | 2018-12-15 00:00:00.000 | 2018-12-15 00:00:00.000 | PRDPWEACR00001::Event_Agent_Down  OpC_Internal_Msg - prdpweacr00001.gsm1900.org is not communicating with the Operations Manager - agent restart required | Degraded Service    | Resolved      | P4                     | Automation: PRDPWEACR00001 responds to RDP Port pings. | NTM ServiceUser | 10080 |         11 |     1 | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=21855004 |               4 |               1 | Under 7 Days | Agent Down | WI        | WI                 |                     |                   | 12/8/2018               | 12/21/2018            | Keep          | 2018-12-09 00:00:00.000 | Keep                   |              0 |              0 | Phil            | IO Support      |          0 |           4 | Closed         |          2018 |
| PIER          |      21855004 | EIT Inf Ops Support | ocuser         | NTM ServiceUser | 2018-12-15 00:00:00.000 | PRDPWEACR00001 | EIT Inf Ops Support | EIT Inf Ops Support | 2018-12-15 00:00:00.000 | 2018-12-15 00:00:00.000 | PRDPWEACR00001::Event_Agent_Down  OpC_Internal_Msg - prdpweacr00001.gsm1900.org is not communicating with the Operations Manager - agent restart required | Degraded Service    | Resolved      | P4                     | Automation: PRDPWEACR00001 responds to RDP Port pings. | NTM ServiceUser | 10080 |         11 |     1 | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=21855004 |               4 |               1 | Under 7 Days | Agent Down | WI        | WI                 |                     |                   | 12/8/2018               | 12/21/2018            | Keep          | 2018-12-10 00:00:00.000 | Keep                   |              0 |              0 | Phil            | IO Support      |          0 |           4 | Closed         |          2018 |
| PIER          |      21855004 | EIT Inf Ops Support | ocuser         | NTM ServiceUser | 2018-12-15 00:00:00.000 | PRDPWEACR00001 | EIT Inf Ops Support | EIT Inf Ops Support | 2018-12-15 00:00:00.000 | 2018-12-15 00:00:00.000 | PRDPWEACR00001::Event_Agent_Down  OpC_Internal_Msg - prdpweacr00001.gsm1900.org is not communicating with the Operations Manager - agent restart required | Degraded Service    | Resolved      | P4                     | Automation: PRDPWEACR00001 responds to RDP Port pings. | NTM ServiceUser | 10080 |         11 |     1 | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=21855004 |               4 |               1 | Under 7 Days | Agent Down | WI        | WI                 |                     |                   | 12/8/2018               | 12/21/2018            | Keep          | 2018-12-11 00:00:00.000 | Keep                   |              0 |              0 | Phil            | IO Support      |          0 |           4 | Closed         |          2018 |
| PIER          |      21855004 | EIT Inf Ops Support | ocuser         | NTM ServiceUser | 2018-12-15 00:00:00.000 | PRDPWEACR00001 | EIT Inf Ops Support | EIT Inf Ops Support | 2018-12-15 00:00:00.000 | 2018-12-15 00:00:00.000 | PRDPWEACR00001::Event_Agent_Down  OpC_Internal_Msg - prdpweacr00001.gsm1900.org is not communicating with the Operations Manager - agent restart required | Degraded Service    | Resolved      | P4                     | Automation: PRDPWEACR00001 responds to RDP Port pings. | NTM ServiceUser | 10080 |         11 |     1 | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=21855004 |               4 |               1 | Under 7 Days | Agent Down | WI        | WI                 |                     |                   | 12/8/2018               | 12/21/2018            | Keep          | 2018-12-12 00:00:00.000 | Keep                   |              0 |              0 | Phil            | IO Support      |          0 |           4 | Closed         |          2018 |
| PIER          |      21855004 | EIT Inf Ops Support | ocuser         | NTM ServiceUser | 2018-12-15 00:00:00.000 | PRDPWEACR00001 | EIT Inf Ops Support | EIT Inf Ops Support | 2018-12-15 00:00:00.000 | 2018-12-15 00:00:00.000 | PRDPWEACR00001::Event_Agent_Down  OpC_Internal_Msg - prdpweacr00001.gsm1900.org is not communicating with the Operations Manager - agent restart required | Degraded Service    | Resolved      | P4                     | Automation: PRDPWEACR00001 responds to RDP Port pings. | NTM ServiceUser | 10080 |         11 |     1 | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=21855004 |               4 |               1 | Under 7 Days | Agent Down | WI        | WI                 |                     |                   | 12/8/2018               | 12/21/2018            | Keep          | 2018-12-13 00:00:00.000 | Keep                   |              0 |              0 | Phil            | IO Support      |          0 |           4 | Closed         |          2018 |
| PIER          |      21855004 | EIT Inf Ops Support | ocuser         | NTM ServiceUser | 2018-12-15 00:00:00.000 | PRDPWEACR00001 | EIT Inf Ops Support | EIT Inf Ops Support | 2018-12-15 00:00:00.000 | 2018-12-15 00:00:00.000 | PRDPWEACR00001::Event_Agent_Down  OpC_Internal_Msg - prdpweacr00001.gsm1900.org is not communicating with the Operations Manager - agent restart required | Degraded Service    | Resolved      | P4                     | Automation: PRDPWEACR00001 responds to RDP Port pings. | NTM ServiceUser | 10080 |         11 |     1 | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=21855004 |               4 |               1 | Under 7 Days | Agent Down | WI        | WI                 |                     |                   | 12/8/2018               | 12/21/2018            | Keep          | 2018-12-14 00:00:00.000 | Keep                   |              0 |              0 | Phil            | IO Support      |          0 |           4 | Closed         |          2018 |
| PIER          |      21855004 | EIT Inf Ops Support | ocuser         | NTM ServiceUser | 2018-12-15 00:00:00.000 | PRDPWEACR00001 | EIT Inf Ops Support | EIT Inf Ops Support | 2018-12-15 00:00:00.000 | 2018-12-15 00:00:00.000 | PRDPWEACR00001::Event_Agent_Down  OpC_Internal_Msg - prdpweacr00001.gsm1900.org is not communicating with the Operations Manager - agent restart required | Degraded Service    | Resolved      | P4                     | Automation: PRDPWEACR00001 responds to RDP Port pings. | NTM ServiceUser | 10080 |         11 |     1 | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=21855004 |               4 |               1 | Under 7 Days | Agent Down | WI        | WI                 |                     |                   | 12/8/2018               | 12/21/2018            | Keep          | 2018-12-15 00:00:00.000 | Keep                   |              1 |              1 | Phil            | IO Support      |          0 |           4 | Closed         |          2018 |
| PIER          |      21856753 | EIT Inf Ops Support | ocuser         | NTM ServiceUser | 2018-12-15 00:00:00.000 | ADMPWSNOW00010 | EIT Inf Ops Support | EIT Inf Ops Support | 2018-12-15 00:00:00.000 | 2018-12-15 00:00:00.000 | ADMPWSNOW00010::Event_Agent_Down  OpC_Internal_Msg - admpwsnow00010.gsm1900.org is not communicating with the Operations Manager - agent restart required | Degraded Service    | Resolved      | P4                     | Automation: ADMPWSNOW00010 responds to RDP Port pings. | NTM ServiceUser | 10080 |         14 |     1 | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=21856753 |               4 |               1 | Under 7 Days | Agent Down | WI        | WI                 |                     |                   | 12/8/2018               | 12/21/2018            | Keep          | 2018-12-08 00:00:00.000 | Keep                   |              0 |              0 | Phil            | IO Support      |          0 |           4 | Closed         |          2018 |
| PIER          |      21856753 | EIT Inf Ops Support | ocuser         | NTM ServiceUser | 2018-12-15 00:00:00.000 | ADMPWSNOW00010 | EIT Inf Ops Support | EIT Inf Ops Support | 2018-12-15 00:00:00.000 | 2018-12-15 00:00:00.000 | ADMPWSNOW00010::Event_Agent_Down  OpC_Internal_Msg - admpwsnow00010.gsm1900.org is not communicating with the Operations Manager - agent restart required | Degraded Service    | Resolved      | P4                     | Automation: ADMPWSNOW00010 responds to RDP Port pings. | NTM ServiceUser | 10080 |         14 |     1 | https://technology.services.t-mobile.com/pier#Ticket?ticket_id=21856753 |               4 |               1 | Under 7 Days | Agent Down | WI        | WI                 |                     |                   | 12/8/2018               | 12/21/2018            | Keep          | 2018-12-09 00:00:00.000 | Keep                   |              0 |              0 | Phil            | IO Support      |          0 |           4 | Closed         |          2018 |


Table: QueueManagers
| Manager   |
|:----------|
| Virgil    |
| Phil      |
| Kathy     |


Table: rpt_OverarchingTotals
| Application   |   YearControl | Project   | Status      |   Issue_Count |   Ttl_Story_Points | Manager   |   Sort_Order |
|:--------------|--------------:|:----------|:------------|--------------:|-------------------:|:----------|-------------:|
| JIRA          |          2017 | INFAOP    | Blocked     |             1 |                  5 | Virgil    |            4 |
| JIRA          |          2018 | INFAOP    | Blocked     |             3 |                  7 | Virgil    |            4 |
| JIRA          |          2018 | NAS       | Blocked     |             4 |                  0 | Kathy     |            4 |
| JIRA          |          2017 | INFUOP    | In Progress |             1 |                  0 | Virgil    |            7 |
| JIRA          |          2018 | INFUOP    | In Progress |            12 |                 31 | Virgil    |            7 |
| JIRA          |          2017 | STOR      | In Progress |             5 |                  0 | Kathy     |            7 |
| JIRA          |          2018 | STOR      | In Progress |            31 |                 13 | Kathy     |            7 |
| JIRA          |          2017 | STOR      | To Do       |            12 |                  0 | Kathy     |            5 |
| JIRA          |          2018 | INFUOP    | To Do       |            40 |                173 | Virgil    |            5 |
| JIRA          |          2018 | NAS       | To Do       |            86 |                  0 | Kathy     |            5 |


Table: S2_GraphActiveSprint
| jira_proj_key_cd   | sprint_name      | sprint_start_dt         | sprint_end_dt           | DayByDay                |   Issues |   Story Points | Burndown_SP   | Burndown_Issues   | Graph_SP   | Graph_Issues   | Graph_Today_SP   | Graph_Today_Issues   | Added_SP   | Added_Issues   |   Rolling Data Story Points |
|:-------------------|:-----------------|:------------------------|:------------------------|:------------------------|---------:|---------------:|:--------------|:------------------|:-----------|:---------------|:-----------------|:---------------------|:-----------|:---------------|----------------------------:|
| INFAOP             | INFOP_2018-12-18 | 2018-12-19 00:00:00.000 | 2019-01-02 00:00:00.000 | 2018-12-19 00:00:00.000 |       10 |             28 | 28            | 10                | 28         | 10             |                  |                      | 0          |                |                          28 |
| INFAOP             | INFOP_2018-12-18 | 2018-12-19 00:00:00.000 | 2019-01-02 00:00:00.000 | 2018-12-20 00:00:00.000 |       10 |             28 |               |                   | 28         | 10             | 28               | 10                   | 0          |                |                          28 |
| INFAOP             | INFOP_2018-12-18 | 2018-12-19 00:00:00.000 | 2019-01-02 00:00:00.000 | 2018-12-21 00:00:00.000 |       10 |             28 |               |                   |            |                | 28               | 10                   | 0          |                |                          28 |
| INFAOP             | INFOP_2018-12-18 | 2018-12-19 00:00:00.000 | 2019-01-02 00:00:00.000 | 2018-12-22 00:00:00.000 |       10 |             28 |               |                   |            |                |                  |                      |            |                |                          28 |
| INFAOP             | INFOP_2018-12-18 | 2018-12-19 00:00:00.000 | 2019-01-02 00:00:00.000 | 2018-12-23 00:00:00.000 |       10 |             28 |               |                   |            |                |                  |                      |            |                |                          28 |
| INFAOP             | INFOP_2018-12-18 | 2018-12-19 00:00:00.000 | 2019-01-02 00:00:00.000 | 2018-12-24 00:00:00.000 |       10 |             28 |               |                   |            |                |                  |                      |            |                |                          28 |
| INFAOP             | INFOP_2018-12-18 | 2018-12-19 00:00:00.000 | 2019-01-02 00:00:00.000 | 2018-12-25 00:00:00.000 |       10 |             28 |               |                   |            |                |                  |                      |            |                |                          28 |
| INFAOP             | INFOP_2018-12-18 | 2018-12-19 00:00:00.000 | 2019-01-02 00:00:00.000 | 2018-12-26 00:00:00.000 |       10 |             28 |               |                   |            |                |                  |                      |            |                |                          28 |
| INFAOP             | INFOP_2018-12-18 | 2018-12-19 00:00:00.000 | 2019-01-02 00:00:00.000 | 2018-12-27 00:00:00.000 |       10 |             28 |               |                   |            |                |                  |                      |            |                |                          28 |
| INFAOP             | INFOP_2018-12-18 | 2018-12-19 00:00:00.000 | 2019-01-02 00:00:00.000 | 2018-12-28 00:00:00.000 |       10 |             28 |               |                   |            |                |                  |                      |            |                |                          28 |


Table: ServiceNowHighStatuses
| Status_Group     |   Sort_Order |
|:-----------------|-------------:|
| Open             |            1 |
| Pending          |            2 |
| Work in Progress |            7 |
| Closed           |            9 |


Table: ServiceNowTickets
| Application_Name   | Request_ID   | Request_State   | Assignee_Group     | Request_Priority   | cat_item                    | requested_for   | Created_By     | REQ_Created_Date        | REQ_Closed_Date         | REQ_Description   | REQ_SLA   | RITM_number   | RITM_State   | RITM_Opened_Date        | RITM_Closed_Date        | RITM_status_desc   | closed_by          |   RTIM_Duration | RITM_Made_SLA   | Task_Number   | Task_Opened_Date        | Task_Closed_Date        |   Task_Duration | Task_Assignee      | Task_Status   | TicketURL                                                                          | Aged         | Project   | Manager   |   Created_Year |   AgedSort |   YearControl |   StateSort |
|:-------------------|:-------------|:----------------|:-------------------|:-------------------|:----------------------------|:----------------|:---------------|:------------------------|:------------------------|:------------------|:----------|:--------------|:-------------|:------------------------|:------------------------|:-------------------|:-------------------|----------------:|:----------------|:--------------|:------------------------|:------------------------|----------------:|:-------------------|:--------------|:-----------------------------------------------------------------------------------|:-------------|:----------|:----------|---------------:|-----------:|--------------:|------------:|
| SNOW               | REQ0103287   | Closed Complete | EIT-Windows-Tier 1 | P4                 | Server Decommission Request | Keith Blystone  | Keith Blystone | 2017-07-20 13:53:35.000 | 2017-11-15 09:32:28.000 |                   |           | RITM0157481   | Complete     | 2017-07-20 13:52:59.000 | 2017-08-04 07:02:19.000 | Complete           | Tirumala Dandagala |           21190 | True            | TASK0230963   | 2017-08-03 23:23:47.000 | 2017-08-05 08:12:54.000 |            1969 | Tirumala Dandagala | Closed        | https://tmus.service-now.com/sc_request.do?sys_id=08b9f28edb80c708ef4d541adc96191b | Over 30 Days | WI        | Phil      |           2017 |          3 |          2017 |           9 |
| SNOW               | REQ0103287   | Closed Complete | EIT-Windows-Tier 1 | P4                 | Server Decommission Request | Keith Blystone  | Keith Blystone | 2017-07-20 13:53:35.000 | 2017-11-15 09:32:28.000 |                   |           | RITM0157493   | Complete     | 2017-07-20 13:53:03.000 | 2017-08-16 09:31:43.000 | Complete           | Tirumala Dandagala |           38618 | True            | TASK0234825   | 2017-08-15 22:37:02.000 | 2017-08-16 05:52:29.000 |             435 | Tirumala Dandagala | Closed        | https://tmus.service-now.com/sc_request.do?sys_id=08b9f28edb80c708ef4d541adc96191b | Over 30 Days | WI        | Phil      |           2017 |          3 |          2017 |           9 |
| SNOW               | REQ0103287   | Closed Complete | EIT-Windows-Tier 1 | P4                 | Server Decommission Request | Keith Blystone  | Keith Blystone | 2017-07-20 13:53:35.000 | 2017-11-15 09:32:28.000 |                   |           | RITM0157494   | Complete     | 2017-07-20 13:53:03.000 | 2017-08-02 04:42:16.000 | Complete           | Tirumala Dandagala |           18169 | True            | TASK0229744   | 2017-08-01 22:03:17.000 | 2017-08-05 07:59:01.000 |            4916 | Tirumala Dandagala | Closed        | https://tmus.service-now.com/sc_request.do?sys_id=08b9f28edb80c708ef4d541adc96191b | Over 30 Days | WI        | Phil      |           2017 |          3 |          2017 |           9 |
| SNOW               | REQ0103287   | Closed Complete | EIT-Windows-Tier 1 | P4                 | Server Decommission Request | Keith Blystone  | Keith Blystone | 2017-07-20 13:53:35.000 | 2017-11-15 09:32:28.000 |                   |           | RITM0157496   | Complete     | 2017-07-20 13:53:04.000 | 2017-08-03 03:32:08.000 | Complete           | Tirumala Dandagala |           19539 | True            | TASK0230389   | 2017-08-02 22:03:18.000 | 2017-08-05 08:00:05.000 |            3477 | Tirumala Dandagala | Closed        | https://tmus.service-now.com/sc_request.do?sys_id=08b9f28edb80c708ef4d541adc96191b | Over 30 Days | WI        | Phil      |           2017 |          3 |          2017 |           9 |
| SNOW               | REQ0103287   | Closed Complete | EIT-Windows-Tier 1 | P4                 | Server Decommission Request | Keith Blystone  | Keith Blystone | 2017-07-20 13:53:35.000 | 2017-11-15 09:32:28.000 |                   |           | RITM0157501   | Complete     | 2017-07-20 13:53:06.000 | 2017-08-02 04:42:04.000 | Complete           | Tirumala Dandagala |           18169 | True            | TASK0229980   | 2017-08-02 02:08:34.000 | 2017-08-05 07:57:29.000 |            4669 | Tirumala Dandagala | Closed        | https://tmus.service-now.com/sc_request.do?sys_id=08b9f28edb80c708ef4d541adc96191b | Over 30 Days | WI        | Phil      |           2017 |          3 |          2017 |           9 |
| SNOW               | REQ0103287   | Closed Complete | EIT-Windows-Tier 1 | P4                 | Server Decommission Request | Keith Blystone  | Keith Blystone | 2017-07-20 13:53:35.000 | 2017-11-15 09:32:28.000 |                   |           | RITM0157503   | Complete     | 2017-07-20 13:53:06.000 | 2017-08-02 04:42:01.000 | Complete           | Tirumala Dandagala |           18169 | True            | TASK0229727   | 2017-08-01 22:03:17.000 | 2017-08-05 07:57:16.000 |            4914 | Tirumala Dandagala | Closed        | https://tmus.service-now.com/sc_request.do?sys_id=08b9f28edb80c708ef4d541adc96191b | Over 30 Days | WI        | Phil      |           2017 |          3 |          2017 |           9 |
| SNOW               | REQ0103287   | Closed Complete | EIT-Windows-Tier 1 | P4                 | Server Decommission Request | Keith Blystone  | Keith Blystone | 2017-07-20 13:53:35.000 | 2017-11-15 09:32:28.000 |                   |           | RITM0157509   | Complete     | 2017-07-20 13:53:08.000 | 2017-08-08 22:06:11.000 | Complete           | Tirumala Dandagala |           27853 | True            | TASK0232368   | 2017-08-08 14:23:25.000 | 2017-08-11 04:02:17.000 |            3699 | Tirumala Dandagala | Closed        | https://tmus.service-now.com/sc_request.do?sys_id=08b9f28edb80c708ef4d541adc96191b | Over 30 Days | WI        | Phil      |           2017 |          3 |          2017 |           9 |
| SNOW               | REQ0103287   | Closed Complete | EIT-Windows-Tier 1 | P4                 | Server Decommission Request | Keith Blystone  | Keith Blystone | 2017-07-20 13:53:35.000 | 2017-11-15 09:32:28.000 |                   |           | RITM0157510   | Complete     | 2017-07-20 13:53:09.000 | 2017-08-08 22:06:10.000 | Complete           | Tirumala Dandagala |           27853 | True            | TASK0232499   | 2017-08-08 14:25:49.000 | 2017-08-11 04:01:41.000 |            3696 | Tirumala Dandagala | Closed        | https://tmus.service-now.com/sc_request.do?sys_id=08b9f28edb80c708ef4d541adc96191b | Over 30 Days | WI        | Phil      |           2017 |          3 |          2017 |           9 |
| SNOW               | REQ0103287   | Closed Complete | EIT-Windows-Tier 1 | P4                 | Server Decommission Request | Keith Blystone  | Keith Blystone | 2017-07-20 13:53:35.000 | 2017-11-15 09:32:28.000 |                   |           | RITM0157510   | Complete     | 2017-07-20 13:53:09.000 | 2017-08-08 22:06:10.000 | Complete           | Tirumala Dandagala |           27853 | True            | TASK0232500   | 2017-08-08 14:25:49.000 | 2017-08-11 03:47:09.000 |            3682 | Tirumala Dandagala | Closed        | https://tmus.service-now.com/sc_request.do?sys_id=08b9f28edb80c708ef4d541adc96191b | Over 30 Days | WI        | Phil      |           2017 |          3 |          2017 |           9 |
| SNOW               | REQ0103287   | Closed Complete | EIT-Windows-Tier 1 | P4                 | Server Decommission Request | Keith Blystone  | Keith Blystone | 2017-07-20 13:53:35.000 | 2017-11-15 09:32:28.000 |                   |           | RITM0157512   | Complete     | 2017-07-20 13:53:09.000 | 2017-08-04 07:02:16.000 | Complete           | Tirumala Dandagala |           21189 | True            | TASK0230861   | 2017-08-03 22:03:18.000 | 2017-08-05 07:57:29.000 |            2034 | Tirumala Dandagala | Closed        | https://tmus.service-now.com/sc_request.do?sys_id=08b9f28edb80c708ef4d541adc96191b | Over 30 Days | WI        | Phil      |           2017 |          3 |          2017 |           9 |


Table: ServiceNow_AllGroups_CurrentSprint_Marked_DayByDay
| jira_proj_key_cd   | DayByDay                | Assignee_Group   | OpenedToday   |   ClosedToday |   DayRecords | RemainingTickets   | Project   | Manager   |
|:-------------------|:------------------------|:-----------------|:--------------|--------------:|-------------:|:-------------------|:----------|:----------|
| INFUOP             | 2018-12-21 00:00:00.000 | EIT-Unix-Tier 2  | 0             |             0 |          135 | 135                | INFUOP    | Virgil    |
| INFUOP             | 2018-12-22 00:00:00.000 | EIT-Unix-Tier 2  |               |             0 |          135 |                    | INFUOP    | Virgil    |
| INFUOP             | 2018-12-23 00:00:00.000 | EIT-Unix-Tier 2  |               |             0 |          135 |                    | INFUOP    | Virgil    |
| INFUOP             | 2018-12-24 00:00:00.000 | EIT-Unix-Tier 2  |               |             0 |          135 |                    | INFUOP    | Virgil    |
| INFUOP             | 2018-12-25 00:00:00.000 | EIT-Unix-Tier 2  |               |             0 |          135 |                    | INFUOP    | Virgil    |
| INFUOP             | 2018-12-26 00:00:00.000 | EIT-Unix-Tier 2  |               |             0 |          135 |                    | INFUOP    | Virgil    |
| INFUOP             | 2018-12-27 00:00:00.000 | EIT-Unix-Tier 2  |               |             0 |          135 |                    | INFUOP    | Virgil    |
| INFUOP             | 2018-12-28 00:00:00.000 | EIT-Unix-Tier 2  |               |             0 |          135 |                    | INFUOP    | Virgil    |
| INFUOP             | 2018-12-29 00:00:00.000 | EIT-Unix-Tier 2  |               |             0 |          135 |                    | INFUOP    | Virgil    |
| INFUOP             | 2018-12-30 00:00:00.000 | EIT-Unix-Tier 2  |               |             0 |          135 |                    | INFUOP    | Virgil    |


Table: StoryXSprintData_ActiveSprint
|   DW Unique Issue ID |   JIRA Unique Issue ID | Issue Key   | Summary                                                         | Story Points   |   Sprint ID | Resolution Date         | Status      | Sprint Name                    | Sprint Start Date       | Sprint End Date         | Sprint Complete Date   | Sprint Status   | Current Year   | Reset Status   | Sprint Completed Story Points   | Committed Points   | jira_proj_key_cd   | issue_creation_dt       | Display JIRA Sprint            | Sprint Modification   | Number of Sprints   | Added_DuringSprint   |   AddedToSprintSP | Orig_Committed_SP   |   Added_SP |   AddedToSprint |   StartIssues |   Sort Order |
|---------------------:|-----------------------:|:------------|:----------------------------------------------------------------|:---------------|------------:|:------------------------|:------------|:-------------------------------|:------------------------|:------------------------|:-----------------------|:----------------|:---------------|:---------------|:--------------------------------|:-------------------|:-------------------|:------------------------|:-------------------------------|:----------------------|:--------------------|:---------------------|------------------:|:--------------------|-----------:|----------------:|--------------:|-------------:|
|               134232 |                 161811 | WI-186      | Create Jenkins folder structure for Windows Operations team     |                |        1034 | 2018-06-19 14:00:31.223 | Done        | Sprint 22 (11/6 - 11/19) - UNP | 2017-11-06 08:00:53.000 | 2017-11-20 07:58:00.000 |                        | Active          | No             | Done           |                                 |                    | WI                 | 2018-05-11 09:55:17.866 | Sprint 22 (11/6 - 11/19) - UNP |                       |                     |                      |                 0 |                     |          0 |               0 |             1 |            9 |
|               202514 |                 239106 | STOR-1585   | Decomm  Polaris VNX pxvnx2309                                   |                |        2241 |                         | In Progress | STOR_2018-12-11                | 2018-12-13 18:15:00.000 | 2018-12-25 01:30:00.000 |                        | Active          | Yes            | In Progress    |                                 |                    | STOR               | 2018-12-18 18:04:59.313 | 2018-12-11                     | Added                 |                     | TRUE                 |                 0 |                     |          0 |               0 |             0 |            7 |
|               202513 |                 239105 | STOR-1584   | Decomm  Polaris VNX pxvnx0683                                   |                |        2241 |                         | In Progress | STOR_2018-12-11                | 2018-12-13 18:15:00.000 | 2018-12-25 01:30:00.000 |                        | Active          | Yes            | In Progress    |                                 |                    | STOR               | 2018-12-18 18:04:11.936 | 2018-12-11                     | Added                 |                     | TRUE                 |                 0 |                     |          0 |               0 |             0 |            7 |
|               202512 |                 239104 | STOR-1583   | Decomm Titan VNX ttvnx0680                                      |                |        2241 |                         | In Progress | STOR_2018-12-11                | 2018-12-13 18:15:00.000 | 2018-12-25 01:30:00.000 |                        | Active          | Yes            | In Progress    |                                 |                    | STOR               | 2018-12-18 18:03:19.283 | 2018-12-11                     | Added                 |                     | TRUE                 |                 0 |                     |          0 |               0 |             0 |            7 |
|               202511 |                 239103 | STOR-1582   | Decomm Titan VMAX ttvmx2394                                     |                |        2241 |                         | In Progress | STOR_2018-12-11                | 2018-12-13 18:15:00.000 | 2018-12-25 01:30:00.000 |                        | Active          | Yes            | In Progress    |                                 |                    | STOR               | 2018-12-18 18:02:18.766 | 2018-12-11                     | Added                 |                     | TRUE                 |                 0 |                     |          0 |               0 |             0 |            7 |
|               201153 |                 236990 | STOR-1581   | Pure1 Overhead Dashboard                                        | 2              |        2241 |                         | To Do       | STOR_2018-12-11                | 2018-12-13 18:15:00.000 | 2018-12-25 01:30:00.000 |                        | Active          | Yes            | To Do          | 0                               | 2                  | STOR               | 2018-12-13 12:53:08.986 | 2018-12-11                     |                       |                     |                      |                 0 | 2                   |          0 |               0 |             1 |            5 |
|               201147 |                 236988 | STOR-1580   | TT CaaS NPE Pod                                                 | 1              |        2241 |                         | To Do       | STOR_2018-12-11                | 2018-12-13 18:15:00.000 | 2018-12-25 01:30:00.000 |                        | Active          | Yes            | To Do          | 0                               | 1                  | STOR               | 2018-12-13 12:13:21.823 | 2018-12-11                     |                       |                     |                      |                 0 | 1                   |          0 |               0 |             1 |            5 |
|               200466 |                 236642 | STOR-1578   | Decomm 2 VI HD48 probes from Titan that were used for vmax 2394 |                |        2241 |                         | In Progress | STOR_2018-12-11                | 2018-12-13 18:15:00.000 | 2018-12-25 01:30:00.000 |                        | Active          | Yes            | In Progress    |                                 |                    | STOR               | 2018-12-11 14:09:42.903 | 2018-12-11                     |                       |                     |                      |                 0 |                     |          0 |               0 |             1 |            7 |
|               200356 |                 236383 | STOR-1577   | TT VRA Prod 2 - fix replication link                            | 2              |        2241 |                         | In Progress | STOR_2018-12-11                | 2018-12-13 18:15:00.000 | 2018-12-25 01:30:00.000 |                        | Active          | Yes            | In Progress    | 0                               | 2                  | STOR               | 2018-12-11 10:50:25.856 | 2018-12-11                     |                       |                     |                      |                 0 | 2                   |          0 |               0 |             1 |            7 |
|               200354 |                 236381 | STOR-1576   | PDS Prod 2 - fix replication links                              | 2              |        2241 |                         | In Progress | STOR_2018-12-11                | 2018-12-13 18:15:00.000 | 2018-12-25 01:30:00.000 |                        | Active          | Yes            | In Progress    | 0                               | 2                  | STOR               | 2018-12-11 10:49:18.870 | 2018-12-11                     |                       |                     |                      |                 0 | 2                   |          0 |               0 |             1 |            7 |


Table: YearsInTickets
|   YearControl |
|--------------:|
|          2018 |
|          2017 |

 


tables: name: Current Year Control
data: Current Year Control.csv
name: JIRA_Projects
data: JIRA_Projects.csv
name: LastRefresh
data: LastRefresh.csv
name: ManagerToProject
data: ManagerToProject.csv
name: PierHighStatuses
data: PierHighStatuses.csv
name: PierTickets
data: PierTickets.csv
name: PierTicketsCurrentSprint_Counts
data: PierTicketsCurrentSprint_Counts.csv
name: PierTickets_AllGroups_CurrentSprint_Marked
data: PierTickets_AllGroups_CurrentSprint_Marked.csv
name: QueueManagers
data: QueueManagers.csv
name: rpt_OverarchingTotals
data: rpt_OverarchingTotals.csv
name: S2_GraphActiveSprint
data: S2_GraphActiveSprint.csv
name: ServiceNowHighStatuses
data: ServiceNowHighStatuses.csv
name: ServiceNowTickets
data: ServiceNowTickets.csv
name: ServiceNow_AllGroups_CurrentSprint_Marked_DayByDay
data: ServiceNow_AllGroups_CurrentSprint_Marked_DayByDay.csv
name: StoryXSprintData_ActiveSprint
data: StoryXSprintData_ActiveSprint.csv
name: YearsInTickets
data: YearsInTickets.csv
label: S2_GraphActiveSprint
jira_proj_key_cd
JIRA_Projects
jira_proj_key_cd
StoryXSprintData_ActiveSprint
jira_proj_key_cd
JIRA_Projects
jira_proj_key_cd
StoryXSprintData_ActiveSprint
Current Year
Current Year Control
Current Year
PierTicketsCurrentSprint_Counts
jira_proj_key_cd
JIRA_Projects
jira_proj_key_cd
PierTickets
Project
JIRA_Projects
jira_proj_key_cd
ServiceNow_AllGroups_CurrentSprint_Marked_DayByDay
jira_proj_key_cd
JIRA_Projects
jira_proj_key_cd
ServiceNow_AllGroups_CurrentSprint_Marked_DayByDay
Manager
QueueManagers
Manager
PierTickets
Queue Manager
QueueManagers
Manager
PierTickets
status_group
PierHighStatuses
Status_Group
PierTickets_AllGroups_CurrentSprint_Marked
status_group
PierHighStatuses
Status_Group
PierTickets
YearControl
YearsInTickets
YearControl
PierTickets_AllGroups_CurrentSprint_Marked
YearControl
YearsInTickets
YearControl
PierTickets
Project
ManagerToProject
Project
PierTickets_AllGroups_CurrentSprint_Marked
Project
ManagerToProject
Project
ServiceNow_AllGroups_CurrentSprint_Marked_DayByDay
Project
ManagerToProject
Project
rpt_OverarchingTotals
Project
ManagerToProject
Project
rpt_OverarchingTotals
YearControl
YearsInTickets
YearControl
rpt_OverarchingTotals
Manager
QueueManagers
Manager
rpt_OverarchingTotals
Sort_Order
PierHighStatuses
Sort_Order
ServiceNowTickets
Project
ManagerToProject
Project
ServiceNowTickets
YearControl
YearsInTickets
YearControl
ServiceNowTickets
Manager
QueueManagers
Manager
ServiceNowTickets
Project
JIRA_Projects
jira_proj_key_cd
ServiceNowTickets
Task_Status
ServiceNowHighStatuses
Status_Group
output: {
    "joins": [
        {
            "from_table": "S2_GraphActiveSprint",
            "from_column": "jira_proj_key_cd",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "StoryXSprintData_ActiveSprint",
            "from_column": "jira_proj_key_cd",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "StoryXSprintData_ActiveSprint",
            "from_column": "Current Year",
            "to_table": "Current Year Control",
            "to_column": "Current Year"
        },
        {
            "from_table": "PierTicketsCurrentSprint_Counts",
            "from_column": "jira_proj_key_cd",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "PierTickets",
            "from_column": "Project",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "ServiceNow_AllGroups_CurrentSprint_Marked_DayByDay",
            "from_column": "jira_proj_key_cd",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "ServiceNow_AllGroups_CurrentSprint_Marked_DayByDay",
            "from_column": "Manager",
            "to_table": "QueueManagers",
            "to_column": "Manager"
        },
        {
            "from_table": "PierTickets",
            "from_column": "Queue Manager",
            "to_table": "QueueManagers",
            "to_column": "Manager"
        },
        {
            "from_table": "PierTickets",
            "from_column": "status_group",
            "to_table": "PierHighStatuses",
            "to_column": "Status_Group"
        },
        {
            "from_table": "PierTickets_AllGroups_CurrentSprint_Marked",
            "from_column": "status_group",
            "to_table": "PierHighStatuses",
            "to_column": "Status_Group"
        },
        {
            "from_table": "PierTickets",
            "from_column": "YearControl",
            "to_table": "YearsInTickets",
            "to_column": "YearControl"
        },
        {
            "from_table": "PierTickets_AllGroups_CurrentSprint_Marked",
            "from_column": "YearControl",
            "to_table": "YearsInTickets",
            "to_column": "YearControl"
        },
        {
            "from_table": "PierTickets",
            "from_column": "Project",
            "to_table": "ManagerToProject",
            "to_column": "Project"
        },
        {
            "from_table": "PierTickets_AllGroups_CurrentSprint_Marked",
            "from_column": "Project",
            "to_table": "ManagerToProject",
            "to_column": "Project"
        },
        {
            "from_table": "ServiceNow_AllGroups_CurrentSprint_Marked_DayByDay",
            "from_column": "Project",
            "to_table": "ManagerToProject",
            "to_column": "Project"
        },
        {
            "from_table": "rpt_OverarchingTotals",
            "from_column": "Project",
            "to_table": "ManagerToProject",
            "to_column": "Project"
        },
        {
            "from_table": "rpt_OverarchingTotals",
            "from_column": "YearControl",
            "to_table": "YearsInTickets",
            "to_column": "YearControl"
        },
        {
            "from_table": "rpt_OverarchingTotals",
            "from_column": "Manager",
            "to_table": "QueueManagers",
            "to_column": "Manager"
        },
        {
            "from_table": "rpt_OverarchingTotals",
            "from_column": "Sort_Order",
            "to_table": "PierHighStatuses",
            "to_column": "Sort_Order"
        },
        {
            "from_table": "ServiceNowTickets",
            "from_column": "Project",
            "to_table": "ManagerToProject",
            "to_column": "Project"
        },
        {
            "from_table": "ServiceNowTickets",
            "from_column": "YearControl",
            "to_table": "YearsInTickets",
            "to_column": "YearControl"
        },
        {
            "from_table": "ServiceNowTickets",
            "from_column": "Manager",
            "to_table": "QueueManagers",
            "to_column": "Manager"
        },
        {
            "from_table": "ServiceNowTickets",
            "from_column": "Project",
            "to_table": "JIRA_Projects",
            "to_column": "jira_proj_key_cd"
        },
        {
            "from_table": "ServiceNowTickets",
            "from_column": "Task_Status",
            "to_table": "ServiceNowHighStatuses",
            "to_column": "Status_Group"
        }
    ]
}