SQL Queries - CAST Management Base - Queries on jobs - How to retrieve a KB Update tool details from the DB

Purpose of Query

This query retrieves the details of the KB Update tool configured in the application per DB server

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
7.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(question)
Microsoft SQL Server(question)
CSS2(tick)
CSS3(tick)
Query for CSS

To retrieve all the KB Update tool configured specifically to one DB sever, you need to run the attached SQL on the DB server.

 FindKBUpdateTools.sql

After which you can run the select function like below to display the results - 

select * from findKBUpdateTools();
Query result example

 

Query result interpretation
The query returns the name of the KB Update tool in the management bases on the specific DB server. 
Notes/comments


Related Pages