Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

What does 1, 2,3,4,5,6,7 etc represent on "interfaces report" under "admin status" op status mean?

on the Orion Interfaces report, I have the below some values are 1&2, others 3& 4.

What do these values represent? Search around and couldn't find a legend of what they mean.

Admin Status	Operational Status
1	1
1	1
2	2
1	1
1	1
1	1
2	2

1	2
3	4
1	2
3	4
1	2
3	4

Find more posts tagged with

Reports

Accepted answers

All comments

KMSigma.SWI

I never know this information, so I always go back to a query that helps me.

SELECT TOP 1000 [I].FullName
     , [I].UnPluggable
     , [I].AdminStatus
     , [I].AdminStatusLED
     , [I].Status
     , [I].StatusDescription
     , [I].OperStatusLED
     , [I].StatusLED
FROM Orion.NPM.Interfaces AS [I]

Then I look at the Admin Status numbers and the Status numbers and do a cross-reference.

Sometimes the information is in Orion.StatusInfo, but that's not always 100% valid for non-up/down status information.

jdoug

thanks for the info. But I don't have access to SWQL. trying to get a rough idea of what ports are up/down or admin down. anyplace else this data is available? Our Orion is base with just NCM, nothing else.

LeBeauUK

Picked up from SQL on StatusInfo:

so

1 - 1 is Up Up

2 - 2 is Down Down

3 - 4 Warning Sutdown

#	Status
0	Unknown
1	Up
2	Down
3	Warning
4	Shutdown
5	Testing
6	Dormant
7	NotPresent
8	LowerLayerDown
9	Unmanaged
10	Unplugged
11	External
12	Unreachable
14	Critical
15	PartlyAvailable
16	Misconfigured
17	Undefined
19	Unconfirmed
22	Active
24	Inactive
25	Expired
26	MonitoringDisabled
27	Disabled
28	NotLicensed
29	OtherCategory
30	NotRunning
31	Online
32	OnBattery
33	OnSmartBoost
34	TimedSleeping
35	SoftwareBypass
36	Off
37	Rebooting
38	SwitchedBypass
39	HardwareFailureBypass
40	SleepingUntilPowerReturn
41	OnSmartTrim
42	EcoMode
43	HotStandBy
44	OnBatteryTest
45	Missing

@jdoug do you have access to create your own dashboard? If so you could create a widget on a dashboard and post the SWQL (don't get that confused with SQL) that @KMSigma.SWI posted in to that. Another option is to get the SWQL Studio if your company allows you to install it - GitHub - solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in PowerShell, C#, Go, Perl, and Java.

SELECT TOP 1000 InterfaceDescription
        , AdminStatus
        , OperStatus 
FROM NCM.Interfaces

If you can edit the SWQL that is behind the table that you are showing above then the SWQL that I have provided will given you the word status rather than number:

KMSigma.SWI

This data is stored in the code so it can change version to version - which is why I make the query via SWQL.

And if you can create a report, you can run SWQL.

Create a new report, select a custom table, use Advanced Query (SWQL).

KMSigma.SWI

But this isn't a 1:1 for Admin Status or Operational Status.

KMSigma.SWI

I should add that SWQL Studio does NOT need to be installed on the server. It's designed for workstation installs. See [mention:988f674088944a53a6ce2b0e40c8d246:6b577b8c04704e209d29b6772bf67243] for more details on the tool.