Group Policy not applying to security filtered user or group

August 25, 2016 0 Comments

  Came across an issue this week where a newly imaged computer would not apply group policies that were filtered to an Active Directory group. GPResult showed no reference of the group policy, but it did show that the user was in the correct AD group.   After much research, I found that Microsoft released …

Sage 50–Automatic Backup – An unknown error occurred compressing the database files.

March 24, 2015 0 Comments

  While setting up a new Sage 50 2015 server I kept getting an error message “An unknown error occurred compressing the database files.” After further troubleshooting with Microsoft Process Monitor (https://technet.microsoft.com/en-us/library/bb896645.aspx) I found that it was trying to put a temporary file in a folder called “Backup” inside the company folder. This is probably …

Enterprise Google Chrome Extension Not Installing

February 24, 2015 0 Comments

  Had a recent issue where a Google Chrome extension I built wasn’t installing via group policy. After a lot of troubleshooting I found an entry in HKLM\Software\Policies\Google\Chrome\ExtensionInstallSources. Once I deleted that entire registry key (not just the value), the and restarted Chrome, the extension installed using the pushed settings that is in HKLM\Software\Policies\Google\Chrome\ExtensionInstallSources.

SQL Select–Format for phone number

February 11, 2015 0 Comments

  If you want to create a SQL query to format a phone number based on different formats that may be in a database you can use this. Modify to fit your needs. ### – Replace this with your 3 digit area code. This is used when only 7 digits are stored as the value. …

Apple Account Auto Verify

December 24, 2014 22 Comments

  A tool I wrote in C# that automatically verifies apple accounts. Below is a link to the source code (Visual Studio 2010), however if you meet the following criteria, you can use it without modifying the code. Windows computer running .Net 4.0 Running Exchange 2010 Know the username and password to the mailbox that …

SharePoint–Profile Pictures no longer show after MySite URL change

November 5, 2014 0 Comments

I was recently installed SharePoint 2013 and had it staged under a different hostname so that I could just migrate IP’s and create CNAME DNS records for minimal downtime. However I found that once I had everything swapped to the new server the profile photos wouldn’t work anymore and I kept getting error messages when …

SharePoint – Export All Documents on Site and Sub-Sites

September 25, 2014 0 Comments

  I was eliminating a site on SharePoint that had over 50 sub-sites. I wanted an easy way to get all the documents in each site without having to manually visit each one. Here is an easy PowerShell script I came up with. 1: #Created by Brandon Claps 2: #9/25/14 3: #Exports all documents under …

Check group membership from AD with Foreign Security Principals

May 19, 2014 7 Comments

The following code will check if a user is a member of a specific group. This will work with a domain trust and Foreign Security Principals. See the update below! groupName = The sAMAccountName of the group you want to check the members of. SearchDomain = This is the FQDN that you will be searching …

Microsoft Word – Mail Merge Separate Documents and Save File Name as Mail Merge Variable

January 28, 2014 0 Comments

Setup your Microsoft Word mail merge by selecting your data source and the recipients. Don’t actually complete the mail merge. Create two Macro’s, one called “StartMailMerge” and the other called “DoWork”.   StartMailMerge – Code Sub Start() For i = 1 To ActiveDocument.MailMerge.DataSource.RecordCount DoWork Next i End Sub DoWork – Code Sub DoWork() Dim DokName …

Configuring alarms on all VMware alarm definitions automatically using PowerShell

January 21, 2014 0 Comments

  My example contains alarm actions to send an email, but you can configure this for SNMP or any other actions. You can copy and paste this into a “.ps1” file to create a PowerShell scripts. # This command will remove any alarms actions that are configured currently. Get-AlarmDefinition | Get-AlarmAction | Remove-AlarmAction -confirm:$false   …