Re: [Non-DoD Source] Need input on Delta load - Spoon client

2017-08-28 Thread Jarl Grøneng
If you running 9.1 SP3 you can use the AR Upsert step, that can handle checksum. https://docs.bmc.com/docs/ars91/ar-upsert-step-718087759.html -- J 2017-08-28 20:43 GMT+02:00 Scott Philben : > ** > I am in the middle of this. Here is what I did (based on a thing I found > on Communities). You h

Re: Securing Sensitive WO Information

2017-08-28 Thread Adams, Peter
See https://docs.bmc.com/docs/itsm91/row-level-security-612964878.html On 8/23/17, 1:25 PM, "Action Request System discussion list(ARSList) on behalf of Rockwood, Julie" wrote: This is exactly what Support Group Hierarchical Configuration was introduced for. However you will want to pat

Re: Smart IT Assigned Person

2017-08-28 Thread Adams, Peter
I do want to call out that applying an incident template after creation of the incident is also not possible ootb with the mid-tier ITSM UI. I understand that some customers have solved this via “customization”, but it is not an ootb capability. In fact, there are a number of interesting quesi

Re: [Non-DoD Source] Need input on Delta load - Spoon client

2017-08-28 Thread Ravindrakumar Rodge
There is NGIE:Delta form that holds the last successful run which can be used to run the job for delta part. Regards, Ravindrakumar On Aug 29, 2017 12:15 AM, "Scott Philben" wrote: > ** > I am in the middle of this. Here is what I did (based on a thing I found > on Communities). You have to set

Re: [Non-DoD Source] Need input on Delta load - Spoon client

2017-08-28 Thread Scott Philben
I am in the middle of this. Here is what I did (based on a thing I found on Communities). You have to set a checksum value in the data stream the first time you call AD. Then the second time you can do a DB call to the table you are using (I have a staging form) and filter out the ones that alr

Re: [Non-DoD Source] Need input on Delta load - Spoon client

2017-08-28 Thread Joe D'Souza
There is something funky about the AR API that is used by Pentaho Spoon. If I recall correctly, the $OPERATION$ value at the time of create as well as update is CREATE. Something funky like that. I do not recall specifics, but you could try a small experiment to ascertain this for yourself. Cre

Re: [Non-DoD Source] Need input on Delta load - Spoon client

2017-08-28 Thread Shivanand Jeerigiwad
Hi Ryan, Yes, i am passing.. My scenario is like in a day if i process 100 records it successfully creates people record. But the next day it should not consider the same old records unless if it is not updated at LDAP side. How i can achieve this? Regards, Shiva +91 9986985798 On Mon, Aug 28,

Re: [Non-DoD Source] Need input on Delta load - Spoon client

2017-08-28 Thread Nicosia, Ryan J CTR USSOCOM SOCOM J631
Are you passing "VALIDATELOAD" into z1D_Action field? That triggers the workflow to run. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shivanand Jeerigiwad Sent: Monday, August 28, 2017 6:32 AM To: arslist@ARSLIST.ORG

Need input on Delta load - Spoon client

2017-08-28 Thread Shivanand Jeerigiwad
Hi team, I am trying to achieve the LDAP People Integration. I can able to pull people records from LDAP server to BMC staging i.e CTM:LoadPeople form. However, not getting how to achieve the delta load. If anybody has done, please let me know. Regards, Shiva +91 9986985798 __