{"id":9,"date":"2016-06-24T16:25:21","date_gmt":"2016-06-24T16:25:21","guid":{"rendered":"http:\/\/hochsticher.de\/?p=8"},"modified":"2016-06-28T11:09:19","modified_gmt":"2016-06-28T11:09:19","slug":"report-your-cdp-neighbours","status":"publish","type":"post","link":"http:\/\/vblog.hochsticher.de\/?p=9","title":{"rendered":"Report your CDP Neighbours"},"content":{"rendered":"

Let’s\u00a0build a HTML-Report about the CDP Neighbours\u00a0of your ESXi Hosts.<\/p>\n

<\/p>\n

It looks like this:<\/p>\n

\"cdp\"<\/p>\n

You can see your VMhost, VMNic, etc. in a HTML Output<\/p>\n

# Creator Christoph Hochsticher 04.09.2015\r\n# 13.05.2016 Changed to function\r\n\r\n\r\n############################################################\r\n# Creates a HTML Output with CDP informations of your hosts#\r\n############################################################\r\n\r\n# Load VMware Snapin\r\nAdd-PSSnapin VMware.VimAutomation.Core\r\n\r\n#Connect vCenter Server\r\nConnect-VIServer -server yourvcenter -User administrator@vsphere.local -password yourpassword\r\n\r\n\r\n#Define Var\r\n$path = \t'L:HTML-ReportsCDP-InfoCSVCDP-Info-' + (Get-Date -Format yyyy-MM-dd) + '.csv'\r\n$htmlfile = 'L:HTML-ReportsCDP-Infoolder-reportsCDP-Info-' + (Get-Date -Format yyyy-MM-dd) + '.html'\r\n$htmlfile2 = 'L:HTML-ReportsCDP-InfoCDP-Info-latest' + '.html'\r\n$date = Get-Date\r\n$logo = '<img src=\"http:\/\/your-logo.svg\" alt=\"\" align=\"right\">'\r\n\r\n#html custom\r\n$custom = '<style>\r\nBODY{background-color:#A4D7D2;}\r\n\r\nTABLE{border-width:1px; border-style:solid; border-color:black; border-collapse:collapse;}\r\nTH{border-width:1px; padding:0px; border-style:solid; border-color:black;}\r\nTD{border-width:1px; padding:0px; border-style:solid; border-color:black;}\r\n<\/style>'\r\n\r\n\r\n#function get-cdp info\r\nfunction Get-Cdpinfo\r\n{\r\n  <#\r\n      .SYNOPSIS\r\n      Short Description\r\n      .DESCRIPTION\r\n      Detailed Description\r\n      .EXAMPLE\r\n      Get-cdpinfo esxhost\r\n      Get-cdpinfo *\r\n      explains how to use the command\r\n      can be multiple lines\r\n      .EXAMPLE\r\n      Get-cdpinfo\r\n      another example\r\n      can have as many examples as you like\r\n  #>\r\n  param\r\n  (\r\n    [Parameter(Mandatory=$true)]\r\n  \r\n    $VMHost\r\n  \r\n  )\r\n  $vmh = Get-VMHost $VMHost\r\n  Get-View $vmh.ID | `\r\n  % { $esxname = $_.Name; Get-View $_.ConfigManager.NetworkSystem} | `\r\n  % { foreach ($physnic in $_.NetworkInfo.Pnic) {\r\n      $pnicInfo = $_.QueryNetworkHint($physnic.Device)\r\n      foreach( $hint in $pnicInfo ){\r\n        # Write-Host $esxname $physnic.Device\r\n        if ( $hint.ConnectedSwitchPort ) {\r\n          $hint.ConnectedSwitchPort | Select-Object @{n='VMHost';e={$esxname}},@{n='VMNic';e={$physnic.Device}},DevId,Address,PortId,HardwarePlatform,Location,MgmtAddr,SoftwareVersion,SystemName\r\n        }\r\n        else {\r\n          \r\n        }\r\n      }\r\n    }\r\n  }\r\n}\r\n\r\n$tmp = (Get-Cdpinfo -vmhost *) \r\n\r\n#Export to CSV & HTML\r\n$tmp | export-csv $path\r\n$tmp | sort-object 'VMHost' | ConvertTo-Html -Title 'CDP-Info' -Body \"<H2> CDP-Info $logo <\/H2> <br> <H3>Reporting Date :$date <\/H3> $custom \" |Out-File $htmlfile\r\n\r\n#Copy for Archive\r\nCopy-Item $htmlfile $htmlfile2\r\n \r\nDisconnect-VIServer * -Confirm:$false<\/pre>\n","protected":false},"excerpt":{"rendered":"
Let’s\u00a0build a HTML-Report about the CDP Neighbours\u00a0of your ESXi Hosts.<\/p>\n","protected":false},"author":1,"featured_media":19,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[4,5,7],"tags":[],"class_list":["post-9","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powercli","category-reports","category-vsphere"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t