Re: How to display DATE field in date format (from DB)

2010-04-06 Thread Brosow, Torsten
alter session set NLS_DATE_FORMAT='DD.MM. HH24:MI:SS'; select TO_DATE('1970-01-01 00:00:00', '-MM-DD hh24:mi:ss') + numtodsinterval(c6, 'SECOND') from t954 where rownum 2; Kind Regards Torsten Brosow Senior Solution Consultant Column Technologies Australia Pty Ltd

Re: why does archive form have create_date of today?

2010-03-04 Thread Brosow, Torsten
The archive form contains two additional fields (original Request-ID and original create date). There you can find the info you looking for. Kind Regards Torsten Brosow Senior Solution Consultant Column Technologies Australia Pty Ltd Level 32, 101 Miller Street North Sydney NSW 2060

Re: Archiving for incidents in Remedy

2010-03-04 Thread Brosow, Torsten
Hi Amunullah, ITSM requires a much more smarter solution as BMC offers for OOTB archiving. I set up a database driven solution to archive ITSM 7.x and 7.5 considering the data and permission model. If you need more information pls let me know. Kind Regards Torsten Brosow Senior

ARSLIST as RSS-Feed

2006-08-25 Thread Brosow Torsten
Hi Daniel, Do we have the chance to get the list as a RSS-Feed in the next future? Would anybody prefer this as well? Thanks Torsten best regards Torsten Brosow ___

ARDBC Plugin questions

2006-08-16 Thread Brosow Torsten
** Hi list, Has anybody experiences with plugin development. Here my question: - It is possible to log information into the arplugin.log file from functions like ARDBCGetListEntryWithFields, ARDBCGetEntry, etc. - How does it work? - Has the parameter version in the function

AW: Integration Remedy and Webmethods

2006-08-16 Thread Brosow Torsten
Hi Pascale, we did it with our product ARSXML-Link. If you are interested you can contact me off list. best regards Torsten Brosow Senior Consultant COC N-Tuition Business Solutions AG -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:[EMAIL

IP Address from ARS-Client

2006-08-04 Thread Brosow Torsten
Title: ORA-03127: no new operations allowed until the active operation ends ARERR - 552 Hi all, anybody has an idea to retrieve the IP address from the ARS-Client which is connected to the ARS-Server. It should be working in the Mid-Tier as well. Any hints? Thanks Torsten

AW: IP Address from ARS-Client

2006-08-04 Thread Brosow Torsten
Tristan -Original Message-Date: Fri, 4 Aug 2006 13:52:51 +0200Subject: IP Address from ARS-ClientFrom: Brosow Torsten [EMAIL PROTECTED]To: arslist@ARSLIST.ORG Hi all, anybody has an idea to retrieve the IP address from the ARS-Client which is connected to the ARS-Server. It should