This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Need help with creating an advanced SQL Query in Orion Report Writer.


I am a noob in terms of SQL queries.


I have been trying to create a report that provides my company's WAN usage per WAN circuit.(With Circuit IDs displayed)


I need it to report monthly and I have tried in the 'Advanced SQL' but have been unable to get anthing to Query so that I can at least preview the report before I save it.

I have even googled and cannot seem to find anything in terms of the report that I am trying to create.

I have also tried to edit existing reports to no avail.


Thanks for any help on this!

  • Let us know which SQL query you've tried or which report you've tried to modify and we can work from there. Also, if applicable, what error messages did you encounter?

    My first guess is that you'd want to use any one of the canned reports under Historical Traffic Reports.