巡检WINDOWS服务器CPU,内存和磁盘多个分区的PYTHON脚本

接上一次实验的内容,输出相同格式的EXCEL巡检表格

https://blog.csdn.net/lsysafe/article/details/106927633

这次巡检的服务器平台为WINDOWS的机器,从网络调用WMIC接口获取服务器的信息,代码如下:

1. # -*- coding: utf-8 -*-
2. import wmi
3. import sys
4. reload(sys)
5. import xlsxwriter
6. sys.setdefaultencoding('utf-8')
7. import time
10. def trywexrestrdiskp(files):
11. nowtime=time.strftime('%Y-%m-%d-%H-%M-%S',time.localtime(time.time()))+""
12. filenames=nowtime+'systeminfo.xlsx'
13. workbook1 = xlsxwriter.Workbook(filenames)
14. worksheet = workbook1.add_worksheet()
15. t1='自定义WINDOWS服务器运行情况'
16. format=workbook1.add_format()
17. format.set_bold()
18. yellow=workbook1.add_format({'align':'center','valign':'vcenter','font_size':22,'fg_color':'FFC1C1'})
19. yellow.set_bold()
20. worksheet.merge_range('A1:I1',t1,yellow)
21. worksheet.set_row(0, 38)
22. worksheet.set_column("A:A",20)
23. worksheet.set_column("B:B",11)
24. worksheet.set_column("C:C",12)
25. worksheet.set_column("D:D",12)
26. worksheet.set_column("E:E",20)
27. title=[u'IP地址',u'CPU使用率%',u'内存总量M',u'内存使用率%',u'巡检结果']
28. format=workbook1.add_format()
29. format=workbook1.add_format({'align':'center','valign':'vcenter'})
30. format.set_bold()
31. worksheet.write_row('A2',title,format)
32. worksheet.set_row(1, 25)
33. row=2
34. try:
35. myfile=open(files,'r')
36. for line in myfile:
37. con=line.split()
38. h=con[0]
39. u=con[1]
40. p=con[2]
41. try:
42. conn = wmi.WMI(computer=h,user=u,password=p)
43. cu=0
44. cn=0
45. for cpu in conn.Win32_Processor():
46. cl=int(cpu.LoadPercentage)
47. cu=cu+cl
48. cn=cn+1
49. cp=("%0.2f%%" %(cu/cn)) #CPU使用率
50. mcs=conn.Win32_ComputerSystem()
51. mos=conn.Win32_OperatingSystem()
52. mpfu=int(mcs[0].TotalPhysicalMemory)/1024/1024 #内存总量M
53. mfree=int(mos[0].FreePhysicalMemory)/1024
54. um=mpfu-mfree
55. mp=("%0.2f%%" %(100*um/mpfu)) #内存使用率
57. worksheet.write(row,0,h)
58. worksheet.write(row,1,cp)
59. worksheet.write(row,2,mpfu)
60. worksheet.write(row,3,mp)
61. remark="正常"
62. try:
63. # b=round(float(mp))
64. # print b
65. if int(100*um/mpfu)>80:
66. remark="评估是否扩内存" #内存使用率达到80%进行提示
67. except Exception:
68. remark="NONE"
69. worksheet.write(row,4,remark)
71. n=5
72. for disk in conn.Win32_LogicalDisk (DriveType=3):
73. worksheet.set_column(n,n,10)
74. worksheet.write(row,n,"分区 "+disk.DeviceID)
75. worksheet.set_column(n+1,n+1,15)
76. worksheet.write(row,n+1,"分区大小 "+str(int(disk.Size)/1073741824) + "G")
77. worksheet.set_column(n+2,n+2,20)
78. try:
79. du=int(int(disk.Size)-int(disk.FreeSpace))
80. dp=("%0.2f%%" %(100*du/int(disk.Size)))
81. if int(100*du/int(disk.Size))>80:
82. formatmred = workbook1.add_format({'bold': True, 'font_color': 'red'})
83. worksheet.write(row,n+2,"分区使用率 "+dp,formatmred) #磁盘使用率达到80%用红色字体显示
84. else:
85. worksheet.write(row,n+2,"分区使用率 "+dp)
86. except Exception:
88. worksheet.write(row,n+2,"分区使用率无法计算")
89. n=n+3
92. except Exception:
93. print h +" error"
94. worksheet.write(row,0,h)
95. worksheet.write(row,1,"none")
96. worksheet.write(row,2,"none")
97. worksheet.write(row,3,"none")
98. row=row+1
99. except Exception:
100. print "cannot open files"
102. workbook1.close()
105. trywexrestrdiskp("windows.txt")

复制代码

同一目录的windows.txt,写上IP用户名密码,也可以写进数据库再加密读取比较安全

 

运行脚本,输出的格式和上一篇博文CENTOS版本的输出格式一样

主要就是能够支持任意多个分区,每个机器只用一行记录