Bluemix-Infra(SoftLayer)のデバイスのユーザー名とパスワードを一覧表示するスクリプト

#内容
Bluemix Infrastructure (旧SoftLayer)のデバイス（ベアメタルや仮想サーバー）のユーザー名とパスワードを、毎回ポータルにアクセスするのも煩わしくなってきたので、コマンドで一覧表示できるスクリプトをつくりました。

#参考記事
ShinobiLayer: Virtual Serverの作成者や稼動ホストのRack/Slot情報を確認するスクリプト - Qiita

#スクリプト

getDevicesTable.py

import SoftLayer
import dateutil.parser
from prettytable import PrettyTable

# account info
client = SoftLayer.create_client_from_env()

objectmask_vitualGuests = """
	id,
	virtualGuests[
		id,
		notes,
		provisionDate,
		fullyQualifiedDomainName,
		primaryBackendIpAddress,
		primaryIpAddress,
		datacenter[
			longName
		],
		operatingSystem[
                        softwareLicense[
                                softwareDescription[
                                        name
                                ]
                        ],
                        passwords[
                                username,
                                password
                        ]
                ]
	]
"""

objectmask_hardware = """
	id,
	hardware[
		id,
		notes,
		provisionDate,
		fullyQualifiedDomainName,
		primaryBackendIpAddress,
		primaryIpAddress,
		datacenter[
			longName
		],
		operatingSystem[
			softwareLicense[
				softwareDescription[
					name
				]
			],
			passwords[		
				username,
				password
			]
		]
	]
"""

vg = client['Account'].getObject(mask=objectmask_vitualGuests)
hw = client['Account'].getObject(mask=objectmask_hardware)

virtualGuests=vg.keys()[0]
hardware=hw.keys()[0]

table = PrettyTable([
	'Device Name',
	'Device Type',
	'Location',
	'Public IP',
	'Private IP',
	'Start Date',
	'OS Name',
	'Username',
	'Password'])

for key in range(len(vg['virtualGuests'])):
	for key2 in range(len(vg['virtualGuests'][key]['operatingSystem']['passwords'])):
		table.add_row([
			vg['virtualGuests'][key]['fullyQualifiedDomainName'],
                	virtualGuests,
			vg['virtualGuests'][key]['datacenter']['longName'],
			vg['virtualGuests'][key].get('primaryIpAddress'),
			vg['virtualGuests'][key]['primaryBackendIpAddress'],
			dateutil.parser.parse(vg['virtualGuests'][key]['provisionDate']).strftime('%Y/%m/%d'),
			vg['virtualGuests'][key]['operatingSystem']['softwareLicense']['softwareDescription']['name'][:16],
			vg['virtualGuests'][key]['operatingSystem']['passwords'][key2]['username'],
			vg['virtualGuests'][key]['operatingSystem']['passwords'][key2]['password']
		])
for key in range(len(hw['hardware'])):
	for key2 in range(len(hw['hardware'][key]['operatingSystem']['passwords'])):
	        table.add_row([
        	        hw['hardware'][key]['fullyQualifiedDomainName'],
        	        hardware,
        	        hw['hardware'][key]['datacenter']['longName'],
			hw['hardware'][key].get('primaryIpAddress'),
        	        hw['hardware'][key]['primaryBackendIpAddress'],
        	        dateutil.parser.parse(hw['hardware'][key]['provisionDate']).strftime('%Y/%m/%d'),
			hw['hardware'][key]['operatingSystem']['softwareLicense']['softwareDescription']['name'][:16],
			hw['hardware'][key]['operatingSystem']['passwords'][key2]['username'],
			hw['hardware'][key]['operatingSystem']['passwords'][key2]['password']
        	])

print(table)

#実行結果の例

+-----------------------------------------------+---------------+----------+-----------------+---------------+------------+------------------+-----------------------------+---------------+
|                  Device Name                  |  Device Type  | Location |    Public IP    |   Private IP  | Start Date |     OS Name      |           Username          |    Password   |
+-----------------------------------------------+---------------+----------+-----------------+---------------+------------+------------------+-----------------------------+---------------+
| xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.vsphere.local | virtualGuests | Tokyo 2  |       None      | 10.133.xx.xxx | 2016/10/26 | Windows 2012 R2  |        Administrator        |    xxxxxxxx   |
|            win2012r2.softlayer.com            | virtualGuests | Tokyo 2  |  161.202.xxx.xx | 10.132.xx.xxx | 2016/05/09 | Windows 2012 R2  |        Administrator        |    xxxxxxxx   |
|              esx01.softlayer.com              |    hardware   | Tokyo 2  |  161.202.xxx.xx | 10.132.xx.xxx | 2016/04/19 | Customer Install |             root            |   xxxxxxxxx   |
|              esx02.softlayer.com              |    hardware   | Tokyo 2  |  161.202.xxx.xx | 10.132.xx.xxx | 2016/04/19 | Customer Install |             root            | xxxxxxxxxxxxx |
|             vyatta01.softlayer.com            |    hardware   | Tokyo 2  | 161.202.xxx.xxx | 10.132.xx.xxx | 2016/04/08 | Vyatta Subscript |             root            |    xxxxxxxx   |
|             vyatta01.softlayer.com            |    hardware   | Tokyo 2  | 161.202.xxx.xxx | 10.132.xx.xxx | 2016/04/08 | Vyatta Subscript |            vyatta           |    xxxxxxxx   |
+-----------------------------------------------+---------------+----------+-----------------+---------------+------------+------------------+-----------------------------+---------------+