One stop PowerShell script to setup Prometheus, Grafana and Windows Exporter on Windows Machine


After setting up Prometheus, Grafana over Linux host, I was approached for similar setup over Windows. That had separate set of challenges since Prometheus and Grafana projects, despite of requests in last couple of years, are not yet compatible with Microsoft Service Framework. Even official documentation proposes solution via nssm, which is another OSS project (in a way).

Though I would have created similar step by step doc for Windows, thought to do better this time and almost half day work brought us a PowerShell script, which can download almost all the latest packages (except nssm, which is not github hosted) and then proceed to configure them on the same machine. Functions to download and create services are created in a way that select set of package can be downloaded or installed as putting everything on the same server may not be good idea.

This is still not ready for production use as there might be random quirks but here we do with the complete script, which has an experiment Prometheus configuration function as well.

About below?? Yeah I felt like I been doing it all the way wrong about sharing code. Github Gists are best way to share code on wordpress and also keep it updated. Though wish it could have been linked to normal github same way


#Requires -RunAsAdministrator
#Requires -Version 3.0
#Requires -Modules BitsTransfer
# Author : Nitish Kumar
# Download and Install Prometheus, Grafana and Windows Exporter
# version 1.0 | 19/10/2022 Initial version
# version 1.1 | 21/10/2022 Cleaned up the script to supress error messages, added override switch
# version 1.2 | 21/10/2022 Added a crude way to update Prometheus configuration for adding nodes at mass scale
# version 1.3 | 22/10/2022 Added remove services option. Sorted nssm output encoding issue to find install path
# version 1.4 | 23/10/2022 Ready for mass deployment, sample code parts added
# USAGES:
# For getting the installers need to add the below line
# Get-Executables # By default it downloads all four packages
# Get-Executables -packages Prometheus, Grafana # In case you want to download select packages
# For services setup, need to add the lines like below
# New-Services # By default, it would assume that all 4 packages need to be installed in c:\program files\<package_name> & executables are at c:\%username%\downloads\Executables
# New-Services -Override # Adding Override switch would remove existing installations & install fresh except nssm
# New-Services – packages Grafana, Windows_exporter # this would install only two of the packages given
# For prometheus config, need to add the lines like below, same way can be extended to many nodes using csv file or table in a loop
# Set-PrometheusConfig -jobName "Windows_exporter" -scrape_interval "5s" -targetAddress <IPAddress or FQDN> -targetPort <port> -prometheusInstallPath <Installation folder> # Except Scrape interview, rest all parameters are mandatory
# REFER TO COMMENTED PARTS AT END OF SCRIPT FOR MASS DEPLOYMENT CASES
Import-Module BitsTransfer
# Function to download excutables for Prometheus, Grafana, Windows_exporter and nssm
function Get-Executables {
[CmdletBinding()]
Param(
[Parameter(ValueFromPipeline = $true,mandatory=$false)]
[ValidateSet('Prometheus','Grafana','Windows_exporter','nssm')]
[String[]]$packages = @('Prometheus','Grafana','Windows_exporter','nssm'),
[Parameter(ValueFromPipeline = $true,mandatory=$false)]$executableDownloadPath = "$env:userprofile\downloads\"
)
if (Test-Path Path $executableDownloadPath"Executables") {
#Clean up the old files in the path before downloading new ones
$OldFiles = (get-Childitem $executableDownloadPath"Executables" ).FullName | Select-String Pattern $packages
$OldFiles | ForEach-Object {Remove-Item $_.Line}
} else {
New-Item Path $executableDownloadPath Name "Executables" ItemType "directory" | Out-Null
}
if ($packages -match 'Prometheus'){
$url = Invoke-RestMethod uri https://api.github.com/repos/prometheus/prometheus/releases/latest | Select-Object ExpandProperty assets | Where-Object{$_.Name.EndsWith("windows-amd64.zip")} | select expand browser_download_url
$file = Split-Path $url Leaf
Write-Host "Downloading $file to $($executableDownloadPath)Executables…" ForegroundColor GREEN
Start-BitsTransfer Source $url Destination $executableDownloadPath"Executables\"$file
}
if ($packages -match 'Grafana'){
$grafanaVersion = (Split-Path (Invoke-RestMethod uri https://api.github.com/repos/grafana/grafana/releases/latest).html_url Leaf ).Substring(1)
$file = "grafana-" + $grafanaVersion + ".windows-amd64.zip"
$url = "https://dl.grafana.com/oss/release/" + $file
Write-Host "Downloading $file to $($executableDownloadPath)Executables…" ForegroundColor GREEN
Start-BitsTransfer Source $url Destination $executableDownloadPath"Executables\"$file
}
if ($packages -match 'Windows_exporter'){
$url = Invoke-RestMethod uri https://api.github.com/repos/prometheuscommunity/windows_exporter/releases/latest | Select-Object ExpandProperty assets | Where-Object{$_.Name.EndsWith("amd64.exe")} | select expand browser_download_url
$file = Split-Path $url Leaf
Write-Host "Downloading $file to $($executableDownloadPath)Executables…" ForegroundColor GREEN
Start-BitsTransfer Source $url Destination $executableDownloadPath"Executables\"$file
}
if ($packages -match 'nssm'){
$file = Split-Path("https://nssm.cc/release/nssm-2.24.zip") Leaf
Write-Host "Downloading $file to $($executableDownloadPath)Executables…" ForegroundColor GREEN
Start-BitsTransfer Source https://nssm.cc/release/nssm2.24.zip Destination $executableDownloadPath"Executables\"$file
}
}
# Function to install services for Prometheus, Grafana, Windows_exporter and nssm
function New-Services {
[CmdletBinding()]
Param(
[Parameter(ValueFromPipeline = $true,mandatory=$false)]
[ValidateSet('Prometheus','Grafana','Windows_exporter','nssm')]
[String[]]$packages = @('nssm','Prometheus','Grafana','Windows_exporter'),
[Parameter(ValueFromPipeline = $true,mandatory=$false)]$servicePath = "$env:programfiles\",
[Parameter(ValueFromPipeline = $true,mandatory=$false)]$Override,
[Parameter(ValueFromPipeline = $true,mandatory=$false)]$executableDownloadPath = "$env:userprofile\downloads\Executables"
)
$packages
$servicePath
$Override
$executableDownloadPath
if($Override.IsPresent){
Write-Host "Proceeding to wipe out earlier installations of $($packages -join ","). Close the script if you do not wish so" ForegroundColor RED
Pause
}
Write-Host "Checking if nssm is setup …" ForegroundColor Yellow
$nssmExists = (where.exe nssm)
if ($nssmExists) {Write-Host "nssm found to be installed at $nssmExists"} else {Write-Host "nssm not installed yet …"}
ForEach($package in $packages){
# Install nssm which would help creating services for Prometheus and Grafana
if ($package -match 'nssm' -AND !($nssmExists)){
# Create folder for nssm in Installation path
New-Item Path $servicePath Name $package ItemType "directory" | Out-Null
Write-Host "Setting up $package" ForegroundColor GREEN
# Extract nssm zip to Install path
$filePath = (get-childitem $executableDownloadPath | Where-Object {$_.Name.StartsWith($package.ToLower())}).versioninfo.filename
$shell = New-Object ComObject Shell.Application
$zipFile = $shell.NameSpace($filePath + "\" + ((get-childitem $executableDownloadPath | Where-Object {$_.Name.StartsWith($package)}).Name -replace ".zip"))
$destinationFolder = $shell.NameSpace($servicePath + $package)
$copyFlags = 0x00
$copyFlags += 0x04 # Hide progress dialogs
$copyFlags += 0x10 # Overwrite existing files
Write-Host "Copying files for $package" ForegroundColor GREEN
$destinationFolder.CopyHere($zipFile.Items(), $copyFlags)
# Add nssm to system path permanently
$oldpath = (Get-ItemProperty Path 'Registry::HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\Environment' Name PATH).path
$newpath = $oldpath + ";" + $servicePath + $package + "\win64"
Set-ItemProperty Path 'Registry::HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\Environment' Name PATH Value $newPath
# Refresh the path variable for current session
$env:Path = [System.Environment]::GetEnvironmentVariable("Path","Machine") + ";" + [System.Environment]::GetEnvironmentVariable("Path","User")
$nssmExists = (where.exe nssm)
if ($nssmExists) {Write-Host "nssm is now installed at $nssmExists"} else {Write-Host "nssm not installed yet …"}
}
# Install Prometheus as Service
if ($package -match 'prometheus' -AND ($nssmExists)){
if($Override.IsPresent -AND (Get-Service prometheusservice)){
Write-Host "Proceeding to wipe out $package. Close the script if you do not wish so" ForegroundColor RED
Pause
Remove-Services packages $package
}
New-Item Path $servicePath Name $package ItemType "directory" | Out-Null
# Extract Prometheus installer zip to Install path
$filePath = (get-childitem $executableDownloadPath | Where-Object {$_.Name.StartsWith($package.ToLower())}).versioninfo.filename
$shell = New-Object ComObject Shell.Application
$zipFile = $shell.NameSpace($filePath + "\" + ((get-childitem $executableDownloadPath | Where-Object {$_.Name.StartsWith($package.ToLower())}).Name -replace ".zip"))
$destinationFolder = $shell.NameSpace($servicePath + $package)
$copyFlags = 0x00
$copyFlags += 0x04 # Hide progress dialogs
$copyFlags += 0x10 # Overwrite existing files
Write-Host "Copying files for $package Service from $filePath" ForegroundColor GREEN
$destinationFolder.CopyHere($zipFile.Items(), $copyFlags)
Write-Host "Setting up $package" ForegroundColor GREEN
$prometheusServiceName = 'prometheus-service'
$prometheusInstallPath = $servicePath + $package
$prometheusServiceUsername = "NT SERVICE\$prometheusServiceName"
Write-Host "Configuring the $prometheusServiceName service…" ForegroundColor GREEN
nssm install $prometheusServiceName "`"$prometheusInstallPath\prometheus.exe`""
nssm set $prometheusServiceName Start SERVICE_AUTO_START
nssm set $prometheusServiceName AppRotateFiles 1
nssm set $prometheusServiceName AppRotateOnline 1
nssm set $prometheusServiceName AppRotateSeconds 86400
nssm set $prometheusServiceName AppRotateBytes 1048576
nssm set $prometheusServiceName AppStdout "`"$prometheusInstallPath\logs\service-stdout.log`""
nssm set $prometheusServiceName AppStderr "`"$prometheusInstallPath\logs\service-stderr.log`""
nssm set $prometheusServiceName AppDirectory "`"$prometheusInstallPath`""
# Parameters are passed via a Here-String, so do not touch formatting if to use a path with space
nssm set $prometheusServiceName AppParameters `
@"
–config.file=""$prometheusInstallPath\prometheus.yml"" –storage.tsdb.path=""$prometheusInstallPath\data"" –storage.tsdb.retention.time=168h –web.console.libraries=""$prometheusInstallPath\console_libraries"" –web.console.templates=""$prometheusInstallPath\consoles"" –web.listen-address=:9090
"@
$result = sc.exe sidtype $prometheusServiceName unrestricted
if ($result -ne '[SC] ChangeServiceConfig2 SUCCESS') {
throw "sc.exe sidtype failed with $result"
}
$result = sc.exe config $prometheusServiceName obj= $prometheusServiceUsername
if ($result -ne '[SC] ChangeServiceConfig SUCCESS') {
throw "sc.exe config failed with $result"
}
$result = sc.exe failure $prometheusServiceName reset= 0 actions= restart/1000
if ($result -ne '[SC] ChangeServiceConfig2 SUCCESS') {
throw "sc.exe failure failed with $result"
}
$acl = Get-Acl $prometheusInstallPath
$user = New-Object System.Security.Principal.NTAccount($prometheusServiceUsername)
$acl.SetOwner([System.Security.Principal.NTAccount] $user)
$acl.SetAccessRuleProtection($True, $False)
$ruleSystem = New-Object System.Security.AccessControl.FileSystemAccessRule('SYSTEM','FullControl','ObjectInherit, ContainerInherit','None','Allow')
$ruleAdmins = New-Object System.Security.AccessControl.FileSystemAccessRule('Administrators','FullControl','ObjectInherit, ContainerInherit','None','Allow')
$ruleService = New-Object System.Security.AccessControl.FileSystemAccessRule($user,'ReadAndExecute','ObjectInherit, ContainerInherit','None','Allow')
$acl.AddAccessRule($ruleSystem)
$acl.AddAccessRule($ruleAdmins)
$acl.AddAccessRule($ruleService)
Set-Acl $prometheusInstallPath $acl | Out-Null
'data','logs' | ForEach-Object {
mkdir $prometheusInstallPath\$_ | Out-Null
$acl = Get-Acl $prometheusInstallPath\$_
$acl.SetOwner([System.Security.Principal.NTAccount] $prometheusServiceUsername)
$acl.SetAccessRuleProtection($True, $False)
$acl.AddAccessRule($ruleSystem)
$acl.AddAccessRule($ruleAdmins)
$ruleService = New-Object System.Security.AccessControl.FileSystemAccessRule($user,'FullControl','ObjectInherit, ContainerInherit','None','Allow')
$acl.AddAccessRule($ruleService)
Set-Acl $prometheusInstallPath\$_ $acl | Out-Null
Write-Host "Checking the prometheus configuration…" ForegroundColor GREEN
&$prometheusInstallPath\promtool.exe check config $prometheusInstallPath\prometheus.yml
Write-Host "Starting the $prometheusServiceName service…" ForegroundColor GREEN
Start-Service $prometheusServiceName
# Create Firewall rule for Prometheus Server
$suppressMsg = New-NetFirewallRule DisplayName 'Prometheus Server' Profile @('Public','Private','Domain') Direction Inbound Action Allow Protocol TCP LocalPort 9090 ErrorAction SilentlyContinue ErrorVariable MyErrorVar
}
}
# Install Grafana as Service
if ($package -match 'Grafana' -AND ($nssmExists)){
if($Override.IsPresent){
Write-Host "Proceeding to wipe out $package. Close the script if you do not wish so" ForegroundColor RED
Pause
Remove-Services packages $package
New-Item Path $servicePath Name $package ItemType "directory" | Out-Null
}
Write-Host "Setting up $package" ForegroundColor GREEN
$grafanaServiceName = 'grafana-server'
$grafanaInstallPath = $servicePath + "Grafana"
$grafanaServiceUsername = "NT SERVICE\$grafanaServiceName"
# Extract Grafana installer zip to Install path
$filePath = (get-childitem $executableDownloadPath | Where-Object {$_.Name.StartsWith($package.ToLower())}).versioninfo.filename
$shell = New-Object ComObject Shell.Application
$rawPath = $filePath + "\" + ((get-childitem $executableDownloadPath | Where-Object {$_.Name.StartsWith($package.ToLower())}).Name -replace ".zip")
$actualPath = $rawPath.Substring(0,$rawPath.Length14)
$zipFile = $shell.NameSpace($actualPath)
$destinationFolder = $shell.NameSpace($servicePath + $package)
$copyFlags = 0x00
$copyFlags += 0x04 # Hide progress dialogs
$copyFlags += 0x10 # Overwrite existing files
Write-Host "Copying data for the $($grafanaServiceName) service from $filePath, may take some time…" ForegroundColor YELLOW
$destinationFolder.CopyHere($zipFile.Items(), $copyFlags)
$confPath = $servicePath + $package
Copy-Item $confPath\Conf\defaults.ini $confPath\Conf\custom.ini
Write-Host "Configuring the $($grafanaServiceName) service…" ForegroundColor GREEN
nssm install $grafanaServiceName "`"$grafanaInstallPath\bin\grafana-server.exe`""
nssm set $grafanaServiceName Start SERVICE_AUTO_START
nssm set $grafanaServiceName AppRotateFiles 1
nssm set $grafanaServiceName AppRotateOnline 1
nssm set $grafanaServiceName AppRotateSeconds 86400
nssm set $grafanaServiceName AppRotateBytes 1048576
nssm set $grafanaServiceName AppStdout "`"$grafanaInstallPath\logs\service-stdout.log`""
nssm set $grafanaServiceName AppStderr "`"$grafanaInstallPath\logs\service-stderr.log`""
nssm set $grafanaServiceName AppDirectory "`"$grafanaInstallPath\bin`""
$result = sc.exe sidtype $grafanaServiceName unrestricted
if ($result -ne '[SC] ChangeServiceConfig2 SUCCESS') {
throw "sc.exe sidtype failed with $result"
}
$result = sc.exe config $grafanaServiceName obj= $grafanaServiceUsername
if ($result -ne '[SC] ChangeServiceConfig SUCCESS') {
throw "sc.exe config failed with $result"
}
$result = sc.exe failure $grafanaServiceName reset= 0 actions= restart/1000
if ($result -ne '[SC] ChangeServiceConfig2 SUCCESS') {
throw "sc.exe failure failed with $result"
}
$acl = Get-Acl $grafanaInstallPath
$user = New-Object System.Security.Principal.NTAccount($grafanaServiceUsername)
$acl.SetOwner([System.Security.Principal.NTAccount] $user)
$acl.SetAccessRuleProtection($True, $False)
$ruleSystem = New-Object System.Security.AccessControl.FileSystemAccessRule('SYSTEM','FullControl','ObjectInherit, ContainerInherit','None','Allow')
$ruleAdmins = New-Object System.Security.AccessControl.FileSystemAccessRule('Administrators','FullControl','ObjectInherit, ContainerInherit','None','Allow')
$ruleService = New-Object System.Security.AccessControl.FileSystemAccessRule($user,'ReadAndExecute','ObjectInherit, ContainerInherit','None','Allow')
$acl.AddAccessRule($ruleSystem)
$acl.AddAccessRule($ruleAdmins)
$acl.AddAccessRule($ruleService)
Set-Acl $grafanaInstallPath $acl | Out-Null
'data','logs' | ForEach-Object {
mkdir $grafanaInstallPath\$_ | Out-Null
$acl = Get-Acl $grafanaInstallPath\$_
$acl.SetOwner([System.Security.Principal.NTAccount] $grafanaServiceUsername)
$acl.SetAccessRuleProtection($True, $False)
$acl.AddAccessRule($ruleSystem)
$acl.AddAccessRule($ruleAdmins)
$ruleService = New-Object System.Security.AccessControl.FileSystemAccessRule($user,'FullControl','ObjectInherit, ContainerInherit','None','Allow')
$acl.AddAccessRule($ruleService)
Set-Acl $grafanaInstallPath\$_ $acl | Out-Null
Write-Host "Starting the $grafanaServiceName service…" ForegroundColor GREEN
Start-Service $grafanaServiceName
# Create Firewall rule for Grafana Server
$suppressMsg = New-NetFirewallRule DisplayName 'Grafana Server' Profile @('Public','Private','Domain') Direction Inbound Action Allow Protocol TCP LocalPort 3000 ErrorAction SilentlyContinue ErrorVariable MyErrorVar
}
}
# Install Windows Exporter as Service
if ($package -match 'windows_exporter'){
if($Override.IsPresent){
Write-Host "Proceeding to wipe out $package. Close the script if you do not wish so" ForegroundColor RED
Pause
Remove-Services packages $package
New-Item Path $servicePath Name $package ItemType "directory" | Out-Null
}
Write-Host "Setting up $package" ForegroundColor GREEN
# Extract Windows Exporter installer zip to Install path
$filePath = (get-childitem $executableDownloadPath | Where-Object {$_.Name.StartsWith($package.ToLower())}).versioninfo.filename
$windowsExporterInstallPath = $servicePath + $package
Write-Host "Copying files for $package Service from $filePath" ForegroundColor GREEN
Copy-Item $filePath $windowsExporterInstallPath
$exeName = split-path $filePath leaf
$ServicePath = """$windowsExporterInstallPath\$exeName"" –log.format logger:eventlog?name=windows_exporter –collectors.enabled ""cpu,cs,net,service,process,tcp,logical_disk,os,system,textfile,thermalzone"" –collector.textfile.directory C:\custom_metrics\"
$params = @{
Name = "Windows_exporter"
BinaryPathName = $ServicePath
DisplayName = "Windows Exporter"
StartupType = "Automatic"
Description = "To run windows exporter service"
}
New-Service @params
Write-Host "Starting the Windows Exporter service…" ForegroundColor GREEN
Start-Service Windows_exporter
# Create Firewall rule for Windows Exporter
$suppressMsg = New-NetFirewallRule DisplayName 'Windows Exporter' Profile @('Public','Private','Domain') Direction Inbound Action Allow Protocol TCP LocalPort 9182 ErrorAction SilentlyContinue ErrorVariable MyErrorVar
}
}
}
# Function to configure Prometheus
function Set-PrometheusConfig{
[CmdletBinding()]
Param(
[Parameter(ValueFromPipeline = $true,mandatory=$true)]$jobName,
[Parameter(ValueFromPipeline = $true,mandatory=$true)]$targetAddress,
[Parameter(ValueFromPipeline = $true,mandatory=$true)]$targetPort,
[Parameter(ValueFromPipeline = $true,mandatory=$false)]$scrape_interval="10s"
)
# Encoding of nssm output causes issue, so forcing to unicode temporarily
$originalEncoding = [Console]::OutputEncoding
[Console]::OutputEncoding = [System.Text.Encoding]::Unicode
$prometheusInstallPath =(nssm get prometheusservice AppDirectory) # This gives error msg due to NT Service in config, can be ignored
[Console]::OutputEncoding = $originalEncoding
if((Test-Path $prometheusInstallPath\prometheus.yml) -AND (Test-Path $prometheusInstallPath\promtool.exe)){
$backupYaml = Get-Content $prometheusInstallPath\prometheus.yml
$backupYamlUpdated = $backupYaml
$foundAt = ($backupYaml | Select-String "Job_name: ""$jobName""" ).LineNumber
$i = $foundAt
if($foundAt){
do {
if(($backupYaml[$i] | Select-String "targets:" ).LineNumber){
$backupYamlUpdated[$i] = $backupYamlUpdated[$i] -replace ']',",`"$targetAddress`:$targetPort`"]"
Write-Host "Targets changed to " $backupYaml[$i]
}
$i++
} while ( $null -eq ($backupYaml[$i1] | Select-String "targets:" ).LineNumber )
$backupYamlUpdated | Set-Content $prometheusInstallPath\prometheus.yml
$backupYaml | Set-Content $prometheusInstallPath\prometheuscopy.yml
}else {
add-content $prometheusInstallPath\prometheus.yml @"
– job_name: "$jobName"
scrape_interval: $scrape_interval
static_configs:
– targets: ["$targetAddress`:$targetPort"]
"@
}
if((& $prometheusInstallPath\promtool.exe check config $prometheusInstallPath\prometheus.yml) -match "SUCCESS"){
Write-Host "Configuration updated successfully." ForegroundColor Green
Write-Host "Restarting the prometheus-service service…" ForegroundColor GREEN
Get-Service prometheusservice | Restart-Service
} else {
$backupYaml | Set-Content $prometheusInstallPath\prometheus.yml
Write-Host "Incorrect config value: Changes rolled back." ForegroundColor Red
}
} else {
Write-Host "The given path $prometheusInstallPath doens't include either yml or promtool so we can not continue."
}
}
function Remove-Services {
[CmdletBinding()]
Param(
[Parameter(ValueFromPipeline = $true,mandatory=$true)]
[ValidateSet('Prometheus','Grafana','Windows_exporter','nssm')]
[String[]]$packages
)
ForEach($package in $packages){
# Remove nssm from system
if($package -match "nssm"){
$nssmExists = (where.exe nssm)
if ($nssmExists) {Write-Host "nssm found to be installed at $nssmExists"} else {Write-Host "nssm not installed yet …"}
$nssmDependents = (Get-CimInstance Win32_Service | Where-Object{$_.PathName -like "*nssm.exe*"} | Select-Object Name, DisplayName, StartMode, State)
if($nssmDependents.count -ne 0){
Write-Host "There are $($nssmDependents.Count) depedent service(s): $($nssmDependents.name -join ","). Remove them first…" ForegroundColor Red
} else {
if($nssmExists){
$servicePath = Split-Path $nssmExists
try{
Get-Process nssm ErrorAction SilentlyContinue | Stop-Process Force ErrorAction SilentlyContinue
Remove-Item $servicePath Recurse Force
if((Split-Path ($servicePath) Parent).EndsWith("nssm")){
Remove-Item (Split-Path ($servicePath) Parent) Recurse Force
}
If ((Read-Host 'Do you want to update system path as well (y/n) ') -eq 'Y') {
$OldPath = (Get-ItemProperty Path 'Registry::HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\Environment' Name PATH).path
Write-Host "Old Path is: `n$OldPath"
$NewPath = ($OldPath -split ";" | where-object{$_ -ne "$servicePath" -AND $_ -ne ""}) -join ";"
Set-ItemProperty Path 'Registry::HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\Environment' Name PATH Value "$NewPath"
Write-Host "Updated new Path is: `n$NewPath"
}
Write-host "$package has been removed from the system …" ForegroundColor GREEN
} catch {
Write-Host "Unable to stop nssm process.. can't remove nssm."
}
}
}
}
# Remove Grafana from system
if($package -match "Grafana"){
if(Get-Service grafanaserver ErrorAction SilentlyContinue){
# Encoding of nssm output causes issue, so forcing to unicode temporarily
$originalEncoding = [Console]::OutputEncoding
[Console]::OutputEncoding = [System.Text.Encoding]::Unicode
$GrafanaInstallPath =(nssm get grafanaserver AppDirectory) # This gives error msg due to NT Service in config, can be ignored
[Console]::OutputEncoding = $originalEncoding
Stop-Service grafanaserver ErrorAction SilentlyContinue
Get-Process grafanaserver ErrorAction SilentlyContinue | Stop-Process Force ErrorAction SilentlyContinue
Wait-Process Name grafanaserver ErrorAction SilentlyContinue
nssm remove grafanaserver confirm
$GrafanaInstallPath = Split-Path ($GrafanaInstallPath) Parent
If ((Read-Host "Do you want to delete $GrafanaInstallPath as well (y/n) ") -ieq 'Y') {
Remove-Item $GrafanaInstallPath Recurse Force
Write-Host "$GrafanaInstallPath deleted." ForegroundColor Yellow
}
} else {
Write-Host "Count not find $package service in system … " ForegroundColor Green
}
}
# Remove Prometheus from the system
if($package -match "Prometheus"){
if(Get-Service prometheusservice ErrorAction SilentlyContinue){
# Encoding of nssm output causes issue, so forcing to unicode temporarily
$originalEncoding = [Console]::OutputEncoding
[Console]::OutputEncoding = [System.Text.Encoding]::Unicode
$prometheusInstallPath =(nssm get prometheusservice AppDirectory) # This gives error msg due to NT Service in config, can be ignored
[Console]::OutputEncoding = $originalEncoding
Stop-Service prometheusservice ErrorAction SilentlyContinue
Get-Process prometheusservice ErrorAction SilentlyContinue | Stop-Process Force ErrorAction SilentlyContinue
Wait-Process Name prometheusservice ErrorAction SilentlyContinue
nssm remove prometheusservice confirm
If ((Read-Host "Do you want to delete $prometheusInstallPath as well (y/n) ") -ieq 'Y') {
Remove-Item $prometheusInstallPath Recurse Force
Write-Host "$prometheusInstallPath deleted." ForegroundColor Yellow
}
} else {
Write-Host "Count not find $package service in system … " ForegroundColor Green
}
}
# Remove Windows Exporter from the system
if($package -match "Windows_Exporter"){
if(Get-Service Windows_exporter ErrorAction SilentlyContinue){
$WinExporterInstallPath = split-path ((Get-CimInstance Win32_Service | Where-Object {$_.Name -eq "Windows_exporter"}).PathName -split "")[0]
Stop-Service Windows_exporter ErrorAction SilentlyContinue
Get-Process windows_exporter* ErrorAction SilentlyContinue | Stop-Process Force ErrorAction SilentlyContinue
Wait-Process windows_exporter* ErrorAction SilentlyContinue
Remove-Service Windows_exporter ErrorAction SilentlyContinue
If ((Read-Host "Do you want to delete $WinExporterInstallPath as well (y/n) ") -ieq 'Y') {
Remove-Item $WinExporterInstallPath Recurse Force
Write-Host "$WinExporterInstallPath deleted." ForegroundColor Yellow
}
Write-host "$package has been removed from the system …" ForegroundColor GREEN
} else {
Write-Host "Count not find $package service in system … " ForegroundColor Green
}
}
}
}
#Write-Host "Download all the latest executables …." -ForegroundColor GREEN
#Get-Executables nssm
# Sample code if you want to download the packages on remote machine
#$credential = Get-Credential
#Invoke-Command -ComputerName $env:COMPUTERNAME -ScriptBlock ${function:get-executables} -Credential $credential -ArgumentList @("nssm","prometheus"), "$env:userprofile\"
# Sample code if you want to install the packages on remote machine
#$param = @{
# packages = @("nssm", "prometheus")
# servicePath = "c:\down\"
# Override = $true
# executableDownloadPath = "$env:userprofile\Executables"
#}
#$ScriptBlock = [scriptblock]::Create("${function:New-Services}")
#Invoke-Command -ComputerName $env:COMPUTERNAME -ScriptBlock $ScriptBlock -Credential $credential -ArgumentList ($param.packages, $param.servicePath, $param.Override,$param.executableDownloadPath)
# Sample code if you want to install the packages on local machine
#Write-Host "Setting up services …." -ForegroundColor GREEN
#New-Services
# Sample code if you want to download the packages on remote machine
#$credential = Get-Credential
#Invoke-Command -ComputerName $env:COMPUTERNAME -ScriptBlock ${function:get-executables} -Credential $credential -ArgumentList @("nssm","prometheus"), "$env:userprofile\"
# Sample code if you want to remove the packages from remote machine
#$param = @{
# packages = @("nssm", "prometheus")
#}
#$ScriptBlock = [scriptblock]::Create("${function:Remove-Services}")
#Invoke-Command -ComputerName $env:COMPUTERNAME -ScriptBlock $ScriptBlock -Credential $credential -ArgumentList ($param.packages)
# Sample code if you want to remove the service(s) from local machine
#Remove-Services -packages nssm, Prometheus
# Update Prometheus config to scrape current host metrics | Can be done for other hosts using similar syntax
#$HostAddress = (Test-Connection -ComputerName $env:ComputerName -IPv4 -Count 1).Address.IPAddressToString
#Set-PrometheusConfig -jobName "Windows_exporter" -scrape_interval "5s" -targetAddress $HostAddress -targetPort 9182

Advertisement

One thought on “One stop PowerShell script to setup Prometheus, Grafana and Windows Exporter on Windows Machine

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.