Post reply

Identifying SSRS Subscription Users

  • July 27, 2012 at 8:29 am

    #259505

    Hello

    We have an external facing custom .NET website that allows clients to run reports. We authenticate external users using forms authentication. Once they are authenticated, they are redirected to landing page and from there they can run a set of reports.

    Once a user ran a report, he/she subscribes to the report to be delivered by email. I would like to know who the user is from reportserver's subscriptions table.

    We cannot use AD otherwise this wouldn't have been an issue.

    Is there anything I can do to achieve the above?

    Thanks in Advance.

  • July 27, 2012 at 10:44 am

    #1518647

    Does this work for you?

    use ReportServer

    go

    SELECT UserName, sub.*

    FROM dbo.Subscriptions sub

    inner join dbo.Users u on sub.OwnerID = u.UserID

  • July 31, 2012 at 2:34 am

    #1519571

    This would have worked but we don't have external users in the Users table. They all are in a custom apsnetdb database.

  • July 31, 2012 at 4:54 am

    #1519610

    Ok, I see. What values are listed in the OwnerId field of the subscriptions table?

    Thanks

  • July 31, 2012 at 6:04 am

    #1519646

    OwnerID field has no value. It is blank because we have not yet created any subscriptions. On Non-Production environment we have created and tested subscriptions but not on LIVE.

    On LIVE, we want to see the UserID/UserName of an external user such as 'User123'.

    Thanks for your help.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply