Skip to content

Instantly share code, notes, and snippets.

@DerfOh
DerfOh / install-sql-exporter.ps1
Created October 7, 2022 14:36
Installs sql exporter and configurations
$version = "0.9.1"
$AgentURL = "https://github.com/burningalchemist/sql_exporter/releases/download/${version}/sql_exporter-${version}.windows-amd64.zip"
$AbsoluteCurrPath = $(Get-Location).Path
$AbsolutePathZip = "${AbsoluteCurrPath}\tmp\sql-exporter\sql_exporter.zip"
$ServiceName = "sql_exporter"
$TempDirectoryToCreate = "$AbsoluteCurrPath\tmp\sql-exporter"
$SQL_EXPORTER_PATH = "C:\sql-exporter"
$ExporterDirectoryToCreate = "C:\sql-exporter"
# Default is localhost, can be changed if the exporter needs to be remote
# 'sqlserver://${DbUser}:${DbPassword}@${DbAddress}:${DbPort}'
@DerfOh
DerfOh / install-windows-exporter.ps1
Created October 8, 2022 00:10
installs windows prometheus exporter
$version = "0.20.0"
$AgentURL = "https://github.com/prometheus-community/windows_exporter/releases/download/v${version}/windows_exporter-${version}-amd64.exe"
$AbsoluteCurrPath = $(Get-Location).Path
$ExporterDirectoryToCreate = "C:\Program Files\windows_exporter\"
$AbsolutePathExe = "${ExporterDirectoryToCreate}\windows_exporter.exe"
$EnabledCollectors = "cpu,cs,logical_disk,memory,net,os,service,system,tcp,remote_fx,logon,process"
$ServiceName = "windows_exporter"
# create exporter directory