To all the experts out there.
I am trying to retrieve basic user details from our AD server using a Run Script action in Workflow. The script systematically takes between 14-20 seconds to run in Workflow to return the output succesfully.
Outside the Workflow but from the same machine, it takes about 1 second to run and returns the result to the console.
Am I missing anything? How can I get the below script to run faster within Workflow?
var oConnection = new ActiveXObject(“ADODB.Connection”);
var oCommand = new ActiveXObject(“ADODB.Command”);
oCommand.ActiveConnection = oConnection;
oCommand.Properties(“Page Size”) = 100;
var userName = ‘testuser1’;
oCommand.CommandText =“SELECT name, mail, sAMAccountName From ‘LDAP://adserver.com:333’ WHERE objectClass=‘User’ and sAMAccountName=’”+userName+"’";
oRS = oCommand.Execute;
Watch.Log("name " + oRS.Fields(“name”).Value,2);