ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Message:

* HTML is ON
* Forum Code is OFF

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
roquesalde	Posted - 11/10/2021 : 11:08:26 Hi! I need to list all subscriptions for any user logged into RP, I could build a query to get that information but I don´t know how to get the user logged in order to filter the query and only show subscriptions for that particular user. I tried using SUSER_SNAME() but I am getting the SQL user configured in the connection, and I need the RP user. Any idea? Thanks, Roque
2 L A T E S T R E P L I E S (Newest First)
roquesalde	Posted - 11/15/2021 : 19:23:19 Thank you very much!
admin	Posted - 11/11/2021 : 20:04:48 Please try the Job, JobUser and AppUser tables: http://www.reportportal.us/ReportPortal/help/index.aspx?page=architecture.htm http://www.reportportal.us/ReportPortal/help/images/ERD/Scheduler.gif

ReportPortal