[Script Of Mar. 30] How to convert Excel xlsx file to csv file in batch by PowerShell

Mar 30 Script Download: The script is available for download from https://gallery.technet.microsoft.com/How-to-convert-Excel-xlsx-d9521619. The sample code demonstrates how to convert Excel xlsx file to csv file in batch by PowerShell. You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery


Word-Makro infiziert sowohl Windows als auch macOS

Die amerikanische Security-Firma Fortinet beschreibt in ihrem Blog einen neuen VBA-Makrovirus, der sowohl Windows-, als auch Macintosh-Rechner infiziert. Er wird übertragen durch eine Word-Datei im DOC-Format. Sobald der Anwender das File öffnet, erscheint zwar zunächst eine Sicherheitswarnung – eingebettete Makros sind in der Voreinstellung von Word deaktiviert. Doch wenn Anwender diese Warnung ignorieren und die…


Practical PowerShell Security: Enable Auditing and Logging with DSC

PowerShell Security Almost two years ago Lee Holmes released his famous PowerShell ♥ the Blue Team whitepaper. This is required reading for anyone who works with PowerShell at all in their job or who is concerned about the security of PowerShell in their environment. I outlined a number of PowerShell security-related resources in this previous…

1

Generate Random Content for SharePoint – 4

This is the last chapter of the Generate Random Content For SharePoint series. This time, detailing the challenges you might face when you want to create PowerPoint presentations. Chapters: Generate random content for SharePoint – About how to create big files for upload testing. Generate random content for SharePoint 2 – About how to generate Word…


A License to Bill

Do you have enough Office 365 licenses? Are you sure? Are they expiring? Is billing getting everything approved to have the licenses renewed? These are not always easy questions. Many admins don’t go to the portal often and check this. I wanted to have a simple check that I could run against any tenant and…


Simple Surface Hub Account Configuration

I was looking through the documentation for setting up an account for a Surface Hub. It’s a wonderful set of documentation, but it’s also very long! Most of this was just more detailed than I needed, but I wanted a very simple, easy-to-follow script for building this in Office 365. I don’t like to do…


Fun & Frolics: Generate a 0 and 1 Screen Stream

What a ridiculous title! Believe me, the post gets even more ridiculous. Anyway, it’s a bit of fun!   I had to do the following for a conference I recently spoke at…   function ExfiltrateData { Write-Output ” ” 1..900 | % {Write-Host “$(Get-Random -Minimum 0 -Maximum 2)” -NoNewline } 1..14 | % {Write-Host “$(Get-Random…


PowerShell – DSC Environment Analyser (DSCEA)

Awesome! An  open source release of DSC Environment Analyzer (DSCEA), a PowerShell module that uses the declarative nature of Desired State Configuration to scan systems in an environment against a defined reference MOF file and generate compliance reports as to whether systems match the desired configuration. For more information, check out: https://blogs.technet.microsoft.com/ralphkyttle/2017/03/21/introducing-dscea/ https://github.com/Microsoft/DSCEA https://www.powershellgallery.com/packages/DSCEA  


[Script Of Mar. 23] How to calculate Azure SQL databases price by PowerShell

Mar 23 Script Download: The script is available for download from https://gallery.technet.microsoft.com/How-to-calculate-Azure-SQL-d0acbce8. The sample code demonstrates how to calculate Azure SQL databases price by PowerShell. You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery


Change in focus…

I forgot I haven’t touched this in a while – but will not be posting anything about Service Manager any more. I’m now changing focus to all Automation related technologies – specifically Azure Automation and PowerShell Desired State Configuration.