Help getting Query AD output from databus

[apjohn2]

Hi everyone!

I have a workflow which is supposed to loop through users from a list collector variable and do a handful of Orch activities. I know the data being passed into the workflow is good because one of the orchestration pieces (to update an extension attribute in the AD user record) is working fine.

I'm stuck with the Query AD and subsequent If activities. I can't seem to get to the output from the databus no matter what I do. I've referred to multiple posts here but can't get anything to work.

What I need is this:

• Query AD for the user and pull back a single attribute: extensionAttribute15
• In a subsequent If activity, determine if the value of extensionAttribute15 is equal to "o365_Licensed_Standard" or not
• If that is the value, return yes, else, return no.
• Last time I ran a test I got 'undefined' for the 'ea15' variable shown below and have no idea why

I can't get this to output even when testing on a user I know has the affirmative setting.

Here's the whole script, including some commented-out lines where you can see different things I've tried. I can confirm the 'Data' tab shows "7" next to the activity output in question.

Anyone have a suggestion? (Much appreciated in advance!)

var ea15 = '';
var qry = new JSON();
qry = qry.decode(sanitizeResults(data.get(7).output));
ea15 = qry['extensionAttribute15'];
function sanitizeResults(qry) {
	qry = qry.replace(/<\/*(powershell|output)>/g, "");
	qry =qry.replace(/((^\[)|(\]$))/g, "");
	return qry;
}
gs.log('QUERY RESULTS FROM JSON DECODE DATA GET 7' + ea15);
if (ea15.indexOf('o365_Licensed_Standard') > -1) {
	answer = 'yes';
}
else {
	answer = 'no';
}

// var parser = new JSON();
// var obj = parser.decode(sanitizeResults(data.get(7).output));
// var olic = obj.extensionAttribute15;

// function sanitizeResults(obj) {
// 	obj = obj.replace(/<\/*(powershell|output)>/g, "");
// 	obj = obj.replace(/((^\[)|(\]$))/g, "");
// 	return obj;
// }

// if (olic.indexOf('o365_Licensed_Standard') > -1) {
// 	answer = 'yes';
// }
// else {
// 	answer = 'no';
// }

// var queryResults = new JSON().decode(data.get(7).output);
// gs.log('QUERY RESULTS FROM JSON DECODE DATA GET 7' + queryResults);
// answer = ((queryResults.length > 0 && queryResults == 'o365_Licensed_Standard') ? 'yes' : 'no');

// if (queryResults.length > 0 && queryResults.indexOf('o365_Licensed_Standard') > -1) { answer = 'yes'; }
// else { answer = 'no'; }

[apjohn2]

Hello there!

As noted I was able to get this working by starting again from the KB article linked above. (https://hi.service-now.com/kb_view.do?sysparm_article=KB0635207)

If you have some specific examples/code you want to post I'd be glad to take a look. May be worth posting a new question. Good luck!

[Smashley]

Hi Aaron,

Thanks for the reply.  I did use that KB, along with several other community posts, but am unable to isolate the name/value pair I need from the databus without [] around the value. In my case samaccountname.  My output looks like /"samaccountname/":[/"username/"]  I did post a question on the community, but have received no replies as of yet.  I was just curious if you actually were able to completely isolate your value from the databus, and what did it look like.  I know in the end, you were able to do an If with indexOf, but didn't know if you got farther than that.

Thanks anyways.

[apjohn2]

Sorry that I'm not more help here. I found your posted question. Have you tried submitting a HI support case for this? I think if I was in your shoes that might be my next step in trying to find help. I've had good experiences w/ them if that helps. 🙂