Automatics Updates

• 
  Hi AndrewL
  
  What part of this is causing issue? Please note though you will still have to download the latest installer each time.

  ATurner August 25, 2022 16:39

  - 0 +
• 
  Let me share what I have no far. This will download the latest version and extract it:
  
  

  <div>$awsroot = "http://redgate-download.s3.eu-west-1.amazonaws.com/"</div><div>$awsquery = "?delimiter=/&prefix=checkforupdates/SQLMonitorWeb/"</div><div><br></div><div>$xml = new-object System.Xml.XmlDocument</div><div>$xml.load($awsroot + $awsquery)</div><div><br></div><div>$sortedcontents = $xml.ListBucketResult.Contents | where-object {$_.key -notlike "*.sha256"} | sort-object -Property LastModified -Descending</div><div><br></div><div>write-host $sortedcontents[0].Key</div><div><br></div><div>$url = $awsroot + $sortedcontents[0].Key</div><div><br></div><div>$filename = $sortedcontents[0].Key.Substring($sortedcontents[0].key.lastindexof("/") + 1)</div><div><br></div><div>Invoke-WebRequest -UseBasicParsing -Uri $url -Method GET -OutFile "C:\Temp\$filename"</div><div><br></div><div>cd \Temp</div><div><br></div><div>& C:\Temp\$filename /IAgreeToTheEULA extract web.msi</div>

  
  

  I tried curl but couldn't get it to work. Also PowerShells Invoke-WebRequest isn't the quickest either.

  AndrewL August 26, 2022 08:18

  - 0 +
• 
  Hi AndrewL
  
  Could you try using "https://download.red-gate.com/checkforupdates/SQLMonitor.exe" as your download location?

  ATurner September 06, 2022 12:48

  - 0 +

Add comment

Please sign in to leave a comment.