Hi Arpan,
Let me try to clarify.
You said "I am able to see the data for java application on CA dash board". Therefore somewhere in your environment there must be an Enterprise Manager (EM) already installed which is receiving data from the Java Agent to display on the dashboard.
The SQL REST API and CLW (Command Line Workstation) are 2 different options for you to try to get the alert data per your original thread: REST API for CA APM open alerts (APM SaaS for DXI)
1. The SQL REST API is available in EM 10.7 SP2 (SQL REST API - CA Application Performance Management - 10.7 - CA Technologies Documentation ) and you can use the metric_path mike_cook suggested ("SuperDomain|Custom Metric Host|Custom Metric Process|Custom Metric Agent|Alerts|{MM name}|{Alert name}")
2. Using CLW is an alternative option.
java .... -jar CLWorkstation.jar query state of alerts matching (.*) in management modules matching (.*)
CLW Command Reference - CA Application Performance Management - 10.7 - CA Technologies Documentation
The CLWorkstation.jar can be found in the lib directory under the Enterprise Manager install or Standalone Workstation install.
Hope that helps.
I also put this in your original thread REST API for CA APM open alerts (APM SaaS for DXI) so let us continue there if you still need more help.
Regards,
Lynn