i_like_eggs · Just an egg · ✭✭✭✭✭

hey, this should do the job: create a custom query resource paste the SWQL: select t.name as Alerting_Thresholds,t.level1value AS Warning,t.level2value AS CricitalFROM Orion.Thresholds t INNER JOIN orion.nodes n ON n.nodeid = t.InstanceId Where t.name…

looks like you are looking for a custom table poller Success Center. expected outcomes: unique name would be cpqRackServerBladeStatus and alert would be anything other then '2' { other(1), ok(2), degraded(3), failed(4) }

There are a few ways to do this. You can either poll the information from the device via UNDP and Alert on when the condition changes. To poll the information use the Orion Universal Device Poller application on the Solarwinds servers (You will need to find out what the OIDS are for the Power Supplys, normally on the…

ye, your right there, everyone loves a report i have attached a report i use to send out weekly/ monthly,should give you some ground work on grouping etc.. 

this service is defo stopped right?

You have two things here, the first is NPM. The NPM module will poll data from a SNMP enabled device such as ifInOctets and ifOutOctets OID’s to tell you how much data is passing through the interface. The second is NTA, the NTA module will give you a deeper insight into the traffic, this is done by sending Flow data from…

Hey, when working with the SWQL or SQL you need to join your table on to the the predefined select and from statement. your have to remove your select statement because you will be using two select statements and it will error out. the challenge would be that the current query doesn't have a unique ID of some type so it…

Yo, You will have to set your device to send traps to your application server from here you can create an alert on the trap condition this can be done in the Trap Viewer you can add Alert Actions choose 'send Email' and add the veriables you want to see you can find a list of the variables here SolarWinds Online Help But…

looking over the developer documentation i cant see the volume OID, it might be worth while reaching out to Citrix for the OID? I might have over looked it but have a check: Citrix NetScaler SNMP OID Reference

HI orioncrack​, i have added some additional features hopefully i have answered your question here Volume Report - Fixed Disk - Available - Size - Used - overall volume capacity NEW ** THRESHOLDS ** included

nice question, got me thinking this is some methods id try: send a trap to solarwinds on Windows Server 2008 Event Log SNMP Traps | Question Driven the next would be to use the UNDP device poller and poll the status. Create a Universal Device Poller (UnDP) for a Counter - SolarWinds Worldwide, LLC. Help and Support…

might be a SQL guru out here but you purpose of selecting the top 1 is so you get the top one there are going to be many events for an interface node etc and this is looking at the one at the top

Try this select * from eventtypes filter for events that interfaces can trigger then select * from events whene eventtype = interface eventid lol bit vague but on the train on my phone and dont have access to my db to try these queries lol but when im in the office if this is unanswered by then ill help you out

you can run this quick query select n.Caption AS NODE ,n.IP_Address AS IP_address ,n.Vendor ,MachineType from nodes n where ObjectSubType like 'WMI'

the screenshots were only to illustrate what is available. With the alert you are looking 'High CPU Utilization with Top 10 Processes' 'This alert reports the percentage of CPU usage for Linux/Unix hosts running NET-SNMP as well as Windows devices. It also shows the top ten processes running to help you troubleshoot why…

"When I get an alert that two many resources are being used it would be good to know what is using that resource." I Might not be understanding the question but i think if you select alert you want to go to 'trigger actions' select Email then select insert Variable?

hey, your need the SAM Module for this but its here:

HI @Tdanner but what is the definition? i have done the below and copied a 'definition' from an exciting report but its not quite working have i got the syntax correct? Invoke-SwisVerb $swis Orion.Report CreateReport @("Active Alerts older than 7 days","All alerts 'Active' older then 7…

agh yes thanks, ill use the Notes field of when the update will happen and include that in the report to get the details into the report. would have been cool to have a random field that will allow enter data in a adhoc manor and save to the report but this can work Thanks for your assistance

You will need to add the widget back to the view, its worth mentioning that once you remove the widget it will go back to its default

Who knew a CPU report could have so many veriabels lol

'remote install' didn't see that

jburke​ did you manage to get it to work in the end? if so what did you do? thanks

i have made some updates to this query to include Perfstack charts to pre populate 'Availability' SELECT n.Caption as [Node], n.IP_Address AS [IP Address], c.Detailsurl as [_linkfor_Node] ,n.StatusDescription AS [Status] ,'Availability' as [Availability] ,'/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Node]…

+plus 1 for that. Could be the engineID table or the website table that has the old data still there, removing the old fields and re running the configuration would hopefully do the job, definitely do that with solarwinds assistant

Following on from this, i would suggest trying to remove 'nightly inventory job' from this device if you have this set up or removing the node from NCM if its configured with this modul. I would remove the device from NCM then check back tomorrow

You could actually do the same thing paste the SQL code in to the report but select the 'advanced Database Query (sql,SWQL) paste bam lol

you could reverse the logic here.

I like the syslog idea nice one superfly99​

also a issue for me, do we know of a work around for this?