In order to check what level your clients are, your can run a simple select:

select node_name, -
cast (client_version as char)||'.'||-
cast (client_release as char)||'.'||-
cast (client_level as char)||'.'||-
cast (client_sublevel as char (2))-
CLIENT_LVL from nodes

Sometimes when you upgrade the server, you need a minimum level of client. Like the 6.1 server requires all clients to be at 5.5 or higher. To just see what clients are below a certain level, you can run:

select node_name, -
cast (client_version as char)||'.'||-
cast (client_release as char)||'.'||-
cast (client_level as char)||'.'||-
cast (client_sublevel as char (2))-
CLIENT_LVL from nodes where -
cast (client_version as char)||'.'||-
cast (client_release as char)||'.'||-
cast (client_level as char)||'.'||-
cast (client_sublevel as char (2))-
< '5.5.0.0'
{"id":456,"date":"2010-02-26T16:25:46","date_gmt":"2010-02-26T20:25:46","guid":{"rendered":"http:\/\/patrickv.info\/wordpress\/?p=456"},"modified":"2010-02-26T16:25:46","modified_gmt":"2010-02-26T20:25:46","slug":"check-tsm-client-levels","status":"publish","type":"post","link":"https:\/\/rootuser.ninja\/index.php\/2010\/02\/26\/check-tsm-client-levels\/","title":{"rendered":"Check TSM Client Levels"},"content":{"rendered":"

In order to check what level your clients are, your can run a simple select:<\/p>\n

select node_name, -\ncast (client_version as char)||'.'||-\ncast (client_release as char)||'.'||-\ncast (client_level as char)||'.'||-\ncast (client_sublevel as char (2))-\nCLIENT_LVL from nodes<\/pre>\n
<\/code><\/p>\n
Sometimes when you upgrade the server, you need a minimum level of client.  Like the 6.1 server requires all clients to be at 5.5 or higher. To just see what clients are below a certain level, you can run:<\/p>\n
select node_name, -\ncast (client_version as char)||'.'||-\ncast (client_release as char)||'.'||-\ncast (client_level as char)||'.'||-\ncast (client_sublevel as char (2))-\nCLIENT_LVL from nodes where -\ncast (client_version as char)||'.'||-\ncast (client_release as char)||'.'||-\ncast (client_level as char)||'.'||-\ncast (client_sublevel as char (2))-\n< '5.5.0.0'<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":null,"protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,1],"tags":[],"class_list":["post-456","post","type-post","status-publish","format-standard","hentry","category-tsm-notes","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/rootuser.ninja\/index.php\/wp-json\/wp\/v2\/posts\/456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootuser.ninja\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootuser.ninja\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootuser.ninja\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootuser.ninja\/index.php\/wp-json\/wp\/v2\/comments?post=456"}],"version-history":[{"count":0,"href":"https:\/\/rootuser.ninja\/index.php\/wp-json\/wp\/v2\/posts\/456\/revisions"}],"wp:attachment":[{"href":"https:\/\/rootuser.ninja\/index.php\/wp-json\/wp\/v2\/media?parent=456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootuser.ninja\/index.php\/wp-json\/wp\/v2\/categories?post=456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootuser.ninja\/index.php\/wp-json\/wp\/v2\/tags?post=456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}