title: See SSRS subscriptions via SSL query? Query to generate parameters.
body: <p>I am a setting up a test SSRS server to work "just like production, just a little different".  I got the reports, the tempDB, and all the datasets working. </p>
  
  <p>Need help on subscriptions. 
  Production server has a small number of subscriptions, and I can see them through the browser UI.  However, it doesn't show where it pushes the report files. </p>
  
  <blockquote>
    <p>Update: found a way to see where the files are dropped, in the
    Subscription Manager tool.  Still looking for how the parameters are
    generated when the report is run through subscription. There is one
    parameter that doesn't have a default and requires input when report
    is run manually.</p>
  </blockquote>
  
  <p>Is where a way to see the subscription information by running a SQL query(-ies)? 
  Is it possible to set up subscriptions by inserting data into tables directly, without dealing with the UI? </p>
  
  <p><a href="https://i.stack.imgur.com/WwjPq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WwjPq.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/BjBA8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BjBA8.png" alt="enter image description here"></a></p>