DX Application Performance Management

I want to find out all the alert names created, status of each alert and the Action associated with each alert. can i have the sql query for that ? 

Dear Usman:

The Command Line Workstation can list alerts and actions but does not tie them together. See CLW Command Reference - CA Application Performance Management - 10.7 - CA Technologies Documentation 

List Actions

The List Actions command lists one or more Actions in one or more Management Modules. You supply two regular expressions -- one that specifies the Actions, and one that specifies the Management Modules.

Syntax

list actions matching <REGULAR EXPRESSION> in management modules matching <REGULAR EXPRESSION>

Example

list actions matching (.*) in management modules matching (.*)

This command lists all Actions in all Management Modules.

List Alerts

The List Alerts command lists one or more Alerts in one or more Management Modules. You supply two regular expressions -- one that specifies the Alerts, and one that specifies the Management Modules.

Syntax

list alerts matching <REGULAR EXPRESSION> in management modules matching <REGULAR EXPRESSION>

Example

list alerts matching (.*) in management modules matching Sample

This command lists the Alerts in the Management Module named Sample.

You can also get the status of an alert using the "query state of alerts" option

CLW Command Reference - CA Application Performance Management - 10.7 - CA Technologies Documentation