<div>$awsroot = "http://redgate-download.s3.eu-west-1.amazonaws.com/"</div><div>$awsquery = "?delimiter=/&prefix=checkforupdates/SQLMonitorWeb/"</div><br><div>$xml = new-object System.Xml.XmlDocument</div><div>$xml.load($awsroot + $awsquery)</div><br><div>$sortedcontents = $xml.ListBucketResult.Contents | where-object {$_.key -notlike "*.sha256"} | sort-object -Property LastModified -Descending</div><br><div>write-host $sortedcontents[0].Key</div><br><div>$url = $awsroot + $sortedcontents[0].Key</div><br><div>$filename = $sortedcontents[0].Key.Substring($sortedcontents[0].key.lastindexof("/") + 1)</div><br><div>Invoke-WebRequest -UseBasicParsing -Uri $url -Method GET -OutFile "C:\Temp\$filename<span>"</span></div>
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal
AndrewL
Posts: 6 Bronze 1
Answers
This documentation page https://documentation.red-gate.com/sm/installation-and-setup/automated-installation-and-updates has information on automating the install of SQL Monitor using the msi files and there are some examples at the bottom of the page using PowerShell for the different components.
The installers can be downloaded from https://download.red-gate.com/checkforupdates/SQLMonitorWeb/ and then you would just need to do the extraction described near the top of the documentation page and then run msi as shown in the examples.
Hope that helps!
Kind regards,
Alex
Have you visited our Help Center?
After messing around a bit with PowerShell, one of our developers came up with this script that will download the latest installer:
<div>$awsroot = "http://redgate-download.s3.eu-west-1.amazonaws.com/"</div><div>$awsquery = "?delimiter=/&prefix=checkforupdates/SQLMonitorWeb/"</div><br><div>$xml = new-object System.Xml.XmlDocument</div><div>$xml.load($awsroot + $awsquery)</div><br><div>$sortedcontents = $xml.ListBucketResult.Contents | where-object {$_.key -notlike "*.sha256"} | sort-object -Property LastModified -Descending</div><br><div>write-host $sortedcontents[0].Key</div><br><div>$url = $awsroot + $sortedcontents[0].Key</div><br><div>$filename = $sortedcontents[0].Key.Substring($sortedcontents[0].key.lastindexof("/") + 1)</div><br><div>Invoke-WebRequest -UseBasicParsing -Uri $url -Method GET -OutFile "C:\Temp\$filename<span>"</span></div>Was wondering if we can then just execute the downloaded file so there are no prompts?
Regards
Andrew
You would need to first extract the msi's and then if you specify the various details in the command line install I think it will run with no prompts. See https://documentation.red-gate.com/sm/installation-and-setup/automated-installation-and-updates for more information on automating the install.
Kind regards,
Alex
Have you visited our Help Center?