Capturing diffrence of two date time fields in Remedy..?

Hi, My requirement is to capture in a FIELD the time elapsed since an entry was created in a form. eg. i have a ticket which arrives at 12:30 pm, this value is getting saved in 'Arrival Time' field which is a date time field. Now, if i open the ticket at 12:45 pm, then this FIELD should show valu

Re: BMC Support RFE Document

CMDB (Carey Matthew de Black), Kinetic would be more than willing to host a nice RFE submittal process. I saw the URLs for the circa v4 system - but I had trouble logging into Dev Network -- I am looking into that. However - Kinetic Request could certainly be put together to handle collection --

Re: Arserver.exe high CPU usage

I finally was able to reproduce this issue. Gavin, thanks very much for your post as this gave me some important clues as to the issue. I believe it is related to the same bug you experienced with version 6.3 patch 19 because the symptoms are almost identical. My issue was caused by the CCM Cale

Re: Arimport to for importing data in Remedy 6.3

As far as I'm aware, if you'd like to use the Import tool (or arimportcmd for that matter) and would want to import character fields with line breaks inside, that's just not possible with CSV files. You can do it with ARX files; here some escape sequences are available. However the ARX file format

Re: Mail Parsing Issue ars 6.3

You have probably selected the wrong source field from the AR System Email Message form; this is actually what you would see if you push an attachment field to a character field. Use the Plain Text Body field or the Rich Text Body field (do not know exact naming, please check in the Admin tool) fo

Re: How to add the attachment included in an email message when creating a new Incident (U)

UNCLASSIFIED We are using ARS 6.3 patch 21 Windows Server 2003 SQL 2000 Help Desk 5.5 Using a Filter, Push Fields Action, I mapped File 1 (attachment field) to receive $Email$. The encapsulated email is attached; it includes the sender's digital signature and attachments as sent. The attachment

Re: BMC Support RFE Document

Resitance is futile! You will be assimilated! On Tue, 22 Apr 2008, Carey Matthew Black wrote: Shawn, I actually remember discussion of a "NEW RFE process" that would provide better feedback to the submitter being discussed at a RUG er.. BUW. ( But most of my RFE's are filed under single phr

Re: BMC Support RFE Document

Shawn, I actually remember discussion of a "NEW RFE process" that would provide better feedback to the submitter being discussed at a RUG er.. BUW. ( But most of my RFE's are filed under single phrase statements like "As Designed" or "Rejected" with no confirmation email or discussion with me so t

Re: Remedy User Client - Win98 Compatible

** Thanks for the info David.   Rick   Rick Parry Application Engineer [EMAIL PROTECTED] 801-861-1747 >>> "Easter, David" <[EMAIL PROTECTED]> 4/22/2008 11:14 AM >>> AR System 5.1.2 was last version where the user client supported on Windows 98.   Thanks,   -David J. Easter Sr. Product Manage

Re: BMC Support RFE Document

Although rumors of said document persist, we have not yet been told to use it (our last submission was 4/15). But if it's unavoidable, why not at least provide an automated form to collect the information? And perhaps a 'voting' mechanism so that others could champion their favorites? Persona

Re: BMC Support RFE Document

> a *FOUR PAGE* document Just to clarify, the actual area to be filled out is only 1 1/3 pages. The last 2 pages are examples, and 2/3 of the second page is for support use only. In addition, the bulk of the document is checkboxes, which are very fast to fill out. Attached is a text version

Re: BMC Support RFE Document

I have filled out one of these, and I didn't see it as being as large a task as you see. It took me about 10 minutes, which was worth my time for the return of knowing that my request didn't get misinterpreted by someone along the chain. YMMV. Rick On Tue, Apr 22, 2008 at 11:51 AM, Pierson, Sha

BMC Support RFE Document

I don't really want to start a flame war about BMC Support, but I have a question about RFEs. I recently submitted an Issue to BMC to request an enhancement to Change Management. It's a pretty straight forward request (I asked for the Work Info to be able to be updated on Closed Change Requests)

Re: Windows Server issue?

The only issue I have seen where no pages are being displayed, not even the config page, was due to the jakarta (sp?) web plugin. I uninstalled Mid-Tier, TomCat and the Jakarts ASPI plugin from Add/ Remove programs. I then went into the IIS control panel and manually removed the entry for the Jak

Mail Parsing Issue ars 6.3

I have a filter that takes a piece of mail that is sent to the Remedy mailbox and if it matches certain qualifications, sends the information to my "transport" form. From this form, I will eventually push the data to a ticket for updating etc. My problem is that the text of the email is pushed to

Re: Data Migration

C'mon guys. It uses the API. Simple as that. Else, how would a Merge filter fire? Note that the API allows you to turn off Merge filters on any run but the Import tool does not offer this option. - Meta-Update does, Confirm with a simple test running API and SQL logging (to the same file!) on

Re: Data Migration

LJ and Misi, You both make valid points. Like I said I could not find anything in the documentation that would confirm or deny my understanding. Now that I have sound examples I can move on. Thanks again form the help. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cel

Re: Custom css

I simply want to show column dividers (borders) on a Remedy table field, between the columns. Thanks, James On Apr 22, 1:09 am, Bradford Bingel <[EMAIL PROTECTED]> wrote: > You can change (or add) CSS elements to alter how your pages appear. > > What, exactly, do you want to change?  (Perhaps we

Re: Remedy User Client - Win98 Compatible

AR System 5.1.2 was last version where the user client supported on Windows 98. Thanks, -David J. Easter Sr. Product Manager, Solution Strategy and Development BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect t

Re: Server Group Floating Write License Issue

Let me clear up the question definitively: AR System 7.1.00 is the first release where licenses are stored in the database. -David J. Easter Sr. Product Manager, Solution Strategy and Development BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in th

Re: Server Group Floating Write License Issue

David Please see my comments in red. Dan Dan Wangler, Team Lead, STARS Group Phone: 214-567-8304; email: [EMAIL PROTECTED] Client/Server Services, IT Operations Texas Instruments, Inc. 6500 Chase Oaks Blvd., MS 8401 Plano, Texas, 75023 -Original Message- From: Ac

Re: Data Migration

You could setup a simple form with an attachment on it, create a record and add the attachment, then migrate that record to the other server and see if it made it over there with the status historyI seriously doubt it won't, I mean...the migration tool sucks in several aspects, but it usually '

JOB: Senior Remedy Developer (great opportunity to gain experience with ITSM 7)

Northrop Grumman Mission Systems has a position open for a Remedy Software Developer in San Diego, CA. It is a really great opportunity for someone who does not have experience with ITSM 7, to gain that experience. The right candidate should be comfortable with and have a good understanding o

Re: Data Migration

Hi Roger, I am 99.9 percent sure that everything is moved with Migrator. Why not test it? Just copy a record with an attachment, then check to see that both attachment and Status-History (Ctrl-H) is there. Best Regards - Misi, RRR AB, http://rrr.se > Misi, > > Thanks for getting back to

Re: Data Migration

Misi, Thanks for getting back to me. While I am sure you are correct I am wondering if anyone can confirm that indeed all data from the T, H, and B tables is moved when using Migrator. This is a very important question for me right now and I must be as sure as I can of the answer. Thanks, Roger

Re: Server Group Floating Write License Issue

Nice to know I have that straight. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Be

Re: Server Group Floating Write License Issue

You could be right Roger - I am on a 7.1 server David Sanders Remedy Solution Architect Enterprise Service Suite @ Work == ARS List Award Winner 2005 Best 3rd party Remedy Application See the ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PRO

Remedy User Client - Win98 Compatible

** Hello Everyone,   What is the last version of the Remedy User client that will install on the Win98 OS?   Take care,   Rick Parry     Rick Parry Application Engineer [EMAIL PROTECTED] 801-861-1747 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___

Re: Server Group Floating Write License Issue

David, I believe it is in v7.1 where the Server licenses are stored in the database. User license no longer have license keys. Of course I could be all wrong. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM R

Re: Server Group Floating Write License Issue

I could be wrong here, but it was my understanding that in ARS v7 the licenses are stored in the database, not in the file system.  Although armonitor.conf still contains a pointer to the old location of the license files, these no longer exist. So, you will probably not have a multilicense file t

SHR Audit form, safe to truncate?

Hi Listers, My SHR:Audit form has become my largest table in the database. It has data from several years ago, basically from Help Desk 6.0 I was thinking in truncate the table to gain back some space in my database. Anyone has done this before without any issues? Or it would be preferable to de

Re: New Mailbox issue

See http://rkm.bmc.com/rkm/viewdoc.jsp?doc=KM-00012163 There's a filter (AR System Email Mailbox Configuration Check Duplicates) that disables SMTP mailboxes if they use the same mail server. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL

Re: Server Group Floating Write License Issue

There have been a number of defects with floating licenses and server groups in earlier releases of 7.0.1. The first thing you should do is get your servers all up to patch 6, I believe this resolves all the ones we are aware of. As also pointed out you should delete the /etc/arsystem/.multilicen

Re: Server Group Floating Write License Issue

Hi Dan Have you tried deleting the multi lic file and then restarting the service. We had a similar issue here and that resolved it.Kind Regards Alan D West Date: Tue, 22 Apr 2008 09:35:31 -0500From: [EMAIL PROTECTED]: Server Group Floating Write License IssueTo: [EMAIL PROTECTED] Dear

New Mailbox issue

Hi All, I have added a new UNIX user and mailbox and then added new incoming and outgoing mailboxes in the AR System Email Configuration form. So now I have Old_box_In Old_box_Out (default) New_Box_In New_Box_Out Send and receive emails are working fine. In and out boxes are associated with eac

Re: Permissions On A Join Form

That makes sense, since I no longer see those forms in the Asset Inventory Application form list. Any ideas on how I can make them part of Asset Inventory? Sorry am still pretty new to v 7. Thanks, Lou -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAI

Re: Using sysdate on Oracle 10g

Remember Remedy stores Create_Date and Date_Modified as the number of seconds since Jan 1, 1970 so you have to convert the Oracle SYSDATE data. Here are the Oracle functions I use to convert to and from "Epoch" (number of seconds since Jan 1, 1970). Just change the 'America/Chicago' to the tim

Server Group Floating Write License Issue

Dear List We are trying to set up a Server Group. Below is our environment. We are running ARS 7.0.1 patch 3 on Sun Unix serverss with Solaris 9 with and Oracle 10. DB #1 and DB #2 are remote databases. In our development environment, the primary server is Server #1. In our production

Re: Deployable Applications in ARS 7.1.0 patch 002

Hi, RESOLVED!!! I now managed to: 1. Open Form 2. Add Field 3. Save (message: unable to save) 4. Save (it seemed to save OK) 5. Close Window 6. Open Form (the field was missing) 7. Close Form 8. Open Form (the field appears) I did this with Development-Cache-Mode turned Off. The other experience

Re: Wrong UID being used by mid-tier 7.1

Standard AREA/LDAP using Active Directory. William Rentfrow Principal Consultant, StrataCom [EMAIL PROTECTED] O 952-432-0227 C 701-306-6157 From: Action Request System discussion list(ARSList) on behalf of Axton Sent: Mon 4/21/2008 4:32 PM To: arslist@ARSLIST.OR

ARS 7.0.01 ITSM 7 - Performance - SLM SVTs

Hi Listeners We seem to be having a problem with performance and are trying to isolate the problem. One of the areas is the number of Service Targets we have. We have about 1400 Service Targets and are slowly increasing and we are fearing that this number of Service Targets may be hampering the

Re: Slightly OT--US Govt Security Clearances (was: Job: Two Openings ....)

The length of time it takes to complete a Secret clearance request varies with the phase of the moon, the number of ants in your yard, and the location of your security office. It has been my experience that if your skills are sufficiently strong and you interview well, an employer will bring

Re: ITSM(7) marketing strategies

Actually I happen to be in the middle of preparing a power point presentation to upper management. The power point will go hand in hand with a demo. I plan on explaining OOTB workflow, roles, and new terms. As I introduce the new concepts, I'll point out the benefits. I think the biggest key is

Re: Data Migration

Hi, Everything should be migrated. The data is copied using the API, so the actual T/B/H tables are not accessed directly by Migrator. Or so I would think... You can also use our RRR|Chive to move the data. In this case, I definitely know that all the data for each form is copied. You can move

ITSM(7) marketing strategies

Hi all, do you have marketing strategies implemented during the implementation of your ITSM projects? If yes, what different ways did you use to communicate the changes of the IT environment to your IT- and end users? Thanks for any reply. Mario __

Re: Deployable Applications in ARS 7.1.0 patch 002

Hi, Not "Form03", but the form I did "Save As" on appears. And the permissions are kept intact, just as Scott has been experiencing. It seems strange that this has passed QA... Anyone with good experience from working with Deployable Applications in ARS 7.1.0 patch 002? Best Regards -

Data Migration

While I think I know the answer to this I would like to be sure. When migrating data using Migrator is on the data from the T-tables migrated. I cannot find anything in the documentation that states whether data from B or H tables is or even can be migrated. I am thinking not. Thanks in advance for

Re: Deployable Applications in ARS 7.1.0 patch 002

Misi, I have experienced some of the same problems you have had. The one that really surprised me was copying a form WITHIN the application and the Admin Tool reporting the permissions had been removed. However, when I went back into the form, all roles and permissions remained. I have not, however

Using sysdate on Oracle 10g

Hi people... I'm not an expert in SQL statements, and I'd like to get some suggestions about a search that I wanted to do on a table... I would like to get all records that are less than current date (ex: 22/04/2008) and more than the first day of the current month (ex: 01/04/2008)... How c

Re: Deployable Applications in ARS 7.1.0 patch 002

When you open the application and look at the properties does the form appear in the forms list? Don> Date: Tue, 22 Apr 2008 15:12:59 +0200> From: [EMAIL PROTECTED]> Subject: Deployable Applications in ARS 7.1.0 patch 002> To: arslist@ARSLIST.ORG> > Hi!> > I am creating a deployable applicati

Re: Can you export to a csv file from Mid Tier?

It is a tiny report. There is nothing wrong with it. I can print it or preview it. I can also export it using the user tool. Just will not work on MidTier. Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Steve Br

Re: Can you export to a csv file from Mid Tier?

Hi Lisa, My settings are all the same except I have the report format set to Column. I need this setting in order to open the export in Excel. This should not matter. I tested it with the user tool and it works OK. Brian From: Action Request System discussion

Re: Two Instances on the Same Oracle Server

This will work fine. Axton On Tue, Apr 22, 2008 at 9:08 AM, Scott Philben <[EMAIL PROTECTED]> wrote: > arslisters: > > We have two unix applications servers (Solaris, ARS 6.3, Oracle 9i) that we > would like to point at the same Oracle server using different > instances(?)/tablespaces(?)/datab

Deployable Applications in ARS 7.1.0 patch 002

Hi! I am creating a deployable application in version 7.1, and I am experiencing problems... 1. When I rightclick on Form in the Application Window and create a new form, I get a "Form does not exist on server : Form03 (ARERR 303)"

Re: Arimport to for importing data in Remedy 6.3

Hi Sanjana, You've already determined that the import cannot read data with embedded newlines. What actually happens is that the record with the data newline character is truncated at that character and processes (is imported) fine, not withstanding that the record itself is truncated at that new

Two Instances on the Same Oracle Server

arslisters: We have two unix applications servers (Solaris, ARS 6.3, Oracle 9i) that we would like to point at the same Oracle server using different instances(?)/tablespaces(?)/databases(?). I am not sure of the correct verbiage. We only have one Oracle server but we want to run two Remedy in

Re: Large Email Send Issue

Mark, There is a bug in the notify filter process that trims data to 255 characters for the To:, CC: and BCC: fields. To overcome the issue, I needed to perform a push fields directly to the Email messages form. We're using email templates so there are a few extra things that need to be pushed l

Large Email Send Issue

Hi All, I have inherited several interesting email issues, most of which are straight forward but this one is cooking my noodle. When the ticket is created, a RUN PROCESS executes a Perl script which queries the database for contact email addresses. The email addresses are placed in the ticket ($

Re: Arimport to for importing data in Remedy 6.3

Hi, Replace the NL with \n, and see if it works. That is how it is done with the ARX-format at least. Export a record from AR User to a CSV/ARX to see how the NL-characters are stored. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enou

Re: Advanced Search Bar

You can use workflow to make any fields you do not want used in a search read only. This would if desired be one way to prevent the use of particular fields in a search. Another would be a particular view for search operations that do not have the fields as part of the view. HTH -Original M

Arimport to for importing data in Remedy 6.3

Hello, Whenever I tried to import some data in "Description" or "Worklog" field having "Enter" (linefeed or a new line character) in it. For example: "To include the purge of ATTRIBUTE_HISTORY table 4.3Patch 4.3 already delivered to Agrate in WW09 2008 for Testings." I got the following error

Re: Tool to convert a def file?

Great tip Carey.. Thanks everyone for your help! - Mary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Monday, April 21, 2008 10:58 PM To: arslist@ARSLIST.ORG Subject: Re: Tool to convert a def fil