Re: Namesake Views
This is what we do. We just re-create the AR view into a custom view and manage it manually from that point forward. For example, HPD_HELP_DESK would have a stable version called REPORTING__HPD_HELP_DESK (just be careful you don't exceed the maximum length of view names in your DB). It's very easy to setup if you just copy/paste the view SQL and rename the name in the statement. I had wanted to investigate triggers to regrant on CREATE VIEW statements, but never got around to it. -Patrick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Wednesday, January 22, 2014 2:55 PM To: arslist@ARSLIST.ORG Subject: Re: Namesake Views ** Mark, The way we combated this particular issue was to actually create a new db view, one that is defined specifically for your purposes, and is not re-created after every form change. On Wed, Jan 22, 2014 at 12:38 PM, Brittain, Mark mbritt...@navisite.commailto:mbritt...@navisite.com wrote: ** HI All, The move from 6.3 (custom) to 7.6 ITSM always seems to have more surprises than I care to sustain. Anyway, I have a monitoring tool that queries the hpd_help_desk view. The monitoring tool is granted permission to the view using the command grant select on aradmin.hpd_help_desk to monitoringtool; Before today I did not know about these namesake views. Last night I added a field to the HPD:HelpD Desk and this query broke. Apparently there is a script that runs, deletes rather than updates the view and builds a new view. The result is any grants assigned to the view are wiped out. After that monitoring tool could not query the view and the DatabaseError: ORA-00942: table or view does not exist was being returned. One solution would be to grant the permission the monitoring tool anytime the view is rebuilt. Not my favorite approach. Has anyone run into this and come up with a better solution? ARS 7.6.04 ITSM 7.6.04 Oracle 11 Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation, Continual Service Improvement NaviSite, Inc. - A Time Warner Cable Company mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315.634.9337tel:315.634.9337 Mobile: 315.882.5360tel:315.882.5360 [navsig] This E-mail and any of its attachments may contain Time Warner Cable proprietary information, which is privileged, confidential, or subject to copyright belonging to Time Warner Cable. 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, 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. _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 inline: image001.gif
Re: work log search
Are you using ITSM? If so, there is usually an Advanced Search function in the left navigation bar on the consoles or directly in the ticket search/modify views. It lets you do this type of search pretty easily. -Patrick -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Young Sent: Thursday, November 07, 2013 12:23 PM To: arslist@ARSLIST.ORG Subject: work log search Question for you all. Is there a way I can set something up to say... go into a work log (diary field) and search for a word or phrase and then spit out a report? ___ 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: LIKE operation on a display-only character field is failing
Hard to tell without seeing the whole XML doc, but don't you need to wrap % signs on both sides? I.e.: 'XML Data' LIKE %COMMENTS% Another option might be to do a substring match and then test the result. -Patrick | -Original Message- | From: Action Request System discussion list(ARSList) | [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Westbrock | Sent: May 1, 2013 02:41 PM | To: arslist@ARSLIST.ORG | Subject: LIKE operation on a display-only character field is failing | | Listers- | | For some reason I am having a very tough time with an active link | qualification. I am using a display-only form with display fields to parse | the contents of an XML data file into discreet fields to push to a regular | form. The basic process is to use the XML tags to isolate the data in each | element and do a set fields to a display field on the form, then strip the | XML element (tags and data) from the front of the string and proceed to the | next element. I am walking a table to loop through all the elements. | | My problem is that any given record in the XML data may have zero to many | Comments. There is an opening tag COMMENTS that will show there is at | least one comment but if there are no comments then it will have a | COMMENTS/ tag instead. I have an active link that looks at the string and | decides whether or not to call the guide for parsing out the comments but | the qualification is not working at all. | | I first tried to test for the existence of the opening tag with this | qualification where XML Data is the character field (size 0) that holds the | contents of the XML file: 'XML Data' LIKE COMMENTS% | | However even when I can see that a previous active link set fields has set | the XML Data field to a string that starts with COMMENTS this | qualification fails. I tried to go the other way by using 'XML Data' LIKE | COMMENTS/% (the tag which indicates no comments are present) and NOT | 'XML Data' LIKE COMMENTS% but no matter what I try the qualification | always fails. | | Am I missing something obvious about the way a LIKE operation works on a | character field in an active link? I found documentation that it may not | work properly when comparing to the database value of an unlimited character | field but this is just a display field on a display-only staging form. Any | suggestions would be greatly appreciated. Below is a screen shot of the data | field at the time the qualification is evaluated: | | | | AR 7.6.04 SP2, custom application | Windows Server 2008 | MS-SQL Server 2008 | | -Rick | | ___ | Rick Westbrock | QMX Support Services | | | | | ___ | 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: Whats with the Classification field labels in 8.1
It has been like that since at least ITSM 7.0. I'm guessing it is related to aesthetics as you mention. -Patrick | -Original Message- | From: Action Request System discussion list(ARSList) | [mailto:arslist@ARSLIST.ORG] On Behalf Of SUBSCRIBE ARSLIST theReel | Sent: March 27, 2013 10:13 AM | To: arslist@ARSLIST.ORG | Subject: Whats with the Classification field labels in 8.1 | | Hi Guys, | | Time to let off some steam. | Just having a look a the classification tab that has been added to the Best | Practice View of Incidents in 8.1. | For the Operational Categorization Tier 1 - 3 and Product categorization | Tier 1-3 fields the display labels of the fields have been hidden behind | other fields and then separate text fields added where the labels would have | normaly been. | | Does anyone have any idea why on earth this has been done and why the labels | are not visible as normal? | The product Name, Model, Manufacture labels are all laid out as normal. | | This will affect users when they try to do an avanced search and click on | the field label expecting it to be added to the search bar but it will not | work. | | Also this highlights a bug of mine and many of my users - the name of the | actual field is ''Product Categorization Tier 1 but the label is Tier 1. | Which means when users unfamilar with the field names try to do a search, | report, filter or look in the audit log they cant find the fields they want | as the labels are different. My favourite one is the Problem coordinator | field which shows up as the Assignee Pblm Mgr in the audit log. | | As I write/rant I think I know why it has been done in the incident form - | it is for asthectic reasons - i.e it doesnt look pretty having a list of | long labels: | Product Categorization Tier 1 | Product Categorization Tier 2 | Product Categorization Tier 3 | It might not look pretty but at least the usability would have been better! | Why not shorten to Product Cat Tier 1. | | I notice in the change module they have named the fields Tier 1 - 3. But | then most things seem to be done differently accross the modules. eg. how | the customer is selected is wildly different in Incident and change. | | Note to any BMC readers: | Please try to keep labels, Db names and visble labels the same Please get | the change/incident/problem teams to look at the other modules and keep them | some way similar at least in the end users eyes. | | And breathe. Sorry about that folks, I just had to get it off my chest. | | Tony | | | ___ | UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers | Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: LogIn ID
Or, if you are using ITSM 7.6+ then you have access to the Data Wizard which you can use to change the Login ID throughout the system (works on many other fields too). -Patrick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brien Dieterle Sent: December 2, 2011 06:22 PM To: arslist@ARSLIST.ORG Subject: Re: LogIn ID ** Misi makes a great tool called LoginConv that can scour multiple fields in all forms the do the translation. http://www.rrr.se Brien On 12/2/2011 4:13 PM, Mike Hocks wrote: Hello Everyone, I am wondering if there is a way to change the Login ID on the user record in a Remedy 7.6.04 environment, for example we use part of the employees first and last name in the Remedy Login ID (The Remedy User Account is defined by the Active Directory account) when an employee's name changes we need to reflect this on the Remedy people record Login ID. Is there a way to safely do this? Thanks, -Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Developer Studio 7.6.04 Form View Resize.
You have to use panels that will auto-expand (set to Fill). Make sure that if you have any nested panels that all are set to fill. Sometimes I find that I need to reset the layout to XY, resize the object DOWN a little bit (save) and the reset back to FILL. There's a bug in there somewhere, and that's the only way I've been able to resolve this issue when panels are not auto-expanding even if they are set to FILL. -Patrick -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of uday kiran Sent: June 8, 2011 1:41 PM To: arslist@ARSLIST.ORG Subject: Developer Studio 7.6.04 Form View Resize. Hi Experts, My client is facing an issue with Form Size in Web browser, He created a view for the my services portal and that view is displaying extra spaces in the browser window how to troubleshoot that , I tried with form layout XY and Fill Options but dint get any clue. Thanks In Advance Kiran ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Midtier 7.6.4
Probably stating the obvious, but have you cleared browser and mid-tier cache after the upgrade? I've seen some of these errors on occasion if I haven't flushed my local browser cache after a code change. -Patrick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: June 7, 2011 6:39 PM To: arslist@ARSLIST.ORG Subject: Midtier 7.6.4 We just updated to Midtier 7.6.4 from 7.5 p4 (we are still on AR Server 7.5 p4). Is anyone else experiencing this? (see below) I'm getting a Caught exception:Object doesn't support this Property or method. When I got rid of the Close Window Action (in an Active Link), this error went away. I'm also getting a Caugh exception:Permission denied error when a PERFORM-ACTION-EXIT-APP action is performed. I haven't gotten rid of that action, but I bet when I do, I won't see this error anymore. Of course this wasn't happening with 7.5 p4 Lisa Kemes AR System Developer TE Information Systems Global Infrastructure and Ops +01 717 810 2408 tel +01 717 602 9460 mobile lisa.ke...@te.com MS 161-43 P.O. Box 3608 Harrisburg, PA 17105-3608 http://www.te.com/ www.te.com http://www.te.com/ http://twitter.com/teconnectivity http://www.facebook.com/teconnectivity http://www.flickr.com/photos/teconnectivity/ http://www.linkedin.com/groups?gid=1591657 http://www.youtube.com/teconnectivity _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are image001.gifimage007.jpgimage008.jpgimage009.jpgimage010.jpgimage011.jpg
Re: MidTier 7.6.4 Cache Setting
We have had problems in the past where flushing/syncing does not work completely In that case we had to shutdown Apache Tomcat and then manually clear the cache directory (%appdir%/midtier/cache). Good luck. -Patrick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pargeter, Christie :CO IS Sent: June 3, 2011 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: MidTier 7.6.4 Cache Setting I had tried flushing syncing and neither seemed to work. But the Dev Cache mode did. But it is making me wonder what people have for their MidTier settings for Production on 7.6.4 versions. Thanks From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Friday, June 03, 2011 6:48 AM To: arslist@ARSLIST.ORG Subject: Re: MidTier 7.6.4 Cache Setting ** There is also the Sync Cache button which would be much faster than doing a full cache flush. On Fri, Jun 3, 2011 at 8:53 AM, David Durling durl...@uga.edu wrote: Dev cache mode might be the thing. Otherwise, you could manually Flush Cache on the Cache Settings page in the Mid Tier Configuration Tool. David Durling University of Georgia -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pargeter, Christie :CO IS Sent: Thursday, June 02, 2011 6:26 PM To: arslist@ARSLIST.ORG Subject: Re: MidTier 7.6.4 Cache Setting No, I did not. I just started that and rebooted the server. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: Thursday, June 02, 2011 3:17 PM To: arslist@ARSLIST.ORG Subject: Re: MidTier 7.6.4 Cache Setting Do you have the developer cache mode turned on as well? On Jun 2, 5:12 pm, Pargeter, Christie :CO IS cparg...@lhs.org wrote: Hi All - I have recently built an ARS 7.6.4 environment and when I change some code (active links or form definitions) I can't seem to make my Dev MidTier server to see the changes. I have to wait over an hour to see these changes. What do people have for the Cache settings? I am currently at Definition Change Check: 0 Seconds Perform Check: Yes Update Flashboard Definitions: 86400 seconds Resource Check: 86400 seconds Enabled Cache Persistence: Unchecked What should I change so I can actually see my changes within a timely manner? ARS 7.6.4 MidTier 7.6.4 IIS 7.5 Tomcat 6.0.20 Windows 2008 64 Bit Christie Pargeter Legacy Health IS - Programming SR Technical Analyst cparge...@lhs.org 1120 Building tel: 503-415-5149 __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug11www.wwrug.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Remedy Log analizer
Personally, I like this one the best: http://communities.bmc.com/communities/docs/DOC-2973 Not sure if it works in 7.1 or greater, though. I use it on 7.01 all of the time. Very fast and it provides great reports. -Patrick From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pavan Kumar Sent: Thursday, April 01, 2010 4:39 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Log analizer Many thanks Frederick. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Thursday, April 01, 2010 2:25 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Log analizer On BMCDN http://communities.bmc.com/communities/docs/DOC-6036 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pavan Kumar Sent: Wednesday, March 31, 2010 1:53 PM To: arslist@ARSLIST.ORG Subject: Remedy Log analizer ** Hi All, I heard there is a tool to analyze the AR system log, can some one please share if you have. Thanks Regards, Pavan Kumar _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Oracle sizing guidelines
Good day, I'm trying to find some guidelines on Oracle 10g sizing for 7.x w/ITSM but all I can find from BMC are guidelines for BSM. Should I assume that it applies? We are concerned that our DB hasn't been spec'd correctly and I would like to give some best practices sizing guidelines to the DBA team. Patrick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Filter logging during import
Hello there, Having a hard time troubleshooting an issue while using arimportcmd (automated imports). It's complaining about a field being reset to NULL on a push action, but I can't figure out why it's happening. Is there any way to enable logging during import? Server side filter/sql logging doesn't show me anything. Many thanks, Patrick Shelston ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Remedy Support Site - Fixed?
Title: RE: Remedy Support Site - Fixed? ** I found that the site works best with Firefox for now (previously, Firefox didnt work at all). Patrick Shelston From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: October 18, 2006 10:03 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Support Site - Fixed? Chris: Interestingand agrevating at the same time. I don't want you to spend hours on the phone. Maybe I can find information on how to submit an e-mail to start a ticket James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gillman, Chris Sent: Wednesday, October 18, 2006 7:01 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Support Site - Fixed? ** James, Yes the page says Welcome Remedy and Marimba Support Users Im going to the correct page, it just wont let me login period. Christopher P. Gillman From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3 Sent: Tuesday, October 17, 2006 3:12 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Support Site - Fixed? Chris: Did the page say: Welcome Remedy and Marimba Support Users. on the page? James McKenzie L-3 GSI in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
SLA 5.5: Repeating Milestone Actions
Title: SLA 5.5: Repeating Milestone Actions ** Hello all, Im usually just a lurker, but I now need some help. We are trying to setup SLA that fires notifications when the Incident status reaches Restored. That works, fine, but as soon as I change the status to something else, and then back to Restored, the Milestone action wont run again. What am I doing incorrectly, or is this normal? Is there a workaround? Many, MANY thanks! Patrick Shelston Consultant, Managed Application Services, ITS Allstream - http://www.allstream.com [EMAIL PROTECTED] Work: 905-896-6254 Mobile: 416-845-3158 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
