how to get into a variable the eid which is in an URL ...

2007-04-04 Thread Serouche Rahimpour
dear lister, when I use direct access through a URL I can do it with something like http://my remedy server/servlet/ViewFormServlet?form=my formserver=pepito serverview=the vieweid=$Request ID$ Instead of going to that view and opening the specified id, I would like to first check which user

how to get the file name of an attachment field

2007-04-04 Thread Vinson
Hi, I want to design a filter to notify my user when a file is upload to an attachment field. I've try to use $attachmentfieldname$ in the email to get the file name but it is included with path that I want to remove. How can I get the file name without the path of the attachment field? Thanks.

Java edplus examples updated

2007-04-04 Thread Hugo Visser
Hello, I've updated the examples for the ExpertDesk plus library and added an example for creating an entry. For those who missed the announcement, the ExpertDesk plus library is an add-on library to the AR System Java API that aims to simplify api development. It's open source (Apache License),

Case ID just submitted reflect to quickly at the bottom status ba r

2007-04-04 Thread Siti Hawa Bee SHAIK FARID
Dear Listers, I had just upgraded my Remedy version from AR 6.0 to AR 6.3. So now I am using AR 6.3 with Help desk 6.0. After submitting a case, I can't even get a glimpse of the case number/case ID+. It was reflected briefly and went off at the bottom left hand of the status bar. What cause

Re: how to get the file name of an attachment field

2007-04-04 Thread Michiel Beijen
Create a set fields action to a character field Use workflow which searches for the first \ character and use the right part of the string. Then re-start this workflow, either by using a filter guide or a goto action, until there is not a \ character left in the string. This is not as easy as you

Re: Case ID just submitted reflect to quickly at the bottom status ba r

2007-04-04 Thread David Sanders
Hi Sita In the User tool, Tools. Options menu. Change to the Confirmations tab and check the Confirm After creating New Request checkbox. Is this what you want? HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award

Re: Execute active link or filter of specific time of the day

2007-04-04 Thread Siti Hawa Bee SHAIK FARID
Hi Rocky, It's better to create a filter for this. Execute on Submit or Modify Run If 'Create Date'=($DATE$+(60*60*18)) AND 'Create Date'=($DATE$+(60*60*30))) Set Field ** set whatever field you want. Good Luck -Original Message- From: Action Request System discussion list(ARSList)

Re: Execute active link or filter of specific time of the day

2007-04-04 Thread Siti Hawa Bee SHAIK FARID
Hmm YES, escalation would be more appropriate. You can try the RUN IF qualification that I gave in my earlier mail. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike White Sent: Wednesday, April 04, 2007 03:36 To:

attachment problem within incidents

2007-04-04 Thread roseta
Hello, I have a problem with some incidents that have attachment. The problem is that if we log an incident with an attachement. after a while if some one referes to that incident .he/she does not see any attachment with incident. Just the variable above attachment list named outbound is equel

Regarding the Replace function

2007-04-04 Thread Saravanan Palaniappan
Dear Lister, I am trying to use a Replace function in remedy in which I am getting some problem. Please help me in resolving it. REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

Re: Regarding the Replace function

2007-04-04 Thread Frank Caruso
You are problem reaching some memory limitation. For pure readability\comprehension reasons I would break this down into separate statements. On 4/4/07, Saravanan Palaniappan [EMAIL PROTECTED] wrote: ** Dear Lister, I am trying to use a Replace function in remedy in

Re: how to get the file name of an attachment field

2007-04-04 Thread Vinson
Michiel, I create 3 filters as you suggested and use goto action. Now it works like a charm... Thanks for great help. On Apr 4, 4:26 pm, Michiel Beijen [EMAIL PROTECTED] wrote: Create a set fields action to a characterfield Use workflow which searches for the first \ character and use the

ITSM 7.x: Install and Config

2007-04-04 Thread Gwenn Cross
Is anyone interested in trying to get BMC to offer the IT Service Management 7.x: Installing and Configuring class (course code: RSMG-SMIC-0700) here in ATL? They only need 4 people to put it on the schedule...me being the first...only need 3 moreanyone interested?

Re: ARERR [102] on display of AST:ComputerSystem record

2007-04-04 Thread Dwayne Martin
Thanks, David, I am using the 7.01 patch 1 user tool. Now something I maybe should have said in the initial email. I used the Migrator tool to move the form and data. We bought the tool in part to help us move our system (including Asset Management) to our new platform. But now that we have

Re: Execute active link or filter of specific time of the day

2007-04-04 Thread Kaiser Norm E CIV USAF 96 CG/SCWOE
Use an escalation. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rocky - Sent: Tuesday, April 03, 2007 1:05 PM To: arslist@ARSLIST.ORG Subject: Execute active link or filter of specific time of the day Can anyone help me

Re: how to get the file name of an attachment field

2007-04-04 Thread Heider, Stephen
Vinso, On a related note, you can also rename the attachment name at the database level. Below is a stored procedure in SQL Server format that is called from workflow. I find it useful to rename the filename in two circumstances: when the filename is originally generated from workflow using a

Strange behavior on Table Refresh - 7.0.1 patch 1

2007-04-04 Thread Sean Garrison
Has anyone noticed this ... I have a form b that contains a table field table 1 that references form a. I have an active link on form b that does a push fields to form a on Return/Double Click and then does a table refresh on table 1. What I noticed happening is that the table is being

Remedy Knowledge Management 7.1.1 over HTTPS

2007-04-04 Thread Watson, Benjamin A.
Greetings List, Previously, I had MidTier 7 and RKM working under HTTPS (port 443) under IIS6 on Windows Server 2003 using ServletExec as my jsp engine. Well, we ran into some odd RKM behaviour and, have since rebuilt the server. When running the MidTier installer this time (7.1.01), we

Re: ARS Report Creator's time problem on queries

2007-04-04 Thread Whilden, Mark D.
David, I checked and our TIMEZONE file on our Solarius server (our sys admin knew just what you were talking about) is set to: TZ=EST5EDT CMASK=022 Unless these are translated to the long timezone name and then truncated, I don't think this bug applies to us. Let me know if I am missing

When do Arsystem Email Messages get created?

2007-04-04 Thread Dwayne Martin
Hi Everyone, We have a test server (ARS 7.01 patch 1, Red-Hat Linux). We want to know when this system WOULD send out email if it were a live system, but we don't want it to actually do it. So we haven't installed the Email Engine because we don't want it sending out test messages to customers.

Load Balancing Issues

2007-04-04 Thread Frank Caruso
I am posting this for another client so I do not have complete details but am hoping somebody may have thoughts on the issue ... Env: ARS 7 ITSM V7, Windows 2003 Servers (3 of them in Server Group) Issue: Log in through the User tool and hit the load balancer. Load balancer quick passes them

Re: When do Arsystem Email Messages get created?

2007-04-04 Thread Roger Justice
Do not set up the Outgoing mailbox and no email will be sent. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 4 Apr 2007 11:28 AM Subject: When do Arsystem Email Messages get created? Hi Everyone, We have a test server (ARS 7.01 patch 1, Red-Hat Linux).

Re: When do Arsystem Email Messages get created?

2007-04-04 Thread Ron Legters
This may not be the most elegant way, but I just had my email admins create a dummy account, then changed the e-mail address of every 'person' on my test system to be that dummy account. I added the dummy account to my Outlook profile, so I can easily monitor the messages. The only downside is

Re: When do Arsystem Email Messages get created?

2007-04-04 Thread David Yearsley
We had the post office create a test/dummy account to send the emails to and then I put a filter, that runs on Submit, on the AR Email Message form that moves the address in the To field to the From field (So we know who was supposed to get the message) and the set the test/dummy email address

Re: Load Balancing Issues

2007-04-04 Thread Rick Cook
Frank, the first thing I would check is the network routing and the authentication settings on the load balancer. Rick _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Wednesday, April 04, 2007 9:04 AM To:

set runmacro to use a private server

2007-04-04 Thread Roger Walls
Hi, How do I set a runmacro command line to use a private arserver? Thanks in advance, Roger Walls ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are

Re: When do Arsystem Email Messages get created?

2007-04-04 Thread Clary, Bill
Dwayne; You can make a Filter on the Email form that on Submit Takes the info in the To field and adds it to the Body at the top and then sets the To field with a email address that you montor. This would allow all workflow to work as designed and you can see who it would go to but it would

Difference- User form and People form

2007-04-04 Thread John Kelley
Does anyone know why the members of users form has a different total # than the members in the people form? Unless its my workflow. Are they supposed to match? ARS 6.3 Thanks John ___ UNSUBSCRIBE or access

Re: Updating a server via coping files directly

2007-04-04 Thread Frank Caruso
A couple of thoughts: 1. Since the production database has already been upgraded to patch 20 then I would think re-running the installer on the other box would do nothing to the database. I believe it checks a table (control???) for the dbase patch version. 2. If the other box has version of

Re: When do Arsystem Email Messages get created?

2007-04-04 Thread Reiser, John J
Ron and Dwayne, That is a good way to do it. So is Roger's suggestion of not setting up the Outgoing mailbox. To find out for who the record was intended you can add the $Assigned to$ value to the subject line of the Notification action and use the dummy email address. This will help you verify

Re: Difference- User form and People form (U)

2007-04-04 Thread Hennigan, Sandra H CTR OSD-CIO
UNCLASSIFIED The People Form holds your customer names as well as your licensed users. The User Form holds you licensed users. Sandra Hennigan OSD Remedy Administrator Office # 703-602-0980 x174 CACI - Ever Vigilant(tm) Apparently, there is nothing that cannot happen today. Mark Twain

Re: View Forms and Oracle Data Types

2007-04-04 Thread Rick Cook
Lisa, what if you hid that field, and did a set fields from it to a Remedy D/T field that is local (not part of the DB table)? That way, ARS would do the string conversion. Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf

Re: Load Balancing Issues

2007-04-04 Thread Grooms, Frederick W
Also have them check the sticky timeout setting of the Load Balancer (the length of time the LB maintains a list of who goes to which server). It almost sounds like they are timing out in the LB and it is having to determine which server they go to again. Fred

Re: Updating a server via coping files directly

2007-04-04 Thread Grooms, Frederick W
Since this is a second server (I take it the 1st and the db is already on patch 20), run the installer and select SHARED for the server type. If you choose UPGRADE the installer will update the database, if you choose SHARED the installer will not change the database. Fred

Re: View Forms and Oracle Data Types

2007-04-04 Thread Heider, Stephen
Lisa, If the JOURNAL_ENTRY_DATE column is a Remedy datetime field, then... Add a new Datetime field to your Remedy View Form. Open the Field Properties dialog and select the Database tab. In the View Form section change the Name field to the name of the field in the SQL View -

Re: View Forms and Oracle Data Types

2007-04-04 Thread Grooms, Frederick W
Just create a Date field on the view form and tell it that the field is your JOURNAL_ENTRY_DATE field. i.e. Create a regular Date/Time field on the View form and on the Database tab type in the DB View's field name exactly (yes case does matter here). Fred -Original Message- From:

Re: Difference- User form and People form

2007-04-04 Thread Joe DeSouza
The people form is a form used by the application you have on your AR Server, and is generally a subset or a superset (depending on how you are using your AR Server) of the user form, and hence the numbers would not match in most cases... Joe - Original Message From: John Kelley

Re: Updating a server via coping files directly

2007-04-04 Thread Joe DeSouza
It was a problem with a missing .so file and yes the way to fix that was to run the installer to upgrade - else the patch would fail as there would be a failure to bring up the AR Server.. Cheers Joe - Original Message From: Frank Caruso [EMAIL PROTECTED] To: arslist@ARSLIST.ORG

Re: View Forms and Oracle Data Types

2007-04-04 Thread Kemes, Lisa
Thanks everyone!!! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Wednesday, April 04, 2007 2:08 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Oracle Data Types Lisa, If the

Re: When do Arsystem Email Messages get created?

2007-04-04 Thread Dwayne Martin
A big THANK YOU! to all who responded. It sounds like simply not creating the outgoing mailbox entry is the simplest solution. But I could also have a filter change the to to my email address and I would get all the test messages. Two great ideas. Thanks Dwayne Original message

View Forms and Key Fields

2007-04-04 Thread Kemes, Lisa
Another question about View Forms. Here is my SQL View: SELECT Vendor as VendorName, sum(RECORD_AMOUNT) as SUM, Journal_Entry_Date FROM TIP_MONTHLY_BILLING_DATA Group by Vendor, JOURNAL_ENTRY_DATE; When I go to create my View Form, only SUM and Journal_Entry_Date are in the dropdown list as

Re: View Forms and Key Fields

2007-04-04 Thread Grooms, Frederick W
It needs a unique field as a unique ID and Remedy's unique ID column can only be 15 bytes long. One solution is to just add the Oracle Rownum to the query and use that as the Remedy unique Key column. SELECT min(ROWNUM) as Entry_ID, Vendor as VendorName, sum(RECORD_AMOUNT) as SUM,

Re: Approval Process Question

2007-04-04 Thread Song, Su
Thank you Matt. That worked perfectly! There are several cases where the ManagerLoginID field is empty. Do you have any suggestions on how to create a rule that will route the request back to the first approver under this circumstance? Currently if the ManagerLoginID field is empty, it

Re: View Forms and Key Fields

2007-04-04 Thread Frank Caruso
Because that is the length of the request_id field on all Remedy forms and request_id is the primary key. On 4/4/07, Kemes, Lisa [EMAIL PROTECTED] wrote: Another question about View Forms. Here is my SQL View: SELECT Vendor as VendorName, sum(RECORD_AMOUNT) as SUM, Journal_Entry_Date FROM

Re: View Forms and Key Fields

2007-04-04 Thread Joe DeSouza
Lisa, It's prompting for a Request ID field that has to be a character field of length 6-15 characters.. hope this helps.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Wednesday, April 04, 2007 1:46

Re: View Forms and Key Fields

2007-04-04 Thread Kemes, Lisa
Thank you! Worked like a charm! :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, April 04, 2007 2:55 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Key Fields It needs a

Re: Load Balancing Issues

2007-04-04 Thread Joe DeSouza
Fred, You just might be right.. I had that issue on a recent engagement and reconfiguring the sticky timeout did work for us.. Joe - Original Message From: Grooms, Frederick W [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, April 4, 2007 2:01:15 PM Subject: Re: Load

LogAnalysis.zip @ www.mattreinfeldt.com

2007-04-04 Thread Opela, Gary L Contr OC-ALC/ITMA
Hey, does the LogAnalysis.mdb work with server-side SQL log files generated on remedy 6.3 no patch systems? I am trying to load a file and keep getting the error message of No Current Record. Whenever I hit the 'Load Log File' button. Thanks! Gary Opela

Re: DST Issue

2007-04-04 Thread LAU, DARREN (ATTASI)
Yup, same thing happened here when we had the DST change in the US. Some of our users manually set their Time Zone in the User Tool so I had them clear it out and that fixed it. Darren Lau From: Action Request System discussion list(ARSList) [mailto:[EMAIL

Operational Categories vs. Product Cat in 7.0

2007-04-04 Thread Koyb P. Liabt
Hi All - Within 7.0, my understanding is that the operational categories is a listing of the operational services that the help desk provides, such as adding user accounts, changing server passwords. And the operational catalog contains items that represent symptoms of incidents or

Consuming Web Services and using Attachment fields

2007-04-04 Thread Leihkauff, Kenneth
Hi, Has anyone attempted to use a filter (web service action) to consume a remote web service which mapped an attachment field? The basic workflow seems to work reliably including pushing the attachment data to the remote web service. An error (ARERR 8939) occurs however, whenever I try to push

Re: Operational Categories vs. Product Cat in 7.0

2007-04-04 Thread Roger Justice
The Product categorization are still what they were in that it is: Tier 1 Hardware Tier 2 Computer Tier 3 Laptop This should reduce your headaches. -Original Message- From: [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wed, 4 Apr 2007 5:03 PM Subject: Operational

Re: LogAnalysis.zip @ www.mattreinfeldt.com

2007-04-04 Thread Grooms, Frederick W
Yes, I usually copy the file from the server to my PC and then load it into the app. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Wednesday, April 04, 2007 3:36 PM To:

.net Utilities on ARSWiki.org

2007-04-04 Thread Axton
I wanted to announce a set of .net utilities hosted on ARSWiki. Many thanks to Stephen Heider for releasing these under an open source license and adding these to the ARSWiki site. http://arswiki.org/projects/dotnetutil If you want to learn .net, contribute to these .net utilities, or add

Re: Updating a server via coping files directly

2007-04-04 Thread Halstead, Robert
Sorry for the late reply, meetings all day today. I will try to run the installer as SHARED instead of upgrade. I was hesitant on just copying the whole directory as Remedy maybe does some type of file lock on certain files but wasn't sure. That is good to know that patch 20 didn't include

Re: Load Balancing Issues

2007-04-04 Thread Bradford Bingel
Because the log files confirm it takes 35-40 seconds for anything to hit the AR System, seems to indicate an issues with the load balancer. I agree with Fred that the sticky timeout setting is a prime suspect. You might also do a traceroute, just to make sure the routing path between your users

Re: Consuming Web Services and using Attachment fields

2007-04-04 Thread Joe D'Souza
Consuming Web Services and using Attachment fieldsI wonder if it has to do with some sort of a limitation on the IIS server.. Can you attach an attachment that size from the Mid-Tier? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]

Re: arslist Digest - 3 Apr 2007 to 4 Apr 2007 (#2007-145)

2007-04-04 Thread Sunshine.acosta
I will be on vacation Thursday, April 4, 2007 and returning Monday, April 9, 2007. For immediate assistance regarding the Newell Rubbermaid project, please contact Melanee Davis at [EMAIL PROTECTED] ___ UNSUBSCRIBE