How to create payload in ecc queue?

Sathwik1
Tera Expert

Can someone help me to create payload in ecc queue..

I need to pass a powershell command through payload  so that command can perform some action in the midserver.

1 ACCEPTED SOLUTION

@Sathwik1 

I wrongly copied these 2 lines

try this

var value = "Get-ChildItem –Path \\'C:\\SathwikFolder\\' -Recurse | Where-Object {($_.LastWriteTime -lt (Get-Date).AddDays(-10))} | Remove-Item";
var payload = '<?xml version="1.0" encoding="UTF-8"?><parameter name="name" value="' + value + '"></parameter>';

when I used this it didn't give me xml error

see output below

XML Error.gif

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

21 REPLIES 21

tried like below @Ankur Bawiskar 

that powershell script is responsible for deleting records in the mid server

 

Sathwik1_0-1676361996774.png

 

 

I tried as per your suggestion, but still it's not working.. please correct my code..

var gr = new GlideRecord('ecc_queue');
gr.newRecord();
gr.agent='mid.server.DevMID_ServerCluster1';
gr.topic='Command';
value = PowerShell -Command "Get-ChildItem –Path \"C:\SathwikFolder\" -Recurse | Where-Object {($_.LastWriteTime -lt (Get-Date).AddDays(-10))} | Remove-Item";
gr.payload = <?xml version="1.0" encoding="UTF-8"?><parameter name="name" value=+value/></parameter>;
gr.queue = "output";
gr.insert(); 

What was wrong in this @Ankur Bawiskar , please correct my code..

@Ankur Bawiskar @asifnoor 

Please help me to understand what was mistake in the above code.

@Sathwik1 

I modified your script a little bit

please check the highlighted line and update it correctly

var gr = new GlideRecord('ecc_queue');
gr.initialize();
gr.agent='mid.server.DevMID_ServerCluster1';
gr.topic='Command';
var value = 'Get-ChildItem –Path \"C:\SathwikFolder\" -Recurse | Where-Object {($_.LastWriteTime -lt (Get-Date).AddDays(-10))} | Remove-Item';
gr.state = 'ready';
gr.payload = '<?xml version="1.0" encoding="UTF-8"?><parameter name="name" "value="' + value + '"/></parameter>';
gr.queue = "output";
gr.insert();

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Tried ankur, same error again..

In output, below part is highlighted in red.. I think there is some issue..

Sathwik1_0-1676366198894.png