Back to Home

Drop Sampling from Feed

Overview

Sometimes necessary audits do not come in from the feed like they are supposed to, due to issues with the sample method. In these cases, business still needs these audits to be loaded.

Steps

  1. Run Script 1 on CIWSQLXP1125, updating @SampleNo, @NumberOfRows, @StartDate, @EndDate to the requested values

  2. Add where conditions business requests

    • This may come from the Sample Setup page
      • If LeadTeamName is needed, grab all processors under a lead team and add a condition to filter request_upd_agent_ntid by those processors
    • This may be specific work_request_item number
      • Add those to the where condition
  3. Open Script 2 on CIWSQLXP0053
  4. Paste results from Script 1 into Script 2
    • Delete trailing comma on last line
  5. Send Script 2 to the DBA to be executed on CIWSQLXP0053
  6. Verify audits have been added in the p10_AuditInstance table

Script 1

Script 2