Stanley Paul, Author at FMT

Search Archive
Office 365 bulk attribute update via PowerShell
In today fast-paced business environment, management attempt to perform an Office 365 users audit might find that the company had grown faster than they kept up with. Lots of unfamiliar names with assigned licenses and difficulties telling who belonged to which department. A request was put in for the Office 365 administrator to update user profiles with additional information such as title, department, and phone. A fairly easy task to perform, but quite a tall order if the information was not populated for all 126 users. Here is where PowerShell comes to the rescue! The tool can be leveraged and the list can be updated in a template spreadsheet to eliminate the need to edit individual profiles within Office 365 admin portal. Such tasks may take hours to complete.   Prerequisites: Office 365 “cloud” users. This process will not work on users that are synchronized from on-premises Active Directory via […]
How To Backup, Delete And Re-Create An SQL Table
Did Your Company Table Fail During A Dynamics GP Upgrade? From time to time during upgrades, we run into time-consuming issues that really don't make much sense.  I have performed more Dynamics GP upgrades than I care to count and no two are ever alike. The process below will guide you through backing up, deleting and re-creating a Dynamics GP company table that failed to upgrade. (This happened during a test upgrade, and we did not get this error during the production upgrade.  Go figure.) During Dynamics GP upgrades you will find from time to time that a company will fail to upgrade. Worse yet you check the error and find you get something like this:     Then you check for the temporary table and it does not exist. This script was used to solve the issue I was having with this table in question. BEWARE! If using this […]
Dynamics GP Disaster Recovery Planning
While setting up and upgrading Dynamics GP for clients, I often find disaster recovery planning is something that is overlooked. Often, only the databases are backed up and newly created companies have not been added to the backup plan. In light of this, I want to walk you through what you’ll need to have ready to bring up your GP system quickly in the event of a disaster or data loss. For the purposes of this blog, we will assume that only the SQL Server needs to be recovered. In this case, no software will need to be reinstalled unless it was installed on the SQL server itself. Since all our other servers are still up and running, but are pointed to the SQL server, the software on these servers would be safe in this case. 1. Capture Logins It is important to capture SQL logins from the SQL server […]
 FMT Consultants, LLC.
Privacy Policy

Contact Us


Newsletter Sign-up

menu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram