Details

    • Type: Story
    • Status: Open (View Workflow)
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: CFA 2022R2
    • Component/s: None
    • Labels:
      None
    • SCRUM Team:
      Brotherhood of Mutants
    • Story Points:
      8
    • Work Type Classification:
      Sustaining

      Description

      Story

      As an admin, I would like to be able to view the DLPS configuration tables so that I can effectively troubleshoot any issues I find.

      Details

      CFA is attempting to make sure that DLPS is configured and working correctly. In order to do that they periodically want to audit the DLPS configurations. The InFORM team has provided this data in the past for them on and ad hoc basis.

      The request to get this data ad hoc was handled in tickets CFAMX-12914 and CFAMX-14574. In these stories, InFORM provided a full database backup export (.bak) file.

      Basically, we want use the same methods we used for the ad hoc request and create a data export so that CFA can get this data when they want it instead of having to request the time from an InFORM developer. Please see the attached files below:

      DLPS Export SQL

      DLPS Export.sql

      DLPS Data Extract Sample

      DLPSExtract.zip

      DLPS Zone Members .CSV

      DLPSZoneMembers.csv

      Export Title

      DLPS Configurations Database

      AC

      1. Confirm that a "DLPS Configurations Database" data export exists based on the SQL example attached to this ticket.
      2. Confirm that the export is inclusive of all the data included in the previous ad hoc data requests.

        Attachments

        1. DLPSZoneMembers.csv
          421 kB
          Jason Powell
        2. DLPS Export.sql
          3 kB
          Jason Powell

          Issue Links

          1.
          Create Test Scripts QA Task Ready for QA Unassigned

          1%

          Original Estimate - 0.5h Original Estimate - 0.5h
          Time Spent - 1m Remaining Estimate - 1h
          2.
          Review Test Scripts QA Task Ready for QA Unassigned

          0%

          Original Estimate - 0.5h
          Remaining Estimate - 0.5h
          3.
          Deploy QA Task Ready for QA Unassigned

          0%

          Original Estimate - 0.5h
          Remaining Estimate - 0.5h
          4.
          Execute Test Cases QA Task Ready for QA Unassigned

          0%

          Original Estimate - 0.5h Original Estimate - 0.5h
          Remaining Estimate - 2h
          5.
          Functional Review with QA Dev Task Ready for Developer Unassigned

          0%

          Original Estimate - 0.5h
          Remaining Estimate - 0.5h
          6.
          DIT Dev Task Ready for Developer Unassigned

          0%

          Original Estimate - 0.5h
          Remaining Estimate - 0.5h
          7.
          Design Review Dev Task Ready for Developer Unassigned

          0%

          Original Estimate - 0.5h
          Remaining Estimate - 0.5h
          8.
          Story Documentation Dev Task Ready for Developer Unassigned

          0%

          Original Estimate - 0.5h
          Remaining Estimate - 0.5h
          9.
          Implementation 17 tables data Export Dev Task Ready for Developer Unassigned

          0%

          Original Estimate - 35h
          Remaining Estimate - 35h

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jason.powell Jason Powell
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - 39h Original Estimate - 39h
                  39h
                  Remaining:
                  Remaining Estimate - 41h
                  41h
                  Logged:
                  Remaining Estimate - 41h
                  2m

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.