ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Delete subscriptions massively for certain user

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
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
roquesalde Posted - 01/21/2022 : 08:57:53
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
2   L A T E S T    R E P L I E S    (Newest First)
roquesalde Posted - 01/21/2022 : 09:57:07
Thank you!
admin Posted - 01/21/2022 : 09:35:41
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'

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page