The report you have created is perfect, really helpfull!
I am trying to understand what do I have to change in order to create this report but only for specific interfaces and not for all in the database. F.e. Select specific interfaces using InterfaceID. Can you please help on this?
I think this report can only be queried from SQL Studio not the report writer.
For different time period, you can change the time duration, e.g: this is for last 3 month from jan1-mar31: '01/01/2011 00:00:00', '03/31/2011 23:59:59'
For a specific interface, you can put the WHERE clause under the Select distinct query: e.g: Where (Interfaces.Caption like '%xxxxx%') or Where (Interfaces.Caption = 'xxxxxx')
