Re: how to get the values instead of ID's in the Database table

2012-05-16 Thread Misi Mladoniczky
Hi, I think we are overcomplicating things. I have read between the lines here, and think that Sagar is talking about a simple multi-tier search-type char-menu... You should give us detailed examples, otherwise we can never help you. This could be your setup: FormProductCat: FieldProdCat

Chris Ingalls is out of the office

2012-05-16 Thread Chris Ingalls
I will be out of the office starting 05/16/2012 and will not return until 05/17/2012. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are

question on Incident Console Window Open vs. Search Incident Window Open

2012-05-16 Thread smiley
hello all! I am having difficulty with a process I'm trying to add to the Incident page (HPD:Help Desk) when the Window has been Opened on an Incident. (Active Link on Window Open) Evidently, in ITSM (version 7.6.03, mid-tier, windows), if one Searches for an Incident and single or multiple

Re: question on Incident Console Window Open vs. Search Incident Window Open

2012-05-16 Thread Joe Martin D'Souza
$USER$ does not have strange values on any version of AR System that I have known – and I have been through quite a few versions.. It is the Remedy User Login Name used to login into the client. There is NO OTHER possible value it can assume. Values like ‘Remedy Application Service’,

Re: question on Incident Console Window Open vs. Search Incident Window Open

2012-05-16 Thread Nancy Tietz
Hi Joe – This is that same request from before, - sigh. I’m attempting to notify the user via a popup that this particular incident that they have wandered into, is already currently open by someone else. However – I am saving the $USER$ value in an Active Link on Window Open, and YES it Does

Re: question on Incident Console Window Open vs. Search Incident Window Open

2012-05-16 Thread Nancy Tietz
Hi again! I found it! My field that was getting the ‘smim’ in it from Searching… had a ‘Default Value’ of ‘$USER$’ – so I wiped that out – a default value is not needed – and now it works as expected!! Those Default Values are tricky!It was getting the search user id in it

Re: Cleaning Special Characters from a Character Field

2012-05-16 Thread Axton
I would not use client side technologies for data validation or sanitization; at some point someone or something will bypass it (api, web service, import, workflow, etc.). I wrote a Java plugin that uses the java regex capabilities to do something similar. It relatively simple to write and you

Re: Cleaning Special Characters from a Character Field

2012-05-16 Thread Jason Miller
I agree. I haven't had a chance to write a plugin yet but we have a few cases where we built DB functions or server side scripts (.vbs, .bat) that we call from a Filter using Direct SQL or Run Process. It isn't as elegant as what Axton describes but is more or less the same concept; off load the

Load Balancer Mid Tiers

2012-05-16 Thread Mike Hocks
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

Re: question on Incident Console Window Open vs. Search Incident Window Open

2012-05-16 Thread Joe Martin D'Souza
You got to be careful on what you set your fields when you open windows, using your window open active link as well as ‘Get Entry’ filters.. You can end up setting in the fields what you set into them during such operations, irrespective to what may already be existing in the database – it will

Re: Cleaning Special Characters from a Character Field

2012-05-16 Thread Jeff Lockemy (QMX Support Services)
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 quick and dirty solution to buy us more

Re: Load Balancer Mid Tiers

2012-05-16 Thread Goodall, Andrew C
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

Re: Load Balancer Mid Tiers

2012-05-16 Thread Pruitt, Christopher (Bank of America Account)
We have multiple Load Balancers pointing to multiple Mid-Tiers and the multiple Mid-Tiers are all point to a single AR Server. Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.com Confidentiality Notice: This message and any files

Re: Load Balancer Mid Tiers

2012-05-16 Thread pritch
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.

Re: Load Balancer Mid Tiers

2012-05-16 Thread Hocks, Mike (DOT)
Awesome, thanks a lot for the reply! -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pruitt, Christopher (Bank of America Account) Sent: Wednesday, May 16, 2012 2:21 PM To: arslist@ARSLIST.ORG Subject: Re: Load Balancer

Re: Load Balancer Mid Tiers

2012-05-16 Thread Hocks, Mike (DOT)
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

Re: Load Balancer Mid Tiers

2012-05-16 Thread Brian Goralczyk
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

Re: Load Balancer Mid Tiers

2012-05-16 Thread patrick zandi
server group 3 heads with everything loadbalenced 1 oracle db replicated to standby system what more do you need. On Wed, May 16, 2012 at 3:28 PM, Hocks, Mike (DOT) mike.ho...@state.mn.uswrote: Interesting, we need to build out our environment for 500 concurrent connections, do you think we

Re: question on Incident Console Window Open vs. Search Incident Window Open

2012-05-16 Thread Nancy Tietz
Hi Joe – I thought you said you were nice on Wednesdays? I’m not carelessly manipulating field values… this is my own custom field. It is getting set to the database via a ‘Direct SQL’. (which was your recommendation in the first place a few days ago…) Perhaps my descriptions are not easy to

Re: Cleaning Special Characters from a Character Field

2012-05-16 Thread Axton
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

Re: Cleaning Special Characters from a Character Field

2012-05-16 Thread Jeff Lockemy (QMX Support Services)
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

Re: Adding HR Department to ITSM Application using Multi-tenancy

2012-05-16 Thread Terry Bootsma
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

Re: Load Balancer Mid Tiers

2012-05-16 Thread Hocks, Mike (DOT)
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

Re: Load Balancer Mid Tiers

2012-05-16 Thread Hocks, Mike (DOT)
Thanks Patrick From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Wednesday, May 16, 2012 2:53 PM To: arslist@ARSLIST.ORG Subject: Re: Load Balancer Mid Tiers ** server group 3 heads with everything loadbalenced 1 oracle db

Re: Load Balancer Mid Tiers

2012-05-16 Thread Nathan Aker
Mike, per the latest BMC Reference Architecture document, the Midtier can handle up to 150 peak concurrent users per CPU and 300 peak concurrent users per 2 CPU virtual machine (VM). The performance ceiling is typically with the instance of the webserver supporting the Midtier and the

Re: Load Balancer Mid Tiers

2012-05-16 Thread Hocks, Mike (DOT)
Thanks a lot Nathan I appreciate your help. -Mike -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nathan Aker Sent: Wednesday, May 16, 2012 4:23 PM To: arslist@ARSLIST.ORG Subject: Re: Load Balancer Mid Tiers Mike, per

Re: Load Balancer Mid Tiers

2012-05-16 Thread Brian Goralczyk
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

Re: Load Balancer Mid Tiers

2012-05-16 Thread Brian Pancia
We just set up a similar environment with 7.6.04. We setup 1 mid-tier to 1 ARSystem server and had another ARSystem server in the server group for admin functions, so the final was 2 mid-tiers and 3 arsystem servers. Keep in mind that the sticky bit needs to be enabled between the load balancer

Re: Load Balancer Mid Tiers

2012-05-16 Thread Jason Miller
Sounds like a good size server however as others have pointed out the configuration doesn't seem ideal for the load you are looking at. The two things that stick out to me are the AR server and MT are sharing this server and it was built using the pre-configured stack installer. If you are going