Re: ITSM 7/LDAP not importing some records
My tests confirm that. By setting the Requester console as their Home Page, we will keep them out of the rest of the Incidents. Thanks, Roger. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Wednesday, May 16, 2007 11:51 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** You will not need incident submitter to have the incidents created. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 16 May 2007 2:13 PM Subject: Re: ITSM 7/LDAP not importing some records ** Our users will create tickets one of two ways: 1) An email to a certain mailbox (which I will deal with separately) 2) The Requester Console. Are you saying that Incident Submitter is the incorrect permission for that level of use? Rick _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Roger Justice Sent: Wednesday, May 16, 2007 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Your end users do not need Incident Submitter if you are using the Service Request Wizard for them to create new tickets. I found that the client does not want end users being able to search all incidents since they can do this if they are incident viewers. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 16 May 2007 1:54 PM Subject: Re: ITSM 7/LDAP not importing some records Our end users won't be doing much, and we're only starting out with IM/PM, so what I have is: Incident Submitter (which is Incident Viewer + being able to submit tickets) Unrestricted Access General Access (don't forget this one) Rick -Original Message- From: Action Request System discussion list(ARSList) __20060125___This posting was submitted with HTML in it_ __20060125___This posting was submitted with HTML in it___ _ AOL now offers free email to everyone. Find out more about what's free from AOL at <http://www.aol.com?ncid=AOLAOF0002000437> AOL.com. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ITSM 7/LDAP not importing some records
You will not need incident submitter to have the incidents created. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 16 May 2007 2:13 PM Subject: Re: ITSM 7/LDAP not importing some records ** Our users will create tickets one of two ways: 1) An email to a certain mailbox (which I will deal with separately) 2) The Requester Console. Are you saying that Incident Submitter is the incorrect permission for that level of use? Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Wednesday, May 16, 2007 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Your end users do not need Incident Submitter if you are using the Service Request Wizard for them to create new tickets. I found that the client does not want end users being able to search all incidents since they can do this if they are incident viewers. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 16 May 2007 1:54 PM Subject: Re: ITSM 7/LDAP not importing some records Our end users won't be doing much, and we're only starting out with IM/PM, so what I have is: Incident Submitter (which is Incident Viewer + being able to submit tickets) Unrestricted Access General Access (don't forget this one) Rick -Original Message- From: Action Request System discussion list(ARSList) __20060125___This posting was submitted with HTML in it_ __20060125___This posting was submitted with HTML in it___ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ITSM 7/LDAP not importing some records
I agree on the incident viewer permission giving them too much visibility, trouble is the notifications to the customers send them to the Incident, not to the service request, and send them without enough permissions on the incident (even with Incident Submitter and Viewer) to edit the WorkLog. The whole dynamic between the service requests in the requester console and the incidents they create and how the customer is supposed to interact with them is half-baked in ITSM 7.0.02.003, especially since support staff created incidents do not reliable create corresponding service requests to be customer access points. IMHO the app is broken out of the box, and must be fixed before it can be implemented without extensive customization (actually, correction). The only folks who may get unrestricted access in our very multi-tenancy configured system will be admins, helpdesk managers, and the security team. Security would rather that no one had it. By General Access do you mean membership in one company under Access Restrictions? All of our LDAP imported customer records will be members of a single "UNT Customers" company, which has no groups, only Organizations and Departments; all who are support staff will have separate logins in one of the many IT support companies and membership on one or more of their subordinate support groups. Roger, what permissions do you plan to use for customers? Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Wednesday, May 16, 2007 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Your end users do not need Incident Submitter if you are using the Service Request Wizard for them to create new tickets. I found that the client does not want end users being able to search all incidents since they can do this if they are incident viewers. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 16 May 2007 1:54 PM Subject: Re: ITSM 7/LDAP not importing some records Our end users won't be doing much, and we're only starting out with IM/PM, so what I have is: Incident Submitter (which is Incident Viewer + being able to submit tickets) Unrestricted Access General Access (don't forget this one) Rick -Original Message- From: Action Request System discussion list(ARSList) __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ITSM 7/LDAP not importing some records
Oops - that CTM:Support Group Association form is just for Support Groups, in which end users would not have records. Rick -Original Message- From: Rick Cook [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 16, 2007 11:19 AM To: 'arslist@ARSLIST.ORG' Subject: RE: ITSM 7/LDAP not importing some records If you're talking about unauthenticated users, you might be right - I haven't checked that. For the users I am looking at, I don't see a generic record anywhere, unless that's the "General Access" record. I did just see that a record must also be created in the CTM:Support Group Association form for each of the records in the CTM:People Permission Groups form. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, May 16, 2007 11:06 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records >From my understanding, a generic user has to be in the group that his company belongs to.. when you create a company record, a group for that company with the same company name gets automatically created. The user has to be a member of that group, and the 112 field in the CTM:People form has to be populated with the Group ID of that company.. So that's the first mass load of permissions I intend to do using the utility that you guys now have.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Wednesday, May 16, 2007 1:09 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records What permissions are you automatically assigning to the new customer records with this process? I was expecting to need Incident Submitter, Incident Viewer, Asset Viewer, and KMSAC-KMSUser. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, May 16, 2007 11:57 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Joe, and all, what I wanted to do was to create some basic permissions for the 90+% of the LDAP people that were not Support people, and I wanted to do it quickly. Rather than spend half my day futzing with import scripts and such, what I did was create a Filter that emulates the actions of the CTM:PPG:Add_115_PPPG Active Link, which runs from the CTM:People Permission Groups form when you click the "Add" button for to add a permissions group for a user. The Filter, unlike the AL, has a Set Fields action (check the "Unrestricted Access" box), and three Push Fields actions, one for each entry in the CTM:People Permission Groups form that it will create. Initially, I will have it run for all existing users until the perms are populated. After initial population, I will have it only run on Submit, just to reduce the time it takes to check for records that are already there. So thanks to all for the ideas and the help, but as is often the case, the simplest solution is the best one for me. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, May 15, 2007 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Rick, Its a word document with embedded macros so might not make it to the list if I were to attempt to send it. I'm not quite sure if you can find it on the support web as yet as I recall the agent telling me that they are still in the process of developing little utilities like this in way of excel files with spreadsheets with CSV data expected coupled with a def file that contain filters defined to fire on MERGE. I've sent you a mail directly containing the word file, with a high level information of changes you might want to consider doing to it in order to make certain data appear the same as it does as if it were entered from the user console using the data configuration utility. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 5:52 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Sweet! I was just going to do this for a bunch of users. I'll have to check out the utility - how do we find it on the support page? Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Its just been release and is a part
Re: ITSM 7/LDAP not importing some records
If you're talking about unauthenticated users, you might be right - I haven't checked that. For the users I am looking at, I don't see a generic record anywhere, unless that's the "General Access" record. I did just see that a record must also be created in the CTM:Support Group Association form for each of the records in the CTM:People Permission Groups form. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, May 16, 2007 11:06 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records >From my understanding, a generic user has to be in the group that his company belongs to.. when you create a company record, a group for that company with the same company name gets automatically created. The user has to be a member of that group, and the 112 field in the CTM:People form has to be populated with the Group ID of that company.. So that's the first mass load of permissions I intend to do using the utility that you guys now have.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Wednesday, May 16, 2007 1:09 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records What permissions are you automatically assigning to the new customer records with this process? I was expecting to need Incident Submitter, Incident Viewer, Asset Viewer, and KMSAC-KMSUser. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, May 16, 2007 11:57 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Joe, and all, what I wanted to do was to create some basic permissions for the 90+% of the LDAP people that were not Support people, and I wanted to do it quickly. Rather than spend half my day futzing with import scripts and such, what I did was create a Filter that emulates the actions of the CTM:PPG:Add_115_PPPG Active Link, which runs from the CTM:People Permission Groups form when you click the "Add" button for to add a permissions group for a user. The Filter, unlike the AL, has a Set Fields action (check the "Unrestricted Access" box), and three Push Fields actions, one for each entry in the CTM:People Permission Groups form that it will create. Initially, I will have it run for all existing users until the perms are populated. After initial population, I will have it only run on Submit, just to reduce the time it takes to check for records that are already there. So thanks to all for the ideas and the help, but as is often the case, the simplest solution is the best one for me. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, May 15, 2007 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Rick, Its a word document with embedded macros so might not make it to the list if I were to attempt to send it. I'm not quite sure if you can find it on the support web as yet as I recall the agent telling me that they are still in the process of developing little utilities like this in way of excel files with spreadsheets with CSV data expected coupled with a def file that contain filters defined to fire on MERGE. I've sent you a mail directly containing the word file, with a high level information of changes you might want to consider doing to it in order to make certain data appear the same as it does as if it were entered from the user console using the data configuration utility. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 5:52 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Sweet! I was just going to do this for a bunch of users. I'll have to check out the utility - how do we find it on the support page? Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Its just been release and is a part of a bunch of utilities that BMC support is working on which will eventually be released.. At the moment they have released a utility to mass load users, associate these users with permission groups, mass define their access. Joe -Original Message- From: Ac
Re: ITSM 7/LDAP not importing some records
Our users will create tickets one of two ways: 1) An email to a certain mailbox (which I will deal with separately) 2) The Requester Console. Are you saying that Incident Submitter is the incorrect permission for that level of use? Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Wednesday, May 16, 2007 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Your end users do not need Incident Submitter if you are using the Service Request Wizard for them to create new tickets. I found that the client does not want end users being able to search all incidents since they can do this if they are incident viewers. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 16 May 2007 1:54 PM Subject: Re: ITSM 7/LDAP not importing some records Our end users won't be doing much, and we're only starting out with IM/PM, so what I have is: Incident Submitter (which is Incident Viewer + being able to submit tickets) Unrestricted Access General Access (don't forget this one) Rick -Original Message- From: Action Request System discussion list(ARSList) __20060125___This posting was submitted with HTML in it_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ITSM 7/LDAP not importing some records
>From my understanding, a generic user has to be in the group that his company belongs to.. when you create a company record, a group for that company with the same company name gets automatically created. The user has to be a member of that group, and the 112 field in the CTM:People form has to be populated with the Group ID of that company.. So that's the first mass load of permissions I intend to do using the utility that you guys now have.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Wednesday, May 16, 2007 1:09 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records What permissions are you automatically assigning to the new customer records with this process? I was expecting to need Incident Submitter, Incident Viewer, Asset Viewer, and KMSAC-KMSUser. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, May 16, 2007 11:57 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Joe, and all, what I wanted to do was to create some basic permissions for the 90+% of the LDAP people that were not Support people, and I wanted to do it quickly. Rather than spend half my day futzing with import scripts and such, what I did was create a Filter that emulates the actions of the CTM:PPG:Add_115_PPPG Active Link, which runs from the CTM:People Permission Groups form when you click the "Add" button for to add a permissions group for a user. The Filter, unlike the AL, has a Set Fields action (check the "Unrestricted Access" box), and three Push Fields actions, one for each entry in the CTM:People Permission Groups form that it will create. Initially, I will have it run for all existing users until the perms are populated. After initial population, I will have it only run on Submit, just to reduce the time it takes to check for records that are already there. So thanks to all for the ideas and the help, but as is often the case, the simplest solution is the best one for me. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, May 15, 2007 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Rick, Its a word document with embedded macros so might not make it to the list if I were to attempt to send it. I'm not quite sure if you can find it on the support web as yet as I recall the agent telling me that they are still in the process of developing little utilities like this in way of excel files with spreadsheets with CSV data expected coupled with a def file that contain filters defined to fire on MERGE. I've sent you a mail directly containing the word file, with a high level information of changes you might want to consider doing to it in order to make certain data appear the same as it does as if it were entered from the user console using the data configuration utility. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 5:52 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Sweet! I was just going to do this for a bunch of users. I'll have to check out the utility - how do we find it on the support page? Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Its just been release and is a part of a bunch of utilities that BMC support is working on which will eventually be released.. At the moment they have released a utility to mass load users, associate these users with permission groups, mass define their access. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Monday, May 14, 2007 5:25 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Where did you see this utility, or was it only available directly through support??? I can't comment (yet) since I had not heard of it. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Reques
Re: ITSM 7/LDAP not importing some records
Your end users do not need Incident Submitter if you are using the Service Request Wizard for them to create new tickets. I found that the client does not want end users being able to search all incidents since they can do this if they are incident viewers. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 16 May 2007 1:54 PM Subject: Re: ITSM 7/LDAP not importing some records Our end users won't be doing much, and we're only starting out with IM/PM, so what I have is: Incident Submitter (which is Incident Viewer + being able to submit tickets) Unrestricted Access General Access (don't forget this one) Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Wednesday, May 16, 2007 10:09 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records What permissions are you automatically assigning to the new customer records with this process? I was expecting to need Incident Submitter, Incident Viewer, Asset Viewer, and KMSAC-KMSUser. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, May 16, 2007 11:57 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Joe, and all, what I wanted to do was to create some basic permissions for the 90+% of the LDAP people that were not Support people, and I wanted to do it quickly. Rather than spend half my day futzing with import scripts and such, what I did was create a Filter that emulates the actions of the CTM:PPG:Add_115_PPPG Active Link, which runs from the CTM:People Permission Groups form when you click the "Add" button for to add a permissions group for a user. The Filter, unlike the AL, has a Set Fields action (check the "Unrestricted Access" box), and three Push Fields actions, one for each entry in the CTM:People Permission Groups form that it will create. Initially, I will have it run for all existing users until the perms are populated. After initial population, I will have it only run on Submit, just to reduce the time it takes to check for records that are already there. So thanks to all for the ideas and the help, but as is often the case, the simplest solution is the best one for me. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, May 15, 2007 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Rick, Its a word document with embedded macros so might not make it to the list if I were to attempt to send it. I'm not quite sure if you can find it on the support web as yet as I recall the agent telling me that they are still in the process of developing little utilities like this in way of excel files with spreadsheets with CSV data expected coupled with a def file that contain filters defined to fire on MERGE. I've sent you a mail directly containing the word file, with a high level information of changes you might want to consider doing to it in order to make certain data appear the same as it does as if it were entered from the user console using the data configuration utility. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 5:52 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Sweet! I was just going to do this for a bunch of users. I'll have to check out the utility - how do we find it on the support page? Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Its just been release and is a part of a bunch of utilities that BMC support is working on which will eventually be released.. At the moment they have released a utility to mass load users, associate these users with permission groups, mass define their access. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Monday, May 14, 2007 5:25 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Where did you see this utility, or was it only available directly through support??? I can't comment (yet) since I had not heard of it. Christopher Strauss, Ph.D. Remedy Database Administrato
Re: ITSM 7/LDAP not importing some records
Our end users won't be doing much, and we're only starting out with IM/PM, so what I have is: Incident Submitter (which is Incident Viewer + being able to submit tickets) Unrestricted Access General Access (don't forget this one) Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Wednesday, May 16, 2007 10:09 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records What permissions are you automatically assigning to the new customer records with this process? I was expecting to need Incident Submitter, Incident Viewer, Asset Viewer, and KMSAC-KMSUser. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, May 16, 2007 11:57 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Joe, and all, what I wanted to do was to create some basic permissions for the 90+% of the LDAP people that were not Support people, and I wanted to do it quickly. Rather than spend half my day futzing with import scripts and such, what I did was create a Filter that emulates the actions of the CTM:PPG:Add_115_PPPG Active Link, which runs from the CTM:People Permission Groups form when you click the "Add" button for to add a permissions group for a user. The Filter, unlike the AL, has a Set Fields action (check the "Unrestricted Access" box), and three Push Fields actions, one for each entry in the CTM:People Permission Groups form that it will create. Initially, I will have it run for all existing users until the perms are populated. After initial population, I will have it only run on Submit, just to reduce the time it takes to check for records that are already there. So thanks to all for the ideas and the help, but as is often the case, the simplest solution is the best one for me. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, May 15, 2007 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Rick, Its a word document with embedded macros so might not make it to the list if I were to attempt to send it. I'm not quite sure if you can find it on the support web as yet as I recall the agent telling me that they are still in the process of developing little utilities like this in way of excel files with spreadsheets with CSV data expected coupled with a def file that contain filters defined to fire on MERGE. I've sent you a mail directly containing the word file, with a high level information of changes you might want to consider doing to it in order to make certain data appear the same as it does as if it were entered from the user console using the data configuration utility. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 5:52 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Sweet! I was just going to do this for a bunch of users. I'll have to check out the utility - how do we find it on the support page? Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Its just been release and is a part of a bunch of utilities that BMC support is working on which will eventually be released.. At the moment they have released a utility to mass load users, associate these users with permission groups, mass define their access. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Monday, May 14, 2007 5:25 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Where did you see this utility, or was it only available directly through support??? I can't comment (yet) since I had not heard of it. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza
Re: ITSM 7/LDAP not importing some records
What permissions are you automatically assigning to the new customer records with this process? I was expecting to need Incident Submitter, Incident Viewer, Asset Viewer, and KMSAC-KMSUser. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, May 16, 2007 11:57 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Joe, and all, what I wanted to do was to create some basic permissions for the 90+% of the LDAP people that were not Support people, and I wanted to do it quickly. Rather than spend half my day futzing with import scripts and such, what I did was create a Filter that emulates the actions of the CTM:PPG:Add_115_PPPG Active Link, which runs from the CTM:People Permission Groups form when you click the "Add" button for to add a permissions group for a user. The Filter, unlike the AL, has a Set Fields action (check the "Unrestricted Access" box), and three Push Fields actions, one for each entry in the CTM:People Permission Groups form that it will create. Initially, I will have it run for all existing users until the perms are populated. After initial population, I will have it only run on Submit, just to reduce the time it takes to check for records that are already there. So thanks to all for the ideas and the help, but as is often the case, the simplest solution is the best one for me. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, May 15, 2007 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Rick, Its a word document with embedded macros so might not make it to the list if I were to attempt to send it. I'm not quite sure if you can find it on the support web as yet as I recall the agent telling me that they are still in the process of developing little utilities like this in way of excel files with spreadsheets with CSV data expected coupled with a def file that contain filters defined to fire on MERGE. I've sent you a mail directly containing the word file, with a high level information of changes you might want to consider doing to it in order to make certain data appear the same as it does as if it were entered from the user console using the data configuration utility. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 5:52 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Sweet! I was just going to do this for a bunch of users. I'll have to check out the utility - how do we find it on the support page? Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Its just been release and is a part of a bunch of utilities that BMC support is working on which will eventually be released.. At the moment they have released a utility to mass load users, associate these users with permission groups, mass define their access. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Monday, May 14, 2007 5:25 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Where did you see this utility, or was it only available directly through support??? I can't comment (yet) since I had not heard of it. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Does this happen only with $DEFAULT$ mapped to a field or does it happen with constant values mapped to a field? By constant values I mean if in case we want to put a value of lets say 'x' to a field and we type x into the value part on the import tool mapping,
Re: ITSM 7/LDAP not importing some records
Joe, and all, what I wanted to do was to create some basic permissions for the 90+% of the LDAP people that were not Support people, and I wanted to do it quickly. Rather than spend half my day futzing with import scripts and such, what I did was create a Filter that emulates the actions of the CTM:PPG:Add_115_PPPG Active Link, which runs from the CTM:People Permission Groups form when you click the "Add" button for to add a permissions group for a user. The Filter, unlike the AL, has a Set Fields action (check the "Unrestricted Access" box), and three Push Fields actions, one for each entry in the CTM:People Permission Groups form that it will create. Initially, I will have it run for all existing users until the perms are populated. After initial population, I will have it only run on Submit, just to reduce the time it takes to check for records that are already there. So thanks to all for the ideas and the help, but as is often the case, the simplest solution is the best one for me. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, May 15, 2007 11:39 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Rick, Its a word document with embedded macros so might not make it to the list if I were to attempt to send it. I'm not quite sure if you can find it on the support web as yet as I recall the agent telling me that they are still in the process of developing little utilities like this in way of excel files with spreadsheets with CSV data expected coupled with a def file that contain filters defined to fire on MERGE. I've sent you a mail directly containing the word file, with a high level information of changes you might want to consider doing to it in order to make certain data appear the same as it does as if it were entered from the user console using the data configuration utility. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 5:52 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Sweet! I was just going to do this for a bunch of users. I'll have to check out the utility - how do we find it on the support page? Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Its just been release and is a part of a bunch of utilities that BMC support is working on which will eventually be released.. At the moment they have released a utility to mass load users, associate these users with permission groups, mass define their access. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Monday, May 14, 2007 5:25 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Where did you see this utility, or was it only available directly through support??? I can't comment (yet) since I had not heard of it. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Does this happen only with $DEFAULT$ mapped to a field or does it happen with constant values mapped to a field? By constant values I mean if in case we want to put a value of lets say 'x' to a field and we type x into the value part on the import tool mapping, will it fail? I may have to do something like that while importing people information into CTM:People using a excel file format that BMC gave me with a few merge filters, and they have instructed me to put constant values such as 00 in a field and PPL in another.. I'm wondering if I would need to define filters in order to input these values? On a slightly related note (mass importing users from external sources), has anyone else used that utility that comes with 2 def files: 1) PeopleDataLoad.def 2) PeopleDataLoad_APS.def (optional if you have the approval server installed) Any shortcomings using this? One inconsistency that I noticed is that the filters defined on MERGE, formats the phone numbers in the format +1 999 888 Ext. while the out of the box submit/modify active links if entering the data using the administration interface formats it as 1 999 888 (). The outputs described happens in the event the country code is 1, Area code is 999, Local phone is 888 and Extension is . As this
Re: ITSM 7/LDAP not importing some records
Rick, Its a word document with embedded macros so might not make it to the list if I were to attempt to send it. I'm not quite sure if you can find it on the support web as yet as I recall the agent telling me that they are still in the process of developing little utilities like this in way of excel files with spreadsheets with CSV data expected coupled with a def file that contain filters defined to fire on MERGE. I've sent you a mail directly containing the word file, with a high level information of changes you might want to consider doing to it in order to make certain data appear the same as it does as if it were entered from the user console using the data configuration utility. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 5:52 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Sweet! I was just going to do this for a bunch of users. I'll have to check out the utility - how do we find it on the support page? Rick -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Its just been release and is a part of a bunch of utilities that BMC support is working on which will eventually be released.. At the moment they have released a utility to mass load users, associate these users with permission groups, mass define their access. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Monday, May 14, 2007 5:25 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Where did you see this utility, or was it only available directly through support??? I can't comment (yet) since I had not heard of it. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Does this happen only with $DEFAULT$ mapped to a field or does it happen with constant values mapped to a field? By constant values I mean if in case we want to put a value of lets say 'x' to a field and we type x into the value part on the import tool mapping, will it fail? I may have to do something like that while importing people information into CTM:People using a excel file format that BMC gave me with a few merge filters, and they have instructed me to put constant values such as 00 in a field and PPL in another.. I'm wondering if I would need to define filters in order to input these values? On a slightly related note (mass importing users from external sources), has anyone else used that utility that comes with 2 def files: 1) PeopleDataLoad.def 2) PeopleDataLoad_APS.def (optional if you have the approval server installed) Any shortcomings using this? One inconsistency that I noticed is that the filters defined on MERGE, formats the phone numbers in the format +1 999 888 Ext. while the out of the box submit/modify active links if entering the data using the administration interface formats it as 1 999 888 (). The outputs described happens in the event the country code is 1, Area code is 999, Local phone is 888 and Extension is . As this would bring about data to be formatted differently when imported, I've disabled the MERGE filters that format phone, fax, pager numbers after importing the above def files. I was wondering if anyone has noticed any other discrepancies in these def files if anyone else has used the same.. Rgds Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 4:08 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Yeah, I've seen that the Modify Escalations seem to update all records, because I haven't found a effective and efficient way to check for changes, and it would probably take almost as much time to do the check as it would to update the data anyway. Thankfully, we're under a thousand, so actions to submit and/or modify all records only take a minute or so. The data is fairly volatile, so I'll try updating it eve
Re: ITSM 7/LDAP not importing some records
Sweet! I was just going to do this for a bunch of users. I'll have to check out the utility - how do we find it on the support page? Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Its just been release and is a part of a bunch of utilities that BMC support is working on which will eventually be released.. At the moment they have released a utility to mass load users, associate these users with permission groups, mass define their access. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Monday, May 14, 2007 5:25 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Where did you see this utility, or was it only available directly through support??? I can't comment (yet) since I had not heard of it. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Does this happen only with $DEFAULT$ mapped to a field or does it happen with constant values mapped to a field? By constant values I mean if in case we want to put a value of lets say 'x' to a field and we type x into the value part on the import tool mapping, will it fail? I may have to do something like that while importing people information into CTM:People using a excel file format that BMC gave me with a few merge filters, and they have instructed me to put constant values such as 00 in a field and PPL in another.. I'm wondering if I would need to define filters in order to input these values? On a slightly related note (mass importing users from external sources), has anyone else used that utility that comes with 2 def files: 1) PeopleDataLoad.def 2) PeopleDataLoad_APS.def (optional if you have the approval server installed) Any shortcomings using this? One inconsistency that I noticed is that the filters defined on MERGE, formats the phone numbers in the format +1 999 888 Ext. while the out of the box submit/modify active links if entering the data using the administration interface formats it as 1 999 888 (). The outputs described happens in the event the country code is 1, Area code is 999, Local phone is 888 and Extension is . As this would bring about data to be formatted differently when imported, I've disabled the MERGE filters that format phone, fax, pager numbers after importing the above def files. I was wondering if anyone has noticed any other discrepancies in these def files if anyone else has used the same.. Rgds Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 4:08 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Yeah, I've seen that the Modify Escalations seem to update all records, because I haven't found a effective and efficient way to check for changes, and it would probably take almost as much time to do the check as it would to update the data anyway. Thankfully, we're under a thousand, so actions to submit and/or modify all records only take a minute or so. The data is fairly volatile, so I'll try updating it every few hours during the day. It shouldn't be a noticeable impact, and if it is, we can always back it off to an acceptable balance. Thanks again! Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Monday, May 14, 2007 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** When I did the push qualification I did a RequestID != Remedy Login. My Vendor request ID is mapped to the network login. The only potential problem is that if you have 5000 entries the qualification will require all records be compared and of course the escalation should be run after hours. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14 May 2007 3:39 PM Subject: Re: ITSM 7/LDAP not importing some records ** Thanks, Roger and Fred, I'll do that. Interesting that the Default value wouldn't be seen by Filters and Escalations. Have you found any other gotchas with LDAP? Also, am I assuming correctly that the Escalation, when it fires against the Vendor form, will do a fresh pull from LDAP vs. just getting whatever might be in that form from the last manual search? Rick _ From:
Re: ITSM 7/LDAP not importing some records
Its just been release and is a part of a bunch of utilities that BMC support is working on which will eventually be released.. At the moment they have released a utility to mass load users, associate these users with permission groups, mass define their access. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of strauss Sent: Monday, May 14, 2007 5:25 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Where did you see this utility, or was it only available directly through support??? I can't comment (yet) since I had not heard of it. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Does this happen only with $DEFAULT$ mapped to a field or does it happen with constant values mapped to a field? By constant values I mean if in case we want to put a value of lets say 'x' to a field and we type x into the value part on the import tool mapping, will it fail? I may have to do something like that while importing people information into CTM:People using a excel file format that BMC gave me with a few merge filters, and they have instructed me to put constant values such as 00 in a field and PPL in another.. I'm wondering if I would need to define filters in order to input these values? On a slightly related note (mass importing users from external sources), has anyone else used that utility that comes with 2 def files: 1) PeopleDataLoad.def 2) PeopleDataLoad_APS.def (optional if you have the approval server installed) Any shortcomings using this? One inconsistency that I noticed is that the filters defined on MERGE, formats the phone numbers in the format +1 999 888 Ext. while the out of the box submit/modify active links if entering the data using the administration interface formats it as 1 999 888 (). The outputs described happens in the event the country code is 1, Area code is 999, Local phone is 888 and Extension is . As this would bring about data to be formatted differently when imported, I've disabled the MERGE filters that format phone, fax, pager numbers after importing the above def files. I was wondering if anyone has noticed any other discrepancies in these def files if anyone else has used the same.. Rgds Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 4:08 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Yeah, I've seen that the Modify Escalations seem to update all records, because I haven't found a effective and efficient way to check for changes, and it would probably take almost as much time to do the check as it would to update the data anyway. Thankfully, we're under a thousand, so actions to submit and/or modify all records only take a minute or so. The data is fairly volatile, so I'll try updating it every few hours during the day. It shouldn't be a noticeable impact, and if it is, we can always back it off to an acceptable balance. Thanks again! Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Monday, May 14, 2007 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** When I did the push qualification I did a RequestID != Remedy Login. My Vendor request ID is mapped to the network login. The only potential problem is that if you have 5000 entries the qualification will require all records be compared and of course the escalation should be run after hours. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14 May 2007 3:39 PM Subject: Re: ITSM 7/LDAP not importing some records ** Thanks, Roger and Fred, I'll do that. Interesting that the Default value wouldn't be seen by Filters and Escalations. Have you found any other gotchas with LDAP? Also, am I assuming correctly that the Escalation, when it fires against the Vendor form, will do a fresh pull from LDAP vs. just getting whatever might be in that form from the last manual search? Rick From: Action Request System discussion list(ARSList) [mailto:[EMA
Re: ITSM 7/LDAP not importing some records
I didn't try mapping $DEFAULT$, I just had a value in the field, and it wasn't checking the default because I only told it to get it from the LDAP record. My bad there. My structure (which seems to be working) is now this: :00: Escalation that imports new records containing phone #s. :05: Escalation that imports new records NOT containing phone #s. :10: Escalation that updates existing records containing phone #s. :15: Escalation that updates existing records NOT containing phone #s. Filter (firing on Modify where 'Last Modified' = AR_ESCALATOR) that does some data gathering from other forms, and does various set fields to more completely populate the user record (Cost Center, Manager's name, etc.). Still fleshing this one out, but I'm most of the way there. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 2:19 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Does this happen only with $DEFAULT$ mapped to a field or does it happen with constant values mapped to a field? By constant values I mean if in case we want to put a value of lets say 'x' to a field and we type x into the value part on the import tool mapping, will it fail? I may have to do something like that while importing people information into CTM:People using a excel file format that BMC gave me with a few merge filters, and they have instructed me to put constant values such as 00 in a field and PPL in another.. I'm wondering if I would need to define filters in order to input these values? On a slightly related note (mass importing users from external sources), has anyone else used that utility that comes with 2 def files: 1) PeopleDataLoad.def 2) PeopleDataLoad_APS.def (optional if you have the approval server installed) Any shortcomings using this? One inconsistency that I noticed is that the filters defined on MERGE, formats the phone numbers in the format +1 999 888 Ext. while the out of the box submit/modify active links if entering the data using the administration interface formats it as 1 999 888 (). The outputs described happens in the event the country code is 1, Area code is 999, Local phone is 888 and Extension is . As this would bring about data to be formatted differently when imported, I've disabled the MERGE filters that format phone, fax, pager numbers after importing the above def files. I was wondering if anyone has noticed any other discrepancies in these def files if anyone else has used the same.. Rgds Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 4:08 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Yeah, I've seen that the Modify Escalations seem to update all records, because I haven't found a effective and efficient way to check for changes, and it would probably take almost as much time to do the check as it would to update the data anyway. Thankfully, we're under a thousand, so actions to submit and/or modify all records only take a minute or so. The data is fairly volatile, so I'll try updating it every few hours during the day. It shouldn't be a noticeable impact, and if it is, we can always back it off to an acceptable balance. Thanks again! Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Monday, May 14, 2007 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** When I did the push qualification I did a RequestID != Remedy Login. My Vendor request ID is mapped to the network login. The only potential problem is that if you have 5000 entries the qualification will require all records be compared and of course the escalation should be run after hours. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14 May 2007 3:39 PM Subject: Re: ITSM 7/LDAP not importing some records ** Thanks, Roger and Fred, I'll do that. Interesting that the Default value wouldn't be seen by Filters and Escalations. Have you found any other gotchas with LDAP? Also, am I assuming correctly that the Escalation, when it fires against the Vendor form, will do a fresh pull from LDAP vs. just getting whatever might be in that form from the last manual search? Rick _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Roger Justice Sent: Monday, May 14, 2007 12:09 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Yes, mine did the same thing and I created 2 escalations 1 if there was a phone number and 2 if there was no phone number. On the
Re: ITSM 7/LDAP not importing some records
Where did you see this utility, or was it only available directly through support??? I can't comment (yet) since I had not heard of it. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 4:19 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Does this happen only with $DEFAULT$ mapped to a field or does it happen with constant values mapped to a field? By constant values I mean if in case we want to put a value of lets say 'x' to a field and we type x into the value part on the import tool mapping, will it fail? I may have to do something like that while importing people information into CTM:People using a excel file format that BMC gave me with a few merge filters, and they have instructed me to put constant values such as 00 in a field and PPL in another.. I'm wondering if I would need to define filters in order to input these values? On a slightly related note (mass importing users from external sources), has anyone else used that utility that comes with 2 def files: 1) PeopleDataLoad.def 2) PeopleDataLoad_APS.def (optional if you have the approval server installed) Any shortcomings using this? One inconsistency that I noticed is that the filters defined on MERGE, formats the phone numbers in the format +1 999 888 Ext. while the out of the box submit/modify active links if entering the data using the administration interface formats it as 1 999 888 (). The outputs described happens in the event the country code is 1, Area code is 999, Local phone is 888 and Extension is . As this would bring about data to be formatted differently when imported, I've disabled the MERGE filters that format phone, fax, pager numbers after importing the above def files. I was wondering if anyone has noticed any other discrepancies in these def files if anyone else has used the same.. Rgds Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 4:08 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Yeah, I've seen that the Modify Escalations seem to update all records, because I haven't found a effective and efficient way to check for changes, and it would probably take almost as much time to do the check as it would to update the data anyway. Thankfully, we're under a thousand, so actions to submit and/or modify all records only take a minute or so. The data is fairly volatile, so I'll try updating it every few hours during the day. It shouldn't be a noticeable impact, and if it is, we can always back it off to an acceptable balance. Thanks again! Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Monday, May 14, 2007 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** When I did the push qualification I did a RequestID != Remedy Login. My Vendor request ID is mapped to the network login. The only potential problem is that if you have 5000 entries the qualification will require all records be compared and of course the escalation should be run after hours. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14 May 2007 3:39 PM Subject: Re: ITSM 7/LDAP not importing some records ** Thanks, Roger and Fred, I'll do that. Interesting that the Default value wouldn't be seen by Filters and Escalations. Have you found any other gotchas with LDAP? Also, am I assuming correctly that the Escalation, when it fires against the Vendor form, will do a fresh pull from LDAP vs. just getting whatever might be in that form from the last manual search? Rick _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Roger Justice Sent: Monday, May 14, 2007 12:09 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Yes, mine did the same thing and I created 2 escalations 1 if there was a phone number and 2 if there was no phone number. On the no phone number I hard coded the receptionist. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14
Re: ITSM 7/LDAP not importing some records
Does this happen only with $DEFAULT$ mapped to a field or does it happen with constant values mapped to a field? By constant values I mean if in case we want to put a value of lets say 'x' to a field and we type x into the value part on the import tool mapping, will it fail? I may have to do something like that while importing people information into CTM:People using a excel file format that BMC gave me with a few merge filters, and they have instructed me to put constant values such as 00 in a field and PPL in another.. I'm wondering if I would need to define filters in order to input these values? On a slightly related note (mass importing users from external sources), has anyone else used that utility that comes with 2 def files: 1) PeopleDataLoad.def 2) PeopleDataLoad_APS.def (optional if you have the approval server installed) Any shortcomings using this? One inconsistency that I noticed is that the filters defined on MERGE, formats the phone numbers in the format +1 999 888 Ext. while the out of the box submit/modify active links if entering the data using the administration interface formats it as 1 999 888 (). The outputs described happens in the event the country code is 1, Area code is 999, Local phone is 888 and Extension is . As this would bring about data to be formatted differently when imported, I've disabled the MERGE filters that format phone, fax, pager numbers after importing the above def files. I was wondering if anyone has noticed any other discrepancies in these def files if anyone else has used the same.. Rgds Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 4:08 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Yeah, I've seen that the Modify Escalations seem to update all records, because I haven't found a effective and efficient way to check for changes, and it would probably take almost as much time to do the check as it would to update the data anyway. Thankfully, we're under a thousand, so actions to submit and/or modify all records only take a minute or so. The data is fairly volatile, so I'll try updating it every few hours during the day. It shouldn't be a noticeable impact, and if it is, we can always back it off to an acceptable balance. Thanks again! Rick -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Monday, May 14, 2007 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** When I did the push qualification I did a RequestID != Remedy Login. My Vendor request ID is mapped to the network login. The only potential problem is that if you have 5000 entries the qualification will require all records be compared and of course the escalation should be run after hours. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14 May 2007 3:39 PM Subject: Re: ITSM 7/LDAP not importing some records ** Thanks, Roger and Fred, I'll do that. Interesting that the Default value wouldn't be seen by Filters and Escalations. Have you found any other gotchas with LDAP? Also, am I assuming correctly that the Escalation, when it fires against the Vendor form, will do a fresh pull from LDAP vs. just getting whatever might be in that form from the last manual search? Rick -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Monday, May 14, 2007 12:09 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Yes, mine did the same thing and I created 2 escalations 1 if there was a phone number and 2 if there was no phone number. On the no phone number I hard coded the receptionist. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14 May 2007 2:52 PM Subject: ITSM 7/LDAP not importing some records ** I have an ARDBC integration between ITSM 7.0.2 and LDAP that is working fine, except that it won't import records for which there is no phone #. Even though there is a Default Phone # in the Business Phone # field, only LDAP records with a value in the 'telephoneNumber' attribute get imported. The really puzzling part is that after running Filter and Escalation logs while the data is importing, the error is not generated from Remedy workflow, from what I can see. The Escalation displays that an error occurred at the end of each record's Push Fields, but is no more specific than that. The Filter logs don't sh
Re: ITSM 7/LDAP not importing some records
Yeah, I've seen that the Modify Escalations seem to update all records, because I haven't found a effective and efficient way to check for changes, and it would probably take almost as much time to do the check as it would to update the data anyway. Thankfully, we're under a thousand, so actions to submit and/or modify all records only take a minute or so. The data is fairly volatile, so I'll try updating it every few hours during the day. It shouldn't be a noticeable impact, and if it is, we can always back it off to an acceptable balance. Thanks again! Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Monday, May 14, 2007 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** When I did the push qualification I did a RequestID != Remedy Login. My Vendor request ID is mapped to the network login. The only potential problem is that if you have 5000 entries the qualification will require all records be compared and of course the escalation should be run after hours. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14 May 2007 3:39 PM Subject: Re: ITSM 7/LDAP not importing some records ** Thanks, Roger and Fred, I'll do that. Interesting that the Default value wouldn't be seen by Filters and Escalations. Have you found any other gotchas with LDAP? Also, am I assuming correctly that the Escalation, when it fires against the Vendor form, will do a fresh pull from LDAP vs. just getting whatever might be in that form from the last manual search? Rick _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Roger Justice Sent: Monday, May 14, 2007 12:09 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Yes, mine did the same thing and I created 2 escalations 1 if there was a phone number and 2 if there was no phone number. On the no phone number I hard coded the receptionist. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14 May 2007 2:52 PM Subject: ITSM 7/LDAP not importing some records ** I have an ARDBC integration between ITSM 7.0.2 and LDAP that is working fine, except that it won't import records for which there is no phone #. Even though there is a Default Phone # in the Business Phone # field, only LDAP records with a value in the 'telephoneNumber' attribute get imported. The really puzzling part is that after running Filter and Escalation logs while the data is importing, the error is not generated from Remedy workflow, from what I can see. The Escalation displays that an error occurred at the end of each record's Push Fields, but is no more specific than that. The Filter logs don't show any related problems at all. Has anyone run into this before? Rick Cook __20060125___This posting was submitted with HTML in it___ _ AOL now offers free email to everyone. Find out more about what's free from AOL at <http://www.aol.com/?ncid=AOLAOF0002000437> AOL.com. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ITSM 7/LDAP not importing some records
When I did the push qualification I did a RequestID != Remedy Login. My Vendor request ID is mapped to the network login. The only potential problem is that if you have 5000 entries the qualification will require all records be compared and of course the escalation should be run after hours. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14 May 2007 3:39 PM Subject: Re: ITSM 7/LDAP not importing some records ** Thanks, Roger and Fred, I'll do that. Interesting that the Default value wouldn't be seen by Filters and Escalations. Have you found any other gotchas with LDAP? Also, am I assuming correctly that the Escalation, when it fires against the Vendor form, will do a fresh pull from LDAP vs. just getting whatever might be in that form from the last manual search? Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Monday, May 14, 2007 12:09 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Yes, mine did the same thing and I created 2 escalations 1 if there was a phone number and 2 if there was no phone number. On the no phone number I hard coded the receptionist. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14 May 2007 2:52 PM Subject: ITSM 7/LDAP not importing some records ** I have an ARDBC integration between ITSM 7.0.2 and LDAP that is working fine, except that it won't import records for which there is no phone #. Even though there is a Default Phone # in the Business Phone # field, only LDAP records with a value in the 'telephoneNumber' attribute get imported. The really puzzling part is that after running Filter and Escalation logs while the data is importing, the error is not generated from Remedy workflow, from what I can see. The Escalation displays that an error occurred at the end of each record's Push Fields, but is no more specific than that. The Filter logs don't show any related problems at all. Has anyone run into this before? Rick Cook __20060125___This posting was submitted with HTML in it___ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ITSM 7/LDAP not importing some records
Thanks, Roger and Fred, I'll do that. Interesting that the Default value wouldn't be seen by Filters and Escalations. Have you found any other gotchas with LDAP? Also, am I assuming correctly that the Escalation, when it fires against the Vendor form, will do a fresh pull from LDAP vs. just getting whatever might be in that form from the last manual search? Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice Sent: Monday, May 14, 2007 12:09 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Yes, mine did the same thing and I created 2 escalations 1 if there was a phone number and 2 if there was no phone number. On the no phone number I hard coded the receptionist. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14 May 2007 2:52 PM Subject: ITSM 7/LDAP not importing some records ** I have an ARDBC integration between ITSM 7.0.2 and LDAP that is working fine, except that it won't import records for which there is no phone #. Even though there is a Default Phone # in the Business Phone # field, only LDAP records with a value in the 'telephoneNumber' attribute get imported. The really puzzling part is that after running Filter and Escalation logs while the data is importing, the error is not generated from Remedy workflow, from what I can see. The Escalation displays that an error occurred at the end of each record's Push Fields, but is no more specific than that. The Filter logs don't show any related problems at all. Has anyone run into this before? Rick Cook __20060125___This posting was submitted with HTML in it___ _ AOL now offers free email to everyone. Find out more about what's free from AOL at <http://www.aol.com?ncid=AOLAOF0002000437> AOL.com. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ITSM 7/LDAP not importing some records
Yes, Joe, the records are all in the Vendor form. But there are about 100 that didn't get pushed into the CTM:People form, and the lack of a Phone Number is the only common element between them. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, May 14, 2007 12:07 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7/LDAP not importing some records ** Rick, In the vendor form you created, do you see the records without a phone number when you perform a search? Maybe you aren't constructing the correct LDAP URL to view the information you want to and are disqualifying null phone numbers in your LDAP qualification? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 2:53 PM To: arslist@ARSLIST.ORG Subject: ITSM 7/LDAP not importing some records ** I have an ARDBC integration between ITSM 7.0.2 and LDAP that is working fine, except that it won't import records for which there is no phone #. Even though there is a Default Phone # in the Business Phone # field, only LDAP records with a value in the 'telephoneNumber' attribute get imported. The really puzzling part is that after running Filter and Escalation logs while the data is importing, the error is not generated from Remedy workflow, from what I can see. The Escalation displays that an error occurred at the end of each record's Push Fields, but is no more specific than that. The Filter logs don't show any related problems at all. Has anyone run into this before? Rick Cook __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ITSM 7/LDAP not importing some records
Yes, mine did the same thing and I created 2 escalations 1 if there was a phone number and 2 if there was no phone number. On the no phone number I hard coded the receptionist. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Mon, 14 May 2007 2:52 PM Subject: ITSM 7/LDAP not importing some records ** I have an ARDBC integration between ITSM 7.0.2 and LDAP that is working fine, except that it won't import records for which there is no phone #. Even though there is a Default Phone # in the Business Phone # field, only LDAP records with a value in the 'telephoneNumber' attribute get imported. The really puzzling part is that after running Filter and Escalation logs while the data is importing, the error is not generated from Remedy workflow, from what I can see. The Escalation displays that an error occurred at the end of each record's Push Fields, but is no more specific than that. The Filter logs don't show any related problems at all. Has anyone run into this before? Rick Cook __20060125___This posting was submitted with HTML in it___ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ITSM 7/LDAP not importing some records
Rick, In the vendor form you created, do you see the records without a phone number when you perform a search? Maybe you aren't constructing the correct LDAP URL to view the information you want to and are disqualifying null phone numbers in your LDAP qualification? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Monday, May 14, 2007 2:53 PM To: arslist@ARSLIST.ORG Subject: ITSM 7/LDAP not importing some records ** I have an ARDBC integration between ITSM 7.0.2 and LDAP that is working fine, except that it won't import records for which there is no phone #. Even though there is a Default Phone # in the Business Phone # field, only LDAP records with a value in the 'telephoneNumber' attribute get imported. The really puzzling part is that after running Filter and Escalation logs while the data is importing, the error is not generated from Remedy workflow, from what I can see. The Escalation displays that an error occurred at the end of each record's Push Fields, but is no more specific than that. The Filter logs don't show any related problems at all. Has anyone run into this before? Rick Cook __20060125___This posting was submitted with HTML in it___ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: 269.7.0/803 - Release Date: 5/13/2007 12:17 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ITSM 7/LDAP not importing some records
I have seen it before where a Default Value does not apply to a Push fields action. Try adding a Filter (on Modify & Merge) where Business Phone # = $NULL$ to set the field with your default. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Monday, May 14, 2007 1:53 PM To: arslist@ARSLIST.ORG Subject: ITSM 7/LDAP not importing some records ** I have an ARDBC integration between ITSM 7.0.2 and LDAP that is working fine, except that it won't import records for which there is no phone #. Even though there is a Default Phone # in the Business Phone # field, only LDAP records with a value in the 'telephoneNumber' attribute get imported. The really puzzling part is that after running Filter and Escalation logs while the data is importing, the error is not generated from Remedy workflow, from what I can see. The Escalation displays that an error occurred at the end of each record's Push Fields, but is no more specific than that. The Filter logs don't show any related problems at all. Has anyone run into this before? Rick Cook ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"