• State Verified Answer
  • Locked Locked
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 92 subscribers
  • Views 3492 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

When is the INSERT event triggered for ADSAccountinADSGroup ?

CVU
over 5 years ago

Hi there!

I have some operations that need to be performed when an AD account gets inserted in a specific group. I've created a business role, let's call it "AccesosPermitidos" for that, so when the Person gets the role, the ad account is inserted in an AD  group and some files are copied to the AD user profile. To accomplish this, I've created a custom process attached to the ADSAccountinADSGroup table and the insert event.

With this scenario, I'm having trouble trying to figure out when the event INSERT is triggered for the table ADSAccountinADSGroup. Sometimes is triggered, sometimes is not.

Cases:

  1. Locate the AD account , add the AD group: Insert triggered
  2. Locate the AD group, add the AD account. Insert triggered
  3. Now I grant the role "AccesosPermitidos" to a Person. In this case, the Insert event is not triggered, only Update on the table ADSGroup. The result is the same, I mean, an insert is performed in the ADSAccountinADSGroup (checked via Object Browser) but the Insert event is not triggered though. Why is that?

Thanks!

  • +1 over 5 years ago

    Hi Juan,

    You don't say which version of 1IM you are using but I'm going to assume it's V7 or above.  First, ensure that you have enabled 'Assign by event' for the table ADSAccountInADSGroup in Designer.  Then you should configure your process to react off the events INSERT and ASSIGN (the opposites are DELETE and REMOVE).

    I think this will move you along.

    HTH, Barry.

  • 0 over 5 years ago in reply to Barry Jackson

    Hi Barry,

    Sorry I was so messed up with the issue that I even forgot to mention that. This is version 8.0.1 Slight smile , migrated from Oracle to Sqlserver .

    Process configured and acting correctly now. Evenmore, it is not the first time though that I need to activate this setting on other tables, so more to add to my mistake.

    You think well. This moved me along... and beyond.

    Thanks so much!!