Recent content by ishelpdesk

SET SCHEMA MTRC! DROP TRIGGER T_RESTPBYUNIT_IA1! CREATE TRIGGER T_RESTPBYUNIT_IA1 AFTER INSERT ON RESERVETYPEBYUNIT REFERENCING NEW AS new FOR EACH ROW MODE DB2SQL BEGIN ATOMIC DECLARE ld_adjusteddate DATE; SET ld_adjusteddate = (new.startdate -1); UPDATE RESERVETYPEBYUNIT...

I would like to subtract on day in a trigger. How do I do this? I have tried using -1 but it does not like this. Regards Grant

Help!!! I have just installed oracle 8.1.7 and I can't login to the OMS. I have checked that the service is running and have tried logging in using the sysman/oem_temp but I still get the same error. I can get into the database using the stand alone but not into the Management Server. Any...

What we have had to do is create a new field that is populated by the C/T/I and the remedy ticket numer. That field will give a different prefix depending on the C/T/I. We then hid the Original ticket number.

Hi, We are having trouble with RemMail IN. The emails are getting in to the inbox but not through to remedy. We ahave stopped and started the services, checked the passwords have not been changed and even rebooted the box. ( Nt SQL 4.5.1 )

We are running AR 4.5.1, Helpdesk 4.0 and using an SQL data base. I have been doing research on this and it does not look like it can be done. Remedy have said that it is not possible.

Thanks, but we have found the problem. The data base was busy converting the form across, hence the T25a.

We want to have our Helpdesk cases split into 2 types, Service Requests and Incidents. We want Service Requests to have a Request ID starting LONSRV and Incidents starting LONINC. How can I, with workflow, affect the Request ID value. It needs to be kept in mind that this is for...

I am getting ARERR552 Failure during SQL operation to db. Could not use T87 because of previous binding errors (SQL server 4413). This occurs when trying to populate fields such as assigned to on a new ticket. Any ideas?