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

Applicable RDBMS

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