Skip to Content
0

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

May 10 at 10:44 AM

45

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Bharath B N
May 10 at 11:39 AM
2

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/

Show 3 Share
10 |10000 characters needed characters left characters exceeded
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

1

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. (')

0

is this query worked for you?

0
Bharath B N
May 10 at 11:45 AM
2
Share
10 |10000 characters needed characters left characters exceeded
Bharath B N
May 10 at 12:25 PM
2

Query in QueryBuilder:

Result:


Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 10 at 01:23 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded