c.gura

However, if I build a report on a view using Admin Rights to be displayed on users views utilizing SQL, the users should still be able to see the report, but just not be able to edit the SQL if they have report capabilities. It currently shows an error if you don't have Admin Rights. But I can create the exactly same…

bmcmcm​ is upgrading possible with your installation? There are many nice new features with the newest version of the Orion platform.

@msarkar Sure, what kind of details are you wanting?

petr.krcmarik‌ I have opened a Case with SolarWinds. Based on another issue with displaying traps with Account Limitations and using a custom property as the limitation type. I looked into our DB and using the sp_whoisactive discovered the Top X traps query is never returning. Here is the stock SQL Query used in the…

I use Subversion and when I do this I see changes and compare the new file to my custom file and make the changes appropriately, then copy the updated file into production after the upgrade. We learned this the hard way.

stripet To change the message all you have to do is change the message in the Alert Rule. Go to All Settings, then goto the Manage Alerts, then find the Reboot Alert Rule. Edit the Alert, go to the Trigger Actions Edit each of the Actions to change the message. You would change this: Node…

There is a big problem with rewriting things in SWQL from SQL. If you create a custom functions to use in your SQL it is not usable in SWQL.

The error occurs when you do not have Admin rights. Try it out. If you have Admin rights, you can see the View, if you don't have Admin Rights, you get the error.

meech I am booked. Just giving you a preview.

jjrealm45​ I agree. We created a hack to generate an alert based on Traps. We utilize the Auditing Events table and generate alerts based on this information.

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

This sounds like it needs to be an enhancement then.

A workaround that I am doing for now is the following. Note: I had to use the SWQL ExecuteSQL call in order to do this. my $result = $swqldb->run_sql("UPDATE NodesData SET [External] = ". $properties->{External} ." WHERE NodeID = ". $node_info->{nodeid}); my run_sql method does the following: my $payload = [$sql]; my…

@cjfranca, I tried installing the agent manually and the problem still persists. This is on both physical machines and virtual machines. Here is all the application versions: Orion Platform 2015.1.2, SAM 6.2.1, DPA 9.2.0, QoE 2.0, IPAM 4.3, NPM 11.5.2, WPM 2.2.0, IVIM 2.1.0 Here are the versions of the plugins:

This would be a good api, as this information is what we already have in our CMDB and we need to get it over into SolarWinds as well. This is duplicate effort. Is there a way to do this via SQL? I know it wouldn't be supported by SolarWinds, but I am willing to take the risk and work out any changes that may occur on…

@tdanner I am actually doing Checkbox Method. So that is the example I need to know how to pass the values for CheckboxItems. We are making so that depending on the user, they may have views into several different values in the CustomProperty.

And I am getting an error. That it is not able to Acknowledge an Event. I am doing this with Perl here is the code. my $proxy = GMP::Solarwinds::SWQLAccess->new({db=>$page->db, ipaddress => $orion_ip}); my $event_id = 459290; return $proxy->swis->Invoke( 'Orion.Events', 'Acknowledge', [$event_id] ); Here is the error I get…

Thank you, I will try this out. Though I am using Perl I will need to convert the PowerShell to perl.

tdanner I have been able to get the code to work. I am new to ASP.NET and C#. I am trying to access a customer table that we created in SolarWinds. Attached is the modified ascx. Am I referencing everything correctly? If not how do I need to reference this properly? Thank you, Charles

I haven't looked at it, which file are you looking at? I may be able to offer some tips.

I did not realize we could execute raw SQL from SWQL. THANKS A MILLION for revealing this functionality. Nowhere in the documentation does it tell us about this. This helps me tremendously and I don't have to install a Database drivers now everywhere I want to access custom tables we have created.

Thank you very much. That did the trick. I have included a fix for getting a warning for splitqname when $template->type is not defined. 

I know about the pollers and setting those up. I am just trying to set the Node Properties that specify the node is now SNMP. The node properties are not updating. I have other calls to update the node properties that work just fine, but when I try doing this specifically to update the properties to change form ICMP to…

I was able to figure out how to use limitations, but you have to add the limitation to your own query. The query I am doing only handles SQL limitations. If you are utilizing the SWQL calls, then you will need to do the same. The tables to look at are the Limitations table and the Accounts table. Each user can have a…

I would like to know what resources are defined for a specific node id. So I have NodeID = 1 and I want to know which Resources are being monitored for that node.

When you create a custom table view. There is an option to use custom SQL.

I used the SQL query you posted in the NOC View screen for my web report. I then created some a function to create the image link for the icons and built them without Solarwinds options. Then just put this in the query to add the icons as a column: dbo.mine_Icon('/netperfmon/images',RTRIM(Nodes.GroupStatus)) + ' ' +…

How do we force the last boot time to be updated? I have just installed the Agent on several systems but I also have SNMP on others. The last boot doesn't seem to be updating timely. I had a box that was rebooted 12 days ago, but SolarWinds was reporting that it was last booted back in 2014. How can I force this to be…

What resource did you use to utilize the search?

wluther​ you really should check out the SolarWinds Lab. patrick.hubbard​ shows how to create a PerfStack view dynamically. He does this in the alert trigger action to build a link to the exact type of perfstack view you want. This could easily be adapted to create a link on the Node page or other page to take you to the…