Hi All - i have tried searching on here but cant find it
im after the Node status values i.e
1 =- up
2 = down
9 - Unmanaged
etc can someone help - thanks
VIA AI
AI OverviewIn SolarWinds, node status values are stored in the database as numerical codes. These codes are typically found in tables such as ResponseTime or views within the database schema, like the Orion.Nodes or Orion.ResponseTime SWQL entities. The primary numerical values and their corresponding statuses are:
In SolarWinds, node status values are stored in the database as numerical codes. These codes are typically found in tables such as ResponseTime or views within the database schema, like the Orion.Nodes or Orion.ResponseTime SWQL entities. The primary numerical values and their corresponding statuses are:
0: Unknown
- The current up/down status of the node cannot be determined.
1: Up
- The node is responding to polling requests (e.g., ICMP pings).
2: Down
- The node is not responding to polling requests.
3: Warning
- The node may be responding, but is experiencing packet loss, or a child component (like an interface or volume) has a non-critical issue.
14: Unmanaged
- The node has been manually set to an unmanaged state for maintenance, and data collection has been temporarily suspended.
Other statuses, such as Critical or External, also exist, especially when using the "Enhanced Node Status" calculation feature, which considers the status of various child elements and thresholds. For querying the database, SolarWinds recommends using the SolarWinds Information Service (SWIS) via the Orion SDK for better compatibility with future upgrades, rather than direct SQL queries to the underlying tables. You can use the SolarWinds Database Manager to view database details and perform queries.
Other statuses, such as Critical or External, also exist, especially when using the "Enhanced Node Status" calculation feature, which considers the status of various child elements and thresholds. For querying the database, SolarWinds recommends using the
SolarWinds Information Service (SWIS)
via the Orion SDK for better compatibility with future upgrades, rather than direct SQL queries to the underlying tables. You can use the
SolarWinds Database Manager
to view database details and perform queries.
I also saw this KB. Hope this helps
https://solarwindscore.my.site.com/SuccessCenter/s/article/Component-status-value-definitions?language=en_US
For node status values, I'd recommend you run
SELECT StatusId, StatusName, ShortDescription, Color, IconPostfix FROM Orion.StatusInfo
And you will get them all :-)
Thank you
hi was after a physical list rather than some swql - there was a list on here somewhere but i couldnt find it - many thanjs
Here is a list for you ;-)
StatusID
StatusName
ShortName
Color
IconPostFix
0
Unknown
#999999
unknown
1
Up
#B8D757
up
2
Down
#950000
down
3
Warning
#FEC405
warning
4
Shutdown
#707070
shutdown
5
Testing
#C2C2C2
testing
6
Dormant
7
NotPresent
Not Present
notpresent
8
LowerLayerDown
Lower Layer Down
#FF00A3
updown
9
Unmanaged
#176998
unmanaged
10
Unplugged
#A6DBF8
unplugged
11
External
#9954D4
external
12
Unreachable
#111111
unreachable
14
Critical
#DD2C00
critical
15
PartlyAvailable
Partly Available
#BCBD22
16
Misconfigured
17
Undefined
Could Not Poll
19
Unconfirmed
22
Active
#00A753
24
Inactive
25
Expired
26
MonitoringDisabled
Monitoring Disabled
27
Disabled
disabled
28
NotLicensed
Not Licensed
29
OtherCategory
Other
other
30
NotRunning
Not Running
notrunning
31
Online
32
OnBattery
On Battery
33
OnSmartBoost
On Smart Boost
34
TimedSleeping
Timed Sleeping
sleep
35
SoftwareBypass
Software Bypass
36
Off
#A31770
37
Rebooting
38
SwitchedBypass
Switched Bypass
39
HardwareFailureBypass
Hardware Failure Bypass
40
SleepingUntilPowerReturn
Sleeping Until Power Return
41
OnSmartTrim
On Smart Trim
42
EcoMode
Eco Mode
#A6E7DE
43
HotStandBy
Hot Stand By
44
OnBatteryTest
On Battery Test
45
Missing
missing
Thats what i was after - thank you very much
