Re: How do I force a filter to only happen after save? i.e. phase 3 ....
Hello Sean, Here is the trick to force a filter to run in phase 3. - On the form on which you want to run the filter, add a display-only field, that will be the trigger indicating it is a phase 3. - Create a dummy form, that will contain temporary values, among which the request ID of the record you want filters to exec in phase 3 - Create a filter link to your first form: this filter makes 2 things: - a push to the dummy form with your entry-id - a Run Process Application-Query-Delete-Entry where you delete the entry you have just created - Create a second filter, attached to the dummy form, that executes on DELETE, and that makes a push to your first form, pushing a value to the display-only form. - Create filters attached to the first form, where the Run if contains 'TR.Display-Only Field' != $NULL$, that you want to run in phase 3. Existing filters should be added a AND TR.Display-Only Field' = $NULL$ in their Run If. In fact the trick here is that filters running a process are executed in phase 3. So the Application-Query-Delete-Entry is executed in phase 3, then it restarts the whole processing in your dummy form, which in turns restarts the processing in your first form. Best regards, The ARSmarts Support Team ARSmarts winner of the Best New Product award at WWRUG11 www.ARSmarts.com On 16 Dec 2011, at 22:51, Garrison, Sean (Norcross) wrote: ** Thanks Chris, My workaround is close to that – add a table field to the “People” form and loop through each record. This will send the “TR” values instead of the “DB” values like I am seeing. Since I am 99% of the way there with what I have I am trying to avoid the rewrite I’m going to try a few more things to see if it resolves my issue. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Danaceau, Chris (CONTR) Sent: Friday, December 16, 2011 3:54 PM To: arslist@ARSLIST.ORG Subject: Re: How do I force a filter to only happen after save? i.e. phase 3 ** How about using the TR.Value which should capture the changed name? -- Chris Danaceau 301-903-8741 Contractor to the Department Of Energy From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Garrison, Sean (Norcross) Sent: Friday, December 16, 2011 2:14 PM To: arslist@ARSLIST.ORG Subject: How do I force a filter to only happen after save? i.e. phase 3 ** I have a workaround for this but I don’t really like it. But here is the problem I am trying to solve: We have a custom crm app that contains people and clients. I am trying to trigger an event for each client related to a person whenever a field is changed on the people record. I have set up a filter that does a push fields to a temp field on a join form to fire the workflow. Here is what is happening: 1.I change the person’s last name. 2. Filter processing begins and filters fire. 3. Filter processing phase 2 begins. 4. I do a push fields to a join form to trigger the event. 5. Filter processing phase 3 begins. Filter Level:0 Number Of Filters:50 Checking CKFR:DM:People-on_Submit/Modify-990-PushContactChangesToPeople-Assn_Join~! (990) -- Passed -- perform actions 0: Push Fields - CKFR:DM:People-Assn_Join deferred to phase 2 Even though I changed the name from “Smith” to “Jones” in my event I get “Smith” because the processing was done in phase 2. I am not pushing the “Last Name” field to the join form because it already has it (that’s why I created the join in the first place). In addition because the “Jones” is in transaction it is not committed in the db yet. I have a workaround but for the sake of learning was wondering if anyone has run into this before and what I could do to resolve it. I have tried the following options: 1.Put a ~! At the end of the filter name. 2. Use “Application-Release-Pending” run process command before the action fires in the filter. 3. Use “Application-Set-Filter-Phasing value where value = “1”. This didn’t work either. 4. Use the “PERFORM-ACTION-APPLY” run process command Thanks, Sean _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: Is there a way to make a Filter API Plugin run in Phase
Hello, There is way to force any set field action in phase 2. This is little cumbersome, but here is the trick: - Create a filter with a push action in a temporary table, immediately followed by a delete action (you delete the record you just created) - Create a filter on the temporary table that runs on Delete, and that will push a temp field in your original table - Create a filter that runs the Set action with Run If set to 'Temp Field' = Yes As the delete action is run in phase 2, the set field action will be run in phase 2 as well. I have been using this trick for months now, and it allowed me to build workflow I had never been able to do before. ARSmarts Support Team ARSmarts, your most useful AR System companion. www.ARSmarts.com On 11 May 2011, at 04:03, Jason Miller wrote: ** Thanks for the tip Jarl! That looks pretty interesting. How long has that been there? Jason On Sat, May 7, 2011 at 8:30 AM, Jarl Grøneng jarl.gron...@gmail.com wrote: If your on 7.6.4 you can use the Alert -- Web service plug-in in AR System. This is asyncron, and will probably do what you want. Page 260 in BMC Remedy Action Request System 7.6.04 Configuration Guide -- J 2011/5/4 Geoffrey Endresen geoffer...@gmail.com: ** We generally use Filter APIs during set fields operations that would be Phase 1. But we have a feature where we want call the Filter API that would run after the ticket is committed to the DB. Any ideas? -- -Geoff Endresen Amazon.com _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Trying to convert Integer field value into Hours divided by 60.
Dear, I would suggest to have two fields for the total time: one for the total number of hours, and one for the total number of minutes. Because the notation 1.01 to represent 1 hour and 1 minute is not clear. The first field (zTmpTotHour) should contain COLSUM(hours)+COLSUM(minutes)/60 The second field (zTmpTotMin) should contain COLSUM(minutes)%60 (the modulo operator) Now if you really want to have a single field containing both, you add a character field, and you concatenate the result: zTmpToHour + . + LPAD(00, zTmpTotMin) Best regards, ARSmarts Support Team ARSmarts, your most useful AR System companion. www.ARSmarts.com On 23 Mar 2011, at 01:12, Jason wrote: ** Off the top of my head... Add 2 real number fields. ztmp_CalculateTime ztmp_CalculateTimeHour Add 1 character field ztmp_CalculateTimeDisplay 1 Active link or filter with 5 set field actions. Set field Action 1, Set ztmp_CalculateTime = $YourSourceField$ Set field Action 2, Set ztmp_CalculateTime = $ztmp_CalculateTime$ / 60 Set field Action 3, Set ztmp_CalculateTimeHour = LEFT($ztmp_CalculateTimeHour$, (STRSTR($ztmp_CalculateTime$, .))) Set field Action 4, Set ztmp_CalculateTime = $ztmp_CalculateTime$ - $ztmp_CalculateTimeHour$ Set field Action 5, Set ztmp_CalculateTimeDisplay = ($ztmp_CalculateTimeHour$ + .) + LEFT(($ztmp_CalculateTime$ * 60), 2) Alternate step 5 as plain text Set field Action 5, Set ztmp_CalculateTimeDisplay = (($ztmp_CalculateTimeHour$ + Hour(s) ) + LEFT(($ztmp_CalculateTime$ * 60), 2)) + Minute(s) Jason From: Jase Brandon jasebran...@gmail.com To: arslist@ARSLIST.ORG Sent: Tue, March 22, 2011 7:18:32 PM Subject: Re: Trying to convert Integer field value into Hours divided by 60. ** Thanks Christie and Fred, I should have mentioned I've already tried using Real, Integer, Char, etc. I should have stated: I want to be able to take a value of 61 in any type field, and convert that somehow to be interpreted as 'Total Time' = 1.01 or One Hour One Minute, etc.. in any format. What would you guys suggest for accomplishing this goal? I'm admittedly tired and frustrated right now. Thanks in Advance... :-) Jase :-) On Tue, Mar 22, 2011 at 6:41 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: Since you are doing integer math it is truncating the remainder You state 'Total Time' is an integer so it can never show 6.08 Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jase Brandon Sent: Tuesday, March 22, 2011 5:17 PM To: arslist@ARSLIST.ORG Subject: Trying to convert Integer field value into Hours divided by 60. ** Hello All, I am writing a custom time tracking app and have been banging my head on the keyboard for a few hours with the below. I have one Active Link and three fields: 'Minutes', 'Hours', and 'Total Time' all are Integer/Numeric Spinner/Display Only. 'Minutes' and 'Hours' are populated by a COLSUM functions on a table field and that part is working great. I want to be able to take 'Minutes' and 'Hours' and populate 'Total Time' field, so a user can do a date range search on Monday-Friday and see if they have entered a full 40 hours. My problem is this: 'Hours' and 'Minutes' both work great and are populated with the correct values from the table field using COLSUM. I have an Active Link with three Set Fields. Action 1: Set Fields 'Hours' = COLSUM(Column38). Action 2: Set Fields 'Minutes' COLSUM(Column39). Action 3: Set Fields 'Total Time' = 'Hours' + ('Minutes' /60) Action 3 is what is causing the pain. Ex Action 1 uses COLSUM and sets the 'Hours' as 4 hours, and that's correct. Action 2 does the same COLSUM function and comes up with 128 Minutes, and that's correct. Action 3 sets 'Total Hours' as 6 Hours with NO minutes. So, the workflow it's picking up the fact that when I divide by 60 in action 3 it works, but... it's not taking into account the other 8 minutes. So the problem is that when 'Hours' = 4, and 'Minutes' = 128... I get the result in 'Total Time' as 6, instead of 6.08. I need the 'Total Time' field to populate with exact Hours/Minutes. The only thing I have come close with if using another Decimal Integer field with a Precision of 2 as 'Total Time'.. but.. that gives me a time of 2.13 for 2 Hours and 8 Minutes, as it should. 13% of 60 is 8. How can I overcome this? I haven't done anything like this in quite awhile and I am admittedly stumped. ARS 7.1 Windows 2003 ITSM 7.0.0.3 Thanks in Advance to All with any advice for me. :-) Cheers, Jase Brandon Senior Remedy Developer Quality Technology Services 300 Satellite Blvd Suwanee, GA 30024 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers
Re: Unable to set up data connection (ARERR 9351)
Hello Peter, We have seen this message many times when there is a reverse proxy between the web browser and the midtier. Is it your case ? Best regards, ARSmarts Support Team ARSmarts, your most useful AR System companion. www.ARSmarts.com On 18 Mar 2011, at 15:26, team.rem...@libero.it wrote: Hello everyone, a group of operators can not navigate on the Service Desk because random warning appears: Unable to set up data connection, Which Is Preventing the application from working Correctly (ARERR 9351). Can you help me? Thank you very much Peter Mid Tier Version 7.1.00 Patch 007 200904060530 Web Server Information Apache Tomcat/5.5.25 Operating System Name Windows 2003 Java Version 1.6.0_23 Definition Change Check Interval(Seconds) 3600 Session Timeout (Minutes) 90 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Configuring email mailbox to send outgoing email messages by using gmail smtp server
You need to activate SSL support in the configuration of the mailbox. The gmail smtp port is 587. You might also have to import the thawte ca server certificate (http://www.verisign.com/repository/roots/root-certificates/PCA-3G2.pem) in the keystore of your java installation. The command to do this on unix is keytool -import -alias webmail -file /tmp/thawte.cer -keystore /usr/java/jre/lib/security/cacerts When prompted for a password, you can try the default password for the keystore :changeit (without the double quotes) Best regards, ARSmarts Support Team ARSmarts, your most useful AR System companion. www.ARSmarts.com On 18 Feb 2011, at 08:33, uday kiran wrote: ** Hi Rajesh Actually I am now working on Demo System ie in my laptop i configured the email system with gmail details any thing else needed to be done thanks Uday On Fri, Feb 18, 2011 at 12:59 PM, Nair, Rajesh SISPL nairraj...@siemens.com wrote: ** Uday, If I am not wrong, you need to get your IP of your email server added to the SMTP server in order to accept mails. My is an configured on external SMTP and using the same process. With Best Regards Rajesh From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of uday kiran Sent: Friday, February 18, 2011 12:54 PM To: arslist@arslist.org Subject: Re: Configuring email mailbox to send outgoing email messages by using gmail smtp server ** Ha ha actually i followed your steps for configuring outgoing mail thanks Uday On Fri, Feb 18, 2011 at 12:38 PM, Nair, Rajesh SISPL nairraj...@siemens.com wrote: ** I need to ask know one thing. How is your existing email configured for outgoing mail??? With Best Regards Rajesh From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of rahul Sent: Friday, February 18, 2011 9:49 AM To: arslist@arslist.org Subject: Re: Configuring email mailbox to send outgoing email messages by using gmail smtp server Hi All, I Tried with port 587 but still not working and I have not enabled SSL. Can any one send all setting if its working at there end. Thanks Regards Rahul From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Boyd, Rebecca Sent: 17 February 2011 07:33 To: arslist@ARSLIST.ORG Subject: Re: Configuring email mailbox to send outgoing email messages by using gmail smtp server ** Try setting email server user to simply username. Drop the @gmail.com. Don't forget to restart the email service after you've made the change. On Wed, Feb 16, 2011 at 2:35 PM, rahul trancefreak1...@gmail.com wrote: ** Hi All, I have configured my remedy email client to send email notifications by using gmail SMTP server but it’s not sending email messages. I have configured AR:Email mailbox configuration with following settings: Mailbox name: AREmail_Out Mailbox Function: Outgoing Email Server Type: SMTP Polling Interval: 10 Email Server Name: smtp.gmail.com Email server user: usern...@gmail.com EmailServer Password: Can anyone let me know why its not working or what can be done to send messages using gmail email server. Thanks Rahul _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are__attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Midtier SRM Application Settings
Dear Larry, I have been confronted to the exact same issue recently. A colleague of mine opened a ticket at BMC, but we have never received a satisfying an answer. So the workaround we put in place: create a filter attached to AR System Email Message. Add a set field action that makes a replace of the bad server name value by the good one in the email body. Best regards ARSmarts support ARSmarts, your most useful AR System companion. www.ARSmarts.com On 05 Feb 2011, at 00:51, Larry Barnes wrote: ** We have users that are getting email notifications concerning tickets that contain a bad url. Example: http://WebServerName/arsys//servlet/ViewFormServlet?form=NTE%3aNotifierserver=AppServerName.thecreek.comeid=NTS03629234 I'm trying to understand what builds this url and have run out of ideas. I've looked at the SRM Application Settings form and I'm seeing possible conflicts between the AR Server Value for MidTier Configuration URL To Request Entry console fields. In the Mid Tier Path field I have the correct name for the Web Server Name. 1. In the AR Server Value for MidTier Configuration it shows: AppServerName.thecreek.com 2. In the URL To Request Entry console field it shows: http://AliasAppServerName.thecreek.com/arsys/forms/AppServerName.thecreek.com/SRS:ServiceRequestConsole/ I can't modify these two fields in this form so I'm asking where this information is pulled from so I can make the necessary changes to get the email notification url's to work. I hope I'm making sense ? Thanks for your time and help. Larry B. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Multi-select field - best method?
Hello, I used to have 2 fields: one read-only without a menu, and another one read-write with a menu, aligned exactly in the same place. Then you put an active link that copies information from the background field to the foreground field when the menu from the background field is selected. This way your end-user can never fill in data directly in the foreground field as it is read-only, but can however select the menu attached to the background field. Best regards, ARSmarts Support ARSmarts, your most useful AR System companion. www.ARSmarts.com On 21 Jan 2011, at 23:03, Grooms, Frederick W wrote: I've done something similar by having a table field. The user selects one (or more) items in the table then a guide walks the table with selected records only and builds a string of the selections. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Guyse, Timothy D. {Tim}(MSFC-IS30)[MITS] Sent: Friday, January 21, 2011 3:49 PM To: arslist@ARSLIST.ORG Subject: Multi-select field - best method? ** Does anyone have a clean way to create a multi-select field in Remedy? There needs to be dozens of possible pre-defined choices but normally only a few will be selected. A drop-down list field only allows a single choice. A character field with a Display Type of Edit allows Menus with Append Items checked allows selection from a list (menu) but it also allows free-formed typing into the field which we don't want. We have a requirement for values to be selected only from a list and items cannot be typed in. Any tips would be greatly appreciated. I'm running on v7.1. Thanks Tim ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: BMC Atrium Core Console ....... Sent Failed error
Dear all, We were confronted to the same issue. It was due to the reverse proxy in front of our internal midtier. The PreserveProxyHost must be set to Yes in the configuration of the proxy. Best regards, ARSmarts Support ARSmarts, your most useful AR System companion. www.ARSmarts.com On 21 Jan 2011, at 15:21, gok's wrote: Doug Blair wrote: Gok's, We have seen this error too. Our configurations may not be the same (ours is unusual, load balancers and firewalls and such). Are you running SSL on the mid-tier(s)? Doug On Jan 18, 2011, at 8:04 PM, gok's wrote: Environment 7.5 Patch 04 DB - SQL Server 2008 SP 2 Hi all, when select the Atrium console from quick links it is throwing an error 'sent failed ' Authentication error as according in to Remedy Knowledge mng they mentioned me to restart the midtier which I did it didn't resolved the issue.can any one help me please. Thanks -- View this message in context: http://old.nabble.com/BMC-Atrium-Core-Console-...-Sent-Failed-error-tp30705467p30705467.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are Doug -- Doug Blair d...@blairing.com +1 224-558-5462 200 North Arlington Heights Road Arlington Heights, Illinois 60004 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are -- View this message in context: http://old.nabble.com/BMC-Atrium-Core-Console-...-Sent-Failed-error-tp30705467p30728996.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: Entry ID Truncated In Notification Email
Filters creating the notification in NTE:SYS-NT Process Control end with `!, so the field id 1 is not known in the notification. The only solution you have to know the value in advance, is to use an SQL statement like SELECT nextid from arschema where name = '$SCHEMA$'. Best regards, ARSmarts Support Team On 18 Jan 2011, at 14:11, Joe Martin D'Souza wrote: It looks like your notification is being sent before the Entry ID is generated by the CAI. This looks like an OTB notification? I haven't worked with that version/patch of ITSM, but it would be worth checking out if there is a known issue and if not, it may be a possible bug. I remember exactly the same bug in ITSM 7.1 pre-patch 4, which was identified as a software bug and corrected using a workflow patch.. Joe -Original Message- From: William Chen Sent: Monday, January 17, 2011 4:10 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Entry ID Truncated In Notification Email ARS 7.5 patch 003 ITSM 7.6 patch 001 Hello listers, When we add the Entry ID field (from NTE:SYS-NT Process Control form) to the body of the email notification in the SYS: Notification Messages form and applicable filters, the full length of the Entry ID does not get captured in the email notification and is cut off after INC. Any other fields we add works fine. Any ideas what the problem could be? Thank you in advance for any help. Test notification: Customer: JOHN SMITH Customer Contact Number: 123-456-7890 Ext. 2011 ProductCategorizationTier1: Application ProductCategorizationTier2: Remedy ProductCategorizationTier3: Issues Entry ID: INC Contact First Name: BOB Contact Last Name: SMITH This is what we get. http://support.yourcompany.com/arsys/forms/arsproduction/HPD:Help+Desk/Default+Admin+View/?eid=INC This is what the link should look like. http://support.yourcompany.com/arsys/forms/arsproduction/HPD:Help+Desk/Default+Admin+View/?eid=INC8155 Regards, Bill _ Bill Chen | APC by Schneider Electric | Information, Process Organization (IPO) | BMC Remedy Operations Phone: +401-789-5735 ext. 2376 | Mobile: +401-486-2328 Email: william.c...@apcc.com | Site: www.apc.com | Address: 132 Fairgrounds Road, West Kingston, RI 02892 *** Please consider the environment before printing this e-mail ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are ARSmarts, your most useful AR System companion. www.ARSmarts.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: RKM 7.5 Installation
Hello, I succeed in installing RKM with tomcat 6. There was a trick: you had to copy the file \lib\catalina.jar found in tomcat installation path into \server\lib\catalina.jar (I had to create the folders), this to make sure that the mid-tier installation program can validate the tomcat installation. Best regards, ARmarts Support ARSmarts, your most useful AR System companion. www.ARSmarts.com On 28 Sep 2010, at 00:23, strauss wrote: I don't think so; the last two times I built RKM 7.5 test servers one used the built-in tomcat 5.5.20, and the other successfully used the tomcat 5.5.28 installed with a 7.5.00.004 mid-tier. I never had much luck getting either mid-tier or RKM to work with a pre-installed tomcat 6.x. Both of those systems are now 7.6.03 so it becomes a moot point since RKM no longer uses tomcat, except as a component of the mid-tier, which now installs a bundled tomcat 6.0.18. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Moe Abdelaziz Sent: Monday, September 27, 2010 8:08 PM To: arslist@ARSLIST.ORG Subject: RKM 7.5 Installation Is RKM 7.5 compatible with tomocat 6.x or 7.x? I have been trying to install RKM 7.5 on tomocat 6 or 7 and so far no luck. Current environment: - Appserver Win 2003, Hammingbird with SearchServer 6.1 with embedded tomocat 5.5, AR 7.5.006 and ITSM 7.6.001 - DBserver SQL 2005 - Webserver Win 2003 hosting the mid-tier running one instance of tomcat 6.x for the mid-tier on port 8080 and another instance of tomcat 7.x for SLM collection points on port 7089. I am trying to find the most efficient type of installation for my environemnt. The RKM Installation Guide says that I can install RKM web app on the mid tier, searchserver on a remote location and AR Integrations for RKM on a nother remote location. I attempted to do that, but RKM doesn't recognize either tomcat 6 or 7. Any thoughts? Thanks, ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: How do I find all the workflows that update a particular field in DB?
Another way to find it is to use ARSmarts (http://www.arsmarts.com). You can even search for any string that update a particular field. With that tool, it is for example possible to search the workflow that sets the status field with value New. Best regards, ARSmarts support team On 21 Jun 2010, at 15:45, Chowdhury, Tauf wrote: I also use Abydos Analyser. It's a 3rd party product but works well in digging into a field, menu, or whatever. Creates reports too. Again, I'm a customer, not the vendor. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Monday, June 21, 2010 5:54 AM To: arslist@ARSLIST.ORG Subject: Re: How do I find all the workflows that update a particular field in DB? Hi, You need to do a Sync Search Database first. It can take some time to complete. Another way is to run ARInside to create local HTML-pages with a very good cross reference for fields and workflow: http://www.arinside.org/ Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * 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. There is no related workflow tab in field properties. How do I see that tab? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Viswa K Sent: Monday, June 21, 2010 11:13 AM To: arslist@ARSLIST.ORG Subject: Re: How do I find all the workflows that update a particular field in DB? ** If you are using Remedy Administrator, Open the form and double click the field ,in the properties window , go to related workflow tab. You will find the active links and filters working on the field you selected. viswa On Sun, Jun 20, 2010 at 8:56 PM, Manzano, Annalyn a-manz...@ti.commailto:a-manz...@ti.com wrote: ** _attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 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 wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: COLCOUNT not working
Hi, You can make a filter with 2 set field actions: - the 1st one is just setting a dummy field with the result of the query you want to count the results - the 2nd one uses the $LASTCOUNT$ keyword or you use a set field with SQL source, and write a query like SELECT COUNT(Field1) FROM table_Name WHERE query Best regards, ARSmarts support team ARSmarts, your most useful AR System companion. www.ARSmarts.com On 10 May 2010, at 17:41, Raj wrote: Hi All, Setting a field with COLCOUNT($COLUMN FIELD ID$) in a Set Fields action of a Filter on Submit. Seems is it not working. Always setting the field to a constant value of 15. Would like to set the field with the number of rows in that particular table. Is the any other way around to do this? How can it be done with the help of Direct SQL ? Please advise. Thanks, Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: COLCOUNT not working
You can make use of the view created by ars. Here is an example: suppose you have a table name HPD:Help Desk, and count the New incidents in it. The sql statement would be SELECT Count(Case_ID) FROM HPD_Help_Desk WHERE Status = 0 Status = 0 because it is the integer corresponding to the New value of the status field Best regards, ARSmarts support team ARSmarts, your most useful AR System companion. www.ARSmarts.com On 10 May 2010, at 18:41, Ravi wrote: ** Thanks for the reply. so, DB ID of Table Name = Table1 DB ID of Column in the table = Column Field ( Only one column in this table ) then my Set Field with SQL Source should look like : SELECT COUNT(Column FIeld) FROM Table1 WHERE query ? Please let me know. Thanks. On Mon, May 10, 2010 at 9:09 AM, ARSmarts Support supp...@arsmarts.com wrote: ** Hi, You can make a filter with 2 set field actions: - the 1st one is just setting a dummy field with the result of the query you want to count the results - the 2nd one uses the $LASTCOUNT$ keyword or you use a set field with SQL source, and write a query like SELECT COUNT(Field1) FROM table_Name WHERE query Best regards, ARSmarts support team ARSmarts, your most useful AR System companion. www.ARSmarts.com On 10 May 2010, at 17:41, Raj wrote: Hi All, Setting a field with COLCOUNT($COLUMN FIELD ID$) in a Set Fields action of a Filter on Submit. Seems is it not working. Always setting the field to a constant value of 15. Would like to set the field with the number of rows in that particular table. Is the any other way around to do this? How can it be done with the help of Direct SQL ? Please advise. Thanks, Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: COLCOUNT not working
You have 2 forms: form1 which contains the field where you want to store the number of records you find in form2. Create a temp field in form1: zTmp Create an optional field in form1 to hold the number of records found in form2: RowCount Create a filter attached to form1: 1st action: Set field from: Form1 No match: Set fields to $NULL$ Multiple match: Use 1st matching Set Field if: the query you had in your table field Set Fields: zTmp -- $1$ 2nd action Set field from: Current Transaction Set Fields: RowCount -- $LASTCOUNT$ Best regards, ARSmarts support team ARSmarts, your most useful AR System companion. www.ARSmarts.com On 10 May 2010, at 18:48, Ravi wrote: ** So, if I use the first way you mentioned: Since, I don't have the dummy field, so do I need to add a temp field to that form. If so then still what should I be using to set the count? As the need is to set count of number of rows in the table to a field.( Table contains only one column but will have multiple rows) and then use $LASTCOUNT$ ( As COLCOUNT is not working) ? Please let me know. Thank you. On Mon, May 10, 2010 at 9:09 AM, ARSmarts Support supp...@arsmarts.com wrote: ** Hi, You can make a filter with 2 set field actions: - the 1st one is just setting a dummy field with the result of the query you want to count the results - the 2nd one uses the $LASTCOUNT$ keyword or you use a set field with SQL source, and write a query like SELECT COUNT(Field1) FROM table_Name WHERE query Best regards, ARSmarts support team ARSmarts, your most useful AR System companion. www.ARSmarts.com On 10 May 2010, at 17:41, Raj wrote: Hi All, Setting a field with COLCOUNT($COLUMN FIELD ID$) in a Set Fields action of a Filter on Submit. Seems is it not working. Always setting the field to a constant value of 15. Would like to set the field with the number of rows in that particular table. Is the any other way around to do this? How can it be done with the help of Direct SQL ? Please advise. Thanks, Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARDBC LDAP
The fact is that I do not have ownership on the LDAP directory, and I have to use the dn. I cannot add any sn or uid, and the process owner will not make the change for me... Kais On 20 Apr 2010, at 17:46, Grooms, Frederick W wrote: I believe someone in the past suggested using uSNCreated as the mapping for RequestID. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky Sent: Tuesday, April 20, 2010 10:20 AM To: arslist@ARSLIST.ORG Subject: Re: ARDBC LDAP I have not done this recently. My experience was that you needed to add a unique attribute to the directory that could be used to retrieve the actual record. If you are only doing a table-refresh to load data, you will not need this, as the system only performs a single search. If you are using set-fields or push-fields, the unique max-15-character-key is needed. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of ARSmarts Support Sent: Tuesday, April 20, 2010 8:44 AM To: arslist@ARSLIST.ORG Subject: ARDBC LDAP Hi listeners, Has anybody ever been able to use the ARDBC LDAP plugin mapping the request id to the dn ? I succeeded with mapping to attribute where length is less than 15 characters, but I can't succeed with longer strings, while it is documented as being supported. I am using ARS 7.5 patch 3. Thanks for your help. Kais ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
ARDBC LDAP
Hi listeners, Has anybody ever been able to use the ARDBC LDAP plugin mapping the request id to the dn ? I succeeded with mapping to attribute where length is less than 15 characters, but I can't succeed with longer strings, while it is documented as being supported. I am using ARS 7.5 patch 3. Thanks for your help. Kais ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: OOB changes
** Hi,What I usually do for that purpose it to make a complete OOTB install of ITSM, extract the definition and compare it with the definition of the production server. I had to make this operation so often that I have a definition file for ITSM 7.5, for ITSM 7.1 and for ITSM 7.0 (with different level of patches)Of course, I run the comparison with ARSmarts Navigator.Best regards,ARSmarts supportOn 09 Apr 2010, at 16:20, Barb Wagner wrote:** Hi Danny - What a clever idea! In all my years of working with patches ... and trying to figure out the differences have never thought of that - VERY CLEVER Barb Wagner Remedy Architect IBM Global Services (612) 397-2955 Tie Line 608-1958 bar...@us.ibm.com graycol.gifDanny Kellett ---04/07/2010 03:42:04 PM---** Hi, Danny Kellett danny.kell...@strategicworkflow.com Sent by: "Action Request System discussion list(ARSList)" arslist@ARSLIST.ORG 04/07/2010 03:41 PM Please respond to arslist@ARSLIST.ORG ecblank.gif Toecblank.gif arslist@ARSLIST.ORG ecblank.gif ccecblank.gif ecblank.gif Subjectecblank.gif Re: OOB changes ecblank.gifecblank.gif ** Hi, Not to answer your question but what I normally do, and you could going forward, is to create a different user, give them admin rights, install the patch etc then remove the user. Then you can query by user name. This gives you a report of whats changed. E.g. for the CMDB patch upgrade, I created a user called cmdbp3 then when finished I can a query. Regards Danny From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Kelley Sent: 07 April 2010 20:52 To: arslist@ARSLIST.ORG Subject: OOB changes Hi List Does anyone have a tool or know of a tool that does an audit of your Remedy Server that gives you all of the "Out of the Box" workflow that has been changed. ARS 7.1 patch 9 ITSM 7.0 patch 6 Oracle 10g JK * This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_inline: pic14669.gif
Re: Anyone know how to get the soap request or contents into a log when consuming an external web service?
Hello Ben, I can confirm you that the plugin log contains the xml sent to external web services. Best regards On 25 Mar 2010, at 15:15, Ben Chernys wrote: ** ARS 7.5 on Windows 2007 svr p1 on VM ITSM 7.6 MS SQL (G_d knows what version) Anyone know how to get the soap request or contents into a log when consuming an external web service? Read the book which said you should be able to see it in the PLGN logs but no such luck. All logging set to max (plugin to 100, mid-tier to finest. Midtier logging seems to handle only ARS published web services. Saw some apache axis lines in a log but not relevant. I want to see what I sent an external system when I consume their web service. Thanks a bunch! Ben _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ARSmarts, your most useful AR System companion. www.ARSmarts.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Anyone know how to get the soap request or contents into a log when consuming an external web service?
I must admit it is on even older version (5.1.2) with plugin-log-level set to 100. On 25 Mar 2010, at 15:54, Grooms, Frederick W wrote: ** Set the Plugin log to 400 in the config Plugin-Log-Level:400 It works on my 7.1.0 on Solaris Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ben Chernys Sent: Thursday, March 25, 2010 9:15 AM To: arslist@ARSLIST.ORG Subject: Anyone know how to get the soap request or contents into a log when consuming an external web service? ** ARS 7.5 on Windows 2007 svr p1 on VM ITSM 7.6 MS SQL (G_d knows what version) Anyone know how to get the soap request or contents into a log when consuming an external web service? Read the book which said you should be able to see it in the PLGN logs but no such luck. All logging set to max (plugin to 100, mid-tier to finest. Midtier logging seems to handle only ARS published web services. Saw some apache axis lines in a log but not relevant. I want to see what I sent an external system when I consume their web service. Thanks a bunch! Ben _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question on H and T tables in Remedy Schema
The H table contains the status history data. Best regards ARSmarts, your most useful AR System companion. www.ARSmarts.com On 25 Mar 2010, at 16:16, Jim Coryat wrote: ** I have a quick question on the tables in the Remedy schema. I know that the T prefixed tables are the actual form data. What function do the H prefixed tables provide? Our EIE:Log form has over 60 million rows. We want to truncate the table and them implement purging for the form. Thinking we can implement the purging and have it purge the rows is not realistic. However I don’t want to do this and have some other dependent forms start having issues because of this action. Jim Coryat Micron Technology Inc. ITIL v2 Practitioner Certified _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Filter in BMC Remedy Administrator
And a small suggestion to make you run if shorter: ( 'Support Group Name' = Command group ) AND ( 'Support Group Name' != 'DB.Support Group Name') Jean-Louis Halleux ARSmarts sa On 30 Jan 2010, at 12:12, Frank Caruso wrote: ** The user names need to be separated by Carriage returns not commas. However, a better a way to do this is to user the Support Group ID for the Command Group. Remedy will evaluate that value and send the notification to all members of the group. Check out the 7.1 Workflow Objects guide doc, page 63. HTH On Sat, Jan 30, 2010 at 1:56 PM, ITN (Amanullah Bashir Ahmed) ahmed...@emiratesnbd.com wrote: ** Hi there, I made one filter in BMC Remedy Administrator, the purpose of filter is when new Infrastructure change is assigned to group “Command group”, the email notification should go to only members of Command group. The filter’s details are given below Form Name: CHG: Infrastructure Change Run if: ( 'TR.Support Group Name' != $NULL$ ) AND ( 'TR.Support Group Name' = Command group ) AND ( 'TR.Support Group Name' != 'DB.Support Group Name') Execute on: Submit Modify When click on If Action(1) Notify Text: You have been selected as a change assignee for change ID $Infrastructure change ID$ User name: Jhon115, Geji234, Geroge345, Sunil111, Madhem101 When I am creating new Infrastructure change, the email notification message should go to “Command group” members those are Jhon115, Geji234, Geroge345, Sunil111, Madhem101 but email notification message is going to all users. Which mistake I am doing in filter. Can anybody help me about this issue. Thanks Regards Amanullah Software Consultant IT Application and Enterprise Management DISCLAIMER:This e-mail message including any of its attachments is intended solely for the addressee(s) and may contain privileged information. If you are not the addressee or you have received this email message in error, please notify the sender who will remove your details from its database. You are not authorized to read, copy, disseminate, distribute or use this e-mail message or any attachment to it in any manner and must delete the email and destroy any hard copies of it. This e-mail message does not contain financial instructions or commitments of any kind. Any views expressed in this message are those of the individual sender and do not necessarily reflect the views of Emirates NBD PJSC, or any other related subsidiaries, entities or persons. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SLA time Calculations
Hi, I think that if you do not have the SLA module, you will have to track in a separate form all the status changes, and time when it changes, and elapsed time between status transitions. You will then be able to compute what you need. This is not so complicated: one form, one or 2 filters to push into it, and 2 or 3 filters to make the computation. Best regards, Jean-Louis Halleux www.arsmarts.com On 19 Oct 2009, at 20:17, Brittain, Mark wrote: ** Hi All, Does anyone have a good way of tracking the work time of an issue? In my case the issue could be in a Status of Work in Progress, Pending or Closed. What I need to be able to determine is Closed- time minus Create Date minus Pending-time = Time-worked Status History does not work because the Status could go back and forth between Work in Progress and Pending several times during the life of the issue. Suspect this will get complicated but would like to keep this as simple as possible. ARS 6.3 patch 20 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.com Today. This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Reported date
Hi, In order to see the whole list of filters or active links or escalations that set the Reported Date or the z1D Ticket Start Time, you should have a look at ARSmarts, which will give you all XRefs to those fields. Best regards, Jean-Louis Halleux www.arsmarts.com On 19 Oct 2009, at 20:34, Ramey, Anne wrote: It doesn't appear to be that way in ITSM 7.x...The only filter that sets it that I can find is HPD:INC:SetReportedDate_010, which sets it if ('Reported Date' = $NULL$) OR (('Reported Date' != $NULL$) AND ('Reported Date' 'z1D Ticket Start Time')). Then it sets it to 'z1D Ticket Start Time'...but I can't find a filter or escalation that sets 'z1D Ticket Start Time'. Anne Ramey -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Charles Baldi Sent: Friday, October 16, 2009 4:00 PM To: arslist@ARSLIST.ORG Subject: Re: Reported date I think that ReportedDate has workflow that sets it based on Reported Source. I don't know if that gets called via the interface create form or not but it is a place to look. Regards, Chuck Baldi On 10/16/09, Ramey, Anne anne.ra...@its.nc.gov wrote: I'm seeing an issue where sometimes, when a ticket is created through the HPD:IncidentInterface_Create, the Reported Date is not getting set. It's not on every ticket created this way, just some of them. Has anyone else seen this? Anne Ramey E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties by an authorized state official. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- Sent from my mobile device ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties by an authorized state official. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Indexing help
Hi Mark, You are right. If you create an index on ABC, and search on BC, the query will not use an index. If you search on A, AB or ABC, you query may use the index. The 3 indexes you create are not redundant, but I would not do so. I would reverse the order of your first index (Assigned Person, Assigned Group, Status). This way you do not need to create the index 3. You must always remember that you can search on fields in the order they are defined in the index. Jean-Louis Halleux www.arsmarts.com On 17 Sep 2009, at 17:30, Brittain, Mark wrote: ** Good morning, I think I inherited a mess and need some help with indexing. If I have an index Status Assigned Group Assigned Person And the query is Assigned Group and Assigned Person does the index get ignored because Status was not used? What if I have similar indexes like these Index 1 Status Assigned Group Assigned Person Index 2 Assigned Group Index 3 Assigned Person Are these redundant? Also is there and good information out there that really gets into the nuts and bolts of indexing? Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.com Today. This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Push Fields creating loop
Hi Akos, First possibility: You can add a checkbox display-only field with a value of 'No'. The filter on form A runs only if the checkbox is $NULL $. And on the filter on form B, in the push field action, you push the value 'No' in the checkbox field. Second one: The filter on Form A should only be executed on Submit, not on Modify. Jean-Louis Halleux ARSmarts sa http://www.arsmarts.com On 15 Jul 2009, at 13:41, Elry wrote: Hi Akos... That kind of push can easily loop on you... I would suggest doing one of the following: 1) Using LastId keyword to locate the ID (providing that this is the only creation initiated by this process). 2) Put a GUID on form A that gets pushed to form B. Then you can fire another filter that looks up the GUID on form B to return the form Request ID Hope this helps. On Jul 15, 5:08 am, Akos Malindovszky jes...@vipmail.hu wrote: Hi all! 'm having a problem with the Push fields action in a Filter. I have two forms A B. When a ticket is created on A that matches certain qualifications, then a new ticket is created on form B via a at Push field action in a filter. I want to store the request-ID of the new ticket on form A also, so there is a filter running on submit on B which pushes the info back to the matching request on A. My problem is that when the ID is pushed back from B to A, then A starts running all the filters again triggered by this modification. Is there any way to avoid this step. Can I push a value to a form without triggering a modification? Thank you in advance. best regards, Akos Malindovszky Helpdesk Administrator -- View this message in context:http://www.nabble.com/Push-Fields-creating-loop-tp24494356p24494356.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: SRM through the thick client
Hi, The Remedy User tool connects directly to the Remedy Mid-Tier in case of SRM. It caused me many issues in case of multiple mid-tiers. Best regards, Jean-Louis Halleux ARSmarts sa http://www.arsmarts.com On 14 Jul 2009, at 16:21, lee wrote: Hi, Question regarding SRM 2.1 through the user tool. We have a citrix server with Remedy 7.1 User tool installed. However, it is restricted to only 1 port that we designated for Remedy. eg 999 or something. It can access AR server and do everything in Remedy except SRM. SRM 2.1 has the midtier part load the Request Entry screen. However, does the Remedy client use midtier on the Citrix box and port 80 and talk directly to midtier server? Or does it use the AR server to pull that Request Entry screen? If the former, then I guess I need to also open port 80. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Anybody able to export all ITSM 7.x definitions with DevStudio?
Hi, A tool called ARSMarts can export the full definitions from ITSM for free very easily. You must register on the web site (www.arsmarts.com) to download it, and it contains many other (payable) functionalities. Best regards, Jean-Louis Halleux On 15 Jun 2009, at 20:12, Guillaume Rheault wrote: ** great suggestion, I'll try that out. So are you able to export all the ITSM 7.x definitions in one operation? Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Lyle Taylor Sent: Mon 06/15/09 2:09 PM To: arslist@ARSLIST.ORG Subject: Re: Anybody able to export all ITSM 7.x definitions with DevStudio? Have you tried adjusting the JVM options for DevStudio to increase the amount of heap allocated to it? I had to do this to work around an error I was getting a while back. Go to the installation directory for DevStudio (maybe C:\Program Files\BMC Software\ARSystem \DeveloperStudio) and open devstudio.ini. Change the -Xmx512m line to something more like -Xmx1536m. Lyle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Guillaume Rheault Sent: Monday, June 15, 2009 12:03 PM To: arslist@ARSLIST.ORG Subject: Anybody able to export all ITSM 7.x definitions with DevStudio? ** This is very frustrating and something that I hoped it was going to be addressed in DevStudio. I cannot export all the ITSM 7.5 definitions with DevStudio in one export operation. I cannot even export all the forms in one operation with DevStudio, I get an out of memory error, that I attached. My PC has 4 GBs of memory with 8 processors, so it's definitely not a resource issue on my side, it's probably the DevStudio JRE that ran out of memory. I really hate it not to be able to do a full definitions export in one shot: you have to split the export in multiple chunks, which makes the management of the def files much harder, it more much more time consuming because of you have to monitor the exports and initiate a new one once the previous completed, etc. When is BMC going to fully address and correct this?? It seems to me the backup of the application code at the application level is ESSENTIAL. I was really hoping that DevStudio would fix this very significant problem, but it it did not happen. How can you do effective release management and application version control if you cannot even efficiently and effectively export the definitions?? For what it's worth, we have ITSM 7.5.1, where the app server is running on Windows 2003 and the database is remote, it's 10gR2 running on Solaris 10. My PC has Windows XP. Has anybody been successful in exporting all the defs of ITSM 7.5 in one export operation? -Guillaume _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: how to trigger a filter guide from an AL
- Create a display-only field on the form where you filter guide is attached - Create a filter that starts when this display-only field is filled in, and that calls your filter guide - Create an AL that pushes a value to this display-only field That should do the trick. Jean-Louis Halleux ARSmarts sa http://www.arsmarts.com On 07 May 2009, at 11:51, Remedy Maniac wrote: dear experts, I have a Filter guide which sends an email out at some point. I have a AL on Display, which filters do not do, and which cannot send emails out. So I'd like this AL firing the Filter Guide so my email will be sent out. Is there a way to perform this? As usual, there is always a solution to any problem. Thanks in advance. Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: AD Account Disabled Flag in Remedy?
First (1203920 AND 2) == 2, not 1. To test if your account is disabled, the correct test is (1203920 AND 2) 0 If you want 1 for disabled and 0 for enabled, you can run the following test: (1203920 \ 2) % 2 == 1 indicates that the account is disabled where \ is the entire division, and % is the modulo Jean-Louis Halleux ARSmarts sa www.arsmarts.com On 04 May 2009, at 19:45, Mark Lev wrote: The AD Attribute userAccountControl stores multiple bit values for AD user accounts. The formula to determine if the user is disabled is : userAccountControl AND 2 For example; userAccountControl = 1203920 1203920 AND 2 = 1 then the account is disabled. Any know how we can calculate this in Remedy? The bottom line is we want to know if they are disabled, so if anyone has another way of doing it, that would work for us. Thanks, Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: how to define access to Assignee Group
Hi, The field ID 112 should contain a group name, not a login name. In your case, you should create a group for each user. Best regards Jean-Louis Halleux www.arsmarts.com On 07 Apr 2009, at 15:33, Remedy Maniac wrote: dear listers, I am trying to build an access based on individual basis. i.e: the user can access any ticket as soon as s/he is either the Submitter or in the CC list field found in the ticket itself (= there is a character field used to cc some people) So i created a character field with id 112 named Assignee Group I've built a workflow which reads the User form and set the field 112 to the login name of the $USER$ the Request-ID field is readable by the field id 112 This later is correctly updated base on the login found in the User form But then I keep getting the following message: You cannot translate the group name in the Group List or Assignee Group Field. : Assignee Group (ARWARN 9305) Can anyone help on solving this issue? Thank you Serouche PS: ARS 6.00.01 with Mid-tiers 6.3 on Solaris 8 with Sybase 12.5.3 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Am I making this more difficult than it is?
Hi Lisa, I think you need to create a filter with a Set Field action that will check the condtion hereafter, and a second one that will raise an error if the first filter found a matching record. Let's assume that your form is called Sample You create a display-only field on that form called zTmpEntryID You create a first filter on submit and on modify. The Run If is empty. It contains one Set Field action From: Sample Set If: ('Start Date' = $Start Date$ AND 'End Date' $Start Date$) OR ('Start Date' $End Date$ AND 'End Date' = $End Date$) If No Match = Set Field To Null If Multiple Match = Use First Matching zTmpEntryID - $1$ The second filter just displays an error message in case of zTmpEntryID is not null. Hope this helps, Jean-Louis Halleux Remedy Expert Developer ARSmarts sa www.arsmarts.com On 03 Apr 2009, at 20:11, Kemes, Lisa wrote: ** I have a record with a Start Date field of: 4/12/2009 12:00:00 AM and an End Date field of: 4/30/2009 12:00:00 AM. If someone were to create another record with a Start Date of: 4/1/2009 12:00:00 AM and an End Date field of 4/15/2009 12:00:00 AM, I want it to error because this would overwrite (not really) the other record. This is for my On Call system. Therefore, if these 2 records are allowed to exist, you would have more than one person on call (as a primary) for the same dates (4/12, 4/13, 4/14 and 4/15). Hope this makes sense! I actually have these records on a table and I would like to walk through the table to make sure the records with the Start Date field: 4/1 and End Date field: 4/15 does not get created. AR System 7.0 Oracle 10g Windows 2003 Server Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Panacea Workflow Studio (UNCLASSIFIED)
Hi Timothy, I have some experience with that tool, and I must admit it is a good tool, though the license policy is quite expensive, and the tool is rather slow for some aspects. That is why our company has started designing its own tool. Today, we have a running product available for much less than Workflow Studio, and I invite you to check our web site at www.arsmarts.com to request an evaluation license (either for the stable version, or the beta version). Best regards, Jean-Louis Halleux ARSmarts.com On 30 Mar 2009, at 21:30, Hulmes, Timothy W Mr CTR USA IMCOM wrote: Classification: UNCLASSIFIED Caveats: NONE We are looking at purchasing Panacea Workflow Studio. Does anyone have any experience with what this software has to offer? Timothy W. Hulmes Remedy Administrator Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Help with web services
What I am sending is valid, I am precisely using soapUI to check it. I am not the owner of the web service, only the consumer. And it works from soapUI, but not from a Remedy filter. Jean-Louis On 09 Feb 2009, at 16:20, Grooms, Frederick W wrote: ** I’m not sure if what you are wanting to send is actually valid. You are saying getIncident has a namespace and then you are saying the fields have a namespace of empty string. Try getting the free tool soapUI http://www.soapui.org and see what it tries to send when you give it the WSDL. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of ARSmarts Support Sent: Friday, February 06, 2009 12:30 AM To: arslist@ARSLIST.ORG Subject: Help with web services Hi, I am trying to consume a web service from a Set Field action in a filter. The xml that Remedy should send to my web service is the following: soap12:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema- instance xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:soap12=http://www.w3.org/2003/05/soap-envelope soap12:Body getIncident xmlns=http://portimaincidentservice.soap.iss.studioworx.be/ username xmlns=Login/username password xmlns=Password/password id xmlns=1/id /getIncident /soap12:Body /soap12:Envelope However, Remedy generates an XML like this ?xml version=1.0 encoding=utf-8? soap12:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema- instance xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:soap12=http://www.w3.org/2003/05/soap-envelope soap12:Body getIncident xmlns=http://portimaincidentservice.soap.iss.studioworx.be/ usernameLogin/username passwordPassword/password id1/id /getIncident /soap12:Body /soap12:Envelope And of course, the set field fails. Does anybody have an idea how I can force Remedy to put the xmlns= attribute in the autogenerated soap request ? Thanks a lot. Jean-Louis Halleux -- ARSmarts, your most useful AR System companion. www.ARSmarts.com __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Help with web services
Hi, I am trying to consume a web service from a Set Field action in a filter. The xml that Remedy should send to my web service is the following: soap12:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema- instance xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:soap12=http://www.w3.org/2003/05/soap-envelope soap12:Body getIncident xmlns=http://portimaincidentservice.soap.iss.studioworx.be/ username xmlns=Login/username password xmlns=Password/password id xmlns=1/id /getIncident /soap12:Body /soap12:Envelope However, Remedy generates an XML like this ?xml version=1.0 encoding=utf-8? soap12:Envelope xmlns:xsi=http://www.w3.org/2001/XMLSchema- instance xmlns:xsd=http://www.w3.org/2001/XMLSchema; xmlns:soap12=http://www.w3.org/2003/05/soap-envelope soap12:Body getIncident xmlns=http://portimaincidentservice.soap.iss.studioworx.be/ usernameLogin/username passwordPassword/password id1/id /getIncident /soap12:Body /soap12:Envelope And of course, the set field fails. Does anybody have an idea how I can force Remedy to put the xmlns= attribute in the autogenerated soap request ? Thanks a lot. Jean-Louis Halleux -- ARSmarts, your most useful AR System companion. www.ARSmarts.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are