Select query from all DPs

[najoua]

Hi,

I have the following sql query that select all alerts of a DP. What is the syntax to do a select query of all available alerts of all DPs in the Para module?

SELECT ALERT 'COUNT(_alert_hdl.._value)' FROM 'MyDP_example' WHERE '_alert_hdl.._act_state' = 1

Thanks,

[michel.eijgermans]

Hi,
Have you tried the following statement,
SELECT ALERT 'COUNT(_alert_hdl.._value)' FROM '*' WHERE '_alert_hdl.._act_state' = 1

[najoua]

Hi,

Thank you Michel ! I tried to use the '*' but it doesn't work, the I replaced it by '*.*.*.*' and it works because in the structure of my DPs I have alerts at the 4th level !!

Best regards,