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 or

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] Beh

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 a

ARSWiki Updates - Kinetic Data Klink

2007-04-04 Thread Axton
The Kinetic Data Klink sources are mirrored on the ARSWiki Trac/svn application for easy browsing and search engine indexing. For the java junkies out there, there are lots of good examples and ideas in this software. Project Information: - Version: 1.0.1 - License: BSD - Kinetic Data Klink Home

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 every

.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 addit

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: ar

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 Cate

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

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 pro

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

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: 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 Bal

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 unique

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 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: 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 byp

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, Journal_Entry

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 key

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 >Da

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 JOURNAL_ENTRY_DATE

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: 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 <[E

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: Action

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 - JOURNAL_ENTRY_DAT

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: 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: 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 Of

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: When do "Arsystem Email Messages" get created?

2007-04-04 Thread Durrant, Michael M. - ITSD
If I recall correctly, I disabled my outgoing email account in the Mailbox configuration form. This would generate the messages in the Email Messages form but it wouldn't send them out. Michael Durrant [EMAIL PROTECTED] Share what you know. Learn what you don't. -Original Message-

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 i

Re: When do "Arsystem Email Messages" get created?

2007-04-04 Thread Ben Cantatore
Install the email engine. When you configure the email outbox (AR System Email Configuration form) there is a status field. You can set it to enable or disabled. Emails do not get sent but will queue up in the AR System Email messages form. Excellent way to see notifications that should be

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 ARS

View Forms and Oracle Data Types

2007-04-04 Thread Kemes, Lisa
I created a SQL View: SELECT Vendor as V, sum(RECORD_AMOUNT) as SUM, Journal_Entry_Date FROM TIP_MONTHLY_BILLING_DATA Group by Vendor, JOURNAL_ENTRY_DATE; I created a View form and the Journal_Entry_Date is coming out like: 106092 or 115164. When I look at the data types from my SQL Vie

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 ARSlist

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

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: 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: arslist@ARSLIST.O

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 addr

Updating a server via coping files directly

2007-04-04 Thread Halstead, Robert
I'm trying to upgrade a secondary server to patch 20. We're running ARSystem with Oracle under Solaris. We are creating a server group so I can't use the installer to install the patch as it will touch the production database. So I'm copying files directly. While following the directions to do

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 that

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: Copy-To-New Run Process function

2007-04-04 Thread Bob Rowe
Why is it that almost every time I have a problem I take to the list, I figure it out AFTER I hit the send button? Thanks to Frank and Frederick. The list is great. On 4/3/07, Frank Caruso <[EMAIL PROTECTED]> wrote: ** I think it is saying torun all active links that would run on Copy To New?

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 off

Re: ARS Report Creator's time problem on queries

2007-04-04 Thread Davis, David CTR NAVSURFWARCENDIV Crane, Code 0552
Hello Mark, Our ticket number is ISS03085228. If you would like I could sent you the detail off-list. Thanks, Dave Davis David J. Davis SAIC Senior Software Systems Engineer Crane Division, Naval Surface Warfare Center (NSWC Crane) Harnessing the Power of Technology for the Warfighter Code 0552

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.

Re: ARS Report Creator's time problem on queries

2007-04-04 Thread Easter, David
TZ is an OS environment variable that can be set at the operating system level (e.g. SET TZ=PST8PDST), on the WUT through the locale tab in "Options", or through a preference server. TZ stands for "Time Zone". If it is set on your server, it most likely would have been done consciously prior to s

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 noti

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 somethin

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

Re: Regarding the Replace function

2007-04-04 Thread Dave Saville
Hm, there has got to be an easier method of bolting fields together :-) You have not blown the field length of the field that is the destination of that lot have you? -- Regards Dave Saville ___ UNSUBSCRIBE or access

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 G

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 cre

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 i

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: 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

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

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( REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPL

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

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

2007-04-04 Thread Siti Hawa Bee SHAIK FARID
Hi David, I'm actually referring to the message shown on the bottom left of the application status bar. It will show as Submit Successful. ID=HDX -> this is the message that was shown briefly as just gone and cleared the form for new case entry. In my Previous AR version, after i

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: arslist@A

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: 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 Wi

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

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 thi

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),

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.

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:///servlet/ViewFormServlet?form=form>&server=&view=&eid=$Request ID$ Instead of going to that view and opening the specified id, I would like to first check which user is this trying to open that ticket. S