c.gura

>So a manual set to NULL and rediscover updates this, but a rediscover alone does not? Yes. It does not update with a rediscover. Then when I set it to null. The value gets updated automatically with no rediscover action. > Any other 'symptoms' that you can note? If you looked through any log files, are these nodes showing…

Then when I look in the Nodes table, why does the Nodes.Description field be NULL for all devices that are added with the API, but those nodes added through the GUI are populated with empty string which allows the Node Details to display?

wluther​ Those graphs are created outside of SolarWinds altogether and are in our custom proprietary perl code. I may be able to put together the resulting html to give you some ideas. It will take me some time to do that though, as I am swamped. - Charles

I can't change the report from SQL to SWQL. I have MS SQL functions created and they are not accessible via SWQL.

Thank you, I have opened a Support Case and I have added your suggestion as well.

I figured it out. I needed to Import this in order to get the NodeID <%@ Import Namespace="SolarWinds.Orion.NPM.Web" %>

Let me ask this a different way? If I have a node, Solarwinds defines how performance data can be collected, it then stores that information in some table which specifies the type of data to collect. I would assume that table has a Resource ID associated to the collection definition so that it can then be displayed on the…

Here is an example of the view I created.

stripet I understand, but you can change the NetPerfMon Event Message in the Trigger Action. Look here: Edit the NetPerfMon Event Log: Change the Message and Save the Changes. This will change the message in the NetPerfMmon Event Message. -Charles

tdanner, I am using the REST calls and JSON with Perl. How do I need to create my JSON for the REST call for creating a Orion.Container with the defintions?

I get the same response: my $node_alerts = \SOAP::Data->name('ArrayOfAlertInfo')->attr({xmlns=>'http://schemas.solarwinds.com/2008/Orion'})->value( SOAP::Data->name('AlertInfo')->value( SOAP::Data->name('DefinitionId')->type('')->value($alertDefId), SOAP::Data->name('ObjectType')->type('')->value('Node'),…

This did not help either. We are using the Agent as active and it is communicating back to Orion so port 17778 is what is used. 

I am actually passing an array I just had one element in the array. Here is the error with two elements in the array. 2014-04-04 15:50:48,469 [98] ERROR SolarWinds.InformationService.Core.InformationService - Exception for Operation: <soap:Envelope…

I got your original code to work. But my code is not working. Not sure why. It should have been a custom table not customer table.

@tdanner Thank you exactly what I was needing.

@tdanner I realize this, and I actually take the upgrade scenarios into my design. That is why I create custom Views and create my SQL based off of the views rather than the tables. Then if the schema changes all I have to do is update my View. How do I do the call using REST I have the Invoke portions? I just need to know…

You would have to play around with it. based on what I see the grid variable is defined somewhere. maybe there is a way to create a secondary variable like grid2 or something. It isn't anything I have done yet. You might try to create a view that returns the data in the columns you are expecting. SQL Server should allow…

I make changes to the node properties. I then make changes to the pollers. It is not done in the same call, as it is a different URI call and table that is updated.

shawn.schiebrel What are the results of running the SQL from SW Support?

You will have to add those functions to the database through the backend.

You can but you have to add it view the Customize Page. Then select the add Resource and Go to the Reporting Category and select the Custom Table resource. Then on the page select to Customize the Report. The add the SQL as a Datasource.

But if they uses QueryXML how would the =>0 work? Whenever I use a > or < for a QueryXML request with Perl, I get an error that it doesn't know how to handle &lt and &gt. Charles

I have actually opened a ticket with tech support, and they are raising the issue with Development. I know it is not ordering, as this worked with the previous version prior to NPM 11.

On the details page the last boot is not updated either it is the same value. The performance information is updated and showing current. It looks like it is the last boot that is not updating. When I set the last boot to null, the value gets updated to the correct value.

@mwb Wonderful?! I haven't really worked on this in a while, we ended up doing an alternate solution. I would need to go back and see what I did and update what was done.

Here is a Message Center mod I did, you could probably glean some tips from this mod. NPM 12 Message Center mod

I had to create a custom asp file utilizing SQL. The relationship to the provisioning system is done utilizing the CP fields. I have a synchronization cron job that keeps the Node CP fields synchronized between Solarwinds and the provisioning system. I even pull the raw data out of SolarWinds and utilize our own Highcharts…

">nickzourdos, Could you provide the Custom HTML you used for the Iframe to get it to display. I need to do the same thing. Thanks Charles

tdanner​ Is there any other possible work around? I have code throughout customer integration scripts and finding exactly which fields are date fields would be difficult. Could I potentially change all fields to just return ToString(), as I am doing these calls via perl? example: SELECT TOP 10 ToString(NodeID) AS NodeID,…

OK, so now after several installs and uninstalls of the agent, the Hardware Monitoring is working. However, I am still unable to get any Routing or Topology information.