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… Continue reading Sage 50–Automatic Backup – An unknown error occurred compressing the database files.
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.
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.… Continue reading SQL Select–Format for phone number
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… Continue reading Apple Account Auto Verify
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… Continue reading SharePoint–Profile Pictures no longer show after MySite URL change
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… Continue reading SharePoint – Export All Documents on Site and Sub-Sites
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… Continue reading Check group membership from AD with Foreign Security Principals
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… Continue reading Microsoft Word – Mail Merge Separate Documents and Save File Name as Mail Merge Variable
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 … Continue reading Configuring alarms on all VMware alarm definitions automatically using PowerShell
Happen to have a calendar that is email enabled on SharePoint but calendar items aren’t being created from an email? Check your ULS logs on your SharePoint server that and see if you have something similar to this error below: An error occurred while processing the incoming e-mail file C:\Inetpub\mailroot\Drop\86d3c93401cab0ba0000002b.eml. The error was: Value… Continue reading An error occurred while processing the incoming e-mail The error was: Value cannot be null. Parameter name: stream.