SQL Queries - Common SQL Queries - How to get Assessment Model Information for whole database server

This page provides the script to get the assessment model details for the applications on the whole database server. 

1. Run the script attached on your database server. server_assessmentModelUpgradeHistory.sql 
   1. 
2. You will be able to see it created in your public schema as below -  
   1. 

3. Run the below command to get the results - 

   select *
   from MAINT_assessmentModelUpgradeHistory() 

   Query result example

   schemaname	logdate	tasklabel	upgradeversion
   xxx_mngt	2018-12-11 01:30:42.336	Merge Assessment Model [progressive] for xxx-central*	8.3.6.1
   xxx_mngt	2019-03-10 05:53:22.834	Merge Assessment Model [progressive] for xxx-central*	8.3.6.1
   xxx_mngt	2019-12-12 03:30:23.983	Merge Assessment Model [progressive] for xxx-central*	8.3.16.1
   xxx_mngt	2021-03-12 13:27:22.223	Merge Assessment Model [progressive] for xxx-central*	8.3.32.1
   xxx_mngt	2021-03-29 10:24:56.37	Merge Assessment Model [progressive] for xxx-central*	8.3.33.1
   xxx_mngt	2021-04-28 05:18:31.178	Merge Assessment Model [conservative] for xxx-central*	8.3.34.1
   xxx_mngt	2021-05-28 13:17:02.309	Merge Assessment Model [conservative] for xxx-central*	8.3.35.1
   xxx_mngt	2021-06-25 06:14:48.396	Merge Assessment Model [conservative] for xxx-central*	8.3.36.1
   xxx_mngt	2021-07-28 05:49:17.207	Merge Assessment Model [conservative] for xxx-central*	8.3.37.1

   Query result interpretation

   The mode of the assessment model migration is given between brackets, with the following meanings:

   • progressive: keep current configuration on existing QRs, activate new QRs
   • conservative: keep current configuration on existing QRs, do not activate new QRs
   • true: replace with the new assessment model
   • retain: do not update current assessment model