Re: How to display DATE field in date format (from DB)
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 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kali Obsum Sent: Tuesday, 6 April 2010 11:59 To: arslist@ARSLIST.ORG Subject: [ARSLIST] How to display DATE field in date format (from DB) ** Hi, We have a field of type 'DATE'. It is stored as an integer in DB. Does anyone know how to display this in Date format? (e.g. are there functions that we can use?) Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: why does archive form have create_date of today?
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 Mobile: +61 (0) 450 605 836 | Email: tbro...@columnit.com mailto:tbro...@columnit.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Geoffrey Endresen Sent: Tuesday, 2 March 2010 17:37 To: arslist@ARSLIST.ORG Subject: [ARSLIST] why does archive form have create_date of today? ** Sorry for the stupid question. Why is the create_date reset when copying to the archive form? -- -Geoff Endresen Amazon.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Archiving for incidents in Remedy
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 Solution Consultant Column Technologies Australia Pty Ltd Level 32, 101 Miller Street North Sydney NSW 2060 Mobile: +61 (0) 450 605 836 | Email: tbro...@columnit.com mailto:tbro...@columnit.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of ITN (Amanullah Bashir Ahmed) Sent: Monday, 1 March 2010 16:47 To: arslist@ARSLIST.ORG Subject: [ARSLIST] Archiving for incidents in Remedy ** Hi Guys, Version 7.1.00 Patch 007 First I need any link for studying material on Archiving in BMC Remedy. Secondly we need to do Archiving for incidents in BMC Remedy, how we can do archiving in Remedy? Thanks Regards Amanullah Software Consultant DISCLAIMER:This e-mail message including any of its attachments is intended solely for the addressee(s) and may contain privileged information. If you are not the addressee or you have received this email message in error, please notify the sender who will remove your details from its database. You are not authorized to read, copy, disseminate, distribute or use this e-mail message or any attachment to it in any manner and must delete the email and destroy any hard copies of it. This e-mail message does not contain financial instructions or commitments of any kind. Any views expressed in this message are those of the individual sender and do not necessarily reflect the views of Emirates NBD PJSC, or any other related subsidiaries, entities or persons. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
ARSLIST as RSS-Feed
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 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
ARDBC Plugin questions
** 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 ARPluginIdentify any influence of the behaviour of the plugin or it is only for version control? - Has anyone tested selfmade plugins on AR Server version 7 under Windows? - I wrote the function ARPlugInSetProperties but in the arplugin.log the function is still undefined. Any hints ARPLUGIN_EXPORT int ARPlugInSetProperties(ARPropList *propList,ARStatusList status) { propList-numItems = 1; propList-props = (ARPropStruct *) calloc(1, sizeof(ARPropStruct)); propList-props[0].prop = AR_PLUGIN_PROP_LOG_FUNCTION; propList-props[0].value.dataType = AR_DATA_TYPE_CHAR; propList-props[0].value.u.charVal = strdup(TEST PROP); return AR_RETURN_OK; } best regards Torsten Brosow [EMAIL PROTECTED] / http://www.ntuition.de __20060125___This posting was submitted with HTML in it___
AW: Integration Remedy and Webmethods
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 PROTECTED] Im Auftrag von Pascale Boyer Gesendet: Mittwoch, 16. August 2006 16:13 An: arslist@ARSLIST.ORG Betreff: Integration Remedy and Webmethods Hi all We are trying todo a integration between Webmethods and ARS 5.1.2 We installed the required DLL on the webmethods server but it looks like we are still missing something. As far as we can see we did install everything in the proper location. We did contact webmethods (3 days ago) and still no answer... Did any of you did this integration and what are the DLL, jar etc that are required. Remedy: ARS: 5.1.2 patch 1375 OS: Sun Solaris 5.9 Webmethods: Win 2K remedy adapter 6 _ __ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
IP Address from ARS-Client
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
Thanks Tristan :) do you have any idea without any API Call to use. Do you know in which table it is. Then I can use SQL to get it. For the background: We are using our ReportLink to display any data over the web. To avoid that any User manipulates the urlwe create a crypted session string with a filter plugin. When we have the IP as well we can check it into the ReportLink if it match. Still in the OSD project? Cheers Torsten Mit freundlichen Gren / best regards --- Torsten Brosow System Architect Integration COC N-Tuition Business Solutions AG Martin-Behaim-Str. 4, D-63263 Neu-Isenburg Fon: +49 175 9319 614 Fax: +49 6102 567 888 Fix: +49 6102 567 805 [EMAIL PROTECTED] / htttp://www.coc-ag.de Von: Action Request System discussion list(ARSList) im Auftrag von [EMAIL PROTECTED]Gesendet: Fr 04.08.2006 14:22An: arslist@ARSLIST.ORGBetreff: Re: IP Address from ARS-Client ** Hi Torsten ! With the help of the API call ARGetListUser you can get the information of the working users, after that you can easilycheck with the help of LDAP or Active Directory the IP-connection ! Cheers 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 be working in the Mid-Tier as well. Any hints? Thanks Torsten __20060125___This posting was submitted with HTML in it___