03.02.2018, 01:15 | #1 |
Участник
|
yetanotherdynamicsaxblog: PowerShell script to toggle Maintenance mode
Источник: http://yetanotherdynamicsaxblog.blog...intenance.html
============== In order to change licence configurations on Operations, you need to toggle maintenance mode on or off. This can be done using a Setup tool, but on the development machines where we do not have local admin rights, the only solution would be to hack the database, like Kurt Hatlevik shows us in this blog post. In this post I will show how you can toggle maintenance mode on or off using PowerShell. The script is intended for OneBox environments. Just paste it into a new ps1 file for future use, or run it through PowerShell ISE. DISCLAIMER: Don't run this unless you are prepared to take the heat from restarting the entire web application. It stops and starts the web server. function ToggleMaintenanceMode() { $parm = @{ ServerInstance = 'localhost' Database = 'AxDB' Query = "UPDATE SQLSYSTEMVARIABLES SET [VALUE] = IIF([VALUE]=1, 0, 1) WHERE PARM = 'CONFIGURATIONMODE'" } Get-Service "W3SVC" | Stop-Service -Force Invoke-Sqlcmd @parm Get-Service "W3SVC" | Start-Service $parm.Query = "SELECT [VALUE] FROM SQLSYSTEMVARIABLES WHERE PARM = 'CONFIGURATIONMODE'" $result = Invoke-Sqlcmd @parm [int]$value = $result.Value Write-Output "Configuration mode $(('disabled','enabled')[$value])" } ToggleMaintenanceMode The script shows you how you can easily run SQL commands, and even retrieve values back to your PowerShell script. Enjoy! Источник: http://yetanotherdynamicsaxblog.blog...intenance.html
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору. |
|
|
|