Re: Application-Query-Delete-Entry
Hi, I did my PTT (Performance Tuning Troubleshooting class) in 1998, and had an argument with the teacher. I produced some log files to prove my case during class, but she refused to accept that as proof, and I gave up ;-) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. That shatters a long standing understanding I had about data driven escalations. I had received this info at a Remedy training facility in Bracknell in UK years ago, that you ought to help Escalations with Filters triggered off modifications by the Escalation User in processing 2nd and 3rd stage actions. I guess they were wrong when they instructed us so then.. That is one of the benefit that they explained of having Filters running with a Run If of $USER$ = AR_ESCALATOR AND whatever else the rest of the qualification may be.. The other benefit I'm guessing (I wasn’t told this but it makes sense) is if you need to override filter phasing during the run of an escalation.. Joe -Original Message- From: Misi Mladoniczky Sent: Saturday, December 10, 2011 4:04 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Application-Query-Delete-Entry Hi, Filters triggered by an Escalation, either via Set-Fields or Push-Fields, will ALWAYS be run in the same thread. This has ALWAYS been the case. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Now that you remind me, I actually remember discussing this once with you.. I'll really need to log the workflow to see what thread processes the filter workflow when filters are executed triggered by the AR_ESCALATOR user. I was told this in a performance tuning class years ago (version 4.0 - 4.5 days so probably 11 or 12 years ago) that you let escalations perform first stage actions, and leave any 2nd and 3rd stage actions (deletes, push fields, notifications) to be performed by filters that are run using the admin thread. Maybe the design was different back then? So this is obsolete now? I wish I had a server to verify this :-) Joe -Original Message- From: LJ LongWing Sent: Thursday, December 08, 2011 2:18 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Application-Query-Delete-Entry Joe, I know this discussion comes up every once in awhilebut you and I seem to differ in our opinions of how it works. So...based on your statement below, having the escalation set a field, and having a filter fire on that field being set, then performing the delete will be 'faster' because of a 'fire and forget' type of mechanism? I would argue that an action of delete within the escalation, and a setfield causing a filter to fire that causes the delete are 'the same', in that the escalation thread does not 'go onto the next record' till after the filters on the current record are done...so, in essence, the performance of either action would be the same and the escalation thread would still be tied up for exactly the same amount of time regardless At least, that's my understanding :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Thursday, December 08, 2011 11:33 AM To: arslist@ARSLIST.ORG Subject: Re: Application-Query-Delete-Entry End Date as Linda pointed out should be a field on that form you are searching for, represented by 'End Date' in the qualification and not $End Date$.. That being said, LJ's suggestion is right.. The qualification should be in the Run If of the Escalation and the run process should be Application-Delete-Entry $SCHEMA$ $Request ID$ Having an Escalation with no Run If instructs it to be run over the entire data table. You do not want to do that in case you have like a million or more records in it.. It may probably hang the escalation thread waiting for it to complete.. Also a faster way to do it would be to 'mark that entry for deletion' using a tag on a field created for that. This would mean that the Escalation would do a single update to that table which is a faster operation that multiple deletes and be done with it.. Create a filter that runs if the $USER$ is AR_ESCALATOR and the flag for delete is set, to delete that entry. So on a fairly large set of data, although the deletes
Java API Help - SelectionFieldLimit
LJ, If you use the constructor or set method that takes an array of Strings, you get a regular list. If you use the constructor or set method that takes a list of EnumItems, you get a custom list. I'll leave it to you for feedback on how obvious this seems :-) John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Commit Changes vs PERFORM ACTION APPLY
Hi, I definitely vote for Commit Changes! Why use the ugly Run-Process bla bla bla syntax, when you have an action that does the same thing? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. That's a good question Mark. I'm not aware of any differences that would make one more efficient than the other. Personally I prefer to use the Commit Changes as it seems cleaner to use this rather than one of many run process commands. Rod Harris On 9 December 2011 04:51, Brittain, Mark mbritt...@navisite.com wrote: ** HI All, ** ** Commit Changes vs. PERFORM ACTION APPLY. Is one better to use than the other on ARS 6.3? ** ** I have one active link that populates data from a SQL query and a second active link to commit the changes. These were probably created under ARS 3 or 4. The Commit Changes does the job but always looking to smart way to do things. ** ** Thanks Mark ** ** *Mark Brittain* Remedy Developer *NaviSite – **A Time Warner Cable Company* mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 ** ** -- 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. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Java API Help - SelectionFieldLimit
The last line... really? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Baker Sent: 12 December 2011 08:31 To: arslist@ARSLIST.ORG Subject: Java API Help - SelectionFieldLimit LJ, If you use the constructor or set method that takes an array of Strings, you get a regular list. If you use the constructor or set method that takes a list of EnumItems, you get a custom list. I'll leave it to you for feedback on how obvious this seems :-) John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Java API Help - StructItemInfo
I find a good strategy sometimes is to locate the corresponding item in the C API as it's usually better documented. In this case, it seems these are used when you are importing or exporting VUIs (type = VUI) or mail templates (type = MAIL), and they allow you to specify the specific VUI or mail template you want to import/export for the schema named in the name field. So unless you are dealing with VUIs or mail templates you can probably ignore them. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: BMC Analytics
Thanks to Tauf and Rick! Appreciate all the info! From: Chowdhury, Tauf tauf.chowdh...@frx.com To: arslist@ARSLIST.ORG Date: 12/09/2011 05:05 PM Subject:Re: BMC Analytics Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** Christine, Analytics really isn’t a “Remedy module.” It’s basically a “custom” universe created by BMC based on the Remedy data model on the Business Objects platform. So I think the training that would be helpful is to first understand how Remedy data is structured within the DB. For example, knowing that Remedy “Forms” are views within the DB etc… Second, if you needed training on using Business Objects, I’m sure there are classes out there that will help you get an understanding of how to use Business Objects both from a Universe Designer perspective and also the end user “InfoView” perspective. This will assist in helping you then take that Remedy DB knowledge and work with the ITSM Universe within Analytics to customize or just use it. Business Objects is owned by SAP so perhaps they have specific training on the Designer and Infoview that is independent of what the universe actually is. Hope that makes sense. :) -Tauf From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Christine Milton Hall Sent: Friday, December 09, 2011 4:58 PM To: arslist@ARSLIST.ORG Subject: BMC Analytics ** Hi everyone... Sorry to bug you all again... Does anyone know where I can get training for Analytics? thanks! c ** This e-mail and any files transmitted with it may contain confidential information and is intended solely for use by the individual to whom it is addressed. If you received this e-mail in error, please notify the sender, do not disclose its contents to others and delete it from your system. ** _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ** This e-mail and any files transmitted with it may contain confidential information and is intended solely for use by the individual to whom it is addressed. If you received this e-mail in error, please notify the sender, do not disclose its contents to others and delete it from your system. ** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: graycol.gif
Re: Commit Changes vs PERFORM ACTION APPLY
Yeah Misi, I'm a bit surprised that the run process commands have grown so much faster than the actions. I guess it's quicker to develop features as Run Process commands rather than have dev studio hold our hand and check the syntax and context on entry. I know that it wouldn't be practical to expect every run process to be implemented as an action but for some of the very common ones it would make a lot of sense. A business time command would be nice. The syntax on those process commands is darn tricky even for experts. The other thing that has surprised me is that the odd `! naming convention for overriding filter phasing has survived all these years. Surely it would be much nicer to have a simple check box field or something to indicate this. It would be easy enough to phase out the old method over time and just auto set the new check box if the name ended in `! I'm not a fan of the mechanics of a piece of code featuring in the name. I think it should describe what it does rather than how it does it. If you change how it does it then you have to change its name also. In Remedy since the name of an active link or filter etc. is the key you have a problem with version control if you keep changing the names of things. If you leave the name the same despite changing how things are done then your naming convention becomes compromised. There's a lot I love about Remedy and it does keep getting better but I'd like it if these couple of things were improved. Rod Harris On 12 December 2011 16:32, Misi Mladoniczky m...@rrr.se wrote: Hi, I definitely vote for Commit Changes! Why use the ugly Run-Process bla bla bla syntax, when you have an action that does the same thing? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. That's a good question Mark. I'm not aware of any differences that would make one more efficient than the other. Personally I prefer to use the Commit Changes as it seems cleaner to use this rather than one of many run process commands. Rod Harris On 9 December 2011 04:51, Brittain, Mark mbritt...@navisite.com wrote: ** HI All, ** ** Commit Changes vs. PERFORM ACTION APPLY. Is one better to use than the other on ARS 6.3? ** ** I have one active link that populates data from a SQL query and a second active link to commit the changes. These were probably created under ARS 3 or 4. The Commit Changes does the job but always looking to smart way to do things. ** ** Thanks Mark ** ** *Mark Brittain* Remedy Developer *NaviSite – **A Time Warner Cable Company* mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 ** ** -- 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. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Incident Management reports
First let me thank everyone for their feedback on the first 2 emails.. Now for the next piece of the question. If I can find data in a search, to me that means that the data exists in the database already. Would there be any reason that fields would be required to be added to a form or the DB if data can be found in a search (such as date and time stamps for Assigned and Resolved)? thanks! c ** This e-mail and any files transmitted with it may contain confidential information and is intended solely for use by the individual to whom it is addressed. If you received this e-mail in error, please notify the sender, do not disclose its contents to others and delete it from your system. ** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Application-Query-Delete-Entry
I doubt too many instructors would be taking you on in argument about Remedy these days Misi. They'd have to be game!! One thing I'd like to add is that all other things being equal I think the query version of delete entry should be a fair bit faster for bulk deletes. I think if you do have a bunch of records tagged to delete that the first match could delete all the other ones in the one go. I doubt this would be as fast as a database level delete as you still have the app server overhead and the potential to run Delete filters on each delete but I think it would be faster than doing a modify and delete on each match. I still prefer the control that putting all the logic in the one place - filters gives. If you use escalations for just identifying data that needs attention then it makes it easier to develop accurate maintainable bug free code. Rod Harris On 12 December 2011 16:23, Misi Mladoniczky m...@rrr.se wrote: Hi, I did my PTT (Performance Tuning Troubleshooting class) in 1998, and had an argument with the teacher. I produced some log files to prove my case during class, but she refused to accept that as proof, and I gave up ;-) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. That shatters a long standing understanding I had about data driven escalations. I had received this info at a Remedy training facility in Bracknell in UK years ago, that you ought to help Escalations with Filters triggered off modifications by the Escalation User in processing 2nd and 3rd stage actions. I guess they were wrong when they instructed us so then.. That is one of the benefit that they explained of having Filters running with a Run If of $USER$ = AR_ESCALATOR AND whatever else the rest of the qualification may be.. The other benefit I'm guessing (I wasn’t told this but it makes sense) is if you need to override filter phasing during the run of an escalation.. Joe -Original Message- From: Misi Mladoniczky Sent: Saturday, December 10, 2011 4:04 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Application-Query-Delete-Entry Hi, Filters triggered by an Escalation, either via Set-Fields or Push-Fields, will ALWAYS be run in the same thread. This has ALWAYS been the case. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se . Now that you remind me, I actually remember discussing this once with you.. I'll really need to log the workflow to see what thread processes the filter workflow when filters are executed triggered by the AR_ESCALATOR user. I was told this in a performance tuning class years ago (version 4.0 - 4.5 days so probably 11 or 12 years ago) that you let escalations perform first stage actions, and leave any 2nd and 3rd stage actions (deletes, push fields, notifications) to be performed by filters that are run using the admin thread. Maybe the design was different back then? So this is obsolete now? I wish I had a server to verify this :-) Joe -Original Message- From: LJ LongWing Sent: Thursday, December 08, 2011 2:18 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Application-Query-Delete-Entry Joe, I know this discussion comes up every once in awhilebut you and I seem to differ in our opinions of how it works. So...based on your statement below, having the escalation set a field, and having a filter fire on that field being set, then performing the delete will be 'faster' because of a 'fire and forget' type of mechanism? I would argue that an action of delete within the escalation, and a setfield causing a filter to fire that causes the delete are 'the same', in that the escalation thread does not 'go onto the next record' till after the filters on the current record are done...so, in essence, the performance of either action would be the same and the escalation thread would still be tied up for exactly the same amount of time regardless At least, that's my understanding :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Thursday, December 08, 2011 11:33 AM To: arslist@ARSLIST.ORG Subject: Re:
Re: Application-Query-Delete-Entry
Hi, I have doe quite some testing with deleting entries. The problem with Application-Query-Delete-Entry is that it is treated as ONE database transaction. That means that the database needs to be able to roll back the delet, and copies everything to a transaction-space or something like that. This all makes it choke, if it is too many records. Even deleting 100 records at a time may be a problem if you have big attachments. I suggest that you use Application-Delete-Entry directly from your escalation. If you want to delete child records, create a filter executing on Delete, that calls Application-Query-Delete-Entry. This is the place where I have found that function useful. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I doubt too many instructors would be taking you on in argument about Remedy these days Misi. They'd have to be game!! One thing I'd like to add is that all other things being equal I think the query version of delete entry should be a fair bit faster for bulk deletes. I think if you do have a bunch of records tagged to delete that the first match could delete all the other ones in the one go. I doubt this would be as fast as a database level delete as you still have the app server overhead and the potential to run Delete filters on each delete but I think it would be faster than doing a modify and delete on each match. I still prefer the control that putting all the logic in the one place - filters gives. If you use escalations for just identifying data that needs attention then it makes it easier to develop accurate maintainable bug free code. Rod Harris On 12 December 2011 16:23, Misi Mladoniczky m...@rrr.se wrote: Hi, I did my PTT (Performance Tuning Troubleshooting class) in 1998, and had an argument with the teacher. I produced some log files to prove my case during class, but she refused to accept that as proof, and I gave up ;-) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. That shatters a long standing understanding I had about data driven escalations. I had received this info at a Remedy training facility in Bracknell in UK years ago, that you ought to help Escalations with Filters triggered off modifications by the Escalation User in processing 2nd and 3rd stage actions. I guess they were wrong when they instructed us so then.. That is one of the benefit that they explained of having Filters running with a Run If of $USER$ = AR_ESCALATOR AND whatever else the rest of the qualification may be.. The other benefit I'm guessing (I wasn’t told this but it makes sense) is if you need to override filter phasing during the run of an escalation.. Joe -Original Message- From: Misi Mladoniczky Sent: Saturday, December 10, 2011 4:04 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Application-Query-Delete-Entry Hi, Filters triggered by an Escalation, either via Set-Fields or Push-Fields, will ALWAYS be run in the same thread. This has ALWAYS been the case. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se . Now that you remind me, I actually remember discussing this once with you.. I'll really need to log the workflow to see what thread processes the filter workflow when filters are executed triggered by the AR_ESCALATOR user. I was told this in a performance tuning class years ago (version 4.0 - 4.5 days so probably 11 or 12 years ago) that you let escalations perform first stage actions, and leave any 2nd and 3rd stage actions (deletes, push fields, notifications) to be performed by filters that are run using the admin thread. Maybe the design was different back then? So this is obsolete now? I wish I had a server to verify this :-) Joe -Original Message- From: LJ LongWing Sent: Thursday, December 08, 2011 2:18 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Application-Query-Delete-Entry Joe, I know
Re: Application-Query-Delete-Entry
Thanks Misi, you are a founatin of knowledge and I guess that makes sense. It would be one database transaction and everything would need to be rolled back if it failed. I've used it to delete several hundred temporary rows at a time no problem and it is faster than running several hundred updates. I think if, as you say, you need to update maybe thousands of rows it might become a bit impractical. Might be safer in most instances to go the scalable approach and use the individual delete entry. Of course there are times when it is best to do all the deletes as one transaction as in my situation where a bunch of temporary rows were created and then deleted soon after. Makes sense not to leave any mess behind if there is a problem and by skipping the modify actions you're saving a bit of time and reducing the risk of some unintended cascading modify. (I've seen a bug caused by this in a recent version of well known Remedy app). Most of the time the individual delete is probably the right way to go and have it tiggered by a simple escalation and (whilst still using one thread) split each delete into a separate transaction. Each deleted row should have a delete filter to delete children. Would you then think deleting children by a query delete or push fields update would be the way to go? Either way the delete children would be combined into one transaction. Rod Harris On 12 December 2011 21:42, Misi Mladoniczky m...@rrr.se wrote: Hi, I have doe quite some testing with deleting entries. The problem with Application-Query-Delete-Entry is that it is treated as ONE database transaction. That means that the database needs to be able to roll back the delet, and copies everything to a transaction-space or something like that. This all makes it choke, if it is too many records. Even deleting 100 records at a time may be a problem if you have big attachments. I suggest that you use Application-Delete-Entry directly from your escalation. If you want to delete child records, create a filter executing on Delete, that calls Application-Query-Delete-Entry. This is the place where I have found that function useful. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I doubt too many instructors would be taking you on in argument about Remedy these days Misi. They'd have to be game!! One thing I'd like to add is that all other things being equal I think the query version of delete entry should be a fair bit faster for bulk deletes. I think if you do have a bunch of records tagged to delete that the first match could delete all the other ones in the one go. I doubt this would be as fast as a database level delete as you still have the app server overhead and the potential to run Delete filters on each delete but I think it would be faster than doing a modify and delete on each match. I still prefer the control that putting all the logic in the one place - filters gives. If you use escalations for just identifying data that needs attention then it makes it easier to develop accurate maintainable bug free code. Rod Harris On 12 December 2011 16:23, Misi Mladoniczky m...@rrr.se wrote: Hi, I did my PTT (Performance Tuning Troubleshooting class) in 1998, and had an argument with the teacher. I produced some log files to prove my case during class, but she refused to accept that as proof, and I gave up ;-) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. That shatters a long standing understanding I had about data driven escalations. I had received this info at a Remedy training facility in Bracknell in UK years ago, that you ought to help Escalations with Filters triggered off modifications by the Escalation User in processing 2nd and 3rd stage actions. I guess they were wrong when they instructed us so then.. That is one of the benefit that they explained of having Filters running with a Run If of $USER$ = AR_ESCALATOR AND whatever else the rest of the qualification may be.. The other benefit I'm guessing (I wasn’t told this but it makes sense) is if you need to override filter phasing during the run of an escalation.. Joe -Original Message- From: Misi Mladoniczky Sent: Saturday, December 10, 2011 4:04 AM Newsgroups:
Re: Application-Query-Delete-Entry
Hi, If your children is to be deletet, I think that a Application-Query-Delete-Entry call would be the cleanest way to go. If the child does not want to be deleted, it can send an Error. If you do a push, the database will be updated, and the modify-filters will run, which seems unnecessary. If you do it in two steps (with an additional child-form-escalation), the delete will not be contained within one transaction. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Thanks Misi, you are a founatin of knowledge and I guess that makes sense. It would be one database transaction and everything would need to be rolled back if it failed. I've used it to delete several hundred temporary rows at a time no problem and it is faster than running several hundred updates. I think if, as you say, you need to update maybe thousands of rows it might become a bit impractical. Might be safer in most instances to go the scalable approach and use the individual delete entry. Of course there are times when it is best to do all the deletes as one transaction as in my situation where a bunch of temporary rows were created and then deleted soon after. Makes sense not to leave any mess behind if there is a problem and by skipping the modify actions you're saving a bit of time and reducing the risk of some unintended cascading modify. (I've seen a bug caused by this in a recent version of well known Remedy app). Most of the time the individual delete is probably the right way to go and have it tiggered by a simple escalation and (whilst still using one thread) split each delete into a separate transaction. Each deleted row should have a delete filter to delete children. Would you then think deleting children by a query delete or push fields update would be the way to go? Either way the delete children would be combined into one transaction. Rod Harris On 12 December 2011 21:42, Misi Mladoniczky m...@rrr.se wrote: Hi, I have doe quite some testing with deleting entries. The problem with Application-Query-Delete-Entry is that it is treated as ONE database transaction. That means that the database needs to be able to roll back the delet, and copies everything to a transaction-space or something like that. This all makes it choke, if it is too many records. Even deleting 100 records at a time may be a problem if you have big attachments. I suggest that you use Application-Delete-Entry directly from your escalation. If you want to delete child records, create a filter executing on Delete, that calls Application-Query-Delete-Entry. This is the place where I have found that function useful. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. I doubt too many instructors would be taking you on in argument about Remedy these days Misi. They'd have to be game!! One thing I'd like to add is that all other things being equal I think the query version of delete entry should be a fair bit faster for bulk deletes. I think if you do have a bunch of records tagged to delete that the first match could delete all the other ones in the one go. I doubt this would be as fast as a database level delete as you still have the app server overhead and the potential to run Delete filters on each delete but I think it would be faster than doing a modify and delete on each match. I still prefer the control that putting all the logic in the one place - filters gives. If you use escalations for just identifying data that needs attention then it makes it easier to develop accurate maintainable bug free code. Rod Harris On 12 December 2011 16:23, Misi Mladoniczky m...@rrr.se wrote: Hi, I did my PTT (Performance Tuning Troubleshooting class) in 1998, and had an argument with the teacher. I produced some log files to prove my case during class, but she refused to accept that as proof, and I gave up ;-) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. That shatters a long standing understanding I had about
Re: Incident Management reports
Not all fields were loaded in to Analytics Universe. You will need to add them and then export your changes back in to the Universe. I would recommend getting training on setting up permissions and adding fields to the Universe as will as learning on how to create reports. As a Crystal report writer I have found that doing things in Analytics is not the same as in Crystal do to the fact that BMC or SAP has made Analytics a drag and drop application. In Analytics you must keep your thinking simple. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail Christine Milton Hall christine_milton_h...@pepperidgefarm.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 12/12/2011 08:24 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Incident Management reports ** First let me thank everyone for their feedback on the first 2 emails.. Now for the next piece of the question. If I can find data in a search, to me that means that the data exists in the database already. Would there be any reason that fields would be required to be added to a form or the DB if data can be found in a search (such as date and time stamps for Assigned and Resolved)? thanks! c __ This email has been scanned by the Symantec Email Security.cloud service. __ ** This e-mail and any files transmitted with it may contain confidential information and is intended solely for use by the individual to whom it is addressed. If you received this e-mail in error, please notify the sender, do not disclose its contents to others and delete it from your system. ** _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Java API Help - SelectionFieldLimit
LJ, If you looked up the meaning of snide, you'd find the following definition: Malicious, derogatory, counterfeit, sham. Clearly, stating it's not obvious - which it isn't, given you've asked the question and come to the same conclusion - is entirely reasonable. I made time to help you and avoid you wasting any more of your time. And I spent 20 minutes on Sunday looking at your previous question, too. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Mid Tier 7.6.4 SP2 browser issues
Good morning folks, I wanted to post this to see if anyone has any ideas as well as a warning for those that haven't yet applied 7.6.4 SP2. What we are running into is random slowness and eventual locking up of our browsers while accessing ITSM 7.6.4 SP2. Some people occasionally see the locking up occurring on the Overview Console, others see it happening in Asset Management. At one point, even just changing the dataset via the menu on the Asset Management console (and we only have a handful of datasets) would cause the browser to lock up to where you had to kill it via Task Manager. Right now I'm consistently running into it when I open the search of RKM via an Incident, but it will probably work fine later on. We've applied a few hotfixes from BMC to both AR Server and the Mid Tier, and we've done some performance tuning of Tomcat which also hasn't really helped. BMC Support is looking into it, but I'm losing hope since after a grueling webex session on Friday I got an email this morning to generate all the logs again and send them off to BMC support. I'm dealing with someone pretty good at BMC, but she has to work with BMC's engineering department and I think they must be swamped trying to clean up all the defects in their code. Our environment is: AR Server OS: Windows Server 2008 R2 Mid Tier OS: Windows Server 2008 R2 Web Server: Apache Tomcat 6 running on Port 80 Database: SQL Server 2005 Browsers: Internet Explorer 8, Internet Explorer 9, and Firefox 8.0.1 Thanks, Shawn Pierson Remedy Developer | Southern Union Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Commit Changes vs PERFORM ACTION APPLY
I had put in a RFE back in 2010 to change the `! into a Phase Override radio button, but it was closed. I had suggested the radio button/dropdown so we could override the phase in all directions (I can see times where we would want a filter to run in Phase 4, such as if we have to push to on outside system after all processing is complete on a record) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rod Harris Sent: Monday, December 12, 2011 7:14 AM To: arslist@ARSLIST.ORG Subject: Re: Commit Changes vs PERFORM ACTION APPLY ** Yeah Misi, I'm a bit surprised that the run process commands have grown so much faster than the actions. I guess it's quicker to develop features as Run Process commands rather than have dev studio hold our hand and check the syntax and context on entry. I know that it wouldn't be practical to expect every run process to be implemented as an action but for some of the very common ones it would make a lot of sense. A business time command would be nice. The syntax on those process commands is darn tricky even for experts. The other thing that has surprised me is that the odd `! naming convention for overriding filter phasing has survived all these years. Surely it would be much nicer to have a simple check box field or something to indicate this. It would be easy enough to phase out the old method over time and just auto set the new check box if the name ended in `! I'm not a fan of the mechanics of a piece of code featuring in the name. I think it should describe what it does rather than how it does it. If you change how it does it then you have to change its name also. In Remedy since the name of an active link or filter etc. is the key you have a problem with version control if you keep changing the names of things. If you leave the name the same despite changing how things are done then your naming convention becomes compromised. There's a lot I love about Remedy and it does keep getting better but I'd like it if these couple of things were improved. Rod Harris -Original Message- On 12 December 2011 16:32, Misi Mladoniczky wrote: Hi, I definitely vote for Commit Changes! Why use the ugly Run-Process bla bla bla syntax, when you have an action that does the same thing? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. -Original Message- That's a good question Mark. I'm not aware of any differences that would make one more efficient than the other. Personally I prefer to use the Commit Changes as it seems cleaner to use this rather than one of many run process commands. Rod Harris -Original Message- On 9 December 2011 04:51, Brittain, Mark wrote: HI All, Commit Changes vs. PERFORM ACTION APPLY. Is one better to use than the other on ARS 6.3? I have one active link that populates data from a SQL query and a second active link to commit the changes. These were probably created under ARS 3 or 4. The Commit Changes does the job but always looking to smart way to do things. Thanks Mark *Mark Brittain* Remedy Developer *NaviSite - **A Time Warner Cable Company* mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 ** ** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Mid Tier 7.6.4 SP2 browser issues
Shawn Have you ruled out the JVM running out of memory, or run away threads? Can I suggest you take a look at JVisualVM. Run it against your test instance and see if you can replicate the problem through usage. Or jconsole, which is a bit less intrusive, against your production instance - both have pretty graphs to monitor heap/threads, and the former allows you to drill down and send a profile to BMC (have they asked for one?). http://www.javasystemsolutions.com/jss/video/view/MidTier-JMX http://www.javasystemsolutions.com/jss/video/view/MidTier-JVisualVM This won't give you the answer, but it may give you some idea of where to look. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Mid Tier 7.6.4 SP2 browser issues
Have you guys looked at setting a value for the Max Get List? If it's set to 0, you may be waiting a long time for queries to execute and return values and it in turn can present itself as a mid tier performance issue. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Monday, December 12, 2011 10:22 AM To: arslist@ARSLIST.ORG Subject: Mid Tier 7.6.4 SP2 browser issues ** Good morning folks, I wanted to post this to see if anyone has any ideas as well as a warning for those that haven't yet applied 7.6.4 SP2. What we are running into is random slowness and eventual locking up of our browsers while accessing ITSM 7.6.4 SP2. Some people occasionally see the locking up occurring on the Overview Console, others see it happening in Asset Management. At one point, even just changing the dataset via the menu on the Asset Management console (and we only have a handful of datasets) would cause the browser to lock up to where you had to kill it via Task Manager. Right now I'm consistently running into it when I open the search of RKM via an Incident, but it will probably work fine later on. We've applied a few hotfixes from BMC to both AR Server and the Mid Tier, and we've done some performance tuning of Tomcat which also hasn't really helped. BMC Support is looking into it, but I'm losing hope since after a grueling webex session on Friday I got an email this morning to generate all the logs again and send them off to BMC support. I'm dealing with someone pretty good at BMC, but she has to work with BMC's engineering department and I think they must be swamped trying to clean up all the defects in their code. Our environment is: AR Server OS: Windows Server 2008 R2 Mid Tier OS: Windows Server 2008 R2 Web Server: Apache Tomcat 6 running on Port 80 Database: SQL Server 2005 Browsers: Internet Explorer 8, Internet Explorer 9, and Firefox 8.0.1 Thanks, Shawn Pierson Remedy Developer | Southern Union Private and confidential as detailed here http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access hyperlink, please e-mail sender. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Mid Tier 7.6.4 SP2 browser issues
I've sent BMC the output of dumpthreads.jsp which I assume displays enough data to see whether it is a memory issue or not. Fortunately we are running into this problem with our pre-production 7.6.4 and development 7.6.4 environments, so even though it is costing us money in terms of my contractors and I working on BMC defects which have delayed our implementation by more than a month, at least we aren't in production with critical defects like this yet. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Baker Sent: Monday, December 12, 2011 9:49 AM To: arslist@ARSLIST.ORG Subject: Mid Tier 7.6.4 SP2 browser issues Shawn Have you ruled out the JVM running out of memory, or run away threads? Can I suggest you take a look at JVisualVM. Run it against your test instance and see if you can replicate the problem through usage. Or jconsole, which is a bit less intrusive, against your production instance - both have pretty graphs to monitor heap/threads, and the former allows you to drill down and send a profile to BMC (have they asked for one?). http://www.javasystemsolutions.com/jss/video/view/MidTier-JMX http://www.javasystemsolutions.com/jss/video/view/MidTier-JVisualVM This won't give you the answer, but it may give you some idea of where to look. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: xMatters / AlarmPoint
We purchased/installed xMatters/Alarmpoint 4.1 and ITSM Helpdesk Integration 2.2, with mixed results. Current status: Alarmpoint *notification node* [their term] is functioning as their marketing data claims, providing manually-triggered two-way traffic (notification by server, response by user). Full details of this step alone are extensive, and I can continue this point off-line (will be lengthy!). The commissioning process was non-trivial, and required steps beyond those claimed in their documentation. This notification node is very hardware-specific, while other components which can initiate notification actions are more general (Windows, Linux, and others). Notification-node response to integration agents has been more involved and less successful. ITSM Integration has been partially successful, with significant data fields which *should* be handled by the notification node remaining un-populated even after their consultant visited us on-site. Again, I can supply more details in a lengthy discourse, probably taken off-line. xMatters' Change Management integration was also acquired by us, and not yet implemented. We wanted to see full functionality from Help Desk before committing further effort. Bottom line: their consultant was here on-site in September, and accepted two action items which have not been completed as of today [12 Dec 2011]. One of those action items was a specific 'how-to' for tracing the data fields mentioned above. Three followup contacts have not produced resolution on these items; the latest contact was a conference call with their account rep, tech rep, and a customer-service ombudsman. One xMatters rep also told us that the integration mechanism is being completely redesigned. The latest information I had from their account rep is that most customers should expect to purchase xMatters professional services for initial installation and commissioning--at additional cost beyond quoted purchase price to customer, of course. Such initial effort is expected to take two to three weeks for notification node function and *one* application integration (such as BMC Help Desk). My administration would probably not have approved expenditure for this system, in light of the 'consultancy' expectation. Initial presentation of this system to us was as a customer-installable, commissionable environment--which has not been completely realized. Any list reader is welcome to contact me directly for further details. Don W. McClure, P.E. CITC Call Tracking Administration University of North Texas dwmac @ unt . edu From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Palla Sent: Monday, December 12, 2011 11:47 AM To: arslist@ARSLIST.ORG Subject: xMatters / AlarmPoint ** Is anyone using BMCs xMatters or the old AlarmPoint in conjunction with Remedy? Can you offer-up any perceptions, pros/cons, cautions? How would you rate the product for value-added? Thanks; R Ray Palla Sr. IT/Remedy Consultant [cid:image001.jpg@01CCB8C5.465167F0] [cid:image002.jpg@01CCB8C5.465167F0] Mobile: 512-917-1739 Time Zone: Central Email: ray.pa...@insona.commailto:ray.pa...@insona.com [cid:image003.gif@01CCB8C5.465167F0] Professional Profilehttp://www.linkedin.com/pub/1/544/598 INSONA Corporation http://www.insona.com/1201 Berry Lane http://maps.google.com/maps?q=10650+SW+Plaza+CT%2CBox%3A+J68%2CHouston%2CTX+77074%2CUSAhl=enGeorgetown, TX 78626-3832 USA Infrastructure Solutions - Network Applications _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: image001.jpginline: image002.jpginline: image003.gif
Re: Notfications are going to people in a group even if their staus is 'Deleted' in people form..
I do not believe those fields are taken into consideration when sending a notification using the Notify action in a Filter. I know that the ITSM suite does look at Notification Availablility. If you are sending the notifiaction to a group and do not want certain users to receive that notification then remove them from the support group. On 12/12/11, Vikram_Betholi betholi.vik...@gmail.com wrote: I have written a filter to send the noification to the respective group by selecting the Notify action.But this notifiation is even sent to the people with 'Deleted' status in People form, who were partof the Group earlier.I have even updated the NOtification Availability as 'NO' to them in the people form.How to take care of this issue? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: xMatters / AlarmPoint
Ray, I think the answer depends on what your looking for. I have found that xMatters (not owned by BMC although they resell the product) can do a lot. Sales folks will even have you think you can't live without it. In my opinion many of the items that are controlled through xMatters should be done else where. We have tech folks make themselves available and control their notifications within the AR System. Yes one can also respond to a ticket through xMatters yet one can do that through MidTier as well (except from an iDevice but some day soon maybe). We use TelAlert for our text messaging from the AR System and other apps. Dave From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Palla Sent: Monday, December 12, 2011 12:47 PM To: arslist@ARSLIST.ORG Subject: xMatters / AlarmPoint ** Is anyone using BMCs xMatters or the old AlarmPoint in conjunction with Remedy? Can you offer-up any perceptions, pros/cons, cautions? How would you rate the product for value-added? Thanks; R Ray Palla Sr. IT/Remedy Consultant [http://www.linkedin.com/img/signature/bg_bluefade_195x42.jpg] [cid:460402018@12122011-08FF] Mobile: 512-917-1739 Time Zone: Central Email: ray.pa...@insona.commailto:ray.pa...@insona.com [http://www.linkedin.com/img/signature/icon_in_blue_14x14.gif] Professional Profilehttp://www.linkedin.com/pub/1/544/598 INSONA Corporation http://www.insona.com/1201 Berry Lane http://maps.google.com/maps?q=10650+SW+Plaza+CT%2CBox%3A+J68%2CHouston%2CTX+77074%2CUSAhl=enGeorgetown, TX 78626-3832 USA Infrastructure Solutions - Network Applications _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: bg_bluefade_195x42.jpginline: INSONA-Logo.jpginline: icon_in_blue_14x14.gif
Purge Script
My organization has elected to not use archiving for the last year and we have now run into a space issue. I have been tasked with backing up and purging a large volume of rows from the ITSM tables. Has anyone had to do this and if so be willing to share a script? My fear is that relationships to Audit or Work Info or other will be missed and orphaned resulting in further headaches. Thanks in advance! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Commit Changes vs PERFORM ACTION APPLY
While you'll brought out this idea, if at all BMC ever intends to change the way this works along the lines of your ideas, it would be even cooler if they changed it in such a way that you could control the specific phase you would like each action within a filter to run after you check that check box to override default phasing.. options like Default to let the action run on the default phase, Phase 1, Phase 2 etc for every action in that Filter so you could choose what action you would like the override.. That would probably add a lot more control than just saying - ok all actions run on phase 1 with the `! convention.. Joe -Original Message- From: Grooms, Frederick W Sent: Monday, December 12, 2011 10:40 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Commit Changes vs PERFORM ACTION APPLY I had put in a RFE back in 2010 to change the `! into a Phase Override radio button, but it was closed. I had suggested the radio button/dropdown so we could override the phase in all directions (I can see times where we would want a filter to run in Phase 4, such as if we have to push to on outside system after all processing is complete on a record) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rod Harris Sent: Monday, December 12, 2011 7:14 AM To: arslist@ARSLIST.ORG Subject: Re: Commit Changes vs PERFORM ACTION APPLY ** Yeah Misi, I'm a bit surprised that the run process commands have grown so much faster than the actions. I guess it's quicker to develop features as Run Process commands rather than have dev studio hold our hand and check the syntax and context on entry. I know that it wouldn't be practical to expect every run process to be implemented as an action but for some of the very common ones it would make a lot of sense. A business time command would be nice. The syntax on those process commands is darn tricky even for experts. The other thing that has surprised me is that the odd `! naming convention for overriding filter phasing has survived all these years. Surely it would be much nicer to have a simple check box field or something to indicate this. It would be easy enough to phase out the old method over time and just auto set the new check box if the name ended in `! I'm not a fan of the mechanics of a piece of code featuring in the name. I think it should describe what it does rather than how it does it. If you change how it does it then you have to change its name also. In Remedy since the name of an active link or filter etc. is the key you have a problem with version control if you keep changing the names of things. If you leave the name the same despite changing how things are done then your naming convention becomes compromised. There's a lot I love about Remedy and it does keep getting better but I'd like it if these couple of things were improved. Rod Harris -Original Message- On 12 December 2011 16:32, Misi Mladoniczky wrote: Hi, I definitely vote for Commit Changes! Why use the ugly Run-Process bla bla bla syntax, when you have an action that does the same thing? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. -Original Message- That's a good question Mark. I'm not aware of any differences that would make one more efficient than the other. Personally I prefer to use the Commit Changes as it seems cleaner to use this rather than one of many run process commands. Rod Harris -Original Message- On 9 December 2011 04:51, Brittain, Mark wrote: HI All, Commit Changes vs. PERFORM ACTION APPLY. Is one better to use than the other on ARS 6.3? I have one active link that populates data from a SQL query and a second active link to commit the changes. These were probably created under ARS 3 or 4. The Commit Changes does the job but always looking to smart way to do things. Thanks Mark *Mark Brittain* Remedy Developer *NaviSite - **A Time Warner Cable Company* mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 ** ** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Purge Script
Best to do from Archive form properties of desired forms, e.g. purging data using form property archiving from HPD_Help_Desk will also clean up related associated data due to built in filter workflow on DELETE. Do you means archive - i.e. to another form or db, or purge the old data? Attached is a script for sql server for you to be able to cut and paste into excel to determine largest tables. (just remove the ' kb' references to sort correctly. If you haven't already, there are some system forms that get huge that are no brainers for cleanup, e.g. - AR System Email Messages - NTE:Notifier - NTE:Notifier Logs Also if on ITSM 7.5+ consider whether you need people CI data as, that version and above will automatically add a person CI for every CTM:People record - if you're in a large enterprise, that can added up. If you don't need it and it is taking up valuable space then you set a reconciliation job to delete them. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matthew Moellmer Sent: Monday, December 12, 2011 12:50 PM To: arslist@ARSLIST.ORG Subject: Purge Script My organization has elected to not use archiving for the last year and we have now run into a space issue. I have been tasked with backing up and purging a large volume of rows from the ITSM tables. Has anyone had to do this and if so be willing to share a script? My fear is that relationships to Audit or Work Info or other will be missed and orphaned resulting in further headaches. Thanks in advance! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are table-space-used.sql Description: table-space-used.sql
Re: Purge Script
Alternately you can also delete obsolete records from table, export table data, truncate table and import back the data, in that order to free up unused blocks used by large tables in Oracle.. This would perhaps be quicker if you have large number of tables you wish to perform that exercise on. Joe -Original Message- From: Andrew C Goodall Sent: Monday, December 12, 2011 2:51 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Purge Script Best to do from Archive form properties of desired forms, e.g. purging data using form property archiving from HPD_Help_Desk will also clean up related associated data due to built in filter workflow on DELETE. Do you means archive - i.e. to another form or db, or purge the old data? Attached is a script for sql server for you to be able to cut and paste into excel to determine largest tables. (just remove the ' kb' references to sort correctly. If you haven't already, there are some system forms that get huge that are no brainers for cleanup, e.g. - AR System Email Messages - NTE:Notifier - NTE:Notifier Logs Also if on ITSM 7.5+ consider whether you need people CI data as, that version and above will automatically add a person CI for every CTM:People record - if you're in a large enterprise, that can added up. If you don't need it and it is taking up valuable space then you set a reconciliation job to delete them. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matthew Moellmer Sent: Monday, December 12, 2011 12:50 PM To: arslist@ARSLIST.ORG Subject: Purge Script My organization has elected to not use archiving for the last year and we have now run into a space issue. I have been tasked with backing up and purging a large volume of rows from the ITSM tables. Has anyone had to do this and if so be willing to share a script? My fear is that relationships to Audit or Work Info or other will be missed and orphaned resulting in further headaches. Thanks in advance! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
[7.6.04] Upgrade didn't move OOTB forms to the new server
Hi everyone, Someone could explain the Best way for upgrade of AR Server to version 7.6.04 ? Our scenario is upgrade from 7.0.01 to 7.6.04 ... We did the upgrade of our server, but, in this case, the process didn't bring to the new Server the related data (arx) and workflow objects from OOTB applications that we have. What could've happened during the installation? Could I export def's from our AR Admin 7.0.01 and import those using the new BMC Remedy Developer without concerns about relationships and future upgrades? P.S.: I don't feel comfortable to import/export all the forms, actives, filters, etc (def files) and all the arx files as well (including arx files for forms like as User, Group that didn't go to the new server). Thankz Tadeu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Java API Help - SelectionFieldLimit
John, I then apologize...sarcasm is extremely difficult to pick up in this medium. Going back and re-reading your post, I can read it in a different frame of mind and see that were was no malicious or derogatory intent :) Thank you for the time you spent helping a fellow lister...it allows me to build my code to create 'regular' lists :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Baker Sent: Monday, December 12, 2011 8:09 AM To: arslist@ARSLIST.ORG Subject: Java API Help - SelectionFieldLimit LJ, If you looked up the meaning of snide, you'd find the following definition: Malicious, derogatory, counterfeit, sham. Clearly, stating it's not obvious - which it isn't, given you've asked the question and come to the same conclusion - is entirely reasonable. I made time to help you and avoid you wasting any more of your time. And I spent 20 minutes on Sunday looking at your previous question, too. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Notfications are going to people in a group even if their staus is 'Deleted' in people form..
Instead of the Notify action, push the message through the Notification Sub-system (NTE). Thanks Mahesh On Mon, Dec 12, 2011 at 12:00 PM, Vikram_Betholi betholi.vik...@gmail.comwrote: I have written a filter to send the noification to the respective group by selecting the Notify action.But this notifiation is even sent to the people with 'Deleted' status in People form, who were partof the Group earlier.I have even updated the NOtification Availability as 'NO' to them in the people form.How to take care of this issue? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Server name clarification
Hi all, I'm finally back to working on my disaster recovery server configuration, after a six month diversion for other projects. Having never worked in an environment where the Remedy server name was different than the host name, and after some intial reading, I had a couple of configuration questions that I figure the arslist could clarify the fastest. My current understanding of the following ar.conf settings (please correct anything that needs it): Server-Name: - The name that remedy knows itself by, and which users would use to connect to the system. - Must be DNS-resolvable. - In a server group, all servers in the group have this set to the same value. - It is the value returned by the $\SERVER$ keyword (that's a guess...?) Server-Connect-Name: - The actual host name of the server that Remedy lives on. - Must also be DNS-resolvable. - In a server group, each server will have its individual host name configured here. Questions: Which of the above values are used for AR paths in the file system. Directories for things like the email engine, AIE, and /etc/arsystem/servername all have the server name in them. Do those represent the Server-Name or the host name? Email engine configuration (EmailDaemon.properties): Same question, which value is used? Thinking through this, it would make the most sense that all those settings would use the Server-Name, not the host-name? If that's not true, what are the exceptions? I'm sure I'll have more questions (IP-Name and Map-IP-Address look fun), but these are the ones pestering me now. Thanks in advance Thad ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Moving ARServer being Firewall and new server
Hello List, Our environment is: ARServer: 7.5.00 Patch 004 (2-installation) MT Server: 7.5.00 Patch 004 AR Server OS: AIX 6.1 Mid Tier OS: AIX 6.1 Web Server: Websphere 6.1 Database: Oracle 10 g Browsers: Internet Explorer 8, Internet Explorer 9, and Firefox 8.0.1 TCD-Specific-Port: 0 Oracle is local to Arserver. New environment ( on ArServer OS AIX 6.1.6) BigIp -- 2HttpServers --2websphereApp-- (FW)---Arserver WUT --(FW) -- Arsever We had moved our test environment to new server from a shared environment (with DR). So we tar and lay it down, and that was port mapped. Question: On the test environment, if I change the TCD-Specific-Port: XX to TCD-Specific-Port: 0, will it default to udp 111, what TCP range will return? Other than midtier/WUT configuration, is there anywhere we will need to remove port. Basically, UN-portmapping test to mirror production. Question: Behind firewall, is it more recommended set a TCD-Specific-Port? Per the documentation, all connections will used the assigned port, true? also, what will the load and performance impact? I know this will impact WUT users which is a small population of 350 - whom will need to start going to MT with client being retired. Question: We are exploring the idea of doing a fresh installation of 7.5.00 Patch 004, then import the schemas/def (customer shop) from production, then import the data. This way we can install all the components of 7.5x, that we will be using going forward. Is this a good method? Basically, this new server aix 6.1.6, will be a test environment which will move to prod. We will change to database port and server alias. So, when we move to production, can we move back to old alias? Any help, and direction will be appreciated! Thank you, ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Notfications are going to people in a group even if their staus is 'Deleted' in people form..
If you are using the Group email id (Distribution list) in the filter notification, then check if the deleted user's email id is still part of the DL, we had similar concern in where user was receiving emails even after being removed from a support group/remedy. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Moving ARServer being Firewall and new server
Behind a firewall, you HAVE to specify a specific port that has been configured by the firewall admins to be allowed on the network.. If you default it to 0, it tells the AR Server to use a default available port on the server, and you would require to enable your port mapper and remove the server from behind the firewall in order for the server to accept connections from the clients.. Hope that answers your questions.. Joe From: DEE Sent: Monday, December 12, 2011 9:36 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Moving ARServer being Firewall and new server ** Hello List, Our environment is: ARServer: 7.5.00 Patch 004 (2-installation) MT Server: 7.5.00 Patch 004 AR Server OS: AIX 6.1 Mid Tier OS: AIX 6.1 Web Server: Websphere 6.1 Database: Oracle 10 g Browsers: Internet Explorer 8, Internet Explorer 9, and Firefox 8.0.1 TCD-Specific-Port: 0 Oracle is local to Arserver. New environment ( on ArServer OS AIX 6.1.6) BigIp -- 2HttpServers --2websphereApp-- (FW)---Arserver WUT --(FW) -- Arsever We had moved our test environment to new server from a shared environment (with DR). So we tar and lay it down, and that was port mapped. Question: On the test environment, if I change the TCD-Specific-Port: XX to TCD-Specific-Port: 0, will it default to udp 111, what TCP range will return? Other than midtier/WUT configuration, is there anywhere we will need to remove port. Basically, UN-portmapping test to mirror production. Question: Behind firewall, is it more recommended set a TCD-Specific-Port? Per the documentation, all connections will used the assigned port, true? also, what will the load and performance impact? I know this will impact WUT users which is a small population of 350 - whom will need to start going to MT with client being retired. Question: We are exploring the idea of doing a fresh installation of 7.5.00 Patch 004, then import the schemas/def (customer shop) from production, then import the data. This way we can install all the components of 7.5x, that we will be using going forward. Is this a good method? Basically, this new server aix 6.1.6, will be a test environment which will move to prod. We will change to database port and server alias. So, when we move to production, can we move back to old alias? Any help, and direction will be appreciated! Thank you, _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are