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