Zabbix批量导入XML文件生成小脚本(by Powershell)

最近升级6.0后发现手动批量导入Zabbix主机群组需要一个新的uuid参数，于是用powershell写了一个脚本。

 

 

 

 

代码如下：

<#     TIME:2022/04/30     DESCRIPTION:生成zabbix批量导入的XML文件     AUTHOR:Monbro #> # # $zbxiface设置为161为生成SNMP的XML文件，设置10050为ZabbixAgent的XML文件 $zbxiface = 10050 $ppath = Split-Path -Parent $PSCommandPath $xlsxfile = $ppath+\+(Get-ChildItem -Path $ppath\*.xlsx).Name $excel = New-Object -ComObject Excel.Application $excel.Visible = $false $wb=$excel.Workbooks.Open($xlsxfile) $ws=$wb.Sheets.Item(Sheet1) $slist=$iplist=$dplist=$cnlist=@() for ($n = 1; $n -le $ws.UsedRange.Rows.Count; $n++) {     #01_Names     $slist+=$ws.Cells.Item($n,1).Text     #02_IPv4Address     $iplist+=$ws.Cells.Item($n,2).Text     #03_Description     $dplist+=$ws.Cells.Item($n,3).Text     #04_CanonicalName     $cnlist+=$ws.Cells.Item($n,4).Text } $excel.Quit() $excel = $null [GC]::Collect() $cretedate =  Get-Date -Format yyyy-MM-ddThh:mm:ssZ $groupname=$cretedate $groupuuid=[System.Guid]::NewGuid().toString('N') $filename = $ppath+\+$cretedate.Replace(:, )+.xml function ZBXhosts_imxml{  $xmlhead=<?xml version=`1.0` encoding=`UTF-8`?> <zabbix_export>     <version>6.0</version>     <date>$cretedate</date>     <groups>         <group>             <uuid>$groupuuid</uuid>             <name>$groupname</name>         </group>     </groups>     <hosts>     $xmltail=    </hosts> </zabbix_export> $xmlhead | Out-File -Encoding utf8 $filename  if ($zbxiface.Equals(10050)) {     $i=0     foreach($ServerName in $slist ){         $ip=$iplist[$i]         $desp=$dplist[$i]         $cnname=$cnlist[$i]         $xmlmid10050=        <host>             <host>$ServerName</host>             <name>$ServerName</name>             <description>$desp</description>             <groups>                 <group>                     <name>$groupname</name>                 </group>             </groups>             <interfaces>                 <interface>                     <ip>$ip</ip>                     <dns>$ServerName</dns>                     <interface_ref>if1</interface_ref>                 </interface>             </interfaces>             <inventory>                 <name>$cnname</name>             </inventory>         </host>         $xmlmid10050 | Out-File -Encoding utf8 -Append $filename         $i++     } }  if ($zbxiface.Equals(161)) {     $i=0     foreach($ServerName in $slist ){         $ip=$iplist[$i]         $desp=$dplist[$i]         $cnname=$cnlist[$i]         $xmlmid161=        <host>             <host>$ServerName</host>             <name>$ServerName</name>             <description>$desp</description>             <groups>                 <group>                     <name>$groupname</name>                 </group>             </groups>             <interfaces>                 <interface>                     <type>SNMP</type>                     <ip>$ip</ip>                     <dns>$ServerName</dns>                     <port>161</port>                     <details>                         <community>{`$SNMP_COMMUNITY}</community>                     </details>                     <interface_ref>if1</interface_ref>                 </interface>             </interfaces>             <inventory>                 <name>$cnname</name>             </inventory>         </host>         $xmlmid161 | Out-File -Encoding utf8 -Append $filename         $i++     } }  $xmltail | Out-File -Encoding utf8 -Append $filename }  ZBXhosts_imxml