i_like_eggs · Just an egg · ✭✭✭✭✭

lol not sure how much help ill be here i don't have SQL db to hand and iv not encountered this problem off to a good start but ill try my best to help. what id do in your case is rebuild the statement and see what it is getting caught but firstly can you run the query in your db? and can you query the table a with no other…

The Swap space is located in the Orion.volumes table here is a snippet: SELECT hc.Caption, HC.TotalMemory, hc.cpuload, hc.cpucount, HC.PercentMemoryUsed, c.avgpercentmemoryused, c.DateTime, c.avgload, c.MaxLoad, c.minload, c.MaxMemoryUsed, c.avgmemoryused, c.minmemoryused ,V.VolumePercentUsed ,V.DisplayName FROM…

here you can find the relationships scroll down check the join clause Advanced Custom SQL Alert with UnDP

Hi, Recently I did a database migration to a new VM and didn't need to export UNDP pollers, the pollers just migrated with the database and were still assigned to the same nodes\interfaces after i hooked the new solarwinds modules up to the previous database

hey. Something like this? your need to create a custom query resource. and paste the below. sure you can group device or vendor etc.. SELECT I.MAC AS [MAC ADD], N.Caption AS [NODE], Alias as Description, IfName AS [PORT] FROM Orion.NPM.Interfaces i INNER JOIN ORION.Nodes N ON I.NodeID = N.NodeID WHERE ( N.Caption LIKE…

Why don't you just simply get SolarWinds Alert Central point both instances at Alert Central, now you have one single pane of glass for all alerts from both instances?

hey, i think they only issue with selecting the fields was because you needed the Orion.NodesCustomProperties table, try this: # Parameters $orionServer = "localhost" $orionUsername = "user" $orionPassword = "password" #Get snapin if (! (Get-PSSnapin | where {$_.Name -eq "SwisSnapin"})) { Add-PSSnapin "SwisSnapin" } #…

Cheers silverbacksays​, ill go through the logs see whats getting written to them, if i come across any documents ill be sure to post back here

This thread is extreamly informative good work

im on my phone at the monent lol. everything joins primarily throuh the nodeid i cant test the follwoing query but heres the idea SELECT top 100 (*) FROM nodedata ND INNER JOIN nodes statistic NS ON ND.nodeID = NS.nodeID Im just slecting top 100 here beacuse this could be a huge query.

HI, The NCM_Nodes tables contains a list of nodes that have been set up to allow managing of configurations here is the NCM guide that will exaplin what NCM does in great detail. http://www.solarwinds.com/documentation/orionNCM/docs/orionNCMAdministratorGuide.pdf​ The nodes table contains everything you monitor with your…

i have tried to answer your question here Transient,Reserved,Used IP address - IPAM

You can try here: Alerts · solarwinds/OrionSDK Wiki · GitHub

Just a quick one do you have the 'settings' in the top right? you will need admin privileges to set this alerts

Also there are some built in Alerts that are already created for you in managed Alert like you said, you might not find what you need but you can tweek these alerts to your liking

you could use this Query i have put together just create a new report and add the below SWQL, you may want to change the headers. this query will retive the the last 24 hours worth of logs that contain the message 'snow' SELECT s.Hostname as [OBJECT], '/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_OBJECT],…

Unfortuntatly i dont have the IPAM module installed so i cant test, but i can see where you may be going wrong here, the alert trigger condtion when using custom SQL you need to 'Join' your condition on to the pre populated SELECT. so something like this: INNER JOIN IPAM_Node n ON IPAM_NOdeReportView.IPNodeId…

Thank you cvachovecj​​

Thank you Maria ill keep a close eye on this

try this out it will check for Acknowledged but i couldn't get the Lastchange status in the OSPF for 60 hours this is because i am using SQL and not SWQL. (i just prefer SQL interface and flexibility) this is what the alert looks like: Raw SQL: SELECT *FROM NPM_RoutingNeighbor_V JOIN NPM_RoutingProtocol RP ON…

Damn would have been good to answer this at work ill take a look for you tomorrow essentually you want to join the alertstatusview on this has a colloum acknowladged you want to set this as an additional check in your where clause to be acknowledge = 1. 0 being unacknowledged.

yea its a staged upgrade process each one is dependent on the other 12.1 is cool btw

can you show me where the serial numbers are you want to see on the report?

HI, You might find that you dont retain that amount of Syslog messages the default from SolarWinds is 7 Days. To check just click Settings > Polling Settings and i wouldn't recommend increase depending on Hard drive space ect.. but then again depends on your retention policy if i did have all that data i would first start…

Iv not actually used PagerDuty but looks good, i was thinking without testing or using this before, ill give it a go. You have the PDIntegrationKey witch is a custom property you could duplicate and change the select. { "service_key": "${SQL: SELECT Nodes.PDIntegrationKey FROM Nodes WHERE NodeID='${NodeID}'}",…

NTA has recently migrated from a FastBit database to MS-SQL, the alerting i think you are looking for is only available on the SQL database NTA compatible version. i am still on 4.2.2 and the alerting in this version is quite limited. Here are the specific alerts out of box with the newer version: NetFlow-specific…