查看vcenter中虚拟机的快照情况
pip安装版本信息
pip install pyvim pyvmomi
pip install pandas openpyxl
代码：
# -*- coding: utf-8 -*- import pandas from pyvim import connect from pyVmomi import vim import json class VcenterApi(object): def __init__(self, host, user, pwd): self.si = connect.SmartConnect(host=host, user=user, pwd=pwd, disableSslCertValidation=True) self.content = self.si.RetrieveContent() datacenter = self.content.rootFolder.childEntity[0] self.datacentername = datacenter.name # print(self.datacentername) def get_cluster_list(self): """ 获取所有机器资源使用情况 1。CPU 2。内存 3。磁盘 :return: """ # 获取集群视图 objview = self.content.viewManager.CreateContainerView(self.content.rootFolder, [vim.ComputeResource], True) # 获取集群对象 clusters = objview.view # 销毁视图 objview.Destroy() redata = [] for cluster in clusters: summary = cluster.summary cpuusage = 0 memusage = 0 vmcount = 0 for host in cluster.host: # print "主机已使用cpu", host.summary.quickStats.overallCpuUsage # print "主机已使用内存", host.summary.quickStats.overallMemoryUsage cpuusage += host.summary.quickStats.overallCpuUsage memusage += host.summary.quickStats.overallMemoryUsage vmcount += len(host.vm) totaldatastore = 0 datastorefree = 0 for datastore in cluster.datastore: totaldatastore += datastore.summary.capacity datastorefree += datastore.summary.freeSpace # print("---------------------------------") # print "集群名称：", cluster.name # print "集群状态：", summary.overallStatus # print "总主机数：", summary.numHosts # print "vm数量：", vmcount # print "cpu颗数：", summary.numCpuCores # print "总cpu：%.2f GHz" % (summary.totalCpu / 1000.0) # print "已使用cpu: %.2f GHz" % (cpuusage / 1000.0) # print "总内存：%.2f GB" % (summary.totalMemory / 1024 / 1024 / 1024.0) # print "已使用mem: %.2f GB" % (memusage / 1024.0) # print "总存储: %.2f T" % (totaldatastore / 1024 / 1024 / 1024 / 1024.0) # print "可用存储: %.2f T" % (datastorefree / 1024 / 1024 / 1024 / 1024.0) clusterdata = { "clustername": cluster.name, "overallstatus": summary.overallStatus, "numhosts": summary.numHosts, "numcpucores": summary.numCpuCores, "cputotal": "%.2f GHz" % (summary.totalCpu / 1000.0), "cpuusage": "%.2f GHz" % (cpuusage / 1000.0), "memtotal": "%.2f GB" % (summary.totalMemory / 1024 / 1024 / 1024.0), "memusage": "%.2f GB" % (memusage / 1024.0), "totaldatastore": "%.2f T" % (totaldatastore / 1024 / 1024 / 1024 / 1024.0), "datastorefree": "%.2f T" % (datastorefree / 1024 / 1024 / 1024 / 1024.0), "vmcount": vmcount, "datacentername": self.datacentername, } redata.append(clusterdata) return redata def print_vm_info(self, virtual_machine): """ Print information for a particular virtual machine or recurse into a folder with depth protection """ summary = virtual_machine.summary if summary.guest.ipAddress: return self.count += 1 print "Name : ", summary.config.name print "Template : ", summary.config.template print "Path : ", summary.config.vmPathName print "Guest : ", summary.config.guestFullName print "Instance UUID : ", summary.config.instanceUuid print "Bios UUID : ", summary.config.uuid annotation = summary.config.annotation if annotation: print "Annotation : ", annotation print("State : ", summary.runtime.powerState) if summary.guest is not None: ip_address = summary.guest.ipAddress tools_version = summary.guest.toolsStatus if tools_version is not None: print("VMware-tools: ", tools_version) else: print("Vmware-tools: None") if ip_address: print("IP : ", ip_address) else: print("IP : None") if summary.runtime.question is not None: print("Question : ", summary.runtime.question.text) print("") def get_all_vm(self): self.count = 0 container = self.content.rootFolder viewType = [vim.VirtualMachine] recursive = True containerView = self.content.viewManager.CreateContainerView( container, viewType, recursive) children = containerView.view for child in children: self.print_vm_info(child) print(self.count) print(len(children)) def get_vm_count(self): container = self.content.rootFolder viewType = [vim.VirtualMachine] recursive = True containerView = self.content.viewManager.CreateContainerView( container, viewType, recursive) children = containerView.view return len(children) def get_datacenter_list(self): """ 数据中心信息 :return: """ objview = self.content.viewManager.CreateContainerView(self.content.rootFolder, [vim.ComputeResource], True) # 获取集群对象 clusters = objview.view # 销毁视图 objview.Destroy() # cpu总大小 cputotal = 0 # 使用cpu cpuusage = 0 memtotal = 0 memusage = 0 totaldatastore = 0 datastorefree = 0 numHosts = 0 numCpuCores = 0 datastore_list = [] for cluster in clusters: summary = cluster.summary for host in cluster.host: cpuusage += host.summary.quickStats.overallCpuUsage memusage += host.summary.quickStats.overallMemoryUsage for datastore in cluster.datastore: datastore_list.append(datastore) cputotal += summary.totalCpu memtotal += summary.totalMemory numHosts += summary.numHosts numCpuCores += summary.numCpuCores # print("---------------------------------") # print "集群名称：", cluster.name # print "集群状态：", summary.overallStatus # print "总主机数：", summary.numHosts # print "cpu颗数：", summary.numCpuCores # print "总cpu：%.2f GHz" % (summary.totalCpu / 1000.0) # print "已使用cpu: %.2f GHz" % (cpuusage / 1000.0) # print "总内存：%.2f GB" % (summary.totalMemory / 1024 / 1024 / 1024.0) # print "已使用mem: %.2f GB" % (memusage / 1024.0) # print "总存储: %.2f T" % (totaldatastore / 1024 / 1024 / 1024 / 1024.0) # print "可用存储: %.2f T" % (datastoreusage / 1024 / 1024 / 1024 / 1024.0) # clusterdata = {"clustername": cluster.name, # "overallStatus": summary.overallStatus, # "numHosts": summary.numHosts, # "numCpuCores": summary.numCpuCores, # "totalCpu": "%.2f GHz" % (summary.totalCpu / 1000.0), # "cpuusage": "%.2f GHz" % (cpuusage / 1000.0), # "totalMemory": "%.2f GB" % (summary.totalMemory / 1024 / 1024 / 1024.0), # "memusage": "%.2f GB" % (memusage / 1024.0), # "totaldatastore": "%.2f T" % (totaldatastore / 1024 / 1024 / 1024 / 1024.0), # "datastoreusage": "%.2f T" % (datastoreusage / 1024 / 1024 / 1024 / 1024.0), # } # redata.append(clusterdata) for datastore in set(datastore_list): totaldatastore += datastore.summary.capacity datastorefree += datastore.summary.freeSpace return { "cputotal": "%.2f GHz" % (cputotal / 1000.0), "cpuusage": "%.2f GHz" % (cpuusage / 1000.0), "memtotal": "%.2f GB" % (memtotal / 1024 / 1024 / 1024.0), "memusage": "%.2f GB" % (memusage / 1024.0), "totaldatastore": "%.2f T" % (totaldatastore / 1024 / 1024 / 1024 / 1024.0), "datastorefree": "%.2f T" % (datastorefree / 1024 / 1024 / 1024 / 1024.0), "numhosts": numHosts, "numcpucores": numCpuCores, "vmcount": self.get_vm_count(), "datacentername": self.datacentername, } def get_datastore_list(self): objview = self.content.viewManager.CreateContainerView(self.content.rootFolder, [vim.Datastore], True) objs = objview.view objview.Destroy() # 存储部分 # 存储集群环境-通过单个存储汇总得到存储集群得容量情况 cluster_store_dict = {} datastore_list = [] for i in objs: capacity = "%.2f G" % (i.summary.capacity / 1024 / 1024 / 1024.0) freespace = "%.2f G" % (i.summary.freeSpace / 1024 / 1024 / 1024.0) datastore_summary = { "cluster_store_name": "默认集群目录" if i.parent.name == "datastore" else i.parent.name, "datacentername": self.datacentername, "datastore": str(i.summary.datastore), "name": i.summary.name, "url": i.summary.url, # 唯一定位器 "capacity": capacity, "freespace": freespace, "type": i.summary.type, "accessible": i.summary.accessible, # 连接状态 "multiplehostaccess": i.summary.multipleHostAccess, # 多台主机连接 "maintenancemode": i.summary.maintenanceMode # 当前维护模式状态 } datastore_list.append(datastore_summary) return datastore_list def get_host_list(self): """ vcenter下物理主机信息 :return: """ objview = self.content.viewManager.CreateContainerView(self.content.rootFolder, [vim.HostSystem], True) objs = objview.view objview.Destroy() host_list = [] for host in objs: """物理信息""" # 厂商 vendor = host.summary.hardware.vendor # 型号 model = host.summary.hardware.model uuid = host.summary.hardware.uuid # cpu信号 cpumodel = host.summary.hardware.cpuModel # cpu插槽 numcpupkgs = host.summary.hardware.numCpuPkgs # cpu核心 numcpucores = host.summary.hardware.numCpuCores # 逻辑处理器 numcputhreads = host.summary.hardware.numCpuThreads # cpuMhz cpumhz = host.summary.hardware.cpuMhz # cpu总Ghz cpusize = "%.2f GHz" % (host.summary.hardware.cpuMhz * host.summary.hardware.numCpuCores / 1000.0) # 使用cpu cpuusage = "%.2f GHz" % (host.summary.quickStats.overallCpuUsage / 1000.0) # 内存大小 G memorysize = "%.2f G" % (host.summary.hardware.memorySize / 1024 / 1024 / 1024.0) memusage = "%.2f G" % (host.summary.quickStats.overallMemoryUsage / 1024.0) # 运行时间 uptime = host.summary.quickStats.uptime """运行状态""" # 主机连接状态 connectionstate = host.runtime.connectionState # 主机电源状态 powerstate = host.runtime.powerState # 主机是否处于维护模式 inmaintenancemode = host.runtime.inMaintenanceMode """基础信息""" name = host.name # EXSI版本 fullname = host.summary.config.product.fullName """关联信息""" clustername = host.parent.name datacentername = self.datacentername # 多对多 network = [network.name for network in host.network] datastore = [datastore.name for datastore in host.datastore] data = { "name": name, "clustername": clustername, "datacentername": datacentername, "network": network, "datastore": datastore, "connectionstate": connectionstate, "powerstate": powerstate, "inmaintenancemode": inmaintenancemode, "vendor": vendor, "model": model, "uuid": uuid, "cpumodel": cpumodel, "numcpupkgs": numcpupkgs, "numcpucores": numcpucores, "numcputhreads": numcputhreads, "cpumhz": cpumhz, "cpusize": cpusize, "cpuusage": cpuusage, "memorysize": memorysize, "memusage": memusage, "uptime": uptime, } host_list.append(data) return host_list def get_networkport_group_list(self): objview = self.content.viewManager.CreateContainerView(self.content.rootFolder, [vim.Network], True) objs = objview.view objview.Destroy() network_list = [] for networkobj in objs: name = networkobj.name # network = networkobj.summary.network accessible = networkobj.summary.accessible # 分布式交换机名称 try: distributedvirtualswitchname = networkobj.config.distributedVirtualSwitch.name key = networkobj.config.key vlanid = networkobj.config.defaultPortConfig.vlan.vlanId type = "上行链路端口组" if not isinstance(vlanid, int): vlanid = "0-4094" type = "分布式端口组" except AttributeError: continue data = { "name": name, "datacentername": self.datacentername, "key": key, "accessible": accessible, "distributedvirtualswitchname": distributedvirtualswitchname, "vlanid": vlanid, "type": type, } network_list.append(data) return network_list def get_vm_list(self): objview = self.content.viewManager.CreateContainerView(self.content.rootFolder, [vim.VirtualMachine], True) objs = objview.view objview.Destroy() vm_list = [] allstime = time.time() count = 0 for vm_machine in objs: count += 1 starttime = time.time() # print(count) # 虚拟机名称 name = vm_machine.name # EXSI主机 host = vm_machine.summary.runtime.host.name """运行状态""" # 连接状态 connectionstate = vm_machine.summary.runtime.connectionState # 电源状态 powerstate = vm_machine.summary.runtime.powerState """guest模版-""" # vmwareTools 安装情况 toolsstatus = vm_machine.summary.guest.toolsStatus # 系统内hostname hostname = vm_machine.summary.guest.hostName """config""" uuid = vm_machine.summary.config.uuid # 是否模版 template = vm_machine.summary.config.template # vm文件路径 vmpathname = vm_machine.summary.config.vmPathName # cpu 颗数 numcpu = vm_machine.summary.config.numCpu # 内存总大小 memtotal = "%.2fG" % ( vm_machine.summary.config.memorySizeMB / 1024.0) # 网卡数 numethernetcards = vm_machine.summary.config.numEthernetCards # 虚拟磁盘数量 numvirtualdisks = vm_machine.summary.config.numVirtualDisks # 已使用存储容量 storage_usage = "%.2fG" % (vm_machine.summary.storage.committed / 1024 / 1024 / 1024.0) # cpu使用Mhz cpuusage = vm_machine.summary.quickStats.overallCpuUsage # GB memusage = "%.2fG" % (vm_machine.summary.quickStats.guestMemoryUsage /1024.0) # 开机时间 uptime = vm_machine.summary.quickStats.uptimeSeconds # 运行状态 overallstatus = vm_machine.summary.overallStatus # 网络 network = [i.name for i in vm_machine.network] # 虚拟磁盘信息 virtualdisk = [] try: for disk in vm_machine.config.hardware.device: try: if hasattr(disk, "diskObjectId"): label = disk.deviceInfo.label capacityinkb = "%.2fG" % (disk.capacityInKB / 1024 / 1024.0) virtualdisk.append({"label": label, "capacityinkb": capacityinkb}) except AttributeError: pass except AttributeError: # print("----------什么都没有的------------") continue # print virtualdisk virtualdiskinfo = json.dumps(virtualdisk) # IP信息 ipaddress = vm_machine.guest.ipAddress other_ip = set() for vmnet in vm_machine.guest.net: for ip in vmnet.ipAddress: other_ip.add(ip) data = { "name": name, "host": host, "datacentername": self.datacentername, "ipaddress": ipaddress, "other_ip": json.dumps(list(other_ip)), "connectionstate": connectionstate, "powerstate": powerstate, "toolsstatus": toolsstatus, "hostname": hostname, "uuid": uuid, "template": template, "vmpathname": vmpathname, "numcpu": numcpu, "memtotal": memtotal, "numethernetcards": numethernetcards, "numvirtualdisks": numvirtualdisks, "storage_usage": storage_usage, "cpuusage": cpuusage, "memusage": memusage, "uptime": uptime, "overallstatus": overallstatus, "network": network, "virtualdiskinfo": virtualdiskinfo, } vm_list.append(data) # print time.time()-starttime print "allover---", time.time() - allstime return vm_list def get_vmsnapshotinfo(self): # 查看快照信息 objview = self.content.viewManager.CreateContainerView(self.content.rootFolder, [vim.VirtualMachine], True) obj = objview.view vmsnapshotinfo = [] for vm in obj: if vm.snapshot is not None: vm_name = vm.name for i in range(len(vm.snapshot.rootSnapshotList)) : snapshot_name = vm.snapshot.rootSnapshotList[i].name snapshot_createTime = vm.snapshot.rootSnapshotList[i].createTime year = snapshot_createTime.year month = snapshot_createTime.month day = snapshot_createTime.day hour = snapshot_createTime.hour + 8 if hour >= 24 : day = day + 1 hour = 24 - hour minute = snapshot_createTime.minute second = snapshot_createTime.second snapshot_createTime = "{0}-{1}-{2} {3}:{4}:{5}".format(year,month,day,hour,minute,second) print(snapshot_createTime,snapshot_name) data = { "vm_name": vm_name, "snapshot_name": snapshot_name, "snapshot_createTime": snapshot_createTime } vmsnapshotinfo.append(data) # print(vmsnapshotinfo) return vmsnapshotinfo if __name__ == '__main__': obj = VcenterApi(host='192.168.96.85', user='root', pwd='Abc123!') vmsnapshotinfo= obj.get_vmsnapshotinfo() dataframe = pandas.DataFrame(vmsnapshotinfo) dataframe.to_excel("vmsnapshotinfo.xlsx") # vm = obj.get_vm_list() # dataframe = pandas.DataFrame(vm) # dataframe.to_excel("vmlist.xlsx")
