ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Delete subscriptions massively for certain user
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

roquesalde

Argentina
38 Posts

Posted - 01/21/2022 :  08:57:53  Show Profile  Click to see roquesalde's MSN Messenger address  Reply with Quote
Hi Admin!

Currently in our instance we have a couple of users with dozens of subscriptions and those users are no longer part of the company so we want to remove all of the subscriptions related to the specific user, but we donĀ“t want to delete the user.

Exists any method to remove all subscriptions for specific user? Maybe using some script...

Thanks in advance.
Roque

admin

1637 Posts

Posted - 01/21/2022 :  09:35:41  Show Profile  Reply with Quote
delete ju
from JobUser ju
join AppUser u on u.UserId = ju.UserId
where u.UserName = 'UserName1'

select j.JobName, u.UserName
from Job j
join JobUser ju on ju.JobId = j.JobId
join AppUser u on u.UserId = ju.UserId
where u.UserName = 'UserName1'
Go to Top of Page

roquesalde

Argentina
38 Posts

Posted - 01/21/2022 :  09:57:07  Show Profile  Click to see roquesalde's MSN Messenger address  Reply with Quote
Thank you!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page