Tag Archives: powershell

Windows knowhow

Windows: Internet Explorer set open as default action for a file extension

Leave a comment

Hi,

the following steps describe how to  open a file with a specific file extension in Internet Explorer without showing the open/save dialog. In this example a the URL http://myintranethost.local/data/doc.pptm should open the PowerPoint Viewer without any interaction.

Continue reading Windows: Internet Explorer set open as default action for a file extension →

Advertisment to support michlstechblog.info

Powershell, Windows knowhow, Windows Scripts

Windows: Script to uninstall all Hotfixes and Updates

4 Comments

Hi,

here is a “oneliner” to uninstall all Windows Update at once. They were deinstalled in order from the highest to the lowest KB Number which increases speed of the remove process(Latest fix first).
Continue reading Windows: Script to uninstall all Hotfixes and Updates →

MySQL, Powershell, SQL Snipets

Powershell: Some examples to use a MySQL Database

7 Comments

Hi,

sometimes it makes sence to write Data in a “real” Databasesystem instead of writing to a text- or xml file.

MySQL offers an native Windows .NET Connector to its Database. You can get it here.

Continue reading Powershell: Some examples to use a MySQL Database →

Powershell

Powershell: Export a Excel Worksheet as csv file

7 Comments

Hi,

with a few lines Powershell code it is possible to export a Excel Workbook as a csv file.
Define your excel list

$sExcelFile="D:\temp\ExcelFile.xlsx"
$sCSVFile="D:\temp\list.csv"

Open Excel using DCOM
Continue reading Powershell: Export a Excel Worksheet as csv file →

Powershell, Windows Scripts

Powershell: List members of an Active Directory Group

Leave a comment

Hi,

here are the code snippets to list all members of an Active Directory Group.

Some constants

# Define LDAP search root, the Global catalog of the domain
$sLDAPSearchRoot="LDAP://yourDomain.com:3268"
# The Groupname to looking for
$sGroupName="USR_GRP_IN_AD"

Continue reading Powershell: List members of an Active Directory Group →