Export a list of all mailboxes in Exchange using PowerShell including sizes and which database they reside on

This is a just a quick post to show an example of the Get-MailboxStatistics command in Microsoft Exchange.  This command is useful if you want to pull off information about your user’s mailboxes including size, mailbox database and other attributes.

Continue reading “Export a list of all mailboxes in Exchange using PowerShell including sizes and which database they reside on”

How to find out the password expiry dates for your Active Directory Users

If you want to find out when user’s passwords will expire and export them to a .csv file then this will help.  This simple script will list all of your active users, sort the list and list the expiry dates.

Import-Module ActiveDirectory
Get-ADUser -filter {Enabled -eq $True -and PasswordNeverExpires -eq $False} Properties "SamAccountName","msDS-UserPasswordExpiryTimeComputed" | Select-Object -Property "SamAccountName", @{Name="Password Expiry Date"; Expression={[datetime]::FromFileTime($_."msDS-UserPasswordExpiryTimeComputed")}} | sort "SamAccountName" | export-csv c:\temp\expire.csv -NoTypeInformation 

 

You can also modify the script so that all you need to do is enter the username and get the expiry date:

Import-Module ActiveDirectory
Add-Type -AssemblyName Microsoft.VisualBasic
$username = [Microsoft.VisualBasic.Interaction]::InputBox('Enter users SamAccountName', 'SamAccountName') 

Get-ADUser $username Properties "SamAccountName","msDS-UserPasswordExpiryTimeComputed" | Select-Object -Property "SamAccountName", @{Name="Password Expiry Date"; Expression={[datetime]::FromFileTime($_."msDS-UserPasswordExpiryTimeComputed")}} | sort "SamAccountName" | Out-GridView 

 
If you are running the script from a desktop machine ensure that PowerShell is running as admin and that you have the RSAT tools installed.

Use PowerShell to list and export all updates from a Windows machine

Sometimes when trying to find particular updates and troubleshoot Windows update problems you need to be able to manipulate the update data.  Using the ‘installed updates’ applet is not always practical.  I use the below script to give me a .csv files with all updates installed on a machine.

Continue reading “Use PowerShell to list and export all updates from a Windows machine”