Lately for many of our customers the Connect section has not been working as expected, for a few its just an ugly Error 404: File or directory not Found.
Or simply it has been getting in the way of Integration Manager. Even when many colleagues like Mariano Gomez, Mark Polino, David Musgrave, Leslie Vail and others have provided help to the community on this issues. One question remained unanswered: How to massively remove it without the administrator login into each account?.
Famous engineer Tami Jones from the RoseASP team came up to my beach front office with a wonderful view of the Pacific ocean (ok it’s a 3 wall cubicle with no view) and asked me how can we automate this process as you know we team up with myGPcloud as well.
So I decided to take a look at the homepage behavior and came up with the following descriptions:
|SectionID||Value 1||is the ToDo Section|
|SectionID||Value 2||is the Outlook Section|
|SectionID||Value 3||is the Metrics Section|
|SectionID||Value 4||is the My Reports Section|
|SectionID||Value 5||is the Quick Links Section|
|SectionID||Value 6||is the Connect Section|
The table responsible for storing the values to display or hide those sections is SY08100 in Dynamics DB. So here is the script that will help you remove the connect section:
With a little tweak you can limit the update statement to work only on 1 user or a set of users.
Always remember to backup your database and try statements in a test DB.
Have a great day!!!