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.

Maximum number of B-channels in user per day

Questionario over 14 years ago

This report reports on all nodes who have a custom poller with an OID of 1.3.6.1.2.1.10.20.1.2.1.1.2 assigned.

This will give you the maximum amount of used B-channels probed per day over the last 30days.

MAX_ISDN_B-Channels_in_use_per_day_-_Last_30_days.OrionReport

0 geeknet over 13 years ago

Thanks for sharing; it worked great!
Cancel
Vote Up 0 Vote Down

Cancel
0 Questionario over 13 years ago

your welcome
Cancel
Vote Up 0 Vote Down

Cancel
0 mholland over 13 years ago

new to the progam but this looks something of interest.
could you proved brief detail as to proper location to place this file and how to access it

Thank you.
Cancel
Vote Up 0 Vote Down

Cancel
0 Questionario over 13 years ago

you need to open this file with report writer and also create a universal device poller with the OID mentioned above and assign that to any node you want to report on!
Cancel
Vote Up 0 Vote Down

Cancel
0 mholland over 13 years ago

Thanks for the help
Cancel
Vote Up 0 Vote Down

Cancel
0 Questionario over 13 years ago

glad to help, did you get what you wanted from the report?
Cancel
Vote Up 0 Vote Down

Cancel
0 jerryard1 over 13 years ago

i've created the universal poller and tried running the report. I get a message: "sql error: type date is not a defined system type." anyone know what that means?
Cancel
Vote Up 0 Vote Down

Cancel
0 Questionario over 13 years ago

did you assign the poller to the devices in question?
did you change anything in the report?
which version of NPM are you running?
Cancel
Vote Up 0 Vote Down

Cancel
0 FormerMember over 13 years ago

we had the same error message using sql 2005 and made a few changes -

SELECT DateTime, NodeID, NodeName, MAX(Max) AS Max From
(
--SELECT COUNT(Row_ID) AS Max, NodeName, NodeID, Cast(DateTime as date) AS DateTime FROM
SELECT COUNT(Row_ID) AS Max, NodeName, NodeID, REPLACE(CONVERT(VARCHAR(11), DateTime, 106), ' ', '-') AS DateTime FROM
(
SELECT CustomNodePollerStatistics_CustomPollerStatistics."RowID" AS Row_ID,
Nodes.Caption AS NodeName, Nodes.NodeID AS NodeID,
DATEADD(hh, DATEDIFF(hh, GETUTCDATE(), GETDATE()) , CustomNodePollerStatistics_CustomPollerStatistics.DateTime) DateTime
Cancel
Vote Up 0 Vote Down

Cancel
0 Questionario over 13 years ago

I dont quite understand :P
What was the problem and what/how did you fix it?
Cancel
Vote Up 0 Vote Down

Cancel