Thanks Kelly, I am aware of that, my question is about the concept of using Webservices or Transact SQL to achieve this. How to go about implementing sending some data from the remote database to update the local one. for example an assetID which will be stored in a local form and fire a filter on submit/update which will execute a run process etc..
--- En date de : Mar 15.9.09, Kelly Deaver <[email protected]> a écrit : De: Kelly Deaver <[email protected]> Objet: Re: AIE 7.5 À: [email protected] Date: Mardi 15 Septembre 2009, 0h27 ** if you can trigger and run a command line you can trigger an AIE exchange using aiexfer utiilty. Look on page 169 of the AIE 7.5 Users Guide for details. Kelly Deaver Effective Technologies www.effect-tech.com [email protected] (ARSlist mail) [email protected] (Business mail) (no longer BMC) -------- Original Message -------- Subject: Re: AIE 7.5 From: Frex Popo <[email protected]> Date: Mon, September 14, 2009 2:14 pm To: [email protected] ** Did anyone try to do something similar? I was thinking may be this can be acheived using WebServices or Transact SQL. I am sure there are other ways of doing this using ARS API for example. Perhaps send some token (assetid) from the remote applicacion using the Remedy WebService, this will be written to some form with a filter attached to it. The filter will then run the "Data Exchange" for that single record and update the local copy. Or Perhaps (not sure if this would be tidy) create a trigger on the remote SQL server which fires on an attribute change which would update a temporary table/view form localy which I later use to update the main class using a filter. Any thought? Frex. --- En date de : Jeu 10.9.09, Joe DeSouza <[email protected]> a écrit : De: Joe DeSouza <[email protected]> Objet: Re: AIE 7.5 À: [email protected] Date: Jeudi 10 Septembre 2009, 19h59 ** #yiv1914653082 #wmMessage #yiv475096450 DIV {margin:0px;} Frex, I'm afraid not. AIE is a schedule based system and not trigger based. If you need real time your only best bet would be to create a DB link and work your way up from there. Joe From: Frex Popo <[email protected]> To: [email protected] Sent: Thursday, September 10, 2009 8:15:50 AM Subject: AIE 7.5 ** Dear all, We are still on ITSM 7.0 and looking to upgrade at some stage. Someone asked me if version AIE 7.5 somehow can detect (In real time) any change to a specific attribute on a remote SQL Server table and (In real time of course) update the locally mapped attribute/class? This would be almost a miracle, but thought I will ask since I haven't seen 7.5 yet and don't have too much time to go through all the manuals etc. Many thanks in advance, Frex _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
