SQL Queries - CAST Central Base - Queries on applications - How to get and update the business value of an application

Created by Salim Frontin, last modified by Deepak Kumar on Jun 13, 2022
Purpose of Query

This document provides a query to get or update the business value of an application.

The business value of an application is a parameter used by the Cast Engineering Dashboard to decide the size of the application in the global display of the portfolio data.

Its value is set by the final user, it represents the importance of an application within the business portfolio.

Applicable CAST Version
Release
Yes/No
8.3.x(tick) 
Applicable RDBMS
RDBMS
Yes/No
Oracle Server (tick) 
Microsoft SQL Server (question) 
CSS2 (tick) 
Query for CSS

Get the business value of your application


SELECT Metric_num_value AS "business value"
FROM   dss_metric_results
WHERE  metric_id  =66061
AND    object_id  =<APPLICATION_ID>
AND    snapshot_id=
       (SELECT MAX(SNAPSHOT_ID)
       FROM    DSS_SNAPSHOTS
       WHERE   APPLICATION_ID=<APPLICATION_ID>
       )
Query result example

1

Query result interpretation

The business value parameter set for this application is 1.

(It is the default value)

Query for Oracle

Get the business value of your application


SELECT Metric_num_value AS "business value"
FROM   dss_metric_results
WHERE  metric_id  =66061
AND    object_id  =<APPLICATION_ID>
AND    snapshot_id=
       (SELECT MAX(SNAPSHOT_ID)
       FROM    DSS_SNAPSHOTS
       WHERE   APPLICATION_ID=<APPLICATION_ID>
       )
Query result example

business value
-----------------
1

1 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 0/ms]

Query result interpretation

The business value parameter set for this application is 1.

(It is the default value)

Query for CSS

Update the business value of your application

Suppose you want to give more importance to your application in Cast Engineering Dashboard display.

UPDATE dss_metric_results
SET    metric_num_value = <BUSINESS_VALUE> -- 3 for instance
WHERE  metric_id        =66061
AND    object_id        =<APPLICATION_ID>
AND    snapshot_id      =
       (SELECT MAX(SNAPSHOT_ID)
       FROM    DSS_SNAPSHOTS
       WHERE   APPLICATION_ID=<APPLICATION_ID>
       )
Query result example

Query executed successfully : one line modified. Query was executed in 13 ms.

Query result interpretation

The business value parameter was updated to 3. The application will now appear in a bigger frame in CED.

In case you want to update for any particular snapshot, then you can replace the "(select max(SNAPSHOT_ID) from DSS_SNAPSHOTS WHERE APPLICATION_ID=<APPLCIATION_ID>)"  with the snapshot_id you are interested in.
In this example, it is for the latest snapshot

Query for Oracle

Update the business value of your application

Suppose you want to give more importance to your application in Cast Engineering Dashboard display.

UPDATE dss_metric_results
SET    metric_num_value = <BUSINESS_VALUE> -- 3 for instance
WHERE  metric_id        =66061
AND    object_id        =<APPLICATION_ID>
AND    snapshot_id      =
       (SELECT MAX(SNAPSHOT_ID)
       FROM    DSS_SNAPSHOTS
       WHERE   APPLICATION_ID=<APPLICATION_ID>
       )
Query result example

1 record(s) affected

[Executed: 17/01/17 09:22:34 GMT ] [Execution: 345/ms]

Query result interpretation

The business value parameter was updated to 3. The application will now appear in a bigger frame in CED.

In case you wanted to update for any particular snapshot, then you can replace the "(select max(SNAPSHOT_ID) from DSS_SNAPSHOTS WHERE APPLICATION_ID=<APPLCIATION_ID>)"  with the snapshot_id you are interested in.
In this example, it is for the latest snapshot

Notes/comments

Related Pages