March 9, 2011 at 1:28 pm
has anyone done this? is it as straight forward as a CSV file? i want to import the logs into a database to run daily reports of any errors
March 10, 2011 at 10:00 am
Take a look at the report server tables:
ExecutionLogStorage
Subscriptions
You should be able to build your reports right off of them. Beware of relying only on the ExecutionLogStorage, I have seen false Success in the Status column. I usually refer to the Subscriptions.LastStatus column for the most recent errors.
Also if you use the mail functions of the Report Manager and subscriptions are not running properly, your errors report may not execute automatically.
March 10, 2011 at 11:55 am
thx
not that big a deal but we've had trouble where sales people who are constantly turning over are on report emails and when they leave the subscription fails because the BI devs hard coded email addresses instead of using distro lists
March 10, 2011 at 4:50 pm
With regard to your sales turnover issue. If the reports are individualized, try putting together a data driven subscription that queries a db somewhere that holds reasonably accurate employee data such as your HR db or even Active Directory. If the reports are not sales rep specific, change the subscription to send to a distribution list, that hopefully is maintained.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply