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/updated client ID into the script. Check the syntax of your SQL with the verify button.
Caution! Be careful with this feature. If you don’t use a filtering statement to the specific client PKID, you may/will update ALL clients in your HelpMaster database depending on your SQL script.
Caution! SQL does not have an “undo” feature. The only undo is a database restore from 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.