MSDynamics.de

Code:

Set-ExecutionPolicy –ExecutionPolicy RemoteSigned

• NAV 2015 CU1 und später: Aus dem CU-Paket die frühere Hotfix-Ordnerstruktur wiederherstellen
• Create ISO of Cumulative Update with PowerShell – Overview
  
  • Unzip
  • Create the ISO
• Apply a Cumulative Update with Powershell

• Creating an Azure VM with NAV 2015 using PowerShell
• Easy Deployment of the Latest Version of Microsoft Dynamics NAV 2015

• Start Dynamics NAV Windows Client (RTC) from PowerShell
• Tip: Development client paths in PowerShell

• Using Windows Powershell cmdlets to modify companies and databases

• Export NAV Application Objects fob, txt, Deltas ...
• Apply-NAVDelta to add and remove customizations
• Start NAV Object in RTC with PowerShell
• Summarizing object ID ranges in PowerShell

• Einführung: ServerInstance Administration with PowerShell
• HOW TO set NAV Service Startup Type via PowerShell
• Port Sharing with NAV with PowerShell
• Dynamics NAV PowerShell: Creating an enhanced Get-NAVServerInstance function

• Get Session Count over multiple NST’s, fertige Funktion Get-NAVServerSessions
• Creating users with Powershell
• import your Office 365 users

• Invoke-NAVSQL: Execute SQL queries on NAV databases with PowerShell

• Coffee Break 1: Add AD users to NAV.
• Coffee Break 2: Automate a Microsoft Dynamics NAV deployment
• Coffee Break 3: PowerShell Remoting with Microsoft Dynamics NAV
• Coffee Break 4: Piping in Windows PowerShell
• Coffee Break 5 - Searching through a Dynamics NAV text file
• Coffee Break 6 - Return to piping
• Coffee Break 7 - Creating and using Windows PowerShell profiles
• Coffee Break 8 - Windows PowerShell Remoting (On-Premises)
• Coffee Break 9 - Provisioning (Creating Hyper-V disks)
• Coffee Break 10 – Provisioning (Creating a Virtual Machine (VM) in Azure)
• Coffee Break 11 – Provisioning - Using Microsoft Azure storage to keep VHDs and other useful stuff in the cloud
• Coffee Break 12 - Provisioning - Automatic installation and deployment of Microsoft Dynamics NAV
• Coffee Break 13 - Checking file properties and copying files with Windows PowerShell
• Coffee Break 14 - Using Windows PowerShell to check and search the Application Log
• Coffee Break 15 - Using Windows PowerShell to enable WCF message logging and tracing on Dynamics NAV Server
• Coffee Break 16 – Using Windows PowerShell to Mark and Compare Fingerprints and Diff-Checks
  
  
• Coffee Break – Monitoring and troubleshooting NAV Services
• Coffee Break – Monitoring and Troubleshooting Services Part 2
• Coffee Break: Monitoring and troubleshooting NAV Services, Part III – Performance troubleshooting and profiling User Activity using PowerShell
• Coffee Break Troubleshooting Part IV: Windows Error Reporting and Collecting Crash Dumps
• Coffee Break: Proactive Monitoring with Task Scheduler
  
  
• Coffee Break: Make your (Windows PowerShell) life easier
  In this post we will show a couple of examples of creating functions and store them in your profile to reduce the amount of re-typing needed in order to make your life easier.
• Coffee Break: Use the PowerShell Runner Add-In
• Coffee Break: Automate it! - how to use PowerShell to collect some basic diagnostic details
• Coffee Break: Automate it, part 2
  
  
• Coffee Break – Creating CNAME records with Windows PowerShell

• Export-NAVApplicationObjectFile mit Serverwahl
• Sortiertes Objektpaket zusammenstellen
• Objektpaket aus Datenbank exportieren
• Compilerfunktionen
• Compilerstapellauf
• Objektimportfunktionen
• Objektstapelimporte
• Mergen von Versionslisten (ohne Objektdatum )
• Mergen von Versionslisten (mit Objektdatum)
• Mergen von Versionlisten (2 AddOns) und Objektdatum
• Skripte aus NAV erzeugen und ausführen
• Aus Fob-Datei Objektindex erzeugen
• Fob-Viewer mit Filter-und Sortiermöglichkeit
• Inhalte der Mergeordner abstimmen
• Quellcodekommentierung vor Release bereinigen
• Versionsliste pflegen
• Objektdatum anhand des Versionsstands setzen
• Lokales Datumsformat im Objektpaket einsetzen
• Objekte für Testtoolkit auf 'Geändert' setzen
• C/AL in AL für Extensions überführen
• C/AL-Objekte in AL umwandeln
• NAV 2018 Reports (u.a. Objekte) downgraden
• Tooltips entfernen (Pages/Reports downgraden)
• C/AL-Objektsplitter (auch für Forms/Dataports)
• Dokumentations-Trigger pflegen
• C/AL-Objektpaketkonfigurator
• Generate Symbol Reference für AL (mit GUI)
• AL-Objektsplitter

• Einsatz der NAVApplicationObjectLanguage-Cmdlets
• Captionvergleich von Sprachvarietäten
• Datei zeilenweise alternierend aufteilen
• XLF-Datei erstellen (XLIFF)
• Aus NAV-Translationsdatei eine XLIFF erzeugen
• Aus XLIFF eine NAV-Translationsdatei erzeugen
• Translations-Datei via Translator Hub übersetzen
• XLIFF (.xlf) Trans-Unit-IDs abgleichen

• Datenbanknamen als Dateinamen auslesen
• DB-Backup aus Install-DVD herauskopieren
• Aus Install-DVD-Backup neue Datenbank anlegen

• Textdateikonverter (für OEM 850 und andere Codepages bzw. Unicode/UTF-8/UTF-16)
• PowerShell: UTF-16 Little-Endian ohne BOM erzeugen

• Remote Sessions (Mandant anlegen ab NAV 2013 R2)
• Entpacken
• KB-Artikel im Standardbrowser aufrufen
• Liste aller COM-Objekte in GridView ausgeben
• Serversystemfehlerprotokoll auslesen

• Windows PowerShell Tips
• Windows PowerShell Tutorial
• MSDN: Windows PowerShell
• Microsoft Script Center
• The power of variables
• Automatic Variables
• Pipelines, functions, parameters
• IF…ELSE mit Operatorenliste
• 10 reasons for using PowerShell ISE instead of the PowerShell console
• Hey, scripting guy! (Blog von Ed Wilson)
• Stringfunktionen
• Using SQL Server Management Objects with PowerShell (Archivlink)
• What I Hate About PowerShell
• Playlist mit Schulungsvideos von Peter Kriegel (auf Deutsch)
• Powershell GUI Programmierung für Dummies Step-by-Step
• How To Create a WPF GUI for your Powershell Script in 10 lines of code

• Parameter -Force nutzen (wenn vorhanden)
• Wenn Parameter -Force nicht vorhanden, arbeitet mit –Confirm:$false

Code:

Get-ChildItem “.\single” -recurse | Select-String -pattern “Posting Date” | group path | select name, count

Code:

grep -c "Posting Date" ./single/*.txt|grep -v ":0$"

fiddi hat geschrieben:Hallo,
ein weiterer interessanter Powershell- Link ist dieser hier
How to get back the 'hotfix directories' from NAV 2015 Cumulative Update 1

Code:

 # Language Specific Folders
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\RTC\de-DE
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\RTC\DEU
 
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\NST\Add-ins
 # Language Specific Folder
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\NST\de-DE

Code:

 # Language Specific Files for DE
 # RTC
 # Path Example C:\CU 25 NAV 2016 DE\NAV.9.0.49424.DE.DVD\Installers\DE\RTC\PFiles\Microsoft Dynamics NAV\90\RoleTailored Client
 Copy-Item $DvdDirectory\"Installers\DE\RTC\PFiles\Microsoft Dynamics NAV\"$NavVersion"\RoleTailored Client\de-DE"\* -destination $BatchDirectory\_Temp\RTC\de-DE -recurse -Force
 Copy-Item $DvdDirectory\"Installers\DE\RTC\PFiles\Microsoft Dynamics NAV\"$NavVersion"\RoleTailored Client\DEU"\* -destination $BatchDirectory\_Temp\RTC\DEU -recurse -Force
 # NST
 # Path Example C:\CU 25 NAV 2016 DE\NAV.9.0.49424.DE.DVD\Installers\DE\Server\PFiles\Microsoft Dynamics NAV\90\Service\de-DE
 Copy-Item $DvdDirectory\"Installers\DE\Server\PFiles\Microsoft Dynamics NAV\"$NavVersion"\Service\de-DE"\* -destination $BatchDirectory\_Temp\NST\de-DE -recurse -Force

Code:

# Keep these !
 #RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\_Temp\RTC\ 'ENU')
 #RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\_Temp\RTC\ 'en-US')
 

Code:

<#
 .SYNOPSIS
 This cmdlet copies all the DVD files to create a batch ready set of files.
 .DESCRIPTION
 This cmdlet copies all the DVD files to create a batch ready set of files..
 It skips files that are not needed in installation scenarios such as .config files.
 .PARAMETER DvdDirectory
 Specifies the directory where the uncompressed Cumulative Update DVD subdirectory is located.
 .PARAMETER BatchDirectory
 Specifies the directory that should hold the result set of files, i.e., the directory to copy to.
#>
function Copy-UpdateFilesToBatchDirectoryAllVersions
{
 [CmdletBinding()]
 param (
 [parameter(Mandatory=$true)]
 [string] $DvdDirectory,

 [parameter(Mandatory=$true)]
 [string] $BatchDirectory
 )
 PROCESS
 {
 # Copy all the Dvd files to a _TEMP folder
 if (Test-Path -Path $DvdDirectory\"RoleTailoredClient\program files\Microsoft Dynamics NAV\70")
 {
 $NavVersion = "70"
 }
  if (Test-Path -Path $DvdDirectory\"RoleTailoredClient\program files\Microsoft Dynamics NAV\71")
 {
 $NavVersion = "71"
 }
 if (Test-Path -Path $DvdDirectory\"RoleTailoredClient\program files\Microsoft Dynamics NAV\80")
 {
 $NavVersion = "80"
 }
 elseif (Test-Path -Path $DvdDirectory\"RoleTailoredClient\program files\Microsoft Dynamics NAV\90")
 {
 $NavVersion = "90"
 }
 elseif (Test-Path -Path $DvdDirectory\"RoleTailoredClient\program files\Microsoft Dynamics NAV\100")
 {
 $NavVersion = "100"
 }
 elseif (Test-Path -Path $DvdDirectory\"RoleTailoredClient\program files\Microsoft Dynamics NAV\110")
 {
 $NavVersion = "110"
 }
 else
 {
 Write-Host Please check your DvdDirectory parameter
 return
 }

 Write-Verbose "Copying files from $DvdDirectory to $BatchDirectory\_Temp\..."
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\RTC\Add-ins
 # Language Specific Folders
 if (-not $NavVersion -eq "110")
 {
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\RTC\de-DE
 }
 
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\RTC\DEU
 
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\NST\Add-ins
 # Language Specific Folder
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\NST\de-DE
 if (-not $NavVersion -eq "110")
 {
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\BPA
 }
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\"WEB CLIENT"
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\OUTLOOK
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\ADCS
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\HelpServer
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\UpgradeToolKit
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\WindowsPowerShellScripts
 if (($NavVersion -eq "90") -or ($NavVersion -eq "100") -or ($NavVersion -eq "110"))
 {
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\CrmCustomization
 New-Item -ItemType Directory -Force -Path $BatchDirectory\_Temp\TestToolKit
 }

 Copy-Item $DvdDirectory\"RoleTailoredClient\program files\Microsoft Dynamics NAV\"$NavVersion"\RoleTailored Client"\* -destination $BatchDirectory\_Temp\RTC -recurse -Force
 Copy-Item $DvdDirectory\"ServiceTier\program files\Microsoft Dynamics NAV\"$NavVersion"\Service"\* -destination $BatchDirectory\_Temp\NST -recurse -Force
 if (-not $NavVersion -eq "110")
 {
 Copy-Item $DvdDirectory\BPA\* -destination $BatchDirectory\_Temp\BPA -recurse -Force
 }
 Copy-Item $DvdDirectory\"WebClient\Microsoft Dynamics NAV\"$NavVersion"\Web Client"\* -destination $BatchDirectory\_Temp\"WEB CLIENT" -recurse -Force
 Copy-Item $DvdDirectory\"Outlook\program files\Microsoft Dynamics NAV\"$NavVersion"\OutlookAddin"\* -destination $BatchDirectory\_Temp\OUTLOOK -recurse -Force
 Copy-Item $DvdDirectory\"ADCS\program files\Microsoft Dynamics NAV\"$NavVersion"\Automated Data Capture System"\* -destination $BatchDirectory\_Temp\ADCS -recurse -Force
 Copy-Item $DvdDirectory\"HelpServer\DynamicsNAV"$NavVersion"Help"\* -destination $BatchDirectory\_Temp\HelpServer -recurse -Force
 Copy-Item $DvdDirectory\"UpgradeToolKit"\* -destination $BatchDirectory\_Temp\UpgradeToolKit -recurse -Force
 Copy-Item $DvdDirectory\"WindowsPowerShellScripts"\* -destination $BatchDirectory\_Temp\WindowsPowerShellScripts -recurse -Force
 if (($NavVersion -eq "90") -or ($NavVersion -eq "100") -or ($NavVersion -eq "110"))
 {
 Copy-Item $DvdDirectory\"CrmCustomization"\* -destination $BatchDirectory\_Temp\CrmCustomization -recurse -Force
 Copy-Item $DvdDirectory\"TestToolKit"\* -destination $BatchDirectory\_Temp\TestToolKit -recurse -Force
 }
 # Language Specific Files for DE
 # RTC
 # Path Example C:\CU 25 NAV 2016 DE\NAV.9.0.49424.DE.DVD\Installers\DE\RTC\PFiles\Microsoft Dynamics NAV\90\RoleTailored Client
 if (-not $NavVersion -eq "110")
 {
 Copy-Item $DvdDirectory\"Installers\DE\RTC\PFiles\Microsoft Dynamics NAV\"$NavVersion"\RoleTailored Client\de-DE"\* -destination $BatchDirectory\_Temp\RTC\de-DE -recurse -Force
 }
 Copy-Item $DvdDirectory\"Installers\DE\RTC\PFiles\Microsoft Dynamics NAV\"$NavVersion"\RoleTailored Client\DEU"\* -destination $BatchDirectory\_Temp\RTC\DEU -recurse -Force
 # NST
 # Path Example C:\CU 25 NAV 2016 DE\NAV.9.0.49424.DE.DVD\Installers\DE\Server\PFiles\Microsoft Dynamics NAV\90\Service\de-DE
 if (-not $NavVersion -eq "110")
 {
 Copy-Item $DvdDirectory\"Installers\DE\Server\PFiles\Microsoft Dynamics NAV\"$NavVersion"\Service\de-DE"\* -destination $BatchDirectory\_Temp\NST\de-DE -recurse -Force
 }
 
 
 Write-Verbose "Done copying files RTC files from $DvdDirectory to $BatchDirectory\_Temp."
 
 # Delete files that are not needed for an installation scenario
 Write-Verbose "Deleting files from $BatchDirectory that are not needed for the batch directory..."


 Get-ChildItem $BatchDirectory\_Temp -include '*.chm' -Recurse | Remove-Item -force -ErrorAction SilentlyContinue
 Get-ChildItem $BatchDirectory\_Temp -include '*.hh' -Recurse | Remove-Item -force -ErrorAction SilentlyContinue
 Get-ChildItem $BatchDirectory\_Temp -include '*.config' -Recurse | Remove-Item -force -ErrorAction SilentlyContinue
 Get-ChildItem $BatchDirectory\_Temp -include '*.ico' -Recurse | Remove-Item -force -ErrorAction SilentlyContinue
 Get-ChildItem $BatchDirectory\_Temp -include '*.flf' -Recurse | Remove-Item -force -ErrorAction SilentlyContinue
 Get-ChildItem $BatchDirectory\_Temp -include '*.sln' -Recurse | Remove-Item -force -ErrorAction SilentlyContinue
 # Keep these !
 #RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\_Temp\RTC\ 'ENU')
 #RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\_Temp\RTC\ 'en-US')
 RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\_Temp\RTC\ 'Images')
 RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\_Temp\RTC\ 'SLT')
 RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\_Temp\RTC\ 'ReportLayout')
 if (-not $NavVersion -eq "110")
 {
 RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\_Temp\BPA\ 'Scripts')
 }
 RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\_Temp\HelpServer\ 'css')
 RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\_Temp\HelpServer\ 'help')
 RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\_Temp\HelpServer\ 'images')
 RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\_Temp\WindowsPowerShellScripts\ 'ApplicationMergeUtilities')
 Write-Verbose "Done deleting files from $BatchDirectory that are not needed for for the batch directory."

 # Copy the result to the requested directory and remove the _Temp folder
 Copy-Item $BatchDirectory\_Temp\* -destination $BatchDirectory\ -recurse -Force
 RemoveUnnecessaryDirectory (Join-Path $BatchDirectory\ '_Temp')
 }
}

function RemoveUnnecessaryDirectory
{
 param ([string]$directory)
 Remove-Item $directory -force -Recurse -ErrorAction SilentlyContinue
}


Code:

Add-Type -AssemblyName System.Speech
$synthesizer = New-Object -TypeName System.Speech.Synthesis.SpeechSynthesizer
$synthesizer.Speak("Hallo, hier ist ihr HAL 9000 Computer. Was kann ich für Sie tun?")