I know that a lot of things have been discussed about Custom Attributes and Tags across various blogs but I thought that I would just share some scripts that I have been using for a particular scenario that other people may also run into.<\/p>\n
In the environment I was looking after, we had over 1000 virtual machines which had been deployed over the past few years (most of them just being deployed with templates and no real automation involved).\u00a0 These virtual machines were not owned by a single person or team but multiple people across multiple teams, a scenario seen at most companies.\u00a0 In the past we had utilised the ‘Notes’ field of the virtual machine to list some simple information about the virtual machine, such as the owner, email address etc.<\/p>\n
This method was not great as all of the information was contained in a single field and therefore searching on the information using scripts etc. proved to be difficult.\u00a0 Previously, we had also looked at utilising Custom Attributes in earlier versions of vSphere but this proved to be tricky to view or manage as the Custom Attributes did not appear on the summary screen for the VM (especially in the Web Client).<\/p>\n
Thankfully, in vSphere 6.5, Custom Attributes can now be fully viewed and managed directly from the vSphere Web Client… meaning that utilising Custom Attributes becomes a real possibility now.<\/p>\n
<\/p>\n
I therefore revisited Custom Attributes and utilised the following scripts to help create the Custom Attribute names, update the virtual machines from a CSV file and also to export the virtual machines including the Custom Attributes.\u00a0 I have to admit that I am not the original author of these scripts although I have tweaked them and unfortunately I cannot remember who the various authors are (therefore I apologise to the original authors for not being able to give them the full credit they deserve).\u00a0 I’m sure that these scripts can be improved upon but they do what I need them to do.<\/p>\n
<\/p>\n
Create Custom Attributes<\/strong><\/p>\n The first script is a simple script to create a number of Virtual Machine Custom Attributes, the ones listed were specific to my requirements but you can adjust these to your requirements.\u00a0 Please remember to change the ***vCenterName***<\/span><\/em> to your vCenter name.<\/p>\n <\/p>\n Import Custom Attribute Values<\/strong><\/p>\n The second script takes an input from a csv file and updates the relevant virtual machine Custom Attributes with the additional details from the csv file.\u00a0 In the csv file there is a column called VMName (housing the full virtual machine name) with additional columns for each of the Custom Attributes.\u00a0 Once again, remember to change the ***vCenterName***<\/span> to your vCenter name and the ***CSVfileLocation***<\/span> to the location of the csv file.<\/p>\n <\/p>\n Export Custom Attributes<\/strong><\/p>\n The final script scans over the vCenter server and exports all of the virtual machines with their Custom Attributes to a csv file (to allow you to check for any missing data or as a base to update the information before importing it again).\u00a0 As in the previous scripts, please remember to modify the ***vCenterName***<\/span> and ***CSVfileLocation***<\/span> with your information.<\/p>\n <\/p>\n I hope that this proves to be useful for other people.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":" I know that a lot of things have been discussed about Custom Attributes and Tags across various blogs but I thought that I would just share some scripts that I have been using for a particular scenario that other people may also run into. In the environment I was looking after, we had over 1000 virtual machines which had been […]<\/p>\n","protected":false},"author":1,"featured_media":735,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[9],"tags":[],"class_list":["post-835","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vmware"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts\/835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/comments?post=835"}],"version-history":[{"count":0,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts\/835\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/media?parent=835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/categories?post=835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/tags?post=835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}connect-viserver<\/span>\u00a0***vCenterName***<\/span><\/em>\n\nNew-CustomAttribute -TargetType \"VirtualMachine\" -Name \"VMOwner\"<\/span>\nNew-CustomAttribute -TargetType \"VirtualMachine\" -Name \"OwnerEmail\"<\/span>\nNew-CustomAttribute -TargetType \"VirtualMachine\" -Name \"OwnerADLocation\"<\/span>\nNew-CustomAttribute -TargetType \"VirtualMachine\" -Name \"BusinessReason\"<\/span>\nNew-CustomAttribute -TargetType \"VirtualMachine\" -Name \"Application\"<\/span>\nNew-CustomAttribute -TargetType \"VirtualMachine\" -Name \"ServerType\"<\/span>\n\nDisconnect-VIServer -Server<\/span> ***vCenterName***<\/em><\/span> -Confirm:$False<\/span><\/pre>\nconnect-viserver<\/span> ***vCenterName***\n<\/span><\/em>$FileList = \"<\/span>***CSVfileLocation***<\/span>\"\n$VMList=Import-CSV $FileList\nForEach($Line in $VMList)<\/span>\n {<\/span>\n Get-Vm $Line.VMName | Set-Annotation -CustomAttribute \"VMOwner\" -Value $Line.VMOwner<\/span>\n Get-Vm $Line.VMName | Set-Annotation -CustomAttribute \"OwnerEmail\" -Value $Line.OwnerEmail<\/span>\n Get-Vm $Line.VMName | Set-Annotation -CustomAttribute \"OwnerADLocation\" -Value $Line.OwnerADLocation<\/span>\n Get-Vm $Line.VMName | Set-Annotation -CustomAttribute \"BusinessReason\" -Value $Line.BusinessReason<\/span>\n Get-Vm $Line.VMName | Set-Annotation -CustomAttribute \"Application\" -Value $Line.Application<\/span>\n Get-Vm $Line.VMName | Set-Annotation -CustomAttribute \"ServerType\" -Value $Line.ServerType<\/span>\n }\n<\/span>Disconnect-VIServer -Server<\/span> ***vCenterName*** <\/span><\/em>-Confirm:$False<\/span><\/pre>\nconnect-viserver\u00a0<\/span>***vCenterName*** <\/span><\/em>\n\n$Report = @()<\/span>\n\nGet-VM | foreach{<\/span>\n\n$Summary = \"\" | Select VMName<\/span>\n\n$Summary.VMName = $_.Name<\/span>\n\n$_ | Get-Annotation | foreach{<\/span>\n\nAdd-Member -InputObject $Summary -MemberType NoteProperty -Name $_.Name -Value $_.Value<\/span>\n\n}<\/span>\n\n$Report += $Summary<\/span>\n\n}<\/span>\n\n$Report | Export-Csv -Path\u00a0<\/span>***CSVfileLocation***\u00a0<\/span>-NoTypeInformation<\/span>\n\nDisconnect-VIServer -Server\u00a0<\/span>***vCenterName***\u00a0<\/span><\/em>-Confirm:$False<\/span><\/pre>\n