swinds-ansible-inv

Dynamic Inventory for Solar Winds hosts in Ansible

This python script connects to Solar Winds via rest API to create a dynamic inventory in Ansible. JSON data is pulled into the python script via rest https API call to Orion. Groups are based on 'Vendor'. It pulls the 'IPAddress' for hosts field. The impetus for this script was for network devices. As such, the 'IPAddress' was chosen over say hostname. If one wanted to use anisble for servers with DNS using hostnames, replacing the 'IPAdrress' string to 'SysName' should produce that result. One could also change the 'Vendor' to somethign else like the OS version. I would recommend downloading the SWQL Studio and look under Orion.Nodes table for more options.

Based on the groundwork layed by cbabs, this dynamic inventory script has been totally rewritten aiming primarily for simplicity. All configuration has been moved to swinds.ini.

Usage

swinds.py is a python script that can be executed on any host with python installed.

swinds.ini is the configuration file where servername, username and password are contained. This file must be in the same directory as swinds.py. Moreover, it contains the following:

• hostfields which is a plain list of columns to get from the Nodes table. More items may be added as long as the mandatory ones (sysname, ansible_host) remain in the list.
• groupings which is a list of 'groupings' along with their respective SWQL queries; these are used to create Ansible groups. More groupings may be added given a correct SWQL query. Solarwinds Database Manager will come as great help for constructing new queries.

Any suggestions/code to improve would be awesome.