Is there a published list of states for the "Status" field in the NPM Node database?

I am looking for a list of the various states of the Status field in the NPM database. Currently I have several SQL filters set up on "All Nodes" widgets that specifies Status <> 9, where Unmanaged nodes are not included in the list of Nodes displayed. In one widget, I display a list of nodes that have been down longer than 48 hours and don't want to see Unmanaged nodes in this list either, but even though I have a similar filter "Status <> 9" as part of the SQL filter the Unmanaged nodes are still displayed. Any thoughts or guidance?

Find more posts tagged with

status field

unmanaged nodes

Accepted answers

hpstech

Is this it?

Status values

All comments

hpstech

Is this it?

Status values

mesverrum

You most likely have an OR condition in the query somewhere, whenever i see things that i know I'm explicitly excluding I start double checking my OR's.

There is a table in the db called statusinfo if you ever need to join it in to display statuses in english instead of as codes.

mdbakerusa

Thanks for this answer too. Sorry I had two questions in one post so I can't mark this one correct too, even though it is.

mdbakerusa

Thanks for the quick response. I looked all over for that. Where did you get it from?

hpstech

Whenever I need those or the application status codes I juat google “Thwack component status ID”. And usually they appear in results. I guess a bookmark would be better but you know how it is with guys that use 3 different browsers.