BPM Alarms - Looking for Query to find Transaction information for Alarm in Alarm_10000 table

I'm trying to find the link back from the Alarm found in the Alarm_10000 table to the transaction that creaed the alarm.  Anyone know how to find this?

 

LeRoy

Parents
  • Hi LeRoy,

     

    the key is the field ALARMS.AL_ENTITY_ID

    It links to the table TRANSACTIONS_DIM (and a lot others as well), field APPLICATION_NAME
    So if you have these entries in ALARMS (which is the view, pointing to in your case ALARMS_10000)


    SELECT [AL_TRIGGERED_TIME],[AL_ALARM_NAME],[AL_ENTITY_ID]
    FROM [VM402_BSM_PROFDEF].[dbo].[ALARMS]

     

    AL_TRIGGERED_TIME AL_ALARM_NAME AL_ENTITY_ID
    2014-05-23 15:13:52.000 SG_Test 0xD72F7FF493E849DCD9FD6055C57927C1
    2014-10-10 09:19:25.000 SG_BA_BPM_JPetStore:user1 0x6002F6E3AF222928800524D7D25D4DA0

     

    you can find the corresponding EUM transactions here:

     

    SELECT [TRANSACTION_NAME],[APPLICATION_NAME],[BTF_NAME]
    FROM [VM402_BSM_PROFBPM].[dbo].[TRANSACTIONS_DIM]
    where APPLICATION_ID=0xD72F7FF493E849DCD9FD6055C57927C1 or
    APPLICATION_ID=0x6002F6E3AF222928800524D7D25D4DA0


    TRANSACTION_NAME APPLICATION_NAME BTF_NAME
    Step 1 - Google Seach for SSO BA_Google_SSO Google_SSO
    Step 2 - SSO BA_Google_SSO Google_SSO
    Step 0 - Google BA_Google_SSO Google_SSO

    Step 0 - Start JPetStore BA_BPM_JPetStore_user1 JPetStore_user1

    Step 1 - Login BA_BPM_JPetStore_user1 JPetStore_user1
    Step 2 - Order a bird BA_BPM_JPetStore_user1 JPetStore_user1
    Step 3 - Check out BA_BPM_JPetStore_user1 JPetStore_user1
    Step 4 - Logout BA_BPM_JPetStore_user1 JPetStore_user1


    Note:

    I found the alarm messages logged into the default profile database only, while my BPM transactions live in a different profile database, so you need to verify where to retrieve the information from.

     

    Greetings
    Siggi

  • Hi Siggi,

     

    That gets me part way there.  I need to get to the location of where that alarm came from.

     

    LeRoy

Reply Children
No Data