How to Create SQL alerts reports in web based

Hi Guys,

I am creating SQL alerts report for last one month.can you suggest me.

creating report by dynamic query. not using SQL query(Report writer). Please help me.

Thanks and Regards,

Kishore.

Find more posts tagged with

daily reports

sql

npm

Alerts

In the "Add Content" of the report change the drop down to the following.

You can then use SWQL or SQL and test your results.

Thank you for Neomatrix, I am not using SWQL. can you tell me the dynamic query.

Please suggest.

Thanks and Regards,

Kishore.

You can select SWQL or SQL.

Can you tell me what level of access I need to be able to select SQL rather than WSQL in the report editor?

(I'm a DBA not completely familier with Orion backend)

At the moment I can only select WSQL.