Re: Question: Export attachment Many to many
Hi, If you create a report with your attachment slots, you can export all 5 records in a single run to an ARX file. Your attachments will be placed in a sub directory. 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. It there away to export multiple attachments at once. For example: A search return 5 record with attachment to each. How can I export all 5 attachment at once; instead of opening each request one at a time and exporting the subsequent attachment? ___ 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: AW: kind of selection
Hi, If you go with my suggestion, you can have the same form underneath both tables. My idea was to MOVE things from left to right. How to do this much depends on what end results your are trying to accomplish. You might get better response from the list if you explain that to us. I suggest that you read more documentation on tables, and check how existing tables work, and possibly go on a training class that covers the topic in detail. 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. Dear listers, first of all thanks a lot for your answers but I still haven’t got it. I still have problems in understanding tables in remedy. If I want a table with one column und about 20 rows I need a new form [Form 1] with one character field [Char Field] and in that form 20 requests with different Char Field contents? I connect this form and the character field with the table. Then I have a table with fixed values. This would be ok for my left table. But how do I handle with the right table? My problem is that I want this kind of selection for my ticket-form. That means of course for each ticket different results in the right table. But I don’t know how to link the table with the request-ID of my ticket form. For that I need a three dimensional table, not only a two-one…I think it must be easier but I don’t how to do it. Please, can you help me? Thanks a lot! Regards Christoph Von: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] Im Auftrag von Remedy Gesendet: Montag, 24. Oktober 2011 15:54 An: arslist@ARSLIST.ORG Betreff: Re: kind of selection ** From the help files in developer studio, they have a step by step write up on how move data back and forth between two tables. I found it while searching for details on how to add rows to a table. Sent from my iPhone, so typo's or funky words can and do happen! On Oct 23, 2011, at 9:24 PM, Shafqat Ayaz shafq...@yahoo.com wrote: ** Hi Christoph you can achieve this with a simple flag on the form, say for example a field Show, which has two values, Show 1 and Show 2. The first table shows all entries with the flag set to 1, when you move the items from table one to two, just set the flag to Show 2 and reverse it back when the opposite happens. Set the qualification for the tables appropriately. That would be the simplest method, I am sure there are many more ways to do this. Shafqat Ayaz From: Wagner, Christoph christoph.wag...@ard-stern.de To: arslist@ARSLIST.ORG Sent: Sunday, October 23, 2011 12:55 PM Subject: kind of selection ** Dear listers, is there any way to build a view as you can see in the screenshot (2 fields with add und remove button to push values from one table into another)? What is the real name of this kind of selection? I already tried this with two tables (list view) but for that kind of selection I have to build 2 new forms whereas I have to push the values from one to the other. But this is not what I want because the values are static. Any ideas? Thanks a lot. Regards Christoph Remedy Version 7.1 image001.png _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question: Export attachment Many to many
Thank Misi, Found the code after I posted. That has led to scripting runmacro to grab each request and attachment and appending with entryid. Sincerely, D.Dussie On Oct 25, 2011, at 2:49 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, If you create a report with your attachment slots, you can export all 5 records in a single run to an ARX file. Your attachments will be placed in a sub directory. 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. It there away to export multiple attachments at once. For example: A search return 5 record with attachment to each. How can I export all 5 attachment at once; instead of opening each request one at a time and exporting the subsequent attachment? ___ 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
Email Attachment Weirdness
Hi All, After a year of successfully sending out emails with between 1-4 attachments included, and an html template, the attachments have stopped going out WITHIN our domain. If the emails are sent to a different domain they go out just fine. These are files, contracts, emails etc i.e. multiple formats that are attached by the submitter and sent to the approver for review. All custom forms and workflow. Mailbox outgoing email size is enormous, way above the amount needed per message. The standard artask attachments are still going out as they should. This only happens on the production server, the very same process, email account, forms, html template etc etc all work beautifully on the dev server. I also tried creating emails on the AR System Email Messages form and attaching one of those very same attachments that did not go out when the email was created systematically and the attachments went out just fine. I got a response from support that the attachment field name needs to be in the template and it needs to match the name of the attachment itself not the field name!!! By the way, exchange logs show that the email message does not change at all from the second it is sent out so it is not a case of the attachments being stripped off and there are no policies that would do that. Version Info: ARS 7.5 patch 3 with SQL 2005 db. Any ideas or suggestions would be very much appreciated. Thanks, Sharon ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Email Attachment Weirdness
Hi Sharon, Turn on debug logging on Email Engine. You will see exactly what is passed to your SMTP-server, and you can compare what it receives between the external and internal email. If the attachments are sent to the SMTP-server, something happens outside of Remedy. 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. Hi All, After a year of successfully sending out emails with between 1-4 attachments included, and an html template, the attachments have stopped going out WITHIN our domain. If the emails are sent to a different domain they go out just fine. These are files, contracts, emails etc i.e. multiple formats that are attached by the submitter and sent to the approver for review. All custom forms and workflow. Mailbox outgoing email size is enormous, way above the amount needed per message. The standard artask attachments are still going out as they should. This only happens on the production server, the very same process, email account, forms, html template etc etc all work beautifully on the dev server. I also tried creating emails on the AR System Email Messages form and attaching one of those very same attachments that did not go out when the email was created systematically and the attachments went out just fine. I got a response from support that the attachment field name needs to be in the template and it needs to match the name of the attachment itself not the field name!!! By the way, exchange logs show that the email message does not change at all from the second it is sent out so it is not a case of the attachments being stripped off and there are no policies that would do that. Version Info: ARS 7.5 patch 3 with SQL 2005 db. Any ideas or suggestions would be very much appreciated. Thanks, Sharon ___ 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
Internal Servern Error 500 (Midtiern 7.604)
Hi! We have a reported ussue/bug created at BMC since June 2011 regarding a issue that gives some users the error Internal Server Error 500 when opening some of our forms. When the error occurs other users can look at the same form without any problems at all. If we give the user a new premission the form works (the user gets a new cacheid), if we remove the new group the user gets the error again. But this is not a workaround because the user can get the error the day after anyways again. The only thing that works is to flush the cache, then it magically works again. We are having a big deployment enviroment and when we flush the cache we get preformance issues when the server caches up again, so we are in big need of a solution on this. This makes us having problem to let the users go from userclient to webclient. BMC told us that this is a bug and that there are no solutions at the moment, nothing wrong with our form. BMC tells us it's a rendering issue in table fields. Below comes the error i midtier log: - 2011-okt-13 10:33:37 org.apache.catalina.core.StandardWrapperValve invoke ALLVARLIG: Servlet.service() for servlet ApplicationServlet threw exception java.lang.NullPointerException at com.remedy.arsys.goat.field.emit.html.TableFieldEmitter.emitOpenMarkup(Unknown Source) at com.remedy.arsys.goat.fieldgraph.visitor.html.HTMLFieldGraphVisitor.visitBeforeChildren(Unknown Source) at com.remedy.arsys.goat.field.FieldGraph$Node.traverseDepthFirst(Unknown Source) at com.remedy.arsys.goat.service.FieldGraphService.traverseDepthFirst(Unknown Source) at com.remedy.arsys.goat.service.DHTMLBuilder.genResultsListHTML(Unknown Source) at com.remedy.arsys.goat.service.DHTMLBuilder.genBasicDivForHTML(Unknown Source) at com.remedy.arsys.goat.service.DHTMLBuilder.genHTML(Unknown Source) at com.remedy.arsys.goat.service.DHTMLService.getHTMLData(Unknown Source) at com.remedy.arsys.goat.service.DHTMLRequestService.getHTMLData_aroundBody0(Unknown Source) at com.remedy.arsys.goat.service.DHTMLRequestService$AjcClosure1.run(Unknown:1) at com.remedy.arsys.goat.aspects.IDHTMLServiceCacheAspect.ajc$around$com_remedy_arsys_goat_aspects_IDHTMLServiceCacheAspect$1$517e374fproceed(IDHTMLServiceCacheAspect.aj:1) at com.remedy.arsys.goat.aspects.IDHTMLServiceCacheAspect.ajc$around$com_remedy_arsys_goat_aspects_IDHTMLServiceCacheAspect$1$517e374f(IDHTMLServiceCacheAspect.aj:74) at com.remedy.arsys.goat.service.DHTMLRequestService.transmitHTML(Unknown Source) at com.remedy.arsys.goat.service.DHTMLRequestService.requestDispatch(Unknown Source) at com.remedy.arsys.stubs.FormServlet.doRequest(Unknown Source) at com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown Source) at com.remedy.arsys.stubs.GoatHttpServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675) at java.lang.Thread.run(Unknown Source) - Do anyone else have simmilar issue? Any ideas? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Internal Servern Error 500 (Midtiern 7.604)
Hello Internal server error 500 means the application died processing a request. These issues are typically NullPointerExceptions, which usually take about 30 seconds to resolve. Look for Exception in the Tomcat stdout log and paste what you find. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Internal Servern Error 500 (Midtiern 7.604)
John, By any chance do you have a script that will check for those? and then auto shutdown apache and restart it up? for unix? On Tue, Oct 25, 2011 at 6:02 AM, John Baker jba...@javasystemsolutions.comwrote: Hello Internal server error 500 means the application died processing a request. These issues are typically NullPointerExceptions, which usually take about 30 seconds to resolve. Look for Exception in the Tomcat stdout log and paste what you find. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Internal Servern Error 500 (Midtiern 7.604)
Hi! Thats one of the problems, the stdout.log only gives us the following every time the error occurs: java.lang.NullPointerException Nothing more :( ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Internal Servern Error 500 (Midtiern 7.604)
No, that would give the users problems during the restart of tomcat, so that is no solution for us. Besides we are using a windows 2008 server enviroment. 2011/10/25 patrick zandi remedy...@gmail.com ** John, By any chance do you have a script that will check for those? and then auto shutdown apache and restart it up? for unix? On Tue, Oct 25, 2011 at 6:02 AM, John Baker jba...@javasystemsolutions.com wrote: Hello Internal server error 500 means the application died processing a request. These issues are typically NullPointerExceptions, which usually take about 30 seconds to resolve. Look for Exception in the Tomcat stdout log and paste what you find. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Patrick Zandi _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- M.v.h/Regards Daniel Tillberg Blå Tornet Systems www.blatornet.se +46 703 82 10 20 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: kind of selection
Christoph, Table fields are just a view of the data stored in a form. So your first part is correct. The left side table would show results of the Character field of Form 1. Why are you processing this as a table when a menu would do? You can select menu items and have then concatenated into a single character field on the ticket form. You can select an entry in the menu SET the entry into a character field on your Ticket Form. Then select a new entry and add the selection to the character field. This will take a little more processing in an active link. You must determine if the character field is empty, if it is just use a set fields to put the first value in. If not you need to use a SET fields with $Character_Field$+”, “+$Menu_Field$ to overwrite the field with the existing value and a comma and then the new value. This will keep going until you run out of space in the Character Field. There is more that can be done to count the remaining characters and check for duplicate selections but that would take too long. If the two table method is required and you want to display the multiple selections in a table on the Ticket Form then these values are children of the Ticket Form. Now you are creating new records in a separate form. So the action changes to a PUSH and during the PUSH you grab the Request_ID or better yet generate a GUID on the Ticket Form for each record so you have a value before it gets submitted. You are not actually pushing the value to the second Table Field on your form you are pushing it to the child form and then refreshing the table field to display what you selected and saved. I sure hope this didn’t confuse things even more. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Wagner, Christoph Sent: Monday, October 24, 2011 5:15 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: AW: kind of selection ** Dear listers, first of all thanks a lot for your answers but I still haven’t got it. I still have problems in understanding tables in remedy. If I want a table with one column und about 20 rows I need a new form [Form 1] with one character field [Char Field] and in that form 20 requests with different Char Field contents? I connect this form and the character field with the table. Then I have a table with fixed values. This would be ok for my left table. But how do I handle with the right table? My problem is that I want this kind of selection for my ticket-form. That means of course for each ticket different results in the right table. But I don’t know how to link the table with the request-ID of my ticket form. For that I need a three dimensional table, not only a two-one…I think it must be easier but I don’t how to do it. Please, can you help me? Thanks a lot! Regards Christoph Von: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] Im Auftrag von Remedy Gesendet: Montag, 24. Oktober 2011 15:54 An: arslist@ARSLIST.ORG Betreff: Re: kind of selection ** From the help files in developer studio, they have a step by step write up on how move data back and forth between two tables. I found it while searching for details on how to add rows to a table. Sent from my iPhone, so typo's or funky words can and do happen! On Oct 23, 2011, at 9:24 PM, Shafqat Ayaz shafq...@yahoo.com wrote: ** Hi Christoph you can achieve this with a simple flag on the form, say for example a field Show, which has two values, Show 1 and Show 2. The first table shows all entries with the flag set to 1, when you move the items from table one to two, just set the flag to Show 2 and reverse it back when the opposite happens. Set the qualification for the tables appropriately. That would be the simplest method, I am sure there are many more ways to do this. Shafqat Ayaz _ From: Wagner, Christoph christoph.wag...@ard-stern.de To: arslist@ARSLIST.ORG Sent: Sunday, October 23, 2011 12:55 PM Subject: kind of selection ** Dear listers, is there any way to build a view as you can see in the screenshot (2 fields with add und remove button to push values from one table into another)? What is the real name of this kind of selection? I already tried this with two tables (list view) but for that kind of selection I have to build 2 new forms whereas I have to push the values from one to the other. But this is not what I want because the values are static. Any ideas? Thanks a lot. Regards Christoph Remedy Version 7.1 image001.png _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12
Internal Servern Error 500 (Midtiern 7.604)
Patrick, Unfortunately I don't. Call me old fashioned, but at JSS, we try to fix the bugs before the product goes out of the door and when bugs are reported, we get a patch out as soon as possible (usually within 24 hours) :-) You'd need to monitor stdout*.log on Windows, or catalina.out on Unix, for java.lang.NullPointerException. If I were writing something, I'd ask it to monitor a list of log files (recalling some will rotate, which would break the Unix tail -f command) and email me with errors. Something like this, running every X minutes: grep NullPointerException tomcat/logs/catalina.out 2 /dev/null tomcat/bin/catalina.sh stop; sleep 20; tomcat/bi/catalina.sh start But Tomcat may not stop, as JVMs tend to get upset and not gracefully exit when they've been busy throwing exceptions. So the stop/start needs to be better and check for a java process ID, killing it if need be. Really not very nice :) John -- SSO Plugin for BMC products http://www.javasystemsolutions.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Internal Servern Error 500 (Midtiern 7.604)
Daniel It's very poor to hide the exception, so I doubt it's hidden. It's likely to be printed elsewhere, have you looked in armidtier.log? If there is no exception, I don't understand how BMC can verify/fix it unless they can reproduce. Here's what an exception looks like: javax.naming.NoInitialContextException: Blah blah at javax.naming.spi.NamingManager.getInitialContext(Unknown Source) at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source) at javax.naming.InitialContext.getURLOrDefaultInitCtx(Unknown Source) at javax.naming.InitialContext.lookup(Unknown Source) John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Internal Servern Error 500 (Midtiern 7.604)
John, Daniel Our Mid-Tiers/Tomcats create separate txt files in the Tomcat log directory for each exception, e.g. localhost_log.2011-10-24.txt In catalina.out, you will only get the NullPointerException message, not the whole stack trace. You can configure this in Tomcat's server.xml: Logger className=org.apache.catalina.logger.FileLogger directory=logs prefix=localhost_log. suffix=.txt timestamp=true/ This should bring you closer to the root cause. br, thomas -Urspr?ngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] Im Auftrag von John Baker Gesendet: Dienstag, 25. Oktober 2011 15:52 An: arslist@ARSLIST.ORG Betreff: Internal Servern Error 500 (Midtiern 7.604) Daniel It's very poor to hide the exception, so I doubt it's hidden. It's likely to be printed elsewhere, have you looked in armidtier.log? If there is no exception, I don't understand how BMC can verify/fix it unless they can reproduce. Here's what an exception looks like: javax.naming.NoInitialContextException: Blah blah at javax.naming.spi.NamingManager.getInitialContext(Unknown Source) at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source) at javax.naming.InitialContext.getURLOrDefaultInitCtx(Unknown Source) at javax.naming.InitialContext.lookup(Unknown Source) 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: Internal Servern Error 500 (Midtiern 7.604)
Tomcat has had a force option for years tomcat/bin/catalina.sh stop -force Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Baker Sent: Tuesday, October 25, 2011 8:50 AM To: arslist@ARSLIST.ORG Subject: Internal Servern Error 500 (Midtiern 7.604) Patrick, Unfortunately I don't. Call me old fashioned, but at JSS, we try to fix the bugs before the product goes out of the door and when bugs are reported, we get a patch out as soon as possible (usually within 24 hours) :-) You'd need to monitor stdout*.log on Windows, or catalina.out on Unix, for java.lang.NullPointerException. If I were writing something, I'd ask it to monitor a list of log files (recalling some will rotate, which would break the Unix tail -f command) and email me with errors. Something like this, running every X minutes: grep NullPointerException tomcat/logs/catalina.out 2 /dev/null tomcat/bin/catalina.sh stop; sleep 20; tomcat/bi/catalina.sh start But Tomcat may not stop, as JVMs tend to get upset and not gracefully exit when they've been busy throwing exceptions. So the stop/start needs to be better and check for a java process ID, killing it if need be. Really not very nice :) John -- SSO Plugin for BMC products http://www.javasystemsolutions.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, October 25, 2011 6:27 AM To: arslist@ARSLIST.ORG Subject: Re: Internal Servern Error 500 (Midtiern 7.604) ** John, By any chance do you have a script that will check for those? and then auto shutdown apache and restart it up? for unix? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Unable to connect to oracle when starting remedy
Hi listers, We had an issue with our server today. The server process stopped and when trying to restart it we can't connect to the database (oracle) due to a bad username/password issue. Checked with our DBA and the oracle password had expired and was locked. Changed it to un-locked and tried to restart the server process. We are still getting the bad username/password when trying to connect to oracle. We can sqlplus into the database with the username/password combination. Is there a config file that can be updated offline to set the database password that remedy process is looking for when trying to connect? any help would be appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Unable to connect to oracle when starting remedy
Dan, in your ar.cfg, you should see entries like this. Make sure the DB user name and PW are correct. Also, can your DBA verify which server the bad requests are coming from? Just make sure there are no apps outside of AR like Analytics or Dashboards that are also trying to use the account and locking out with bad entries Here's the entries in the ar.cfg Db-user: ARAdmin Db-password: YOURPASSWORDHERE -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dan Sent: Tuesday, October 25, 2011 10:42 AM To: arslist@ARSLIST.ORG Subject: Unable to connect to oracle when starting remedy Hi listers, We had an issue with our server today. The server process stopped and when trying to restart it we can't connect to the database (oracle) due to a bad username/password issue. Checked with our DBA and the oracle password had expired and was locked. Changed it to un-locked and tried to restart the server process. We are still getting the bad username/password when trying to connect to oracle. We can sqlplus into the database with the username/password combination. Is there a config file that can be updated offline to set the database password that remedy process is looking for when trying to connect? any help would be appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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
BMC Analytics Missing form
I'm looking in the Universe for the Remedy form User and do not see it. I Imported the Universe and did a refresh on it and it is not listed in the forms. Am I missing a step or is there something I need to turn on the form so Analytics can see it Remedy 7.6 _ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: BMC Analytics Missing form
John, Analytics is basically a pre-packaged universe that BMC has written which encompasses most of the ITSM suite that is forward facing to the user community for reporting such as your Incidents/Changes/Problems/ etc... For something like the User form to be visible as a Universe item, you must Insert Table and insert it from there. Are you saying it is not showing up from the list of available tables or that it is not there out of the box? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of john.athe...@schneider-electric.com Sent: Tuesday, October 25, 2011 10:51 AM To: arslist@ARSLIST.ORG Subject: BMC Analytics Missing form ** I'm looking in the Universe for the Remedy form User and do not see it. I Imported the Universe and did a refresh on it and it is not listed in the forms. Am I missing a step or is there something I need to turn on the form so Analytics can see it Remedy 7.6 _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com mailto:%20john.athe...@apcc.com | Site: www.apc.com/ http://www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail _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: BMC Analytics Missing form
Not showing up in the drop down box. I believe your first part is correct and I need to do an insert table and insert it. Then it will or should be in the drop down box. Thanks _ 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 Chowdhury, Tauf tauf.chowdh...@frx.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/25/2011 10:53 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: BMC Analytics Missing form ** John, Analytics is basically a pre-packaged universe that BMC has written which encompasses most of the ITSM suite that is forward facing to the user community for reporting such as your Incidents/Changes/Problems/ etc… For something like the User form to be visible as a “Universe” item, you must Insert Table and insert it from there. Are you saying it is not showing up from the list of available tables or that it is not there out of the box? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of john.athe...@schneider-electric.com Sent: Tuesday, October 25, 2011 10:51 AM To: arslist@ARSLIST.ORG Subject: BMC Analytics Missing form ** I'm looking in the Universe for the Remedy form User and do not see it. I Imported the Universe and did a refresh on it and it is not listed in the forms. Am I missing a step or is there something I need to turn on the form so Analytics can see it Remedy 7.6 _ 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 _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. __ This email has been scanned by the MessageLabs Email Security 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
Re: Unable to connect to oracle when starting remedy
first thank you for your input. I am running on a UNIX platform so I looked into my ar.conf file. Db-name: Db-user: both are there and correct. I do not see a Db_password entry. only password entries are DSO Remedy-App Mid-Tier they are also not in plain text. our ar.conf file has not been changed in over a month so we have been working with this for at least that long. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Unable to connect to oracle when starting remedy
fixed Went to my production server and took the Db_password: and value, copied and pasted into the one on my test box and it now works. Now to figure out what happened to the Db_password value to start with.. Thanks for the help ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
How to create a request automatically from an Incident with a Business Service associated BUT.......
Hi all I'm doing an integration with the email engine. I create an entry in the HPD:Incident InterfaceCreate and this creates the incident but I want that this creates the related request too. I've checked in the HPD:Incident InterfaceCreate the field Create Request to yes and I've written a business service in the field service fromt tis form too but in the created incident, there is not request associated and no service. Anyone knows how to create the request and how to associate the service?. Thank you very much ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Internal Servern Error 500 (Midtiern 7.604)
We are in itsm 7.6.03 p002 and we are also noticing this. We saw this happening when when user tries to open a dialog on click of a menu or button. This does not happen to all the users all the time. Only one or two users notice it while it works fine for all others. As you mentioned the workaround was to flush the midtier cache or sometimes user's browser cache. Do you have a defectID that BMC created for this issue? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Discovery ADDM 8.3
Hi, In what instances would you have to log on remotely to the Appliance server with ADDM 8.3? Are there any log files that we should be examining on the Appliance Server directly, that we cannot view via the Admin tool User GUI? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Discovery ADDM 8.3
Configuration and functionality is through the gui.. once set up.. I know of no reason to access the server itself outside the gui interface.. but if you are the admin, security scanning.. you want to still have access.. I would highly doubt it.. but someone else on the list might through out something.. Check the community site as well.. On Tue, Oct 25, 2011 at 12:37 PM, Kathy Morris kathymorris...@aol.comwrote: ** ** Hi, In what instances would you have to log on remotely to the Appliance server with ADDM 8.3? Are there any log files that we should be examining on the Appliance Server directly, that we cannot view via the Admin tool User GUI? _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
ARS 7.6.04 OOB Groups
All, We have installed ITSM 7.6.04 and SRM 7.6.04. Does someone have a server with the original groups that they can provide in a .csv format? Thanks in advance. David Abry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Internal Servern Error 500 (Midtiern 7.604)
catalina.out contains stack traces for every other application I use, including MidTier :) The log file you mention is enabled by default. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Indexes that aren't really there
Hi Folks, My AR System is confused about the indexes on a particular form. The AR System believes that there are four indexes on this particular form but in the database (Oracle) there are no entries for this form in the SCHEMA_INDEX table. When I attempt to delete the indexes using Dev Studio, I get errors: Failure during SQL operation to the database : ORA-01418: specified index does not exist, 552, AR System User Central File and I can see from the SQL logs: */*** ERROR *** ORA-01418: specified index does not exist So it appears that there is some other place within the AR System that still indicates that there are indexes on this form. Can anyone tell me where to look? I understand the dangers of mucking around directly in the database tables. This is my development system, so the results of a mistake will not be catastrophic. Thanks. Larry ARS: 7.6.03 - Solaris 10 Oracle: 11.2.0.1.0 - 64bit Larry Robinson NC State University Remedy Admin/Developer 919-515-5432 n...@ncsu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Discovery ADDM 8.3
Kathy, There are several logs on the appliance. See below: export-creds.log export_startup.log tc_shutdown.log tc_startup.log tw_appliance_df.log tw_appliance_du.log tw_appliance_sar.log tw_appserver.log tw_baseline.log tw_cmdbsync_exporter.log tw_consolidation.log tw_cron_update.log tw_deptree.log tw_edm_java.log tw_export-ui.log tw_integrations-ui.log tw_options.log tw_patterns.log tw_svc_cmdbsync_exporter.log tw_svc_cmdbsync_transformer.log tw_svc_discovery.log tw_svc_eca_engine.log tw_svc_eca_patterns.log tw_svc_eca_perf_engine.log tw_svc_eca_perf_pattern.log tw_svc_eca_trackers.log tw_svc_edm.log tw_svc_free_space_monitor.log tw_svc_integrations_sql.log tw_svc_integrations_sql_jsvc.log tw_svc_model.log tw_svc_options.log tw_svc_reasoning.log tw_svc_reports.log tw_svc_security.log tw_svc_tomcat.log tw_svc_topology.log tw_svc_watchdog.log tw_tax_export.log there are the application logs, reasoning service logs, cmdb sync logs, performance logs. Thanks, Rajesh On Tue, Oct 25, 2011 at 12:37 PM, Kathy Morris kathymorris...@aol.comwrote: ** ** Hi, In what instances would you have to log on remotely to the Appliance server with ADDM 8.3? Are there any log files that we should be examining on the Appliance Server directly, that we cannot view via the Admin tool User GUI? _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Indexes that aren't really there
So there are indexes on the T table, but no record of them in SCHEMA_INDEX. Then Oracle knows of them, but ARS should not. Have you tried restarting the app (as the index info is held in memory while the server is running) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of L G Robinson Sent: Tuesday, October 25, 2011 12:49 PM To: arslist@ARSLIST.ORG Subject: Indexes that aren't really there ** Hi Folks, My AR System is confused about the indexes on a particular form. The AR System believes that there are four indexes on this particular form but in the database (Oracle) there are no entries for this form in the SCHEMA_INDEX table. When I attempt to delete the indexes using Dev Studio, I get errors: Failure during SQL operation to the database : ORA-01418: specified index does not exist, 552, AR System User Central File and I can see from the SQL logs: */*** ERROR *** ORA-01418: specified index does not exist So it appears that there is some other place within the AR System that still indicates that there are indexes on this form. Can anyone tell me where to look? I understand the dangers of mucking around directly in the database tables. This is my development system, so the results of a mistake will not be catastrophic. Thanks. Larry ARS: 7.6.03 - Solaris 10 Oracle: 11.2.0.1.0 - 64bit Larry Robinson NC State University Remedy Admin/Developer 919-515-5432 n...@ncsu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7.6.04 OOB Groups
Hi, You should always use ARX-files, if possible, when working with internal data. I would imagine that you would find an ARX-file containing the groups in the installer package somewhere. 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. All, We have installed ITSM 7.6.04 and SRM 7.6.04. Does someone have a server with the original groups that they can provide in a .csv format? Thanks in advance. David Abry ___ 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: Indexes that aren't really there
Hi Fred, Nope, it is the other way around Dev Studio says there are indexes, but there are none on the T table nor entries in the SCHEMA_INDEX table. Thanks. Larry On Tue, Oct 25, 2011 at 2:03 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: So there are indexes on the T table, but no record of them in SCHEMA_INDEX. Then Oracle knows of them, but ARS should not. Have you tried restarting the app (as the index info is held in memory while the server is running) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of L G Robinson Sent: Tuesday, October 25, 2011 12:49 PM To: arslist@ARSLIST.ORG Subject: Indexes that aren't really there ** Hi Folks, My AR System is confused about the indexes on a particular form. The AR System believes that there are four indexes on this particular form but in the database (Oracle) there are no entries for this form in the SCHEMA_INDEX table. When I attempt to delete the indexes using Dev Studio, I get errors: Failure during SQL operation to the database : ORA-01418: specified index does not exist, 552, AR System User Central File and I can see from the SQL logs: */*** ERROR *** ORA-01418: specified index does not exist So it appears that there is some other place within the AR System that still indicates that there are indexes on this form. Can anyone tell me where to look? I understand the dangers of mucking around directly in the database tables. This is my development system, so the results of a mistake will not be catastrophic. Thanks. Larry ARS: 7.6.03 - Solaris 10 Oracle: 11.2.0.1.0 - 64bit Larry Robinson NC State University Remedy Admin/Developer 919-515-5432 n...@ncsu.edu ___ 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: Indexes that aren't really there
Sorry, there is an index on C1 on the T table, as you would expect, but no others. Thanks. Larry On Tue, Oct 25, 2011 at 2:19 PM, L G Robinson n...@ncsu.edu wrote: Hi Fred, Nope, it is the other way around Dev Studio says there are indexes, but there are none on the T table nor entries in the SCHEMA_INDEX table. Thanks. Larry On Tue, Oct 25, 2011 at 2:03 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: So there are indexes on the T table, but no record of them in SCHEMA_INDEX. Then Oracle knows of them, but ARS should not. Have you tried restarting the app (as the index info is held in memory while the server is running) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of L G Robinson Sent: Tuesday, October 25, 2011 12:49 PM To: arslist@ARSLIST.ORG Subject: Indexes that aren't really there ** Hi Folks, My AR System is confused about the indexes on a particular form. The AR System believes that there are four indexes on this particular form but in the database (Oracle) there are no entries for this form in the SCHEMA_INDEX table. When I attempt to delete the indexes using Dev Studio, I get errors: Failure during SQL operation to the database : ORA-01418: specified index does not exist, 552, AR System User Central File and I can see from the SQL logs: */*** ERROR *** ORA-01418: specified index does not exist So it appears that there is some other place within the AR System that still indicates that there are indexes on this form. Can anyone tell me where to look? I understand the dangers of mucking around directly in the database tables. This is my development system, so the results of a mistake will not be catastrophic. Thanks. Larry ARS: 7.6.03 - Solaris 10 Oracle: 11.2.0.1.0 - 64bit Larry Robinson NC State University Remedy Admin/Developer 919-515-5432 n...@ncsu.edu ___ 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: Indexes that aren't really there
Hi, I have seen that index creation has failed, but the AR System repository still has the indexes in them. The problem is that you can not recreate the indexes, because the AR System gives you an error while it tries to delete the original index. Just look in the schema_indexes table and create the indexes manually in the database. They do not need to be correct, except for the index name. You can then recreate them via Dev Studio, and they should be fine. 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. Sorry, there is an index on C1 on the T table, as you would expect, but no others. Thanks. Larry On Tue, Oct 25, 2011 at 2:19 PM, L G Robinson n...@ncsu.edu wrote: Hi Fred, Nope, it is the other way around Dev Studio says there are indexes, but there are none on the T table nor entries in the SCHEMA_INDEX table. Thanks. Larry On Tue, Oct 25, 2011 at 2:03 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: So there are indexes on the T table, but no record of them in SCHEMA_INDEX. Then Oracle knows of them, but ARS should not. Have you tried restarting the app (as the index info is held in memory while the server is running) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of L G Robinson Sent: Tuesday, October 25, 2011 12:49 PM To: arslist@ARSLIST.ORG Subject: Indexes that aren't really there ** Hi Folks, My AR System is confused about the indexes on a particular form. The AR System believes that there are four indexes on this particular form but in the database (Oracle) there are no entries for this form in the SCHEMA_INDEX table. When I attempt to delete the indexes using Dev Studio, I get errors: Failure during SQL operation to the database : ORA-01418: specified index does not exist, 552, AR System User Central File and I can see from the SQL logs: */*** ERROR *** ORA-01418: specified index does not exist So it appears that there is some other place within the AR System that still indicates that there are indexes on this form. Can anyone tell me where to look? I understand the dangers of mucking around directly in the database tables. This is my development system, so the results of a mistake will not be catastrophic. Thanks. Larry ARS: 7.6.03 - Solaris 10 Oracle: 11.2.0.1.0 - 64bit Larry Robinson NC State University Remedy Admin/Developer 919-515-5432 n...@ncsu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Indexes that aren't really there
Larry, What I would do to take care of this would be to export the form to XML Def.remove all index information from the def.then re-import it..I would expect that to take care of the scenario you are dealing with. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of L G Robinson Sent: Tuesday, October 25, 2011 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: Indexes that aren't really there ** Sorry, there is an index on C1 on the T table, as you would expect, but no others. Thanks. Larry On Tue, Oct 25, 2011 at 2:19 PM, L G Robinson n...@ncsu.edu wrote: Hi Fred, Nope, it is the other way around Dev Studio says there are indexes, but there are none on the T table nor entries in the SCHEMA_INDEX table. Thanks. Larry On Tue, Oct 25, 2011 at 2:03 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: So there are indexes on the T table, but no record of them in SCHEMA_INDEX. Then Oracle knows of them, but ARS should not. Have you tried restarting the app (as the index info is held in memory while the server is running) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of L G Robinson Sent: Tuesday, October 25, 2011 12:49 PM To: arslist@ARSLIST.ORG Subject: Indexes that aren't really there ** Hi Folks, My AR System is confused about the indexes on a particular form. The AR System believes that there are four indexes on this particular form but in the database (Oracle) there are no entries for this form in the SCHEMA_INDEX table. When I attempt to delete the indexes using Dev Studio, I get errors: Failure during SQL operation to the database : ORA-01418: specified index does not exist, 552, AR System User Central File and I can see from the SQL logs: */*** ERROR *** ORA-01418: specified index does not exist So it appears that there is some other place within the AR System that still indicates that there are indexes on this form. Can anyone tell me where to look? I understand the dangers of mucking around directly in the database tables. This is my development system, so the results of a mistake will not be catastrophic. Thanks. Larry ARS: 7.6.03 - Solaris 10 Oracle: 11.2.0.1.0 - 64bit Larry Robinson NC State University Remedy Admin/Developer 919-515-5432 n...@ncsu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ITSM Group name = 1000000022
Claire, The group ID is the value stored in any definition and the group ID can always be used in any reference to a group. The name is just an alias that is a pretty name to be used when interacting with people. If you want to change the group name from a number to a name, there should be no issue for the system. Any reference to the group in a field in any data you have will have stored only the group ID. Doug -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire Sent: Monday, October 24, 2011 3:06 PM To: arslist@ARSLIST.ORG Subject: ITSM Group name = 100022 Somehow when the consultants loaded the groups from my spreadsheets, they were all given a number instead of a group name. They have the group number in the Group ID field and the Group ID in the Group Name field. The Long Group Name has the full name along with the menu choice -- MH-Technical-Desktop Solutions Will it break anything if I change the 100022 in the Group Name to Desktop Solutions?It looks like all of the vendors are in there the same way as well. Is this a mistake? Should they display the name? Claire ITSM 7.6.04 sp1 ___ 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: Discovery ADDM 8.3
Understood. I can view the logs below by looking under Administration/logs in the GUI. My question was ... is there ever any reason to log on directly to the appliance server for logs and/or troubleshooting. In a message dated 10/25/2011 2:03:32 P.M. Eastern Daylight Time, rgull...@gmail.com writes: ** Kathy, There are several logs on the appliance. See below: export-creds.log export_startup.log tc_shutdown.log tc_startup.log tw_appliance_df.log tw_appliance_du.log tw_appliance_sar.log tw_appserver.log tw_baseline.log tw_cmdbsync_exporter.log tw_consolidation.log tw_cron_update.log tw_deptree.log tw_edm_java.log tw_export-ui.log tw_integrations-ui.log tw_options.log tw_patterns.log tw_svc_cmdbsync_exporter.log tw_svc_cmdbsync_transformer.log tw_svc_discovery.log tw_svc_eca_engine.log tw_svc_eca_patterns.log tw_svc_eca_perf_engine.log tw_svc_eca_perf_pattern.log tw_svc_eca_trackers.log tw_svc_edm.log tw_svc_free_space_monitor.log tw_svc_integrations_sql.log tw_svc_integrations_sql_jsvc.log tw_svc_model.log tw_svc_options.log tw_svc_reasoning.log tw_svc_reports.log tw_svc_security.log tw_svc_tomcat.log tw_svc_topology.log tw_svc_watchdog.log tw_tax_export.log there are the application logs, reasoning service logs, cmdb sync logs, performance logs. Thanks, Rajesh On Tue, Oct 25, 2011 at 12:37 PM, Kathy Morris _Kathymorris727@aol.com_ (mailto:kathymorris...@aol.com) wrote: ** Hi, In what instances would you have to log on remotely to the Appliance server with ADDM 8.3? Are there any log files that we should be examining on the Appliance Server directly, that we cannot view via the Admin tool User GUI? _attend WWRUG12 _www.wwrug.com_ (http://www.wwrug.com/) ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Indexes that aren't really there
Hi LJ, Thanks for the suggestion. However, I found it easier to do as Misi suggested. I created the indexes that the AR System thought were already there using direct access to the database. Then I was able to delete the indexes using Dev Studio. Finally, after updating, I was able to create the one index that I wanted in the first place. So all is well. Thanks Misi... you have come through for me once again. Larry On Tue, Oct 25, 2011 at 2:43 PM, LJ LongWing lj.longw...@gmail.com wrote: ** Larry, What I would do to take care of this would be to export the form to XML Def…remove all index information from the def…then re-import it….I would expect that to take care of the scenario you are dealing with. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
ITSM - 7.6.04 - Email Templates
I have a team here that likes to create their own things and then have them send an email to Remedy to create a ticket. In the 6.3 world it was easy. Just send an email to the HPD:HelpDesk or CHG:Change form and it will create the ticket using an email template. Can I do the same thing in the 7.6.04 world or do I have to send it to one of the create forms... for example: WOI:WorkOrderInterface_Create Thank you all for your answers! I am swimming upstream on this! Thank goodness for the life vest that is the ARSList. Claire ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Discovery ADDM 8.3
Well... Other than during the initial setup and if you want to edit graph defenitions text file. You would not need to login (BMC also recommends that you do not use command line). ButAdmins would need access to the Applicance. 1) To setup crons (for example:: backups using snapshot tool). 2) If you want to schedule a job in GUI, there is duration limit to 23 hours. Where as if we set up schedule thru command line with out --recurrence-duration, it will run till it completes. So in nutshell, it helps sometimes to have access to Appliance. But not absolutely required to maintain the tool. Thanks, Rajesh On Tue, Oct 25, 2011 at 3:30 PM, Kathy Morris kathymorris...@aol.comwrote: ** ** Understood. I can view the logs below by looking under Administration/logs in the GUI. My question was ... is there ever any reason to log on * directly* to the appliance server for logs and/or troubleshooting. In a message dated 10/25/2011 2:03:32 P.M. Eastern Daylight Time, rgull...@gmail.com writes: ** Kathy, There are several logs on the appliance. See below: export-creds.log export_startup.log tc_shutdown.log tc_startup.log tw_appliance_df.log tw_appliance_du.log tw_appliance_sar.log tw_appserver.log tw_baseline.log tw_cmdbsync_exporter.log tw_consolidation.log tw_cron_update.log tw_deptree.log tw_edm_java.log tw_export-ui.log tw_integrations-ui.log tw_options.log tw_patterns.log tw_svc_cmdbsync_exporter.log tw_svc_cmdbsync_transformer.log tw_svc_discovery.log tw_svc_eca_engine.log tw_svc_eca_patterns.log tw_svc_eca_perf_engine.log tw_svc_eca_perf_pattern.log tw_svc_eca_trackers.log tw_svc_edm.log tw_svc_free_space_monitor.log tw_svc_integrations_sql.log tw_svc_integrations_sql_jsvc.log tw_svc_model.log tw_svc_options.log tw_svc_reasoning.log tw_svc_reports.log tw_svc_security.log tw_svc_tomcat.log tw_svc_topology.log tw_svc_watchdog.log tw_tax_export.log there are the application logs, reasoning service logs, cmdb sync logs, performance logs. Thanks, Rajesh On Tue, Oct 25, 2011 at 12:37 PM, Kathy Morris kathymorris...@aol.comwrote: ** ** Hi, In what instances would you have to log on remotely to the Appliance server with ADDM 8.3? Are there any log files that we should be examining on the Appliance Server directly, that we cannot view via the Admin tool User GUI? _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Discovery ADDM 8.3
Thanks. In a message dated 10/25/2011 4:18:23 P.M. Eastern Daylight Time, rgull...@gmail.com writes: ** Well... Other than during the initial setup and if you want to edit graph defenitions text file. You would not need to login (BMC also recommends that you do not use command line). ButAdmins would need access to the Applicance. 1) To setup crons (for example:: backups using snapshot tool). 2) If you want to schedule a job in GUI, there is duration limit to 23 hours. Where as if we set up schedule thru command line with out --recurrence-duration, it will run till it completes. So in nutshell, it helps sometimes to have access to Appliance. But not absolutely required to maintain the tool. Thanks, Rajesh On Tue, Oct 25, 2011 at 3:30 PM, Kathy Morris _Kathymorris727@aol.com_ (mailto:kathymorris...@aol.com) wrote: ** Understood. I can view the logs below by looking under Administration/logs in the GUI. My question was ... is there ever any reason to log on directly to the appliance server for logs and/or troubleshooting. In a message dated 10/25/2011 2:03:32 P.M. Eastern Daylight Time, _rgullapa@GMAIL.COM_ (mailto:rgull...@gmail.com) writes: ** Kathy, There are several logs on the appliance. See below: export-creds.log export_startup.log tc_shutdown.log tc_startup.log tw_appliance_df.log tw_appliance_du.log tw_appliance_sar.log tw_appserver.log tw_baseline.log tw_cmdbsync_exporter.log tw_consolidation.log tw_cron_update.log tw_deptree.log tw_edm_java.log tw_export-ui.log tw_integrations-ui.log tw_options.log tw_patterns.log tw_svc_cmdbsync_exporter.log tw_svc_cmdbsync_transformer.log tw_svc_discovery.log tw_svc_eca_engine.log tw_svc_eca_patterns.log tw_svc_eca_perf_engine.log tw_svc_eca_perf_pattern.log tw_svc_eca_trackers.log tw_svc_edm.log tw_svc_free_space_monitor.log tw_svc_integrations_sql.log tw_svc_integrations_sql_jsvc.log tw_svc_model.log tw_svc_options.log tw_svc_reasoning.log tw_svc_reports.log tw_svc_security.log tw_svc_tomcat.log tw_svc_topology.log tw_svc_watchdog.log tw_tax_export.log there are the application logs, reasoning service logs, cmdb sync logs, performance logs. Thanks, Rajesh On Tue, Oct 25, 2011 at 12:37 PM, Kathy Morris _Kathymorris727@aol.com_ (mailto:kathymorris...@aol.com) wrote: ** Hi, In what instances would you have to log on remotely to the Appliance server with ADDM 8.3? Are there any log files that we should be examining on the Appliance Server directly, that we cannot view via the Admin tool User GUI? _attend WWRUG12 _www.wwrug.com_ (http://www.wwrug.com/) ARSlist: Where the Answers Are_ _attend WWRUG12 _www.wwrug.com_ (http://www.wwrug.com/) ARSlist: Where the Answers Are_ _attend WWRUG12 _www.wwrug.com_ (http://www.wwrug.com/) ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Indexes that aren't really there
Hi, It would not. The AR System still thinks the indexes are there, but they are not. Best Regards - Misi, RRR AB, http://rrr.se Larry, What I would do to take care of this would be to export the form to XML Def.remove all index information from the def.then re-import it..I would expect that to take care of the scenario you are dealing with. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of L G Robinson Sent: Tuesday, October 25, 2011 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: Indexes that aren't really there ** Sorry, there is an index on C1 on the T table, as you would expect, but no others. Thanks. Larry On Tue, Oct 25, 2011 at 2:19 PM, L G Robinson n...@ncsu.edu wrote: Hi Fred, Nope, it is the other way around Dev Studio says there are indexes, but there are none on the T table nor entries in the SCHEMA_INDEX table. Thanks. Larry On Tue, Oct 25, 2011 at 2:03 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: So there are indexes on the T table, but no record of them in SCHEMA_INDEX. Then Oracle knows of them, but ARS should not. Have you tried restarting the app (as the index info is held in memory while the server is running) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of L G Robinson Sent: Tuesday, October 25, 2011 12:49 PM To: arslist@ARSLIST.ORG Subject: Indexes that aren't really there ** Hi Folks, My AR System is confused about the indexes on a particular form. The AR System believes that there are four indexes on this particular form but in the database (Oracle) there are no entries for this form in the SCHEMA_INDEX table. When I attempt to delete the indexes using Dev Studio, I get errors: Failure during SQL operation to the database : ORA-01418: specified index does not exist, 552, AR System User Central File and I can see from the SQL logs: */*** ERROR *** ORA-01418: specified index does not exist So it appears that there is some other place within the AR System that still indicates that there are indexes on this form. Can anyone tell me where to look? I understand the dangers of mucking around directly in the database tables. This is my development system, so the results of a mistake will not be catastrophic. Thanks. Larry ARS: 7.6.03 - Solaris 10 Oracle: 11.2.0.1.0 - 64bit Larry Robinson NC State University Remedy Admin/Developer 919-515-5432 n...@ncsu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ 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
Compliance activity for Remedy
I was wondering - what kind of compliance events do people use for Remedy? Some examples: Disable all accounts where password has not changed 120 days Remove all accounts that have not been used 365 days Remove groups - where no members exist. Review mid-tier log files for excessive error messages Review mid-tier directory for non-standard files (possible new .jsp) etc... Thanks, -John -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7.6.04 OOB Groups
Thank you. Appreciate it. On Tue, Oct 25, 2011 at 2:11 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, You should always use ARX-files, if possible, when working with internal data. I would imagine that you would find an ARX-file containing the groups in the installer package somewhere. 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. All, We have installed ITSM 7.6.04 and SRM 7.6.04. Does someone have a server with the original groups that they can provide in a .csv format? Thanks in advance. David Abry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Indexes that aren't really there
What would be great is a util that validates what actually exists is what is thought to exist. And - it could run after every install. And - after every upgrade. And - it could run 1/week as part of compliance. BMC should write this - if it does not already exist. (It would catch tons of errors - proactively) As - I have had this before -- and according to the indexes defined by Remedy -- this query should be fast -- but it is not. Turns out -- the index did not actually exist - yet was defined in Remedy :( -John On Oct 25, 2011, at 2:30 PM, L G Robinson wrote: ** Hi LJ, Thanks for the suggestion. However, I found it easier to do as Misi suggested. I created the indexes that the AR System thought were already there using direct access to the database. Then I was able to delete the indexes using Dev Studio. Finally, after updating, I was able to create the one index that I wanted in the first place. So all is well. Thanks Misi... you have come through for me once again. Larry On Tue, Oct 25, 2011 at 2:43 PM, LJ LongWing lj.longw...@gmail.com wrote: ** Larry, What I would do to take care of this would be to export the form to XML Def…remove all index information from the def…then re-import it….I would expect that to take care of the scenario you are dealing with. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Compliance activity for Remedy
Consolidating / merging duplicate groups (same members which are not likely to change) if it appears they were created to serve the same functional purpose, may be a good idea too.. Joe From: John Sundberg Sent: Tuesday, October 25, 2011 4:27 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Compliance activity for Remedy ** I was wondering - what kind of compliance events do people use for Remedy? Some examples: Disable all accounts where password has not changed 120 days Remove all accounts that have not been used 365 days Remove groups - where no members exist. Review mid-tier log files for excessive error messages Review mid-tier directory for non-standard files (possible new .jsp) etc... Thanks, -John -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Indexes that aren't really there
I have a script (for Oracle) that I wrote a while ago to do just this. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: Tuesday, October 25, 2011 3:31 PM To: arslist@ARSLIST.ORG Subject: Re: Indexes that aren't really there ** What would be great is a util that validates what actually exists is what is thought to exist. And - it could run after every install. And - after every upgrade. And - it could run 1/week as part of compliance. BMC should write this - if it does not already exist. (It would catch tons of errors - proactively) As - I have had this before -- and according to the indexes defined by Remedy -- this query should be fast -- but it is not. Turns out -- the index did not actually exist - yet was defined in Remedy :( -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com -Original Message- On Oct 25, 2011, at 2:30 PM, L G Robinson wrote: ** Hi LJ, Thanks for the suggestion. However, I found it easier to do as Misi suggested. I created the indexes that the AR System thought were already there using direct access to the database. Then I was able to delete the indexes using Dev Studio. Finally, after updating, I was able to create the one index that I wanted in the first place. So all is well. Thanks Misi... you have come through for me once again. Larry -Original Message- On Tue, Oct 25, 2011 at 2:43 PM, LJ LongWing wrote: ** Larry, What I would do to take care of this would be to export the form to XML Def...remove all index information from the def...then re-import itI would expect that to take care of the scenario you are dealing with. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Index_Check.SQL Description: Index_Check.SQL
Re: Compliance activity for Remedy
I would be careful about removing any account that hasn't been active for x number of days. I learned the hard way that deleting an account also deletes the tickets tied to that user. Just my 2 cents worth. Larry B. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, October 25, 2011 1:38 PM To: arslist@ARSLIST.ORG Subject: Re: Compliance activity for Remedy ** Consolidating / merging duplicate groups (same members which are not likely to change) if it appears they were created to serve the same functional purpose, may be a good idea too.. Joe From: John Sundberg mailto:john.sundb...@kineticdata.com Sent: Tuesday, October 25, 2011 4:27 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Compliance activity for Remedy ** I was wondering - what kind of compliance events do people use for Remedy? Some examples: Disable all accounts where password has not changed 120 days Remove all accounts that have not been used 365 days Remove groups - where no members exist. Review mid-tier log files for excessive error messages Review mid-tier directory for non-standard files (possible new .jsp) etc... Thanks, -John -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG http://www.kineticdata.com/Events/KEG.html Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com http://www.kineticdata.com/ _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
AW: AW: kind of selection
Hi listers, this is exactly what I want. I have a ticket form, where each request represents a failure in our company, of course (e.g. Server A is down, Server B is down and so on). For each request the user should select some out of 20 people which have to be notified. For this selection I want to use two tables and 2 buttons (add and remove). The left table should contain every people who could be notified (IS state). The right table should contain the people who finally will be notified (target state). Example: |whole distribution list| | choosed distribution list | | - | |- | | people A | add | people A | | people B | remove | | | people C | | | | ... | | | Misi, you said that I can do the whole thing in one form, to be exact: in my ticket-form. As I read through the Form and Application Objects Guide, I found out that tables are created as follows: a column represents any field from my ticket-form and each row represents a request from that form. As you can see out of my example I need one column and at least 20 rows for the tables. For that I need one extra field in my ticket-form, perhaps a character field named distribution list and 20 new requests with the right Email-Address inside this field. And this is where I stuck, what I don't understand!!! I need the requests from the form for my failures (Server A is down...) and I need the requests from the form for the selection itself. But I have to store the information of a failure and the information of the two tables in one request. Am I right with this? Or do I forget anything? This is what I don’t understand - this can't work for me! Thank you very much for your help! Regards, Christoph -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] Im Auftrag von Misi Mladoniczky Gesendet: Dienstag, 25. Oktober 2011 08:56 An: arslist@ARSLIST.ORG Betreff: Re: AW: kind of selection Hi, If you go with my suggestion, you can have the same form underneath both tables. My idea was to MOVE things from left to right. How to do this much depends on what end results your are trying to accomplish. You might get better response from the list if you explain that to us. I suggest that you read more documentation on tables, and check how existing tables work, and possibly go on a training class that covers the topic in detail. 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. Dear listers, first of all thanks a lot for your answers but I still haven’t got it. I still have problems in understanding tables in remedy. If I want a table with one column und about 20 rows I need a new form [Form 1] with one character field [Char Field] and in that form 20 requests with different Char Field contents? I connect this form and the character field with the table. Then I have a table with fixed values. This would be ok for my left table. But how do I handle with the right table? My problem is that I want this kind of selection for my ticket-form. That means of course for each ticket different results in the right table. But I don’t know how to link the table with the request-ID of my ticket form. For that I need a three dimensional table, not only a two-one…I think it must be easier but I don’t how to do it. Please, can you help me? Thanks a lot! Regards Christoph Von: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] Im Auftrag von Remedy Gesendet: Montag, 24. Oktober 2011 15:54 An: arslist@ARSLIST.ORG Betreff: Re: kind of selection ** From the help files in developer studio, they have a step by step write up on how move data back and forth between two tables. I found it while searching for details on how to add rows to a table. Sent from my iPhone, so typo's or funky words can and do happen! On Oct 23, 2011, at 9:24 PM, Shafqat Ayaz shafq...@yahoo.com wrote: ** Hi Christoph you can achieve this with a simple flag on the form, say for example a field Show, which has two values, Show 1 and Show 2. The first table shows all entries with the flag set to 1, when you move the items from table one to two, just set the flag to Show 2 and reverse it back when the opposite happens. Set the qualification
Re: Compliance activity for Remedy
H That seems like weird workflow to me... But yes - I would agree - it is minimally debatable what is to be done with inactive accounts. You could scramble a password -- making it unknown to anybody - effectively locking it. But - I did not know it deleting records by removing a User account? Is this ITSM or a custom system ??? -John On Oct 25, 2011, at 4:07 PM, Larry Barnes wrote: ** I would be careful about removing any account that hasn't been active for x number of days. I learned the hard way that deleting an account also deletes the tickets tied to that user. Just my 2 cents worth. Larry B. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, October 25, 2011 1:38 PM To: arslist@ARSLIST.ORG Subject: Re: Compliance activity for Remedy ** Consolidating / merging duplicate groups (same members which are not likely to change) if it appears they were created to serve the same functional purpose, may be a good idea too.. Joe From: John Sundberg Sent: Tuesday, October 25, 2011 4:27 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Compliance activity for Remedy ** I was wondering - what kind of compliance events do people use for Remedy? Some examples: Disable all accounts where password has not changed 120 days Remove all accounts that have not been used 365 days Remove groups - where no members exist. Review mid-tier log files for excessive error messages Review mid-tier directory for non-standard files (possible new .jsp) etc... Thanks, -John -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Compliance activity for Remedy
I was wondering about this too.. I have never seen tickets being deleted as a result of deleting a user account. Loosing access, yes, when the ticket was locked out using 112, but the ticket wasn’t deleted altogether.. Might be some funky customization in my opinion too.. Joe From: John Sundberg Sent: Tuesday, October 25, 2011 6:05 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Compliance activity for Remedy ** H That seems like weird workflow to me... But yes - I would agree - it is minimally debatable what is to be done with inactive accounts. You could scramble a password -- making it unknown to anybody - effectively locking it. But - I did not know it deleting records by removing a User account? Is this ITSM or a custom system ??? -John On Oct 25, 2011, at 4:07 PM, Larry Barnes wrote: ** I would be careful about removing any account that hasn't been active for x number of days. I learned the hard way that deleting an account also deletes the tickets tied to that user. Just my 2 cents worth. Larry B. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, October 25, 2011 1:38 PM To: arslist@ARSLIST.ORG Subject: Re: Compliance activity for Remedy ** Consolidating / merging duplicate groups (same members which are not likely to change) if it appears they were created to serve the same functional purpose, may be a good idea too.. Joe From: John Sundberg Sent: Tuesday, October 25, 2011 4:27 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Compliance activity for Remedy ** I was wondering - what kind of compliance events do people use for Remedy? Some examples: Disable all accounts where password has not changed 120 days Remove all accounts that have not been used 365 days Remove groups - where no members exist. Review mid-tier log files for excessive error messages Review mid-tier directory for non-standard files (possible new .jsp) etc... Thanks, -John -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: AW: AW: kind of selection
My original response for a solution is still the way to go. The help guide in developer studio has already done most of the work for you, telling you step by step what to do. Two table fields all pointing to what ever form your people information sits in. Table 1 shows the list of users to pick from. Table 2 has its qualification set to 1=2 so that does not show any data. In table 1 the user selects a person and hits the add button. Workflow calls the add row process on table 2 and fills in the details of what was selected in table 1. Repeat for each person added. A delete button can remove people from table 2. User can hit the send button which triggers workflow to walk table 2, creating a notification for each person. This should take you about 15 - 20 minutes to build if you are familiar with the development environment. This is the very implementation I used for one of our notification systems. The help document notes in developer studio gives added pointers and other features to use for this process. As Misi stated, this can be done with just the one form. Brent... Sent from my iPhone, so typo's or funky words can and do happen! On Oct 25, 2011, at 2:08 PM, Wagner, Christoph christoph.wag...@ard-stern.de wrote: Hi listers, this is exactly what I want. I have a ticket form, where each request represents a failure in our company, of course (e.g. Server A is down, Server B is down and so on). For each request the user should select some out of 20 people which have to be notified. For this selection I want to use two tables and 2 buttons (add and remove). The left table should contain every people who could be notified (IS state). The right table should contain the people who finally will be notified (target state). Example: |whole distribution list|| choosed distribution list| | -||-| | people A|add| people A| | people B|remove|| | people C||| | ...||| Misi, you said that I can do the whole thing in one form, to be exact: in my ticket-form. As I read through the Form and Application Objects Guide, I found out that tables are created as follows: a column represents any field from my ticket-form and each row represents a request from that form. As you can see out of my example I need one column and at least 20 rows for the tables. For that I need one extra field in my ticket-form, perhaps a character field named distribution list and 20 new requests with the right Email-Address inside this field. And this is where I stuck, what I don't understand!!! I need the requests from the form for my failures (Server A is down...) and I need the requests from the form for the selection itself. But I have to store the information of a failure and the information of the two tables in one request. Am I right with this? Or do I forget anything? This is what I don’t understand - this can't work for me! Thank you very much for your help! Regards, Christoph -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] Im Auftrag von Misi Mladoniczky Gesendet: Dienstag, 25. Oktober 2011 08:56 An: arslist@ARSLIST.ORG Betreff: Re: AW: kind of selection Hi, If you go with my suggestion, you can have the same form underneath both tables. My idea was to MOVE things from left to right. How to do this much depends on what end results your are trying to accompli ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
How I create sample data
I was recently asked how I make my sample data for:
http://demo.kineticdata.com/KinCal/calendar?CalendarName=sample_scheduled_changes
I use Klink as my Remedy API (allows me to use straight Ruby)
https://github.com/kineticdata/klink
Here is my script:
require rubygems
require kinetic/link
$klink_env = demo
# Start date for random
anchor_time = Time.now.to_i # Now
# anchor_time = Time.now.to_i-3*30*24*60*60 # 3 months ago
# anchor_time = Time.now.to_i+3*30*24*60*60 # 3 months from now
# Number of days to randomize over
num_days = 365
max_change_length_hours = 8
min_change_length_minutes = 15
num_changes_to_create = 1000
form = KS_SAMPLE_Change
fm = Hash.new
fm['Request ID'] = 1
fm['Status History'] = 15
fm['instanceId'] = 179
fm['Submitter'] = 2
fm['Create Date'] = 3
fm['Assigned To'] = 4
fm['Last Modified By'] = 5
fm['Modified Date'] = 6
fm['Status'] = 7
fm['Change Name'] = 70050
fm['Category'] = 70051
fm['Type'] = 70052
fm['Item'] = 70053
fm['Risk'] = 70060
fm['Priority'] = 70061
fm['Impact'] = 70062
fm['Group Assigned'] = 70071
fm['Person Assigned'] = 70072
fm['Start Date/Time'] = 70081
fm['End Date/Time'] = 70082
fm['Link Id'] = 70011
fm['URL'] = 700503509
fm['Company'] = 72000
fm['Configuration_Item'] = 72008
fm['Short Description'] = 8
categories = Array.new
categories [Software,Microsoft Office,Install]
categories [Software,Microsoft Office,Remove]
categories [Software,Microsoft Office,Upgrade]
categories [Software,Adobe Reader,Install]
categories [Software,Adobe Reader,Remove]
categories [Software,Adobe Reader,Upgrade]
categories [Hardware,Additional Disk,Install]
categories [Hardware,Additional Disk,Remove]
categories [Hardware,Memory,Install]
categories [Hardware,Memory,Remove]
categories [Database,Admin,Restore]
categories [Database,Admin,Performance Tune]
categories [Database,Admin,Snapshot]
categories [Database,Admin,Failover]
categories [Network,Router,Install]
categories [Network,Router,Remove]
categories [Network,Router,Upgrade]
categories [Network,DNS,Failover]
categories [Network,DNS,Backup]
categories [Network,DNS,Register name]
categories [Network,DNS,Remove name]
categories [SAN,Additional Disk,Install]
categories [SAN,Additional Disk,Remove]
categories [SAN,Admin,Snapshot]
categories [SAN,Admin,Failover]
categories [Mainframe,Batch Job,Start]
categories [Mainframe,Batch Job,Modify]
categories [Mainframe,Maintenance,Snapshot]
categories [Mainframe,Maintenance,Failover]
groups = Array.new
groups [Network,Joe Blow]
groups [Network,Joe Smith]
groups [Network,Mike Jones]
groups [Network,Sally Smythe]
groups [Network,Chris Johnson]
groups [Network,Marie Metso]
groups [Admin,Sally Smythe]
groups [Admin,Chris Johnson]
groups [Admin,Marie Metso]
groups [Desktop,Sally Smythe]
groups [Desktop,Chris Jones]
groups [Desktop,Heather Sterns]
companies = [ACME,Sithco,Big Massive Company,Xyz Enterprises]
configuration_items = [Rabbit,Fox,Squirrel,Eel,Platypus]
risks = [Critical,Minor,Standard]
priorities = [Critical,Minor,Standard]
impacts = [Low,Medium,High]
statuses = [New,Assigned,Fixed,Rejected,Closed]
num_changes_to_create.times do
category,type,item = categories[rand(categories.size)]
configuration_item = configuration_items[rand(configuration_items.size)]
company = companies[rand(companies.size)]
group_assigned,person_assigned = groups[rand(groups.size)]
group_requested, person_requested = groups[rand(groups.size)]
risk = risks[rand(risks.size)]
priority = priorities[rand(priorities.size)]
impact = impacts[rand(impacts.size)]
status = statuses[rand(statuses.size)]
time_offset = rand(num_days*24*60*60)
seconds_long =
[rand(max_change_length_hours)*60*60,min_change_length_minutes*60].max
# The 3600 stuff converts it to an hour start (not 5:33:22 - but just 5)
start_time_seconds = (((anchor_time + time_offset)/3600).to_i)*3600
end_time_seconds = start_time_seconds + seconds_long
start_time = Time.at(start_time_seconds).strftime(%Y-%m-%dT%H:%M:00)
end_time = Time.at(end_time_seconds).strftime(%Y-%m-%dT%H:%M:00)
change_name = #{configuration_item} #{item}
description = Need to #{item} for ci #{configuration_item},
#{person_requested} says this is a #{risk} risk.
change = {
fm['Submitter'] = person_requested,
fm['Status'] = status,
fm['Change Name'] = change_name,
fm['Category'] = category,
fm['Type'] = type,
fm['Item'] = item,
fm['Risk'] = risk,
fm['Priority'] = priority,
fm['Impact'] = impact,
fm['Group Assigned'] = group_assigned,
fm['Person Assigned'] = person_assigned,
fm['Start Date/Time'] = start_time,
fm['End Date/Time'] = end_time,
fm['URL'] = http://www.kineticdata.com;,
fm['Company'] = company,
fm['Configuration_Item'] = configuration_item,
fm['Short Description'] = description
}
puts Kinetic::Link.create(form,change)
end
--
John Sundberg
Save the Date! First
Remedy on Demand - integrations
Does anybody know how integrations are supposed to work with ROD? Meaning - if you have a tool that monitors a log file -- and an error is found and you want to create an Incident - what are your options? Can you use the normal Remedy Java API to do so - or do you have to use WebServices -- or are their other techniques? Also - regarding licensing - can that create -- be done as a Read-Only user? Can that process also update it's own ticket - if the issue is auto-resolved? Is RoD submitter mode locked ? Does BMC charge a fee for allowing the integrations? How is that monitored and supported? Other questions I should be asking ??? -John -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Compliance activity for Remedy
Just a thoughtI believe you can disable the user so that the ID cannot be used and then tickets would not be deleted. I have not heard anything actually deleting the user ID's and it seems like it would not make sense to delete records with the user account c From: Joe Martin D'Souza jdso...@shyle.net To: arslist@ARSLIST.ORG Date: 10/25/2011 06:08 PM Subject:Re: Compliance activity for Remedy Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** I was wondering about this too.. I have never seen tickets being deleted as a result of deleting a user account. Loosing access, yes, when the ticket was locked out using 112, but the ticket wasn’t deleted altogether.. Might be some funky customization in my opinion too.. Joe From: John Sundberg Sent: Tuesday, October 25, 2011 6:05 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Compliance activity for Remedy ** H That seems like weird workflow to me... But yes - I would agree - it is minimally debatable what is to be done with inactive accounts. You could scramble a password -- making it unknown to anybody - effectively locking it. But - I did not know it deleting records by removing a User account? Is this ITSM or a custom system ??? -John On Oct 25, 2011, at 4:07 PM, Larry Barnes wrote: ** I would be careful about removing any account that hasn't been active for x number of days. I learned the hard way that deleting an account also deletes the tickets tied to that user. Just my 2 cents worth. Larry B. From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, October 25, 2011 1:38 PM To: arslist@ARSLIST.ORG Subject: Re: Compliance activity for Remedy ** Consolidating / merging duplicate groups (same members which are not likely to change) if it appears they were created to serve the same functional purpose, may be a good idea too.. Joe From: John Sundberg Sent: Tuesday, October 25, 2011 4:27 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Compliance activity for Remedy ** I was wondering - what kind of compliance events do people use for Remedy? Some examples: Disable all accounts where password has not changed 120 days Remove all accounts that have not been used 365 days Remove groups - where no members exist. Review mid-tier log files for excessive error messages Review mid-tier directory for non-standard files (possible new .jsp) etc... Thanks, -John -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- John Sundberg Save the Date! First Annual KEG - Kinetic Enthusiasts Group Feb. 29th - Mar. 2nd 2012 in Denver CO For more information click here - KEG Kinetic Data, Inc. Building a Better Service Experience Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com _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
