Imanami Community

We are trying to automate DTM to move user account if/when a user changes deparmtents.  I know this is possible with the power tools but does anyone have a sample script?

Edit the global script and add the Active Directory PowerTool.  I would recommend moving the user after the update, so use the Row_Changed event:

sub DTM_RowChanged(dtmsource As Object, args As JobEventArgs) handles DTM.RowChanged
 ' User-definable script goes here -----------------

'Check if Department attribute has been changed.

If DTM.OriginalDestination("Department").Trim().ToLower() <> DTM.StagingDestination("Department").Trim().ToLower() Then

'Department attribute is changing so let's move the user

Select Case DTM.Source("Department").Trim().ToLower()

Case "sales"

ActiveDirectoryTool.MoveObject("LDAP://OU=HR,DC=fabrikam,DC=com")

Case Else

'Do nothing

End Select

End If

 ' -------------------------------------------------
end sub

I get a few compile errors: 

'OriginalDestination' is not a member of 'Imanami.Dtm.Scripting.IScriptingObject'

'StagingDestination' is not a member of 'Imanami.Dtm.Scripting.IScriptingObject'

Name 'ActiveDirectoryTool' is not declared

Did you add the ActiveDirectory PowerTool to the GSE?  You need the ActiveDirectory PowerTool.dll.  You can add it to the GSE by clicking Add References.

How would I get this ActiveDirectory PowerTool.dll ? What other PowerToll.dll's are availible and how do I get them?

Jay Brophy 

 

Did you add the ActiveDirectory PowerTool to the GSE?  You need the ActiveDirectory PowerTool.dll.  You can add it to the GSE by clicking Add References.

 

 

I also can't locate ActiveDirectory PowerTool.dll

Attached is a document covering the ActiveDirectory PowerTool in detail.  The document includes instructions on how to get the PowerTool.

--Robert

The script still wasn't compiling after adding the AD power tool so did the following modifications <<dtmsource.OriginalDestination("City").Trim().ToLower()>>(as seen below) but when I run the job it fails.

sub DTM_RowChanged(dtmsource As Object, args As JobEventArgs) handles DTM.RowChanged
 ' User-definable script goes here -----------------
'Check if City attribute has been changed.

If dtmsource.OriginalDestination("City").Trim().ToLower() <> dtmsource.StagingDestination("City").Trim().ToLower() Then

'City attribute is changing so let's move the user

Select Case DTM.Source("CITY").Trim().ToLower()

Case "TORONTO"

ActiveDirectoryTool.MoveObject("LDAP://OU=DTM2,DC=LAB,DC=LOCAL")

Case Else

'Do nothing

End Select

End If
 ' -------------------------------------------------
end sub