Monitorpack provides an .exe file which must be executed recurrently by the Windows Task Scheduler, below are the steps allowing setting up this synchronization.

This task synchronizes the file generated by Monitorpack Discovery in the SQL databases, which then allows you to display its information either in a local Power BI report Server or in Azure Power BI depending on your SQL architecture configuration.

• Download the latest version of the file named "MonitorpackSyncDevices.zip" Create the folder "C:\ScriptsMonitorpack" then unzip the file so that the MonitorpackSyncDevices.exe executable is present in this folder.



• Check powershell local execution policy


Copy
Get-ExecutionPolicy


• Update the runlevel to be RemoteSigned if necessary


Copy
Set-ExecutionPolicy RemoteSigned


• Check that the PowerShell SQL module is implemented on the local machine where the task will be executed.


Copy
Install-Module -Name SqlServer -Force


• Create the following scheduled task by opening a cmd window in administrator mode, then execute the following command


Copy
schtasks /create /tn "Monitorpack Discovery Sync" /tr "\"C:\ScriptsMonitorpack\MonitorpackSyncDevices.exe"" /sc hourly /mo 1


• In the folder "C:\Program Files (x86)\Monitorpack Guard" check that all files ContractID.txt, LocalInstance.txt, LocalDBName.txt, LocalLoginUser.txt, LocalPassword.txt are not empty so SQL fields are correctly populated in the Discovery SQL server interface, otherwise script will pop up an error message.

Download the file named MonitorpackSyncDevices.zip