MyWiki

### Option: UserParameter
# VeeamBackup
UserParameter=vbr[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\zabbix_vbr_job.ps1" "$1" "$2" "$3"
###############################################
# TaskScheduler
UserParameter=TaskSchedulerMonitoring[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\DiscoverScheduledTasks.ps1" "$1" "$2"
# Etat de la tâche
UserParameter=TaskSchedulerStatus[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\Scripts\SchedulTaskStatus.ps1" "$1" "status"
# Code retour de la tâche
UserParameter=TaskSchedulerResult[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\Scripts\SchedulTaskStatus.ps1" "$1" "result
# Datetime de la dernière exécution
UserParameter=TaskSchedulerLastrun[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\Scripts\SchedulTaskStatus.ps1" "$1" "lastrun"
# Datetime de la prochaine exécution
UserParameter=TaskSchedulerNextrun[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\Scripts\SchedulTaskStatus.ps1" "$1" "nextrun"
###############################################
# Checks IIS
UserParameter=apppool.discovery,powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\get_apppool.ps1"
UserParameter=apppool.state[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\get_apppoolstate.ps1" "$1"
UserParameter=site.discovery,powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\get_sites.ps1"
UserParameter=site.state[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\get_sitestate.ps1" "$1"
###############################################
# ORACLE
# Discovery
UserParameter=oracle-discovery[*],powershell -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\check_oracle.ps1" "$1"
# GetItem
UserParameter=oracle-get-item[*],powershell -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\check_oracle.ps1" "$1" "$2"
###############################################
# MSSQL
# Liste des bases de données
UserParameter=mssqlDatabasesList[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\checkMSSQL.ps1" "databaseslist"
# Taille d'une base de données
UserParameter=mssqlDatabaseSize[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\checkMSSQL.ps1" "dbsize" "$1
# Taille du log de base de données
UserParameter=mssqlDatabaseLogsize[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\checkMSSQL.ps1" "logsize" "$1"
# Nombre de connexions à la base de données
UserParameter=mssqlDatabaseCnx[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\checkMSSQL.ps1" "dbcnx" "$1"
# Fonctionnement de la base de données
UserParameter=mssqlDatabaseCheck[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\checkMSSQL.ps1" "dbcheck" "$1"
# Liste des tâches planifiées
UserParameter=mssqlTasksList[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\checkMSSQL.ps1" "taskslist"
# Info sur la tâche planifiées
UserParameter=mssqlTaskInfo[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\checkMSSQL.ps1" "task" "$1"
# Nombre de requêtes SELECT
UserParameter=mssqlNumReqSelect[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\checkMSSQL.ps1" "request" "select" "$1"
# Nombre de requêtes INSERT
UserParameter=mssqlNumReqInsert[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\checkMSSQL.ps1" "request" "insert" "$1"
# Nombre de requêtes UPDATE
UserParameter=mssqlNumReqUpdate[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\checkMSSQL.ps1" "request" "update" "$1"
# Nombre de requêtes DELETE
UserParameter=mssqlNumReqDelete[*],powershell -NoProfile -ExecutionPolicy Bypass -File "C:\Program Files\Zabbix Agent 2\scripts\checkMSSQL.ps1" "request" "delete" "$1"
################################################

# SQUID
# - Retourne le nombre de connexions
UserParameter=squid.cnxnmbr,netstat -an|grep ":3128"|grep ESTABLISHED|wc -l

# Apache2
# - Retourne le nombre de connexions
UserParameter=apache2.nbcnxhttp,netstat -an|grep ":80 "|grep ESTABLISHED|wc -l
UserParameter=apache2.nbcnxhttps,netstat -an|grep ":443 "|grep ESTABLISHED|wc -l

# SMTP
# - Retourne le nombre de connexions
UserParameter=smtp.cnxnmbr,netstat -an|grep ":25 "|grep ESTABLISHED|wc -l

# Nginx
# - Retourne le nombre de connexions
UserParameter=nginx.nbcnxhttp,netstat -an|grep ":80 "|grep ESTABLISHED|wc -l
UserParameter=nginx.nbcnxhttps,netstat -an|grep ":443 "|grep ESTABLISHED|wc -l
UserParameter=nginx.nbcnxpops,netstat -an|grep ":995 "|grep ESTABLISHED|wc -l
UserParameter=nginx.nbcnximaps,netstat -an|grep ":993 "|grep ESTABLISHED|wc -l

# - Retourne le nombre de ports en écoute
UserParameter=nginx.listenhttp,netstat -an|grep ":80 "|grep LISTEN|wc -l
UserParameter=nginx.listenhttps,netstat -an|grep ":443 "|grep LISTEN|wc -l
UserParameter=nginx.listenpops,netstat -an|grep ":995 "|grep LISTEN|wc -l
UserParameter=nginx.listenimaps,netstat -an|grep ":993 "|grep LISTEN|wc -l

# - Retourne le nombres de MAJ en attentes
# - Avant Debian 9
UserParameter=apt.upgradable,aptitude search '~U' | wc -l
# - Apres Debian 9
UserParameter=apt.upgradable,yum list updates  2> /dev/null|tail -n +7|wc -l
# - CentOS
UserParameter=apt.upgradable,apt list --upgradeable  2> /dev/null|tail -n +2|wc -l