How to automatically set the "Expanded By Default" property for windows with only one group box

Version 3

    Problem

    When viewing a window in Mobile Web Desk that only has one group box it is collapsed by default and having to expand it manually is a chore.  Having to modify every window in Windows Manager to set the "Expanded By Default in Mobile" property is also a chore.

     

    Solution

    Run the attached SQL script against your Service Desk database to set the "Expanded By Default in Mobile" property on group boxes on windows that have only one group box.  Follow with an IIS reset.

     

    Be sure to try this on a test system first and take a full backup of the database before running.