Answers.Body: <p>Welcome to SE!  The first thing to note is that if you're on 4.6.36 you really need to upgrade.  There have been numerous security fixes and functionality enhancements since then.  You will also need to upgrade your version of php.  But that's not what you asked...</p>
  <p>I needed to investigate mails with a status of 'unknown' recently.  The standard reports did not show what I wanted but the SQL behind them is a useful starting point.</p>
  <p>From the <code>Mailings &gt; Scheduled and Sent Mailings</code> screen, find the mailing of interest and click on <code>Report</code>.  On the <code>Successful Deliveries</code> line, click on <code>Report</code> and then go to the <code>Developer</code> tab.  From there you can copy the SQL, modify it a bit and paste it into a SQL session. How you modify it depends on what you want to know, but you will want to remove the 'where' clause that limits it to successful mails.</p>
  <p>Things have changed a lot since 4.6 so this may not work for you.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-02T11:02:47.700Z
Answers.LastActivityDate: 2021-03-02T11:02:47.700Z
Answers.UserDisplayName: Aidan
Body: <p>I am trying to see all the emails, where the delivery status was &quot;unknown&quot;. I have been trying to change the URL parameter &quot;delivery_status_value&quot; to &quot;unknown&quot;, but that gives a fail as a response. Which value should I use for querying? Or is there another way of filtering the recipients, which's delivery status is unknown? I would have downloaded the excel/CSV file, but that does not seem to work on our system.</p>
  <p>The version we use is 4.6.36.</p>
  <p>Thank you very much for your help!</p>
  
Tags: <civimail>
Title: How to query "delivery status = unknown" on CiviMail report
ThreadText: # How to query "delivery status = unknown" on CiviMail report
  
  (Asked by: username_0 on 2021-03-02)
  
  I am trying to see all the emails, where the delivery status was "unknown". I have been trying to change the URL parameter "delivery\_status\_value" to "unknown", but that gives a fail as a response. Which value should I use for querying? Or is there another way of filtering the recipients, which's delivery status is unknown? I would have downloaded the excel/CSV file, but that does not seem to work on our system.
  
  The version we use is 4.6.36.
  
  Thank you very much for your help!
  
  **Tags:** civimail
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-03-02. Score: 2
  
  Welcome to SE! The first thing to note is that if you're on 4.6.36 you really need to upgrade. There have been numerous security fixes and functionality enhancements since then. You will also need to upgrade your version of php. But that's not what you asked...
  
  I needed to investigate mails with a status of 'unknown' recently. The standard reports did not show what I wanted but the SQL behind them is a useful starting point.
  
  From the `Mailings > Scheduled and Sent Mailings` screen, find the mailing of interest and click on `Report`. On the `Successful Deliveries` line, click on `Report` and then go to the `Developer` tab. From there you can copy the SQL, modify it a bit and paste it into a SQL session. How you modify it depends on what you want to know, but you will want to remove the 'where' clause that limits it to successful mails.
  
  Things have changed a lot since 4.6 so this may not work for you.
  
  
  ---
  
  