Uploaded image for project: 'Modules'
  1. Modules
  2. MODULES-8609

SQLServer : SQL Query Task

    XMLWordPrintable

    Details

    • Template:
    • Acceptance Criteria:
      Hide

      Unit testing via pester? 

      Acceptance testing

      No docs update needed.

      Show
      Unit testing via pester?  Acceptance testing No docs update needed.
    • Team:
      Windows
    • Story Points:
      1
    • Sprint:
      Windows Hopper
    • QA Risk Assessment:
      Needs Assessment

      Description

      Many of the tasks and plans that need to accomplish tasks will need to know how to do sql queries.

      This ticket will create a sql query task so that plans will have the ability to execute t-sql code on a server.

      The result of this task should always be a json object representing the resultset of the query.

      The raw task should not be exposed to users of the PE console, as we don't want console users to be able to execute arbitrary t-sql via the console. This task should only ever be consumed by plans so that the basic query, if not all of it's parameters, can known via a code review process prior to implementing.

      Need to decide on a strategy to accomplish this. May have to write a new PowerShell cmdlet that will do a query and return json.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              william.hurt William Hurt
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Zendesk Support