AIE Updates..

2010-04-16 Thread Remedy
Dear List, I have an AIE job that pulls data into an ARS 7.1 / CMDB 2.1 Class, from a an Oracle database (ARS 7.1 / CMDB 2.1 Class) table. The job is successfully pulling data from the source into the destination. I am using the option to update record only if checksum for mapped field has

OT: Extracting digits from a character field

2010-04-16 Thread Jason Miller
This might start a whole new debate (and kind of what I am looking to do)... I remember learning that train of though (use an AL to run on the client and use their resources when you can and built filters only when you have to) but I have started to hear the opposite over the last few years...

C APIs to create Change ticket.

2010-04-16 Thread Anuj DUA
Hello List, Thanks to please let me know the source of C APIs and the respective API to create change ticket through C programming. With Regards, Anuj Dua ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org

Re: C APIs to create Change ticket.

2010-04-16 Thread Konrad Banasiak
Hi, What is the version of your Change Management Application? Cheers Konrad TopPositions Really only one secure Plugin SSO for BM Remedy AR System. Http://www.remedy-sso.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of

Interpreting ARS server SQL logs

2010-04-16 Thread L G Robinson
Hi Folks, I have a question about interpreting ARS server SQL logs. I am in the process of migrating from a Sybase database server to an Oracle server and I am trying to evaluate the performance of the Oracle server. I have turned on API and SQL logs and have them both written to a combined log

Re: Incoming mail message error

2010-04-16 Thread Rogerio
I was guessing that. In fact, the attachment is corrupted. I've found something in a java forum about this error: Looks like you have some improperly encoded data. If you don't care about the errors you can set the System property mail.mime.base64.ignoreerrors to true. You might also want to

Re: Attention: List Administrator Dan Bloom... ADM

2010-04-16 Thread Daniel Bloom
It may be fixed, but I didn't do anything, so I am sure it will recur. I have asked Joe to send me an example since I have never had it, and if anyone else can send me an example I would appreciate it. Send to arsl...@danielbloom.ca please. thanks Dan _ From: Action Request

Re: Interpreting ARS server SQL logs

2010-04-16 Thread Ben Chernys
For SQL logs ONLY (I presume you edited your sample log and left out the SQL OK) You should have had an OK immediately following every SQL Log entry Then, OK - SQL when they follow each other (and are the same thread id of-course) Cheers Ben Chernys Senior Software Architect Software Tool

Re: Rejected posting to arsl...@listserv.rbugs.com

2010-04-16 Thread Daniel Bloom
Thanks Warren; I'm posting my answer to the list since it could be of use to others: I have had that one too. 1) Sometimes it is legitimate, either I used an exact subject line to someone else's post, or I accidentally hit send twice 2) sometimes a mailer in the middle looses the

Re: Interpreting ARS server SQL logs

2010-04-16 Thread L G Robinson
Hi Ben, Nope... I did not edit out any lines, just the actual text of the SQL Select statement. My logs don't seem to have any OK's in them. Thanks. Larry On Apr 16, 2010, at 9:27 AM, Ben Chernys wrote: For SQL logs ONLY (I presume you edited your sample log and left out the SQL OK)

Re: Attention: List Administrator Dan Bloom... ADM

2010-04-16 Thread Rick Cook
I had a couple dozen of them, all of which I summarily executed. Rick -Original Message- From: Daniel Bloom danielbl...@rogers.com Date: Fri, 16 Apr 2010 09:11:29 To: arslist@ARSLIST.ORG Subject: Re: Attention: List Administrator Dan Bloom... ADM It may be fixed, but I

Re: Benefit of Prefetch Remedy midtier 7.1

2010-04-16 Thread Grooms, Frederick W
Wow . Am I am special or what? ( Sorry, it is Friday and I needed a bit of humor) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of cpgold Sent: Thursday, April 15, 2010 5:55 PM To: arslist@ARSLIST.ORG Subject: Re: Benefit

Re: Reopened date does not get populated

2010-04-16 Thread SriSamSri Appecherla
Hi Murtuza, The Re-open option is available under the Resolved option in the Process flow status. I find no Re-open option for a Closed ticket. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 On Fri, Apr 16, 2010 at 9:48 AM, Murtuza B murtuza.bookw...@ubs.com wrote: ** I had the same

Re: TR vs DB sanity check please

2010-04-16 Thread Lyle Taylor
Actually, that is not correct - the first two statements are NOT equal. The first statement will fire if AssignedToTech is set to $NULL$, and the database value is NOT $NULL$. The second statement will not. However, the second and third statements are essentially equivalent - they will both

Re: Interpreting ARS server SQL logs

2010-04-16 Thread Ben Chernys
I seem to recall that you may be right. It may be a new ARS feature (since 5x). I doubt that I have any 5.x logs around any more. In effect that means you cannot tell the duration of the SQL call. You can probably come close by using any next line in the log - but you have no idea how much

Re: Benefit of Prefetch Remedy midtier 7.1

2010-04-16 Thread James Chafin
The way Doug Mueller explained it to me at a night with the engineers @ the Las Vegas WWRUG, is prefetch loads objects based on all your permission combinations. The fewer combinations the faster it caches. Of course that memory might be a little hazy... It was a great night!! Sent from

Re: Reopened date does not get populated

2010-04-16 Thread strauss
There is a Re-open Incident link under the Functions menu (left sidebar) that appears on a Closed Incident in both 7.0 and 7.6. The link may not be visible if your account does not have at least a Support Group Lead role. Christopher Strauss, Ph.D. Call Tracking Administration Manager

Re: Interpreting ARS server SQL logs

2010-04-16 Thread Grooms, Frederick W
Just looking at your example below Line03 - Line02 would be the SQL to the database Line04 - Line01 would be the API call wrapper around the SQL call Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ben Chernys

Shipping Manifest in Remedy

2010-04-16 Thread Sanford, Claire
I am having a hard time wrapping my brain around this one. Our management team wants me to create a shipping manifest. The guy at the dock would scan the assets into the form, the form would hit the asset record, populate it and then when he presses a button the form would print out all the

Merge Workflow

2010-04-16 Thread Kemes, Lisa
I have a Filter that sets a field on Submit. I have another Filter that sets the same field (with slightly different data) on Modify. I made the mistake of adding Merge to my Submit Filter, thinking (foolishly) that it would only do what I needed it to do if the Merge was a submit or new

Re: Merge Workflow

2010-04-16 Thread Joe D'Souza
MERGE filters will fire only on import. SUBMIT or MODIFY filters do not execute while importing data. They are mutually exclusive operations on any form. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Kemes, Lisa

Re: {Remedy ARS} Re: need to design a counter

2010-04-16 Thread Joe D'Souza
I don't understand why you want to store that information when you can do a lookup at any point of time and get the latest count using a select count(*) using whatever conditions you may want to, to count the work log entries that have that specific value that you want to run a count on.. Joe

Re: need to design a counter

2010-04-16 Thread Opela, Gary L CTR USAF ABW 72 ABW/SCOOA
I've done this. On the form that has the counter, put a display only radio button. Whenever a ticket is submitted in form two, push a value to the radio button. Next, put a filter on the form with the counter that runs when the radio button != $NULL$. The If actions is Integer = Integer + 1. This

Re: Shipping Manifest in Remedy

2010-04-16 Thread Roger Justice
You might be able to do this with a later version that uses the Aeroprise application on a remote devise. -Original Message- From: Sanford, Claire claire.sanf...@memorialhermann.org To: arslist@ARSLIST.ORG Sent: Fri, Apr 16, 2010 12:01 pm Subject: Shipping Manifest in Remedy I am

Friday Humor: Marketing Concepts Explained...

2010-04-16 Thread Joe D'Souza
A Management Professor was explaining marketing concepts to the Students: 1. You see a gorgeous girl at a party. You go up to her and say: I am very rich. Marry me! - That's Direct Marketing 2. You're at a party with a bunch of friends and see a gorgeous girl. One of your friends goes up to her

Re: TR vs DB sanity check please

2010-04-16 Thread Mueller, Doug
Given that there is confusion about this topic, I wanted to weigh in on the topic and be very clear and very explicit about that is happening. First, some definitions: Say you have a field named A, what are the various interpretations TR.A -- Get the current transaction value of the field A.

Re: Extracting digits from a character field

2010-04-16 Thread Joe D'Souza
It really depends on the 'kind of work' that you are having the server perform. A major factor to consider would also be, your environment. What kind of clients would be interfacing with the AR Server? Just your regular WUT or the MT client? Or would you be using web-services or a variety of other

GLEWF Sorting

2010-04-16 Thread Rem Valenzuela
I've searched for an answer to how to sort using the GetListEntryWithFields method using the 7.1 .NET API. I've not found any good examples in VB. Here is a C# example that I was able to get, but am having trouble with translating the sortinfo piece of the command. Can someone help? Does

Logic in active links vs. filters

2010-04-16 Thread Mueller, Doug
First, I changed Jason's subject line -- was OT: Extracting digits from a character field -- because the topic is really different and I wanted to make sure that folks can see the discussion for what it is really about. With this said, I will share what is best practice and provides the best

Re: Merge Workflow

2010-04-16 Thread Mueller, Doug
Lisa, Merge is something that can do a create or can do a set. It depends on whether there is a record in place or not. That is correct. Be careful using the Submit filter as you describe because that will fire on Submit as well as Merge which may or may not be right because you may or may

Re: Interpreting ARS server SQL logs

2010-04-16 Thread Juan Ingles
The timestamp on each line is when that event STARTED. To get duration you have to subtract that time from the next event. In this case the SQL statement started running at line 02 (08:25:23.5178) The SQL finished at line 03 (08:25:24.6918) So the SQL took 1.174 secs. Note that since the next

Re: Extracting digits from a character field

2010-04-16 Thread Jason Miller
Thanks Joe! I guess I should have been a little more specific... I agree with your and Doug's point (See new thread: Logic in active links vs. filters) of always using Filters for logic/rules that you always want to happen. I was referring more to work flow processing that is not critical

Re: TR vs DB sanity check please

2010-04-16 Thread LJ LongWing
Doug, I have tried to explain this MANY times but have never been able to do so as eloquently as you just did. That said, I will point all future questions about this subject (and there will continue to be questions) to your post. From: Action Request System discussion list(ARSList)

Re: Logic in active links vs. filters

2010-04-16 Thread Mueller, Doug
Jason, I guess the question now becomes a higher order one If you have logic in the system that is not business rules (I don't use critical business rules because something either is or is not related to enforcing business rules whether they are critical or casual rules, they are rules for

How to accurately test fail-over

2010-04-16 Thread William Abdo
Hello All, Do any of you know of a tried, tested and accurate method to test fail-over for multiple AR Servers in the server group? Some of the many functions that need to be tested are: - AR Server - Email - Flash Boards - Approval Server To see if the system would fail over from A to B: I have

Re: How to accurately test fail-over

2010-04-16 Thread Lyle Taylor
Shutting down AR Server A should do it if you have your operations rankings configured correctly. If it doesn't fail over (note that it can take a couple minutes to fail over), then it sounds like the other servers don't think that they can take over those operations (for example, if their

Re: How to accurately test fail-over

2010-04-16 Thread LJ LongWing
Pull the network cable?...Power Cord? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of William Abdo Sent: Friday, April 16, 2010 3:04 PM To: arslist@ARSLIST.ORG Subject: How to accurately test fail-over Hello All, Do any

Re: How to accurately test fail-over

2010-04-16 Thread William Abdo
Thank You Lyle, We have the ranking configured to A as 1 and B as 2. We shut down server A and it did not fail over to B. Wow according to what you stated this should of worked. Is there anything else we should check? Also should those processes be in a running state on the B server prior to the

Re: How to accurately test fail-over

2010-04-16 Thread Tommy Morris
Pour some chili on it... that makes everything better. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Friday, April 16, 2010 4:25 PM To: arslist@ARSLIST.ORG Subject: Re: How to accurately test fail-over

Re: How to accurately test fail-over

2010-04-16 Thread Lyle Taylor
All processes in the server group should be running at all times. Nothing will start automatically. As I understand it, the way the server group works is that the backend process apps (e.g., e-mail) will stay awake but in a standby state. They periodically poll the database to see if they

Re: Logic in active links vs. filters

2010-04-16 Thread Lyle Taylor
Doug, Thanks for this excellent post. I think these are excellent points. I have to note, however, that when customizing an existing application, this is not always possible. A case in point is in trying to validate Asset/CI attribute values when the sandbox is enabled (at least in CMDB 2.0

Re: How to accurately test fail-over

2010-04-16 Thread William Abdo
Thank you for Lyle your assistance Respectfully; William Abdo Sent from my Treo™ Pro -Original Message- From: Lyle Taylor tayl...@ldschurch.org Sent: Friday, April 16, 2010 5:31 PM To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Subject: Re: How to accurately test fail-over All processes