Re: Cleaning Special Characters from a Character Field
A quick search in Google will find some SQL functions that strip the
unwanted characters.
Might this suit your skillset better than using a Java plugin?
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jeff Lockemy (QMX Support
Services)
Sent: 16 May 2012 21:25
To: arslist@ARSLIST.ORG
Subject: Re: Cleaning Special Characters from a Character Field
**
Thank you Axton! We'll give it a go.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Wednesday, May 16, 2012 4:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Cleaning Special Characters from a Character Field
** Here is a very simple Java plugin to get you started (38 lines of code).
The plugin accepts 2 parameters; a regex and a value, and returns true/false
on whether the string conforms to the regex. You can extend or modify this
to perform a conversion instead of doing a comparison.
import java.util.ArrayList;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import java.util.regex.PatternSyntaxException;
import com.bmc.arsys.api.ARException;
import com.bmc.arsys.api.Value;
import com.bmc.arsys.pluginsvr.plugins.ARFilterAPIPlugin;
import com.bmc.arsys.pluginsvr.plugins.ARPluginContext;
public class Regex extends ARFilterAPIPlugin {
/**
* @param context ARPluginContext provided by the plugin server.
* @param arg1 Input parameters:
* 1 - Regular Expression
conforming to java.util.regex
* 2 - String to evaluate
* @return Boolean, does the string conform to the regular
expression
* 0 - False
* 1 - True
* @see java.util.regex.Pattern
* @exception ARException handled by plugin server
* @since 1.0
*/
public ListValue filterAPICall(ARPluginContext context,
ListValue arg1)
throws ARException {
// Create List of Values to hold response
ListValue results = new ArrayListValue();
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Regex Plugin Called with parameters: + arg1.get(0).getValue());
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Pattern: + arg1.get(0).getValue());
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Value:+ arg1.get(1).getValue());
// set up the pattern
Pattern pattern = null;
try {
pattern =
Pattern.compile(arg1.get(0).getValue().toString());
} catch (PatternSyntaxException e) {
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
PatternSyntaxException at + e.getIndex());
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Pattern: + e.getPattern());
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Description: + e.getDescription());
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Message: + e.getMessage());
throw e;
}
// set up the value
Matcher value =
pattern.matcher(arg1.get(1).getValue().toString());
// test the value against the pattern and get the
result
boolean b = value.matches();
int result = 0;
if (b == false)
result = 0;
if (b == true)
result = 1;
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Result:+ result);
results.add(new Value(result));
return results;
}
}
On Wed, May 16, 2012 at 2:10 PM, Jeff Lockemy (QMX Support Services)
jlock...@gmail.com wrote:
**
Thanks for the input guys.
In reference to Axton's suggestion - I'm certainly not a Java guy, but might
be able to find some internal resources to tap into on that front. In the
meantime, Jason's suggestion of a VB or batch file script might be good
Re: Cleaning Special Characters from a Character Field
Hi,
You can do this with normal filters as well, even if it will be a little
bit slower.
I like the Service functionality, and would create a simple
Display-only-form with two fields Dirty and Clean and two filters:
FLTR 1:
Run If: ('Dirty' LIKE [A-Za-z 0-9.,\?!#$%^*()_=+/;:|}{[`~-]% OR
'Dirty' LIKE ]%)
Set-Fields: Clean = $Clean$ + LEFTC($Dirty$, 1)
FLTR 2:
Run If: ('Dirty' LIKE _%)
Set-Fields: Dirty = SUBSTRC($Dirty$, 1)
Goto: 1
Just call your Service with Dirty as input and Clean as output.
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.
Thank you Axton! We'll give it a go.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Wednesday, May 16, 2012 4:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Cleaning Special Characters from a Character Field
** Here is a very simple Java plugin to get you started (38 lines of
code).
The plugin accepts 2 parameters; a regex and a value, and returns
true/false
on whether the string conforms to the regex. You can extend or modify
this
to perform a conversion instead of doing a comparison.
import java.util.ArrayList;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import java.util.regex.PatternSyntaxException;
import com.bmc.arsys.api.ARException;
import com.bmc.arsys.api.Value;
import com.bmc.arsys.pluginsvr.plugins.ARFilterAPIPlugin;
import com.bmc.arsys.pluginsvr.plugins.ARPluginContext;
public class Regex extends ARFilterAPIPlugin {
/**
* @param context ARPluginContext provided by the plugin
server.
* @param arg1 Input parameters:
* 1 - Regular Expression
conforming to java.util.regex
* 2 - String to evaluate
* @return Boolean, does the string conform to the regular
expression
* 0 - False
* 1 - True
* @see java.util.regex.Pattern
* @exception ARException handled by plugin server
* @since 1.0
*/
public ListValue filterAPICall(ARPluginContext context,
ListValue arg1)
throws ARException {
// Create List of Values to hold response
ListValue results = new ArrayListValue();
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Regex Plugin Called with parameters: + arg1.get(0).getValue());
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Pattern: + arg1.get(0).getValue());
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Value:+ arg1.get(1).getValue());
// set up the pattern
Pattern pattern = null;
try {
pattern =
Pattern.compile(arg1.get(0).getValue().toString());
} catch (PatternSyntaxException e) {
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
PatternSyntaxException at + e.getIndex());
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Pattern: + e.getPattern());
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Description: + e.getDescription());
context.logMessage(context.getPluginInfo(),
com.bmc.arsys.pluginsvr.plugins.ARPluginContext.PLUGIN_LOG_LEVEL_INFO,
Message: + e.getMessage());
throw e;
}
// set up the value
Matcher value =
pattern.matcher(arg1.get(1).getValue().toString());
// test the value against the pattern and get the
result
boolean b = value.matches();
int result = 0;
if (b == false)
result = 0;
if (b == true)
result = 1;
context.logMessage(context.getPluginInfo(),
ARSList
Hi Allen, He can subscribe to the arslist by send an email to this email address arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG with subject SUSCRIBE and communicate with the Remedy community. Regards Francois Blue Turtle Technologies (Pty) Limited | Reg. no.: 2003/002610/07 | http://www.blueturtle.co.za Gauteng : Tel: +27 (0)11 206 5600 | Fax: +27 (0)11 206 5606 | Midridge Office Estate, International Business Gateway, cnr New Road Sixth Street, Midrand, 1685 | P O Box 31331, Kyalami, 1684 Western Cape: Tel: +27 (0)87 721 1874 | Fax: +27 (0)21 552 7764 | Unit E6, Century Square, Heron Crescent, Century City, Cape Town, 7446 DISCLAIMER: This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of Blue Turtle Technologies (Pty) Ltd. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you received this email in error, please immediately notify the sender. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARSList
Hi all; Sorry I send this email out by mistake ! Francois From: Francois Seegers Sent: Thursday, May 17, 2012 11:21 AM To: arslist@ARSLIST.ORG Subject: ARSList Hi Allen, He can subscribe to the arslist by send an email to this email address arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG with subject SUSCRIBE and communicate with the Remedy community. Regards Francois Blue Turtle Technologies (Pty) Limited | Reg. no.: 2003/002610/07 | http://www.blueturtle.co.za Gauteng : Tel: +27 (0)11 206 5600 | Fax: +27 (0)11 206 5606 | Midridge Office Estate, International Business Gateway, cnr New Road Sixth Street, Midrand, 1685 | P O Box 31331, Kyalami, 1684 Western Cape: Tel: +27 (0)87 721 1874 | Fax: +27 (0)21 552 7764 | Unit E6, Century Square, Heron Crescent, Century City, Cape Town, 7446 DISCLAIMER: This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of Blue Turtle Technologies (Pty) Ltd. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you received this email in error, please immediately notify the sender. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ITSM 7.6.04 - ARS 7.6.04.03 $\TIME$
Two things: 1.- I think that is not a good idea to set time variables with active links, since you depend on the client time configuration. 2.- When setting the time of a field at submit I prefer to copy the core field submit date, instead of using the $TIME$ keyword. Regards, Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, May 15, 2012 at 5:53 PM, Sanford, Claire claire.sanf...@memorialhermann.org wrote: ** I figured out the problem. I needed to have this set in a character field, not a “Time” field. ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Wirasat Siddiqi *Sent:* Monday, May 14, 2012 3:24 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ITSM 7.6.04 - ARS 7.6.04.03 $\TIME$ ** ** ** I have a time field with default value of $Time$ and on submit it enters the time correctly. We are using AR Server 7.6.04 SP1 with same version of ITSM. Thanks, Wirasat From:Sanford, Claire claire.sanf...@memorialhermann.org To:arslist@ARSLIST.ORG Date:05/14/2012 03:45 PM Subject:ITSM 7.6.04 - ARS 7.6.04.03 $\TIME$ Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG -- I have a Time field that I want set when a ticket is submitted. I had $TIME$ in the field and when it was submitted it was supposed to put the time of day in that field. Out of 20 tickets, only 1 will have the correct time in it. All the rest will have 12:00:05 PM in them. I created an AL that was supposed to set the filed on Submit (and tried After Submit) with the current $TIME$ value and it is doing the same thing. I created a Filter that was supposed to set the filed on Submit with the current $TIME$ value and it is doing the same thing. Any ideas? It worked in my old 6.3 version. ITSM 7.6.04.02 ARS 7.6.04.03 Claire ___ 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_ _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 image002.jpgimage001.jpgimage004.jpgimage003.jpg
Re: Adding HR Department to ITSM Application using Multi-tenancy
Hi Terry Brian, Can you tell me what field 6969 is? I've looked in the docs and cannot find anything. I know field 112 is assignee group but what is 6969? Thanks, Lynn From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terry Bootsma Sent: Wednesday, May 16, 2012 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Adding HR Department to ITSM Application using Multi-tenancy ** Similiar to what Brian mentions below, I think you have no other option than writing your own filter to overwrite the row level access fields during certain key incident events. However, you will also have to determine the business rules as to when you want to overwrite the access, and when you want to restore it. For example, (a) When HR people submit incidents, do you want all incidents to be restricted to HR for the entire incident lifecycle? (b) When other people submit incidents and they get assigned to HR, will this incident then only be viewable by HR? What about the incident owner? Will they still be able to view the incident? (c) Will HR ever assign the incident back to the owner or other groups during the incident lifecycle (ex. incorrectly assigned, minor work)? If so, you will have to restore the original incident permissions and invoke workflow to ensure that this is reset. If reset , how do you handle viewing any information by other groups that may have been entered by HR? This will have to be addressed. (d) Notifications during the incident lifecycle. Ensure that any notifications that might be sent to the customer, contact, or owner group that will prompt them to view the incident (in ITSM) will not be restricted by the permissions of the incident at that time. (e) Will there be similiar restrictions on any related Problems, Known Errors, Changes, etc. that might be related to this incident? (not sure of your scope) So, while technically possible (the beauty of Remedy!) , the above questions will also have to be addressed. Terry From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia Sent: Tuesday, May 15, 2012 10:44 AM To: arslist@ARSLIST.ORG Subject: Re: Adding HR Department to ITSM Application using Multi-tenancy ** You can setup: Company 1 - Allpeople Company 2 - IT Support Company 3 - HR Then setup company 2 3 to support company 1. This will give company 2 3 access to company 1. The problem will come with the data segregation part. On your Incident form field 6969 and 112 will setup your permissions for the record. These fields are set by workflow for the customer company, support group, and vendor group. Unrestricted Access is also added into there. You also have assignee and submitter permissions. If you have everyone under Company 1 then anyone that supports that company will see all the tickets, which is not your desired result. You have a couple options. You can replicate the people data across multiple companies, which is probably not ideal or you can setup a filter to lock down field 6969 and 112 on submit. Also you may have sensitive people data that HR needs to see but IT doesn't, so keep in mind that there are going to be additional lock downs on the people form. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Poston, Lynna To: arslist@ARSLIST.ORG Subject: Adding HR Department to ITSM Application using Multi-tenancy ** ARS 7.6.04 SP3 ITSM 7.6.04 SP2 We use ITSM for our IT support personnel and for our field users (SRM). We also have a custom app that we created using remedy that our HR Department and employees use on another server. What we are wanting to do is add the HR group to our ITSM app but keep their tickets separate due to sensitivity issues. I've been looking at setting up HR as their own company but then run into the issue of people records. The people records are for all company employees and they would use, and be used by both IT and HR. I'm not sure how to go about segregating the tickets between the two (IT HR) so that IT personnel cannot see the HR tickets or how to handle the people records. Do I need to create a separate company or separate business units? Can anyone share his or her experience and advice on how to go about this? Any advice is appreciated. Thanks, Lynn P.S. I have the multi-tenancy document and have been through it but I'm still not sure which is the best route to go. _attend WWRUG12 www.wwrug.comhttp://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: Adding HR Department to ITSM Application using Multi-tenancy
Sorry about that the field is Vendor Assignee Group (60900). If you look at the permissions on Incident ID it will give you all the fields that you need to look at for the lock downs. It should have something like Unrestricted Access, Assignee Group, Assignee, Submitter, Vendor Assignee Group. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Poston, Lynn Sent: Thursday, May 17, 2012 8:51 AM To: arslist@ARSLIST.ORG Subject: Re: Adding HR Department to ITSM Application using Multi-tenancy ** Hi Terry Brian, Can you tell me what field 6969 is? I've looked in the docs and cannot find anything. I know field 112 is assignee group but what is 6969? Thanks, Lynn From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terry Bootsma Sent: Wednesday, May 16, 2012 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Adding HR Department to ITSM Application using Multi-tenancy ** Similiar to what Brian mentions below, I think you have no other option than writing your own filter to overwrite the row level access fields during certain key incident events. However, you will also have to determine the business rules as to when you want to overwrite the access, and when you want to restore it. For example, (a) When HR people submit incidents, do you want all incidents to be restricted to HR for the entire incident lifecycle? (b) When other people submit incidents and they get assigned to HR, will this incident then only be viewable by HR? What about the incident owner? Will they still be able to view the incident? (c) Will HR ever assign the incident back to the owner or other groups during the incident lifecycle (ex. incorrectly assigned, minor work)? If so, you will have to restore the original incident permissions and invoke workflow to ensure that this is reset. If reset , how do you handle viewing any information by other groups that may have been entered by HR? This will have to be addressed. (d) Notifications during the incident lifecycle. Ensure that any notifications that might be sent to the customer, contact, or owner group that will prompt them to view the incident (in ITSM) will not be restricted by the permissions of the incident at that time. (e) Will there be similiar restrictions on any related Problems, Known Errors, Changes, etc. that might be related to this incident? (not sure of your scope) So, while technically possible (the beauty of Remedy!) , the above questions will also have to be addressed. Terry _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia Sent: Tuesday, May 15, 2012 10:44 AM To: arslist@ARSLIST.ORG Subject: Re: Adding HR Department to ITSM Application using Multi-tenancy ** You can setup: Company 1 - Allpeople Company 2 - IT Support Company 3 - HR Then setup company 2 3 to support company 1. This will give company 2 3 access to company 1. The problem will come with the data segregation part. On your Incident form field 6969 and 112 will setup your permissions for the record. These fields are set by workflow for the customer company, support group, and vendor group. Unrestricted Access is also added into there. You also have assignee and submitter permissions. If you have everyone under Company 1 then anyone that supports that company will see all the tickets, which is not your desired result. You have a couple options. You can replicate the people data across multiple companies, which is probably not ideal or you can setup a filter to lock down field 6969 and 112 on submit. Also you may have sensitive people data that HR needs to see but IT doesn't, so keep in mind that there are going to be additional lock downs on the people form. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Poston, Lynna To: arslist@ARSLIST.ORG Subject: Adding HR Department to ITSM Application using Multi-tenancy ** ARS 7.6.04 SP3 ITSM 7.6.04 SP2 We use ITSM for our IT support personnel and for our field users (SRM). We also have a custom app that we created using remedy that our HR Department and employees use on another server. What we are wanting to do is add the HR group to our ITSM app but keep their tickets separate due to sensitivity issues. I've been looking at setting up HR as their own company but then run into the issue of people records. The people records are for all company employees and they would use, and be used by both IT and HR. I'm not sure how to go about segregating the tickets between the two (IT HR) so that IT personnel cannot see the HR tickets or how to handle the people records. Do I need to create a separate company or separate business units? Can anyone share his or her experience and advice on how to go about this? Any advice is appreciated. Thanks, Lynn
Re: Load Balancer Mid Tiers
Hello Mike, Long time no speak. You can have several mid-tiers and several AR servers. It sounds like you can do with just one AR server and one mid-tier with only 500 users. If you want to do two mid-tiers, that will give your users a decent amount of horsepower. Both mid-tiers have to have your AR server as the preference server. In the case were you would have two AR Servers, it gets more complicated on the network side where that involves a Virtual IP and name for your load balanced AR servers. That virtual name/load balanced AR Server name will be the one that you input into your mid-tier configuration as the preference server and visualization server. All of this is really for high availability environments. At this point it sounds like you can stick with a single threaded environment with a set of stout AR and Mid-tier servers. Jesus Ortega Senior II, Implementation Engineer LyondellBasell Industries Office: 713 309-4914 Cell: 281 546-0735 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mike Hocks Sent: Wednesday, May 16, 2012 2:06 PM To: arslist@ARSLIST.ORG Subject: Load Balancer Mid Tiers A question regarding a Load balancer and multiple Mid Tiers Can I have multiple mid tiers point to 1 AR Server or do I need to have an AR Server for each Mid Tier? We are running the 7.6.04 from the Pre Config Stack Installer on a Windows 2008 Server with a SQL backend Thank you! -Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Information contained in this email is subject to the disclaimer found by clicking on the following link: http://www.lyondellbasell.com/Footer/Disclaimer/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7.6.03 performance problems
Hi Folks, Me again... still struggling with this Mid-tier performance issue. ColumnIT (our support provider) has escalated the issue to BMC and I would appreciate a second opinion on the information I have received from BMC back line engineering support. I would like to know if you believe the explanation provided makes sense from a technical standpoint. I consider many of you to be quite knowledgable about the inner working of the AR System and it's interactions with the underlying DB, much more so than myself. Background: BMC says that the performance issue is the result of poor SQL initiated by workflow that we have created. Specifically, they contend that there are SQL calls that are resulting in table scans of the table in question. I disagree because my log analysis (thanks Misi) does not show any such SQL. But that is not the part I want your opinion about. This is their explanation: == We have verified the SQL statements and SQL queries from X-calls form are using Like operator which causes oracle to go for a full table scan instead of using indexes which introduces delays. Given their explanation, I asked the following followup question: - If the performance problem is the result of SQL queries which are getting fired on that form are taking too long and not using indexes which is resulting in delays and performance issues, why is it that the problem is not apparent after the AR system is started and only appears after the system has been up and running for a period of time? My expectation would be that performance issues that were the result of inefficient SQL would be apparent all of the time. Please explain how the inefficient SQL results in a gradual degradation in performance over time. This is the BMC response. Does this make sense to you? == After the AR server is restarted data caching is done while AR server is restarted which takes less time however when data increases in the form over time so resource requirements will also increase as well as queries will change based on the amount data fetched and what parameters are being passed and any limitations we have implemented for fetching number of records. This does not strike me as the type of response one would expect from back line engineering staff. Thanks for your thoughts. Larry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Version Roll Up is not working in Atrium 7.6.04
Hello Experts, I am facing issues while using version roll up utility in Normalization engine. The purpose of version roll up utility is to sync CI Market version with Market Version from PCT:Product Catalog. I have created Version Roll Up rule through NE console and I have also made the status of rule as active.Also, dataset and class is configured for version roll up. But, still I can't see the sync between Market version of PCT:Product Catalog to Market Version Of CI in CMDB. I don't see anything significant in NE logs. What can be possible resolutions for this issue? Regards, Sachin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7.6.03 performance problems
Hi Larry Sounds strange... I have seen SQL queries degrade in performance over time depending on the query execution plan, the amount of change to the data, and the statistics that are utilized by the query engine, but it doesn't describe why re-starting arsystem fixes the problem. However, here is a suggestion, 1. Regenerate your db statistics. Your dba will know how to do this. 2. Pick some sql that your app is generating and is a source of your concern. Run it natively via the appropriate sql tool. Turn on the query execution plan and statistics output for later comparison and save the results. 3. When the system starts to slow down, redo 2 above and compare output. if they are the same (or close to it), then it is conclusively not the DB This won't solve the problem,.but it will help you isolate it... Terry Sent from my mobile device.. L G Robinson n...@ncsu.edu wrote: ** Hi Folks, Me again... still struggling with this Mid-tier performance issue. ColumnIT (our support provider) has escalated the issue to BMC and I would appreciate a second opinion on the information I have received from BMC back line engineering support. I would like to know if you believe the explanation provided makes sense from a technical standpoint. I consider many of you to be quite knowledgable about the inner working of the AR System and it's interactions with the underlying DB, much more so than myself. Background: BMC says that the performance issue is the result of poor SQL initiated by workflow that we have created. Specifically, they contend that there are SQL calls that are resulting in table scans of the table in question. I disagree because my log analysis (thanks Misi) does not show any such SQL. But that is not the part I want your opinion about. This is their explanation: == We have verified the SQL statements and SQL queries from X-calls form are using Like operator which causes oracle to go for a full table scan instead of using indexes which introduces delays. Given their explanation, I asked the following followup question: - If the performance problem is the result of SQL queries which are getting fired on that form are taking too long and not using indexes which is resulting in delays and performance issues, why is it that the problem is not apparent after the AR system is started and only appears after the system has been up and running for a period of time? My expectation would be that performance issues that were the result of inefficient SQL would be apparent all of the time. Please explain how the inefficient SQL results in a gradual degradation in performance over time. This is the BMC response. Does this make sense to you? == After the AR server is restarted data caching is done while AR server is restarted which takes less time however when data increases in the form over time so resource requirements will also increase as well as queries will change based on the amount data fetched and what parameters are being passed and any limitations we have implemented for fetching number of records. This does not strike me as the type of response one would expect from back line engineering staff. Thanks for your thoughts. Larry _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
7.6.04 (multi-tenancy) Change Management and Service CI's...
Hello all, This is a 7.6.04 sp2 (multi-tenancy) question regarding Change Management and required Service CI's. We noticed that if the Change Location Company value (on the CRQ) doesn't match the Service CI, Company value, the Service wasn't available to the user. However, if the Service CI, Company value is NULL, the Service is available. The question is: what is the impact of having the Service CI record with a NULL Company value (i.e., elsewhere in the lifecycle of the CI)? Thanks, Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7.6.03 performance problems
Look at some of these settings. I have noticed similar issues in the past. Tweaking the Java settings has helped a lot. Unfortunately Java tuning is not exact and will require little tweaks at a time to get it right for your environment. You may also want to look at how your threads are configured. Are you running FTS? Initial memory pool: 1024 Maximum memory pool: 1024 Java Options: -Xincgc -XX:PermSize=256m (or 300m) -XX:+UseCompressedOops System Variables: JAVA_HOME C:\Program Files\Java\jdk1.6.0_25 (whatever your path is) JAVA_OPTS –server –Xms3072m –Xmx4096m (can set up to 75% of total RAM) I know these are windows references and not solaris, so don’t shoot me for that J . Similar settings can be done in Solaris. Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terry Bootsma Sent: Thursday, May 17, 2012 11:21 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.6.03 performance problems ** Hi Larry Sounds strange... I have seen SQL queries degrade in performance over time depending on the query execution plan, the amount of change to the data, and the statistics that are utilized by the query engine, but it doesn't describe why re-starting arsystem fixes the problem. However, here is a suggestion, 1. Regenerate your db statistics. Your dba will know how to do this. 2. Pick some sql that your app is generating and is a source of your concern. Run it natively via the appropriate sql tool. Turn on the query execution plan and statistics output for later comparison and save the results. 3. When the system starts to slow down, redo 2 above and compare output. if they are the same (or close to it), then it is conclusively not the DB This won't solve the problem,.but it will help you isolate it... Terry Sent from my mobile device.. L G Robinson n...@ncsu.edu wrote: ** Hi Folks, Me again... still struggling with this Mid-tier performance issue. ColumnIT (our support provider) has escalated the issue to BMC and I would appreciate a second opinion on the information I have received from BMC back line engineering support. I would like to know if you believe the explanation provided makes sense from a technical standpoint. I consider many of you to be quite knowledgable about the inner working of the AR System and it's interactions with the underlying DB, much more so than myself. Background: BMC says that the performance issue is the result of poor SQL initiated by workflow that we have created. Specifically, they contend that there are SQL calls that are resulting in table scans of the table in question. I disagree because my log analysis (thanks Misi) does not show any such SQL. But that is not the part I want your opinion about. This is their explanation: == We have verified the SQL statements and SQL queries from X-calls form are using Like operator which causes oracle to go for a full table scan instead of using indexes which introduces delays. Given their explanation, I asked the following followup question: - If the performance problem is the result of SQL queries which are getting fired on that form are taking too long and not using indexes which is resulting in delays and performance issues, why is it that the problem is not apparent after the AR system is started and only appears after the system has been up and running for a period of time? My expectation would be that performance issues that were the result of inefficient SQL would be apparent all of the time. Please explain how the inefficient SQL results in a gradual degradation in performance over time. This is the BMC response. Does this make sense to you? == After the AR server is restarted data caching is done while AR server is restarted which takes less time however when data increases in the form over time so resource requirements will also increase as well as queries will change based on the amount data fetched and what parameters are being passed and any limitations we have implemented for fetching number of records. This does not strike me as the type of response one would expect from back line engineering staff. Thanks for your thoughts. Larry _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
Pushing attached file to external app and then pulling parsed data back
We have a form that contains an attachment pool. When a file is attached to the form we need the attachment to be sent to an outside application to parse the data from the attachment. Once the parse is complete we need the parsed data to be pushed back to our Remedy form. We currently have an application to parse the data but are struggling with how to get the file to the app and the data back from the app. Any advice and/or guidance would be greatly appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7.6.03 performance problems
Hi Terry, That is a good suggestion. I have done an execution plan for the SQL in question, but I have not done a before after for the same SQL. Thanks. Larry On Thu, May 17, 2012 at 11:21 AM, Terry Bootsma tboot...@objectpath.comwrote: ** Hi Larry Sounds strange... I have seen SQL queries degrade in performance over time depending on the query execution plan, the amount of change to the data, and the statistics that are utilized by the query engine, but it doesn't describe why re-starting arsystem fixes the problem. However, here is a suggestion, 1. Regenerate your db statistics. Your dba will know how to do this. 2. Pick some sql that your app is generating and is a source of your concern. Run it natively via the appropriate sql tool. Turn on the query execution plan and statistics output for later comparison and save the results. 3. When the system starts to slow down, redo 2 above and compare output. if they are the same (or close to it), then it is conclusively not the DB This won't solve the problem,.but it will help you isolate it... Terry Sent from my mobile device.. L G Robinson n...@ncsu.edu wrote: ** Hi Folks, Me again... still struggling with this Mid-tier performance issue. ColumnIT (our support provider) has escalated the issue to BMC and I would appreciate a second opinion on the information I have received from BMC back line engineering support. I would like to know if you believe the explanation provided makes sense from a technical standpoint. I consider many of you to be quite knowledgable about the inner working of the AR System and it's interactions with the underlying DB, much more so than myself. Background: BMC says that the performance issue is the result of poor SQL initiated by workflow that we have created. Specifically, they contend that there are SQL calls that are resulting in table scans of the table in question. I disagree because my log analysis (thanks Misi) does not show any such SQL. But that is not the part I want your opinion about. This is their explanation: == We have verified the SQL statements and SQL queries from X-calls form are using Like operator which causes oracle to go for a full table scan instead of using indexes which introduces delays. Given their explanation, I asked the following followup question: - If the performance problem is the result of SQL queries which are getting fired on that form are taking too long and not using indexes which is resulting in delays and performance issues, why is it that the problem is not apparent after the AR system is started and only appears after the system has been up and running for a period of time? My expectation would be that performance issues that were the result of inefficient SQL would be apparent all of the time. Please explain how the inefficient SQL results in a gradual degradation in performance over time. This is the BMC response. Does this make sense to you? == After the AR server is restarted data caching is done while AR server is restarted which takes less time however when data increases in the form over time so resource requirements will also increase as well as queries will change based on the amount data fetched and what parameters are being passed and any limitations we have implemented for fetching number of records. This does not strike me as the type of response one would expect from back line engineering staff. Thanks for your thoughts. Larry _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: Version Roll Up is not working in Atrium 7.6.04
What is showing up in the logs? I've been dealing with some Normalization issues as well, and I see lots of things in the neJob.BMC.ASSET.### files but none that explain this. The only errors I see are for products that truly don't match anything in the Product Catalog where I get errors such as: Error while normalizing the instance id OI-FB5D8F00831045EFABF309C2BC456DBD of class BMC.CORE:BMC_Product. ERROR (120516): Could not find any unique entry in the Product Catalog. Product Catalog Key: null, Model: WinZip, Manufacturer: WinZip Computing, Version: 11.0, Patch: null However, other products that do not give this error also do not appear to have been updated with the Market version for those products. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sachin Sent: Thursday, May 17, 2012 10:00 AM To: arslist@ARSLIST.ORG Subject: Version Roll Up is not working in Atrium 7.6.04 Hello Experts, I am facing issues while using version roll up utility in Normalization engine. The purpose of version roll up utility is to sync CI Market version with Market Version from PCT:Product Catalog. I have created Version Roll Up rule through NE console and I have also made the status of rule as active.Also, dataset and class is configured for version roll up. But, still I can't see the sync between Market version of PCT:Product Catalog to Market Version Of CI in CMDB. I don't see anything significant in NE logs. What can be possible resolutions for this issue? Regards, Sachin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
System Center 2012 Service Manager question
Good Morning everyone, My organization is looking at Microsoft Center 2012 Service Manager to replace Service Desk, Asset Management and ADDM. Can anyone provide info on the differences of the 2 applications? I believe they are looking to use the complete Microsoft solution including Configuration management and Change Management. Danielle R. Henderson L-3 Stratis ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: 7.6.04 (multi-tenancy) Change Management and Service CI's...
Have you tried keeping the company field on the service ci populated with the previous value and creating a used by people-organization relationship to the new company? That should make the service available By creating multiple used-by relationships, you can control who sees the services... Hth Terry Sent from my mobile device.. Rick Phillips r...@netfirst.com wrote: Hello all, This is a 7.6.04 sp2 (multi-tenancy) question regarding Change Management and required Service CI's. We noticed that if the Change Location Company value (on the CRQ) doesn't match the Service CI, Company value, the Service wasn't available to the user. However, if the Service CI, Company value is NULL, the Service is available. The question is: what is the impact of having the Service CI record with a NULL Company value (i.e., elsewhere in the lifecycle of the CI)? Thanks, Rick ___ 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: System Center 2012 Service Manager question
They are immature and not ready to compete against the big boys. Rick On May 17, 2012 11:41 AM, Henderson, Danielle R. CNTR dhender...@nmic.navy.mil wrote: Good Morning everyone, My organization is looking at Microsoft Center 2012 Service Manager to replace Service Desk, Asset Management and ADDM. Can anyone provide info on the differences of the 2 applications? I believe they are looking to use the complete Microsoft solution including Configuration management and Change Management. Danielle R. Henderson L-3 Stratis ___ 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: 7.6.04 (multi-tenancy) Change Management and Service CI's...
Terry, Thanks for the reply. Your suggestion works in INC, but oddly not in CHG. r On 5/17/2012 8:44 AM, Terry Bootsma wrote: ** Have you tried keeping the company field on the service ci populated with the previous value and creating a used by people-organization relationship to the new company? That should make the service available By creating multiple used-by relationships, you can control who sees the services... Hth Terry Sent from my mobile device.. Rick Phillips r...@netfirst.com wrote: Hello all, This is a 7.6.04 sp2 (multi-tenancy) question regarding Change Management and required Service CI's. We noticed that if the Change Location Company value (on the CRQ) doesn't match the Service CI, Company value, the Service wasn't available to the user. However, if the Service CI, Company value is NULL, the Service is available. The question is: what is the impact of having the Service CI record with a NULL Company value (i.e., elsewhere in the lifecycle of the CI)? Thanks, Rick ___ 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: 7.6.04 (multi-tenancy) Change Management and Service CI's...
...and.. That is surprising? Lol Not sure how I could expand upon this other than looking at converting the change service menu to follow the same constructs as the incident one... It might be your only alternative Sent from my mobile device.. Rick Phillips r...@netfirst.com wrote: ** Terry, Thanks for the reply. Your suggestion works in INC, but oddly not in CHG. r On 5/17/2012 8:44 AM, Terry Bootsma wrote: ** Have you tried keeping the company field on the service ci populated with the previous value and creating a used by people-organization relationship to the new company? That should make the service available By creating multiple used-by relationships, you can control who sees the services... Hth Terry Sent from my mobile device.. Rick Phillips r...@netfirst.com wrote: Hello all, This is a 7.6.04 sp2 (multi-tenancy) question regarding Change Management and required Service CI's. We noticed that if the Change Location Company value (on the CRQ) doesn't match the Service CI, Company value, the Service wasn't available to the user. However, if the Service CI, Company value is NULL, the Service is available. The question is: what is the impact of having the Service CI record with a NULL Company value (i.e., elsewhere in the lifecycle of the CI)? Thanks, Rick ___ 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_ _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: System Center 2012 Service Manager question
I'm in a similar situation. BMC has put together a matrix comparing the two, but it's not very complete. According to BMC, SCSM isn't something that has been a competitor to the Remedy platform in the past, so they don't have a well put together comparison between the two. I have put together a much more detailed comparison, and I am going to be sitting in a demo from Microsoft on SCSM next week. Perhaps in two weeks I'll have more information to compare the two. Right now, there are some basic core things missing in SCSM that doesn't have me thrilled to potentially implement it. Some of the major gaps are: - No web interface (other than going through a third party add-on, although their SRM equivalent is SharePoint based.) - No Asset Management (you have to purchase something from a Microsoft partner like Provance.) - Basic configuration tasks are much more difficult (e.g. the ease of setting up an Assignment mapping in Remedy is replaced by something more manual in SCSM which I would compare to setting up an SLA in SLM.) - The product is full of hidden costs, so at least in our organization it's looking like it may potentially be less expensive to keep Remedy and purchase additional licenses rather than implementing SCSM. Microsoft tries to hide lots of expenses hidden into bundles of other products. - SCCM is not a complete overlap with ADDM. The discovery portion of SCSM is basically geared around Windows Servers and Clients, and it is not agentless. I'm also not sure that it can do a good job of mapping out relationships like ADDM does. There are several other areas, but most of my initial opinion was based off of SCSM 2008, so I have to wait to see the 2012 demo before I can confidently give a good comparison. On a personal note, I am conflicted because I know Remedy is a better product, but I am also interested in learning other applications so if I got a chance to implement SCSM that could be an interesting challenge. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Henderson, Danielle R. CNTR Sent: Thursday, May 17, 2012 10:38 AM To: arslist@ARSLIST.ORG Subject: System Center 2012 Service Manager question Good Morning everyone, My organization is looking at Microsoft Center 2012 Service Manager to replace Service Desk, Asset Management and ADDM. Can anyone provide info on the differences of the 2 applications? I believe they are looking to use the complete Microsoft solution including Configuration management and Change Management. Danielle R. Henderson L-3 Stratis ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: 7.6.04 (multi-tenancy) Change Management and Service CI's...
yep, that may be plan A. I was checking out NULL values in the Service CI as plan B. On 5/17/2012 8:50 AM, Terry Bootsma wrote: ** ...and.. That is surprising? Lol Not sure how I could expand upon this other than looking at converting the change service menu to follow the same constructs as the incident one... It might be your only alternative Sent from my mobile device.. Rick Phillips r...@netfirst.com wrote: ** Terry, Thanks for the reply. Your suggestion works in INC, but oddly not in CHG. r On 5/17/2012 8:44 AM, Terry Bootsma wrote: ** Have you tried keeping the company field on the service ci populated with the previous value and creating a used by people-organization relationship to the new company? That should make the service available By creating multiple used-by relationships, you can control who sees the services... Hth Terry Sent from my mobile device.. Rick Phillips r...@netfirst.com wrote: Hello all, This is a 7.6.04 sp2 (multi-tenancy) question regarding Change Management and required Service CI's. We noticed that if the Change Location Company value (on the CRQ) doesn't match the Service CI, Company value, the Service wasn't available to the user. However, if the Service CI, Company value is NULL, the Service is available. The question is: what is the impact of having the Service CI record with a NULL Company value (i.e., elsewhere in the lifecycle of the CI)? Thanks, Rick ___ 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_ _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: Cleaning Special Characters from a Character Field
I wrote the regex plugin because I had a set of requirements that workflow
could not address. We would get bad characters, and I needed to whitelist
the characters that could be used and where in the string they could be
used. The Java regex capabilities were a good fit. They let you look
for occurrence counts, use anchors, etc. In my case, I needed to whitelist
the characters that were allowed in the string. I could not conceive a way
of doing this in workflow, short of pulling evaluating each character in
the string individually. This was inefficient and difficult to maintain,
so I opted for the plugin.
I started finding that there were many things I could do with the regex
capabilities that workflow is just a pain in the rear to do. For example,
if I want to allow phone numbers on one of several formats, or I want IP
addresses to be valid and not have leading zeroes in the octets, or I want
a valid email address format. For example:
Email
Address:
^[_A-Za-z0-9-]+(\.[_A-Za-z0-9-]+)*@[A-Za-z0-9]+(\.[A-Za-z0-9]+)*(\.[A-Za-z]{2,})$
IP
Address:
^([01]?\d\d?|2[0-4]\\d|25[0-5])\.([01]?\d\d?|2[0-4]\d|25[0-5])\.([01]?\d\d?|2[0-4]\d|25[0-5])\.([01]?\d\d?|2[0-4]\d|25[0-5])$
Letters a to z, A to Z, 0 to 9, (comma), and (dash) are
allowed: ^[a-zA-Z0-9-,/\\]+$
Letters a to z, A to Z, 0 to 9, space, and - are allowed but space is not
allowed at the beginning or end of the string: ^[^ ][a-z A-Z0-9-]+[^ ]$
Just to name a few. The way I wrapped the plugin, I have a repository of
evaluations I can perform and I can reuse those wherever they are needed,
and I can modify the evaluation and it is instantly used in all places that
need to use that evaluation. In workflow, this would be problematic to
maintain because it would mean modifying workflow in many places to account
for a single evaluation I was doing in many places. It means finding all
the places, making sure the workflow is modified properly, and that is just
time consuming and the next poor sap who comes along doesn't have much of a
chance of getting it right.
Along this train of thought, it would be nice if I could define the pattern
in the field properties, similar to the way $MENU$ works, but instead of
using the menu for validation, use the regex from the repository. If that
were the case, there would be no workflow to write to validate input, just
define and reuse the regex.
Axton Grams
On Thu, May 17, 2012 at 3:24 AM, Misi Mladoniczky m...@rrr.se wrote:
Hi,
You can do this with normal filters as well, even if it will be a little
bit slower.
I like the Service functionality, and would create a simple
Display-only-form with two fields Dirty and Clean and two filters:
FLTR 1:
Run If: ('Dirty' LIKE [A-Za-z 0-9.,\?!#$%^*()_=+/;:|}{[`~-]% OR
'Dirty' LIKE ]%)
Set-Fields: Clean = $Clean$ + LEFTC($Dirty$, 1)
FLTR 2:
Run If: ('Dirty' LIKE _%)
Set-Fields: Dirty = SUBSTRC($Dirty$, 1)
Goto: 1
Just call your Service with Dirty as input and Clean as output.
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.
Thank you Axton! We'll give it a go.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Wednesday, May 16, 2012 4:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Cleaning Special Characters from a Character Field
** Here is a very simple Java plugin to get you started (38 lines of
code).
The plugin accepts 2 parameters; a regex and a value, and returns
true/false
on whether the string conforms to the regex. You can extend or modify
this
to perform a conversion instead of doing a comparison.
import java.util.ArrayList;
import java.util.List;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import java.util.regex.PatternSyntaxException;
import com.bmc.arsys.api.ARException;
import com.bmc.arsys.api.Value;
import com.bmc.arsys.pluginsvr.plugins.ARFilterAPIPlugin;
import com.bmc.arsys.pluginsvr.plugins.ARPluginContext;
public class Regex extends ARFilterAPIPlugin {
/**
* @param context ARPluginContext provided by the plugin
server.
* @param arg1 Input parameters:
* 1 - Regular Expression
conforming to java.util.regex
* 2 - String to evaluate
* @return Boolean, does the string conform to the regular
expression
* 0 - False
* 1 - True
* @see java.util.regex.Pattern
* @exception
Re: ARS 7.6.03 performance problems
Look at your sql logs. Do you see a long delay between the time the select is issued and the results returned? If so, that would indicate to me that the SQL is the cause of the slowness. Start there, then cross the next bridge when you get to it. Axton Grams On Thu, May 17, 2012 at 10:32 AM, L G Robinson n...@ncsu.edu wrote: ** Hi Terry, That is a good suggestion. I have done an execution plan for the SQL in question, but I have not done a before after for the same SQL. Thanks. Larry On Thu, May 17, 2012 at 11:21 AM, Terry Bootsma tboot...@objectpath.comwrote: ** Hi Larry Sounds strange... I have seen SQL queries degrade in performance over time depending on the query execution plan, the amount of change to the data, and the statistics that are utilized by the query engine, but it doesn't describe why re-starting arsystem fixes the problem. However, here is a suggestion, 1. Regenerate your db statistics. Your dba will know how to do this. 2. Pick some sql that your app is generating and is a source of your concern. Run it natively via the appropriate sql tool. Turn on the query execution plan and statistics output for later comparison and save the results. 3. When the system starts to slow down, redo 2 above and compare output. if they are the same (or close to it), then it is conclusively not the DB This won't solve the problem,.but it will help you isolate it... Terry Sent from my mobile device.. L G Robinson n...@ncsu.edu wrote: ** Hi Folks, Me again... still struggling with this Mid-tier performance issue. ColumnIT (our support provider) has escalated the issue to BMC and I would appreciate a second opinion on the information I have received from BMC back line engineering support. I would like to know if you believe the explanation provided makes sense from a technical standpoint. I consider many of you to be quite knowledgable about the inner working of the AR System and it's interactions with the underlying DB, much more so than myself. Background: BMC says that the performance issue is the result of poor SQL initiated by workflow that we have created. Specifically, they contend that there are SQL calls that are resulting in table scans of the table in question. I disagree because my log analysis (thanks Misi) does not show any such SQL. But that is not the part I want your opinion about. This is their explanation: == We have verified the SQL statements and SQL queries from X-calls form are using Like operator which causes oracle to go for a full table scan instead of using indexes which introduces delays. Given their explanation, I asked the following followup question: - If the performance problem is the result of SQL queries which are getting fired on that form are taking too long and not using indexes which is resulting in delays and performance issues, why is it that the problem is not apparent after the AR system is started and only appears after the system has been up and running for a period of time? My expectation would be that performance issues that were the result of inefficient SQL would be apparent all of the time. Please explain how the inefficient SQL results in a gradual degradation in performance over time. This is the BMC response. Does this make sense to you? == After the AR server is restarted data caching is done while AR server is restarted which takes less time however when data increases in the form over time so resource requirements will also increase as well as queries will change based on the amount data fetched and what parameters are being passed and any limitations we have implemented for fetching number of records. This does not strike me as the type of response one would expect from back line engineering staff. Thanks for your thoughts. Larry _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: 7.6.04 (multi-tenancy) Change Management and Service CI's...
Rick.one other item that I have done in the past is change the service menu so that it is a tiered menu using the tier 1, 2, and 3 of the actual service ci itself. That way it gives you a nice tiered menu of services vs. a large menu that makes service selection difficult. Hth Terry Sent from my mobile device.. Rick Phillips r...@netfirst.com wrote: ** yep, that may be plan A. I was checking out NULL values in the Service CI as plan B. On 5/17/2012 8:50 AM, Terry Bootsma wrote: ** ...and.. That is surprising? Lol Not sure how I could expand upon this other than looking at converting the change service menu to follow the same constructs as the incident one... It might be your only alternative Sent from my mobile device.. Rick Phillips r...@netfirst.com wrote: ** Terry, Thanks for the reply. Your suggestion works in INC, but oddly not in CHG. r On 5/17/2012 8:44 AM, Terry Bootsma wrote: ** Have you tried keeping the company field on the service ci populated with the previous value and creating a used by people-organization relationship to the new company? That should make the service available By creating multiple used-by relationships, you can control who sees the services... Hth Terry Sent from my mobile device.. Rick Phillips r...@netfirst.com wrote: Hello all, This is a 7.6.04 sp2 (multi-tenancy) question regarding Change Management and required Service CI's. We noticed that if the Change Location Company value (on the CRQ) doesn't match the Service CI, Company value, the Service wasn't available to the user. However, if the Service CI, Company value is NULL, the Service is available. The question is: what is the impact of having the Service CI record with a NULL Company value (i.e., elsewhere in the lifecycle of the CI)? Thanks, Rick ___ 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_ _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: Load Balancer Mid Tiers
There was a hard ceiling on how much the midtier could handle with the 32-bit JVM (because memory was scarce), but that, in theory, is no longer the case with the 64-bit JVMs. Using a 64-bit JVM with the midtier will require that you properly tune your JVM though, if you expect to get comparable performance from it that you do with a 32-bit JVM. Axton Grams On Wed, May 16, 2012 at 5:46 PM, Brian Goralczyk bgoralc...@gmail.comwrote: Mike, I am sorry, I meant that the AR server should be able to handle it. I would go with the 150 limit per mid tier. I haven't tested it to see how many it can actually run, but it can be pretty frustrating if you don't have enough of them to handle the load. I believe that you only need one AR server based on concurrent users SOLELY. Fail-over and disaster recovery is a different ball of wax. Server groups are a great way to protect yourself. Based on what you are saying I would say a minimal setup would be 2 good webservers to handle the mid tier, one app server and one db server. But keep in mind that is minimal. Depending on how much money you have to spend I would double everything to start. Patrick has a pretty good recommendation. Brian Goralczyk Phone 574-643-1144 Email bgoralc...@gmail.com On Wed, May 16, 2012 at 3:07 PM, Hocks, Mike (DOT) mike.ho...@state.mn.us wrote: Brian, thanks a lot for the info...so it sounds like the rule of estimating 150 concurrent connections per mid-tier is way off base...we are running a quad core xeon proc with 24GB of RAM w/ Windows 2008 64BIT ... sounds like we are in good shape our environment? We do have Mid-Tier and the AR System all on the same box (pre-config stack install) Thanks again, -Mike -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk Sent: Wednesday, May 16, 2012 2:51 PM To: arslist@ARSLIST.ORG Subject: Re: Load Balancer Mid Tiers I would say that 500 concurrent users isn't to much for some servers to handle. It all depends on your hardware and your code. If you are using out of the box, what are those 500 users going to be doing? If it is custom code, how cleanly is it written. Performance testing and improvement is a job all on it's own. But I have had systems that have dealt with that level of load without a problem. The biggest issue is the single point of failure mentioned. Brian Goralczyk Phone 574-643-1144 Email bgoralc...@gmail.com On Wed, May 16, 2012 at 1:28 PM, Hocks, Mike (DOT) mike.ho...@state.mn.us wrote: Interesting, we need to build out our environment for 500 concurrent connections, do you think we should plan for more AR Servers to accommodate 500 concurrent connection? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of pritch Sent: Wednesday, May 16, 2012 2:22 PM To: arslist@ARSLIST.ORG Subject: Re: Load Balancer Mid Tiers You can, but then you still have a potential single point of failure (or bottleneck). - Original Message - From: Andrew C Goodall ago...@jcp.com To: arslist@ARSLIST.ORG Sent: Wednesday, May 16, 2012 3:11:15 PM Subject: Re: Load Balancer Mid Tiers You can have multiple point to one. Regards, Andrew C. Goodall Software Engineer Development Services ago...@jcpenney.com jcpenney 6501 Legacy Drive Plano, TX 75024 jcp.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mike Hocks Sent: Wednesday, May 16, 2012 2:06 PM To: arslist@ARSLIST.ORG Subject: Load Balancer Mid Tiers A question regarding a Load balancer and multiple Mid Tiers Can I have multiple mid tiers point to 1 AR Server or do I need to have an AR Server for each Mid Tier? We are running the 7.6.04 from the Pre Config Stack Installer on a Windows 2008 Server with a SQL backend Thank you! -Mike __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the
Re: System Center 2012 Service Manager question
What is their driving force to switching? I'm assuming licensing costs and OM costs. If that is the case there are other options with Remedy OnDemand and Remedy Force that could knock out a significant amount of the costs. I think over the next few years you are going to see a significant transition to these solutions. The government may be a little slower to transition, but agencies are slowly but surely adopting cloud and SaaS solutions. BMC may have some other alternatives if you talk to the Account Manager. I have seen a ton of different ITSM solutions. Some good and some bad. A lot of them do 75% of the same thing. The difference is usually implementation. What a lot of organizations find is that they switch for whatever reasons and find that they have a lot of the same issues if not more with the new solution. Also, most organizations only use a fraction of the out of box capabilities and end up doing a lot of customizations instead of using most of the capabilities. If organizations stick to implementing straight out of box functionality first their OM cost will greatly decrease. I have seen organizations use Remedy where a developer has not touched the system in over a year except for patching. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Thursday, May 17, 2012 11:52 AM To: arslist@ARSLIST.ORG Subject: Re: System Center 2012 Service Manager question I'm in a similar situation. BMC has put together a matrix comparing the two, but it's not very complete. According to BMC, SCSM isn't something that has been a competitor to the Remedy platform in the past, so they don't have a well put together comparison between the two. I have put together a much more detailed comparison, and I am going to be sitting in a demo from Microsoft on SCSM next week. Perhaps in two weeks I'll have more information to compare the two. Right now, there are some basic core things missing in SCSM that doesn't have me thrilled to potentially implement it. Some of the major gaps are: - No web interface (other than going through a third party add-on, although their SRM equivalent is SharePoint based.) - No Asset Management (you have to purchase something from a Microsoft partner like Provance.) - Basic configuration tasks are much more difficult (e.g. the ease of setting up an Assignment mapping in Remedy is replaced by something more manual in SCSM which I would compare to setting up an SLA in SLM.) - The product is full of hidden costs, so at least in our organization it's looking like it may potentially be less expensive to keep Remedy and purchase additional licenses rather than implementing SCSM. Microsoft tries to hide lots of expenses hidden into bundles of other products. - SCCM is not a complete overlap with ADDM. The discovery portion of SCSM is basically geared around Windows Servers and Clients, and it is not agentless. I'm also not surWhate that it can do a good job of mapping out relationships like ADDM does. There are several other areas, but most of my initial opinion was based off of SCSM 2008, so I have to wait to see the 2012 demo before I can confidently give a good comparison. On a personal note, I am conflicted because I know Remedy is a better product, but I am also interested in learning other applications so if I got a chance to implement SCSM that could be an interesting challenge. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Henderson, Danielle R. CNTR Sent: Thursday, May 17, 2012 10:38 AM To: arslist@ARSLIST.ORG Subject: System Center 2012 Service Manager question Good Morning everyone, My organization is looking at Microsoft Center 2012 Service Manager to replace Service Desk, Asset Management and ADDM. Can anyone provide info on the differences of the 2 applications? I believe they are looking to use the complete Microsoft solution including Configuration management and Change Management. Danielle R. Henderson L-3 Stratis ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: System Center 2012 Service Manager question
I can't speak for all situations, but in my experience the vast majority of situations where the tool is switched, it is almost never over functionality and it's rarely due to the costs. Generally these types of changes occur due to organizational changes or desired organizational changes. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia Sent: Thursday, May 17, 2012 11:22 AM To: arslist@ARSLIST.ORG Subject: Re: System Center 2012 Service Manager question What is their driving force to switching? I'm assuming licensing costs and OM costs. If that is the case there are other options with Remedy OnDemand and Remedy Force that could knock out a significant amount of the costs. I think over the next few years you are going to see a significant transition to these solutions. The government may be a little slower to transition, but agencies are slowly but surely adopting cloud and SaaS solutions. BMC may have some other alternatives if you talk to the Account Manager. I have seen a ton of different ITSM solutions. Some good and some bad. A lot of them do 75% of the same thing. The difference is usually implementation. What a lot of organizations find is that they switch for whatever reasons and find that they have a lot of the same issues if not more with the new solution. Also, most organizations only use a fraction of the out of box capabilities and end up doing a lot of customizations instead of using most of the capabilities. If organizations stick to implementing straight out of box functionality first their OM cost will greatly decrease. I have seen organizations use Remedy where a developer has not touched the system in over a year except for patching. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Thursday, May 17, 2012 11:52 AM To: arslist@ARSLIST.ORG Subject: Re: System Center 2012 Service Manager question I'm in a similar situation. BMC has put together a matrix comparing the two, but it's not very complete. According to BMC, SCSM isn't something that has been a competitor to the Remedy platform in the past, so they don't have a well put together comparison between the two. I have put together a much more detailed comparison, and I am going to be sitting in a demo from Microsoft on SCSM next week. Perhaps in two weeks I'll have more information to compare the two. Right now, there are some basic core things missing in SCSM that doesn't have me thrilled to potentially implement it. Some of the major gaps are: - No web interface (other than going through a third party add-on, although their SRM equivalent is SharePoint based.) - No Asset Management (you have to purchase something from a Microsoft partner like Provance.) - Basic configuration tasks are much more difficult (e.g. the ease of setting up an Assignment mapping in Remedy is replaced by something more manual in SCSM which I would compare to setting up an SLA in SLM.) - The product is full of hidden costs, so at least in our organization it's looking like it may potentially be less expensive to keep Remedy and purchase additional licenses rather than implementing SCSM. Microsoft tries to hide lots of expenses hidden into bundles of other products. - SCCM is not a complete overlap with ADDM. The discovery portion of SCSM is basically geared around Windows Servers and Clients, and it is not agentless. I'm also not surWhate that it can do a good job of mapping out relationships like ADDM does. There are several other areas, but most of my initial opinion was based off of SCSM 2008, so I have to wait to see the 2012 demo before I can confidently give a good comparison. On a personal note, I am conflicted because I know Remedy is a better product, but I am also interested in learning other applications so if I got a chance to implement SCSM that could be an interesting challenge. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Henderson, Danielle R. CNTR Sent: Thursday, May 17, 2012 10:38 AM To: arslist@ARSLIST.ORG Subject: System Center 2012 Service Manager question Good Morning everyone, My organization is looking at Microsoft Center 2012 Service Manager to replace Service Desk, Asset Management and ADDM. Can anyone provide info on the differences of the 2 applications? I believe they are looking to use the complete Microsoft solution including Configuration management and Change Management. Danielle R. Henderson L-3 Stratis ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com
Re: ARS 7.6.03 performance problems
Hi Axton, I have Used Misi's excellent RRR|Log analysis tool to analyse 24 hours worth of combined API and SQL logs. For the entire 24 hour period, I found a small number of SQL commands that do take several seconds to execute. However, in all cases, these SQL queries are the result of poorly defined advanced searches initiated by my users. The great majority of the SQL commands issued against this table use indexes and complete in well under a second, usually on the order of 0.00xx seconds. But still, I am wondering if longer-running SQL transactions can account for the gradual degradation of performance over time. I can understand that the user who issues the poorly-designed advanced search will suffer the delay resulting from inefficient SQL, but do you believe that it will affect system performance in general, assuming there are enough threads, etc? Do you have an opinion on that? Thanks for any insights. Larry On Thu, May 17, 2012 at 12:05 PM, Axton axton.gr...@gmail.com wrote: ** Look at your sql logs. Do you see a long delay between the time the select is issued and the results returned? If so, that would indicate to me that the SQL is the cause of the slowness. Start there, then cross the next bridge when you get to it. Axton Grams On Thu, May 17, 2012 at 10:32 AM, L G Robinson n...@ncsu.edu wrote: ** Hi Terry, That is a good suggestion. I have done an execution plan for the SQL in question, but I have not done a before after for the same SQL. Thanks. Larry On Thu, May 17, 2012 at 11:21 AM, Terry Bootsma tboot...@objectpath.comwrote: ** Hi Larry Sounds strange... I have seen SQL queries degrade in performance over time depending on the query execution plan, the amount of change to the data, and the statistics that are utilized by the query engine, but it doesn't describe why re-starting arsystem fixes the problem. However, here is a suggestion, 1. Regenerate your db statistics. Your dba will know how to do this. 2. Pick some sql that your app is generating and is a source of your concern. Run it natively via the appropriate sql tool. Turn on the query execution plan and statistics output for later comparison and save the results. 3. When the system starts to slow down, redo 2 above and compare output. if they are the same (or close to it), then it is conclusively not the DB This won't solve the problem,.but it will help you isolate it... Terry Sent from my mobile device.. L G Robinson n...@ncsu.edu wrote: ** Hi Folks, Me again... still struggling with this Mid-tier performance issue. ColumnIT (our support provider) has escalated the issue to BMC and I would appreciate a second opinion on the information I have received from BMC back line engineering support. I would like to know if you believe the explanation provided makes sense from a technical standpoint. I consider many of you to be quite knowledgable about the inner working of the AR System and it's interactions with the underlying DB, much more so than myself. Background: BMC says that the performance issue is the result of poor SQL initiated by workflow that we have created. Specifically, they contend that there are SQL calls that are resulting in table scans of the table in question. I disagree because my log analysis (thanks Misi) does not show any such SQL. But that is not the part I want your opinion about. This is their explanation: == We have verified the SQL statements and SQL queries from X-calls form are using Like operator which causes oracle to go for a full table scan instead of using indexes which introduces delays. Given their explanation, I asked the following followup question: - If the performance problem is the result of SQL queries which are getting fired on that form are taking too long and not using indexes which is resulting in delays and performance issues, why is it that the problem is not apparent after the AR system is started and only appears after the system has been up and running for a period of time? My expectation would be that performance issues that were the result of inefficient SQL would be apparent all of the time. Please explain how the inefficient SQL results in a gradual degradation in performance over time. This is the BMC response. Does this make sense to you? == After the AR server is restarted data caching is done while AR server is restarted which takes less time however when data increases in the form over time so resource requirements will also increase as well as queries will change based on the amount data fetched and what parameters are being passed and any limitations we have implemented for fetching number of records. This does not strike me as the type of response one would expect from back line engineering staff. Thanks for your thoughts. Larry _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_
Re: ARS 7.6.03 performance problems
Well, if you have data piling up somewhere, and you have workflow that scans that data, as the size of the data increases, the time required for the scan will increase. If this is going on, you will see evidence to that effect in the sql logs (increasing time in the sql logs for the same statement execution). If you don't see sql that is taking a long time to return, then I think you are barking up the wrong tree. People have been known to give bad advice before ;) A couple of seconds is ok; milliseconds and microseconds are great. If you are seeing 2 seconds in the sql logs for a statement to return, and it is taking 60 seconds for the client to respond, the cause is not the sql. If someone issues bad sql, let's say something that takes 120 seconds to return, they will occupy some thread (fast, list, of custom, depending on their connection parameters). If you have 2 threads, and 2 users run a bad sql, each of which takes 120 seconds, every other transaction will be queued until one of those threads is returned to the pool. It's not a matter of performance, per say, but a matter of availability of a thread to handle the work. Either a thread is ready to handle the work and does, or a thread is not available, and all the new work coming in has to wait for a thread to become available. This is why it is a good idea to move certain subsystems to private queues. Things like RE, AREmail, or AIE, which are known to keep threads busy, while running, are good candidates. It keeps the resources available where they are needed (i.e., your users are not fighting for resources against your automated systems). Think of a private queue as a containment vessel for whatever uses that private queue. If it goes haywire and starts doing a bunch of work, it will only affect other connections that share that queue. Axton Grams On Thu, May 17, 2012 at 12:16 PM, L G Robinson n...@ncsu.edu wrote: ** Hi Axton, I have Used Misi's excellent RRR|Log analysis tool to analyse 24 hours worth of combined API and SQL logs. For the entire 24 hour period, I found a small number of SQL commands that do take several seconds to execute. However, in all cases, these SQL queries are the result of poorly defined advanced searches initiated by my users. The great majority of the SQL commands issued against this table use indexes and complete in well under a second, usually on the order of 0.00xx seconds. But still, I am wondering if longer-running SQL transactions can account for the gradual degradation of performance over time. I can understand that the user who issues the poorly-designed advanced search will suffer the delay resulting from inefficient SQL, but do you believe that it will affect system performance in general, assuming there are enough threads, etc? Do you have an opinion on that? Thanks for any insights. Larry On Thu, May 17, 2012 at 12:05 PM, Axton axton.gr...@gmail.com wrote: ** Look at your sql logs. Do you see a long delay between the time the select is issued and the results returned? If so, that would indicate to me that the SQL is the cause of the slowness. Start there, then cross the next bridge when you get to it. Axton Grams On Thu, May 17, 2012 at 10:32 AM, L G Robinson n...@ncsu.edu wrote: ** Hi Terry, That is a good suggestion. I have done an execution plan for the SQL in question, but I have not done a before after for the same SQL. Thanks. Larry On Thu, May 17, 2012 at 11:21 AM, Terry Bootsma tboot...@objectpath.com wrote: ** Hi Larry Sounds strange... I have seen SQL queries degrade in performance over time depending on the query execution plan, the amount of change to the data, and the statistics that are utilized by the query engine, but it doesn't describe why re-starting arsystem fixes the problem. However, here is a suggestion, 1. Regenerate your db statistics. Your dba will know how to do this. 2. Pick some sql that your app is generating and is a source of your concern. Run it natively via the appropriate sql tool. Turn on the query execution plan and statistics output for later comparison and save the results. 3. When the system starts to slow down, redo 2 above and compare output. if they are the same (or close to it), then it is conclusively not the DB This won't solve the problem,.but it will help you isolate it... Terry Sent from my mobile device.. L G Robinson n...@ncsu.edu wrote: ** Hi Folks, Me again... still struggling with this Mid-tier performance issue. ColumnIT (our support provider) has escalated the issue to BMC and I would appreciate a second opinion on the information I have received from BMC back line engineering support. I would like to know if you believe the explanation provided makes sense from a technical standpoint. I consider many of you to be quite knowledgable about the inner working of the AR System and it's interactions with the underlying DB, much more so than
Re: System Center 2012 Service Manager question
Thanks everyone for the info. It has been a big help. @ Shawn Pierson, please repost once you view the demo of the latest version. Danielle R. Henderson NMIC, ISC-O L-3 Stratis Application Admin -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Thursday, May 17, 2012 12:42 PM To: arslist@ARSLIST.ORG Subject: Re: System Center 2012 Service Manager question I can't speak for all situations, but in my experience the vast majority of situations where the tool is switched, it is almost never over functionality and it's rarely due to the costs. Generally these types of changes occur due to organizational changes or desired organizational changes. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Pancia Sent: Thursday, May 17, 2012 11:22 AM To: arslist@ARSLIST.ORG Subject: Re: System Center 2012 Service Manager question What is their driving force to switching? I'm assuming licensing costs and OM costs. If that is the case there are other options with Remedy OnDemand and Remedy Force that could knock out a significant amount of the costs. I think over the next few years you are going to see a significant transition to these solutions. The government may be a little slower to transition, but agencies are slowly but surely adopting cloud and SaaS solutions. BMC may have some other alternatives if you talk to the Account Manager. I have seen a ton of different ITSM solutions. Some good and some bad. A lot of them do 75% of the same thing. The difference is usually implementation. What a lot of organizations find is that they switch for whatever reasons and find that they have a lot of the same issues if not more with the new solution. Also, most organizations only use a fraction of the out of box capabilities and end up doing a lot of customizations instead of using most of the capabilities. If organizations stick to implementing straight out of box functionality first their OM cost will greatly decrease. I have seen organizations use Remedy where a developer has not touched the system in over a year except for patching. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Thursday, May 17, 2012 11:52 AM To: arslist@ARSLIST.ORG Subject: Re: System Center 2012 Service Manager question I'm in a similar situation. BMC has put together a matrix comparing the two, but it's not very complete. According to BMC, SCSM isn't something that has been a competitor to the Remedy platform in the past, so they don't have a well put together comparison between the two. I have put together a much more detailed comparison, and I am going to be sitting in a demo from Microsoft on SCSM next week. Perhaps in two weeks I'll have more information to compare the two. Right now, there are some basic core things missing in SCSM that doesn't have me thrilled to potentially implement it. Some of the major gaps are: - No web interface (other than going through a third party add-on, although their SRM equivalent is SharePoint based.) - No Asset Management (you have to purchase something from a Microsoft partner like Provance.) - Basic configuration tasks are much more difficult (e.g. the ease of setting up an Assignment mapping in Remedy is replaced by something more manual in SCSM which I would compare to setting up an SLA in SLM.) - The product is full of hidden costs, so at least in our organization it's looking like it may potentially be less expensive to keep Remedy and purchase additional licenses rather than implementing SCSM. Microsoft tries to hide lots of expenses hidden into bundles of other products. - SCCM is not a complete overlap with ADDM. The discovery portion of SCSM is basically geared around Windows Servers and Clients, and it is not agentless. I'm also not surWhate that it can do a good job of mapping out relationships like ADDM does. There are several other areas, but most of my initial opinion was based off of SCSM 2008, so I have to wait to see the 2012 demo before I can confidently give a good comparison. On a personal note, I am conflicted because I know Remedy is a better product, but I am also interested in learning other applications so if I got a chance to implement SCSM that could be an interesting challenge. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Henderson, Danielle R. CNTR Sent: Thursday, May 17, 2012 10:38 AM To: arslist@ARSLIST.ORG Subject: System Center 2012 Service Manager question Good Morning everyone, My organization is looking at Microsoft Center 2012 Service
arerror 3324 Escalation problem Quick Question?
ENV: 7.6.04 SP2 (server group) (2 servers) solaris / oracle Cannot select button Disable Escalation in the Administration Configuration menu without error arerror 3324 = the configuration setting is not allowed when the server is a member of a sever group so how do you turn on escalations, if you cannot select it.. (I am sure it is obvious) -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: arerror 3324 Escalation problem Quick Question?
take the server out of server group thans modify setting Server Setting--Configuration: checkbox Server Group member** needs restart Ravi Date: Thu, 17 May 2012 14:36:44 -0400 From: remedy...@gmail.com Subject: arerror 3324 Escalation problem Quick Question? To: arslist@ARSLIST.ORG ** ENV: 7.6.04 SP2 (server group) (2 servers) solaris / oracle Cannot select button Disable Escalation in the Administration Configuration menu without error arerror 3324 = the configuration setting is not allowed when the server is a member of a sever group so how do you turn on escalations, if you cannot select it.. (I am sure it is obvious) -- Patrick Zandi _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: arerror 3324 Escalation problem Quick Question?
I can't find it now but I recall reading that you can only run escalations on one server in the group at least on ARS 6.3. That would explain why you can't select and worth checking. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of ravi rai Sent: Thursday, May 17, 2012 3:34 PM To: arslist@ARSLIST.ORG Subject: Re: arerror 3324 Escalation problem Quick Question? ** take the server out of server group thans modify setting Server Setting--Configuration: checkbox Server Group member** needs restart Ravi Date: Thu, 17 May 2012 14:36:44 -0400 From: remedy...@gmail.commailto:remedy...@gmail.com Subject: arerror 3324 Escalation problem Quick Question? To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG ** ENV: 7.6.04 SP2 (server group) (2 servers) solaris / oracle Cannot select button Disable Escalation in the Administration Configuration menu without error arerror 3324 = the configuration setting is not allowed when the server is a member of a sever group so how do you turn on escalations, if you cannot select it.. (I am sure it is obvious) -- Patrick Zandi _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: arerror 3324 Escalation problem Quick Question?
That is correct - when in server group, then it is controlled in the server group ranking form, and the selection is controlled by that config. You would have to unselect it as part of the server group if you want it to run independently. Regards, Andrew C. Goodall Software Engineer Development Services ago...@jcpenney.com jcpenney 6501 Legacy Drive Plano, TX 75024 jcp.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Thursday, May 17, 2012 2:45 PM To: arslist@ARSLIST.ORG Subject: Re: arerror 3324 Escalation problem Quick Question? ** I can't find it now but I recall reading that you can only run escalations on one server in the group at least on ARS 6.3. That would explain why you can't select and worth checking. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of ravi rai Sent: Thursday, May 17, 2012 3:34 PM To: arslist@ARSLIST.ORG Subject: Re: arerror 3324 Escalation problem Quick Question? ** take the server out of server group thans modify setting Server Setting--Configuration: checkbox Server Group member** needs restart Ravi Date: Thu, 17 May 2012 14:36:44 -0400 From: remedy...@gmail.com Subject: arerror 3324 Escalation problem Quick Question? To: arslist@ARSLIST.ORG ** ENV: 7.6.04 SP2 (server group) (2 servers) solaris / oracle Cannot select button Disable Escalation in the Administration Configuration menu without error arerror 3324 = the configuration setting is not allowed when the server is a member of a sever group so how do you turn on escalations, if you cannot select it.. (I am sure it is obvious) -- Patrick Zandi _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ font face=monospacesize=-3brThe information transmitted is intended only for the person or entity to which it is addressed and brmay contain confidential and/or privileged material. If the reader of this message is not the intendedbrrecipient, you are hereby notified that your access is unauthorized, and any review, dissemination,brdistribution or copying of this message including any attachments is strictly prohibited. If you are notbrthe intended recipient, please contact the sender and delete the material from any computer.br ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SRM 7.6.04 - Changing Companies
If I have understood you right, you want to change the name of the company across the application? I had done this what may be considered the ‘dirty way’.. DB level.. I had written a script to find me all the forms which had fields that had the company name as an equal match.. And I had created a stored procedure to change a companies name and used this in a configuration form that was used to change a companies name globally in a system.. We didn’t care about instances where the company name might have appeared within a string.. So it worked quite accurately and to the best of my knowledge had taken into account all the fields exposed to users that had company names in it as I do not recall any calls related to it from users complaining that the name didn’t change.. The stored procedure took a good 5 to 10 minutes to run for each change.. Cheers Joe From: Tauf Chowdhury Sent: Thursday, April 26, 2012 4:40 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: SRM 7.6.04 - Changing Companies ** So I found that in the SRM Import/Export console, there is an import function that will import to a new company. I'm thinking I can leverage this by exporting the SRD and associations, and then importing into the same environment but picking the new company as -Global- Any ideas? On Thu, Apr 26, 2012 at 4:02 PM, Tauf Chowdhury taufc...@gmail.com wrote: All, I've got a requirement to have to change SRDs and of course the PDTs and AOTs associated with it so that the Company is set to -Global- instead of a specific company. By default, the SRD, PDT, and AOT forms each have the company field set to RO. Has anyone ever done this before and if so, are there any other supporting forms involved in changing the Company? The options I'm thinking are to find the AL that makes the field RO and disable it temporarily so I can modify the Company directly. The other option may be to export and re-import with the updated Company. -- Tauf Chowdhury -- Tauf Chowdhury ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
dev studio for linux?
Hi Folks, I just switched my workstation from Windows to Linux. I don't see a download offering for Developer Studio for Linux. Am I missing something? Note that the platform listed at the product name is Linux, but the platform listed for AR System Clients ... is Windows. Is there anyone out there running Dev Studio on Linux? Many thanks in advance, Tony Jurado Release Manager, Services Engineering IBM Security Services ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Areinline: 39673374.gif
JOB: Rockville MD, two positions
I am looking for two consultants to help out with a project in Rockville Maryland. ITSM Consultant - someone who knows Remedy ITSM 7.6.04, especially custom configuration. Someone who is very good at looking at a very inefficient manual IT process and can extract out of that Service Catalog entries, approvals, custom configuration data, foundation data, etc and then configure remedy to form a better process. It would be nice to have someone that is a Certified BMC/Remedy ITSM Application Administrator. This is not a position where someone is going to hand you a well thought out process that would be easily mapped to Remedy ITSM. It is much more of a position where someone who knows how Remedy ITSM can improve IT Operations through better processes and configuration of the tool. ADDM Consultant - someone who knows Atrium Discovery and Dependency Mapping well. Install the product, get something demonstrable working, and help the organization learn how this tool can make operations more efficient. This is not a position where a lot of specifications are going to be provided or required. It is much more of a position of iterating from a small, focused discovery, and then constantly improving the use of the tool in operations. The usual problems of deploying the tool through operations and getting approval from IT Security will be required. Contact bob.l...@klslconsulting.com if you are interested. -- Bob Lind IT Jobs posted daily on klslconsulting.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
ARSPerl Install Problem - 7.6 Linux Server
Ok here is the problem, we are trying to upgrade to 7.6 Linux 64bit system, the ARsperl 1.91 1.93 versions. I tried to install the ActiveState 32bit binary for my system and the ARSperl installed, but then my DBI and DBD:Oracle failed, with the classic message about my 32BIT libs, I can't use a 32bit Oracle client as its required by Remedy to have a 64bit client (I am guessing other modules will be messed up too). So then I tried a 64bit compile of perl in which all my modules that I need for scripts are fine but then ARSperl wont install with either the -m32 flags or trying to do a 64bit install. It baffles me that others are not having this issue, and that there is not a 64bit ARSPerl out there yet, considering 64bit servers have been out for awhile. Is it true that BMC is not going to update there C-Libs after this release and that ARSPerl is essentially dead and this is why there is not a version out yet? We have over 250 scripts on our server mixed in with workflow. Ok, enough complaining. I haven't been able to compile a 32bit perl as of yet, but my only last thought is back in the HPUX days I would have to static compile a few modules while compiling Perl. But I have no idea the lib flags and everything I would need to pass it in order. Please help! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: dev studio for linux?
There isn't one for Linux.. the client tools are developed for Windows.. There used to be unix based client tools about a decade ago which were discontinued on account of a thin user base for them.. Joe From: Anthony Jurado Jr Sent: Thursday, May 17, 2012 1:37 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: dev studio for linux? ** Hi Folks, I just switched my workstation from Windows to Linux. I don't see a download offering for Developer Studio for Linux. Am I missing something? Note that the platform listed at the product name is Linux, but the platform listed for AR System Clients ... is Windows. Is there anyone out there running Dev Studio on Linux? Many thanks in advance, Tony Jurado Release Manager, Services Engineering IBM Security Services ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are 39673374.gif
Re: dev studio for linux?
Although being Java based could the Windows files be used in Linux? I am pretty sure I have seen people mention they are using Dev Studio on Linux. Jason On Thu, May 17, 2012 at 3:15 PM, Joe Martin D'Souza jdso...@shyle.netwrote: ** There isn't one for Linux.. the client tools are developed for Windows.. There used to be unix based client tools about a decade ago which were discontinued on account of a thin user base for them.. Joe *From:* Anthony Jurado Jr ajur...@us.ibm.com *Sent:* Thursday, May 17, 2012 1:37 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* dev studio for linux? ** Hi Folks, I just switched my workstation from Windows to Linux. I don't see a download offering for Developer Studio for Linux. Am I missing something? Note that the platform listed at the product name is Linux, but the platform listed for AR System Clients ... is Windows. Is there anyone out there running Dev Studio on Linux? Many thanks in advance, Tony Jurado Release Manager, Services Engineering IBM Security Services _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 39673374.gif
Re: dev studio for linux?
It is sad that they cannot make one. But with the possibility of the takeover shredding the whole BMC line should make you shudder . I really hope he fails: then making one might become a reality I would like one too Sent from my iPhone On May 17, 2012, at 20:01, Jason Miller jason.mil...@gmail.com wrote: ** Although being Java based could the Windows files be used in Linux? I am pretty sure I have seen people mention they are using Dev Studio on Linux. Jason On Thu, May 17, 2012 at 3:15 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** There isn't one for Linux.. the client tools are developed for Windows.. There used to be unix based client tools about a decade ago which were discontinued on account of a thin user base for them.. Joe From: Anthony Jurado Jr Sent: Thursday, May 17, 2012 1:37 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: dev studio for linux? ** Hi Folks, I just switched my workstation from Windows to Linux. I don't see a download offering for Developer Studio for Linux. Am I missing something? Note that the platform listed at the product name is Linux, but the platform listed for AR System Clients ... is Windows. Is there anyone out there running Dev Studio on Linux? 39673374.gif Many thanks in advance, Tony Jurado Release Manager, Services Engineering IBM Security Services _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: dev studio for linux?
Pat, Not sure I understand this statement But with the possibility of the takeover shredding the whole BMC line should make you shudder . I really hope he fails Dave On May 17, 2012, at 9:16 PM, Pat Zandi remedy...@gmail.commailto:remedy...@gmail.com wrote: ** It is sad that they cannot make one. But with the possibility of the takeover shredding the whole BMC line should make you shudder . I really hope he fails: then making one might become a reality I would like one too Sent from my iPhone On May 17, 2012, at 20:01, Jason Miller jason.mil...@gmail.commailto:jason.mil...@gmail.com wrote: ** Although being Java based could the Windows files be used in Linux? I am pretty sure I have seen people mention they are using Dev Studio on Linux. Jason On Thu, May 17, 2012 at 3:15 PM, Joe Martin D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** There isn't one for Linux.. the client tools are developed for Windows.. There used to be unix based client tools about a decade ago which were discontinued on account of a thin user base for them.. Joe From: Anthony Jurado Jrmailto:ajur...@us.ibm.com Sent: Thursday, May 17, 2012 1:37 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: dev studio for linux? ** Hi Folks, I just switched my workstation from Windows to Linux. I don't see a download offering for Developer Studio for Linux. Am I missing something? Note that the platform listed at the product name is Linux, but the platform listed for AR System Clients ... is Windows. Is there anyone out there running Dev Studio on Linux? 39673374.gif Many thanks in advance, Tony Jurado Release Manager, Services Engineering IBM Security Services _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: dev studio for linux?
It is not fully java based – there are portions of it that gets installed in the windows system registry so its not something that you could just move files across and make it work.. You may have heard about the earliest version which was distributed at a user conference many years ago on a thumb drive.. that was 100% java based which could be technically run off the stick drive even.. There is a possibility that might have been possible to use on LINUX.. Good thought though.. makes me almost want to try to see if its possible – only I do not currently own enough hardware resources to ‘experiment’... Joe From: Jason Miller Sent: Thursday, May 17, 2012 8:01 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: dev studio for linux? ** Although being Java based could the Windows files be used in Linux? I am pretty sure I have seen people mention they are using Dev Studio on Linux. Jason On Thu, May 17, 2012 at 3:15 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** There isn't one for Linux.. the client tools are developed for Windows.. There used to be unix based client tools about a decade ago which were discontinued on account of a thin user base for them.. Joe From: Anthony Jurado Jr Sent: Thursday, May 17, 2012 1:37 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: dev studio for linux? ** Hi Folks, I just switched my workstation from Windows to Linux. I don't see a download offering for Developer Studio for Linux. Am I missing something? Note that the platform listed at the product name is Linux, but the platform listed for AR System Clients ... is Windows. Is there anyone out there running Dev Studio on Linux? Many thanks in advance, Tony Jurado Release Manager, Services Engineering IBM Security Services ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are 39673374.gif
Re: Pushing attached file to external app and then pulling parsed data back
Mmm. One way to get the file out, using run macro to create arx report file, write a wrapper around the run macro. Run script on server, arx file will extra to attachment. If that app that parse attachment file reside on another system/server, FTP/scp. To get data back/file If you are putting the attachment back to same request that has original file, ... Try web services. If you parse data in another db, use view to read that data. Hope this helps -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Pushing-attached-file-to-external-app-and-then-pulling-parsed-data-back-tp7563943p7564905.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
