VM Creation Historical Report

I needed something that I could look back upon to determine who created what VM in vCenter and from what template.  This works when dealing w/ just vCenter and not vCloud Director.  It's painfully slow, but it works as a stopgap until I figure out how to query the same information from SQL instead.

Here is an screenshot example of what the PowerCLI script outputs:

Although, I can probably gather a longer historical view through CSV's than vCenter's SQL if those events/tasks are cleaned up after a period of time.  It's meant to be run on a daily basis.

Script found after the break:

The script assumes IIS as your web server, so you'll need to change some things if you have different target web server.  I also assume the existence of a sorttable.js and a css file.  Both of which you can download.

Copy everything below:
#################################################
#Title: VM Creation Historical Report            #
#Filename: Get-VMCreationReport.ps1                #
#Originally written by K. Chris Nakagaki        #
#http://tech.zsoldier.com/                      #
#################################################

Add-PSsnapin VMware.VimAutomation.Core

Connect-VIServer yourvCenterServerName

# Dates (Midnight specified for absolute start date/time for event collection)
$Date = Get-Date -Hour 0 -Minute 0 -Second 0
$FileFormatDate = Get-Date -Format yyyy.MM.dd-hh.mm.ss

#Enter Datastore names, such as local or read-only stores that should be excluded from totals.
$htmpath        = "C:\inetpub\wwwroot\"
$csvpath        = "C:\inetpub\wwwroot\csv\VMCreationHistory\"
$htmname        = "VMCreationHistoryReport.htm"
$csvname         = "$($FileFormatDate)VMsCreated.csv"

#Report Title appears in <title> section and shows in the browser window.
$ReportTitle     = "VM Creation History Report"

#IconPath is the icon that is rendered on supported web browsers tab or address bar
$IconPath        = "/images/mySuperDuperAwesomeCustomIcon.ico"

#AppleIconType, set this to "Apple-touch-icon" if you would like the iOS device to render a glass effect on top of your custom icon.
#Otherwise use "Apple-touch-icon-precomposed" to just use your stock image.  45x45 is recommended, but higher rez can be used.
$AppleIconType     = "apple-touch-icon-precomposed"

#AppleTouchIcon is the image that appears on an iOS and/or Android device when a home screen bookmark is created.
$AppleTouchIcon = "/images/apple-touch-icon.png"


#Stylesheet is the path where your CSS file lies.
$Stylesheet        = "/styles/style.css"

#SortScript is where the sorttable.js script resides.  This allows dynamic sorting of table information within the browser.
$SortScript     = "/scripts/sorttable.js"

#Notes will be added to the footer of the page.
$Notes             = ""

#HTML Code for <Head> Section, simply append additional code
$Head = "<LINK REL='SHORTCUT ICON' HREF='$($IconPath)'><link rel='$($AppleIconType)' href='$($AppleTouchIcon)'/><title>$($ReportTitle)</title><link rel='stylesheet' type='text/css' href='$($Stylesheet)'><script src='$($SortScript)'></script>"

## Script Output Section ##
$VIEvent = Get-VIEvent -maxsamples 500000 -Start $Date.AddDays(-1) -Finish $Date
$OutputCreatedVMs = @($VIEvent | where {$_.Gettype().Name -eq "VmCreatedEvent" -or $_.Gettype().Name -eq "VmBeingClonedEvent" -or $_.Gettype().Name -eq "VmBeingDeployedEvent"} | Select createdTime, UserName, fullFormattedMessage)
$OutputCreatedVMs | Export-Csv -NoTypeInformation "$($csvpath)$($csvname)"

$OutputCreatedVMs | ConvertTo-Html -Body "<a name='Data'></a><strong>$ReportTitle $date</strong> 
<br><a href=./csv/VMCreationHistory/>(Click here to see historical csv copies)</a>" -Head $Head | 
foreach {$_.replace("&lt;","<").replace("&gt;",">").replace("<tr><th>","<table class='sortable'><thead><tr><th>").replace("</th></tr>","</th></tr></thead><tbody>").replace("</table>","</tbody><tfoot></tfoot></table>")} |
Out-File -Encoding ASCII -FilePath "$($htmpath)$($htmname)"

Disconnect-VIServer yourvCenterServerName -Confirm:$false

Comments

Post a Comment

Popular posts from this blog

NSX-T: vCenter and NSX-T Inventory out of Sync (Hosts in vSphere not showing up in NSX-T)

Image
Summary: NSX-T loses synch w/ vCenter inventory, but statuses don't appear to show an issue.  Basically, you add a host to a vCenter cluster, NSX-T bits should start to automatically installing on new host.  Assuming you've created a Transport Node Profile and associated w/ the cluster.  The problem is that NSX-T doesn't see the new host and its link to the compute manager (vCenter) looks fine. Looks fine, Y U NO WORK!? So what's going on here?  This appears to affect NSX-T 2.5 and 2.5.1.  Cause is unknown. Workaround: Restart the cm-inventory service on each NSX-T mgmt/controller node using API or CLI. Details: If you were to query the status of the cm-inventory via API or CLI, you could query all 3 manager/controller nodes and get a status of running.  Even if the primary node associated w/ the VIP, if configured, is not necessarily in charge of inventory.  So you could restart the cm-inventory service till you are blue in the face and get nowhere be
Read more

MacOS: AnyConnect VPN client was unable to successfully verify the IP forwarding table modifications.

Image
The VPN client was unable to successfully verify the IP forwarding table modification.  A VPN connection will not be established. Summary: I started running into issue utilizing Cisco AnyConnect on my Mac basically complaining about not able to overwrite IP forwarding tables.  This was on 4.6.x.  Since my VPN endpoints were not providing me w/ an updated client and w/ no access to Cisco Anyconnect downloads, my only option was to try openconnect.  It was totally worth it, here is why and how to set it up. PreReqs: Homebrew Installing OpenConnect: Launch MacOS Terminal brew install openconnect Getting VPN IP's/DNS Endpoints from AnyConnect: The information is typically located in your profile xml files located here: /opt/cisco/anyconnect/profile/somethingsomething.xml In the xml file, you are looking for "<HostAddress>typicallyaDNSName.com</HostAddress>" entry.  These are your VPN endpoints that you would need to pass to openconnect. Using
Read more

Azure VMware Solution: NSX-T Active/Active T0 Edges...but

Image
Summary: Azure VMware Solution (AVS) delivers by default w/ a pair of redundant Large NSX-T Edge VM's each running a T0 in active/active mode.  So why is my traffic only going out one Edge VM? Short answer: The default T1 that is delivered w/ AVS is an active/passive T1 where you connect your workloads to.  So while it could technically take either T0, it's always going to go out the closest T0 to the active "SR" T1.  Where do the SR's live?  You guessed it, on the Edge VM's.  As you can imagine, this can lead to a bottleneck if you try to shove all your traffic through a single Edge VM. Simple Diagram: Longer answer with Options:
Read more