Catapult, a Quisitive company, is a Microsoft-focused solutions and services firm that specializes in imagining, building and sustaining digital transformation and cloud-based solutions that people love to use. Catapult has consistently been recognized as a leading Microsoft Partner with 10 Advanced Specializations and 17 Microsoft competencies. Recent accolades include 2020 MSUS Partner Award Winner Azure – DevOps, Top Microsoft 365 Security Partner for FY20, and being named a finalist of the Data Analytics 2020 Microsoft Partner of the Year Award. Catapult has offices nationwide.

Bulk Update AD Objects with a CSV File

Project Description PowerShell script that updates AD objects based on a CSV schema. First, a big thank you to Cary Landers and Nuno Mota. This effort was adapted from: https://companydirectory.codeplex.com/ by Cary Landers https://gallery.technet.microsoft.com/scriptcenter/f7b246a4-95a2-4408-b1a1-73b53003883c by Nuno Mota This script does the following: Iterates through records in a CSV For each record, looks up the AD object’s distinguishedName based…

SP2013 Geolocation Manager

Adding a Geolocation column to a list in SharePoint 2013 is a bit of a pain because there’s no built-in user interface to do so.  Instead, you have to add it with code.  Check out Tobias Zimmergren’s article to get acquainted with the Geolocation column in SharePoint 2013:  http://zimmergren.net/technical/sp-2013-getting-started-with-the-new-geolocation-field-in-sharepoint-2013. Now, to the point of my…

SQL – An aggregate may not appear in the set list of an UPDATE statement

I have a Project table that contains a couple of fields used for reporting and metrics called FirstActivity, LastActivity, and TotalHours. I created the following SQL query to update those fields based on some aggregated results from the ProjectHours table: UPDATE     [dbo].[Project] SET     FirstActivity = MIN(ProjectHours.[EntryDate])     , FirstActivity = MAX(ProjectHours.[EntryDate])     , TotalHours = SUM(ProjectHours.[TotalHours]) FROM…

SQL – An aggregate may not appear in the set list of an UPDATE statement

I have a Project table that contains a couple of fields used for reporting and metrics called FirstActivity, LastActivity, and TotalHours. I created the following SQL query to update those fields based on some aggregated results from the ProjectHours table: UPDATE     [dbo].[Project] SET     FirstActivity = MIN(ProjectHours.[EntryDate])     , FirstActivity = MAX(ProjectHours.[EntryDate])     , TotalHours = SUM(ProjectHours.[TotalHours]) FROM     [dbo].[Project]     INNER JOIN [ProjectHours] ON [Project].[ProjectId]…

RESOLVED – Microsoft OneDrive and Search Indexer 30% CPU ALL THE TIME and OneDrive stuck saying “Checking for changes” in the systray!

UPDATE 10/29/2014 It took me a while but I finally figured out why I was having problems with OneDrive.  Scroll to the 10/05/2014 section for a description of what the problem was.    It turns out I had a folder name using an unusual character.  This was not a special character that OneDrive can’t sync  as in \…