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
Hi,
short post today:-)
nltest is a builtin tool in Windows to query lots of AD information.
Continue reading Windows: Query Active Directory Site information
Hi,
the time command in Windows gets or sets the system time. If you need an equivalent to the linux time command – which measure the execution time of a given command – you can use the powershell commandlet Measure-Command. Limitation is that only the time can measure how long the command execution runs, not splited into user, system and realtime.
Continue reading Windows: Equivalent to linux time command
Hi,
by default Bitlocker could only activated when a TPM chip is physically present.
If you want to use Bitlocker without a TPM module you must change your (local) policy. Open the Group Policy Object Editor (gpedit.msc), navigate to
Continue reading Windows: Enable Bitlocker without a TPM module
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