Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Interface Availability Report - Last Month

FormerMember

Modified Interface Availability report for last month

Interface_Availability_-_Last_Month.OrionReport

Find more posts tagged with

Accepted answers

All comments

goktugy

Thanks

euphorik

Brilliant - exactly what I was looking for.

kkan

Hello sotherls, hope you are fine.

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?

Best Regards
Kostas Kanellopoulos

Mahmood

When I execute the report, the system just hung doing (querying database). do i have to change somthing to make it work ?

mohdeddy

Hi,

I'm just joining in...i have a question how do i open the attached file?

thanks

msab

I am trying to run this report but it is taking a very long time. I am not even sure it is doing anything

msab

Is there somthing in the sql that will need to be changed per installation?

msab

The report would never complete for me. I am running SLX V10 sp1

sean-anthony

anyone tell me what I need to modify to make it do last 3 months please?

IndoMie

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')

ashish

Why does it not generate any thing. Am i doing something wrong. I tried to do a preview in report writer but got nothing.