The most recent content from our members.
Custom reports are not only the domain of Orion custom report writer. SQL Reporting Services also provides a valuable method of creating custom reports. This document provides an introduction to what is possible - including an example of providing graphs within your reports. Dave.
a simple and I think useful resource for the Home page where you can view all nodes scheduled for unmanagement in the near future. Also created a custom node icons for differentiation.
Hi, I need to generate custom Utilization for CustomerX. I only need Utilization Report from Interface Dialer2. CustomerX has Serial0 int, dialer1 int and dialer2 int. This Utilization report/graph for last month. Any idea how to do it? Tqvm.
This attachment provides the necessary SQL scripts and NPM reports to archive Interface Utilization data and display reports where circuit utilization remains over a certain threshold for a consecutive time interval.
This is an Advanced SQL-based reports that looks for any servers in NPM that do no have any monitored physical volumes (i.e. those where physical or virtual memory are monitored will not appear in the report).
list of interfaces where: * status is NOT "up" * admin-status is NOT "shutdown" * status hasn't changed in over 60 days see below for example
Report for Last Month, Monday through Friday, hours from 9-5 giving utilization (MAX,AVG,AVG%) NOTE: you will want to tweak the custom SQL. I have a where clauses that selects specific NodeIDs for my environment. you probably want to tweak that for your enviornment. an example might be to remove my section: ( n.NodeID in…
This is a report that will give you a List of Nodes by Polling Engine.
IPSLA % uptime report - pt 1 ***NOTE - you (or DBAs) need to have access to SQL Mgmt Studio and understand SQL Above is the first part of this. This is a [RUDAMENTARY] script that allows you to (in a separate table) add notes about IPSLA outages. The SQL to create the VoipNotes table and add 2 columns to the…
I am using IPSLA to do TCP connect to remote customers HSRP address from a router within our network. We use it to calculate uptime availability and have PMPs based on it (so its important to be accurate). I have 2 stored procedures that are commented *fairly* well and a report that I'm uploading. The SQL procedures create…
It looks like you're new here. Sign in or register to get started.