msarkar

Hi How can i get sum two different rows in SQL or SWQL like following? I need a query where row1 value will be added with row2 value and generate a new row with different name but same date and keep other Node data as well. /msarkar

in Custom SWQL resource Comment by msarkar February 2018

tdanner Is there any update on 'CHARINDEX' on SWQL? Is it added in any latest release? /msarkar

in SWQL Functions Feeback... Enhancments? Comment by msarkar March 2018

We can post whole message as Trap Deatils using ${Message} in the e-mail body. But is there any such thing to have same in Alert Details Page?

in Custom SQL Alerts based on the SNMP trap message content Comment by msarkar November 2017

m-milligan It works fine when i try the url. /msarkar

in Show us a NOC view and (don't ) get 500 thwack points (we still want to see, points no longer awarded) Comment by msarkar February 2018

mesverrum Is it possible to get value in scale bar like below? /Msarkar

in Custom SWQL resource Comment by msarkar January 2018

tdanner I need the opposite one i.e. convert string to Int. I see in CustomPollerStatus table status is defined as string datatype but i need this value as Int type. BR MSARKAR

in Text colour to display alerts using custom query Comment by msarkar June 2017

right, i start wireshark in polling engine, i saw ping request is going through and getting back response. I can also ssh to the node from Orion web console, but status remain unknown. /msarkar

in Powershell scripts to add a Node Comment by msarkar October 2018

RichardLetts Is there any way to have trap message in Alert Details that caused the alert?

in Custom SQL Alerts based on the SNMP trap message content Comment by msarkar November 2017

tdanner, is there any update on CHARINDEX function on SWQL?

in SWQL Functions Feeback... Enhancments? Comment by msarkar October 2017

m-milligan Everything works fine except status icon breaks up. But i checked path and image is there as well 'localdrive:\inetpub\SolarWinds\Orion\images\StatusIcons\Small-Up.gif' I tried hard coded status icon but no success. SELECT GroupStatusSummary.Name as GroupName, SI.ShortDescription as Status, SI.StatusID as…

in Show us a NOC view and (don't ) get 500 thwack points (we still want to see, points no longer awarded) Comment by msarkar February 2018

kevin.kuhn Do you know any similar page for Network (AT&T,Verizon etc) or Power outage like your weather one? I know the following website but i did not find any animation page for live feed. http://downdetector.com /MSARKAR

in Show us a NOC view and (don't ) get 500 thwack points (we still want to see, points no longer awarded) Comment by msarkar January 2018

yes, here it is: # register specific pollers for the node $poller = @{ NetObject="N:"+$nodeProps["NodeID"]; NetObjectType="N"; NetObjectID=$nodeProps["NodeID"]; } # Status $poller["PollerType"]="N.Status.ICMP.Native"; $pollerUri = New-SwisObject $swis -EntityType "Orion.Pollers" -Properties $poller # Response time…

in Powershell scripts to add a Node Comment by msarkar October 2018

tdanner Is it possible to use CAST in SWQL? /MSARKAR

in Text colour to display alerts using custom query Comment by msarkar June 2017

Is it for single node, right? How about multiple nodes? /MSARKAR

in add node using powershell Comment by msarkar October 2018

tdanner or @stuartwhyte what happened to my case, i just run a simple below query fro example in Custom table resource or custom query resource in Orion it throws me error as follows: select Nodes.NodeiD as Name,Nodes.Status from orion.nodes Nodes where nodes.nodeid=550 union (select Nodes.NodeiD as Name,Nodes.Status from…

in Custom SWQL resource Comment by msarkar October 2017

Exactly. /msarkar

in Show us a NOC view and (don't ) get 500 thwack points (we still want to see, points no longer awarded) Comment by msarkar January 2018

# Connect to SWIS $creds = Get-Credential $swis = Connect-Swis -Credential $creds -Hostname localhost $ip = "10.10.10.2" # add a node $newNodeProps = @{ IPAddress = $ip; EngineID = 15; # SNMP v2 specific ObjectSubType = "ICMP"; #SNMPVersion = 2; DNS = ""; SysName = ""; # === default values === # EntityType = 'Orion.Nodes'…

in Powershell scripts to add a Node Comment by msarkar October 2018

wluther It's my mistake, it is there just need to change orion(v3) from orion(v2).

in Custom Chart in Node Details View of Variable Node Comment by msarkar June 2017

The condition here is like once anyone acknowledge any active alerts from active alert window, it disappear from there and moved to alerts main page as acknowledged. Only way to return the pop up active alert, to clear it that we are expecting to be done automatically. /msarkar

in To clear acknoweldged alert Comment by msarkar July 2020

wluther I did not find "Orion.NPM.CustomPollerStatistics" though. BTW, we are using NPM12.1 and i see only CustomPollerStatus. Attached screenshot5 for reference. Thanks. MSARKAR

in Custom Chart in Node Details View of Variable Node Comment by msarkar June 2017

m-milligan your bull-eye is fantastic and i am able implement it in our system. Do you have any javascript that will create bar chart as well as show status in node icon like the below one where fixed disk usage of a node is 85% in bar scale and node status shows a little yellow square to reflect this. /MSARKAR

in Show us a NOC view and (don't ) get 500 thwack points (we still want to see, points no longer awarded) Comment by msarkar January 2018

I actually try to plot undp poller output in custom chart but datatype of status in custompollerstatus table defined as string type but i need to convert/cast the data as Int type so that i can plot data on chart and analysis the trend of voice traffic. BR MSARKAR

in Does SWQL support CAST function? Comment by msarkar June 2017

In NPM 12.1, there is no issue so far to discover interfaces using broadsoft devices on port 8001. /msarkar

in Vendor SNMP Port 8001 produces no Interface Discovery Comment by msarkar April 2018

It works, thanks. /msarkar

in Is there any way to send traps/alert automatically to respective customer Comment by msarkar May 2018

Even if i deploy second polling Engine with Main Poller, how can we differentiate Network Devices from statistical point of view. Because Main and Second poller will use the same database. Also any events or trap, how would differentiate Network Devices. I also think, NAT could be the best solution in this case?

in How to deploy Network Monitoring for devices with same ip addresses from different network? Comment by msarkar June 2016

no option to search with trapid not trapoid

in Can search Trap using TrapID in TrapViewer? Comment by msarkar November 2017

I have added node using powershell scripts, Node is created in Solarwinds but status remain as unknown even though Poller is sending snmp/ping request and getting response as well. What could be issue? /MSARKAR

in Powershell scripts to add a Node Comment by msarkar October 2018

I tried but failed to get any NetPath.

in About NetPath Comment by msarkar November 2016

c.gura Is it possible to have some details on it?

in Change Row Colors in Reports Comment by msarkar November 2016

Could you please share your modified scripts?

in Using Your Custom HTML Resource To Properly Display SWQL Query Results Comment by msarkar January 2020

msarkar · Tech Support

Comments