RE: Changing a Remedy Login ID In Bulk
I just realised I was responding to an email from May 2015. A bit of a delayed response I’m afraid. I was in an archive data file and it was the top message. I’ll blame age. Cheers Ben From: Ben Chernys Sent: December-18-18 8:21 AM To: 'arslist@ARSLIST.ORG' Subject: RE: Changing a Remedy Login ID In Bulk We wrote a Meta-Update script called Databot <http://www.softwaretoolhouse.com/> which works exactly like the BMC Data Wizard (by default). It will read a spreadsheet of changes in login id (amongst all the other possibilities) and effect the changes across all forms (according to the config). It works by SQL but can be configured to use the Merge API on an individual form basis when needed for workflow and integrations. Adding your own forms is as easy as adding a line to a spreadsheet. It is extensible – that is, you can configure your own “Data Admin” jobs and sports an “Undo” feature. It is free with Meta-Update and is included in free Meta-Update trials. Cheers, Ben Chernys Senior Software Architect Canada / Deutschland Mobile:+49 171 380 2329 GMT - 7 + [ DST ] Mobile +1 403 554 0887 Email:<mailto:Ben.Chernys_AT_softwaretoolhouse.com> Ben.Chernys_AT_softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. <http://www.softwaretoolhouse.com/product/SthMupd/index.html> Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/product/SthArch/index.html> Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as a complete tree and checking associatuions. Archive output to different servers, HTML pages with links to attachments or archive forms. <http://www.softwaretoolhouse.com/product/Databot/index.html> Meta-Databot is an automated, extensible BMC Data Wizard. It reads a file of data changes and sports an Undo feature. Pre ITSM 18.08? Clarify? HP? Roll your own? No problem! You can keep your valuable data! <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) mailto:arslist@ARSLIST.ORG> > On Behalf Of Timothy Powell Sent: May-14-15 9:56 AM To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> Subject: Re: Changing a Remedy Login ID In Bulk ** I can’t speak to ITSM 8.1 because we have not yet upgraded to it, but in ITSM 7.6.04, you can do this using the Out-of-Box Data Wizard. In 7.6.04 this is located at: Application Administration Console/Custom Configuration (tab)/Foundation/Data Management Tool/Data Wizard Console HTH, Tim From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Scott Hallenger Sent: Thursday, May 14, 2015 11:23 AM To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> Subject: Changing a Remedy Login ID In Bulk ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change "jdowe" to "jdowe1", is it possible to do this through export & re-import. _ARSlist: "Where the Answers Are" and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.com <http://www.avg.com> Version: 2015.0.5863 / Virus Database: 4342/9775 - Release Date: 05/14/15 _ARSlist: "Where the Answers Are" and have been for 20 years_ -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
RE: Changing a Remedy Login ID In Bulk
We wrote a Meta-Update script called Databot <http://www.softwaretoolhouse.com/> which works exactly like the BMC Data Wizard (by default). It will read a spreadsheet of changes in login id (amongst all the other possibilities) and effect the changes across all forms (according to the config). It works by SQL but can be configured to use the Merge API on an individual form basis when needed for workflow and integrations. Adding your own forms is as easy as adding a line to a spreadsheet. It is extensible – that is, you can configure your own “Data Admin” jobs and sports an “Undo” feature. It is free with Meta-Update and is included in free Meta-Update trials. Cheers, Ben Chernys Senior Software Architect Canada / Deutschland Mobile:+49 171 380 2329 GMT - 7 + [ DST ] Mobile +1 403 554 0887 Email:<mailto:Ben.Chernys_AT_softwaretoolhouse.com> Ben.Chernys_AT_softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. <http://www.softwaretoolhouse.com/product/SthMupd/index.html> Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/product/SthArch/index.html> Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as a complete tree and checking associatuions. Archive output to different servers, HTML pages with links to attachments or archive forms. <http://www.softwaretoolhouse.com/product/Databot/index.html> Meta-Databot is an automated, extensible BMC Data Wizard. It reads a file of data changes and sports an Undo feature. Pre ITSM 18.08? Clarify? HP? Roll your own? No problem! You can keep your valuable data! <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) On Behalf Of Timothy Powell Sent: May-14-15 9:56 AM To: arslist@ARSLIST.ORG Subject: Re: Changing a Remedy Login ID In Bulk ** I can’t speak to ITSM 8.1 because we have not yet upgraded to it, but in ITSM 7.6.04, you can do this using the Out-of-Box Data Wizard. In 7.6.04 this is located at: Application Administration Console/Custom Configuration (tab)/Foundation/Data Management Tool/Data Wizard Console HTH, Tim From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Scott Hallenger Sent: Thursday, May 14, 2015 11:23 AM To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> Subject: Changing a Remedy Login ID In Bulk ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change "jdowe" to "jdowe1", is it possible to do this through export & re-import. _ARSlist: "Where the Answers Are" and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.com <http://www.avg.com> Version: 2015.0.5863 / Virus Database: 4342/9775 - Release Date: 05/14/15 _ARSlist: "Where the Answers Are" and have been for 20 years_ -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
AD: Changing a Remedy Login ID In Bulk
We have a script that does this through the API and changes all forms’ data (status history, assignments, etc). Input is a set of new and old logins. It runs off a configuration spreadsheet and so bespoke forms and fields can be added to the easily. The script generates a CSV of all forms and fields changed. It is not a free product though the script is available for free. Cheers Cheers, Ben Chernys Senior Software Architect logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as the tree of data and forms that it is it is. Pre ITSM 7.6.04? Clarify? Roll your own? No problem! You can keep your valuable data! http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Scott Hallenger Sent: May-14-15 09:23 To: arslist@ARSLIST.ORG Subject: Changing a Remedy Login ID In Bulk ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import. No virus found in this message. Checked by AVG - www.avg.com Version: 2015.0.5863 / Virus Database: 4342/9775 - Release Date: 05/14/15 _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years smime.p7s Description: S/MIME cryptographic signature
Re: Changing a Remedy Login ID In Bulk
I suppose, but consider things like pending approvals, which are all dependent on the login ID present when the record was created. Unless you update those records to match, they become orphans. Rick On May 14, 2015 8:24 AM, Scott Hallenger vadr...@yahoo.com wrote: ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Changing a Remedy Login ID In Bulk
Scott, You may want to check out this utility https://communities.bmc.com/docs/DOC-33524 On Thu, May 14, 2015 at 9:22 AM, Scott Hallenger vadr...@yahoo.com wrote: ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Changing a Remedy Login ID In Bulk
Yes...Curtis has offered that tool for Free, to the best of my knowledge... On Thu, May 14, 2015 at 9:58 AM, Scott Hallenger vadr...@yahoo.com wrote: ** LJ thank you. That tool sounds like a winner. I didn't see anything about costs though. Are you going to blow my mind and tell me its free! On Thursday, May 14, 2015 11:29 AM, LJ LongWing lj.longw...@gmail.com wrote: ** Scott, You may want to check out this utility https://communities.bmc.com/docs/DOC-33524 On Thu, May 14, 2015 at 9:22 AM, Scott Hallenger vadr...@yahoo.com wrote: ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Changing a Remedy Login ID In Bulk
Hello Lister's,I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Changing a Remedy Login ID In Bulk
I can’t speak to ITSM 8.1 because we have not yet upgraded to it, but in ITSM 7.6.04, you can do this using the Out-of-Box Data Wizard. In 7.6.04 this is located at: Application Administration Console/Custom Configuration (tab)/Foundation/Data Management Tool/Data Wizard Console HTH, Tim From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Scott Hallenger Sent: Thursday, May 14, 2015 11:23 AM To: arslist@ARSLIST.ORG Subject: Changing a Remedy Login ID In Bulk ** Hello Lister's, I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Changing a Remedy Login ID In Bulk
LJ thank you. That tool sounds like a winner. I didn't see anything about costs though. Are you going to blow my mind and tell me its free! On Thursday, May 14, 2015 11:29 AM, LJ LongWing lj.longw...@gmail.com wrote: **Scott,You may want to check out this utilityhttps://communities.bmc.com/docs/DOC-33524 On Thu, May 14, 2015 at 9:22 AM, Scott Hallenger vadr...@yahoo.com wrote: **Hello Lister's,I was wondering if it is possible to update/change an existing Remedy login ID of it were to be exported with its GUID or entry ID and then re-imported with the changed info. I'm on ITSM 8.1. For example, if I wanted to change jdowe to jdowe1, is it possible to do this through export re-import._ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Hude Login ID Conversion
I have published a free utility written that has similar capabilities to Misi's RRR|LoginConv using the Java API and posted the write-up and download here: http://soleauthority.net/login-converter-utility-for-mass-updating-login-ids/ It hasn't gone through exhaustive testing as of yet but I would welcome anybody testing it and providing feedback for further improvements. Here is a quick list of capabilities it provides: - High performance updates from an old LoginID to a new LoginID utilizing merge action that bypasses workflow - Single update or define multiple Login ID updates for a single pass - Updates all Character Fields (regardless of size) - Match exact - (optional) Match surrounded by single/double quotes - (optional) Match surrounded by separators such as white-space, comma, period, pipe, semi-colon or colon - (optional) Updates all Status History entries - (optional) Updates all Diary Field entries And here is a list of nice features above and beyond the core capability: - Two progress bars show displaying progress by the currently processing form and the overall end to end process. - Ability to control the speed by way of a delay slider that will slow down or speed up the processing dynamically - Ability to pause / resume the processing - Ability to cancel in-flight updates (doesn’t not roll back, just stops wherever it happens to be) - Ability to toggle on/off the scope/matching capabilities - Ability to specify all forms to be checked or a specific form only - Ability to ‘simulate’ the run without actually make any changes - Detailed output provided on forms processed and matches found Cheers, On Mon, Sep 29, 2014 at 3:01 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, The RRR|LoginConv worked just fine, but it is written in ARSperl which has kind not been recently updated. So there is a problem when getting the field list from some forms in ITSM (not data, just info about the fields)... I am looking for a sponsor to be able to rewrite it in C or Java. Please let me know if that could be you. It is not a big program, and might take around 40 hours or so to re-write. Using the API, as RRR|LoginConv does, takes considerable time to complete. But by prioritizing the order in which forms and records are converted, you should be able to do the important stuff during a weekend. Then the tool can munch on to convert historical data in a more leisurely manner. RRR|LoginConv exchanges text fields up to 254 characters in length. It does fix the lists in the 112 and 60xxx fields, as well as Status-History and Diary-fields. If it finds a quoted match in a char-field, that will be exchanged as well. It performs one read and one write per record, regardless of the number of fields/logins that is converted on that record, and you should be able to run several in parallel to speed things up. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I would recommend https://rrr.se/cgi/tools/main?tool=rrrLoginConv On Mon, Sep 29, 2014 at 11:02 AM, Frank Caruso caruso.fr...@gmail.com wrote: ITSM 764 sp2, Oracle, Weblogic We have been asked to determine the difficulty/feasibility in converting all Login IDs and Corporate IDs to new values. The unique values currently used must be eliminated from every field in the application: Submitter, Last Modified By, contained within a notes/description field and all custom forms. We have over 1 million HPD records and millions of other ancillary tables; audit, work log, assignments, searches, etc. I looked at the Data Wizard Console (DWC) and it does allow Login IDs to be changed; it appears to search across 408 tables in ITSM. But it does not handle corporate id, can only be run for a single ID, does not search inside text fields and does not handle custom forms. It also looks like a process that will take a very long time to run. Looking for any thoughts on performing such a task; maybe some tricks other have come up? Thank you. Frank Caruso ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers
Hude Login ID Conversion
ITSM 764 sp2, Oracle, Weblogic We have been asked to determine the difficulty/feasibility in converting all Login IDs and Corporate IDs to new values. The unique values currently used must be eliminated from every field in the application: Submitter, Last Modified By, contained within a notes/description field and all custom forms. We have over 1 million HPD records and millions of other ancillary tables; audit, work log, assignments, searches, etc. I looked at the Data Wizard Console (DWC) and it does allow Login IDs to be changed; it appears to search across 408 tables in ITSM. But it does not handle corporate id, can only be run for a single ID, does not search inside text fields and does not handle custom forms. It also looks like a process that will take a very long time to run. Looking for any thoughts on performing such a task; maybe some tricks other have come up? Thank you. Frank Caruso ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Hude Login ID Conversion
I would recommend https://rrr.se/cgi/tools/main?tool=rrrLoginConv On Mon, Sep 29, 2014 at 11:02 AM, Frank Caruso caruso.fr...@gmail.com wrote: ITSM 764 sp2, Oracle, Weblogic We have been asked to determine the difficulty/feasibility in converting all Login IDs and Corporate IDs to new values. The unique values currently used must be eliminated from every field in the application: Submitter, Last Modified By, contained within a notes/description field and all custom forms. We have over 1 million HPD records and millions of other ancillary tables; audit, work log, assignments, searches, etc. I looked at the Data Wizard Console (DWC) and it does allow Login IDs to be changed; it appears to search across 408 tables in ITSM. But it does not handle corporate id, can only be run for a single ID, does not search inside text fields and does not handle custom forms. It also looks like a process that will take a very long time to run. Looking for any thoughts on performing such a task; maybe some tricks other have come up? Thank you. Frank Caruso ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Hude Login ID Conversion
This utility for finding strings anywhere in the database might help you show how difficult that task would be: Simple Utility for finding strings in database: https://communities.bmc.com/docs/DOC-33105 It won’t change the data for you but if you enter run it twice (once for a login ID and once for a corporate ID) you may be surprised at how many places such data might be squirreled away. I would run it against a non-production server if at all possible though since I don’t know what kind of performance hit it might cause. -Rick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, September 29, 2014 10:11 AM To: arslist@ARSLIST.ORG Subject: Re: Hude Login ID Conversion ** I would recommend https://rrr.se/cgi/tools/main?tool=rrrLoginConv On Mon, Sep 29, 2014 at 11:02 AM, Frank Caruso caruso.fr...@gmail.commailto:caruso.fr...@gmail.com wrote: ITSM 764 sp2, Oracle, Weblogic We have been asked to determine the difficulty/feasibility in converting all Login IDs and Corporate IDs to new values. The unique values currently used must be eliminated from every field in the application: Submitter, Last Modified By, contained within a notes/description field and all custom forms. We have over 1 million HPD records and millions of other ancillary tables; audit, work log, assignments, searches, etc. I looked at the Data Wizard Console (DWC) and it does allow Login IDs to be changed; it appears to search across 408 tables in ITSM. But it does not handle corporate id, can only be run for a single ID, does not search inside text fields and does not handle custom forms. It also looks like a process that will take a very long time to run. Looking for any thoughts on performing such a task; maybe some tricks other have come up? Thank you. Frank Caruso ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Hude Login ID Conversion
I might suggest reading in the documentation about the Authentication Alias, if you haven't already. Using that might be an alternative to changing out all of the values. Don't forget you also have Login ID in pending Change approvals and such. Those records can be tricky to transition. Rick Cook On Mon, Sep 29, 2014 at 10:55 AM, Rick Westbrock rwestbr...@24hourfit.com wrote: ** This utility for finding strings anywhere in the database might help you show how difficult that task would be: *Simple Utility for finding strings in database:* https://communities.bmc.com/docs/DOC-33105 It won’t change the data for you but if you enter run it twice (once for a login ID and once for a corporate ID) you may be surprised at how many places such data might be squirreled away. I would run it against a non-production server if at all possible though since I don’t know what kind of performance hit it might cause. -Rick *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing *Sent:* Monday, September 29, 2014 10:11 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Hude Login ID Conversion ** I would recommend https://rrr.se/cgi/tools/main?tool=rrrLoginConv On Mon, Sep 29, 2014 at 11:02 AM, Frank Caruso caruso.fr...@gmail.com wrote: ITSM 764 sp2, Oracle, Weblogic We have been asked to determine the difficulty/feasibility in converting all Login IDs and Corporate IDs to new values. The unique values currently used must be eliminated from every field in the application: Submitter, Last Modified By, contained within a notes/description field and all custom forms. We have over 1 million HPD records and millions of other ancillary tables; audit, work log, assignments, searches, etc. I looked at the Data Wizard Console (DWC) and it does allow Login IDs to be changed; it appears to search across 408 tables in ITSM. But it does not handle corporate id, can only be run for a single ID, does not search inside text fields and does not handle custom forms. It also looks like a process that will take a very long time to run. Looking for any thoughts on performing such a task; maybe some tricks other have come up? Thank you. Frank Caruso ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Hude Login ID Conversion
Hi, The RRR|LoginConv worked just fine, but it is written in ARSperl which has kind not been recently updated. So there is a problem when getting the field list from some forms in ITSM (not data, just info about the fields)... I am looking for a sponsor to be able to rewrite it in C or Java. Please let me know if that could be you. It is not a big program, and might take around 40 hours or so to re-write. Using the API, as RRR|LoginConv does, takes considerable time to complete. But by prioritizing the order in which forms and records are converted, you should be able to do the important stuff during a weekend. Then the tool can munch on to convert historical data in a more leisurely manner. RRR|LoginConv exchanges text fields up to 254 characters in length. It does fix the lists in the 112 and 60xxx fields, as well as Status-History and Diary-fields. If it finds a quoted match in a char-field, that will be exchanged as well. It performs one read and one write per record, regardless of the number of fields/logins that is converted on that record, and you should be able to run several in parallel to speed things up. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I would recommend https://rrr.se/cgi/tools/main?tool=rrrLoginConv On Mon, Sep 29, 2014 at 11:02 AM, Frank Caruso caruso.fr...@gmail.com wrote: ITSM 764 sp2, Oracle, Weblogic We have been asked to determine the difficulty/feasibility in converting all Login IDs and Corporate IDs to new values. The unique values currently used must be eliminated from every field in the application: Submitter, Last Modified By, contained within a notes/description field and all custom forms. We have over 1 million HPD records and millions of other ancillary tables; audit, work log, assignments, searches, etc. I looked at the Data Wizard Console (DWC) and it does allow Login IDs to be changed; it appears to search across 408 tables in ITSM. But it does not handle corporate id, can only be run for a single ID, does not search inside text fields and does not handle custom forms. It also looks like a process that will take a very long time to run. Looking for any thoughts on performing such a task; maybe some tricks other have come up? Thank you. Frank Caruso ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Hude Login ID Conversion
I've got the bulk of the framework already developed using the Java API for this that I would just need to finish. Right now it will update loginIDs based on exact match of any character field (regardless of size) but extending it out to do inline replace across fields where it 'contains' the loginID rather then being an exact match only isn't that much additional work (and also diaries status-history). I'd also need to add a parser so that you can pass it in a list of login IDs to check/update similar to RRR|LoginConv. All the other stuff your tool does would be gravy but not critical to the core usecase and could be added over time. I figure I'll have time to spend on it between now and BMC Engage so I'll hopefully have the utility posted on my site (http://www.soleauthority.net) before then. If anybody is interested in being a guinea pig and have a DEV system they don't mind backing up / restoring as needed that has a lot of actual data (e.g. year or more of buildup), you can contact me offlist. Cheers, On Mon, Sep 29, 2014 at 3:01 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, The RRR|LoginConv worked just fine, but it is written in ARSperl which has kind not been recently updated. So there is a problem when getting the field list from some forms in ITSM (not data, just info about the fields)... I am looking for a sponsor to be able to rewrite it in C or Java. Please let me know if that could be you. It is not a big program, and might take around 40 hours or so to re-write. Using the API, as RRR|LoginConv does, takes considerable time to complete. But by prioritizing the order in which forms and records are converted, you should be able to do the important stuff during a weekend. Then the tool can munch on to convert historical data in a more leisurely manner. RRR|LoginConv exchanges text fields up to 254 characters in length. It does fix the lists in the 112 and 60xxx fields, as well as Status-History and Diary-fields. If it finds a quoted match in a char-field, that will be exchanged as well. It performs one read and one write per record, regardless of the number of fields/logins that is converted on that record, and you should be able to run several in parallel to speed things up. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I would recommend https://rrr.se/cgi/tools/main?tool=rrrLoginConv On Mon, Sep 29, 2014 at 11:02 AM, Frank Caruso caruso.fr...@gmail.com wrote: ITSM 764 sp2, Oracle, Weblogic We have been asked to determine the difficulty/feasibility in converting all Login IDs and Corporate IDs to new values. The unique values currently used must be eliminated from every field in the application: Submitter, Last Modified By, contained within a notes/description field and all custom forms. We have over 1 million HPD records and millions of other ancillary tables; audit, work log, assignments, searches, etc. I looked at the Data Wizard Console (DWC) and it does allow Login IDs to be changed; it appears to search across 408 tables in ITSM. But it does not handle corporate id, can only be run for a single ID, does not search inside text fields and does not handle custom forms. It also looks like a process that will take a very long time to run. Looking for any thoughts on performing such a task; maybe some tricks other have come up? Thank you. Frank Caruso ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years -- :wq cuga ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
Thanks Jason. We want to display Incident and Change data. For some of our companies it is only the manager that needs access to the info but for others we want to encourage individual users to logon to the portal to report issues, get updates etc – in turn reducing calls to our desk. We have a wide range of customers, all with different needs which can make configuring our Remedy quite problematic. We cannot use shared user accounts as we need to know who logged the call and what details to contact them back on. Reporting would also not work as we want users to have the ability to update the tickets. In my mind any enterprise ITSM tool worth its salt should have a user friendly portal which allows users to submit, review and update their information easily weather they logged it via the phone or online, as well as allowing managers to search and review all tickets in their area. SRM seems to do enough to meet the bare requirements but leaves a lot to be desired. It was funny looking at your screen shot as I have made many of the same changes. Although I have not got round to displaying and searching the CHG/INC number – do you remember where this data is stored or did you have to pull it back after the request was fulfilled? The issues I am running into seem to be due to the fact we want to use SRM in both directions – SR - INC/CHG but also INC/CHG - SR. I find when creating a SR from INC/CHG not enough information is passed to the SR but that is something I can work on. For now my main issue is that new INC/CHGs are not creating SRs when the contact doesn’t have a Login ID. I thought I could just use the persons email address to populate the login ID for old and new people. But having looked at the data many of our customers have a number of profiles with the same email address i.e a company’s IT department call us and want any emails to go back to a shared account but yet the call still has to have the individuals name. Also from talking to our guys some will refuse to give out their individual email addresses. So my options – put the login ID field on the Create New person dialog and get our desk to complete an unique Login ID if the email address will not work. Option 2 – figure out why SRM requires the Login ID and see if I can get it to work without it (so the managers get to view all tickets no matter what.) Option 3 – do both option 1 2. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
Cheers guys, The scenario I have is that end users without Login Ids call our service desk to report incidents. We have enabled the feature to create service request on logging - the idea being that all incidents and changes would have Service Requests allowing particular customer Managers to logon to the portal and use the business manager console to view the tickets that all their staff have logged. Because the users calling our desk do not have Login IDs Remedy generates an Error saying that a Service Request cannot be created as the user does not have a Login ID. My query was why does a Service Request need a Login ID and is there an easy workaround. So far the best I have is to create a Login ID for each user - but we do not have a definitie list of possible users so I am looking at creating workflow that generates a login ID for each new People record created. Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
I'm curious what sort of customers you have that you may not be able to track them. I would have thought that there would have to be a CRM or some source of day to automatically create People records from. Also, SRM is supposed to be licensed by the number of users, so I think what you are trying to do might potentially result in licensing issues. However, If I were to do something like that, from a technical standpoint I'd consider not using SRM because not only of the licensing issues but security. You could set up a single People record with a user tied to it and put it in an entitlement group that can only see that single form. However, the risk would be that all the users can see each other's' requests. With that in mind, I'd look outside of Remedy, somewhere like maybe whatever website your people go to, and write some code to push to web services to create the request on the Remedy side. You might even be able to use SharePoint and something like InfoPath to build it without coding but I haven't played around with that enough yet. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of SUBSCRIBE ARSLIST theReel Sent: Friday, January 24, 2014 6:48 AM To: arslist@ARSLIST.ORG Subject: Re: Why do service requests require a Login ID? Cheers guys, The scenario I have is that end users without Login Ids call our service desk to report incidents. We have enabled the feature to create service request on logging - the idea being that all incidents and changes would have Service Requests allowing particular customer Managers to logon to the portal and use the business manager console to view the tickets that all their staff have logged. Because the users calling our desk do not have Login IDs Remedy generates an Error saying that a Service Request cannot be created as the user does not have a Login ID. My query was why does a Service Request need a Login ID and is there an easy workaround. So far the best I have is to create a Login ID for each user - but we do not have a definitie list of possible users so I am looking at creating workflow that generates a login ID for each new People record created. Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
You could also create one Login ID call something like Phone and use that ID to submit all tickets to. If you need to break up the callers for the particular customer Managers you could do something like Phone xxx where xxx is the calling area On Fri, Jan 24, 2014 at 8:48 AM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: I'm curious what sort of customers you have that you may not be able to track them. I would have thought that there would have to be a CRM or some source of day to automatically create People records from. Also, SRM is supposed to be licensed by the number of users, so I think what you are trying to do might potentially result in licensing issues. However, If I were to do something like that, from a technical standpoint I'd consider not using SRM because not only of the licensing issues but security. You could set up a single People record with a user tied to it and put it in an entitlement group that can only see that single form. However, the risk would be that all the users can see each other's' requests. With that in mind, I'd look outside of Remedy, somewhere like maybe whatever website your people go to, and write some code to push to web services to create the request on the Remedy side. You might even be able to use SharePoint and something like InfoPath to build it without coding but I haven't played around with that enough yet. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of SUBSCRIBE ARSLIST theReel Sent: Friday, January 24, 2014 6:48 AM To: arslist@ARSLIST.ORG Subject: Re: Why do service requests require a Login ID? Cheers guys, The scenario I have is that end users without Login Ids call our service desk to report incidents. We have enabled the feature to create service request on logging - the idea being that all incidents and changes would have Service Requests allowing particular customer Managers to logon to the portal and use the business manager console to view the tickets that all their staff have logged. Because the users calling our desk do not have Login IDs Remedy generates an Error saying that a Service Request cannot be created as the user does not have a Login ID. My query was why does a Service Request need a Login ID and is there an easy workaround. So far the best I have is to create a Login ID for each user - but we do not have a definitie list of possible users so I am looking at creating workflow that generates a login ID for each new People record created. Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
You could also create one Login ID call something like Phone and use that ID to submit all tickets to. If you need to break up the callers for the particular customer Managers you could do something like Phone xxx where xxx is the calling area On Fri, Jan 24, 2014 at 8:48 AM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: I'm curious what sort of customers you have that you may not be able to track them. I would have thought that there would have to be a CRM or some source of day to automatically create People records from. Also, SRM is supposed to be licensed by the number of users, so I think what you are trying to do might potentially result in licensing issues. However, If I were to do something like that, from a technical standpoint I'd consider not using SRM because not only of the licensing issues but security. You could set up a single People record with a user tied to it and put it in an entitlement group that can only see that single form. However, the risk would be that all the users can see each other's' requests. With that in mind, I'd look outside of Remedy, somewhere like maybe whatever website your people go to, and write some code to push to web services to create the request on the Remedy side. You might even be able to use SharePoint and something like InfoPath to build it without coding but I haven't played around with that enough yet. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of SUBSCRIBE ARSLIST theReel Sent: Friday, January 24, 2014 6:48 AM To: arslist@ARSLIST.ORG Subject: Re: Why do service requests require a Login ID? Cheers guys, The scenario I have is that end users without Login Ids call our service desk to report incidents. We have enabled the feature to create service request on logging - the idea being that all incidents and changes would have Service Requests allowing particular customer Managers to logon to the portal and use the business manager console to view the tickets that all their staff have logged. Because the users calling our desk do not have Login IDs Remedy generates an Error saying that a Service Request cannot be created as the user does not have a Login ID. My query was why does a Service Request need a Login ID and is there an easy workaround. So far the best I have is to create a Login ID for each user - but we do not have a definitie list of possible users so I am looking at creating workflow that generates a login ID for each new People record created. Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
Hi, We are a Managed Services Provider so at any one time we have 150 + companies who each have their own staff coming and going. Potentially any of these customers end users could call our hotline to log a fault. For obivous reasons it is impractical for us to try and maintain a database of potential callers. So when a person calls us for the first time our guys create a People profile for this person. These end users also have no need to access the SRM portal and so don't require a login ID or licence. Each of the companies have a manager and the requirement is to provide a place that these managers can see the details of tickets that their staff are logging. The idea was that we provide a single SRM logon to the Manager to access the business manager console and to enable the feature that logs a service request for each incideint/change logged. But I am quickly finding out that the Business Management Console leaves a lot to be desired when using it for this purpose. Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
Tony, We use a People profile name of Jane Doe to log calls when the caller is anonymous. Kelvin -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of SUBSCRIBE ARSLIST theReel Sent: Friday, January 24, 2014 12:27 PM To: arslist@ARSLIST.ORG Subject: Re: Why do service requests require a Login ID? Hi, We are a Managed Services Provider so at any one time we have 150 + companies who each have their own staff coming and going. Potentially any of these customers end users could call our hotline to log a fault. For obivous reasons it is impractical for us to try and maintain a database of potential callers. So when a person calls us for the first time our guys create a People profile for this person. These end users also have no need to access the SRM portal and so don't require a login ID or licence. Each of the companies have a manager and the requirement is to provide a place that these managers can see the details of tickets that their staff are logging. The idea was that we provide a single SRM logon to the Manager to access the business manager console and to enable the feature that logs a service request for each incideint/change logged. But I am quickly finding out that the Business Management Console leaves a lot to be desired when using it for this purpose. Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
Ah, thanks! I am getting a better idea of what you are trying to achieve. So the goal if for company/area manager to be able to review submitted issues (I remember that earlier in the discussion but didn't key in on it). So what you are doing doesn't sound too far-fetched. Are they only looking for Incident data or any of the apps (Change, Work Order, Problem)? If you need to be able to give them a requests from multiple apps then overall what you are trying to do makes sense since SRM is the consolidated Request interface. Maybe it is the case that you just need to create a temporary randomish Login ID as John suggested for the sole purpose of fulfilling the Login ID requirement. Optionally is this something that could be handled with reporting (scheduled or on-demand)? With reports you wouldn't necessarily need to create SRM requests and could report on operating company or location information for the managers. Regarding the Business Manager Console I think this one of those things that underutilized by customers so it doesn't get much development attention. The concept is good but for whatever reason I don't think many organizations use it. We use it to allow the business to view status, assign and approval SRs before they fulfill to a CRQ. We found that we had to update it a bit to make it more useful for searching, better use the screen real estate and provide a little more data. There is a screen print here: http://ars-action-request-system.1.n7.nabble.com/SRM -Request-Detail-information-tp113935p113937.html. Maybe this will give you a few ideas. Jason On Fri, Jan 24, 2014 at 9:26 AM, SUBSCRIBE ARSLIST theReel tony.r...@bt.com wrote: Hi, We are a Managed Services Provider so at any one time we have 150 + companies who each have their own staff coming and going. Potentially any of these customers end users could call our hotline to log a fault. For obivous reasons it is impractical for us to try and maintain a database of potential callers. So when a person calls us for the first time our guys create a People profile for this person. These end users also have no need to access the SRM portal and so don't require a login ID or licence. Each of the companies have a manager and the requirement is to provide a place that these managers can see the details of tickets that their staff are logging. The idea was that we provide a single SRM logon to the Manager to access the business manager console and to enable the feature that logs a service request for each incideint/change logged. But I am quickly finding out that the Business Management Console leaves a lot to be desired when using it for this purpose. Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
I haven't looked into using SRM without a Login ID. How does it work if you don't have a Login ID but do have a People record? If the person is not logged in with their account how is a person associated with their People record? Does it prompt them to enter their people ID or search for their People record by name? a few minutes passed So I did a quick test. I enabled allow guest users and was presented with a warning that Logged in user not recognized and was sent back to the landing console. I created a People record for a test user but without the Login name I am not sure how to associated with the guest login. Jason On Wed, Jan 22, 2014 at 1:42 AM, patchsk vamsi...@gmail.com wrote: ** Hmm upon further review it seems like you actually do not need a login to use SRM. All you need is just a person record. And there is no license control at the system level, only paper licenses. In that case no idea why would a loginID be required for SR creation from Incident. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
SRM does not allow guest users. BMC RD wrote the workflow to enforce this. -Original Message- From: Jason Miller jason.mil...@gmail.com To: arslist arslist@ARSLIST.ORG Sent: Thu, Jan 23, 2014 2:42 pm Subject: Re: Why do service requests require a Login ID? ** I haven't looked into using SRM without a Login ID. How does it work if you don't have a Login ID but do have a People record? If the person is not logged in with their account how is a person associated with their People record? Does it prompt them to enter their people ID or search for their People record by name? a few minutes passed So I did a quick test. I enabled allow guest users and was presented with a warning that Logged in user not recognized and was sent back to the landing console. I created a People record for a test user but without the Login name I am not sure how to associated with the guest login. Jason On Wed, Jan 22, 2014 at 1:42 AM, patchsk vamsi...@gmail.com wrote: ** Hmm upon further review it seems like you actually do not need a login to use SRM. All you need is just a person record. And there is no license control at the system level, only paper licenses. In that case no idea why would a loginID be required for SR creation from Incident. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
Thanks for validating. Guest user is the only way I can think of where a person would be logged in an not associated with their Login ID (assuming it isn't a shared account that is use for authentication). I guess it is possible that Authentication Unregistered Users would allow a person to login without having a Login ID (User record) but without Login ID there is no way to associate the person to their People record. I am trying to figure out what patchsk is referring to: Hmm upon further review it seems like you actually do not need a login to use SRM. All you need is just a person record. Maybe that wasn't a technical statement but a licensing one? Jason On Thu, Jan 23, 2014 at 11:53 AM, Roger Justice rjust2...@aol.com wrote: ** SRM does not allow guest users. BMC RD wrote the workflow to enforce this. -Original Message- From: Jason Miller jason.mil...@gmail.com To: arslist arslist@ARSLIST.ORG Sent: Thu, Jan 23, 2014 2:42 pm Subject: Re: Why do service requests require a Login ID? ** I haven't looked into using SRM without a Login ID. How does it work if you don't have a Login ID but do have a People record? If the person is not logged in with their account how is a person associated with their People record? Does it prompt them to enter their people ID or search for their People record by name? a few minutes passed So I did a quick test. I enabled allow guest users and was presented with a warning that Logged in user not recognized and was sent back to the landing console. I created a People record for a test user but without the Login name I am not sure how to associated with the guest login. Jason On Wed, Jan 22, 2014 at 1:42 AM, patchsk vamsi...@gmail.com wrote: ** Hmm upon further review it seems like you actually do not need a login to use SRM. All you need is just a person record. And there is no license control at the system level, only paper licenses. In that case no idea why would a loginID be required for SR creation from Incident. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
My two cents from what I can remember: SR itself is not a ticket by itself, it will always have a backend WO,Incident as a fulfillment record. The main purpose of having SR created is for a customer to actually use selfservice(SRM) portal to Get updates/send updates etc...which will reduce the call volume. Incase if a user does not have a loginID then he cannot login to SRM so there is no need to have an SR created for that specific request as the backend fullfilment records (WO/Incidents) are already created. And the reason to have a loginID to login to SRM is to apply the license controls as you need to buy a set of SRM user licenses for allowing users to access SRM portal. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
Hmm upon further review it seems like you actually do not need a login to use SRM. All you need is just a person record. And there is no license control at the system level, only paper licenses. In that case no idea why would a loginID be required for SR creation from Incident. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
Thanks for the reply Joe. We have a custom utility that the users can use to self-register when they go to our portal for the first time. Like you describe, it creates a people and user account with the correct permissions depending on what we have setup for that customer. The issue is when new users Phone the service desk - our Service Desk will use the create user functionality from the incident form to create a Person profile. It looks like we now need additional workflow so that this also creates a User profile with the correct permissions so that a Service Request can be created on submission of the incident. My original query was to try to ascertain why Service Requests need a Login ID associated to them and why was a person ID association not used like in Incident/Change. Regards Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
Thanks for the reply Jason, I probably should have mentioned that I work for a Managed Services company so not all our customers would have access to SRM and we would get new users calling us every day - so we can't link to AD or anything like that to ensure everyone already has an account. So it may be a case that we will have to modify the create Person workflow so that it also creates a Login ID for each new user. That brings it own issues - of trying to assign the correct permissions etc. Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
Not really.. You do not need to modify existing OTB code. But add a little utility to create this information. You can design a self registration process, that uses some sort of a unique key to register such as maybe a billing account number or something like that so that for a particular managed service, a customer cannot create more than 1 account unless off course you want to give them that ability. And in the self registration process, you need to create a couple of filters, one that pushes into people form, and the other into people permissions group form, to give them the permissions they require to use SRM. Its as simple as that. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of SUBSCRIBE ARSLIST theReel Sent: Monday, January 20, 2014 6:25 AM To: arslist@ARSLIST.ORG Subject: Re: Why do service requests require a Login ID? Thanks for the reply Jason, I probably should have mentioned that I work for a Managed Services company so not all our customers would have access to SRM and we would get new users calling us every day - so we can't link to AD or anything like that to ensure everyone already has an account. So it may be a case that we will have to modify the create Person workflow so that it also creates a Login ID for each new user. That brings it own issues - of trying to assign the correct permissions etc. Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Why do service requests require a Login ID?
Hi Guys, We have a customer who has a few managers that use the SRM Request portal to submit/view requests and also view tickets raised by other users via the Busniess manager console. Not all of this customers users have login Ids for Remedy. 90% submit calls via phone and only a select few access Remedy via the SRM portal. So 90% have people profiles but no User profile/Login ID. When the Create Service Request on Submit rule is enabled and an Incident/Change is created for a person that does not have a Login ID you get the warning Login ID is missing for the registered user. An incident will be created but the request will not be created because Login ID is required. (ARWARN 45459) Question is: why does the Service Request need a Login ID? Surely any relationship to a person should be done via the People ID. Has anyone came accross this before or have any solutons? Thanks Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Why do service requests require a Login ID?
I don't have the answer to your question however we moved from only IT and certain business users having User records (our older system) to all employees and affiliates having User records so SRM can be used by everybody. To us it just made sense that we want them authenticated so we added them. This solves issues we have always have had with trying to work with unauthenticated users (having to ask them their username, employee ID, etc.). Jason On Fri, Jan 17, 2014 at 9:12 AM, SUBSCRIBE ARSLIST theReel tony.r...@bt.com wrote: Hi Guys, We have a customer who has a few managers that use the SRM Request portal to submit/view requests and also view tickets raised by other users via the Busniess manager console. Not all of this customers users have login Ids for Remedy. 90% submit calls via phone and only a select few access Remedy via the SRM portal. So 90% have people profiles but no User profile/Login ID. When the Create Service Request on Submit rule is enabled and an Incident/Change is created for a person that does not have a Login ID you get the warning Login ID is missing for the registered user. An incident will be created but the request will not be created because Login ID is required. (ARWARN 45459) Question is: why does the Service Request need a Login ID? Surely any relationship to a person should be done via the People ID. Has anyone came accross this before or have any solutons? Thanks Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Business Objects 11 (BOXI) Login ID format when running BMC Analytics reports in multi-tenancy mode.
** Hello list... Environment: ARSystem 8.1 Patch 002ITSM 8.1 Patch 002BSM Analytics for BSM 7.6.06 Patch 3SAP Business Objects Business Intelligence Platform 4.0 SP5 Patch 3 I am wondering if anyone has experienced the same issue as below. The issue I have is that Iam logging into Analytics (actually BOXI) and trying to run Analytics reports. However, I do notget any data in any of the Analytics reports, even though my connection to the ITSM universe is valid and I am connecting to the underlying SQL database. I am logging into BOXI as "firstname.lastname" where "firstname.lastname" is the same as the LoginID in CTM:People (which must be the case when using Analytics in Multi-tenancy mode. Analytics uses the permissions associated with your entry in CTM:People in order to determine which customers you are allowed to report on (in multi-tenancy mode). As mentioned above, the BMC Anaytics report definitions that are installed with Analytics query information from the ITSM universe based upon the currently logged in Business Objects userid. The issue here is that all the Analytics reports that I saw EXPECT the Business Objects userid to be in the format of "use...@domainname.com" as shown in the following highlighted (bolded) selection criteria in the Analytics report (Note: This is the subset of selection criteria that gets the permissions associated with the current user): SELECT DISTINCT CTM1.COMPANY FROM CTM_PEOPLE_PERMISSION_GROUPS CTM1 WHERE UPPER(REMEDY_LOGIN_ID) = UPPER(SUBSTRING(@VARIABLE('BOUSER'),0,CHARINDEX('@',@VARIABLE('BOUSER' AND CTM1.COMPANY IS NOT NULL AND ( CTM1.COMPANY = HPD.COMPANY OR CTM1.COMPANY = HPD.CONTACT_COMPANY OR CTM1.COMPANY = HPD.Direct_Contact_Company OR CTM1.COMPANY = HPD.Assigned_Support_Company OR CTM1.COMPANY = HPD.Owner_Support_Company) UNION SELECT DISTINCT CTM2.COMPANY FROM CTM_PEOPLE_ORGANIZATION CTM2 WHERE (SELECT 1 FROM CTM_PEOPLE_PERMISSION_GROUPS WHERE UPPER(REMEDY_LOGIN_ID) = UPPER(SUBSTRING(@VARIABLE('BOUSER'),0,CHARINDEX('@',@VARIABLE('BOUSER' AND PERMISSION_GROUP = 'Unrestricted Access') = 1 (in the example above, @VARIABLE('BOUSER') returns the current login id of the BOXI user) It is the string above UPPER(REMEDY_LOGIN_ID) = UPPER(SUBSTRING(@VARIABLE('BOUSER'),0,CHARINDEX('@',@VARIABLE('BOUSER' that is embedded within all the Analytics reports that expects the "@" in the Business Objects userid. In our case, our userid (and Remedy userids) do not follow this convention. We follow "firstname.lastname". As a result, the query above returns NO results and my reports contain no data. As soon as I change my BOXI userid to firstname.lastname@domainname , logout, and re-login into BOXI and run the report, the report runs just fine. Has anyone else experienced this and/or can advise as to how to resolve ? (without modifying ALLAnalytics reports). Thanks.. Terry _ARSlist: "Where the Answers Are" and have been for 20 years_
Re: Re-use Login ID in Remedy
]0==u89h m,,.Hoik; From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of subash kaki Sent: Tuesday, October 09, 2012 4:27 PM To: arslist@ARSLIST.ORG Subject: Re: Re-use Login ID in Remedy ** UNSUBscrive From: Misi Mladoniczky m...@rrr.se To: arslist@ARSLIST.ORG Sent: Tuesday, October 9, 2012 1:57 PM Subject: Re: Re-use Login ID in Remedy Hi, RRR|LoginConv can change Modified-By/Submitter/Status-History.USER/Diary-entries etc from the original login name to something else. It will munch through all records of all forms an do the necessary updates. https://www.rrr.se/cgi/tools/main#rrrLoginConv I don't know how soon the login names will be reused, but one way would be to do one RRR|LoginConv run each month, cycling all retired accounts in one run. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I said the same thing guys. Let me elaborate a tad. They use a unique id for their company (custom attribute on the People form) that allows internal identification based on their unique identifier attribute, so they clam this will be acceptable when it comes to audits, I also brought up the SarBox issues. What concerns me is that Incidents/Changes/CI's, etc will have last modified by old guy instead of new guy. And... I haven't tried it yet, but I suspect the Data tool isn't going to do the trick as it relates to CI's. By reuse login Id' I was referring to: Ex. Joe Jones leaves the company and has a Remedy login ID of jjones. A new employee is hired, Judy Jones, and she is issued the old login id used for Joe Jones of jjones. So if the new employee Judy Jones logs on as jjones, does she suddenly inherit all the records previously owned/last updated by jjones as the original user of this id? Would she possibly see his Incidents/CI's, etc? I'm still trying to wrap my head around all this so pardon my rambling. :-) I've never had to deal with this issue in the past and wondered how the community handled this request or if anyone had ever had to deal with this issue before. 7.6.04 SP2 Windows Thanks, Jase On Mon, Oct 8, 2012 at 6:08 PM, Tauf Chowdhury taufc...@gmail.commailto:taufc...@gmail.com wrote: ** To echo Chris, I hope you don't work for a public company because that has to be against some sort of Sarbanes-Oxley regulation. Sent from my iPhone On Oct 8, 2012, at 4:11 PM, strauss stra...@unt.edumailto:stra...@unt.edu wrote: ** It is an incredibly bad security practice because it destroys any accountability for identity management. It is akin to reusing the social security numbers of deceased persons for newborns (try that analogy on them). We do battle with our PeopleSoft drones over this regularly, but it’s really a problem with them not having a unique index on the table for workforce ids; the LDAP login names almost never get duplicated, and our AD syncs to LDAP for that data. If you ever get a security audit, and they are reusing login ids in AD as a standard practice, your organization will fail the audit (unless the audit is by Arthur Andersen LLP). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] *On Behalf Of *Jase Brandon *Sent:* Monday, October 08, 2012 2:26 PM *To:* arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG *Subject:* Re-use Login ID in Remedy ** Hello All, I have been approached and asked about how we can re-use Login Id' and I've never been asked to do this anywhere else. Of course my initial reply was We shouldn't Do That, but I need more of a justification as the company reuses login ids via AD as a standard. Ive told them Login Id is associated with all things ITSM/CI's. I see this being a recipe for disaster. Can anyone help me out with your thoughts on this one please? Has anyone else done anything like this before? Thanks in Advance, Jase Brandon _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives
Remedy login ID in People record
Hi All, When I created a People record I used the wrong login ID for a new user and need to correct this. The field in the People record is now read only. How do I correct this? Can I just go to the User form and update it there? Also when some leaves what is the best way to remove a People record when the they have an account? Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-882.5360 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy login ID in People record
I would mark that record as offline and create a new record with correct login ID. Also, when someone leave organization, you can have their people record offline. ~ Vaibhav On Wed, Dec 12, 2012 at 10:40 AM, Brittain, Mark mbritt...@navisite.comwrote: ** Hi All, ** ** When I created a People record I used the wrong login ID for a new user and need to correct this. The field in the People record is now read only. How do I correct this? Can I just go to the User form and update it there? ** ** Also when some leaves what is the best way to remove a People record when the they have an account? ** ** Thanks Mark ** ** *Mark Brittain* Remedy Developer ITILv3 Foundation *NaviSite – **A Time Warner Cable Company* mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-882.5360 ** ** -- This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy login ID in People record
Mark, Under the 'Other functions' nav area there is a 'Remove Login ID' button that may help you out. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Wednesday, December 12, 2012 11:40 AM To: arslist@ARSLIST.ORG Subject: Remedy login ID in People record ** Hi All, When I created a People record I used the wrong login ID for a new user and need to correct this. The field in the People record is now read only. How do I correct this? Can I just go to the User form and update it there? Also when some leaves what is the best way to remove a People record when the they have an account? Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.com mailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-882.5360 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy login ID in People record
You can also use the Data Management Wizard to change the login ID. Application Administration Console Custom Configuration tab Foundation Data Management Data Wizard 1. Update target values 2. Login ID This will update the login id and all OOTB references on the supporting forms. It'll also update the login ID on the application forms if this is an account that's already been in use. Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy login ID in People record
i think marking the people record Offline, disabling the User record does not have any impact in term of restricting access for the user.You might want to change the password if the user has left or delete the record. Ravi Rai Date: Wed, 12 Dec 2012 10:45:16 -0800 From: wadekar.vaib...@gmail.com Subject: Re: Remedy login ID in People record To: arslist@ARSLIST.ORG ** I would mark that record as offline and create a new record with correct login ID. Also, when someone leave organization, you can have their people record offline. ~ Vaibhav On Wed, Dec 12, 2012 at 10:40 AM, Brittain, Mark mbritt...@navisite.com wrote: ** Hi All, When I created a People record I used the wrong login ID for a new user and need to correct this. The field in the People record is now read only. How do I correct this? Can I just go to the User form and update it there? Also when some leaves what is the best way to remove a People record when the they have an account? Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite – A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-882.5360 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy login ID in People record
And the winner is... Cool tool and good advice. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Bess Sent: Wednesday, December 12, 2012 12:52 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy login ID in People record You can also use the Data Management Wizard to change the login ID. Application Administration Console Custom Configuration tab Foundation Data Management Data Wizard 1. Update target values 2. Login ID This will update the login id and all OOTB references on the supporting forms. It'll also update the login ID on the application forms if this is an account that's already been in use. Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy login ID in People record
I like to refer to this part of the DMT as the Marriage/Divorce function, since that's generally the only time I run it. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Bess Sent: Wednesday, December 12, 2012 12:52 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy login ID in People record You can also use the Data Management Wizard to change the login ID. Application Administration Console Custom Configuration tab Foundation Data Management Data Wizard 1. Update target values 2. Login ID This will update the login id and all OOTB references on the supporting forms. It'll also update the login ID on the application forms if this is an account that's already been in use. Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Re-use Login ID in Remedy
Hi, RRR|LoginConv can change Modified-By/Submitter/Status-History.USER/Diary-entries etc from the original login name to something else. It will munch through all records of all forms an do the necessary updates. https://www.rrr.se/cgi/tools/main#rrrLoginConv I don't know how soon the login names will be reused, but one way would be to do one RRR|LoginConv run each month, cycling all retired accounts in one run. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I said the same thing guys. Let me elaborate a tad. They use a unique id for their company (custom attribute on the People form) that allows internal identification based on their unique identifier attribute, so they clam this will be acceptable when it comes to audits, I also brought up the SarBox issues. What concerns me is that Incidents/Changes/CI's, etc will have last modified by old guy instead of new guy. And... I haven't tried it yet, but I suspect the Data tool isn't going to do the trick as it relates to CI's. By reuse login Id' I was referring to: Ex. Joe Jones leaves the company and has a Remedy login ID of jjones. A new employee is hired, Judy Jones, and she is issued the old login id used for Joe Jones of jjones. So if the new employee Judy Jones logs on as jjones, does she suddenly inherit all the records previously owned/last updated by jjones as the original user of this id? Would she possibly see his Incidents/CI's, etc? I'm still trying to wrap my head around all this so pardon my rambling. :-) I've never had to deal with this issue in the past and wondered how the community handled this request or if anyone had ever had to deal with this issue before. 7.6.04 SP2 Windows Thanks, Jase On Mon, Oct 8, 2012 at 6:08 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** To echo Chris, I hope you don't work for a public company because that has to be against some sort of Sarbanes-Oxley regulation. Sent from my iPhone On Oct 8, 2012, at 4:11 PM, strauss stra...@unt.edu wrote: ** It is an incredibly bad security practice because it destroys any accountability for identity management. It is akin to reusing the social security numbers of deceased persons for newborns (try that analogy on them). We do battle with our PeopleSoft drones over this regularly, but it’s really a problem with them not having a unique index on the table for workforce ids; the LDAP login names almost never get duplicated, and our AD syncs to LDAP for that data. If you ever get a security audit, and they are reusing login ids in AD as a standard practice, your organization will fail the audit (unless the audit is by Arthur Andersen LLP). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Jase Brandon *Sent:* Monday, October 08, 2012 2:26 PM *To:* arslist@ARSLIST.ORG *Subject:* Re-use Login ID in Remedy ** Hello All, I have been approached and asked about how we can re-use Login Id' and I've never been asked to do this anywhere else. Of course my initial reply was We shouldn't Do That, but I need more of a justification as the company reuses login ids via AD as a standard. Ive told them Login Id is associated with all things ITSM/CI's. I see this being a recipe for disaster. Can anyone help me out with your thoughts on this one please? Has anyone else done anything like this before? Thanks in Advance, Jase Brandon _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Re-use Login ID in Remedy
UNSUBscrive From: Misi Mladoniczky m...@rrr.se To: arslist@ARSLIST.ORG Sent: Tuesday, October 9, 2012 1:57 PM Subject: Re: Re-use Login ID in Remedy Hi, RRR|LoginConv can change Modified-By/Submitter/Status-History.USER/Diary-entries etc from the original login name to something else. It will munch through all records of all forms an do the necessary updates. https://www.rrr.se/cgi/tools/main#rrrLoginConv I don't know how soon the login names will be reused, but one way would be to do one RRR|LoginConv run each month, cycling all retired accounts in one run. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I said the same thing guys. Let me elaborate a tad. They use a unique id for their company (custom attribute on the People form) that allows internal identification based on their unique identifier attribute, so they clam this will be acceptable when it comes to audits, I also brought up the SarBox issues. What concerns me is that Incidents/Changes/CI's, etc will have last modified by old guy instead of new guy. And... I haven't tried it yet, but I suspect the Data tool isn't going to do the trick as it relates to CI's. By reuse login Id' I was referring to: Ex. Joe Jones leaves the company and has a Remedy login ID of jjones. A new employee is hired, Judy Jones, and she is issued the old login id used for Joe Jones of jjones. So if the new employee Judy Jones logs on as jjones, does she suddenly inherit all the records previously owned/last updated by jjones as the original user of this id? Would she possibly see his Incidents/CI's, etc? I'm still trying to wrap my head around all this so pardon my rambling. :-) I've never had to deal with this issue in the past and wondered how the community handled this request or if anyone had ever had to deal with this issue before. 7.6.04 SP2 Windows Thanks, Jase On Mon, Oct 8, 2012 at 6:08 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** To echo Chris, I hope you don't work for a public company because that has to be against some sort of Sarbanes-Oxley regulation. Sent from my iPhone On Oct 8, 2012, at 4:11 PM, strauss stra...@unt.edu wrote: ** It is an incredibly bad security practice because it destroys any accountability for identity management. It is akin to reusing the social security numbers of deceased persons for newborns (try that analogy on them). We do battle with our PeopleSoft drones over this regularly, but it’s really a problem with them not having a unique index on the table for workforce ids; the LDAP login names almost never get duplicated, and our AD syncs to LDAP for that data. If you ever get a security audit, and they are reusing login ids in AD as a standard practice, your organization will fail the audit (unless the audit is by Arthur Andersen LLP). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Jase Brandon *Sent:* Monday, October 08, 2012 2:26 PM *To:* arslist@ARSLIST.ORG *Subject:* Re-use Login ID in Remedy ** Hello All, I have been approached and asked about how we can re-use Login Id' and I've never been asked to do this anywhere else. Of course my initial reply was We shouldn't Do That, but I need more of a justification as the company reuses login ids via AD as a standard. Ive told them Login Id is associated with all things ITSM/CI's. I see this being a recipe for disaster. Can anyone help me out with your thoughts on this one please? Has anyone else done anything like this before? Thanks in Advance, Jase Brandon _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: [EXTERNAL] Re: Re-use Login ID in Remedy
To answer your this specific question: So if the new employee Judy Jones logs on as jjones, does she suddenly inherit all the records previously owned/last updated by jjones as the original user of this id? Would she possibly see his Incidents/CI's, etc? Yes, Judy Jones (new user) will inherit all the records previously owned/last updated by Joe Jones , she would see all records and ownership of those records which were worked by Joe Jones. Reason: remedy application does not recognize whether user is new or old, as soon as it finds valid record in User form it does get authenticated and as soon as it finds valid record in CTM: People form it gives all permissions and licenses accordingly. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jase Brandon Sent: Monday, October 08, 2012 4:49 PM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Re: Re-use Login ID in Remedy ** I said the same thing guys. Let me elaborate a tad. They use a unique id for their company (custom attribute on the People form) that allows internal identification based on their unique identifier attribute, so they clam this will be acceptable when it comes to audits, I also brought up the SarBox issues. What concerns me is that Incidents/Changes/CI's, etc will have last modified by old guy instead of new guy. And... I haven't tried it yet, but I suspect the Data tool isn't going to do the trick as it relates to CI's. By reuse login Id' I was referring to: Ex. Joe Jones leaves the company and has a Remedy login ID of jjones. A new employee is hired, Judy Jones, and she is issued the old login id used for Joe Jones of jjones. So if the new employee Judy Jones logs on as jjones, does she suddenly inherit all the records previously owned/last updated by jjones as the original user of this id? Would she possibly see his Incidents/CI's, etc? I'm still trying to wrap my head around all this so pardon my rambling. :-) I've never had to deal with this issue in the past and wondered how the community handled this request or if anyone had ever had to deal with this issue before. 7.6.04 SP2 Windows Thanks, Jase On Mon, Oct 8, 2012 at 6:08 PM, Tauf Chowdhury taufc...@gmail.commailto:taufc...@gmail.com wrote: ** To echo Chris, I hope you don't work for a public company because that has to be against some sort of Sarbanes-Oxley regulation. Sent from my iPhone On Oct 8, 2012, at 4:11 PM, strauss stra...@unt.edumailto:stra...@unt.edu wrote: ** It is an incredibly bad security practice because it destroys any accountability for identity management. It is akin to reusing the social security numbers of deceased persons for newborns (try that analogy on them). We do battle with our PeopleSoft drones over this regularly, but it's really a problem with them not having a unique index on the table for workforce ids; the LDAP login names almost never get duplicated, and our AD syncs to LDAP for that data. If you ever get a security audit, and they are reusing login ids in AD as a standard practice, your organization will fail the audit (unless the audit is by Arthur Andersen LLP). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jase Brandon Sent: Monday, October 08, 2012 2:26 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re-use Login ID in Remedy ** Hello All, I have been approached and asked about how we can re-use Login Id' and I've never been asked to do this anywhere else. Of course my initial reply was We shouldn't Do That, but I need more of a justification as the company reuses login ids via AD as a standard. Ive told them Login Id is associated with all things ITSM/CI's. I see this being a recipe for disaster. Can anyone help me out with your thoughts on this one please? Has anyone else done anything like this before? Thanks in Advance, Jase Brandon _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re-use Login ID in Remedy
Hello All, I have been approached and asked about how we can re-use Login Id' and I've never been asked to do this anywhere else. Of course my initial reply was We shouldn't Do That, but I need more of a justification as the company reuses login ids via AD as a standard. Ive told them Login Id is associated with all things ITSM/CI's. I see this being a recipe for disaster. Can anyone help me out with your thoughts on this one please? Has anyone else done anything like this before? Thanks in Advance, Jase Brandon ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Re-use Login ID in Remedy
Jason, There was a rather lengthy discussion of that topic a few months ago that may be able to answer some of your questions. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jase Brandon Sent: Monday, October 08, 2012 1:26 PM To: arslist@ARSLIST.ORG Subject: Re-use Login ID in Remedy ** Hello All, I have been approached and asked about how we can re-use Login Id' and I've never been asked to do this anywhere else. Of course my initial reply was We shouldn't Do That, but I need more of a justification as the company reuses login ids via AD as a standard. Ive told them Login Id is associated with all things ITSM/CI's. I see this being a recipe for disaster. Can anyone help me out with your thoughts on this one please? Has anyone else done anything like this before? Thanks in Advance, Jase Brandon _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Re-use Login ID in Remedy
Jase, What do you mean by re-use login id? Re-use login-Id for what purpose you mean? -Karthik On Oct 9, 2012 12:57 AM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Jason, There was a rather lengthy discussion of that topic a few months ago that may be able to answer some of your questions. -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Jase Brandon Sent: Monday, October 08, 2012 1:26 PM To: arslist@ARSLIST.ORG Subject: Re-use Login ID in Remedy ** Hello All, I have been approached and asked about how we can re-use Login Id' and I've never been asked to do this anywhere else. Of course my initial reply was We shouldn't Do That, but I need more of a justification as the company reuses login ids via AD as a standard. Ive told them Login Id is associated with all things ITSM/CI's. I see this being a recipe for disaster. Can anyone help me out with your thoughts on this one please? Has anyone else done anything like this before? Thanks in Advance, Jase Brandon _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Re-use Login ID in Remedy
It is an incredibly bad security practice because it destroys any accountability for identity management. It is akin to reusing the social security numbers of deceased persons for newborns (try that analogy on them). We do battle with our PeopleSoft drones over this regularly, but it's really a problem with them not having a unique index on the table for workforce ids; the LDAP login names almost never get duplicated, and our AD syncs to LDAP for that data. If you ever get a security audit, and they are reusing login ids in AD as a standard practice, your organization will fail the audit (unless the audit is by Arthur Andersen LLP). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jase Brandon Sent: Monday, October 08, 2012 2:26 PM To: arslist@ARSLIST.ORG Subject: Re-use Login ID in Remedy ** Hello All, I have been approached and asked about how we can re-use Login Id' and I've never been asked to do this anywhere else. Of course my initial reply was We shouldn't Do That, but I need more of a justification as the company reuses login ids via AD as a standard. Ive told them Login Id is associated with all things ITSM/CI's. I see this being a recipe for disaster. Can anyone help me out with your thoughts on this one please? Has anyone else done anything like this before? Thanks in Advance, Jase Brandon _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Re-use Login ID in Remedy
To echo Chris, I hope you don't work for a public company because that has to be against some sort of Sarbanes-Oxley regulation. Sent from my iPhone On Oct 8, 2012, at 4:11 PM, strauss stra...@unt.edu wrote: ** It is an incredibly bad security practice because it destroys any accountability for identity management. It is akin to reusing the social security numbers of deceased persons for newborns (try that analogy on them). We do battle with our PeopleSoft drones over this regularly, but it’s really a problem with them not having a unique index on the table for workforce ids; the LDAP login names almost never get duplicated, and our AD syncs to LDAP for that data. If you ever get a security audit, and they are reusing login ids in AD as a standard practice, your organization will fail the audit (unless the audit is by Arthur Andersen LLP). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Jase Brandon *Sent:* Monday, October 08, 2012 2:26 PM *To:* arslist@ARSLIST.ORG *Subject:* Re-use Login ID in Remedy ** Hello All, I have been approached and asked about how we can re-use Login Id' and I've never been asked to do this anywhere else. Of course my initial reply was We shouldn't Do That, but I need more of a justification as the company reuses login ids via AD as a standard. Ive told them Login Id is associated with all things ITSM/CI's. I see this being a recipe for disaster. Can anyone help me out with your thoughts on this one please? Has anyone else done anything like this before? Thanks in Advance, Jase Brandon _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Re-use Login ID in Remedy
I said the same thing guys. Let me elaborate a tad. They use a unique id for their company (custom attribute on the People form) that allows internal identification based on their unique identifier attribute, so they clam this will be acceptable when it comes to audits, I also brought up the SarBox issues. What concerns me is that Incidents/Changes/CI's, etc will have last modified by old guy instead of new guy. And... I haven't tried it yet, but I suspect the Data tool isn't going to do the trick as it relates to CI's. By reuse login Id' I was referring to: Ex. Joe Jones leaves the company and has a Remedy login ID of jjones. A new employee is hired, Judy Jones, and she is issued the old login id used for Joe Jones of jjones. So if the new employee Judy Jones logs on as jjones, does she suddenly inherit all the records previously owned/last updated by jjones as the original user of this id? Would she possibly see his Incidents/CI's, etc? I'm still trying to wrap my head around all this so pardon my rambling. :-) I've never had to deal with this issue in the past and wondered how the community handled this request or if anyone had ever had to deal with this issue before. 7.6.04 SP2 Windows Thanks, Jase On Mon, Oct 8, 2012 at 6:08 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** To echo Chris, I hope you don't work for a public company because that has to be against some sort of Sarbanes-Oxley regulation. Sent from my iPhone On Oct 8, 2012, at 4:11 PM, strauss stra...@unt.edu wrote: ** It is an incredibly bad security practice because it destroys any accountability for identity management. It is akin to reusing the social security numbers of deceased persons for newborns (try that analogy on them). We do battle with our PeopleSoft drones over this regularly, but it’s really a problem with them not having a unique index on the table for workforce ids; the LDAP login names almost never get duplicated, and our AD syncs to LDAP for that data. If you ever get a security audit, and they are reusing login ids in AD as a standard practice, your organization will fail the audit (unless the audit is by Arthur Andersen LLP). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Jase Brandon *Sent:* Monday, October 08, 2012 2:26 PM *To:* arslist@ARSLIST.ORG *Subject:* Re-use Login ID in Remedy ** Hello All, I have been approached and asked about how we can re-use Login Id' and I've never been asked to do this anywhere else. Of course my initial reply was We shouldn't Do That, but I need more of a justification as the company reuses login ids via AD as a standard. Ive told them Login Id is associated with all things ITSM/CI's. I see this being a recipe for disaster. Can anyone help me out with your thoughts on this one please? Has anyone else done anything like this before? Thanks in Advance, Jase Brandon _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Re-use Login ID in Remedy
Maybe using their unique corporate id in the login name field, and using their Login in the special 'authentication alias' (I think that's what it's called) field on the user form (see docs) will be the best approach. Then all your last modified by, used by relationships, assignee login id's etc, are all tied to the unique corporate id while they can login using their 'jjones' login name as specified in the authentication alias. That's the most workable approach I see, and would require a one time mass conversion. Sent from my BlackBerry device on the Rogers Wireless Network -Original Message- From: Jase Brandon jasebran...@gmail.com Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG Date: Mon, 8 Oct 2012 18:49:02 To: arslist@ARSLIST.ORG Reply-To: arslist@ARSLIST.ORG Subject: Re: Re-use Login ID in Remedy I said the same thing guys. Let me elaborate a tad. They use a unique id for their company (custom attribute on the People form) that allows internal identification based on their unique identifier attribute, so they clam this will be acceptable when it comes to audits, I also brought up the SarBox issues. What concerns me is that Incidents/Changes/CI's, etc will have last modified by old guy instead of new guy. And... I haven't tried it yet, but I suspect the Data tool isn't going to do the trick as it relates to CI's. By reuse login Id' I was referring to: Ex. Joe Jones leaves the company and has a Remedy login ID of jjones. A new employee is hired, Judy Jones, and she is issued the old login id used for Joe Jones of jjones. So if the new employee Judy Jones logs on as jjones, does she suddenly inherit all the records previously owned/last updated by jjones as the original user of this id? Would she possibly see his Incidents/CI's, etc? I'm still trying to wrap my head around all this so pardon my rambling. :-) I've never had to deal with this issue in the past and wondered how the community handled this request or if anyone had ever had to deal with this issue before. 7.6.04 SP2 Windows Thanks, Jase On Mon, Oct 8, 2012 at 6:08 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** To echo Chris, I hope you don't work for a public company because that has to be against some sort of Sarbanes-Oxley regulation. Sent from my iPhone On Oct 8, 2012, at 4:11 PM, strauss stra...@unt.edu wrote: ** It is an incredibly bad security practice because it destroys any accountability for identity management. It is akin to reusing the social security numbers of deceased persons for newborns (try that analogy on them). We do battle with our PeopleSoft drones over this regularly, but it’s really a problem with them not having a unique index on the table for workforce ids; the LDAP login names almost never get duplicated, and our AD syncs to LDAP for that data. If you ever get a security audit, and they are reusing login ids in AD as a standard practice, your organization will fail the audit (unless the audit is by Arthur Andersen LLP). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Jase Brandon *Sent:* Monday, October 08, 2012 2:26 PM *To:* arslist@ARSLIST.ORG *Subject:* Re-use Login ID in Remedy ** Hello All, I have been approached and asked about how we can re-use Login Id' and I've never been asked to do this anywhere else. Of course my initial reply was We shouldn't Do That, but I need more of a justification as the company reuses login ids via AD as a standard. Ive told them Login Id is associated with all things ITSM/CI's. I see this being a recipe for disaster. Can anyone help me out with your thoughts on this one please? Has anyone else done anything like this before? Thanks in Advance, Jase Brandon _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: [EXTERNAL] Re: Re-use Login ID in Remedy
Jase: There's something I'm not following here...if this unique ID/custom attribute is for the company, why isn't it still possible that our hypothetical Joe and Judy Jones might both work for that company? Can you say a little more about what make this identifier unique? Thanks, Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2008 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jase Brandon Sent: Monday, October 08, 2012 4:49 PM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Re: Re-use Login ID in Remedy ** I said the same thing guys. Let me elaborate a tad. They use a unique id for their company (custom attribute on the People form) that allows internal identification based on their unique identifier attribute, so they clam this will be acceptable when it comes to audits, I also brought up the SarBox issues. What concerns me is that Incidents/Changes/CI's, etc will have last modified by old guy instead of new guy. And... I haven't tried it yet, but I suspect the Data tool isn't going to do the trick as it relates to CI's. By reuse login Id' I was referring to: Ex. Joe Jones leaves the company and has a Remedy login ID of jjones. A new employee is hired, Judy Jones, and she is issued the old login id used for Joe Jones of jjones. So if the new employee Judy Jones logs on as jjones, does she suddenly inherit all the records previously owned/last updated by jjones as the original user of this id? Would she possibly see his Incidents/CI's, etc? I'm still trying to wrap my head around all this so pardon my rambling. :-) I've never had to deal with this issue in the past and wondered how the community handled this request or if anyone had ever had to deal with this issue before. 7.6.04 SP2 Windows Thanks, Jase On Mon, Oct 8, 2012 at 6:08 PM, Tauf Chowdhury taufc...@gmail.commailto:taufc...@gmail.com wrote: ** To echo Chris, I hope you don't work for a public company because that has to be against some sort of Sarbanes-Oxley regulation. Sent from my iPhone On Oct 8, 2012, at 4:11 PM, strauss stra...@unt.edumailto:stra...@unt.edu wrote: ** It is an incredibly bad security practice because it destroys any accountability for identity management. It is akin to reusing the social security numbers of deceased persons for newborns (try that analogy on them). We do battle with our PeopleSoft drones over this regularly, but it's really a problem with them not having a unique index on the table for workforce ids; the LDAP login names almost never get duplicated, and our AD syncs to LDAP for that data. If you ever get a security audit, and they are reusing login ids in AD as a standard practice, your organization will fail the audit (unless the audit is by Arthur Andersen LLP). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jase Brandon Sent: Monday, October 08, 2012 2:26 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re-use Login ID in Remedy ** Hello All, I have been approached and asked about how we can re-use Login Id' and I've never been asked to do this anywhere else. Of course my initial reply was We shouldn't Do That, but I need more of a justification as the company reuses login ids via AD as a standard. Ive told them Login Id is associated with all things ITSM/CI's. I see this being a recipe for disaster. Can anyone help me out with your thoughts on this one please? Has anyone else done anything like this before? Thanks in Advance, Jase Brandon _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
User Login ID Server not being set at login ITSM 7.6.04
Has anyone seen this error? I can't find anything related to this error. When I search the ARSList the search times out. Setup - ARS 7.6.04 with ITSM 7.6.04 patch 1, Web only Access (Internet Explorer) I have one user that logs in to the system, however the Internet Explorer Status bar shows $USER$ | $SERVER$ It should show jdoe | myarserver The problem is when the user is selecting a Task from the IT Home Page Overview Console they get an error - A server name must be supplied in the control record (ARERR 150) I've done all the standard stuff, clear cache, restart computer, etc. The odd thing is this happens sporadically. sometimes the $USER$ and $SERVER$ are set properly, sometimes not. This is only occurring to one user. Thanks, Andre ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: User Login ID Server not being set at login ITSM 7.6.04
That error typically used to happen when someone came into mid-tier 7.1 using a book mark for the login page, which meant that they did not go through the server:port/arsys/home link which sets the server information. I cannot say that I have seen this error in 7.6.04.01, but it might depend on your web server (we use pure tomcat). The login page in 7.6.04 is different from that in 7.1, and in my experience leads to a normal login with server specified. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andre Hughes Sent: Wednesday, March 07, 2012 1:45 PM To: arslist@ARSLIST.ORG Subject: User Login ID Server not being set at login ITSM 7.6.04 Has anyone seen this error? I can't find anything related to this error. When I search the ARSList the search times out. Setup - ARS 7.6.04 with ITSM 7.6.04 patch 1, Web only Access (Internet Explorer) I have one user that logs in to the system, however the Internet Explorer Status bar shows $USER$ | $SERVER$ It should show jdoe | myarserver The problem is when the user is selecting a Task from the IT Home Page Overview Console they get an error - A server name must be supplied in the control record (ARERR 150) I've done all the standard stuff, clear cache, restart computer, etc. The odd thing is this happens sporadically. sometimes the $USER$ and $SERVER$ are set properly, sometimes not. This is only occurring to one user. Thanks, Andre ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
ITSM 7.6.04 - Modifying Multiple Login IDs (was - RE Modify login id)
I'm going to piggy back on this one Out of 600 support people I need to modify 176 of their Login IDs. Using the Data Wizard is tedious and very time consuming. Any ideas on a quick, complete and easy way to modify the Login Ids of these people. There are no tickets to be updated, just Assignment, User, Group, People etc. forms and such -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Thursday, November 11, 2010 10:20 AM To: arslist@ARSLIST.ORG Subject: Re: Modify login id Actually it was intended to be a question. Noticed I used a period instead of a question mark as it was being sent. Thanks for the answer. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Thursday, November 11, 2010 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: Modify login id Hi, I guess this was not really a question, but yes, absolutely! Best Regards - Misi, RRR AB, http://www.rrr.se Misi, Since this uses ARMergeEntry this would also work with the server set with Submitter Mode locked. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Thursday, November 11, 2010 3:14 AM To: arslist@ARSLIST.ORG Subject: Re: Modify login id Hi, It is in the RRR|Commands section and is called RRR|LoginConv: https://www.rrr.se/cgi/tools/main#rrrLoginConv It basically go through all regular forms and update those records that needs to be changed. It does not care which application or version is used, as it performs an exact match in all your fields, including diary-fields and status-history. It does not change Modify-Date or Modify-By, as the API-call ARMergeEntry is used (same as Import Tool). Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): Didn't Misi have a login converter tool to do this? http://www.rrr.se (although I'm not seeing it in the list of product right now.) Thad On Wed, Nov 10, 2010 at 12:17 PM, Larry Barnes larry.bar...@thecreek.comwrote: ** I'm wondering if anyone out there has a simple way of modifying a login id for a user and any of their tickets they have created, or been assigned. We have users that are given a login id one way if they are a contractor and a different way if they are an employee. The problem is some contractors eventually become employees. We want to be able to modify the employee's current People, User form records and at the same time modify any tickets associated with their old login id and link them with their new login id. I was thinking of creating workflow and a form, for input, but this may need to be a SQL script. I'm just curious if anyone else has done this and is willing to share. We are running on a windows server with ARS 7.5.00 patch 002 with ITSM 7.0.03 patch 009 Thanks, Larry B. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ITSM 7.6.04 - Modifying Multiple Login IDs (was - RE Modify login id)
Do you just want to modify the User form field or do you want to make the change on all forms that the login ID is stored on. -Original Message- From: Sanford, Claire claire.sanf...@memorialhermann.org To: arslist arslist@ARSLIST.ORG Sent: Mon, Jan 16, 2012 12:53 pm Subject: ITSM 7.6.04 - Modifying Multiple Login IDs (was - RE Modify login id) I'm going to piggy back on this one Out of 600 support people I need to modify 176 of their Login IDs. Using the ata Wizard is tedious and very time consuming. Any ideas on a quick, complete nd easy way to modify the Login Ids of these people. There are no tickets to be updated, just Assignment, User, Group, People etc. orms and such Original Message- rom: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] n Behalf Of Shellman, David ent: Thursday, November 11, 2010 10:20 AM o: arslist@ARSLIST.ORG ubject: Re: Modify login id Actually it was intended to be a question. Noticed I used a period instead of a uestion mark as it was being sent. Thanks for the answer. Dave -Original Message- rom: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] n Behalf Of Misi Mladoniczky ent: Thursday, November 11, 2010 10:14 AM o: arslist@ARSLIST.ORG ubject: Re: Modify login id Hi, I guess this was not really a question, but yes, absolutely! Best Regards - Misi, RRR AB, http://www.rrr.se Misi, Since this uses ARMergeEntry this would also work with the server set with Submitter Mode locked. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Thursday, November 11, 2010 3:14 AM To: arslist@ARSLIST.ORG Subject: Re: Modify login id Hi, It is in the RRR|Commands section and is called RRR|LoginConv: https://www.rrr.se/cgi/tools/main#rrrLoginConv It basically go through all regular forms and update those records that needs to be changed. It does not care which application or version is used, as it performs an exact match in all your fields, including diary-fields and status-history. It does not change Modify-Date or Modify-By, as the API-call ARMergeEntry is used (same as Import Tool). Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): Didn't Misi have a login converter tool to do this? http://www.rrr.se (although I'm not seeing it in the list of product right now.) Thad On Wed, Nov 10, 2010 at 12:17 PM, Larry Barnes larry.bar...@thecreek.comwrote: ** I'm wondering if anyone out there has a simple way of modifying a login id for a user and any of their tickets they have created, or been assigned. We have users that are given a login id one way if they are a contractor and a different way if they are an employee. The problem is some ontractors eventually become employees. We want to be able to modify the employee's urrent People, User form records and at the same time modify any tickets associated with heir old login id and link them with their new login id. I was thinking of creating workflow and a form, for input, but this may need to be a SQL script. I'm just curious if anyone else has done this and is willing to share. We are running on a windows server with ARS 7.5.00 patch 002 with ITSM 7.0.03 patch 009 Thanks, Larry B. ___ NSUBSCRIBE or access ARSlist Archives at www.arslist.org ttend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ITSM 7.6.04 - Modifying Multiple Login IDs (was - RE Modify login id)
I've used the DLD:SYS:DataWizAction form to bulk update login names. Open it up look at it. If you've already used the Data Wizard Console to make any changes, you can search see the records. Here is what I did: Exported the users that needed changing from CTM:People. Created a csv file. Imported the csv file into DLD:SYS:DataWizAction. Then - this is where it gets funky - I used a program called AutoHotKey to run through the everything I'd imported into DLD:SYS:DataWizAction update the records. The reason I used AutoHotKey is because I could make it wait for the update action to complete before moving on to the next record. A colleague recommended this help me set it up. You may be able to do the same thing with an escalation if you can make it update only one record at a time. Even if you don't use AutoHotKey it will be much faster if you import all of the records into DLD:SYS:DataWizAction. Also, BMC recommends escalations be disabled before updating login IDs but I don't always do this if the ID is pretty new doesn't have many or any records associated with it. HTH, Rebecca On Mon, Jan 16, 2012 at 12:53 PM, Sanford, Claire claire.sanf...@memorialhermann.org wrote: I'm going to piggy back on this one Out of 600 support people I need to modify 176 of their Login IDs. Using the Data Wizard is tedious and very time consuming. Any ideas on a quick, complete and easy way to modify the Login Ids of these people. There are no tickets to be updated, just Assignment, User, Group, People etc. forms and such -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Thursday, November 11, 2010 10:20 AM To: arslist@ARSLIST.ORG Subject: Re: Modify login id Actually it was intended to be a question. Noticed I used a period instead of a question mark as it was being sent. Thanks for the answer. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Thursday, November 11, 2010 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: Modify login id Hi, I guess this was not really a question, but yes, absolutely! Best Regards - Misi, RRR AB, http://www.rrr.se Misi, Since this uses ARMergeEntry this would also work with the server set with Submitter Mode locked. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Thursday, November 11, 2010 3:14 AM To: arslist@ARSLIST.ORG Subject: Re: Modify login id Hi, It is in the RRR|Commands section and is called RRR|LoginConv: https://www.rrr.se/cgi/tools/main#rrrLoginConv It basically go through all regular forms and update those records that needs to be changed. It does not care which application or version is used, as it performs an exact match in all your fields, including diary-fields and status-history. It does not change Modify-Date or Modify-By, as the API-call ARMergeEntry is used (same as Import Tool). Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): Didn't Misi have a login converter tool to do this? http://www.rrr.se (although I'm not seeing it in the list of product right now.) Thad On Wed, Nov 10, 2010 at 12:17 PM, Larry Barnes larry.bar...@thecreek.comwrote: ** I'm wondering if anyone out there has a simple way of modifying a login id for a user and any of their tickets they have created, or been assigned. We have users that are given a login id one way if they are a contractor and a different way if they are an employee. The problem is some contractors eventually become employees. We want to be able to modify the employee's current People, User form records and at the same time modify any tickets associated with their old login id and link them with their new login id. I was thinking of creating workflow and a form, for input, but this may need to be a SQL script. I'm just curious if anyone else has done this and is willing to share. We are running on a windows server with ARS 7.5.00 patch 002 with ITSM 7.0.03 patch 009 Thanks, Larry B. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Rebecca Boyd Application Administrator Wake Forest University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ITSM 7.6.04 - Modifying Multiple Login IDs (was - RE Modify login id)
Hi, Why not use RRR|LoginConv? https://www.rrr.se/cgi/tools/main#rrrLoginConv Reverse engineer the Data Wizard to see which forms to update, if you want to limit the search/replace. Best Regards - Misi, RRR AB, http://rrr.se I'm going to piggy back on this one Out of 600 support people I need to modify 176 of their Login IDs. Using the Data Wizard is tedious and very time consuming. Any ideas on a quick, complete and easy way to modify the Login Ids of these people. There are no tickets to be updated, just Assignment, User, Group, People etc. forms and such -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Thursday, November 11, 2010 10:20 AM To: arslist@ARSLIST.ORG Subject: Re: Modify login id Actually it was intended to be a question. Noticed I used a period instead of a question mark as it was being sent. Thanks for the answer. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Thursday, November 11, 2010 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: Modify login id Hi, I guess this was not really a question, but yes, absolutely! Best Regards - Misi, RRR AB, http://www.rrr.se Misi, Since this uses ARMergeEntry this would also work with the server set with Submitter Mode locked. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Thursday, November 11, 2010 3:14 AM To: arslist@ARSLIST.ORG Subject: Re: Modify login id Hi, It is in the RRR|Commands section and is called RRR|LoginConv: https://www.rrr.se/cgi/tools/main#rrrLoginConv It basically go through all regular forms and update those records that needs to be changed. It does not care which application or version is used, as it performs an exact match in all your fields, including diary-fields and status-history. It does not change Modify-Date or Modify-By, as the API-call ARMergeEntry is used (same as Import Tool). Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): Didn't Misi have a login converter tool to do this? http://www.rrr.se (although I'm not seeing it in the list of product right now.) Thad On Wed, Nov 10, 2010 at 12:17 PM, Larry Barnes larry.bar...@thecreek.comwrote: ** I'm wondering if anyone out there has a simple way of modifying a login id for a user and any of their tickets they have created, or been assigned. We have users that are given a login id one way if they are a contractor and a different way if they are an employee. The problem is some contractors eventually become employees. We want to be able to modify the employee's current People, User form records and at the same time modify any tickets associated with their old login id and link them with their new login id. I was thinking of creating workflow and a form, for input, but this may need to be a SQL script. I'm just curious if anyone else has done this and is willing to share. We are running on a windows server with ARS 7.5.00 patch 002 with ITSM 7.0.03 patch 009 Thanks, Larry B. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ITSM 7.6.04 - Modifying Multiple Login IDs (was - RE Modify login id)
Only forms that pertain to assignment etc. We don't care about work orders and incidents. We are not live yet. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Roger Justice Sent: Monday, January 16, 2012 11:56 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7.6.04 - Modifying Multiple Login IDs (was - RE Modify login id) ** Do you just want to modify the User form field or do you want to make the change on all forms that the login ID is stored on. -Original Message- From: Sanford, Claire claire.sanf...@memorialhermann.org To: arslist arslist@ARSLIST.ORG Sent: Mon, Jan 16, 2012 12:53 pm Subject: ITSM 7.6.04 - Modifying Multiple Login IDs (was - RE Modify login id) I'm going to piggy back on this one Out of 600 support people I need to modify 176 of their Login IDs. Using the Data Wizard is tedious and very time consuming. Any ideas on a quick, complete and easy way to modify the Login Ids of these people. There are no tickets to be updated, just Assignment, User, Group, People etc. forms and such -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG?] On Behalf Of Shellman, David Sent: Thursday, November 11, 2010 10:20 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Modify login id Actually it was intended to be a question. Noticed I used a period instead of a question mark as it was being sent. Thanks for the answer. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG?] On Behalf Of Misi Mladoniczky Sent: Thursday, November 11, 2010 10:14 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Modify login id Hi, I guess this was not really a question, but yes, absolutely! Best Regards - Misi, RRR AB, http://www.rrr.sehttp://www.rrr.se/ Misi, Since this uses ARMergeEntry this would also work with the server set with Submitter Mode locked. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG?] On Behalf Of Misi Mladoniczky Sent: Thursday, November 11, 2010 3:14 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Modify login id Hi, It is in the RRR|Commands section and is called RRR|LoginConv: https://www.rrr.se/cgi/tools/main#rrrLoginConv It basically go through all regular forms and update those records that needs to be changed. It does not care which application or version is used, as it performs an exact match in all your fields, including diary-fields and status-history. It does not change Modify-Date or Modify-By, as the API-call ARMergeEntry is used (same as Import Tool). Best Regards - Misi, RRR AB, http://www.rrr.sehttp://www.rrr.se/ Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): Didn't Misi have a login converter tool to do this? http://www.rrr.sehttp://www.rrr.se/ (although I'm not seeing it in the list of product right now.) Thad On Wed, Nov 10, 2010 at 12:17 PM, Larry Barnes larry.bar...@thecreek.commailto:larry.bar...@thecreek.comwrote: ** I'm wondering if anyone out there has a simple way of modifying a login id for a user and any of their tickets they have created, or been assigned. We have users that are given a login id one way if they are a contractor and a different way if they are an employee. The problem is some contractors eventually become employees. We want to be able to modify the employee's current People, User form records and at the same time modify any tickets associated with their old login id and link them with their new login id. I was thinking of creating workflow and a form, for input, but this may need to be a SQL script. I'm just curious if anyone else has done this and is willing to share. We are running on a windows server with ARS 7.5.00 patch 002 with ITSM 7.0.03 patch 009 Thanks, Larry B. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org/ attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com/ ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: LogIn ID
Hi, The Data Wizard is a good choice, as it knows the important places where you need to change Login ID, it is also fast, as it performs the updates directly in the database. RRR|LoginConv is very complete, but takes a lot of time to run, as it has to read each and every record in your system to decide where updates are needed. It updates things like Status-History, Diary-Fields and 60xxx/112 fields where the Login Name is sometimes used. You can limit this by specifying fields and forms, but in this case you need to know where updates may be needed. Another good thing with RRR|LoginConv is that it can update multiple login names in a single run. It could be 10, 100 or 1000. Download and documentation at: https://www.rrr.se/cgi/tools/main#rrrLoginConv Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Or, if you are using ITSM 7.6+ then you have access to the Data Wizard which you can use to change the Login ID throughout the system (works on many other fields too). -Patrick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brien Dieterle Sent: December 2, 2011 06:22 PM To: arslist@ARSLIST.ORG Subject: Re: LogIn ID ** Misi makes a great tool called LoginConv that can scour multiple fields in all forms the do the translation. http://www.rrr.se Brien On 12/2/2011 4:13 PM, Mike Hocks wrote: Hello Everyone, I am wondering if there is a way to change the Login ID on the user record in a Remedy 7.6.04 environment, for example we use part of the employees first and last name in the Remedy Login ID (The Remedy User Account is defined by the Active Directory account) when an employee's name changes we need to reflect this on the Remedy people record Login ID. Is there a way to safely do this? Thanks, -Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: LogIn ID
Or, if you are using ITSM 7.6+ then you have access to the Data Wizard which you can use to change the Login ID throughout the system (works on many other fields too). -Patrick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brien Dieterle Sent: December 2, 2011 06:22 PM To: arslist@ARSLIST.ORG Subject: Re: LogIn ID ** Misi makes a great tool called LoginConv that can scour multiple fields in all forms the do the translation. http://www.rrr.se Brien On 12/2/2011 4:13 PM, Mike Hocks wrote: Hello Everyone, I am wondering if there is a way to change the Login ID on the user record in a Remedy 7.6.04 environment, for example we use part of the employees first and last name in the Remedy Login ID (The Remedy User Account is defined by the Active Directory account) when an employee's name changes we need to reflect this on the Remedy people record Login ID. Is there a way to safely do this? Thanks, -Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: LogIn ID
A safe idea would be to use Login Alias (field 118 I think is the reserved ID for this..) The alternative is to change it database wide but that would mean changes in field 2, field 4, and any other tables that store login information such as custom application fields, diary fields, etc, history tables, and some other tables in the meta data that may store login names (owner)... This is a more involved process if you do it at DB level, but Misi has a product that can do this (3rd party utility) that you can look for on his website.. Joe -Original Message- From: Mike Hocks Sent: Friday, December 02, 2011 6:13 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: LogIn ID Hello Everyone, I am wondering if there is a way to change the Login ID on the user record in a Remedy 7.6.04 environment, for example we use part of the employees first and last name in the Remedy Login ID (The Remedy User Account is defined by the Active Directory account) when an employee's name changes we need to reflect this on the Remedy people record Login ID. Is there a way to safely do this? Thanks, -Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
LogIn ID
Hello Everyone, I am wondering if there is a way to change the Login ID on the user record in a Remedy 7.6.04 environment, for example we use part of the employees first and last name in the Remedy Login ID (The Remedy User Account is defined by the Active Directory account) when an employee's name changes we need to reflect this on the Remedy people record Login ID. Is there a way to safely do this? Thanks, -Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: LogIn ID
** Misi makes a great tool called LoginConv that can scour multiple fields in all forms the do the translation. http://www.rrr.se Brien On 12/2/2011 4:13 PM, Mike Hocks wrote: Hello Everyone, I am wondering if there is a way to change the Login ID on the user record in a Remedy 7.6.04 environment, for example we use part of the employees first and last name in the Remedy Login ID (The Remedy User Account is defined by the Active Directory account) when an employee's name changes we need to reflect this on the Remedy people record Login ID. Is there a way to safely do this? Thanks, -Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: Using login id in field 112
Hi, Can you try to export the data into an ARX-file. You should get the exact thing contained in the database if you do that. It may be interesting to see if it really contains what you want it to contain. I would be very surprised if this core functionality was broken in 7.6.04! Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Yep. It is. I think we have tried just about every possible combination of syntax. The odd thing is that it either pops up with the group error or populates with the settings from the Dynamic Access field on the user form. It looks like it is somehow using that field as a translation from the user form. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Thursday, September 29, 2011 4:26 PM To: arslist@ARSLIST.ORG Subject: Re: Using login id in field 112 ** Did you check that your servers is configured to allow multiple assignee groups? Axton Grams On Thu, Sep 29, 2011 at 3:04 PM, Brian Pancia panc...@finityit.com wrote: ** Tried droping the quotes and semicolons at the beginning and end. Also, tried using field 6090 and 112. Neither work. This might be a bug in 7.6.04. The documentation says it's support, but it looks like I might have to go the individual group route. On Thu, Sep 29, 2011 at 9:44 AM, Frank Caruso caruso.fr...@gmail.com wrote: ** I tested the following in version 7.1p7: Set Field ID 112 to: 'user login';'user login';'user login' Set request ID to Assigned Group permission only. Only users whose userid appears in field id 112 can see the record. On Thu, Sep 29, 2011 at 9:35 AM, Misi Mladoniczky m...@rrr.se wrote: Hi Axton, I tried this with the 112 field when the 60xxx fields was first introduced, but was unable to get it to work for 112... Maybe I made a mistake, or this was added/fixed later... Best Regards - Misi, RRR AB, http://rrr.se http://rrr.se/ From the docs it appears both field types support login names, group names, and role names: *To permit multiple user, group, and role names in the Assignee Group field and dynamic fields, select Enable Multiple Assign Groups on the Configuration tab of AR System Administration: Server Information form. To enter users Dan O'Connor and Mary Manager, group ID 12000, role ID -9000, and role Managers, use the following syntax:* * * *'Dan O''Connor';'Mary Manager';12000;-9000;Managers* Axton Grams On Thu, Sep 29, 2011 at 8:26 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I do not think that the 112-field can hold user names. You have to use the 60xxx-fields for that. If you use those fields, your syntax should be correct. Just to be clear, the value of the data should be: ;'joeuser';'janeuser'; Best Regards - Misi, RRR AB, http://www.rrr.se http://www.rrr.se/ (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se http://rrr.se/ . We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user as their own group. However, adding groups for each user and maintaining that as people are added/removed would probably not be the best idea. Has anyone had any success implementing this in 7.6.04? Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug11 www.wwrug.com http://www.wwrug.com/ ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug11 www.wwrug.com http://www.wwrug.com/ ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug11 www.wwrug.com http://www.wwrug.com
Re: Using login id in field 112
I'll do an export. I was a little taken back myself. If you look at the Dynamic Group Access field on the User form in 7.6.04 you will notice that Public is in there a few times. They set this up much like the Vendor Group field. There is workflow tied to this that sets it to the login id, but is then translated to Public, which is a little scary. I did setup individual groups for each user. I know this is not ideal, but I had to get something out quickly. Since this is for support staff only and the turn over rate is not high this approach would not take a major performance hit on the system. I am still waiting to hear back from BMC on this one, but something definetly changed with 7.6.04 that appears to have broken field 112 and dynamic groups. On Mon, Oct 3, 2011 at 2:48 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, Can you try to export the data into an ARX-file. You should get the exact thing contained in the database if you do that. It may be interesting to see if it really contains what you want it to contain. I would be very surprised if this core functionality was broken in 7.6.04! Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Yep. It is. I think we have tried just about every possible combination of syntax. The odd thing is that it either pops up with the group error or populates with the settings from the Dynamic Access field on the user form. It looks like it is somehow using that field as a translation from the user form. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Thursday, September 29, 2011 4:26 PM To: arslist@ARSLIST.ORG Subject: Re: Using login id in field 112 ** Did you check that your servers is configured to allow multiple assignee groups? Axton Grams On Thu, Sep 29, 2011 at 3:04 PM, Brian Pancia panc...@finityit.com wrote: ** Tried droping the quotes and semicolons at the beginning and end. Also, tried using field 6090 and 112. Neither work. This might be a bug in 7.6.04. The documentation says it's support, but it looks like I might have to go the individual group route. On Thu, Sep 29, 2011 at 9:44 AM, Frank Caruso caruso.fr...@gmail.com wrote: ** I tested the following in version 7.1p7: Set Field ID 112 to: 'user login';'user login';'user login' Set request ID to Assigned Group permission only. Only users whose userid appears in field id 112 can see the record. On Thu, Sep 29, 2011 at 9:35 AM, Misi Mladoniczky m...@rrr.se wrote: Hi Axton, I tried this with the 112 field when the 60xxx fields was first introduced, but was unable to get it to work for 112... Maybe I made a mistake, or this was added/fixed later... Best Regards - Misi, RRR AB, http://rrr.se http://rrr.se/ From the docs it appears both field types support login names, group names, and role names: *To permit multiple user, group, and role names in the Assignee Group field and dynamic fields, select Enable Multiple Assign Groups on the Configuration tab of AR System Administration: Server Information form. To enter users Dan O'Connor and Mary Manager, group ID 12000, role ID -9000, and role Managers, use the following syntax:* * * *'Dan O''Connor';'Mary Manager';12000;-9000;Managers* Axton Grams On Thu, Sep 29, 2011 at 8:26 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I do not think that the 112-field can hold user names. You have to use the 60xxx-fields for that. If you use those fields, your syntax should be correct. Just to be clear, the value of the data should be: ;'joeuser';'janeuser'; Best Regards - Misi, RRR AB, http://www.rrr.se http://www.rrr.se/ (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se http://rrr.se/ . We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user
Using login id in field 112
We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user as their own group. However, adding groups for each user and maintaining that as people are added/removed would probably not be the best idea. Has anyone had any success implementing this in 7.6.04? Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Using login id in field 112
Drop the leading and trailing semi-colon, make sure those double quotes are not part of the value. Make sure the server is configured for multiple assignee groups (Server Configuration- Configuration- Enable Multiple Assign Groups). Axton Grams On Thu, Sep 29, 2011 at 7:20 AM, Brian Pancia panc...@finityit.com wrote: ** We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user as their own group. However, adding groups for each user and maintaining that as people are added/removed would probably not be the best idea. Has anyone had any success implementing this in 7.6.04? ** ** Brian ** ** _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Using login id in field 112
Hi, I do not think that the 112-field can hold user names. You have to use the 60xxx-fields for that. If you use those fields, your syntax should be correct. Just to be clear, the value of the data should be: ;'joeuser';'janeuser'; Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user as their own group. However, adding groups for each user and maintaining that as people are added/removed would probably not be the best idea. Has anyone had any success implementing this in 7.6.04? Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Using login id in field 112
From the docs it appears both field types support login names, group names, and role names: *To permit multiple user, group, and role names in the Assignee Group field and dynamic fields, select Enable Multiple Assign Groups on the Configuration tab of AR System Administration: Server Information form. To enter users Dan O’Connor and Mary Manager, group ID 12000, role ID -9000, and role Managers, use the following syntax:* * * *‘Dan O’’Connor’;’Mary Manager’;12000;-9000;Managers* Axton Grams On Thu, Sep 29, 2011 at 8:26 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I do not think that the 112-field can hold user names. You have to use the 60xxx-fields for that. If you use those fields, your syntax should be correct. Just to be clear, the value of the data should be: ;'joeuser';'janeuser'; Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user as their own group. However, adding groups for each user and maintaining that as people are added/removed would probably not be the best idea. Has anyone had any success implementing this in 7.6.04? Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Using login id in field 112
Hi Axton, I tried this with the 112 field when the 60xxx fields was first introduced, but was unable to get it to work for 112... Maybe I made a mistake, or this was added/fixed later... Best Regards - Misi, RRR AB, http://rrr.se From the docs it appears both field types support login names, group names, and role names: *To permit multiple user, group, and role names in the Assignee Group field and dynamic fields, select Enable Multiple Assign Groups on the Configuration tab of AR System Administration: Server Information form. To enter users Dan O’Connor and Mary Manager, group ID 12000, role ID -9000, and role Managers, use the following syntax:* * * *‘Dan O’’Connor’;’Mary Manager’;12000;-9000;Managers* Axton Grams On Thu, Sep 29, 2011 at 8:26 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I do not think that the 112-field can hold user names. You have to use the 60xxx-fields for that. If you use those fields, your syntax should be correct. Just to be clear, the value of the data should be: ;'joeuser';'janeuser'; Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user as their own group. However, adding groups for each user and maintaining that as people are added/removed would probably not be the best idea. Has anyone had any success implementing this in 7.6.04? Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Using login id in field 112
I tested the following in version 7.1p7: Set Field ID 112 to: 'user login';'user login';'user login' Set request ID to Assigned Group permission only. Only users whose userid appears in field id 112 can see the record. On Thu, Sep 29, 2011 at 9:35 AM, Misi Mladoniczky m...@rrr.se wrote: Hi Axton, I tried this with the 112 field when the 60xxx fields was first introduced, but was unable to get it to work for 112... Maybe I made a mistake, or this was added/fixed later... Best Regards - Misi, RRR AB, http://rrr.se From the docs it appears both field types support login names, group names, and role names: *To permit multiple user, group, and role names in the Assignee Group field and dynamic fields, select Enable Multiple Assign Groups on the Configuration tab of AR System Administration: Server Information form. To enter users Dan O’Connor and Mary Manager, group ID 12000, role ID -9000, and role Managers, use the following syntax:* * * *‘Dan O’’Connor’;’Mary Manager’;12000;-9000;Managers* Axton Grams On Thu, Sep 29, 2011 at 8:26 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I do not think that the 112-field can hold user names. You have to use the 60xxx-fields for that. If you use those fields, your syntax should be correct. Just to be clear, the value of the data should be: ;'joeuser';'janeuser'; Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user as their own group. However, adding groups for each user and maintaining that as people are added/removed would probably not be the best idea. Has anyone had any success implementing this in 7.6.04? Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Using login id in field 112
Tried droping the quotes and semicolons at the beginning and end. Also, tried using field 6090 and 112. Neither work. This might be a bug in 7.6.04. The documentation says it's support, but it looks like I might have to go the individual group route. On Thu, Sep 29, 2011 at 9:44 AM, Frank Caruso caruso.fr...@gmail.comwrote: ** I tested the following in version 7.1p7: Set Field ID 112 to: 'user login';'user login';'user login' Set request ID to Assigned Group permission only. Only users whose userid appears in field id 112 can see the record. On Thu, Sep 29, 2011 at 9:35 AM, Misi Mladoniczky m...@rrr.se wrote: Hi Axton, I tried this with the 112 field when the 60xxx fields was first introduced, but was unable to get it to work for 112... Maybe I made a mistake, or this was added/fixed later... Best Regards - Misi, RRR AB, http://rrr.se From the docs it appears both field types support login names, group names, and role names: *To permit multiple user, group, and role names in the Assignee Group field and dynamic fields, select Enable Multiple Assign Groups on the Configuration tab of AR System Administration: Server Information form. To enter users Dan O’Connor and Mary Manager, group ID 12000, role ID -9000, and role Managers, use the following syntax:* * * *‘Dan O’’Connor’;’Mary Manager’;12000;-9000;Managers* Axton Grams On Thu, Sep 29, 2011 at 8:26 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I do not think that the 112-field can hold user names. You have to use the 60xxx-fields for that. If you use those fields, your syntax should be correct. Just to be clear, the value of the data should be: ;'joeuser';'janeuser'; Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user as their own group. However, adding groups for each user and maintaining that as people are added/removed would probably not be the best idea. Has anyone had any success implementing this in 7.6.04? Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Using login id in field 112
Did you check that your servers is configured to allow multiple assignee groups? Axton Grams On Thu, Sep 29, 2011 at 3:04 PM, Brian Pancia panc...@finityit.com wrote: ** Tried droping the quotes and semicolons at the beginning and end. Also, tried using field 6090 and 112. Neither work. This might be a bug in 7.6.04. The documentation says it's support, but it looks like I might have to go the individual group route. On Thu, Sep 29, 2011 at 9:44 AM, Frank Caruso caruso.fr...@gmail.comwrote: ** I tested the following in version 7.1p7: Set Field ID 112 to: 'user login';'user login';'user login' Set request ID to Assigned Group permission only. Only users whose userid appears in field id 112 can see the record. On Thu, Sep 29, 2011 at 9:35 AM, Misi Mladoniczky m...@rrr.se wrote: Hi Axton, I tried this with the 112 field when the 60xxx fields was first introduced, but was unable to get it to work for 112... Maybe I made a mistake, or this was added/fixed later... Best Regards - Misi, RRR AB, http://rrr.se From the docs it appears both field types support login names, group names, and role names: *To permit multiple user, group, and role names in the Assignee Group field and dynamic fields, select Enable Multiple Assign Groups on the Configuration tab of AR System Administration: Server Information form. To enter users Dan O’Connor and Mary Manager, group ID 12000, role ID -9000, and role Managers, use the following syntax:* * * *‘Dan O’’Connor’;’Mary Manager’;12000;-9000;Managers* Axton Grams On Thu, Sep 29, 2011 at 8:26 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I do not think that the 112-field can hold user names. You have to use the 60xxx-fields for that. If you use those fields, your syntax should be correct. Just to be clear, the value of the data should be: ;'joeuser';'janeuser'; Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user as their own group. However, adding groups for each user and maintaining that as people are added/removed would probably not be the best idea. Has anyone had any success implementing this in 7.6.04? Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Using login id in field 112
I am using ARS 6.3 and have multiple groups in field 112. In my case the groups I am using are one word groups such as Group1 Group2 I don't have quotes or semi-colons in between. Just a space and it works fine. Not sure how that might work with multi-names like Help Desk but thought I would pass this along. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia Sent: Thursday, September 29, 2011 4:05 PM To: arslist@ARSLIST.ORG Subject: Re: Using login id in field 112 ** Tried droping the quotes and semicolons at the beginning and end. Also, tried using field 6090 and 112. Neither work. This might be a bug in 7.6.04. The documentation says it's support, but it looks like I might have to go the individual group route. On Thu, Sep 29, 2011 at 9:44 AM, Frank Caruso caruso.fr...@gmail.commailto:caruso.fr...@gmail.com wrote: ** I tested the following in version 7.1p7: Set Field ID 112 to: 'user login';'user login';'user login' Set request ID to Assigned Group permission only. Only users whose userid appears in field id 112 can see the record. On Thu, Sep 29, 2011 at 9:35 AM, Misi Mladoniczky m...@rrr.semailto:m...@rrr.se wrote: Hi Axton, I tried this with the 112 field when the 60xxx fields was first introduced, but was unable to get it to work for 112... Maybe I made a mistake, or this was added/fixed later... Best Regards - Misi, RRR AB, http://rrr.sehttp://rrr.se/ From the docs it appears both field types support login names, group names, and role names: *To permit multiple user, group, and role names in the Assignee Group field and dynamic fields, select Enable Multiple Assign Groups on the Configuration tab of AR System Administration: Server Information form. To enter users Dan O'Connor and Mary Manager, group ID 12000, role ID -9000, and role Managers, use the following syntax:* * * *'Dan O''Connor';'Mary Manager';12000;-9000;Managers* Axton Grams On Thu, Sep 29, 2011 at 8:26 AM, Misi Mladoniczky m...@rrr.semailto:m...@rrr.se wrote: Hi, I do not think that the 112-field can hold user names. You have to use the 60xxx-fields for that. If you use those fields, your syntax should be correct. Just to be clear, the value of the data should be: ;'joeuser';'janeuser'; Best Regards - Misi, RRR AB, http://www.rrr.sehttp://www.rrr.se/ (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.sehttp://rrr.se/. We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user as their own group. However, adding groups for each user and maintaining that as people are added/removed would probably not be the best idea. Has anyone had any success implementing this in 7.6.04? Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org/ attend wwrug11 www.wwrug.comhttp://www.wwrug.com/ ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org/ attend wwrug11 www.wwrug.comhttp://www.wwrug.com/ ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org/ attend wwrug11 www.wwrug.comhttp://www.wwrug.com/ ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org/ attend wwrug11 www.wwrug.comhttp://www.wwrug.com/ ARSList: Where the Answers Are _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended
Re: Using login id in field 112
Mark, Groups work fine. It's user names that are not going through. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Thursday, September 29, 2011 5:05 PM To: arslist@ARSLIST.ORG Subject: Re: Using login id in field 112 ** I am using ARS 6.3 and have multiple groups in field 112. In my case the groups I am using are one word groups such as Group1 Group2 I don't have quotes or semi-colons in between. Just a space and it works fine. Not sure how that might work with multi-names like Help Desk but thought I would pass this along. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia Sent: Thursday, September 29, 2011 4:05 PM To: arslist@ARSLIST.ORG Subject: Re: Using login id in field 112 ** Tried droping the quotes and semicolons at the beginning and end. Also, tried using field 6090 and 112. Neither work. This might be a bug in 7.6.04. The documentation says it's support, but it looks like I might have to go the individual group route. On Thu, Sep 29, 2011 at 9:44 AM, Frank Caruso caruso.fr...@gmail.com wrote: ** I tested the following in version 7.1p7: Set Field ID 112 to: 'user login';'user login';'user login' Set request ID to Assigned Group permission only. Only users whose userid appears in field id 112 can see the record. On Thu, Sep 29, 2011 at 9:35 AM, Misi Mladoniczky m...@rrr.se wrote: Hi Axton, I tried this with the 112 field when the 60xxx fields was first introduced, but was unable to get it to work for 112... Maybe I made a mistake, or this was added/fixed later... Best Regards - Misi, RRR AB, http://rrr.se http://rrr.se/ From the docs it appears both field types support login names, group names, and role names: *To permit multiple user, group, and role names in the Assignee Group field and dynamic fields, select Enable Multiple Assign Groups on the Configuration tab of AR System Administration: Server Information form. To enter users Dan O'Connor and Mary Manager, group ID 12000, role ID -9000, and role Managers, use the following syntax:* * * *'Dan O''Connor';'Mary Manager';12000;-9000;Managers* Axton Grams On Thu, Sep 29, 2011 at 8:26 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I do not think that the 112-field can hold user names. You have to use the 60xxx-fields for that. If you use those fields, your syntax should be correct. Just to be clear, the value of the data should be: ;'joeuser';'janeuser'; Best Regards - Misi, RRR AB, http://www.rrr.se http://www.rrr.se/ (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se http://rrr.se/ . We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user as their own group. However, adding groups for each user and maintaining that as people are added/removed would probably not be the best idea. Has anyone had any success implementing this in 7.6.04? Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug11 www.wwrug.com http://www.wwrug.com/ ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug11 www.wwrug.com http://www.wwrug.com/ ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug11 www.wwrug.com http://www.wwrug.com/ ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug11 www.wwrug.com http://www.wwrug.com/ ARSList: Where the Answers Are _attend WWRUG11 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity
Re: Using login id in field 112
Yep. It is. I think we have tried just about every possible combination of syntax. The odd thing is that it either pops up with the group error or populates with the settings from the Dynamic Access field on the user form. It looks like it is somehow using that field as a translation from the user form. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Thursday, September 29, 2011 4:26 PM To: arslist@ARSLIST.ORG Subject: Re: Using login id in field 112 ** Did you check that your servers is configured to allow multiple assignee groups? Axton Grams On Thu, Sep 29, 2011 at 3:04 PM, Brian Pancia panc...@finityit.com wrote: ** Tried droping the quotes and semicolons at the beginning and end. Also, tried using field 6090 and 112. Neither work. This might be a bug in 7.6.04. The documentation says it's support, but it looks like I might have to go the individual group route. On Thu, Sep 29, 2011 at 9:44 AM, Frank Caruso caruso.fr...@gmail.com wrote: ** I tested the following in version 7.1p7: Set Field ID 112 to: 'user login';'user login';'user login' Set request ID to Assigned Group permission only. Only users whose userid appears in field id 112 can see the record. On Thu, Sep 29, 2011 at 9:35 AM, Misi Mladoniczky m...@rrr.se wrote: Hi Axton, I tried this with the 112 field when the 60xxx fields was first introduced, but was unable to get it to work for 112... Maybe I made a mistake, or this was added/fixed later... Best Regards - Misi, RRR AB, http://rrr.se http://rrr.se/ From the docs it appears both field types support login names, group names, and role names: *To permit multiple user, group, and role names in the Assignee Group field and dynamic fields, select Enable Multiple Assign Groups on the Configuration tab of AR System Administration: Server Information form. To enter users Dan O'Connor and Mary Manager, group ID 12000, role ID -9000, and role Managers, use the following syntax:* * * *'Dan O''Connor';'Mary Manager';12000;-9000;Managers* Axton Grams On Thu, Sep 29, 2011 at 8:26 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I do not think that the 112-field can hold user names. You have to use the 60xxx-fields for that. If you use those fields, your syntax should be correct. Just to be clear, the value of the data should be: ;'joeuser';'janeuser'; Best Regards - Misi, RRR AB, http://www.rrr.se http://www.rrr.se/ (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se http://rrr.se/ . We are currently trying to setup ITSM 7.6.04 to restrict access based on a selected group of people. This group will be different for each ticket. Basically, the user will go into an Incident and select people to add to a restricted access list. We are trying to push this list of users to field 112. The BMC workflow documentation spells out the syntax (;'joeuser';'janeuser';). However, this throws out Error 417 stating there is no group defined. Now a way around this is to add each user as their own group. However, adding groups for each user and maintaining that as people are added/removed would probably not be the best idea. Has anyone had any success implementing this in 7.6.04? Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug11 www.wwrug.com http://www.wwrug.com/ ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug11 www.wwrug.com http://www.wwrug.com/ ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug11 www.wwrug.com http://www.wwrug.com/ ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug11 www.wwrug.com http://www.wwrug.com/ ARSList: Where the Answers Are _attend WWRUG11 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where
Re: Bulk Change of login ID
Morning all, Just an update on this, I've tested a login ID change using the Data Wizard Console on our development platform, and it's a non-starter. I kicked it off on Tuesday at around 11:00hrs, and it's still running. Thinking it might be that our dev platform is not exactly built for performance, I also ran the same test for a single user on our Prod system, kicking this off at 17:30hrs yesterday - that is also still running :( More investigation required as that doesn't seem quite right to me, as we have no performance issues on our prod platform, in fact, when we brought it in to service. the performance of our boxes actually caused a problem because they were too fast - this was related to rebuilding Service Targets and associated milestones. Cheers - Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
Did you disable escalations first? I think the official instructions say to do that. On Thu, Jun 16, 2011 at 8:38 AM, Michael Burton michael_bur...@hotmail.co.uk wrote: ** Morning all, Just an update on this, I've tested a login ID change using the Data Wizard Console on our development platform, and it's a non-starter. I kicked it off on Tuesday at around 11:00hrs, and it's still running. Thinking it might be that our dev platform is not exactly built for performance, I also ran the same test for a single user on our Prod system, kicking this off at 17:30hrs yesterday - that is also still running :( More investigation required as that doesn't seem quite right to me, as we have no performance issues on our prod platform, in fact, when we brought it in to service. the performance of our boxes actually caused a problem because they were too fast - this was related to rebuilding Service Targets and associated milestones. Cheers - Mike _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Rebecca Boyd Application Administrator Wake Forest University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
That may be a sensible thing to do.. You do not want escalations to be firing when that process is running. Since it’s a Remedy native wizard, you do not have the luxury of completely shutting down the Remedy server. When I had done this using a DB script I had that luxury.. Joe -Original Message- From: Boyd, Rebecca Sent: Thursday, June 16, 2011 9:26 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID Did you disable escalations first? I think the official instructions say to do that. On Thu, Jun 16, 2011 at 8:38 AM, Michael Burton michael_bur...@hotmail.co.uk wrote: ** Morning all, Just an update on this, I've tested a login ID change using the Data Wizard Console on our development platform, and it's a non-starter. I kicked it off on Tuesday at around 11:00hrs, and it's still running. Thinking it might be that our dev platform is not exactly built for performance, I also ran the same test for a single user on our Prod system, kicking this off at 17:30hrs yesterday - that is also still running :( More investigation required as that doesn't seem quite right to me, as we have no performance issues on our prod platform, in fact, when we brought it in to service. the performance of our boxes actually caused a problem because they were too fast - this was related to rebuilding Service Targets and associated milestones. Cheers - Mike _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Rebecca Boyd Application Administrator Wake Forest University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
I may also want to add, that if the wizard actually uses one or more escalation to do some of the updates, then a more sensible thing to do is disable the ones not needed, just before running the process, instead of turning the escalation thread off altogether.. Or you may end up wondering why the process is not working altogether.. Joe -Original Message- From: Joe Martin D'Souza Sent: Thursday, June 16, 2011 12:30 PM To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID That may be a sensible thing to do.. You do not want escalations to be firing when that process is running. Since it’s a Remedy native wizard, you do not have the luxury of completely shutting down the Remedy server. When I had done this using a DB script I had that luxury.. Joe -Original Message- From: Boyd, Rebecca Sent: Thursday, June 16, 2011 9:26 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID Did you disable escalations first? I think the official instructions say to do that. On Thu, Jun 16, 2011 at 8:38 AM, Michael Burton michael_bur...@hotmail.co.uk wrote: ** Morning all, Just an update on this, I've tested a login ID change using the Data Wizard Console on our development platform, and it's a non-starter. I kicked it off on Tuesday at around 11:00hrs, and it's still running. Thinking it might be that our dev platform is not exactly built for performance, I also ran the same test for a single user on our Prod system, kicking this off at 17:30hrs yesterday - that is also still running :( More investigation required as that doesn't seem quite right to me, as we have no performance issues on our prod platform, in fact, when we brought it in to service. the performance of our boxes actually caused a problem because they were too fast - this was related to rebuilding Service Targets and associated milestones. Cheers - Mike _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Rebecca Boyd Application Administrator Wake Forest University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
Do you get the pop-up saying that the change is still pending? It never changes to completed? We've had a job or two hang up, but ID changes generally take about 2-5 minutes depending how active the user is. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michael Burton Sent: Thursday, June 16, 2011 8:38 AM To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID ** Morning all, Just an update on this, I've tested a login ID change using the Data Wizard Console on our development platform, and it's a non-starter. I kicked it off on Tuesday at around 11:00hrs, and it's still running. Thinking it might be that our dev platform is not exactly built for performance, I also ran the same test for a single user on our Prod system, kicking this off at 17:30hrs yesterday - that is also still running :( More investigation required as that doesn't seem quite right to me, as we have no performance issues on our prod platform, in fact, when we brought it in to service. the performance of our boxes actually caused a problem because they were too fast - this was related to rebuilding Service Targets and associated milestones. Cheers - Mike _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
That's what we've got at the moment, but as you say, it does seem to have done the job. Date: Thu, 16 Jun 2011 13:11:17 -0400 From: anne.ra...@nc.gov Subject: Re: Bulk Change of login ID To: arslist@ARSLIST.ORG ** Do you get the pop-up saying that the change is still pending? It never changes to completed? We’ve had a job or two hang up, but ID changes generally take about 2-5 minutes depending how active the user is. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
What you need to do is to check the DTD:ThreadManager form. Open the form and delete all records and restart your job again. I have seen it happened before that for some reason this record gets stuck and it does not get updated. -Moe http://www.remedycloud.com From: Michael Burton [mailto:michael_bur...@hotmail.co.uk] Sent: Thursday, June 16, 2011 1:28 PM Subject: Re: Bulk Change of login ID ** That's what we've got at the moment, but as you say, it does seem to have done the job. _ Date: Thu, 16 Jun 2011 13:11:17 -0400 From: anne.ra...@nc.gov Subject: Re: Bulk Change of login ID To: arslist@ARSLIST.ORG ** Do you get the pop-up saying that the change is still pending? It never changes to completed? We've had a job or two hang up, but ID changes generally take about 2-5 minutes depending how active the user is. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
Hi Moe Just wanted to know if the link from your signature line is genuine because the content on that page has nothing to do with ARS Remedy. Thanks Mahesh From: *Gmail* moe.abdela...@gmail.com Date: Thu, Jun 16, 2011 at 11:56 PM Subject: Re: Bulk Change of login ID To: arslist@arslist.org ** What you need to do is to check the DTD:ThreadManager form. Open the form and delete all records and restart your job again. I have seen it happened before that for some reason this record gets stuck and it does not get updated. -Moe http://www.remedycloud.com *From:* Michael Burton [mailto:michael_bur...@hotmail.co.uk] *Sent:* Thursday, June 16, 2011 1:28 PM *Subject:* Re: Bulk Change of login ID ** That's what we've got at the moment, but as you say, it does seem to have done the job. -- Date: Thu, 16 Jun 2011 13:11:17 -0400 From: anne.ra...@nc.gov Subject: Re: Bulk Change of login ID To: arslist@ARSLIST.ORG ** Do you get the pop-up saying that the change is still pending? It never changes to completed? We’ve had a job or two hang up, but ID changes generally take about 2-5 minutes depending how active the user is. Anne Ramey *** *E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official.* _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ** ** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are image001.png
Re: Bulk Change of login ID
Hi it is DLD:ThreadManager Thanks Regards Prasanth.P From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mahesh Sent: Friday, June 17, 2011 10:51 AM To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID ** Hi Moe Just wanted to know if the link from your signature line is genuine because the content on that page has nothing to do with ARS Remedy. Thanks Mahesh From: Gmail moe.abdela...@gmail.com Date: Thu, Jun 16, 2011 at 11:56 PM Subject: Re: Bulk Change of login ID To: arslist@arslist.org ** What you need to do is to check the DTD:ThreadManager form. Open the form and delete all records and restart your job again. I have seen it happened before that for some reason this record gets stuck and it does not get updated. -Moe http://www.remedycloud.com From: Michael Burton [mailto:michael_bur...@hotmail.co.uk] Sent: Thursday, June 16, 2011 1:28 PM Subject: Re: Bulk Change of login ID ** That's what we've got at the moment, but as you say, it does seem to have done the job. Date: Thu, 16 Jun 2011 13:11:17 -0400 From: anne.ra...@nc.gov Subject: Re: Bulk Change of login ID To: arslist@ARSLIST.ORG ** Do you get the pop-up saying that the change is still pending? It never changes to completed? We've had a job or two hang up, but ID changes generally take about 2-5 minutes depending how active the user is. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are image001.png
Re: Bulk Change of login ID
Morning, Thanks to all for your responses, some food for thought and things to consider. Cheers - Mike Date: Tue, 14 Jun 2011 23:38:10 -0400 From: moe.abdela...@gmail.com Subject: Re: Bulk Change of login ID To: arslist@ARSLIST.ORG ** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
Hi, The rrrLoginConv tool performs the change on everything in the system, including: - Exact Matches on any char-fields smaller than 255 chars (size configurable) - Quoted user names in fields such as the 60xxx fields for dynamic permissions (can be skipped) - Status-History entries (can be skipped) - Diary-Entries (can be skipped) It takes a list of any number of user names to convert. You can perform a dry-run first to see in which fields it finds matches to convert. It does NOT change Modify Date or Modified By. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Yes, Data Wizard considers existing tickets, and field id 2 and 4. However, it does not recognize any custom fields. It runs perfect on 1:1 basis. http://www.remedycloud.com From: Joe Martin D'Souza [mailto:jdso...@shyle.net] Sent: Tuesday, June 14, 2011 4:04 PM Subject: Re: Bulk Change of login ID ** Does the Data wizard consider existing tickets and the values of field 2, 4, and other login name type fields even if they are custom? If not you may have to write a DB script to get this done.. I had done it using a DB script to mass change login names in a system a few years ago long before the dawn of these nifty utilities that are now being bundled over the past couple of years or so... Joe From: Boyd, Rebecca mailto:boy...@wfu.edu Sent: Tuesday, June 14, 2011 8:23 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID ** I've used the DLD:SYS:DataWizAction form to bulk update login names. Open it up look at it. If you've used the Data Wizard Console to make any changes, you can search see the records. Here is what I did: Exported the users that needed changing from CTM:People. Created a csv file. Imported the csv file into DLD:SYS:DataWizAction. Then - this is where it gets funky - I used a program called AutoHotKey to run through the everything I'd imported into DLD:SYS:DataWizAction. The reason I used AutoHotKey is because I could make it wait for the update action to complete before moving on to the next record. A colleague recommended this help me set it up. HTH, Rebecca On Tue, Jun 14, 2011 at 7:09 AM, Michael Burton michael_bur...@hotmail.co.uk wrote: ** Morning, Just wondering if anyone has experience of a bulk update of people's login ID's. Basically we configured our system to use people's email addresses as their User Name. The obvious advantage of this is that your are guaranteed a unique entry for each employee. Authentication takes place against our AD servers. So we are now in the position that due to a company purchase, we are going to have to change everybody's email address, and as such, regardless of short term work arounds we might be able to put in place, each users login ID will need to change too. I've had a dig on support.bmc.com and found questions about using DMT, but it's not designed to do it. It would seem that the best option is to use the Data Wizard Console, but that only works on a 1:1 basis, but it does do the job and updates everything rather than just the CTM:People form and/or the User form. Is it just a case of bite the bullet and crack on with it via the DWC? Cheers - Mike _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Rebecca Boyd Application Administrator Wake Forest University _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
Actually this would be a better tool then as your tool might possibly be doing an EXISTS IN comparison on fields smaller than 255.. Joe -Original Message- From: Misi Mladoniczky Sent: Wednesday, June 15, 2011 6:13 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID Hi, The rrrLoginConv tool performs the change on everything in the system, including: - Exact Matches on any char-fields smaller than 255 chars (size configurable) - Quoted user names in fields such as the 60xxx fields for dynamic permissions (can be skipped) - Status-History entries (can be skipped) - Diary-Entries (can be skipped) It takes a list of any number of user names to convert. You can perform a dry-run first to see in which fields it finds matches to convert. It does NOT change Modify Date or Modified By. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Yes, Data Wizard considers existing tickets, and field id 2 and 4. However, it does not recognize any custom fields. It runs perfect on 1:1 basis. http://www.remedycloud.com From: Joe Martin D'Souza [mailto:jdso...@shyle.net] Sent: Tuesday, June 14, 2011 4:04 PM Subject: Re: Bulk Change of login ID ** Does the Data wizard consider existing tickets and the values of field 2, 4, and other login name type fields even if they are custom? If not you may have to write a DB script to get this done.. I had done it using a DB script to mass change login names in a system a few years ago long before the dawn of these nifty utilities that are now being bundled over the past couple of years or so... Joe From: Boyd, Rebecca mailto:boy...@wfu.edu Sent: Tuesday, June 14, 2011 8:23 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID ** I've used the DLD:SYS:DataWizAction form to bulk update login names. Open it up look at it. If you've used the Data Wizard Console to make any changes, you can search see the records. Here is what I did: Exported the users that needed changing from CTM:People. Created a csv file. Imported the csv file into DLD:SYS:DataWizAction. Then - this is where it gets funky - I used a program called AutoHotKey to run through the everything I'd imported into DLD:SYS:DataWizAction. The reason I used AutoHotKey is because I could make it wait for the update action to complete before moving on to the next record. A colleague recommended this help me set it up. HTH, Rebecca On Tue, Jun 14, 2011 at 7:09 AM, Michael Burton michael_bur...@hotmail.co.uk wrote: ** Morning, Just wondering if anyone has experience of a bulk update of people's login ID's. Basically we configured our system to use people's email addresses as their User Name. The obvious advantage of this is that your are guaranteed a unique entry for each employee. Authentication takes place against our AD servers. So we are now in the position that due to a company purchase, we are going to have to change everybody's email address, and as such, regardless of short term work arounds we might be able to put in place, each users login ID will need to change too. I've had a dig on support.bmc.com and found questions about using DMT, but it's not designed to do it. It would seem that the best option is to use the Data Wizard Console, but that only works on a 1:1 basis, but it does do the job and updates everything rather than just the CTM:People form and/or the User form. Is it just a case of bite the bullet and crack on with it via the DWC? Cheers - Mike -- Rebecca Boyd Application Administrator Wake Forest University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
Hi, The tool will get all char/diary/status-history data from the server, where you can specify a max-length for your char-fields and skip diary/status-history if you like. It will then match the data against the conversion list in this fashion: 1. Exact match ('Data' = fromuser1). 2. Quoted matches ('Data' LIKE %'fromuser1'%) and the same thing with double-quotes. Can be disabled. 3. List matches with separators CRNL, NL, tab, comma, semicolon, colon and pipe. This can also be disabled. If anything is found, the records and field will be marked as changed, and the tool will do an ARMergeEntry() back to the server, with changed fields only for that record. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Actually this would be a better tool then as your tool might possibly be doing an EXISTS IN comparison on fields smaller than 255.. Joe -Original Message- From: Misi Mladoniczky Sent: Wednesday, June 15, 2011 6:13 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID Hi, The rrrLoginConv tool performs the change on everything in the system, including: - Exact Matches on any char-fields smaller than 255 chars (size configurable) - Quoted user names in fields such as the 60xxx fields for dynamic permissions (can be skipped) - Status-History entries (can be skipped) - Diary-Entries (can be skipped) It takes a list of any number of user names to convert. You can perform a dry-run first to see in which fields it finds matches to convert. It does NOT change Modify Date or Modified By. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Yes, Data Wizard considers existing tickets, and field id 2 and 4. However, it does not recognize any custom fields. It runs perfect on 1:1 basis. http://www.remedycloud.com From: Joe Martin D'Souza [mailto:jdso...@shyle.net] Sent: Tuesday, June 14, 2011 4:04 PM Subject: Re: Bulk Change of login ID ** Does the Data wizard consider existing tickets and the values of field 2, 4, and other login name type fields even if they are custom? If not you may have to write a DB script to get this done.. I had done it using a DB script to mass change login names in a system a few years ago long before the dawn of these nifty utilities that are now being bundled over the past couple of years or so... Joe From: Boyd, Rebecca mailto:boy...@wfu.edu Sent: Tuesday, June 14, 2011 8:23 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID ** I've used the DLD:SYS:DataWizAction form to bulk update login names. Open it up look at it. If you've used the Data Wizard Console to make any changes, you can search see the records. Here is what I did: Exported the users that needed changing from CTM:People. Created a csv file. Imported the csv file into DLD:SYS:DataWizAction. Then - this is where it gets funky - I used a program called AutoHotKey to run through the everything I'd imported into DLD:SYS:DataWizAction. The reason I used AutoHotKey is because I could make it wait for the update action to complete before moving on to the next record. A colleague recommended this help me set it up. HTH, Rebecca On Tue, Jun 14, 2011 at 7:09 AM, Michael Burton michael_bur...@hotmail.co.uk wrote: ** Morning, Just wondering if anyone has experience of a bulk update of people's login ID's. Basically we configured our system to use people's email addresses as their User Name. The obvious advantage of this is that your are guaranteed a unique entry for each employee. Authentication takes place against our AD servers. So we are now in the position that due to a company purchase, we are going to have to change everybody's email address, and as such, regardless of short term work arounds we might be able to put in place, each users login ID will need to change too. I've had a dig on support.bmc.com and found questions about using DMT, but it's not designed to do it. It would seem that the best option is to use the Data Wizard Console, but that only works on a 1:1 basis, but it does do the job and updates everything rather than just the CTM:People form and/or the User form. Is it just a case of bite the bullet and crack on with it via the DWC? Cheers - Mike -- Rebecca Boyd
Bulk Change of login ID
Morning, Just wondering if anyone has experience of a bulk update of people's login ID's. Basically we configured our system to use people's email addresses as their User Name. The obvious advantage of this is that your are guaranteed a unique entry for each employee. Authentication takes place against our AD servers. So we are now in the position that due to a company purchase, we are going to have to change everybody's email address, and as such, regardless of short term work arounds we might be able to put in place, each users login ID will need to change too. I've had a dig on support.bmc.com and found questions about using DMT, but it's not designed to do it. It would seem that the best option is to use the Data Wizard Console, but that only works on a 1:1 basis, but it does do the job and updates everything rather than just the CTM:People form and/or the User form. Is it just a case of bite the bullet and crack on with it via the DWC? Cheers - Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
Hi, Have a look at RRR|LoginConv, it is designed to do exactly this on any Remedy application. It will take a lot of time to run on a big system, so you may need to prioritize some forms to convert first. Otherwise it can handle all forms in a single run for all of your users. https://www.rrr.se/cgi/tools/main#rrrLoginConv Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Morning, Just wondering if anyone has experience of a bulk update of people's login ID's. Basically we configured our system to use people's email addresses as their User Name. The obvious advantage of this is that your are guaranteed a unique entry for each employee. Authentication takes place against our AD servers. So we are now in the position that due to a company purchase, we are going to have to change everybody's email address, and as such, regardless of short term work arounds we might be able to put in place, each users login ID will need to change too. I've had a dig on support.bmc.com and found questions about using DMT, but it's not designed to do it. It would seem that the best option is to use the Data Wizard Console, but that only works on a 1:1 basis, but it does do the job and updates everything rather than just the CTM:People form and/or the User form. Is it just a case of bite the bullet and crack on with it via the DWC? Cheers - Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
I've used the DLD:SYS:DataWizAction form to bulk update login names. Open it up look at it. If you've used the Data Wizard Console to make any changes, you can search see the records. Here is what I did: Exported the users that needed changing from CTM:People. Created a csv file. Imported the csv file into DLD:SYS:DataWizAction. Then - this is where it gets funky - I used a program called AutoHotKey to run through the everything I'd imported into DLD:SYS:DataWizAction. The reason I used AutoHotKey is because I could make it wait for the update action to complete before moving on to the next record. A colleague recommended this help me set it up. HTH, Rebecca On Tue, Jun 14, 2011 at 7:09 AM, Michael Burton michael_bur...@hotmail.co.uk wrote: ** Morning, Just wondering if anyone has experience of a bulk update of people's login ID's. Basically we configured our system to use people's email addresses as their User Name. The obvious advantage of this is that your are guaranteed a unique entry for each employee. Authentication takes place against our AD servers. So we are now in the position that due to a company purchase, we are going to have to change everybody's email address, and as such, regardless of short term work arounds we might be able to put in place, each users login ID will need to change too. I've had a dig on support.bmc.com and found questions about using DMT, but it's not designed to do it. It would seem that the best option is to use the Data Wizard Console, but that only works on a 1:1 basis, but it does do the job and updates everything rather than just the CTM:People form and/or the User form. Is it just a case of bite the bullet and crack on with it via the DWC? Cheers - Mike _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Rebecca Boyd Application Administrator Wake Forest University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
Does the Data wizard consider existing tickets and the values of field 2, 4, and other login name type fields even if they are custom? If not you may have to write a DB script to get this done.. I had done it using a DB script to mass change login names in a system a few years ago long before the dawn of these nifty utilities that are now being bundled over the past couple of years or so... Joe From: Boyd, Rebecca Sent: Tuesday, June 14, 2011 8:23 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID ** I've used the DLD:SYS:DataWizAction form to bulk update login names. Open it up look at it. If you've used the Data Wizard Console to make any changes, you can search see the records. Here is what I did: Exported the users that needed changing from CTM:People. Created a csv file. Imported the csv file into DLD:SYS:DataWizAction. Then - this is where it gets funky - I used a program called AutoHotKey to run through the everything I'd imported into DLD:SYS:DataWizAction. The reason I used AutoHotKey is because I could make it wait for the update action to complete before moving on to the next record. A colleague recommended this help me set it up. HTH, Rebecca On Tue, Jun 14, 2011 at 7:09 AM, Michael Burton michael_bur...@hotmail.co.uk wrote: ** Morning, Just wondering if anyone has experience of a bulk update of people's login ID's. Basically we configured our system to use people's email addresses as their User Name. The obvious advantage of this is that your are guaranteed a unique entry for each employee. Authentication takes place against our AD servers. So we are now in the position that due to a company purchase, we are going to have to change everybody's email address, and as such, regardless of short term work arounds we might be able to put in place, each users login ID will need to change too. I've had a dig on support.bmc.com and found questions about using DMT, but it's not designed to do it. It would seem that the best option is to use the Data Wizard Console, but that only works on a 1:1 basis, but it does do the job and updates everything rather than just the CTM:People form and/or the User form. Is it just a case of bite the bullet and crack on with it via the DWC? Cheers - Mike _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Rebecca Boyd Application Administrator Wake Forest University _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
DLD:SYS:DataWizAction updates a bunch of forms. Use the Data Wizard Tool to modify one login then check DLD:SYS:DataWizAction. It will list all the forms it checked tell you how any records were updated. On Tue, Jun 14, 2011 at 4:03 PM, Joe Martin D'Souza jdso...@shyle.netwrote: ** Does the Data wizard consider existing tickets and the values of field 2, 4, and other login name type fields even if they are custom? If not you may have to write a DB script to get this done.. I had done it using a DB script to mass change login names in a system a few years ago long before the dawn of these nifty utilities that are now being bundled over the past couple of years or so... Joe *From:* Boyd, Rebecca boy...@wfu.edu *Sent:* Tuesday, June 14, 2011 8:23 AM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Bulk Change of login ID ** I've used the DLD:SYS:DataWizAction form to bulk update login names.Open it up look at it. If you've used the Data Wizard Console to make any changes, you can search see the records. Here is what I did: Exported the users that needed changing from CTM:People. Created a csv file. Imported the csv file into DLD:SYS:DataWizAction. Then - this is where it gets funky - I used a program called AutoHotKey to run through the everything I'd imported into DLD:SYS:DataWizAction. The reason I used AutoHotKey is because I could make it wait for the update action to complete before moving on to the next record. A colleague recommended this help me set it up. HTH, Rebecca On Tue, Jun 14, 2011 at 7:09 AM, Michael Burton michael_bur...@hotmail.co.uk wrote: ** Morning, Just wondering if anyone has experience of a bulk update of people's login ID's. Basically we configured our system to use people's email addresses as their User Name. The obvious advantage of this is that your are guaranteed a unique entry for each employee. Authentication takes place against our AD servers. So we are now in the position that due to a company purchase, we are going to have to change everybody's email address, and as such, regardless of short term work arounds we might be able to put in place, each users login ID will need to change too. I've had a dig on support.bmc.com and found questions about using DMT, but it's not designed to do it. It would seem that the best option is to use the Data Wizard Console, but that only works on a 1:1 basis, but it does do the job and updates everything rather than just the CTM:People form and/or the User form. Is it just a case of bite the bullet and crack on with it via the DWC? Cheers - Mike _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Rebecca Boyd Application Administrator Wake Forest University _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Rebecca Boyd Application Administrator Wake Forest University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
Updating a bunch of forms is one thing.. what fields it updates in those forms is another.. Functionality can be impacted to a very large extent if not all the information is updated wherever login name type fields are found on those bunch of forms... The whole behavior and properties of a row can be affected with changes in login names if fields like Submitter, Assigned To, and other application level fields holding login name information such as Requester Login Name etc. is not changed.. Joe From: Boyd, Rebecca Sent: Tuesday, June 14, 2011 9:20 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID ** DLD:SYS:DataWizAction updates a bunch of forms. Use the Data Wizard Tool to modify one login then check DLD:SYS:DataWizAction. It will list all the forms it checked tell you how any records were updated. On Tue, Jun 14, 2011 at 4:03 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** Does the Data wizard consider existing tickets and the values of field 2, 4, and other login name type fields even if they are custom? If not you may have to write a DB script to get this done.. I had done it using a DB script to mass change login names in a system a few years ago long before the dawn of these nifty utilities that are now being bundled over the past couple of years or so... Joe From: Boyd, Rebecca Sent: Tuesday, June 14, 2011 8:23 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID ** I've used the DLD:SYS:DataWizAction form to bulk update login names. Open it up look at it. If you've used the Data Wizard Console to make any changes, you can search see the records. Here is what I did: Exported the users that needed changing from CTM:People. Created a csv file. Imported the csv file into DLD:SYS:DataWizAction. Then - this is where it gets funky - I used a program called AutoHotKey to run through the everything I'd imported into DLD:SYS:DataWizAction. The reason I used AutoHotKey is because I could make it wait for the update action to complete before moving on to the next record. A colleague recommended this help me set it up. HTH, Rebecca On Tue, Jun 14, 2011 at 7:09 AM, Michael Burton michael_bur...@hotmail.co.uk wrote: ** Morning, Just wondering if anyone has experience of a bulk update of people's login ID's. Basically we configured our system to use people's email addresses as their User Name. The obvious advantage of this is that your are guaranteed a unique entry for each employee. Authentication takes place against our AD servers. So we are now in the position that due to a company purchase, we are going to have to change everybody's email address, and as such, regardless of short term work arounds we might be able to put in place, each users login ID will need to change too. I've had a dig on support.bmc.com and found questions about using DMT, but it's not designed to do it. It would seem that the best option is to use the Data Wizard Console, but that only works on a 1:1 basis, but it does do the job and updates everything rather than just the CTM:People form and/or the User form. Is it just a case of bite the bullet and crack on with it via the DWC? Cheers - Mike _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Rebecca Boyd Application Administrator Wake Forest University _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Rebecca Boyd Application Administrator Wake Forest University _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Bulk Change of login ID
Yes, Data Wizard considers existing tickets, and field id 2 and 4. However, it does not recognize any custom fields. It runs perfect on 1:1 basis. http://www.remedycloud.com From: Joe Martin D'Souza [mailto:jdso...@shyle.net] Sent: Tuesday, June 14, 2011 4:04 PM Subject: Re: Bulk Change of login ID ** Does the Data wizard consider existing tickets and the values of field 2, 4, and other login name type fields even if they are custom? If not you may have to write a DB script to get this done.. I had done it using a DB script to mass change login names in a system a few years ago long before the dawn of these nifty utilities that are now being bundled over the past couple of years or so... Joe From: Boyd, Rebecca mailto:boy...@wfu.edu Sent: Tuesday, June 14, 2011 8:23 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Bulk Change of login ID ** I've used the DLD:SYS:DataWizAction form to bulk update login names. Open it up look at it. If you've used the Data Wizard Console to make any changes, you can search see the records. Here is what I did: Exported the users that needed changing from CTM:People. Created a csv file. Imported the csv file into DLD:SYS:DataWizAction. Then - this is where it gets funky - I used a program called AutoHotKey to run through the everything I'd imported into DLD:SYS:DataWizAction. The reason I used AutoHotKey is because I could make it wait for the update action to complete before moving on to the next record. A colleague recommended this help me set it up. HTH, Rebecca On Tue, Jun 14, 2011 at 7:09 AM, Michael Burton michael_bur...@hotmail.co.uk wrote: ** Morning, Just wondering if anyone has experience of a bulk update of people's login ID's. Basically we configured our system to use people's email addresses as their User Name. The obvious advantage of this is that your are guaranteed a unique entry for each employee. Authentication takes place against our AD servers. So we are now in the position that due to a company purchase, we are going to have to change everybody's email address, and as such, regardless of short term work arounds we might be able to put in place, each users login ID will need to change too. I've had a dig on support.bmc.com and found questions about using DMT, but it's not designed to do it. It would seem that the best option is to use the Data Wizard Console, but that only works on a 1:1 basis, but it does do the job and updates everything rather than just the CTM:People form and/or the User form. Is it just a case of bite the bullet and crack on with it via the DWC? Cheers - Mike _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Rebecca Boyd Application Administrator Wake Forest University _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Modify login id
Hi, It is in the RRR|Commands section and is called RRR|LoginConv: https://www.rrr.se/cgi/tools/main#rrrLoginConv It basically go through all regular forms and update those records that needs to be changed. It does not care which application or version is used, as it performs an exact match in all your fields, including diary-fields and status-history. It does not change Modify-Date or Modify-By, as the API-call ARMergeEntry is used (same as Import Tool). Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Didn't Misi have a login converter tool to do this? http://www.rrr.se (although I'm not seeing it in the list of product right now.) Thad On Wed, Nov 10, 2010 at 12:17 PM, Larry Barnes larry.bar...@thecreek.comwrote: ** I'm wondering if anyone out there has a simple way of modifying a login id for a user and any of their tickets they have created, or been assigned. We have users that are given a login id one way if they are a contractor and a different way if they are an employee. The problem is some contractors eventually become employees. We want to be able to modify the employee's current People, User form records and at the same time modify any tickets associated with their old login id and link them with their new login id. I was thinking of creating workflow and a form, for input, but this may need to be a SQL script. I'm just curious if anyone else has done this and is willing to share. We are running on a windows server with ARS 7.5.00 patch 002 with ITSM 7.0.03 patch 009 Thanks, Larry B. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are