madhavan

Hello, To set the credentials for NCM, * For adding credentials for already added node, use “UpdateSelectedNodeColumns” verb and provide values for Username, Password, EnableLevel, EnablePassword,… * You can also create connection profile using “AddConnectionProfile” and update ConnectionProfile property in Nodes using…

Hi, Use the below mentioned query. Here, DAYDIFF(DOWNEVENT.EVENTTIME, GETDATE()) < 30 will filter recent 30 days of data. SELECT NodeName AS [Node Name], '/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name], DetailsUrl AS [_LinkFor_Node Name], DOWNEVENT.EVENTTIME AS [DOWN TIME], (SELECT TOP 1…

Hi, Query provided below can be used to get parent, child group information along with node details. Try and let me know if this solves your need. SELECT Container.Name AS PARENTGROUPNAME, P.NAME AS CHILDGROUPNAME, P.NODEID, P.CAPTIONFROM Orion.ContainerMembersLEFT JOIN Orion.Container on ContainerMembers.ContainerID =…

Hi, This looks strange. can you provide the information service log file. @"C:\ProgramData\Solarwinds\InformationService\v3.0". We can start a private message for this if you need.

Hi, You can run query against Metadata.Verb, Metdata.VerbArguments to see list of verbs for each entity and its necessary arguments. You can also open swql studio, expand an entity and will see the list of supported verbs.

Hi, Get-SwisData $swis "SELECT Name FROM Metadata.Property where EntityName = 'Orion.Nodes'" This should give you all the properties in an entity.

["1"] is a valid JSON. I tested the sample provided and it worked fine for me, try that and let me know if there is any issue.

Hi, Right now there is no guide or document to assist users about mandatory properties when creating via SDK. We do have scripts to help them use SDK. In coming releases this issue will be handled by providing default values for properties which are not provided by the user.

You can find sample scripts in "C:\Program Files (x86)\SolarWinds\Orion SDK\Samples\PowerShell". We have examples for adding nodes and interfaces. Orion.Volumes can be created in the same way with its properties assigned. I have provided an sample powershell script for creating volumes. $Target="localhost" # Connect to…

Hi, In the discovery profile, I made the PreferredSnmpVersion to "None" and removed all the SNMPCredentials. This by default uses ICMP and so can be used as ICMP only profile.

Hi, can you please share your script and product versions with us.

Hi, Try adding 'N.StatusAndResponseTime.ICMP.SendEcho' poller. This poller gets node response time and status. It utilizes ICMP query to find out if node is responding.

Hi, Export and Import verbs are not available in 2015.1.2 version of Orion. It will be part of the next major release. If you have SDK installed, you can open SWQL Studio and expand this entity to see the available verbs, or run the below provided query to get the details. SELECT Name, MethodName, CodeBehind, CanInvoke,…

Hi, Programmatically configuring Asset Inventory is not supported right now. We have an internal ticket to add it as a feature. The ticket number is 348041 if you want to check on status in the future.

Hi, When a subquery is used in from or join clause the query alias and the alias used in the ON condition when joining should be the same (case sensitive). example :: The alias tableAP when used in join ON condition it is used as TableIP. This will be fixed in future releases. Let me know if this solves your issue.

Hi, Server types are just how you are authenticated to connected to Orion Information Service. You can use any type of authentication based on the need and configuration. But provided below the easiest to connect to swql studio. For connecting to local server (if the product is installed there) : Server : localhost Server…

Hi, I faced similar issue when opening the java project on a fresh machine. Some of the jar files are not part of the sdk package. I manually added those jar files and then the project compiled and ran without any issues. Open .classpath file @"C:\Program Files (x86)\SolarWinds\Orion SDK\Samples\JavaClient\" and check if…

Hi, Just be on the same page, you wanted to copy all the nodes from one database to another using the copynodes script but you need to replace Caption and SysName with Name and IPAddress of Orion.Packages.Wireless.AccessPoints for all the nodes. Correct? In that case, in the copynodes.ps1 make the below mentioned changes…

Did you add swissnapin to the current session? If not use the below mentioned command. Add-PSSnapin swissnapin

Hi, You can use client.Update method to update any property. Provided an example below for updating next rediscovery for Orion.Nodes. var properties = new dictionary();properties.Add(new item{key = "NextDiscovery",type = "System.DateTime",value = DateTime.Now.Add(new TimeSpan(1, 1, 0, 0))});…

You can also use DayDiff(IA.DateTime, GetDate()) <= 7 instead of IA.DateTime >= AddWeek(-1, GetDate()) AND IA.DateTime <= GetDate() in WHERE clause.

Hi, To get the details of the newly added WMI node, check if you have the necessary pollers added to it. Adding the below mentioned pollers should work in most of cases: "N.Status.ICMP.Native", "N.ResponseTime.ICMP.Native", "N.Details.WMI.Vista", "N.Uptime.WMI.XP", "N.Cpu.WMI.Windows", "N.Memory.WMI.Windows" Also if you…

Hi, The value of caption is returned correctly by the verb but its type is recognized as XmlElement in powershell. Use $discovered.DiscoveredInterfaces.DiscoveredLiteInterface[0].Caption.InnerText to get the actual value.

Hi, Can you check whether you are using swis v3 endpoint?

Provided below is a sample, modify it according to your need. (I'm not sure about the parameters required for this verb) You need "Newtonsoft.Json.dll" which is JSON helper. It can be used to serialize and deserialize json. HttpWebRequest req =…

Hi, Some details appear after rediscovery of the node. You can check the RediscoveryInterval (which is set to 30 minutes by default) and NextRediscovery to see when the rediscovery will happen. You can also trigger Rediscovery from GUI and see the details. Also NextPoll will give you details on when is the next polling…

Hi, We sure can discover resources via SDK. But what polling method are you using? SNMP or WMI? Also, discovering resources will discover all resources for a node and not in particular like 'Virtual Memory' via SDK. Please let me know if you need more details.

Hi, When you publish under Orion Website, settings of orion website will flow to its child (newly published application). There will be more dependency which should be handled in order to do that. What is the purpose of this new application. My opinion is, not to create a web application under solarwinds orion web site…

Hi, It is the syntax issue. Provided below a sample PS statement for getting query results. You can find more powershell samples @"C:\Program Files (x86)\SolarWinds\Orion SDK\Samples\PowerShell" (Orion SDK installation directory) Get-SwisData $swis "select nodeid, caption from orion.nodes where nodeid = @nodeid"…

Hi, When you are using SWQL, there are relationship defined internally between swql entities and you can use its power to frame queries. As in the example provided below, you can query columns like N.INTERFACES.TRAFFIC.DESCRIPTION where It represents Description of Interface Traffic joining Interfaces joining Nodes in a…