SQL Queries - Common SQL Queries - How to get Assessment Model Information for whole database server
Purpose of Query
This page provides the script to get the assessment model details for the applications on the whole database server.
Applicable CAST Version
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
Applicable RDBMS
| RDBMS | Yes/No |
|---|---|
| CSS4 | ✅ |
| CSS3 | ✅ |
Query for CSS
Run the script attached on your database server. server_assessmentModelUpgradeHistory.sql
You will be able to see it created in your public schema as below -
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
**Notes/comments**
Ticket # 37711
**Related Pages**