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.
How do you list the members of an Active Directory Group in PowerShell?
This is a very useful line of code that will list all of the members of a particular Active Directory group and send the output to a .csv file.
Get-ADGroupMember -Identity "Test Group" | export-csv c:\temp\GroupMembers.csv
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”