Python3 脚本:脚本里需要定义模板名称
import json
import requests
from openpyxl import Workbook
from openpyxl.styles import Font, Alignment, Side, Border, PatternFill
import os
import logging
class ZabbixApi:
def __init__(self): # 初始化信息
self.url = 'http://192.10.xxx.xxx/api_jsonrpc.php'
self.user = 'Admin'
self.passwd = 'zabbix'
self.header = {
'Content-Type': 'application/json-rpc',
'User-Agent': 'python/pyzabbix',
'Cache-Control': 'no-cache'
}
def UserLogin(self): # api登录操作
data = {
"jsonrpc": "2.0",
"method": "user.login",
"params": {
"user": self.user,
"password": self.passwd
},
"id": 0,
}
return self.UrlRequest(data)
def UrlRequest(self, data): ##
request = requests.post(url=self.url, data=json.dumps(data), headers=self.header, verify=False)
response = json.loads(request.text)
return response['result']
def GetHost(self, template):
data = {
"jsonrpc": "2.0",
"method": "template.get",
"params": {
"output": ['name'],
"filter": {
"host": template
},
"selectHosts": ['name']
},
"auth": token,
"id": 1
}
return self.UrlRequest(data)
def writeExcel(self, fileName, ZabbixData):
WorkBook = Workbook()
Sheet = WorkBook.active
Sheet.title = 'HostInfo'
TableTitle = ['Template_name',"Host_name"]
TitleColumn = {}
AllHostItemValues = {}
for row in range(len(TableTitle)):
Col = row + 1
Column = Sheet.cell(row=1, column=Col)
Column.value = TableTitle[row]
# TitleCol = Column.coordinate.strip('1')
# TitleColumn[TableTitle[row]] = TitleCol
# 整理Zabbix 监控数据逐行写入到表格中
for hostinfo in ZabbixData.values():
num = len(hostinfo)
for i in range(num):
HostItemValues = []
HostItemValues.append(hostinfo['name']) # 模板名称
HostItemValues.append(hostinfo['hosts'][i]['name']) # 主机名称
AllHostItemValues[i] = HostItemValues
# 将所有信息写入到表格中
for HostValue in range(len(AllHostItemValues)):
Sheet.append(AllHostItemValues[HostValue])
print(AllHostItemValues[HostValue])
############ 设置单元格样式 ############
# 字体样式
TitleFont = Font(name="宋体", size=12, bold=True, italic=False, color="000000")
TableFont = Font(name="宋体", size=11, bold=False, italic=False, color="000000")
# 对齐样式
alignment = Alignment(horizontal="center", vertical="center", text_rotation=0, wrap_text=True)
# 边框样式
side1 = Side(style='thin', color='000000')
border = Border(left=side1, right=side1, top=side1, bottom=side1)
# 填充样式
pattern_fill = PatternFill(fill_type='solid', fgColor='99ccff')
# 设置列宽
column_width = {'A': 25, 'B': 25, 'C': 25, 'D': 25, 'E': 25, 'F': 16, 'G': 18, 'H': 18, 'I': 22, 'J': 22,
'K': 23,
'L': 15, 'M': 16, 'N': 16, 'O': 14, 'P': 16}
for i in column_width:
Sheet.column_dimensions[i].width = column_width[i]
# 设置首行的高度
Sheet.row_dimensions[1].height = 38
# 冻结窗口
Sheet.freeze_panes = 'A2'
# 添加筛选器
Sheet.auto_filter.ref = Sheet.dimensions
# 设置单元格字体及样式
for row in Sheet.rows:
for cell in row:
if cell.coordinate.endswith('1') and len(cell.coordinate) == 2:
cell.alignment = alignment
cell.font = TitleFont
cell.border = border
cell.fill = pattern_fill
else:
cell.font = TableFont
cell.alignment = alignment
cell.border = border
WorkBook.save(filename=fileName)
print('Create Yes!')
if __name__ == '__main__':
zapi = ZabbixApi()
token = zapi.UserLogin()
print(f'身份令牌为"{token}"')
template = 'Template App Zabbix Server' ### 定义模板名称的参数
zabbixDict = {}
zabbixData = zapi.GetHost(template)
fileName = os.path.join(os.getcwd(), "Hosts" + f'({template})' + '.xlsx')
print(fileName)
for info in zabbixData:
hostid = info['hosts'][0]['hostid']
zabbixDict[hostid] = info
zapi.writeExcel(fileName, zabbixDict)