Category Archives: Microsoft

QFE Patch List with PowerShell

This handy little script will give you a list of recently installed security updates via the Win32_QuickFixEngeering WMI class (watch out for line wrap!).

Find Missing Subnets in Active Directory

This is a very manual task of logging onto each domain controller and copying the file to a central location, and then sifting through the data to remove any duplicate IP addresses etc. This task becomes very time consuming if you have a large number of domain controllers.

Find Deferred Messages in Exchange

Here is a quick little one liner to find all the deferred messages with FromAddress, Recipients and DeferReason. Get-TransportServer | Get-Queue | ?{$_.Identity -like ‘*submission*’} | get-message -IncludeRecipientInfo | ?{$_.Status -eq ‘Retry’} | select FromAddress,Recipients, DeferReason

Make Initials Capitals

Makes the initials characters capital. ie. character after space/hyphen/dot Public Function MakeInitialsCapital(str As String) As String    Dim i As Integer, L As Integer   Dim Prev_char As String * 1   Dim c As String * 1   Dim S As String    Prev_char = ” ”   L = Len(str)   i = 1   S = “”   Do While i <= L      c = Mid(str, i, 1)      If Prev_char = ” “… Read More »