cancel
Showing results for 
Search instead for 
Did you mean: 

Business Objects - What is the Query to find the list of watches in CMC ?

Former Member
0 Kudos

Hi,

I know in my platform there are 90+ watches under monitoring was created in our BO CMC and most of them are in active state. I would like to know is there any query to find the list of watches using query builder, i need to get the information of the watches like notification, rule, etc etc . Also happy to know if there is any SDK code that i can use to get all these details from watches under monitoring

Doing this by going through each watches is again to take lot of time and boring human task at any day.

Thanks in advance.

Regards

MK

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member230921
Active Contributor

Query in QueryBuilder:

Result:

former_member230921
Active Contributor
former_member230921
Active Contributor

SELECT SI_NOTIFICATION_SETTINGS, SI_MAIL_DELIVERY_STATE, SI_ALERT_EVENTS FROM CI_APPOBJECTS WHERE SI_KIND= 'MON.ManagedEntityStatus'

If you need more properties use SELECT * .........

If you want export result as JSON/XML:

use BI REST API:https://blogs.sap.com/2017/05/10/query-the-businessobjects-repository-using-bi-platform-rest-sdk-rws...

Former Member

Hi Bharath,

Thanks again.

I tried the query and it is giving me an error. saying that is invalid query.

There was an error retrieving data from the server: Not a valid query. (FWB 00025)

Regards

MK

former_member230921
Active Contributor
0 Kudos

SELECT SI_NOTIFICATION_SETTINGS, SI_MAIL_DELIVERY_STATE, SI_ALERT_EVENTS FROM CI_APPOBJECTS WHERE SI_KIND= 'MON.ManagedEntityStatus'

Try this . single quote problem in first one. (')

former_member230921
Active Contributor
0 Kudos

is this query worked for you?

Former Member
0 Kudos

Thanks Bharat,

When i typed manually, it did got worked for me as well.

Do you have any sdk program based on this watches or appobjects for that matter?

Regards
MK