lll8lll

I am sorry, but I was a bit ahead of myself with the solution. I thought it was as simple as that, but since this user is a database level user without a password, it was not possible to grant it access to other databases. So we found the problem, but have no solution yet. 

Thx to dsimpkins pointing me in the right direction (and absolutely no thanks at all to SW support), I figured it out; The reports are now executed by a new database user that SW has created ; reportingclient. You can verify this by creating a SQL report with; SELECT SUSER_NAME(), USER_NAME(); and preview the result. We…

I did post it in a similar discussion, but I don t find it on the fly, so here is a repost: (You have to change the GUID of the custompollers to the GUID of your own custompollers, as they are assigned by the system when you create a UnDP poller) ***********************************SQL FOR Hardware…

There is no Sensor table, you have to join in the CustompollerStatus table via the CustompollerAsignment table. You see it if you try. Of course first you have to create the Custompollers. You need theese: 1.3.6.1.2.1.99.1.1.1.1 (Sensor units rpm, V etc) 1.3.6.1.2.1.99.1.1.1.1 (Sensor values) 1.3.6.1.2.1.99.1.1.1.6 (Sensor…

You have to do x.NodeID = ${NodeID} because the custompollerID is the same for all nodes. I dont understand what you mean with captions?

That did not work either... I even tried all three macro alternatives i SWQL but none works... Actually SWQL ignores the ${NodeId} part of WHERE (...) AND (<snip>=${NodeId}) and returns all rows. If I use WHERE (CA.CustomPollerID='ABB18B3C-BCB2-473D-AC66-24BED1C8C799') AND (CA.NodeID=${N=SwisEntity;M=NodeID}) I get "Query…

Thx, that was useful. As long as I can do icons I can do without html parsing :-)

Thx for the example, It works fine if I paste it into a Custom Query, but I get 'Query not valid' if I paste it into a SWQL datasource in a Custom table. I have also tried the following query: SELECT Caption FROM Orion.Nodes WHERE NodeID=${NodeId} This works fine, and returns the caption of the active node if I use it in a…

Thx, but that doesnt work either. I just get "Query not valid" no matter where in my SQL I put ${NodeId} or ${ID}.

No I dont mind :-)

Yes you do, and it is very annoying, because it has never worked, and probably never will, as it is not the way hardware MIBs are implemented on ASA. People have asked Solarwinds to support ASA for many many years, but you keep blaming cisco. ASA use 1.3.6.1.2.1.99.1.1.1.1 - entPhySensortype We monitor our ASA hardware…

Well, that was extremely unfortunate... Then as far as I can see there is no way I can make a nice table with icons and html text to present a summary of UnDP pollers....

Hi, Could you please change my username to lll8lll ? Thanks :-)

The only workaround is to use UnDP pollers, and create a custom view for the information. I ended up with using a Custom Query resource. The SQL for the Custom query is here: SELECT Sensor_Names.Value as Name, CASE Sensor_Type.value WHEN 10 THEN ToString(Sensor_Values.Value + ' Rpm') WHEN 12 THEN CASE Sensor_Values.Value…

I dont think this problem is due to new code, although I havent checked which system OID the ASA returns.... I am not sure which context I am monitoring (I am polling the admin context, but it returns things like powersupply and fan status which is obviously the box itself). I can see all the hardware sensors in the…

Well, that was extremely unfortunate... Then as far as I can see there is no way I can make a nice table with icons and html text to present a summary of UnDP pollers....

I installed SWQL Studio, and now it is as easy to make SWQL queries as it is to make SQL queries :-) As for Custom resources: SWQL queries seems nice for plain tables, however I do not see that I can get icons and interpret html with them as I can with Custom Tables. My main question remains though; No matter what I try I…

Hi, The view type is Node Details If I click on use curent node as datasource I loose my SQL... If I deselect it, I get my SQL back (Advanced database Query with SQL selected) and if I replace my hardcoded node ID with ${Nodeid} in the WHERE clause I get "Query not valid"... I probably would be better off learning SWQL. I…

Under Settings you have "Manage Views" here you can create new views (i.e. a copy of the standard summary view but with the CustomQuery) Under "Views by Device Type" you can select the standard view for each device type. NOTE: We just upgraded to NPM 12.01 and I see now that after the upgrade, the menu on the "Manage…

Your welcome :-) I created a seperate view for ASA in order to avoid the customQuery to show on all nodes.

Cisco ASA has its own MIB for hardware (CISCO-ENTITY-SENSOR-EXT-MIB) But Solawinds do not want to support it.

My context is a "custom table" on a "Node Details" View.

I have for days to create custom hardware sensors, and as far as I can see it is not possible. This is very dissapointing, and I hope Solarwinds do something about it. Much of the point in having the system is to monitor the hardware health of our devices. I have tried to poll the hardware sensors with UnDP pollers. I get…

Is there any other _ (underscore) features other than _IconFor an _LinkFor ?