Back to Home

Check Why Audits Haven't Been Pulling in

Overview

If business asks why a sample may be short, we need to manually run the query to see what data is getting returned

Steps

  1. Open up Sample Setup menu
  2. Find the relevant sample that needs updating and select it
  3. Copy the current Sample Method
  4. In CIWSQLXP1125 on the SOBI_QUALITY database, run script 1 with the copied sample method.
    • If there is a part of the Sample Method containing d.LeadTeamName, delete that condition
  5. Check data to see what is getting pulled
  6. If a work_request_item number is provided, add that as part of the query and remove other conditions until it appears
  7. When you've identified which part condition is preventing the audit from coming in, inform business

Script 1

select * from dbo.APP_CORR_SOBI_CALL_CLAIM
where task_end_date > (getdate() - 7) and -- sample method goes here