Historical traffic interface data from multiple fractioned tables

Historical traffic interface data from multiple fractioned tables

Hi,
I need to build historical traffic reports on op manager. Eg. the in/out traffic for a week or a month... as you may know, data collection tables at OpManager (statsdata_daily_yyyy_mm_dd, ifhcraw_yyyy_mm_dd, etc...) are fractioned when they reach specific amount of rows, and the date range where the tables are "cutted" is variable... so I need a SQL query or procedure, or a view that can join this tables so If I need the weekly or monthly report... something that can query from all required tables.

Thanks.
IPM 
              New to ADManager Plus?

                New to ADSelfService Plus?