Re: Installation Error
Hi Abdul, Is database remote? What is OS? Which Database? check arerror log file as well. -- Sandeep Pandey Remedy Developer On Thu, May 2, 2013 at 1:47 AM, laurent matheo lm...@me.com wrote: ** You should check the /ARSystem/arserver/db/arerror.log file and the installation log file which is in the temp folder, usually something like c:/users/administrator/appdata/local/temp/ folder. Perhaps the ARmonitor service already (still) exists? On 01 May, 2013,at 10:14 PM, Abdullah Baytops abayt...@onefederalsolution.com wrote: I had installed 7.6.04 on a server in our environment in which were using and today I decided to uninstall it from our app server and database server. In then tried to reinstall it on our servers and all day I have been not able to install the server from the setup.exe files provided onto the existing DB (MS SQL Server) or App Server. Is there something the DB may be maintaining or holding in a certain location since it was installed on the sever before. When I run the installer we get 90% through the installation and it fails. When I look at the DB it has been created but the services will not start. Any ideas would be great. V/R Abdul Baytops _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: Relate a change to a change error
** Hi, For Oracle Database following information may help you:- 1Character with a maximum length of 4000 or fewer bytes = varchar for DB2 Oracle DB 2Character with an unlimited length or a maximum length of more than 4000 bytes=clob for Db2 Oracle DB 3If you set the Input Length to more than the maximum for varchar, the character field is created as a clob database table column and storage is allocated in blocks that average between 1K to 2K bytes (depending on the database). A full block is allocated for the first byte. When that block is filled with the field contents, another full block is allocated. 4CLOB (character large object) data is stored: In Row:- If the length of the character data, including the LOB locator, is less than or equal to 4000 bytes, store the data "in row." If the length of the character data, including the LOB locator, is greater than 4000 bytes, store the LOB locator "in row" and the data "out row." you expect to store unusually large amounts of data in CLOBs, set this option to TRUE before installing AR System applications so that all database tables for applications are created in-row. In-row CLOBs can degrade CPU performance. If a field contains more than 4000 characters, the CLOB is stored out row no matter which value is specified for this server setting. Out Row Store the data "out row." Out-row CLOBs can cause the database to grow rapidly. Regards, Trupti Thorave On 4/30/2013 8:24 PM, Brittain, Mark wrote: ** HI All, I have an interesting situation that was reported to me. If a user using an existing Change selects Create Related Request Infrastructure Change sometimes it works and sometimes it does not. Specifically the new Change is displayed and if there is a small amount of data in the Notes/Detailed Description, the new Change is saved. If the Notes/Detailed Description is like 4,000 characters, on save the user gets an error Required field cannot be blank.: Request ID (ARERR 326) I would think if the issue was the size of the Notes was too big, it would generate max limit. Has anyone encountered this issue? ITSM 7.6.04 SP3 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_
Filter - Webservice
I have been looking into one scenario to reproduce in test env but I just confused more on this. It is like I have a filter with below syntax, Filter name : Filter A Filter runif: field1 = abdc AND field2 = No Actions : Set field - field 2 = Yes Set field - Trigger 3rd party webservice. After firing the filter A for first time, field2 was set to the value Yes and triggered the wbs request to a middle ware app for a record. After few minutes, the same request has been triggered thrice with the intervals of milliseconds which make me to think, after the value change in Runif field2, is it possible to trigger the filter again? :( From the user tool wise, there is no track of changes in the record and we don't have logs as well. I suspect this can't be by user action, since it of milliseconds interval. Does any come across in ARS 7.1 patch 8 in solaris box.? Any solutions/ ideas are much appreciated to reproduce/resolve. Regards, Govind 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 Where the Answers Are, and have been for 20 years
Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE
Apart from Application installtion dir/bin in LD_LIBRARY_PATH, I have found only one path updated for java: /usr/java/jre/lib/sparc/client. I am not sure after installation, is it updated or needs to be updated correctly. Can you pls guide me what to look out in CLASSPATH. Yes Joe, I have checked by running the plugin start up command thru command line separately. It brought up the Webservice and other plugins as well :). The problem happens when I get HPI library error while restarting it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Thursday, April 11, 2013 7:28 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE ** Apart from your class path examine the plugin startup command in the armonitor file. Try to start it from the command line and see what is the error you get, assuming for some reason it has not started. Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ali A. Musa Sent: Wednesday, April 10, 2013 4:23 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE Check the CLASSPATH From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Govind M Sent: Wednesday, April 10, 2013 10:44 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE ** Hi All, Request your expertise advice for the below error. ARERR 8755 error message for ARSYS.ARF.WEBSERVICE What happened is, upgrading patch 9 in ARS 7.1 in unix environment had failed to set the environment path of Application installtion dir/bin in LD_LIBRARY_PATH and java path which we provided during installation. When we restart the ARSystem, it failed to load Java and webservice plugins and gives HPI library error. We have a case opened with BMC. As per their suggestion, after exporting Application installtion dir/bin in LD_LIBRARY_PATH, tried separately initiating Arplugin process, once arsystem is up which loaded Web service and other plugins properly. For this activity, we have commented the arplugin line item in armonitor.conf. But can't able to figure out, why we are getting these ARERROR 8755 and HPI library error only when we start the ars with uncommenting arplugin line item in armontior.conf. What is the cause for these errors which is not appearing on separate initialization of arplugin..? Thanks, Govind 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.comhttp://www.wipro.com _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ 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 Where the Answers Are, and have been for 20 years
Extracting substring from string and putting the value in different field
Hello Lister's, We have a requirement. Where we have a string which contains incident id's separated by ,. And my requirement is to extract the individual incident from the string and put the value to separate field. Example of the above requirement == Input == TMP_field =INC000123, INC000456, INC000789, INC05 Output === Felid1 = INC000123 Felid2 = INC000456 Felid3 = INC000789 Felid4 = INC05 and my question is how do I accomplish the above task. Please help me out to accomplish the above requirement. Many thanks for all your suggestion and help in advance. Regards, Sanjay. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Exporting data from CLM - Non-CLM
Hello All, We are currently running CLM 3.0 which contains additional cloud data that is not present in Atrium 8.0. We initially tried to use the CMDBDriver utility, but since its version specific we have been unsuccessful. The issue we are having is that the source Atrium has certain CMDB extensions that do not (and should not) exist on the target Atrium. Specifically, the CLM Cloud Extensions are installed on the source Atrium. When we run an import using the *CMDBDriver utility* on the stand-alone Atrium 8, we get import errors (120004) complaining that attributes in the XML import files does not exist in the target dataset. We know what the issue is, but are unsure how to solve it. Essentially, we want to export a subset data from CLM 3.0 Atrium. For a given dataset, we want to export all classes attributes that exist in the BMC.CORE, BMC.AM, and possibly BMC.FED namespaces. Even when specifying a specific namespace to export, the resulting XML files still contain attributes that are provided by other namespaces. This subsequently causes imports to fail, since there is extra data. Thanks for the help! Jared ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Extracting substring from string and putting the value in different field
So you will always have four Incidents that you have to parse to pass to four specific fields? If so, you can do four different Set Fields on the same AL/Filter with different SUBSTRING values pulling each Incident out based on the start and stop values of the SUBSTRING function on the TMP_field. If it's a one to many type of list, then I wouldn't do that, nor would I write them to hardcoded fields. In that case it gets more complicated, but it's still easily doable. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of sanjay Sent: Thursday, May 02, 2013 7:35 AM To: arslist@ARSLIST.ORG Subject: Extracting substring from string and putting the value in different field Hello Lister's, We have a requirement. Where we have a string which contains incident id's separated by ,. And my requirement is to extract the individual incident from the string and put the value to separate field. Example of the above requirement == Input == TMP_field =INC000123, INC000456, INC000789, INC05 Output === Felid1 = INC000123 Felid2 = INC000456 Felid3 = INC000789 Felid4 = INC05 and my question is how do I accomplish the above task. Please help me out to accomplish the above requirement. Many thanks for all your suggestion and help in advance. Regards, Sanjay. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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: Exporting data from CLM - Non-CLM
The easiest way to accomplish this transfer is by using DSO. -Original Message- From: Jared Dean jldea...@gmail.com To: arslist arslist@ARSLIST.ORG Sent: Thu, May 2, 2013 8:37 am Subject: Exporting data from CLM - Non-CLM ** Hello All, We are currentlyrunning CLM 3.0 which contains additional cloud data that is not present inAtrium 8.0. We initially tried to use the CMDBDriver utility, but since its version specific we have been unsuccessful. The issue we arehaving is that the source Atrium has certain CMDB extensions that do not (andshould not) exist on the target Atrium. Specifically, the CLM Cloud Extensionsare installed on the source Atrium. When we run an import using the CMDBDriver utility on the stand-aloneAtrium 8, we get import errors (120004) complaining that attributes in the XMLimport files does not exist in the target dataset. We know what the issue is,but are unsure how to solve it. Essentially, we want to export a subset datafrom CLM 3.0 Atrium. For a given dataset, we want to export all classes attributes that exist in the BMC.CORE, BMC.AM, and possibly BMC.FED namespaces.Even when specifying a specific namespace to export, the resulting XML filesstill contain attributes that are provided by other namespaces. Thissubsequently causes imports to fail, since there is extra data. Thanks for thehelp! Jared _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: Exporting data from CLM - Non-CLM
Thanks for the reply John. Unfortunately, DSO is not an option due to the way our infrastructure is setup. -Jared On Thu, May 2, 2013 at 8:43 AM, Roger J rjust2...@aol.com wrote: ** The easiest way to accomplish this transfer is by using DSO. -Original Message- From: Jared Dean jldea...@gmail.com To: arslist arslist@ARSLIST.ORG Sent: Thu, May 2, 2013 8:37 am Subject: Exporting data from CLM - Non-CLM ** Hello All, We are currently running CLM 3.0 which contains additional cloud data that is not present in Atrium 8.0. We initially tried to use the CMDBDriver utility, but since its version specific we have been unsuccessful. The issue we are having is that the source Atrium has certain CMDB extensions that do not (and should not) exist on the target Atrium. Specifically, the CLM Cloud Extensions are installed on the source Atrium. When we run an import using the *CMDBDriver utility* on the stand-alone Atrium 8, we get import errors (120004) complaining that attributes in the XML import files does not exist in the target dataset. We know what the issue is, but are unsure how to solve it. Essentially, we want to export a subset data from CLM 3.0 Atrium. For a given dataset, we want to export all classes attributes that exist in the BMC.CORE, BMC.AM, and possibly BMC.FED namespaces. Even when specifying a specific namespace to export, the resulting XML files still contain attributes that are provided by other namespaces. This subsequently causes imports to fail, since there is extra data. Thanks for the help! Jared _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
IE 10 on Windows 8
Hello All, Is anyone experiencing browser issues when attempting to use any of the ITSM 8 modules with IE10 on Windows 8? Leo ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: IE 10 on Windows 8
Are you using the IE Compatible mode? Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Leonard Nelson Sent: Thursday, May 02, 2013 8:48 AM To: arslist@ARSLIST.ORG Subject: IE 10 on Windows 8 ** Hello All, Is anyone experiencing browser issues when attempting to use any of the ITSM 8 modules with IE10 on Windows 8? Leo _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: Filter - Webservice
is Field2 'real' or is it display only? On Thu, May 2, 2013 at 5:51 AM, Govind M govind@wipro.com wrote: ** I have been looking into one scenario to reproduce in test env but I just confused more on this. It is like I have a filter with below syntax, ** ** Filter name : Filter A Filter runif: field1 = abdc AND field2 = No Actions : Set field - field 2 = Yes Set field - Trigger 3rd party webservice.*** * ** ** After firing the filter A for first time, field2 was set to the value “Yes” and triggered the wbs request to a middle ware app for a record. After few minutes, the same request has been triggered thrice with the intervals of milliseconds which make me to think, after the value change in Runif field2, is it possible to trigger the filter again? L From the user tool wise, there is no track of changes in the record and we don’t have logs as well. I suspect this can’t be by user action, since it of milliseconds interval. ** ** Does any come across in ARS 7.1 patch 8 in solaris box.? Any solutions/ ideas are much appreciated to reproduce/resolve. ** ** Regards, Govind * 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 _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: Extracting substring from string and putting the value in different field
Hello Pierson, Thanks for your post.But how do I get the start and end position of the incident as the string is dynamic and start and end position cannot be hard coded. See below. I have just outlined the requirement. The string which contain incident has dynamic values and maximum contains 10 ids.Where I have to count the no. incidents and then put individual incident to different field. Example : Temp_field = string string =INC000123, INC000456, INC000789, INC05 or INC000123, INC000456, INC000789, INC05,INC000121, INC000453, INC000781, INC02 field1=INC000123 . . . Field4=INC000121 Field5=NULL . . Field10=NULL or field1=INC000123 . . Field8=INC02 Field9=NULL' Field10=NULL what I have to do is to count no. of ids and then put individual ids to fields. The value of sting cannot be hard coded. it is always dynamic but the limit is 10 records. Basically what I want to do is to parse the string and extract the sub-string whenever it find the delimiter , and then put the values to fields. Hope you have understood my requirement.And expect more suggestion from Lister's. Again,thanking in advance for all suggestion and help. Regards, Sanjay On Thu, May 2, 2013 at 6:11 PM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: So you will always have four Incidents that you have to parse to pass to four specific fields? If so, you can do four different Set Fields on the same AL/Filter with different SUBSTRING values pulling each Incident out based on the start and stop values of the SUBSTRING function on the TMP_field. If it's a one to many type of list, then I wouldn't do that, nor would I write them to hardcoded fields. In that case it gets more complicated, but it's still easily doable. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of sanjay Sent: Thursday, May 02, 2013 7:35 AM To: arslist@ARSLIST.ORG Subject: Extracting substring from string and putting the value in different field Hello Lister's, We have a requirement. Where we have a string which contains incident id's separated by ,. And my requirement is to extract the individual incident from the string and put the value to separate field. Example of the above requirement == Input == TMP_field =INC000123, INC000456, INC000789, INC05 Output === Felid1 = INC000123 Felid2 = INC000456 Felid3 = INC000789 Felid4 = INC05 and my question is how do I accomplish the above task. Please help me out to accomplish the above requirement. Many thanks for all your suggestion and help in advance. Regards, Sanjay. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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: Extracting substring from string and putting the value in different field
Sanjay, you are going to need something in the range of 11 filters...one of them that does a STRSTR to find the location of the , then one filter for each of the field1-10. Put them in a filter guide. Fire the filter that finds the , then, if that int is 0 use SUBSTR to grab the first value, storing it in field 1 and removing that value from your temp field, then call your find the , filter, rinse and repeat untill no , is found. If no , is found, exit the guide. On Thu, May 2, 2013 at 7:06 AM, kanhu mohapatra kanhu.san...@gmail.comwrote: ** Hello Pierson, Thanks for your post.But how do I get the start and end position of the incident as the string is dynamic and start and end position cannot be hard coded. See below. I have just outlined the requirement. The string which contain incident has dynamic values and maximum contains 10 ids.Where I have to count the no. incidents and then put individual incident to different field. Example : Temp_field = string string =INC000123, INC000456, INC000789, INC05 or INC000123, INC000456, INC000789, INC05,INC000121, INC000453, INC000781, INC02 field1=INC000123 . . . Field4=INC000121 Field5=NULL . . Field10=NULL or field1=INC000123 . . Field8=INC02 Field9=NULL' Field10=NULL what I have to do is to count no. of ids and then put individual ids to fields. The value of sting cannot be hard coded. it is always dynamic but the limit is 10 records. Basically what I want to do is to parse the string and extract the sub-string whenever it find the delimiter , and then put the values to fields. Hope you have understood my requirement.And expect more suggestion from Lister's. Again,thanking in advance for all suggestion and help. Regards, Sanjay On Thu, May 2, 2013 at 6:11 PM, Pierson, Shawn shawn.pier...@energytransfer.com wrote: So you will always have four Incidents that you have to parse to pass to four specific fields? If so, you can do four different Set Fields on the same AL/Filter with different SUBSTRING values pulling each Incident out based on the start and stop values of the SUBSTRING function on the TMP_field. If it's a one to many type of list, then I wouldn't do that, nor would I write them to hardcoded fields. In that case it gets more complicated, but it's still easily doable. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of sanjay Sent: Thursday, May 02, 2013 7:35 AM To: arslist@ARSLIST.ORG Subject: Extracting substring from string and putting the value in different field Hello Lister's, We have a requirement. Where we have a string which contains incident id's separated by ,. And my requirement is to extract the individual incident from the string and put the value to separate field. Example of the above requirement == Input == TMP_field =INC000123, INC000456, INC000789, INC05 Output === Felid1 = INC000123 Felid2 = INC000456 Felid3 = INC000789 Felid4 = INC05 and my question is how do I accomplish the above task. Please help me out to accomplish the above requirement. Many thanks for all your suggestion and help in advance. Regards, Sanjay. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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 _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: Exporting data from CLM - Non-CLM
how about RRRChive? On Thu, May 2, 2013 at 6:48 AM, Jared Dean jldea...@gmail.com wrote: ** Thanks for the reply John. Unfortunately, DSO is not an option due to the way our infrastructure is setup. -Jared On Thu, May 2, 2013 at 8:43 AM, Roger J rjust2...@aol.com wrote: ** The easiest way to accomplish this transfer is by using DSO. -Original Message- From: Jared Dean jldea...@gmail.com To: arslist arslist@ARSLIST.ORG Sent: Thu, May 2, 2013 8:37 am Subject: Exporting data from CLM - Non-CLM ** Hello All, We are currently running CLM 3.0 which contains additional cloud data that is not present in Atrium 8.0. We initially tried to use the CMDBDriver utility, but since its version specific we have been unsuccessful. The issue we are having is that the source Atrium has certain CMDB extensions that do not (and should not) exist on the target Atrium. Specifically, the CLM Cloud Extensions are installed on the source Atrium. When we run an import using the *CMDBDriver utility* on the stand-alone Atrium 8, we get import errors (120004) complaining that attributes in the XML import files does not exist in the target dataset. We know what the issue is, but are unsure how to solve it. Essentially, we want to export a subset data from CLM 3.0 Atrium. For a given dataset, we want to export all classes attributes that exist in the BMC.CORE, BMC.AM, and possibly BMC.FED namespaces. Even when specifying a specific namespace to export, the resulting XML files still contain attributes that are provided by other namespaces. This subsequently causes imports to fail, since there is extra data. Thanks for the help! Jared _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: IE 10 on Windows 8
Thanks very much. Disabled it and it worked well. Leo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra Sent: Thursday, May 2, 2013 8:49 AM To: arslist@ARSLIST.ORG Subject: Re: IE 10 on Windows 8 ** Are you using the IE Compatible mode? Thank you, Sandra Hennigan Remedy Developer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Leonard Nelson Sent: Thursday, May 02, 2013 8:48 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: IE 10 on Windows 8 ** Hello All, Is anyone experiencing browser issues when attempting to use any of the ITSM 8 modules with IE10 on Windows 8? Leo _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: AR System ODBC driver
I think Stuart had a typo ... Since the ODBC uses the Remedy application server, if you can't see something in Remedy you can't see it using the ODBC driver. One way around the join limitation is to use sub-reports in Crystal. You can then have multiple form(s) data in the report Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Schon, Stuart Sent: Wednesday, May 01, 2013 6:13 PM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver The main limitation is that you can perform joins in the query using the OBDC driver. If you need to join tables together you need to build them in Remedy first and then use in your report. The other restriction/feature is that the driver uses the Remedy data security model - so if you can't see something using Remedy you can see it in a report. Stuart Schon Service Desk Systems - Manager Fujitsu Australia Limited Please consider the environment before printing this email -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Thursday, 2 May 2013 6:37 AM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver Thanks Fred. I'll check it out. Sent from my iPhone On May 1, 2013, at 4:36 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: The Integration Guide document (Page 212) lists some issues and considerations -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Wednesday, May 01, 2013 2:25 PM To: arslist@ARSLIST.ORG Subject: AR System ODBC driver ** Version: 7.6.04 All, Does anyone know or have a document about what capabilities are available for the AR System ODBC driver? I have a user who is trying to use Crystal Reports by way of the driver and some features aren't working. -- Tauf Chowdhury ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE
Are you running ARS as non-root? When the startup fails is it when running ./arsystem start (from your bin directory) or when starting from the server init ? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Govind M Sent: Thursday, May 02, 2013 7:11 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE ** Apart from Application installtion dir/bin in LD_LIBRARY_PATH, I have found only one path updated for java: /usr/java/jre/lib/sparc/client. I am not sure after installation, is it updated or needs to be updated correctly. Can you pls guide me what to look out in CLASSPATH. Yes Joe, I have checked by running the plugin start up command thru command line separately. It brought up the Webservice and other plugins as well ☺. The problem happens when I get HPI library error while restarting it. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Thursday, April 11, 2013 7:28 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE ** Apart from your class path examine the plugin startup command in the armonitor file. Try to start it from the command line and see what is the error you get, assuming for some reason it has not started. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ali A. Musa Sent: Wednesday, April 10, 2013 4:23 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE Check the CLASSPATH -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Govind M Sent: Wednesday, April 10, 2013 10:44 AM To: arslist@ARSLIST.ORG Subject: ARERR 8755 error message for ARSYS.ARF.WEBSERVICE ** Hi All, Request your expertise advice for the below error. ARERR 8755 error message for ARSYS.ARF.WEBSERVICE What happened is, upgrading patch 9 in ARS 7.1 in unix environment had failed to set the environment path of Application installtion dir/bin in LD_LIBRARY_PATH and java path which we provided during installation. When we restart the ARSystem, it failed to load Java and webservice plugins and gives HPI library error. We have a case opened with BMC. As per their suggestion, after exporting Application installtion dir/bin in LD_LIBRARY_PATH, tried separately initiating Arplugin process, once arsystem is up which loaded Web service and other plugins properly. For this activity, we have commented the arplugin line item in armonitor.conf. But can’t able to figure out, why we are getting these ARERROR 8755 and HPI library error only when we start the ars with uncommenting arplugin line item in armontior.conf. What is the cause for these errors which is not appearing on separate initialization of arplugin..? Thanks, Govind ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Filter - Webservice
Does another filter which fires before this one set field2=No? If so maybe the response to web service call is modifying the record, workflow sets field2 to No and the cycle starts over when filter A fires again. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Govind M Sent: Thursday, May 02, 2013 7:51 AM To: arslist@ARSLIST.ORG Subject: Filter - Webservice ** I have been looking into one scenario to reproduce in test env but I just confused more on this. It is like I have a filter with below syntax, Filter name : Filter A Filter runif: field1 = abdc AND field2 = No Actions : Set field - field 2 = Yes Set field - Trigger 3rd party webservice. After firing the filter A for first time, field2 was set to the value Yes and triggered the wbs request to a middle ware app for a record. After few minutes, the same request has been triggered thrice with the intervals of milliseconds which make me to think, after the value change in Runif field2, is it possible to trigger the filter again? :( From the user tool wise, there is no track of changes in the record and we don't have logs as well. I suspect this can't be by user action, since it of milliseconds interval. Does any come across in ARS 7.1 patch 8 in solaris box.? Any solutions/ ideas are much appreciated to reproduce/resolve. Regards, Govind 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.comhttp://www.wipro.com _ARSlist: Where the Answers Are and have been for 20 years_ 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: Extracting substring from string and putting the value in different field
This would be a situation where I would use the arfPerl plugin (but that is just me) as a simple split would take care of this. In pure ARS you could do it in a single filter that is called multiple times (in a Guide using goto label). While the number of entries may be dynamic the actual length of an incident ID is always the same. In pseudo code it would be something like this: Filter Run-If temp_Inbound_String != $NULL$ Action 1Field_10 = Field_9 Action 2Field_9 = Field_8 Action 3Field_8 = Field_7 Action 4Field_7 = Field_6 Action 5Field_6 = Field_5 Action 6Field_5 = Field_4 Action 7Field_4 = Field_3 Action 8Field_3 = Field_2 Action 9Field_2 = Field_1 Action 10 Field_1 = LEFT( $temp_Inbound_String$, 9) Action 11 temp_Inbound_String = LTRIM(RTRIM(SUBSTR($temp_Inbound_String$+ , 10))) Action 12 goto start of guide label The Filter Guide would be a start label and the filter to do the split. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj Sent: Thursday, May 02, 2013 8:12 AM To: arslist@ARSLIST.ORG Subject: Re: Extracting substring from string and putting the value in different field ** Sanjay, you are going to need something in the range of 11 filters...one of them that does a STRSTR to find the location of the , then one filter for each of the field1-10. Put them in a filter guide. Fire the filter that finds the , then, if that int is 0 use SUBSTR to grab the first value, storing it in field 1 and removing that value from your temp field, then call your find the , filter, rinse and repeat untill no , is found. If no , is found, exit the guide. -Original Message- On Thu, May 2, 2013 at 7:06 AM, kanhu mohapatra wrote: ** Hello Pierson, Thanks for your post.But how do I get the start and end position of the incident as the string is dynamic and start and end position cannot be hard coded. See below. I have just outlined the requirement. The string which contain incident has dynamic values and maximum contains 10 ids.Where I have to count the no. incidents and then put individual incident to different field. Example : Temp_field = string string =INC000123, INC000456, INC000789, INC05 or INC000123, INC000456, INC000789, INC05,INC000121, INC000453, INC000781, INC02 field1=INC000123 . . . Field4=INC000121 Field5=NULL . . Field10=NULL or field1=INC000123 . . Field8=INC02 Field9=NULL' Field10=NULL what I have to do is to count no. of ids and then put individual ids to fields. The value of sting cannot be hard coded. it is always dynamic but the limit is 10 records. Basically what I want to do is to parse the string and extract the sub-string whenever it find the delimiter , and then put the values to fields. Hope you have understood my requirement.And expect more suggestion from Lister's. Again,thanking in advance for all suggestion and help. Regards, Sanjay -Original Message- On Thu, May 2, 2013 at 6:11 PM, Pierson, Shawn wrote: So you will always have four Incidents that you have to parse to pass to four specific fields? If so, you can do four different Set Fields on the same AL/Filter with different SUBSTRING values pulling each Incident out based on the start and stop values of the SUBSTRING function on the TMP_field. If it's a one to many type of list, then I wouldn't do that, nor would I write them to hardcoded fields. In that case it gets more complicated, but it's still easily doable. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of sanjay Sent: Thursday, May 02, 2013 7:35 AM To: arslist@ARSLIST.ORG Subject: Extracting substring from string and putting the value in different field Hello Lister's, We have a requirement. Where we have a string which contains incident id's separated by ,. And my requirement is to extract the individual incident from the string and put the value to separate field. Example of the above requirement == Input == TMP_field =INC000123, INC000456, INC000789, INC05 Output === Felid1 = INC000123 Felid2 = INC000456 Felid3 = INC000789 Felid4 = INC05 and my question is how do I accomplish the above task. Please help me out to accomplish the above requirement. Many thanks for all your suggestion and help in advance. Regards, Sanjay. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access
Upgrade ARS from 7603 to 7604 SP4
Hi I would like to know whether we can directly upgrade from ARS 7603 (hot fix version - FCS MWRT SW00401937) to ARS 7604 SP4 while ITSM remains in 7603? any known errors or compatibility issues between ARS 7604 SP4 and ITSM 7603? Thanks Raja -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Upgrade-ARS-from-7603-to-7604-SP4-tp7588533.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Extracting substring from string and putting the value in different field
Have you tried using LEFTC function in set field action???.it will extract substrings and u can set into different field. Regards Jayesh On May 2, 2013 6:05 PM, sanjay kanhu.san...@gmail.com wrote: Hello Lister's, We have a requirement. Where we have a string which contains incident id's separated by ,. And my requirement is to extract the individual incident from the string and put the value to separate field. Example of the above requirement == Input == TMP_field =INC000123, INC000456, INC000789, INC05 Output === Felid1 = INC000123 Felid2 = INC000456 Felid3 = INC000789 Felid4 = INC05 and my question is how do I accomplish the above task. Please help me out to accomplish the above requirement. Many thanks for all your suggestion and help in advance. Regards, Sanjay. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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: Filter - Webservice
U can use filter guide to trigger the filter again using GO TO label and also u can use WAIT action for user interaction..i am not aware if we can run filter after some seconds...beware of using GO TO and make sure it doesnt lead to infinite loop..make sure u use exit to exit filter guide on false action Regards Jayesh On May 2, 2013 5:21 PM, Govind M govind@wipro.com wrote: ** I have been looking into one scenario to reproduce in test env but I just confused more on this. It is like I have a filter with below syntax, ** ** Filter name : Filter A Filter runif: field1 = abdc AND field2 = No Actions : Set field - field 2 = Yes Set field - Trigger 3rd party webservice.*** * ** ** After firing the filter A for first time, field2 was set to the value “Yes” and triggered the wbs request to a middle ware app for a record. After few minutes, the same request has been triggered thrice with the intervals of milliseconds which make me to think, after the value change in Runif field2, is it possible to trigger the filter again? L From the user tool wise, there is no track of changes in the record and we don’t have logs as well. I suspect this can’t be by user action, since it of milliseconds interval. ** ** Does any come across in ARS 7.1 patch 8 in solaris box.? Any solutions/ ideas are much appreciated to reproduce/resolve. ** ** Regards, Govind * 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 _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: Exporting data from CLM - Non-CLM
Have tried creating a job in Pentaho? We have recently done something similar and Pentaho worked for us! Tim -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jared Dean Sent: Thursday, May 02, 2013 6:28 AM To: arslist@ARSLIST.ORG Subject: Exporting data from CLM - Non-CLM ** Hello All, We are currently running CLM 3.0 which contains additional cloud data that is not present in Atrium 8.0. We initially tried to use the CMDBDriver utility, but since its version specific we have been unsuccessful. The issue we are having is that the source Atrium has certain CMDB extensions that do not (and should not) exist on the target Atrium. Specifically, the CLM Cloud Extensions are installed on the source Atrium. When we run an import using the CMDBDriver utility on the stand-alone Atrium 8, we get import errors (120004) complaining that attributes in the XML import files does not exist in the target dataset. We know what the issue is, but are unsure how to solve it. Essentially, we want to export a subset data from CLM 3.0 Atrium. For a given dataset, we want to export all classes attributes that exist in the BMC.CORE, BMC.AM, and possibly BMC.FED namespaces. Even when specifying a specific namespace to export, the resulting XML files still contain attributes that are provided by other namespaces. This subsequently causes imports to fail, since there is extra data. Thanks for the help! Jared _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
Merge Job
All � In order to save time, we have decided to load our new test servers with hundreds of thousands of assets through a direct SQL import from an earlier direct SQL export rather than through Atrium AI and the Reconciliation Engine.� We have figured out which tables had to be exported, have imported both the staging and production data using SQL, and all seems well after the import except for one detail. When we first run the Reconciliation Engine Job that pushes data from staging into production (needed when we incrementally add assets after the initial SQL import), every single asset imported initially through SQL is Merged, and of course this takes a very long time.� This was surprising because in the database from the SQL import, every asset in the staging dataset has ReconciliationMergeStatus=50 (Merge Done) and our Job does not Merge unchanged CIs.� I expected none of these assets to be included in a Merge.� Moreover, all of our SQL-imported assets had Reconciliation IDs and the Reconciliation Job did correctly skip the Identification Step. Does anyone know why we are seeing this behavior?� Is there another field on another form that controls why all of our records were merged even though ReconciliationMergeStatus=50. We are using 8.0 and oracle 11g. Thanks Atul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Merge Job
The recon job is probably simply merging all the CI’s that have been modified since it last ran. If you are running it for the first time it will pick up all CI’s. From your results it doesn’t look like the recon merge status is taking priority over the last run time but I’ve never played with this field so don’t really know what it’s supposed to do. You could try adding a qualification to the merge job to prevent it merging anything then, when it has finished, its last run time will be set. Then try removing the qualification and see what happens. Cheers Peter From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Atul Vohra Sent: 02 May 2013 21:01 To: arslist@ARSLIST.ORG Subject: Merge Job ** All In order to save time, we have decided to load our new test servers with hundreds of thousands of assets through a direct SQL import from an earlier direct SQL export rather than through Atrium AI and the Reconciliation Engine. We have figured out which tables had to be exported, have imported both the staging and production data using SQL, and all seems well after the import except for one detail. When we first run the Reconciliation Engine Job that pushes data from staging into production (needed when we incrementally add assets after the initial SQL import), every single asset imported initially through SQL is Merged, and of course this takes a very long time. This was surprising because in the database from the SQL import, every asset in the staging dataset has ReconciliationMergeStatus=50 (Merge Done) and our Job does not Merge unchanged CIs. I expected none of these assets to be included in a Merge. Moreover, all of our SQL-imported assets had Reconciliation IDs and the Reconciliation Job did correctly skip the Identification Step. Does anyone know why we are seeing this behavior? Is there another field on another form that controls why all of our records were merged even though ReconciliationMergeStatus=50. We are using 8.0 and oracle 11g. Thanks Atul _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: AR System ODBC driver
Sorry yes your right Fred, I meant that you CAN'T use dynamic joins (i.e. in the SQL) when using the OBDC driver. And as you pointed out you CAN'T see anything your userid is not supposed to see in the report. Using sub-reports is a real solution but it can be really really slow if a significant number of parent records are being processed. Use of the ODBC driver has significant benefits as it decodes many of the DB field values into nice things like dates and readable Strings for things such as Status. You can also test dates in your query without having to decode them to epoch values. Stuart Schon Service Desk Systems - Manager Fujitsu Australia Limited -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Thursday, 2 May 2013 11:42 PM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver I think Stuart had a typo ... Since the ODBC uses the Remedy application server, if you can't see something in Remedy you can't see it using the ODBC driver. One way around the join limitation is to use sub-reports in Crystal. You can then have multiple form(s) data in the report Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Schon, Stuart Sent: Wednesday, May 01, 2013 6:13 PM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver The main limitation is that you can perform joins in the query using the OBDC driver. If you need to join tables together you need to build them in Remedy first and then use in your report. The other restriction/feature is that the driver uses the Remedy data security model - so if you can't see something using Remedy you can't see it in a report. Stuart Schon Service Desk Systems - Manager Fujitsu Australia Limited Please consider the environment before printing this email -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Thursday, 2 May 2013 6:37 AM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver Thanks Fred. I'll check it out. Sent from my iPhone On May 1, 2013, at 4:36 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: The Integration Guide document (Page 212) lists some issues and considerations -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Wednesday, May 01, 2013 2:25 PM To: arslist@ARSLIST.ORG Subject: AR System ODBC driver ** Version: 7.6.04 All, Does anyone know or have a document about what capabilities are available for the AR System ODBC driver? I have a user who is trying to use Crystal Reports by way of the driver and some features aren't working. -- Tauf Chowdhury ___ 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: AR System ODBC driver
All, Thanks for the great info... So here is some info from my superuser who has exp with Crystal (and I don't). Do you guys know if these features are supported by the driver? Crystal in general supports all these functions: multi-value parameters, optional parameters, static/dynamic parameters, sub-reports, TSQL Commands... But what is supported with the AR System Driver, and do the normal steps in Crystal still apply to make the functionality still work? On Thu, May 2, 2013 at 7:58 PM, Schon, Stuart stuart.sc...@au.fujitsu.comwrote: Sorry yes your right Fred, I meant that you CAN'T use dynamic joins (i.e. in the SQL) when using the OBDC driver. And as you pointed out you CAN'T see anything your userid is not supposed to see in the report. Using sub-reports is a real solution but it can be really really slow if a significant number of parent records are being processed. Use of the ODBC driver has significant benefits as it decodes many of the DB field values into nice things like dates and readable Strings for things such as Status. You can also test dates in your query without having to decode them to epoch values. Stuart Schon Service Desk Systems - Manager Fujitsu Australia Limited -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Thursday, 2 May 2013 11:42 PM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver I think Stuart had a typo ... Since the ODBC uses the Remedy application server, if you can't see something in Remedy you can't see it using the ODBC driver. One way around the join limitation is to use sub-reports in Crystal. You can then have multiple form(s) data in the report Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Schon, Stuart Sent: Wednesday, May 01, 2013 6:13 PM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver The main limitation is that you can perform joins in the query using the OBDC driver. If you need to join tables together you need to build them in Remedy first and then use in your report. The other restriction/feature is that the driver uses the Remedy data security model - so if you can't see something using Remedy you can't see it in a report. Stuart Schon Service Desk Systems - Manager Fujitsu Australia Limited Please consider the environment before printing this email -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Thursday, 2 May 2013 6:37 AM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver Thanks Fred. I'll check it out. Sent from my iPhone On May 1, 2013, at 4:36 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: The Integration Guide document (Page 212) lists some issues and considerations -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Wednesday, May 01, 2013 2:25 PM To: arslist@ARSLIST.ORG Subject: AR System ODBC driver ** Version: 7.6.04 All, Does anyone know or have a document about what capabilities are available for the AR System ODBC driver? I have a user who is trying to use Crystal Reports by way of the driver and some features aren't working. -- Tauf Chowdhury ___ 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 -- *Tauf Chowdhury * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Upgrade ARS from 7603 to 7604 SP4
Short answer yes. Long answer would be what might be a recommended approach. 7.6.04 introduces the concept of overlays. There is no real benefit of upgrading the server platform itself to this new version if you do not intend to update ITSM to 7.6.04 and leverage the use of overlays. If you upgrade both the server and the ITSM app in a single project kind of an approach, you will be able to reap the benefits of overlays a lot more easily than otherwise by making use of the hash file that would create overlays of your already customized version of your ITSM applications. I'm guessing that this may get a little more complicated later - I haven't used that as yet so I cannot say that for sure, but this is my best guess... Cheers -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of RajaShanin Sent: Thursday, May 02, 2013 10:05 AM To: arslist@ARSLIST.ORG Subject: Upgrade ARS from 7603 to 7604 SP4 Hi I would like to know whether we can directly upgrade from ARS 7603 (hot fix version - FCS MWRT SW00401937) to ARS 7604 SP4 while ITSM remains in 7603? any known errors or compatibility issues between ARS 7604 SP4 and ITSM 7603? Thanks Raja ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: AR System ODBC driver
Almost everything in CR is usable. But do you want to do so. Things like dynamic parameters can make running the report very slow as lists of values need to queried from the table being referenced. For example if you are reporting on the Helpdesk form and you have a parameter based on Status that is pulled from the DB for selection by the person running the report-every record in the Helpdesk form will be read to determine the list. You cannot branch off and read this from another table. So if there are 10M records then CR will read all 10M to determine the definitive list of Statuses. If the report is being run externally from Remedy then Static Parameters (simple or list) can be used User enterable values can be used, e.g. Dates and date ranges Optional parameters (these default to Null which might not be what you want) Sub-reports - yes as already stated SQL Commands -yes but only tables and views and only one. It can't be a stored procedure or function or. If the report is embedded in Remedy then its tied to a form and about the only thing else that works is sub-reports. Especially you can get the CR to ask for parameters you need to get Remedy to do so which is used to pre-filter the data presented to the CR report. Get the guy to try things and he will get the idea of what is possible and what's not. Stuart Schon Service Desk Systems - Manager From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Friday, 3 May 2013 10:01 AM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver ** All, Thanks for the great info... So here is some info from my superuser who has exp with Crystal (and I don't). Do you guys know if these features are supported by the driver? Crystal in general supports all these functions: multi-value parameters, optional parameters, static/dynamic parameters, sub-reports, TSQL Commands... But what is supported with the AR System Driver, and do the normal steps in Crystal still apply to make the functionality still work? On Thu, May 2, 2013 at 7:58 PM, Schon, Stuart stuart.sc...@au.fujitsu.com wrote: Sorry yes your right Fred, I meant that you CAN'T use dynamic joins (i.e. in the SQL) when using the OBDC driver. And as you pointed out you CAN'T see anything your userid is not supposed to see in the report. Using sub-reports is a real solution but it can be really really slow if a significant number of parent records are being processed. Use of the ODBC driver has significant benefits as it decodes many of the DB field values into nice things like dates and readable Strings for things such as Status. You can also test dates in your query without having to decode them to epoch values. Stuart Schon Service Desk Systems - Manager Fujitsu Australia Limited -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Thursday, 2 May 2013 11:42 PM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver I think Stuart had a typo ... Since the ODBC uses the Remedy application server, if you can't see something in Remedy you can't see it using the ODBC driver. One way around the join limitation is to use sub-reports in Crystal. You can then have multiple form(s) data in the report Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Schon, Stuart Sent: Wednesday, May 01, 2013 6:13 PM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver The main limitation is that you can perform joins in the query using the OBDC driver. If you need to join tables together you need to build them in Remedy first and then use in your report. The other restriction/feature is that the driver uses the Remedy data security model - so if you can't see something using Remedy you can't see it in a report. Stuart Schon Service Desk Systems - Manager Fujitsu Australia Limited Please consider the environment before printing this email -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Thursday, 2 May 2013 6:37 AM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver Thanks Fred. I'll check it out. Sent from my iPhone On May 1, 2013, at 4:36 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: The Integration Guide document (Page 212) lists some issues and considerations -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Wednesday, May 01, 2013 2:25 PM To: arslist@ARSLIST.ORG Subject: AR System ODBC driver ** Version: 7.6.04 All, Does anyone know or have a document about what capabilities are available for the AR System ODBC driver? I have a user who is trying to use Crystal Reports by way of the driver and some
Re: AR System ODBC driver
Thanks Stuart! On Thu, May 2, 2013 at 8:35 PM, Schon, Stuart stuart.sc...@au.fujitsu.comwrote: ** Almost everything in CR is usable. But do you want to do so. Things like dynamic parameters can make running the report very slow as lists of values need to queried from the table being referenced. ** ** For example if you are reporting on the Helpdesk form and you have a parameter based on Status that is pulled from the DB for selection by the person running the report-every record in the Helpdesk form will be read to determine the list. You cannot branch off and read this from another table. So if there are 10M records then CR will read all 10M to determine the definitive list of Statuses. ** ** If the report is being run externally from Remedy then Static Parameters (simple or list) can be used User enterable values can be used, e.g. Dates and date ranges Optional parameters (these default to Null which might not be what you want) Sub-reports – yes as already stated SQL Commands –yes but only tables and views and only one. It can't be a stored procedure or function or….. ** ** If the report is embedded in Remedy then its tied to a form and about the only thing else that works is sub-reports. Especially you can get the CR to ask for parameters you need to get Remedy to do so which is used to pre-filter the data presented to the CR report. ** ** Get the guy to try things and he will get the idea of what is possible and what's not. ** ** ** ** *Stuart Schon Service Desk Systems - Manager * *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Tauf Chowdhury *Sent:* Friday, 3 May 2013 10:01 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: AR System ODBC driver ** ** ** All, Thanks for the great info... So here is some info from my superuser who has exp with Crystal (and I don't). Do you guys know if these features are supported by the driver? Crystal in general supports all these functions: multi-value parameters, optional parameters, static/dynamic parameters, sub-reports, TSQL Commands... But what is supported with the AR System Driver, and do the normal steps in Crystal still apply to make the functionality still work?* *** ** ** On Thu, May 2, 2013 at 7:58 PM, Schon, Stuart stuart.sc...@au.fujitsu.com wrote: Sorry yes your right Fred, I meant that you CAN'T use dynamic joins (i.e. in the SQL) when using the OBDC driver. And as you pointed out you CAN'T see anything your userid is not supposed to see in the report. Using sub-reports is a real solution but it can be really really slow if a significant number of parent records are being processed. Use of the ODBC driver has significant benefits as it decodes many of the DB field values into nice things like dates and readable Strings for things such as Status. You can also test dates in your query without having to decode them to epoch values. Stuart Schon Service Desk Systems - Manager Fujitsu Australia Limited -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Thursday, 2 May 2013 11:42 PM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver I think Stuart had a typo ... Since the ODBC uses the Remedy application server, if you can't see something in Remedy you can't see it using the ODBC driver. One way around the join limitation is to use sub-reports in Crystal. You can then have multiple form(s) data in the report Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Schon, Stuart Sent: Wednesday, May 01, 2013 6:13 PM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver The main limitation is that you can perform joins in the query using the OBDC driver. If you need to join tables together you need to build them in Remedy first and then use in your report. The other restriction/feature is that the driver uses the Remedy data security model - so if you can't see something using Remedy you can't see it in a report. Stuart Schon Service Desk Systems - Manager Fujitsu Australia Limited Please consider the environment before printing this email -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Thursday, 2 May 2013 6:37 AM To: arslist@ARSLIST.ORG Subject: Re: AR System ODBC driver Thanks Fred. I'll check it out. Sent from my iPhone On May 1, 2013, at 4:36 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: The Integration Guide document (Page 212) lists some issues and considerations -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On
Remedy Integration with SCOM
Hi, I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL server 2008 R2 . I need some help on steps required to integrate SCOM with BMC Remedy. Our requirement is like as follows : SCOM should raise an alert whenever any server goes down and then from that alert an incident should be created automatically in BMC Remedy with the information to be picked up from CMDB about that server. Our incident should autmatically populates the entire summary about that server(CI in atrium cmdb) . Is it possible ? Please share some steps or any dcoument if anyone has done that before. Thanks, Anup ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy Integration with SCOM
Microsoft provides some Remedy code with SCOM to handle the interface. I know, I helped them make it work. ;-) Rick On May 2, 2013 7:13 PM, Anup Garg anupgar...@gmail.com wrote: Hi, I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL server 2008 R2 . I need some help on steps required to integrate SCOM with BMC Remedy. Our requirement is like as follows : SCOM should raise an alert whenever any server goes down and then from that alert an incident should be created automatically in BMC Remedy with the information to be picked up from CMDB about that server. Our incident should autmatically populates the entire summary about that server(CI in atrium cmdb) . Is it possible ? Please share some steps or any dcoument if anyone has done that before. Thanks, Anup ___ 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 Integration with SCOM
We use the Microsoft integration to create Remedy incidents from SCOM 2007. We are in the process of upgrading SCOM to 2012 and microsoft no longer supports that connection. The new way is using Systems Center Orhestrater and run books utilizing a connector developed by Kelverion. I hear Kelverion is working on a similar API connector used by Microsoft and it will be more functional (not creating just tickets). Not sure if BAO can be used to integrate with SCOM.. On May 2, 2013 9:13 PM, Anup Garg anupgar...@gmail.com wrote: Hi, I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL server 2008 R2 . I need some help on steps required to integrate SCOM with BMC Remedy. Our requirement is like as follows : SCOM should raise an alert whenever any server goes down and then from that alert an incident should be created automatically in BMC Remedy with the information to be picked up from CMDB about that server. Our incident should autmatically populates the entire summary about that server(CI in atrium cmdb) . Is it possible ? Please share some steps or any dcoument if anyone has done that before. Thanks, Anup ___ 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 Integration with SCOM
It seemed as though the new MS app, formerly known as Opalis, was similar in its build interface to the Remedy Abydos designer. I would think there would be a CLI/API connection that would work. Rick On May 2, 2013 7:36 PM, Saji Philip sphili...@gmail.com wrote: ** We use the Microsoft integration to create Remedy incidents from SCOM 2007. We are in the process of upgrading SCOM to 2012 and microsoft no longer supports that connection. The new way is using Systems Center Orhestrater and run books utilizing a connector developed by Kelverion. I hear Kelverion is working on a similar API connector used by Microsoft and it will be more functional (not creating just tickets). Not sure if BAO can be used to integrate with SCOM.. On May 2, 2013 9:13 PM, Anup Garg anupgar...@gmail.com wrote: Hi, I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL server 2008 R2 . I need some help on steps required to integrate SCOM with BMC Remedy. Our requirement is like as follows : SCOM should raise an alert whenever any server goes down and then from that alert an incident should be created automatically in BMC Remedy with the information to be picked up from CMDB about that server. Our incident should autmatically populates the entire summary about that server(CI in atrium cmdb) . Is it possible ? Please share some steps or any dcoument if anyone has done that before. Thanks, Anup ___ 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy Integration with SCOM
Hi Rick ,Saji, If I start learning system center orchestrater, then how should I start and from where should I learn about it as I have no prior knowledge on orchestrator or on System center. Do you have any kind of documentation which would help me understand this type of integration. Even I read soemwhere that Using orchestrator would be best option for these type of integrations. Rick, Have you done it without using orchestrator? On Fri, May 3, 2013 at 8:15 AM, Rick Cook remedyr...@gmail.com wrote: ** It seemed as though the new MS app, formerly known as Opalis, was similar in its build interface to the Remedy Abydos designer. I would think there would be a CLI/API connection that would work. Rick On May 2, 2013 7:36 PM, Saji Philip sphili...@gmail.com wrote: ** We use the Microsoft integration to create Remedy incidents from SCOM 2007. We are in the process of upgrading SCOM to 2012 and microsoft no longer supports that connection. The new way is using Systems Center Orhestrater and run books utilizing a connector developed by Kelverion. I hear Kelverion is working on a similar API connector used by Microsoft and it will be more functional (not creating just tickets). Not sure if BAO can be used to integrate with SCOM.. On May 2, 2013 9:13 PM, Anup Garg anupgar...@gmail.com wrote: Hi, I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL server 2008 R2 . I need some help on steps required to integrate SCOM with BMC Remedy. Our requirement is like as follows : SCOM should raise an alert whenever any server goes down and then from that alert an incident should be created automatically in BMC Remedy with the information to be picked up from CMDB about that server. Our incident should autmatically populates the entire summary about that server(CI in atrium cmdb) . Is it possible ? Please share some steps or any dcoument if anyone has done that before. Thanks, Anup ___ 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: Remedy Integration with SCOM
I have built a couple of simple things in the Opalis Orchestrator, but that was a few years ago. I would do some digging on Microsoft's website to get more current information. Rick On May 2, 2013 7:54 PM, vivek garg anupgar...@gmail.com wrote: ** Hi Rick ,Saji, If I start learning system center orchestrater, then how should I start and from where should I learn about it as I have no prior knowledge on orchestrator or on System center. Do you have any kind of documentation which would help me understand this type of integration. Even I read soemwhere that Using orchestrator would be best option for these type of integrations. Rick, Have you done it without using orchestrator? On Fri, May 3, 2013 at 8:15 AM, Rick Cook remedyr...@gmail.com wrote: ** It seemed as though the new MS app, formerly known as Opalis, was similar in its build interface to the Remedy Abydos designer. I would think there would be a CLI/API connection that would work. Rick On May 2, 2013 7:36 PM, Saji Philip sphili...@gmail.com wrote: ** We use the Microsoft integration to create Remedy incidents from SCOM 2007. We are in the process of upgrading SCOM to 2012 and microsoft no longer supports that connection. The new way is using Systems Center Orhestrater and run books utilizing a connector developed by Kelverion. I hear Kelverion is working on a similar API connector used by Microsoft and it will be more functional (not creating just tickets). Not sure if BAO can be used to integrate with SCOM.. On May 2, 2013 9:13 PM, Anup Garg anupgar...@gmail.com wrote: Hi, I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL server 2008 R2 . I need some help on steps required to integrate SCOM with BMC Remedy. Our requirement is like as follows : SCOM should raise an alert whenever any server goes down and then from that alert an incident should be created automatically in BMC Remedy with the information to be picked up from CMDB about that server. Our incident should autmatically populates the entire summary about that server(CI in atrium cmdb) . Is it possible ? Please share some steps or any dcoument if anyone has done that before. Thanks, Anup ___ 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_ _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 Integration with SCOM
I have documentation from Kelverion I can forward to you. Systems Center Orhestrator was formerly called Opalis. If your running Microsoft you should already own it. Theres quite a few documantation on Orhestrator on the Microsoft website. Just send me your contact info to 'sphili...@hotmail.com' On May 2, 2013 9:58 PM, Rick Cook remedyr...@gmail.com wrote: ** I have built a couple of simple things in the Opalis Orchestrator, but that was a few years ago. I would do some digging on Microsoft's website to get more current information. Rick On May 2, 2013 7:54 PM, vivek garg anupgar...@gmail.com wrote: ** Hi Rick ,Saji, If I start learning system center orchestrater, then how should I start and from where should I learn about it as I have no prior knowledge on orchestrator or on System center. Do you have any kind of documentation which would help me understand this type of integration. Even I read soemwhere that Using orchestrator would be best option for these type of integrations. Rick, Have you done it without using orchestrator? On Fri, May 3, 2013 at 8:15 AM, Rick Cook remedyr...@gmail.com wrote: ** It seemed as though the new MS app, formerly known as Opalis, was similar in its build interface to the Remedy Abydos designer. I would think there would be a CLI/API connection that would work. Rick On May 2, 2013 7:36 PM, Saji Philip sphili...@gmail.com wrote: ** We use the Microsoft integration to create Remedy incidents from SCOM 2007. We are in the process of upgrading SCOM to 2012 and microsoft no longer supports that connection. The new way is using Systems Center Orhestrater and run books utilizing a connector developed by Kelverion. I hear Kelverion is working on a similar API connector used by Microsoft and it will be more functional (not creating just tickets). Not sure if BAO can be used to integrate with SCOM.. On May 2, 2013 9:13 PM, Anup Garg anupgar...@gmail.com wrote: Hi, I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL server 2008 R2 . I need some help on steps required to integrate SCOM with BMC Remedy. Our requirement is like as follows : SCOM should raise an alert whenever any server goes down and then from that alert an incident should be created automatically in BMC Remedy with the information to be picked up from CMDB about that server. Our incident should autmatically populates the entire summary about that server(CI in atrium cmdb) . Is it possible ? Please share some steps or any dcoument if anyone has done that before. Thanks, Anup ___ 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_ _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: Extracting substring from string and putting the value in different field
Hi, I have created 2 forms 1 display only form containing a field(desc) to store string INC000123, INC000456, INC000789, INC05 ,a temp field(temp) and another regular form to store the incident tickets. 1.Created alink Alink1 with actions a.Set desc=$default$ b.Set temp=STRSTR($desc$, ,) c.callguide AlinkGuide AlinkGuide: 1. Label Start 2. Call alink Alink2 if 'temp' != -1 i. Push in form 2 incno= SUBSTR($desc$, 0, $temp$ - 1) ii.Set desc=SUBSTR($desc$, $temp$ + 1, LENGTH($desc$)) iii. Go to guide label Start. else i.Go to guide label End. 3. Label End d.Pushfield in form 2 incno=desc Thanks and Regard, Sagar Valse On Thu, May 2, 2013 at 7:53 PM, jayesh panchal jhpancha...@gmail.comwrote: ** Have you tried using LEFTC function in set field action???.it will extract substrings and u can set into different field. Regards Jayesh On May 2, 2013 6:05 PM, sanjay kanhu.san...@gmail.com wrote: Hello Lister's, We have a requirement. Where we have a string which contains incident id's separated by ,. And my requirement is to extract the individual incident from the string and put the value to separate field. Example of the above requirement == Input == TMP_field =INC000123, INC000456, INC000789, INC05 Output === Felid1 = INC000123 Felid2 = INC000456 Felid3 = INC000789 Felid4 = INC05 and my question is how do I accomplish the above task. Please help me out to accomplish the above requirement. Many thanks for all your suggestion and help in advance. Regards, Sanjay. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy Integration with SCOM
Hi Anup, You can install integration from below link: http://blogs.technet.com/b/kevinholman/archive/2010/09/23/installing-the-opsmgr-r2-universal-connector.aspx It has a link to download the connector for SCOM 2007 R2 for BMC Remedy ARS. It also has instructions for integration and configuration. Hope this helps. On Fri, May 3, 2013 at 7:43 AM, Anup Garg anupgar...@gmail.com wrote: Hi, I am working on bmc remedy version 7.6.04 SP2 on windows 2008 R2 and SQL server 2008 R2 . I need some help on steps required to integrate SCOM with BMC Remedy. Our requirement is like as follows : SCOM should raise an alert whenever any server goes down and then from that alert an incident should be created automatically in BMC Remedy with the information to be picked up from CMDB about that server. Our incident should autmatically populates the entire summary about that server(CI in atrium cmdb) . Is it possible ? Please share some steps or any dcoument if anyone has done that before. Thanks, Anup ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years -- Regards, Onkar Shinde Senior Software Engineer Vyom Labs Pvt. Ltd. BSM Solutions Services || ITIL Consulting Training Telephone: +91-20-6632-1000 Mobile: +91-7709008719 Email: onkar.shi...@vyomlabs.com Web: www.vyomlabs.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years