aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJan Jansky <jjansky@redhat.com>2020-03-04 17:12:46 +0100
committerJake Hunsaker <jhunsake@redhat.com>2020-03-18 09:57:10 -0400
commit4e30286c2563829b37f95a78584e3c768ed0c5f4 (patch)
treee0232b857e25ef7647a5b010a1c4464f58cf351e
parent9b23b23c2d76a32c3ebeaad68b2c1257dbd4fced (diff)
downloadsos-4e30286c2563829b37f95a78584e3c768ed0c5f4.tar.gz
[foreman] collect smart proxies details
Adding commands which collects smart proxies details. Closes: #1972 Signed-off-by: Jan Jansky <jjansky@redhat.com> Signed-off-by: Jake Hunsaker <jhunsake@redhat.com>
-rw-r--r--sos/plugins/foreman.py6
1 files changed, 5 insertions, 1 deletions
diff --git a/sos/plugins/foreman.py b/sos/plugins/foreman.py
index 9e469283..a533251a 100644
--- a/sos/plugins/foreman.py
+++ b/sos/plugins/foreman.py
@@ -212,7 +212,11 @@ class Foreman(Plugin):
'foreman_settings_table': scmd,
'foreman_auth_table': authcmd,
'dynflow_schema_info': 'select * from dynflow_schema_info',
- 'foreman_tasks_tasks': 'select * from foreman_tasks_tasks'
+ 'foreman_tasks_tasks': 'select * from foreman_tasks_tasks',
+ 'smart_proxies': 'select sp.name, sp.url, ' +
+ 'sp.download_policy,n.ip from smart_proxies ' +
+ 'as sp left join hosts as h on h.name=sp.name ' +
+ 'left join nics as n on n.host_id=h.id'
}
# Same as above, but for CSV output