kohera-logo-regular.svg

Sending monitoring alerts through Telegram

What if you could get the ease of phone notifications for whatever monitoring alerts you need? Then we have a solution for you with the app Telegram. Some of you may be familiar with this messaging tool, that’s very similar to WhatsApp. Telegram focusses on speed and security, is easy to use and free. Setting up the monitoring alerts through Telegram enables you to always be informed on any device. In this blog, we will show you how to set this up with the language PowerShell. We will also create a “bot”, which will be used to receive the messages that we are sending through PowerShell.

 

Create a Telegram Bot

Open the Telegram app and look for the BotFather account in the search bar. Click the verified BotFather account, this bot will be used to create new bot accounts and manage your existing bots.

Open the chat with the BotFather.

    1. Enter or click the command /newbot

    1. Enter the name for your bot

    1. Enter a username for the bot

    1. Save the API token (it is case sensitive)

The full process looks like this:

 

 

Add the bot to a channel

Your bot is created! Next, we need to add the bot to our group or channel so we can receive our chat ID. Pick whatever channel or group you want to use and add the bot. Once you’ve done that, you will need to make the bot administrator. That way we can get the list of updates for your bot.

For this step, you need to go to the Telegram website and fill in your bot API token.

https://api.telegram.org/bot<YourBOTToken>/getUpdates

Example:

https://api.telegram.org/bot5115011894:AAHf8mpjSX-4sLCzBeVtbEAC6YYhADzBPks/getUpdates

Then look for the “chat” object:
(Note: If you created the group/channel with the bot and you only get: {“ok”:true,”result”:[]} , please remove and add the bot again)

 

 

The PowerShell

Now that we have all the parameters we need, we can go to the last and probably most crucial step: the PowerShell script. We have different ways to set up our script to fulfill different use cases. One is getting data from another application. Let’s say we have a monitoring application like SentryOne. When a certain condition is met within that application, we want a Telegram message to be sent.

{

$MyToken = "5313732773:AAGiZxJk6rgB4RkrlMGnWm28sj2mH_0cYDQ"

$chatID = -1001693547082

$rawBody = @{text='<%Message%>'}

$contentType ='application/json'

$jsonBody = (convertto-json $rawBody)

$Response = Invoke-RestMethod -Uri "https://api.telegram.org/bot$($MyToken)/sendMessage?chat_id=$($chatID)" -Method POST -ContentType $contentType -Body $jsonBody

Let’s break down the script to see what all these PowerShell lines mean:

    1. The first two lines of code are your chatID and your BotToken. Those are two parameters that you have determined in the previous step.

    1. The third line in the script is a message placeholder. This is an executive action parameter in SentryOne and allows us to pass content.

    1. The last few lines are the ones that will convert the messages into JSON and send the message to Telegram.

The message

When your condition is met and your PowerShell action is defined with the correct parameters, we will get a message like this on our Telegram chat.

Or let’s say we want to decide what we sent. We can change the script a little bit.

$MyToken = "5313732773:AAGiZxJk6rgB4RkrlMGnWm28sj2mH_0cYDQ"
$chatID = -625205559
$rawBody = @{text='Hello everyone, thank you for reading my blog!'}
$Response = Invoke-RestMethod -Uri "https://api.telegram.org/bot$($MyToken)/sendMessage?chat_id=$($chatID)" -Method POST -Body $RawBody

The test

So, let’s run the last script and see which result we get.

You received a message from your Telegram bot! Using the above method, you will be able to send monitoring alerts through Telegram by using the app in your PowerShell scripts.

DSC_1388
Aggregaties
Power BI Desktop is een prachtige tool om snel data-analyses te kunnen uitvoeren. Je connecteert op een databron, importeert en...
dba image
DBA is not that scary
Often when talking to people who are looking for a career path in the data world I feel like there...
blog-2303
How do you link an SCD Type 2 table in Power Query?
This article uses a simple example to demonstrate how to link an SCD Type 2 table in Power Query to...
featured-2302
How to easily parse JSON in Power BI Desktop
Sometimes you want to use JSON data in Power BI. And sometimes Power BI doesn’t exactly do what you want...
header-2301
Power BI reports as monitoring tool
Who has not created monitoring reports or beautiful dashboards in Power BI? Would it not be great to show off...
your-modernization-journey-starts-now-header
Your Modernization Journey starts now
Recently Microsoft introduced SQL server 2022. We wrote this post to make sure you won’t be missing out on all...