Re: Ticket Query (part deux)

2007-01-26 Thread brian . bishop
Forget the last 4 lines. Just do a query on the Request ID field of the integer value. So taking Johns solution do a set fields from arschema on the nextid, deduct the number 10,20,50 whatever from it and then query Request ID integer value. It will find all the tickets after that number.

Consuming Web Service - How to pass user ID and Password?

2007-01-26 Thread Barb Wagner
HI All - Probably a simple question for those that have done work with web services... We are trying to consume a web service and the site that the service is hosted on is protected by a User ID and Password. How do we submit the ID and Password to be authenticated in a web service? Remedy

Re: ITSM - Verses What ?

2007-01-26 Thread Rick Cook
FrontRange ITSM is a strong competitor, if you go by looks and OOB functionality. Aand then you install it and begin to look at the guts of it. When I did, I was never as thankful for Doug's architectural genius. And while the light customizations can be done as easily there as in Remedy

Re: Exported Forms loosing Application

2007-01-26 Thread Dave Fincher
Probably possible you would have to export and import the entire application in order to maintain the role permissions on the forms. Dave Fincher L. J. Head [EMAIL PROTECTED] wrote: ARS 6.3 I have a deployable application in dev...when I export a form and related workflow from this

Comparing feild lengths

2007-01-26 Thread Kyle Whitley
I have two temp fields that I have created some workflow to compare length between the two. First field is set by the user when they type in a value, the second field is the control (ie the first field must be = the second field). Problem is that when the first field is double digits ( 9)

arstat utility

2007-01-26 Thread Mike Parker
Good morning list: Is anyone aware where I could download the arstat utility? I used to have it, but I can't find it anywhere now. Thank you! _ Get in the mood for Valentine's Day. View photos, recipes and more on your

Re: BMC Support Web Site Performance

2007-01-26 Thread Carina Burns
From: Carey Matthew Black [EMAIL PROTECTED] Subject: Re: BMC Support Web Site Performance In-Reply-To: [EMAIL PROTECTED] Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Disposition: inline Carina, I understand your experiences. (and I have been there too.)

Re: Comparing feild lengths

2007-01-26 Thread Lucero, Michelle - IST contractor
Are ztemp1 and ztemp2control integer or character fields? Thanks, Michelle -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kyle Whitley Sent: Friday, January 26, 2007 8:34 AM To: arslist@ARSLIST.ORG Subject: Comparing feild

Re: Comparing feild lengths

2007-01-26 Thread Kyle Whitley
They are characterthey should be integer shouldn't they? Kyle Lucero, Michelle - IST contractor wrote: Are ztemp1 and ztemp2control integer or character fields? Thanks, Michelle -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On

Re: BMC Support Web Site Performance

2007-01-26 Thread Rick Cook
You mentioned the word culture. I think that may be a bigger player as outsourcing of support increases. It doesn't matter if the overseas support people are trained as well, are as smart, or speak English (or whatever your native language is) as well as the CA people do, one thing remains, and

Re: Ticket Query (part deux)

2007-01-26 Thread Richard Crosby
Thanks everyone for the ideas. It's more work than I expected and have no problem telling the customer No. =) However, when I have time one of these days I plan to test out some of the ideas just for the learning experience. Cheers, Richard

Re: Comparing feild lengths

2007-01-26 Thread Lucero, Michelle - IST contractor
Yes. The LENGTH of the values should be set into integer fields and then compared. Michelle -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kyle Whitley Sent: Friday, January 26, 2007 8:53 AM To: arslist@ARSLIST.ORG

Re: Charge back functionality in Remedy Help Desk for service requests?

2007-01-26 Thread Julie Kanakanui
Thanks, folks, for the info and suggestions... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are

Re: Comparing feild lengths

2007-01-26 Thread Mike White
Yes - you're performing a numeric comparison. Alphanumeric comparisons start at the leftmost byte - regardless of length. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED]

Re: Comparing feild lengths - Resolved

2007-01-26 Thread Kyle Whitley
Michelle, Using the integer fields fixed the issue. Thanks I was using the LENGTH but with the character fields. Thanks Kyle Lucero, Michelle - IST contractor wrote: Yes. The LENGTH of the values should be set into integer fields and then compared. Michelle -Original Message-

Re: Ticket Query (part deux)

2007-01-26 Thread Rick Cook
Richard, I don't know if you saw my submitted idea, but it was to do a search of (('Entry ID' = (nextId - 100)), put the results in a table field, sort it by Entry ID descending, and have a chunk value of 50 on the table field. That would give you the last 50 tickets. The only glitch is that I

Re: arstat utility

2007-01-26 Thread Shellman, David
Mike, What functionality did the arstat utility provide? The same functionality may exist in the Server Statistics which were added to the later versions of the server. You need to turn those on within the admin tool. Dave -Original Message- From: Action Request System discussion

ARS 7, Windows 2003 (64bit), Oracle 10g

2007-01-26 Thread Russell Wurth
All, I am attempting to set up a Windows Server 2003 (64 bit) with Oracle 10g and ARS 7 on the same box. I am looking for any assistance from anyone with a similar configuration. I have performed installations on various UNIX platforms many times before, and a few Windows 32 bit ones, but never

Re: OT: ITSM Total Cost of Implementation Discussion

2007-01-26 Thread patrick zandi
Here is BMC's ITIL Best Practives Director's Article from DECEMBER 2006 --- This might give you some more insight Norm. http://www.enterpriseleadership.org/listen/podcast-turbitt/view?searchterm=Ken%20Turbitt http://www.bmc.com/BMC/Common/CDA/hou_Page_Detail/0,3464,9926222_10636326,00.html look

Re: When is TR valid

2007-01-26 Thread Thad Esser
If I understand your intent, you want to know when the status changed from any other value to Fixed. Adding the TR to the first part offers no real performance advantages that make it worth the added confusion. This: 'Status' = Fixed AND 'Status' != 'DB.Status' works just as well and

Re: When is TR valid

2007-01-26 Thread L. J. Head
I think that what you have there is the best you can get. It verifies that the TR is changing (even if it isn't)...and then if it has a TR value but it isn't actually changing the second half catches that -Original Message- From: Action Request System discussion list(ARSList)

Re: OT: ITSM Total Cost of Implementation Discussion

2007-01-26 Thread Kaiser Norm E CIV USAF 96 CG/SCWOE
It comes down to a question of who should dictate your process, I think-you or the vendor? Here's the scenario. You have a first-rate operation consisting of 2,000 employees. The way you do business is solid because you've turned high profits for the past ten years. Don't mess with success.

Re: ARS 7.0.1 Patch 1 - Any Issues on Windows Server 2003/SQL Serv er 2005?

2007-01-26 Thread strauss
ARS 7.0.01 Patch 001 appears to have fixed a major bug introduced in 7.0.01 that caused SSL AREA connections to stop working. I am running a fresh install of _everything_ using the Patch 001 code in a similar environment only all x64 (Windows Server, SQL Server) systems. So far I have not seen any

Re: ARS 7.0.1 Patch 1 - Any Issues on Windows Server 2003/SQL Ser v er 2005?

2007-01-26 Thread Carter, Craig J Civ ARPC/DPD
Thanks for the info. I'm doing fresh installs as well so will report anything significant I find. //SIGNED// CRAIG J. CARTER _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Friday, January 26, 2007 10:08 AM To:

Re: ITSM - Verses What ?

2007-01-26 Thread Bradford Bingel
The most useful guides might be: - IT Service Desk comparison, Gartner Research (May 2003) -- possibly updated in May 2006 - Asset Portfolio Management comparison, META Group (October 2004) -- summary at http://www.bmc.com/products/attachments/meta_asset_portfolio_mgmt.pdf Hope this

Re: OT: ITSM Total Cost of Implementation Discussion

2007-01-26 Thread Rick Cook
Well, I think we're on the same page here, Norm. I prefer to make the software conform to the business, rather than forcing the business to conform to the software. BMC says ITSM 7 can do that, and I think to a large extent it can, though through means that are new to us old-ITSM guys. That

Re: ITSM Total Cost of Implementation Discussion

2007-01-26 Thread patrick zandi
I would think, Knowing the Air Force a little.. That reprogramming the old dog manager who had been there forever mindset -- would be very difficult. Which in turn would break the real functionality of the application in the first place. Otherwise like hundreds of other systems the military

Thanks for the Memories

2007-01-26 Thread Lori Gumbiner
Dear Listers, Today is my last day as a Remedy Developer. I am off to join the ranks of one of my ARS clients to work as an analyst in the dynamic world of Telecommunications. I want to thank each of you for supporting the ARSLIST - the times I found help here are innumerable. Since I first

Re: Thanks for the Memories

2007-01-26 Thread Rick Cook
Lori, we'll miss you here - best of luck in your new place and in your new job. Rick On 1/26/07, Lori Gumbiner [EMAIL PROTECTED] wrote: ** Dear Listers, Today is my last day as a Remedy Developer. I am off to join the ranks of one of my ARS clients to work as an analyst in the dynamic world

Re: OT: ITSM Total Cost of Implementation Discussion

2007-01-26 Thread Ben Cantatore
See my comments below: Kaiser Norm E CIV USAF 96 CG/SCWOE [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 01/26/2007 11:05 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject OT: ITSM Total Cost of Implementation

Re: How to start using field 112 after 200k rows

2007-01-26 Thread William Broderick
Thanks to all who responded. If performance turns out to be an issue as L J and David suspect, I'll have to try a different approach. Thanks again, Bill ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org

Re: Exported Forms loosing Application

2007-01-26 Thread Axton
One way I 've worked around this is to perform the initial import, which strips the role permissions, modify the app and add the new forms, then perform the import a second time using the 'import in place' option. The second import will import the forms as members of the application, thus

Re: OT: ITSM Total Cost of Implementation Discussion

2007-01-26 Thread Kaiser Norm E CIV USAF 96 CG/SCWOE
* Standard Naming conventions, good documentation, avoiding using reserved IDs, adding rather than modifying, exports and backups, using your own ID rather than the Demo account to modify objects so your name/last modify date shows. Certainly you want to apply the best practice

Re: Error 9350

2007-01-26 Thread Sokol, Brian
We are on ver 7.0.1. Is there a patch for it. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Thursday, January 25, 2007 3:53 PM To: arslist@ARSLIST.ORG Subject: Re: Error 9350 ** BMCs solution is

Re: Error 9350

2007-01-26 Thread Frank Caruso
Just installed Patch 20 (6.3) and it did not fix the problem go figure :) On 1/26/07, Sokol, Brian [EMAIL PROTECTED] wrote: ** We are on ver 7.0.1. Is there a patch for it. -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED]

Re: Reg: Hardware Compactibility

2007-01-26 Thread Bradford Bingel
Sorry Axton, I disagree regarding RAID 5. It may be suitable for general storage and backup, but RAID 5 is a performance-killer for databases. If reliability (fault tolerance) is important, use RAID 0 plus RAID 1 (aka, RAID 0+1 or RAID 10), which may actually outperform RAID 0. RAID 5

Re: Error 9350

2007-01-26 Thread Lucero, Michelle - IST contractor
The only patch for 7.0.1 so far is patch 1. It includes Mid-Tier, Clients, Email, Migrator and Server. The readme files for Mid-Tier or Server didn't mention 9350. However, it might be listed under something else. Michelle From: Action Request System

Consuming Web Service - How to pass user ID and Password?

2007-01-26 Thread John Baker
Hello, Indeed, the XML Gateway will do this for you, but the actual module is being spun off into a separate (pay for) product. Hence, you won't have to buy a gateway to get this functionality. However, anyone attempting a serious integration should think about whether they really want to use

Re: OT: ITSM Total Cost of Implementation Discussion

2007-01-26 Thread Ben Cantatore
Certainly you want to apply the best practice configuration control techniques of Remedy?my point is, with a tool as big as ITSM plus without knowing intimately what the vendor has changed, added, and/or deleted, the configuration control piece is much, much harder with a vendor-supplied

Re: Error 9350

2007-01-26 Thread Ben Cantatore
I've been following this thread because a user didn't logout and got the same exact problem. I'm on version 7.0.1 with all the latest patches, so while I haven't done enough testing, seems to be issue still. Once I get some time to examine this further, I'll post if I have anything useful to

Issues with Escalation

2007-01-26 Thread Cupp, Michael E Jr. CTR USAF AFRL/SNOD
I have an escalation I have created on a vendor form, which queries my LDAP. On the basic tab, my run if is ( 'sourceObjectGUID' != $NULL$ ) AND ( 'sn' LIKE CU% ) I want only records with a GUID populated and last name starts with CU On the If action, I have 1 action, it is a push

Re: OT: ITSM Total Cost of Implementation Discussion

2007-01-26 Thread Carey Matthew Black
Norm, I see this problem from a few perspectives. And I think it helps to look at specific scenarios too. So let's look at a few simple observations. 1) If the business is working just fine then why change anything? I would include in that conversation a discussion of why upgrade anything?

Re: OT: ITSM Total Cost of Implementation Discussion (U)

2007-01-26 Thread Hennigan, Sandra H CTR OSD-CIO
UNCLASSIFIED This is a great article to store away for future reference - thank you. Sandra Hennigan OSD Remedy Administrator Office # 703-602-2525 x251 CACI - Ever Vigilant(tm) Apparently, there is nothing that cannot happen today. Mark Twain -Original Message- From: Action Request

Re: OT: ITSM Total Cost of Implementation Discussion

2007-01-26 Thread Rick Cook
I remember Doug saying that Remedy would release tools to us that did exactly that, but I haven't heard if they actually were released. Rick On 1/26/07, Ben Cantatore [EMAIL PROTECTED] wrote: ** Certainly you want to apply the best practice configuration control techniques of Remedy…my point

Re: OT: ITSM Total Cost of Implementation Discussion

2007-01-26 Thread Kaiser Norm E CIV USAF 96 CG/SCWOE
A few points: Why upgrade to version 7 if version 5 (or any version you're currently running) is OK? Because of support. While I'm sure that if you bring Remedy (or any vendor) bags and bags of money for Professional Support sure, you'll get support for their deprecated version. However, if

Re: Issues with Escalation

2007-01-26 Thread Peter Romain
Looks like it's the use of request id's in the push field qualification. This won't match records in the two forms. Why not push the GUID (assuming it's unique) into the lookup table along with the vendor form data. Then, using $GUID$ = 'GUID' you won't duplicate records on the second and

Re: Exported Forms loosing Application

2007-01-26 Thread L. J. Head
It was suggested to me in an offline post that it may be a bug in the base 6.3 code we are runningthank you for the suggestion...I will definitely take a look at that method to see if it bypasses this 'feature' _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL

Re: Issues with Escalation

2007-01-26 Thread Cupp, Michael E Jr. CTR USAF AFRL/SNOD
That fixed it! Thanks for the suggestion. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Peter Romain Sent: Friday, January 26, 2007 3:11 PM To: arslist@ARSLIST.ORG Subject: Re: Issues with Escalation ** Looks

REPLACE function not replacing...

2007-01-26 Thread John Hanson
Hello all, We've upgraded to: ARS 6.3 patch 18 Solaris 9 Oracle 10 We've got a problem with some workflow that uses the REPLACE function; it is supposed to replace line breaks with a space. It works some of the time, but not other times. The workflow looks like this: Set Fields 'NewField' =

Re: REPLACE function not replacing...

2007-01-26 Thread Heider, Stephen
Certain versions of ARS insert a space just before the new-line character. Try using LTRIM in your REPLACE command. REPLACE($FieldwLineBreak$, LTRIM( |), ) Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf

Re: OT: ITSM Total Cost of Implementation Discussion

2007-01-26 Thread Carey Matthew Black
Norm, There is no application that can solve the problem of ignorant management. Part of my comment about buying Professional Services (and it not being covered by your support contract) is that you have to understand what that support contract is actually buying you. IMHO (and this may only

Re: REPLACE function not replacing...

2007-01-26 Thread Grooms, Frederick W
The problem could be that the line break is sometimes stored as a line break + space Try the following 'NewField' = REPLACE($FieldwLineBreak$, LTRIM(RTRIM( )), ) That should remove any space on either side and just replace the line break Fred From:

Re: ARS 7, Windows 2003 (64bit), Oracle 10g

2007-01-26 Thread Russell Wurth
Patrick, Thanks for the response. I had success in the past doing exactly what you did on a Solaris and Linux server. Windows is turning out to be quite a different beast. Anyone out there with any Windows/Oracle experience? Do I set ORACLE_HOME, ORACLE_SID environment variables? Other

Re: OLE Automation with Word - AR 5.1.2 or AR 7

2007-01-26 Thread William Broderick
Kimberly, If I remember correctly there is a method called AppClose( ). Hope this helps, Bill ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are

Re: REPLACE function not replacing...

2007-01-26 Thread John Hanson
That appears to be helping. I'm still seeing one particular request with one particular field that this is not working for; I manually took out all line breaks on that one. The rest of them are working though. Thanks!! John -Original Message- From: Action Request

Re: Issues since patch #19 or #20 - Uh-Oh

2007-01-26 Thread Axton
I'm wondering if 7.0.01 patch 001 is ready or not. This is rather humerous. In the email and server patch files, the same files have different sizes and modify dates: SIZE FILEMODIFY TIME 4931640 ./server/solaris/api/lib/libarjni70.so 1/22/07 10:46

Re: Issues since patch #19 or #20 - Uh-Oh

2007-01-26 Thread L. J. Head
aw come on Axton...what's a few bytes between friends...:) _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Friday, January 26, 2007 2:54 PM To: arslist@ARSLIST.ORG Subject: Re: Issues since patch #19 or #20 - Uh-Oh ** I'm

Re: What port range does portmapper use?

2007-01-26 Thread Wheeler, Dylan
I'm not sure where the problem is? Lets say the API HAS to use port 1834, se the load balancer to send port 1834 to your ARServer, set your ARServer to not use portmapper and to listen on port 1834 and you should be good to go. -Original Message- From: Action Request