You should have a relationship on End User to Incident because I believe that's where "Raise User" is pulled from. You will probably need to run your query against "User" and in the criteria you should be able to pull information from Incident. if you cannot, then just make that relationship between the two (saying No to the question) and that should get you where you want to be.
Just make sure you run your query against End User or User and you should be able to do the Right Click/delete from that query.
Let us know how it works.
1 of 1 people found this helpful
Hi Jason, Jamie,
Creating a new relationship won't help because each relationship is independant. You already have at least three relationships from Incident to User (Raise User, Create User, Last Update User) so there is no way to tie a new relationship the other direction to one of those.
You can easily query against the Incident object and display the Raise User and even group by the Raise User to find the records you want, however you would need to go elsewhere to delete them.
I hope that helps.
I'm trying to set up a bulk delete of end users but I can't see how it would work.
I guess you could put a condition in your workflow that would check for a Category of "Remove User" when the ticket gets resolved and when it finds one have the system set a flag on the User account for the Raise User to true (have a boolean called "Delete User" or something on the User form). Then just schedule a bulk remove for accounts there "Delete User" is true.
I haven't tried auto setting this up before but it should work. I am actually going to try it today in a test bed.
I just did this and it worked. I created a relationship between User and Incident and called it End User. Added an "Update Related" action to the new End User called "Remove". I had to add the End User field to the form and added the "Remove" action to the workflow. Once I added Remove I populated a "to be removed" boolean as true and it flagged it.
You can then write a query against user to show all "to be removed" flags that equal true. From that query you can then delete them.
I hope this helps. It's a few steps but might be worth the time.
I'll have a go with that one
You would probably want to do this under the Request module since it's more of a request than an Incident.