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"
