Hi,
it’s simply possible to get the serial number of your Windows device at command line. Precontition is that the vendor has done it’s home work and filled up the DMI tables correctly 🙂 .
Continue reading Windows: Get a device serial number from command line
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
Hi,
since Windows 2008 and Windows Vista it is no more possible to start a cmd.exe with system rights by using the (Task)Scheduler.
Continue reading Windows: Start a cmd.exe with system rights
Hi,
since Windows 7 respectively Windows 2008R2 it has the ability to start a windows service with a trigger. Some Services, like dnscache, starts or stops on demand.
A customer had the problem that sometimes, after an automatic restart (on idle) of the DNS Client Service, Windows won’t register its name in DNS anymore. A manual register with
C:\> ipconfig /registerdns
was necessary each time.
Continue reading Windows: Remove a trigger from a service
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