Thanks for the kind words, I was just the first to respond, there are many others here that have the same understanding of the ITSM4/5/6/7 "guts".
The lack of a proper data-dictionary for the V4/5/6/7 products has been the "Learning Factor" for all administrators. Before good analysis tools, it was the school of hard-knocks - ActLink+Filter logging and go "press the button" so to say... This is also the case for V7, a limited dictionary exists but it is not complete from what I have noticed. In both Pre-7 and 7 ITSM there are "Core Forms" like in V6 SHR:People which is now CTM:People in V7 (the rename was just to keep us on our toes..). Then the Applications (Incident / Change / ..) all ride logically "on top of" these, because without the foundation a pillar cannot be built. (unless you happen to reside in the town of Pisa :) ..) So short of using some form of "Workflow Documenter Toolset" (Panacea, RRTools, BMC Tools, Master Suite..) you also will be forced to either ASK or TRACE... Maybe one of the BMC Insider'ers has some "internal documentation" but nothing comes WITH the product(s) that would be of assistance in this area :( 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 10:48 AM To: arslist@ARSLIST.ORG Subject: Re: Removing mass amount of Users 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: arslist@ARSLIST.ORG > 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: arslist@ARSLIST.ORG > > 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
