MP for automatic installing SCOM agents on computers member of a configurable OU in AD.
The MP runs on a configurable schedule and uses Powershell to do all the important bits.
http://blogg.bouvet.no/2014/07/24/scom-automatic-agent-deployment-from-ad-mp/

import pymssql
from datetime import datetime, timedelta
import configparser
from telegram.ext import Updater, CommandHandler
import time

config = configparser.ConfigParser()
config.read("config.ini")


# SCOM connection
scom_server = config["scom"]["server"]
scom_user = config["scom"]["user"]
scom_password = config["scom"]["password"]


def get_alerts():

   conn = pymssql.connect(scom_server, scom_user, scom_password, 'OperationsManager')
   cursor = conn.cursor(as_dict=True)
   cursor.execute("""
   
   
select distinct
MonitoringObjectDisplayName,
Category,
dateadd(hour, 3, TimeAdded) as 'Time',
AlertStringName
-- AlertParams
from AlertView
where Severity = 2
and dateadd(hour, 3, TimeAdded) > DATEADD(MINUTE, -10, GETDATE())
and ResolutionState <> 255
   
   
   """)
   row = cursor.fetchall()

   result = []

   if len(row) != 0:
       for item in row:
           # age = (item['TimeAdded'] + timedelta(hours=3))
           item = 'Host: {0} \nCategory: {1} \nTime: *{2}* \n{3}'.format(item['M…