RogerBevan

Roger, The report works great for most things, what I've noticed however is that when I insert some custom pollers no details appear in the report, even though it's definetly being collected. One of the things that doesn't show up is CiscoFlashDeviceSize - EC378A32-8A13-4B0A-8B5F-2C4215CE707E, would you know why? Is it a…

Hi Dave, Sorry for the delay in responding. I had subscribed to this thread so that I would receive email notification but I didn't get any in my inbox! Anyway, Yes you can add Custom props The simplist way is to add them after the first part of the SQL statement SELECT DISTINCT…

Step 1) Determine CustomPollerAssignment 'PollerIDs' by running the following SQL statement Select * From CustomPollers order by UniqueName Step 2) Near the end of the example SQL script you will see the following WHERE statement WHERE Nodes.SysObjectID = '1.3.6.1.4.1.9.1.516' This determines which nodes you wish to show…

SELECT DISTINCT CustomPollerAssignment_1.NodeID,Nodes.Caption, (SELECT CustomPollerStatus.Status FROM CustomPollerStatus INNER JOIN CustomPollerAssignment ON CustomPollerAssignment.CustomPollerAssignmentID = CustomPollerStatus.CustomPollerAssignmentID WHERE (CustomPollerAssignment_1.NodeID = CustomPollerAssignment.NodeID)…

OK, I have simplified the SQL stement ( a bit) and knocked up a rough guide on how to change my SQL to your requirments You will need to have some kind of SQL knowledge to be able to work it all out. I will post the code next and then the guide cheers

My last post above shows an example SQL report which displays 2 custom node properties and 2 custom poller values. If you can work out my SQL you might be able to mod my SQL code to do what you want. I might play about with my code Today and post a simpler version later

I am experiancing the same problem aprox every 2 days and find it very annoying Looking around then net, I found a VB script solution at the following url http://p2p.wrox.com/archive/windows_2000_help/2002-10/9.asp This solution stops all COM+ instances so would need modding to only stop the Orion module. The problem is…

SELECT DISTINCT CustomPollerAssignment_1.NodeID,Nodes.Plant,Nodes.Subnet,Nodes.Caption, RIGHT( (SELECT CustomPollerStatus.Status FROM CustomPollerStatus INNER JOIN CustomPollerAssignment ON CustomPollerAssignment.CustomPollerAssignmentID = CustomPollerStatus.CustomPollerAssignmentID WHERE (CustomPollerAssignment_1.NodeID =…

You are not on your own, I would also like this feature. The only way I can see this being acheived is by using an SQL based report but I don't think it would be straight forward

Not fixed in version 10.1.2

There was a Beautiful write up on how to report on Custom poller data in post Thanks 'HemiTruck' , glad you found it useful. ---- Regarding your problem trying to compare 2 custom pollers, I would also like to be able to do what you are requesting but have not yet found a suitable solution. I have some computer room…