We use a completely home grown application and had similar issues in relationship to name changes and such. We ended up writing a stored procedure that populates temp tables with lists of tables that contain specific fields, and then loops through those temp tables and updates values from a to b...it seems to work well without causing massive filter bog...that's both a good and a bad depending on what you are looking for.
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A. Sent: Thursday, August 28, 2008 11:12 AM To: arslist@ARSLIST.ORG Subject: Re: Changing username and name in ARS - Need advice ** You are not the first one to find out this glaring issue. Our Login IDs are based on our Corporate network IDs which are based on the names of people as well so when names change so do our login IDs. This of course creates issues if you SAP (or other HR system) integration uses the Login ID or Corporate Network ID as the key for the feed then this will break on a name change so you have to use some other unique identifier for your integration. You need to account for not just CTM:People and User but also a number of other CTM Support forms and any of the key ITSM forms such as HPD:Help Desk, CHG:Infrastructure Change, TMS:Task, and PBM:Problem Investigation. Not to mention that that person or people that have their named changed might have CIs associated to them so you need to update their name in AST:AssetPeople. Many times people asked why Remedy never has this process setup but I am guessing they never really thought of this as a design flaw. We do have other systems here that do not account for name changes very well so I am not too shocked. Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jim Coryat Sent: Thursday, August 28, 2008 12:46 PM To: arslist@ARSLIST.ORG Subject: Changing username and name in ARS - Need advice ** We are running ARS 7.1, with the ITSM suite version 7.0.01. We have implementing an identity management solution and as part of that we need to handle changing usernames and their full names through automation. Currently we have a process that imports the user data from SAP and inserts, updates, deletes the corresponding user in Remedy. We utilize LDAP for authentication so password management is not an issue. On an initial query I found ~26 forms that look to be of interest that may need to be updated. I excluded log files due to the fact that it is history and wanted to avoid changing history. Asking BMC support why their application does not do this out of the box, I basically got the blank stare and "It functions as designed". How do you handle username and name changes for users without breaking the relationships created in the ITSM suite? I find it hard to believe I am the first to come across this. Thank you for any advice you can spare, Jim Coryat __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _____ Please consider the environment before printing this e-mail. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"