Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 10 at 11:39 AM

    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/

    Add comment
    10|10000 characters needed characters exceeded

  • May 10 at 11:45 AM
    Add comment
    10|10000 characters needed characters exceeded

  • May 10 at 12:25 PM

    Query in QueryBuilder:

    Result:

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 10 at 01:23 PM

    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

    Add comment
    10|10000 characters needed characters exceeded