Klaus Oberdalhoff - Kategorie: "Powershell" https://www.insidesql.org/blogs/klausobd/ InsideSQL.org Blogs - Blogs über SQL Server de-DE http://blogs.law.harvard.edu/tech/rss 60 Powershell Info zu SQL Server Updates https://www.insidesql.org/blogs/klausobd/2019/08/21/powershell-info-zu-sql-server Wed, 21 Aug 2019 00:43:00 +0000 klausobd SQLServer Powershell 4092@https://www.insidesql.org/blogs/ <p> </p> <p>Hi,</p> <p>bzgl. der verfügbaren Updates im SQL-Server gibt es ein Powershell-Modul, das einem das Leben vereinfacht:</p> <p>SQLServerUpdatesModule - wie immer zu haben in der <a href="https://www.powershellgallery.com/" target="_blank" rel="noopener">MS Gallery</a>.</p> <p>Der Aufruf von:</p> <p>Invoke-SqlServerUpdatesScan  Servername</p> <p>Invoke-SqlServerUpdatesScan ASTERIX    (oder ASTERIX\SQLExpress)</p> <p>bringt als Ergebnis:</p> <p>Name : ASTERIX<br />Product : Microsoft SQL Server<br />VersionName : SQL Server 2017<br />Edition : Developer Edition (64-bit)<br />ProductLevel : RTM<br />Build : 14.0.3223.3<br />LatestUpdate : <br />LatestUpdateLink : <br />Updates : 14.0.3223.3<br />ToUpdate : False      &lt;----</p> <p>Dies könnte man in eine Prozedur beim Starten einbauen ....</p> <p>---------------------------------------------------------------</p> <div class="tlid-input input"> <div class="source-wrap"> <div class="input-full-height-wrapper tlid-input-full-height-wrapper"> <div class="source-input"> <div class="source-footer-wrap source-or-target-footer"> <div class="character-count tlid-character-count"> </div> </div> </div> </div> </div> </div> <div class="tlid-results-container results-container"> <div class="tlid-result result-dict-wrapper"> <div class="result tlid-copy-target"> <div class="result-header"> <div class="starbutton jfk-button-flat jfk-button unstarred" tabindex="0" role="button" aria-label="Übersetzung markieren" data-tooltip="Übersetzung markieren" data-tooltip-align="t,c"> <div class="jfk-button-img">Regarding the available updates in the SQL server, there is a Powershell module that makes life easier:</div> </div> </div> <div class="text-wrap tlid-copy-target"> <div class="result-shield-container tlid-copy-target" tabindex="0"><span class="tlid-translation translation" lang="en"><br /><span title="">SQLServerUpdatesModule - as always in the <a href="https://www.powershellgallery.com/" target="_blank" rel="noopener">MS Gallery</a>.</span><br /><br /><span title="">The call of:</span><br /><br /><span title="">Invoke-SqlServerUpdatesScan server name</span><br /><br /><span class="" title="">Invoke-SqlServerUpdatesScan ASTERIX (or ASTERIX \ SQLExpress)</span><br /><br /><span title="">brings as result:</span></span></div> <div class="result-shield-container tlid-copy-target" tabindex="0"> </div> <div class="result-shield-container tlid-copy-target" tabindex="0"><span class="tlid-translation translation" lang="en"><span title="">Name : ASTERIX<br />Product : Microsoft SQL Server<br />VersionName : SQL Server 2017<br />Edition : Developer Edition (64-bit)<br />ProductLevel : RTM<br />Build : 14.0.3223.3<br />LatestUpdate : <br />LatestUpdateLink : <br />Updates : 14.0.3223.3<br />ToUpdate : False      &lt;----</span></span></div> <div class="result-shield-container tlid-copy-target" tabindex="0"> </div> <div class="result-shield-container tlid-copy-target" tabindex="0"><span class="tlid-translation translation" lang="en"><span title="">This could be incorporated into a procedure at startup ....</span></span></div> <div class="result-shield-container tlid-copy-target" tabindex="0"> </div> <div class="result-shield-container tlid-copy-target" tabindex="0"><span class="tlid-translation translation" lang="en"><span title="">mfg Klaus</span></span></div> </div> </div> </div> </div>  

Hi,

bzgl. der verfügbaren Updates im SQL-Server gibt es ein Powershell-Modul, das einem das Leben vereinfacht:

SQLServerUpdatesModule - wie immer zu haben in der MS Gallery.

Der Aufruf von:

Invoke-SqlServerUpdatesScan  Servername

Invoke-SqlServerUpdatesScan ASTERIX    (oder ASTERIX\SQLExpress)

bringt als Ergebnis:

Name : ASTERIX
Product : Microsoft SQL Server
VersionName : SQL Server 2017
Edition : Developer Edition (64-bit)
ProductLevel : RTM
Build : 14.0.3223.3
LatestUpdate :
LatestUpdateLink :
Updates : 14.0.3223.3
ToUpdate : False      <----

Dies könnte man in eine Prozedur beim Starten einbauen ....

---------------------------------------------------------------

 
Regarding the available updates in the SQL server, there is a Powershell module that makes life easier:

SQLServerUpdatesModule - as always in the MS Gallery.

The call of:

Invoke-SqlServerUpdatesScan server name

Invoke-SqlServerUpdatesScan ASTERIX (or ASTERIX \ SQLExpress)

brings as result:
 
Name : ASTERIX
Product : Microsoft SQL Server
VersionName : SQL Server 2017
Edition : Developer Edition (64-bit)
ProductLevel : RTM
Build : 14.0.3223.3
LatestUpdate :
LatestUpdateLink :
Updates : 14.0.3223.3
ToUpdate : False      <----
 
This could be incorporated into a procedure at startup ....
 
mfg Klaus
]]> https://www.insidesql.org/blogs/klausobd/2019/08/21/powershell-info-zu-sql-server#comments https://www.insidesql.org/blogs/klausobd/?tempskin=_rss2&disp=comments&p=4092