Use the Post Processing section of a profile to execute an SQL script on the newly created or updated user. This feature allows for additional customization for the newly synchronized HelpMaster client.
Enter any valid SQL into the relevant text box. Use the «ClientPKID» Tag as part of the SQL syntax to inject the newly created and/or updated client ID into the script. Check the syntax of your SQL with the SQL✓ verify button.
Be careful with this feature. If you don’t use the «ClientPKID» Tag filtering statement to find only matching clients, you will likely update ALL clients in your HelpMaster database depending on your SQL script.
Also SQL does not have an undo feature. The only way to undo this would be to restore a database from a backup. It is highly recommended that this feature is fully tested, and only used by experienced database personnel.
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.