chjquest - Friday, July 28, 2017 12:36 PMHi Sue,I just tried one report with subscription on my end, see screenshot.
My first entry is the subscription run. Not sure why it's not working on your end. The parameter is saved in a customized table in a customized database.As for the recipient, I can't find it - it could/may be saved somewhere (if exists), but for history, I didn't research that, will take sometime to see where the subscription information/data saved.
One thing to mention, run my script in ReportServer database, not system (msdb, master or others). And sorry for my bad wording, it should be "Parameters" column, just I kept thought it's URL format (jumping in between my work and posting).
Sorry for the mass editing, want to make sure the image I uploaded is clear enough and does not contain any information may get myself fired~
It is working fine from my end and I see no email address in any table. I believe you said it was in the parameters column of the ExecutionLog3 view. I don't believe that is correct.
It's not a data driven subscription and the parameters are in the subscription table. And you state that you can't find the recipient. It's in the subscription table - no need to research it. This is what you said:
will take sometime to see where the subscription information/data saved
and that is exactly what is discussed in this thread. That is what you told the OP they could get. So I'm confused as the subscription information is in the subscription table in the ReportServer database. Delete a subscription and it's not in that table anymore. And there are no backups. You said you can recreate them but you don't know where the information is? That doesn't make much sense.
And I just noticed another thing -
The report with the 224 missed one could be found from the system table - if they have good backup and kept long enough.
Assuming those 224 subscriptions just ran, all parameters will be saved in the report database/table in URL format.
It's 224 subscriptions and they all had parameters. And we had already discussed they don't have a backup. So that is the question - they have no backup, the subscriptions have all been deleted from the new report, the old report would be in an old backup in the catalog table in the ReportServer database. And that would not have the parameters saved with it. When you have 224 subscriptions to a report, the report doesn't update on every subscription added and put parameters in it. The parameters would be in the subscription table in the ReportServer database. And they do not have a backup of the database and the subscriptions are all gone.
So...what is the method for the poster to recreate all 224 of the non-data driven subscriptions and provide all of the original parameters? I see your posts but I still don't see how that can happen and you said you were unable to find the recipient on your test. I just deleted one of my reports that I subscribed to. I just redeployed the report. Tell me how to recreate the subscription with no backup?
Sue