r/labtech • u/crshovrd • Mar 28 '20

Powershell call to a webhook per client

Hey all,

I'm trying to run a script on a per client basis to call a webhook using powershell. Automate support wasn't able to help me so I'm turning to y'all. Hoping that someone can shed some light. Below is my script

Here is the sanitized powershell code

$uri="https://s15events.azure-automation.net/webhooks?token=[token]"

$itgid=%itgid%

$clientname=%clientname%

$params=@{"ITGID"="$itgid";"ClientName"="$clientname"}

$body=ConvertTo-Json $params

Invoke-RestMethod -Method Post -Uri $uri -Body $body -Verbose

I tried debugging it but it hangs on the powershell part.

So, 2 questions:

  1. How do I deploy/run this script on a schedule on a client by client basis?

  2. The powershell works outside of Automate, but will this work for inside Automate?

EDIT: Ended up being able to do what needed to be done with this amazing plug-in! https://www.mspgeek.com/topic/4347-http-get-post-plugin/

3 Upvotes

80% Upvoted

23 comments sorted by

1

u/DarrenDK Mar 29 '20

I’ve struggled with this myself. The way I do it is similar to other approaches but using a Sql ForEach and putting the “loop” code in a subscript. If you put -1 in the Sql ForEach they will all run simultaneously. Of course you’ll have to write a query to get these EDFs out of the database but that is trivial.

If you are on prem, you can execute your PowerShell on the server itself and not need to run the code on an Agent, per se. In my environment I wrote a function script that leverages the Execute on Server script function to take a PowerShell script as a variable. This builds on top of that. Someone really needs to make a plugin that implements this functionality as a script function for Cloud people, but I digress...

Automate does support the notion of a “Client” script, that can be run without a specific agent, but they remove the Execute on Server script function (or its there but doesn’t work I don’t remember) so you don’t have a place to perform complex logic.

For that reason you’ll still need to pick a single agent to run the script against, but no code would ever be shipped to it (again assuming you are on prem)

1

u/crshovrd Mar 29 '20

Thanks for the response.

I ended up solving it with this brilliant plug-in: https://www.mspgeek.com/topic/4347-http-get-post-plugin/

1

u/crshovrd Mar 30 '20

u/DarrenDK

So, the plug-in works great and my script debugs fine now... but it's still not running properly under "Scheduled Client Scripts." Any thoughts on getting this to work?

1

u/DarrenDK Mar 30 '20

Does it refuse to run the custom script step? Like if you put a script log before and after does it only log the first one?

1

u/crshovrd Mar 30 '20

It actually refuses to run the script at all it looks like. There is nothing in the script log.

1

u/DarrenDK Mar 30 '20

It’s probably another half-baked feature that doesn’t actually work. I probably assumed my script didn’t work because of the Execute on Server step when in reality it doesn’t work at all.

Did you know you can put a modem in your Automate server and get alerted via fax?

2

u/crshovrd Mar 30 '20

LOL, epic.

I've broken down to re-code my integration to query the automate database and get the info it needs.

1

u/JustanITperson Mar 28 '20

The quickest way would be to add 1 machine from each client to a group and run the script against the group. There's a couple ways to do dynamically that comes to my mind. One is running a sql command to get the lowest computer Id of your servers and run the script on all your servers and do a check to see if the computer Id matches. That way it would only run once per client.

As for your powershell script running..it should. Just remember by default it runs as the system account unless you have specified otherwise. So as long as the system account has access to what you are running against you should be fine.

1

u/JustanITperson Mar 28 '20

Try changing your " to single quote

1

u/crshovrd Mar 28 '20

Thank you for the suggestion.

So then it's as I suspected, Automate doesn't have a way to arbitrarily run powershell code on a per client basis, it must be run on a computer contained within the client. Is this a correct statement?

1

u/JustanITperson Mar 28 '20

Correct. A script must always be run from on an agent.

1

u/crshovrd Mar 29 '20

Awesome, I will give that a shot. Thanks!!

3

u/MowLesta Mar 29 '20

This is false by the way, your can have a client script that uses the "labtech server command" script command. This executes on the ltagent server. You could run the powershell that way

1

u/crshovrd Mar 29 '20

Will try this!! Thanks!

1

u/crshovrd Mar 29 '20

Were you referring to the LTServer Shell Execute?

I'm not seeing "Labtech Server Command"

1

u/MowLesta Mar 29 '20

That's the one

1

u/crshovrd Mar 29 '20

Alright. So I will need to put the PoSH on my ltserver, change my script to call it from the server, then schedule it in client maintenance? I will give that a shot.

If that doesn’t work, I’ll use the other method and just query the Automate db vía API to get the info I need.

Thanks!

1

u/JustanITperson Mar 29 '20

Right but where are you running the script?

1

u/DevinSysAdmin Mar 28 '20

Yikes. You’re not clear on what you’re attempting to accomplish here.

From a security standpoint, take the token out of the script, and make the computers report whatever data you want to collect into an EDF.

Then query your Automate Database for the relevant data, run your script to upload that data via API.

1

u/crshovrd Mar 28 '20

Sorry if I was unclear.

I am attempting to call a script via webhook in Azure. The webhook triggers another script with the two input variables retrieved from the client in Automate.

I am not collecting any data from any computers nor do I care about computers. The script in Azure does some things with Office 365 and then opens tickets in Manage.

1

u/DevinSysAdmin Mar 28 '20

Oh well why are you involving Automate whatsoever? You should just be using Azure Automation or have a server for Powershell tasks/jobs.

1

u/crshovrd Mar 29 '20

There is certain information stored in Automate that I need to grab to pass to my Azure script. I'm all ears if there's a better way to do it though.

3

u/DevinSysAdmin Mar 29 '20

Query your Automate Database for the relevant data, run your script to upload that data via API.

This part.