You are the man Robert! The man! I didn't realize all the forms the user was tied to. And your right, the functionality of deleting a user is broken as I sometimes see ghost users when we assign Change tickets.
Thanks a lot. Saves me some time trying to back trace everything ( though I need to do it anyway to get myself more knowledge of how the Configuration utility and change module work). By the way, is there any technical docs on how these two modules work together? Or am I forced to go through the workflow? On 8/21/07, Robert Molenda <[EMAIL PROTECTED]> wrote: > No problem, we all sometimes press the SEND button a sentence short of a > full-email ;) > > Unless they corrected it in ITSM6 the workflow on delete of 'User' table > records does not cascade into the "Application"... And update of > SHR:People "Support Staff" from Yes to No did not clean up the > "Application" either. > > So, here you go, you can create ONE FILTER on User for Delete to do the > below indicated actions, just remember that the cleanup must be > performed to the application forms... (as well as any custom forms which > might contain user references) I like to use the > "Application-Delete-Entry-Query" process to do these things... > > First ensure the server is setup in "Development Cache" mode. > Backup The Database (CYA Measure :) ) > > AR System User Preference - Delete records where 'Login Name' = $Login > Name$ > > SHR:Assignment - Delete records where 'Assignee Type' = "In Group with > Skills" AND 'LoginIndivOrGroup' = $Login Name$ > > SHR:PersonalPreferences - Delete records where 'Login Name+' = $Login > Name$ > > SHR:Reminders - Delete records where 'AR Login' = $Login Name$ > > SHR:People - Update the record, set Support Staff = No (You could delete > it if not needed) > > Restart the ARSystem > > OPTIONALLY: > > Update CHG:Change - Set 'Supervisor Name+' = $NULL$ where 'Supervisor > Name+' = $Full Name$ > > Update CHG:Task - Set 'Implementor Name+' = $NULL$ where 'Implementor > Name+' = $FULL NAME$ > > Delete from CHG:ApprovalID where 'Approver Login' = $USER$ > > I think that is about it. > > HTH > > Thanks-n-advance; > HDT Platform Incident / Problem Manager & Architect > Robert Molenda > IT OS PA > Tel: +1 408 503 2701 > Fax: +1 408 503 2912 > Mobile: +1 408 472 8097 > [EMAIL PROTECTED] > Quality begins with your actions. > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Robert Halstead > Sent: Tuesday, August 21, 2007 9:55 AM > To: [email protected] > Subject: Re: Removing mass amount of Users > > I'm sorry, I should have stated that first lol. I'm running Remedy > 6.3 with the Change Management module and configuration module. I'm > pretty sure it's not ITSM but just the Change Module. Has a bunch of > SHR and SHRCFG forms I know that. > > On 8/21/07, Robert Molenda <[EMAIL PROTECTED]> wrote: > > What version of ARS & Application(s) are you running? My answer might > be > > different... > > > > Thanks-n-advance; > > HDT Platform Incident / Problem Manager & Architect > > Robert Molenda > > IT OS PA > > Tel: +1 408 503 2701 > > Fax: +1 408 503 2912 > > Mobile: +1 408 472 8097 > > [EMAIL PROTECTED] > > Quality begins with your actions. > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Robert Halstead > > Sent: Tuesday, August 21, 2007 8:34 AM > > To: [email protected] > > Subject: Removing mass amount of Users > > > > I'm wondering if I can't run an escalation to remove a bunch of users > > out of our test environment. We're using the configuration utility in > > Remedy and I know that I could just do a wipe of the user form but I > > want all the other data the configuration utility stores in other > > forms gone too. We're trying to make development more like production > > and I plan to only have our testers in development. Is there a way to > > quickly do this? Or do I need to go through each user and manually > > click delete in the Configuration utility? > > > > -- > > "A fool acts, regardless; knowing well that he is wrong. The ignoramus > > acts on only what he knows, but all that he knows. > > The ignoramus may be saved, but the fool knows that he is doomed." > > > > Robert Halstead > > > > > ________________________________________________________________________ > > _______ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > ARSlist:"Where > > the Answers Are" > > > > > ________________________________________________________________________ > _______ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > ARSlist:"Where the Answers Are" > > > > > -- > "A fool acts, regardless; knowing well that he is wrong. The ignoramus > acts on only what he knows, but all that he knows. > The ignoramus may be saved, but the fool knows that he is doomed." > > Robert Halstead > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > -- "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed." Robert Halstead _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
