Viewing the Installed Version History of the Servicing Director Database

Viewing the Installed Version History of the Servicing Director Database

To view the current and previous versions that have been installed on the Servicing Director database, run the following SQL statement on the Database server.

The procedure below is for your local IT or system administrator familiar with Windows and Microsoft SQL server.


Run the following SQL statement on the Database server from a SQL Server Management Studio New Query screen:

SELECT dbInstallDescription AS [Description], Description AS [Install Type], StartDate AS [Install Date] , VersionStart AS [Installed Over]
FROM Service..t_dbhistory
JOIN SystemTypes ON Code = dbInstallType AND FieldName = 'dbinstalltype'
Order by StartDate DESC

This statement returns a list of all versions of Servicing Director that have been installed on a system, listing the most current version first.
 

ArticleNumber:

000044656

    • Related Articles

    • Servicing Director backups

      This article describes the Servicing Director data you should backup as part of your company data backup plan. This article does not cover backup methods or strategies in detail, and you should use your local technical support resources to make sure ...

    • Confirming if a Servicing Director Service Pack is Installed

      Use the following procedures to confirm if a Servicing Director service pack is installed. The Servicing Director service packs are small updates or fixes for Servicing Director, which may apply to the Servicing Director database server, or to the ...

    • Current Version of Fusion Servicing Director

      The current version of Fusion Servicing Director is 20.1. This version was released on June 10, 2020 and is a full upgrade from version 19.4 of both the server and the desktop applications and includes the following: Two major enhancements: ...

    • Viewing the Version Number of Your Servicing Director Applications

      To view the version number (or release version) of your Servicing Director applications, use the procedure below to view the Help About screen. Other useful information is also displayed on the Help About screen. Note: The version number displayed is ...

    • Servicing Director Components Are Version Specific

      The Servicing Director product components are version specific, meaning that all the components need to be of the same version to work together. The required Servicing Director components include databases, a network shared \SvcData folder, and the ...