Virtual Center 6.7U1b upgrade fails with: Update installation failed, vCenter is non-operational

In order to reproduce, get a VC/PSC 6.7 . Make the /storage/log full 100% . Installation fails with unexpected problem.

2019-03-07 14_29_49-host1.greg.labs - VMware ESXi.png

Step two, you clean up the /storage/log a bit and it still fails.

2019-03-07 14_31_15-host1.greg.labs - VMware ESXi.png

After this i made sure that there is 98% free.  And same error occurs.

You can reboot PSC/VC as many times as you want, that  does not help. In order to fix it, login to your VC/PSC box and delete file:

/etc/applmgmt/appliance/software_update_state.conf

After file is gone, or moved , go back to installer and click update -> it works !

Have a look what was causing the error :

2019-03-08 13_23_22-vCenter Server Appliance11.png

And the installer script was looking at it hence failing while spotting INSTAL_FAILED with this cryptic error message that the vcenter is not operational

/usr/lib/applmgmt/update/py/vmware/appliance/update/update_state.py

2019-03-08 13_26_13-vc001-psc001 - VMware Remote Console33.png

Many thanks to Ciaran from @VMware  for spotting that!

Advertisements

Baseline groups with powercli

Ok, i have no idea how EXACTLY that works, nobody could explain this to me, including my vmware TAM. But this it what i came up with. It’s only useful i suppose when you are dealing with a lot of update managers/baselines groups.

$JSESSION is something that comes up in your cookie after you have logged in to your webclient. You can install an addon into your chrome/firefox/etc… that shows you your cookies . I could not figure out how to obtain JSESSION variable automatically.  I used HTML5 webclient + fiddler in order to check how the calls were made and tried to reproduce them. Everything works as expected .

code:

 


function get-VUMnodeid($VC,$JSESSION){
$AllProtocols = [System.Net.SecurityProtocolType]'Ssl3,Tls,Tls11,Tls12'
[System.Net.ServicePointManager]::SecurityProtocol = $AllProtocols
add-type @"
using System.Net;
using System.Security.Cryptography.X509Certificates;
public class TrustAllCertsPolicy : ICertificatePolicy {
public bool CheckValidationResult(
ServicePoint srvPoint, X509Certificate certificate,
WebRequest request, int certificateProblem) {
return true;
}
}
"@
[System.Net.ServicePointManager]::CertificatePolicy = New-Object TrustAllCertsPolicy
$JSESSION= $JSESSION -replace ";"
$uri = 'https://'+$VC+'/ui/vum-ui/rest/vcenters'
$cookie = New-Object System.Net.Cookie
$cookie.Name='JSESSIONID'
$cookie.Value=$JSESSION
$cookie.Domain = 'cookie.domain.something.com'
$session = New-object Microsoft.PowerShell.Commands.WebRequestSession
$session.Cookies.Add($Cookie)
#Invoke-WebRequest -uri $uri -WebSession:$session
$request = ((Invoke-WebRequest -uri $uri -WebSession:$session).Content |convertfrom-Json).GetEnumerator() | ?{$_.name -eq $VC}
return $request.nodeid
}
function get-baselinegroup($VC,$JSESSION){
$AllProtocols = [System.Net.SecurityProtocolType]'Ssl3,Tls,Tls11,Tls12'
[System.Net.ServicePointManager]::SecurityProtocol = $AllProtocols
add-type @"
using System.Net;
using System.Security.Cryptography.X509Certificates;
public class TrustAllCertsPolicy : ICertificatePolicy {
public bool CheckValidationResult(
ServicePoint srvPoint, X509Certificate certificate,
WebRequest request, int certificateProblem) {
return true;
}
}
"@
[System.Net.ServicePointManager]::CertificatePolicy = New-Object TrustAllCertsPolicy
$JSESSION= $JSESSION -replace ";"
$vumid = get-VUMnodeid -vc $VC
$uri = 'https://'+$VC+'/ui/vum-ui/rest/nodes/'+$vumid+'/baselineGroups/'
$session = New-object Microsoft.PowerShell.Commands.WebRequestSession
#$cookiestr = 'Cookie: JSESSIONID=C164315B4958845216338B7C3F568090;'
#$cookiestr = 'Cookie: JSESSIONID=AE57E580958B38E21D2B892840BC8A6D; JSESSIONID=60F391E14417C6D581A34BBF01E03DF0; VSPHERE-UI-XSRF-TOKEN=7fff48d9-54fc-4244-98ba-4a7513858476; VSPHERE-USERNAME=gregk%40management.is; VSPHERE-CLIENT-SESSION-INDEX=_ea276e26b355abc989243d26ecbd4958; _pk_id.1.da8d=65733ab98c5fe089.1548769895.4.1549275686.1549271755..a6c285c80359fd81a3dbc83835bbca941eae248ec84b999da3d8fe12190ebb39'
#$cookiestrarray = $cookiestr.split()|?{$_ -match 'JSESSION'} |% {$_ -replace ";"}|%{$_.split('=')[1]}
$cookie = New-Object System.Net.Cookie
$cookie.Name='JSESSIONID'
$cookie.Value=$JSESSION
$cookie.Domain = $VC
$session.Cookies.Add($Cookie)

$session.headers.Add('Accept-Language',' en-US,en')
$session.headers.Add('Accept-Encoding','application/json')
#Invoke-WebRequest -uri $uri -WebSession:$session
write-host $uri
$request = ((Invoke-WebRequest -uri $uri -WebSession:$session).Content |convertfrom-Json).GetEnumerator()
return $request
}

 
function Get-BaselinegroupBaselines($VC,$BGid,$JSESSION){
$AllProtocols = [System.Net.SecurityProtocolType]'Ssl3,Tls,Tls11,Tls12'
[System.Net.ServicePointManager]::SecurityProtocol = $AllProtocols
add-type @"
using System.Net;
using System.Security.Cryptography.X509Certificates;
public class TrustAllCertsPolicy : ICertificatePolicy {
public bool CheckValidationResult(
ServicePoint srvPoint, X509Certificate certificate,
WebRequest request, int certificateProblem) {
return true;
}
}
"@
[System.Net.ServicePointManager]::CertificatePolicy = New-Object TrustAllCertsPolicy
#cookiestr the JSESSIONID has to be the right one
$vumid = get-VUMnodeid -vc $VC
$uri = 'https://'+$VC+'/ui/vum-ui/rest/nodes/'+$vumid+'/baselineGroups/'+$BGid
$session = New-object Microsoft.PowerShell.Commands.WebRequestSession
#$cookiestr = 'JSESSIONID=C164315B4958845216338B7C3F568090;'

$JSESSION= $JSESSION -replace ";"
$cookie = New-Object System.Net.Cookie
$cookie.Name='JSESSIONID'
$cookie.Value=$JSESSION
$cookie.Domain = $VC
$session.Cookies.Add($Cookie)

$session.headers.Add('Accept-Language',' en-US,en')
$session.headers.Add('Accept-Encoding','application/json')

$parentBG = (Get-Baselinegroup -jsession $JSESSION -vc $vc|?{$_.id -eq $bgId}).Name
$request = ((Invoke-WebRequest -uri $uri -WebSession:$session).Content |convertfrom-Json).Updates | select -unique -property baselineName| select *, @{n='parentBG';e={$parentBG}}
return $request
}

$VC should be your virtualcenter at which VUM is registered, your VC can be in linked mode as well. When you will open fiddler you will see that you can translate even creating baselinegroups , add something to baseline groups etc etc.. All we have to have is that JSESSION cookie with us. Heh.. before that i automated even Internet Explorer to get this cookie automatically but i failed at it ,as i could not get THAT PARTICULAR JSESSION cookie, i saw other cookies but not jsession so i gave up, and if i have to do now work at a lot of baselinegroups i just catch that JSESSION from cookie in browser addon.

cross vmotion between virtual center in different sso

https://blogs.vmware.com/PowerCLI/2017/01/spotlight-move-vm-cmdlet.html

http://www.virtuallyghetto.com/2015/02/did-you-know-of-an-additional-cool-vmotion-capability-in-vsphere-6-0.html

http://www.virtuallyghetto.com/2016/05/automating-cross-vcenter-vmotion-xvc-vmotion-between-the-same-different-sso-domain.html

 

monitoring path of exile prices

I know this has nothing to do with VMware, or powershell … i wrote this to check some price on path of exile, and get notification … (beep), when item is affordable. Script does not need explanation i guess since it’s just few lines. Link are the poe.trade link you would get after creating a search criteria for item.

Not the best way, but it does the job.


While (0 -ne 1 ) {
$links = @(
'http://poe.trade/search/yugakakekutusa',
'other link',
)

foreach ($link in $links){
$data = (Invoke-WebRequest -Uri $link)
$items = $data.ParsedHtml.getElementsByTagName('tbody') |? {$_.outerHTML -match "id=item-container"}
foreach ($item in $items)
{
$res = ([regex]::Matches((($item.outerHTML[0..350] -join '') -split '>')[0],'data-(name|buyout|ign)="[^"]*"')).value
''| select @{n='Item';e={$res[0].split('=')[1]}}, @{n='price';e={$res[2].split('=')[1]}}, @{n='seller';e={$res[1].split('=')[1]}}, @{n='Link';e={$link}}
if($res) {[console]::Beep(500,200)}
}
Start-Sleep -Seconds 1
}
Start-Sleep -Seconds 30
write-host "next run"
}

Get-DeepLtranslation translating straight from your powershell

tt
I was doing my dutch course homework today, and i found it a bit tedious to use browser for translation. This + the fact that i want to write myself some dutch-polish quiz, so i can memorize words better led me to write this tiny function.

The DeepL translator website can be found here https://www.deepl.com/translator

This is a tiny function that would just use the ‘word/1 sentence’ mode. It worked today, not sure if it will be working in later months/years. This was made in really quick/dirty way, as i still need to write my homework today 😉 I wrote it in 15 minutes, so don’t expect fireworks, it does what it does, it translates 😉 You can use different languages using variables fromLang and toLang.

function get-DeepLtranslation ($sentence, $fromLang, $toLang)
{
#Languages available: PL,EN,NL,ES,IT,FR
$url = "https://www.deepl.com/jsonrpc"
$call = '{"jsonrpc":"2.0","method":"LMT_handle_jobs","params":{"jobs":[{"kind":"default","raw_en_sentence":"'+$sentence+'"}],"lang":{"user_preferred_langs":["EN","PL","NL"],"source_lang_user_selected":"'+$fromLang+'","target_lang":"'+$toLang+'"},"priority":-1},"id":15}'
$bytes = [System.Text.Encoding]::ASCII.GetBytes($call)
$web = [System.Net.WebRequest]::Create($url)
$web.Method = "POST"
$web.ContentLength = $bytes.Length
$web.ContentType = "application/x-www-form-urlencoded"
$stream = $web.GetRequestStream()
$stream.Write($bytes,0,$bytes.Length)
$stream.close()
$reader = New-Object System.IO.Streamreader -ArgumentList $web.GetResponse().GetResponseStream()
$answer = ($reader.ReadToEnd()|ConvertFrom-Json).result.translations.beams | select -ExpandProperty 'postprocessed_sentence'
$reader.Close()
return $answer
}

I am not sure why it does not work with the polish single word. IT does translate it though on the website(blue)

2t

When put in sentence that will work.

3t

What i also saw, is that sometimes calls to dict.deepl.com are being made.

I don’t have time right now to dig into this, but for some words you can utilize those:

https://dict.deepl.com/polish-english/search?ajax=1&query=jab%C5%82ko&source=polish&onlyDictEntries=1&translator=dnsof7h3k2lgh3gda&delay=300&jsStatus=0&kind=full&eventkind=keyup&forleftside=true

calls. Behind it’s this :

https://dict.deepl.com/english-polish/search?source=auto&query=%C5%82%C3%B3d%C5%BA

So you can get the translation like this:

(Invoke-WebRequest -Uri ‘https://dict.deepl.com/polish-english/search?ajax=1&query=jab%C5%82ko&source
=polish&onlyDictEntries=1&translator=dnsof7h3k2lgh3gda&delay=300&jsStatus=0&kind=full&eventkind=keyup&forleftside=true’).links[0].outerText
jabłko

That would have to be still converted to proper polish.

I think that something is going wrong when trying to translate words that have polish ‘ogonki’, and char encoding has something to do with it.

Sample send receive Lync / Skype for business messages using powershell

Before you start you need to obtain the Lync SDK package (https://download.microsoft.com/download/0/5/6/056013D5-98F8-4B79-88EF-D221E519C37F/lyncsdk.exe)

I had hard time to have it working with listening what ‘other’ people are writing in the conversation. Thanks to this post(‘John O’ reply) i was able to properly hook the event(to the right participant).
The ‘what*’, was aimed at message: “What is 2+4” or “what is 10*3” for example.
In response you should get the reply with the result.

If you want to test it with ‘somebody’.

cd "C:\Program Files (x86)\Microsoft Office\Office15\lyncsdk\Assemblies\Desktop"
Import-Module .\Microsoft.Lync.Model.dll
$Client = [Microsoft.Lync.Model.LyncClient]::GetClient()
$Conversation = $client.ConversationManager.AddConversation()
$person=$client.ContactManager.GetContactByUri('person@domain.com')
$conversation.AddParticipant($person)


Get-EventSubscriber|Unregister-Event
  # For each participant in the conversation
  $conversation.Participants | Where { !$_.IsSelf } | foreach {
    Register-ObjectEvent -InputObject $_.Modalities[1] -EventName "InstantMessageReceived" -SourceIdentifier "person $i" -action { 
    $global:conv = $event
    $msg = $conv.SourceEventArgs.Text.trim()
    write-host $msg
    switch -Wildcard ($msg) {
     "What*" {$Conversation.Modalities['InstantMessage'].BeginSendMessage((Invoke-Expression $msg.split()[-1]), {}, 0)}
     "Hello" {$Conversation.Modalities['InstantMessage'].BeginSendMessage("Hello human", {}, 0)}
     "stupid robot" {$Conversation.Modalities['InstantMessage'].BeginSendMessage("Humanity is overrated", {}, 0)}
    }
    }
    $i++
   }

Or if you don’t have friends and want to test it against yourself (2nd client running).

cd "C:\Program Files (x86)\Microsoft Office\Office15\lyncsdk\Assemblies\Desktop"
Import-Module .\Microsoft.Lync.Model.dll
$Client = [Microsoft.Lync.Model.LyncClient]::GetClient()
$Conversation = $client.ConversationManager.AddConversation()
$conversation.AddParticipant($client.Self.Contact)

Get-EventSubscriber|Unregister-Event
  $conversation.Participants[0]| foreach {
    Register-ObjectEvent -InputObject $_.Modalities[1] -EventName "InstantMessageReceived" -SourceIdentifier "person $i" -action { 
    $global:conv = $event
    $msg = $conv.SourceEventArgs.Text.trim()
    write-host $msg
    #if ($msg -like 'What*') {$Conversation.Modalities['InstantMessage'].BeginSendMessage((Invoke-Expression $msg.split()[-1]), {}, 0)}
    switch -Wildcard ($msg) {
     "What*" {$Conversation.Modalities['InstantMessage'].BeginSendMessage((Invoke-Expression $msg.split()[-1]), {}, 0)}
     "Hello" {$Conversation.Modalities['InstantMessage'].BeginSendMessage("Hello human", {}, 0)}
     "stupid robot" {$Conversation.Modalities['InstantMessage'].BeginSendMessage("Humanity is overrated", {}, 0)}
    }
    }
    $i++
   }

You can send message using the PS session anytime then:
$Conversation.Modalities[‘InstantMessage’].BeginSendMessage(‘text’, {}, 0)}
Some useful links:
https://msdn.microsoft.com/en-us/library/office/jj937273.aspx
https://msdn.microsoft.com/en-us/library/office/hh243705(v=office.14).aspx
https://msdn.microsoft.com/en-us/library/office/jj933215.aspx
https://msdn.microsoft.com/en-us/library/office/jj937298.aspx
https://msdn.microsoft.com/en-us/library/office/jj933248.aspx
https://blogs.technet.microsoft.com/heyscriptingguy/2011/06/16/use-asynchronous-event-handling-in-powershell/

Migrating virtual center to another virtual center

!!! WARNING !!!
this is not finished ! DO NOT RUN THIS ON PRODUCTION SYSTEMS !!! UNLESS YOU HAVE TESTED IT IN DEV !!!

Gents, please do not treat this as a ready-to-go solution, you would have to understand the contents, in order how to apply this. Destroying your production is that last thing i want.
I had to write this to recover a VC after a major bug/failure. I had to create another VirtualCenter in order to fix the issue. The main goal of this script is to move ‘everything’ i had in the old virtual center server to the new one.

PLEASE NOTE !!!
DVS is not supported here at this moment

Before you comment this, yes, i know that there are already some software/script for doing this, but in my opinion they were not doing everything or not in the way i wanted to do it. That’s why i created this.
This is not completed ! I have tested it numerous times on dev platforms, for me it was working. The only part which is not here is the cluster configs and dvs. Script will not configure your virtual center, but just the ‘content’ including, folder (of any kind), dc, clusters, vapps. The placements + permissions. The annotations are written in previous posts as well as roles.
I know it’s messy, yes… Although i think i will not spend more time on this, unless i will have to do so. I just hope that it might help for people that had similar task to do, and they were lacking some features in their clone of virtual center.
I DO NOT GUARANTEE THE RESULTS OF THE SCRIPT. Gents, please test this first in your test/dev environments. I have been running this script at least 600-800 times, until i was happy with the outcome, where it worked for me. Please have in mind it will not take into consideration on DVS setup. I’ve come up with 2 solutions for dvs, but never implemented it in it. I have decided to write this on my own mainly to test myself if i am able to do so. There might be better ways of doing it(100% sure of that 😉 ). I have put some comments in the script so you can know what to expect at which moment, the execution of this script is divided in many parts. It’s because i never got to 100% with this script i left myself spots to understand where it can go wrong.
I am sorry in some way that i did not explain this entirely, but i would have spend serious amount of hours on that…
I will have to check if i have posted the role-cloning script on blog, because this is something that is expected to be in place for this to work.

#READ THIS VARIABLE FIRST!!!
#$ProjectNAme

function traverse-HostView3 
{
param(
[Parameter(Mandatory=$true)]$originVC,
[Parameter(Mandatory=$true)]$root,
[Parameter(Mandatory=$true)]$type,
[Parameter(Mandatory=$true)]$destinationroot,
[Parameter(Mandatory=$true)]$destinationVC,
[Parameter(Mandatory=$true)]$DatabaseFile,
[string]$DestMorefDC
)

$permissionFile = $DatabaseFile+'-Permissions.csv'

#the type can be following :
#HostFolder - For the Host/Clusters view
#

#Datacenter Object does not contain ChildEntity property, it is a point where folders are split on
#VmFolder            
#HostFolder          
#DatastoreFolder     
#NetworkFolder       
#Hence when we encounter the datacenter object, we are switching root obj to become a HostFolder of that root/Datacenter

#"function start:: , passed root is now "+$root.name

"my root moref type is now "+$root.moref
"Child entities inside this root are: "+($root.ChildEntity -join ',')
#"Will start now the IF section"

################
################ WHAT TO DO IN ORDER TO GET THE TOP ROOT FOLDER -D1 , to get his permissions, since iteration starts from children ?!?!
################ Make entry at the verybottom for folder -d1 , and just take all settings from it, as 1 -off
if ($root.moref.type -eq 'Datacenter') 
{ 
$root = get-view -id $root.$type -server $originVC
}
if ($root.moref.type -eq 'ClusterComputeResource')
{
#break
#we are 'cheating' here to get the compliance for the ChildEntity. Since Cluster does not have ChildEntity that would describe all its hosts. We are creating a column with ChildEntity that include all hosts
#This will also make a situation that resourcepools will not be checked, since we redirected already path to Hosts, we can also add to Children resource pools later on.
$root =$root | Select *,@{n='ChildEntity';e={$_.Host}}
}

if ($root.moref.type -eq 'VirtualApp')
{
#we are 'cheating' here to get the compliance for the ChildEntity. Since Cluster does not have ChildEntity that would describe all its hosts. We are creating a column with ChildEntity that include all hosts
#This will also make a situation that resourcepools will not be checked, since we redirected already path to Hosts, we can also add to Children resource pools later on.
$root =$root | Select *,@{n='ChildEntity';e={$_.Vm}}
}

#if ($root.moref.type -eq 'Datastore') {break}

#"If section was finished, now we will be collecting children"

if ($root.ChildEntity)
{
    $children = get-view -id $root.ChildEntity -server $originVC
    foreach ($child in $children)
    {
       "!!!!!"+ $child.name + " :: "+ $child.moref
       # Switch [typ]
       switch ($child.moref.type) 
    { 
        'Datacenter' {
        "We hit Datacenter"
        $CreatedObject = Get-view  (get-view -id ($destinationroot.createdatacenter($child.name)) -server $destinationVC).HostFolder -server $destinationVC
        $CreatedDatacenter = get-view -id $CreatedObject.parent -Server $destinationVC 
        #sourcedatacenter = $child
        #Datacenter reference database
        "showing object"
        '' | Select-object @{n='ObjectName';e={$child.name}},@{n='OriginObjectMoref';e={$child.moref.ToString()}},@{n='DestinationObjectMoref';e={$CreatedDatacenter.Moref.ToString()}},@{n='Objuuid';e={}},@{n='DestMorefDC';e={}},@{n='vmtxpath';e={}}, @{n='vmtxHost';e={}}, @{n='OwnerMoref';e={}}, @{n='vmmoref';e={}}   | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $DatabaseFile
        #$SourceDCPermission = g
        
        #$DCobject = get-view -id $child.parent -Server $originvc
        
        if ($child.Permission){ 
        write-host  "I saw permissions inside the DC object" 
        $child.Permission | select @{n='OriginObjectMoref';e={$_.Entity.ToString()}},@{n='DestinationObjectMoref';e={$CreatedDatacenter.Moref.ToString()}},@{n='DestMorefDC';e={$DestMorefDC}}, Principal,RoleId,Propagate,Group | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $permissionFile
        }

        } 
        'Folder' {
        "We hit folder:"
        $CreatedObject = get-view $destinationroot.createfolder($child.name) -server $destinationVC
        #$CreatedObject = get-view (New-Folder -Server $destinationvc -name $child.name -Location ($destinationroot|Get-VIObjectByVIView)).Extensiondata
        '' | Select-object @{n='ObjectName';e={$child.name}},@{n='OriginObjectMoref';e={$child.moref.ToString()}},@{n='DestinationObjectMoref';e={$CreatedObject.Moref.ToString()}},@{n='Objuuid';e={}},@{n='DestMorefDC';e={}},@{n='vmtxpath';e={}}, @{n='vmtxHost';e={}}, @{n='OwnerMoref';e={}}, @{n='vmmoref';e={}}   | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $DatabaseFile        
        #sourceFolderPermissions
        if ($child.permission){  
        $child.Permission | select @{n='OriginObjectMoref';e={$_.Entity.ToString()}},@{n='DestinationObjectMoref';e={$CreatedObject.Moref.ToString()}},@{n='DestMorefDC';e={$DestMorefDC}}, Principal,RoleId,Propagate,Group | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $permissionFile
        }
        } 
        'ClusterComputeResource' {
        "We hit cluster"
        $CreatedObject = get-view $destinationroot.createcluster($child.name,(new-object VMware.Vim.ClusterConfigSpec)) -server $destinationVC
        '' | Select-object @{n='ObjectName';e={$child.name}},@{n='OriginObjectMoref';e={$child.moref.ToString()}},@{n='DestinationObjectMoref';e={$CreatedObject.Moref.ToString()}},@{n='Objuuid';e={}},@{n='DestMorefDC';e={}},@{n='vmtxpath';e={}}, @{n='vmtxHost';e={}}, @{n='OwnerMoref';e={}}, @{n='vmmoref';e={}}   | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $DatabaseFile
        #Permissions
        if ($child.permission){  
        $child.Permission | select @{n='OriginObjectMoref';e={$_.Entity.ToString()}},@{n='DestinationObjectMoref';e={$CreatedObject.Moref.ToString()}},@{n='DestMorefDC';e={$DestMorefDC}}, Principal,RoleId,Propagate,Group | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $permissionFile
        }

        } 
        'VirtualApp' {"We hit VirtualApp"
        #This can only be done, when hosts are attached to cluster.
        #Createvapp is method on default resource pool inside cluster.
        #VMware.Vim.ManagedObjectReference CreateVApp(string name, VMware.Vim.ResourceConfigSpec resSpec, VMware.Vim.VAppConfigSpec configSpec,VMware.Vim.ManagedObjectReference vmFolder)
        $child.vappconfig.EntityConfig | export-clixml -Encoding 'UTF8' -depth 2 -LiteralPath ('c:\'+$child.vappconfig.InstanceUuid+'EntityConfig')
        $child.Config.CpuAllocation | export-clixml -Encoding 'UTF8' -depth 2 -LiteralPath ('c:\'+$child.vappconfig.InstanceUuid+'CpuAllocation')
        $child.Config.MemoryAllocation | export-clixml -Encoding 'UTF8' -depth 2 -LiteralPath ('c:\'+$child.vappconfig.InstanceUuid+'MemoryAllocation')
        '' | Select-object @{n='ObjectName';e={$child.name}},@{n='OriginObjectMoref';e={$child.moref.ToString()}},@{n='DestinationObjectMoref';e={$destinationroot.Moref.ToString()}},@{n='Objuuid';e={$child.VAppConfig.InstanceUuid}},@{n='DestMorefDC';e={}},@{n='vmtxpath';e={}}, @{n='vmtxHost';e={}}, @{n='OwnerMoref';e={$child.owner.tostring()}}, @{n='vmmoref';e={}}  | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $DatabaseFile
        if ($child.permission){  
        $child.Permission | select @{n='OriginObjectMoref';e={$_.Entity.ToString()}},@{n='DestinationObjectMoref';e={$child.name}},@{n='DestMorefDC';e={$DestMorefDC}}, Principal,RoleId,Propagate,Group | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $permissionFile
        }
        }
        'HostSystem' {
        "We hit HostSystem"
        '' | Select-object @{n='ObjectName';e={$child.name}},@{n='OriginObjectMoref';e={$root.moref.ToString()}},@{n='DestinationObjectMoref';e={$destinationroot.Moref.ToString()}},@{n='Objuuid';e={$child.Hardware.systeminfo.uuid}},@{n='DestMorefDC';e={$DestMorefDC}},@{n='vmtxpath';e={}}, @{n='vmtxHost';e={}}, @{n='OwnerMoref';e={}}, @{n='vmmoref';e={}}   | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $DatabaseFile
        if ($child.permission){  
        $child.Permission | select @{n='OriginObjectMoref';e={$_.Entity.ToString()}},@{n='DestinationObjectMoref';e={$child.Hardware.systeminfo.uuid}},@{n='DestMorefDC';e={$DestMorefDC}}, Principal,RoleId,Propagate,Group | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $permissionFile
        }
        } 
        'VirtualMachine' {
        #FOR VMS YOU HAVE TO SELECT .config.uuid property into the csv, in order to hit the proper vm. ## TODO !!!!!
        "We hit VirtualMachine"
        $vmtxpath=if ($child.config.template){$child.config.files.VmPathName}
        $vmtxHostRegistered = if ($vmtxpath) { (get-view $child.Runtime.Host -property name -Server $originvc).Name }
        '' | Select-object @{n='ObjectName';e={$child.name}},@{n='OriginObjectMoref';e={$root.moref.ToString()}},@{n='DestinationObjectMoref';e={$destinationroot.Moref.ToString()}},@{n='Objuuid';e={$child.config.uuid}},@{n='DestMorefDC';e={$DestMorefDC}}, @{n='vmtxpath';e={$vmtxpath}}, @{n='vmtxHost';e={$vmtxHostRegistered}}, @{n='OwnerMoref';e={}}, @{n='vmmoref';e={$child.moref.toString()}} | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $DatabaseFile    
        if ($child.permission){  
        $child.Permission | select @{n='OriginObjectMoref';e={$_.Entity.ToString()}},@{n='DestinationObjectMoref';e={$child.config.uuid}},@{n='DestMorefDC';e={$DestMorefDC}}, Principal,RoleId,Propagate,Group | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $permissionFile
        }
        } 
        'Datastore' {"
        We hit Datastore"
        '' | Select-object @{n='ObjectName';e={$child.name}},@{n='OriginObjectMoref';e={$root.moref.ToString()}},@{n='DestinationObjectMoref';e={$destinationroot.Moref.ToString()}},@{n='Objuuid';e={}},@{n='DestMorefDC';e={$DestMorefDC}},@{n='vmtxpath';e={}}, @{n='vmtxHost';e={}}, @{n='OwnerMoref';e={}}, @{n='vmmoref';e={}}   | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $DatabaseFile
        if ($child.permission){  
        $child.Permission | select @{n='OriginObjectMoref';e={$_.Entity.ToString()}},@{n='DestinationObjectMoref';e={$child.name}},@{n='DestMorefDC';e={$DestMorefDC}}, Principal,RoleId,Propagate,Group | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $permissionFile
        }
        }
        'StoragePod' {"
        We hit StoragePod"
        $CreatedObject = get-view $destinationroot.createstoragepod($child.name) -server $destinationVC
        '' | Select-object @{n='ObjectName';e={$child.name}},@{n='OriginObjectMoref';e={$child.moref.ToString()}},@{n='DestinationObjectMoref';e={$CreatedObject.Moref.ToString()}},@{n='Objuuid';e={}},@{n='DestMorefDC';e={}},@{n='vmtxpath';e={}}, @{n='vmtxHost';e={}}, @{n='OwnerMoref';e={}}, @{n='vmmoref';e={}}   | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $DatabaseFile
        if ($child.permission){  
        $child.Permission | select @{n='OriginObjectMoref';e={$_.Entity.ToString()}},@{n='DestinationObjectMoref';e={$CreatedObject.Moref.ToString()}},@{n='DestMorefDC';e={$DestMorefDC}}, Principal,RoleId,Propagate,Group | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $permissionFile
        }
        }
        #The ComputeResource if for a single Host inside a folder for example
        #'ComputeResource' {"
        #We hit StoragePod"
        #$CreatedObject = get-view $destinationroot.createstoragepod($child.name) -server $destinationVC
        #'' | Select-object @{n='ObjectName';e={$child.name}},@{n='OriginObjectMoref';e={$child.moref.ToString()}},@{n='DestinationObjectMoref';e={$CreatedObject.Moref.ToString()}},@{n='Objuuid';e={}},@{n='DestMorefDC';e={}} | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $DatabaseFile
        #if ($child.permission){  
        #$child.Permission | select @{n='OriginObjectMoref';e={$_.Entity.ToString()}},@{n='DestinationObjectMoref';e={$CreatedObject.Moref.ToString()}},@{n='DestMorefDC';e={$DestMorefDC}}, Principal,RoleId,Propagate,Group | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $permissionFile
        #}
        #}
        'Network' {
        "We hit network"
        '' | Select-object @{n='ObjectName';e={$child.name}},@{n='OriginObjectMoref';e={$root.moref.ToString()}},@{n='DestinationObjectMoref';e={$destinationroot.Moref.ToString()}},@{n='Objuuid';e={}},@{n='DestMorefDC';e={$DestMorefDC}},@{n='vmtxpath';e={}}, @{n='vmtxHost';e={}}, @{n='OwnerMoref';e={}}, @{n='vmmoref';e={}}   | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $DatabaseFile
        if ($child.permission){  
        $child.Permission | select @{n='OriginObjectMoref';e={$_.Entity.ToString()}},@{n='DestinationObjectMoref';e={$child.name}},@{n='DestMorefDC';e={$DestMorefDC}}, Principal,RoleId,Propagate,Group | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $permissionFile
        }
        }  
        default {"The object could not be determined : please check";read-host}
    }
       traverse-HostView3 -root $child -type $type -originVC $originVC -destinationVC $destinationVC -destinationroot $CreatedObject -DatabaseFile 'c:\databasefile.csv' -DestMorefDC $DestMorefDC
       
    }
}

}



$originvc = 'your.original.vc'
$destinationVC = 'your.new.vc'
connect-viserver $originVC -Credential (Get-credential)
connect-viserver $destinationVC -credential (get-credential)
$pscred = Get-Credential

$rootFolder = get-view -id ($global:DefaultVIServers |? {$_.name -eq $originvc}).extensiondata.content.rootfolder -Server $originvc
$destinationroot = get-view -id ($global:DefaultVIServers |? {$_.name -eq $destinationvc}).extensiondata.content.rootfolder -Server $destinationvc

traverse-HostView3 -root $rootFolder -type 'HostFolder' -originVC $originVC -destinationVC $destinationVC -destinationroot $destinationroot -DatabaseFile 'c:\databasefile.csv'



##You start first by running through Host and Clusters View, since you have to recreate the entire main structure for datacenters.
##Remember that after each run , in case you went into trouble to clear the database file, or you different file.
##
##
##Tutaj podajemy root folder w source VC, jako folder do konkretnego DC.networkFolder , tak samo w destination , nakladamy folder dc.networkfolder
#NETWORK FOLDERS:
foreach($dc in (import-csv 'c:\databasefile.csv' -Encoding 'UTF8' |? {$_.OriginObjectMoref -like "Datacenter-*"})  )
{
traverse-HostView3 -root (get-view (get-view $dc.OriginObjectMoref -server $originVC).NetworkFolder -Server $originVC) -type 'NetworkFolder' -originVC $originVC -destinationVC $destinationVC -destinationroot (get-view (get-view $dc.DestinationObjectMoref -server $destinationVC).NetworkFolder -Server $destinationVC) -DatabaseFile 'c:\databasefile.csv' -DestMorefDC ($dc.DestinationObjectMoref) 
}

#VM FOLDERS:


foreach($dc in (import-csv 'c:\databasefile.csv' -Encoding 'UTF8' |? {$_.OriginObjectMoref -like "Datacenter-*"})  )
{
traverse-HostView3 -root (get-view (get-view $dc.OriginObjectMoref -server $originVC).VmFolder -Server $originVC) -type 'VmFolder' -originVC $originVC -destinationVC $destinationVC -destinationroot (get-view (get-view $dc.DestinationObjectMoref -server $destinationVC).VmFolder -Server $destinationVC) -DatabaseFile 'c:\databasefile.csv' -DestMorefDC ($dc.DestinationObjectMoref) 
}

#Storage FOLDERS:
foreach($dc in (import-csv 'c:\databasefile.csv' -Encoding 'UTF8' |? {$_.OriginObjectMoref -like "Datacenter-*"})  )
{
traverse-HostView3 -root (get-view (get-view $dc.OriginObjectMoref -server $originVC).DatastoreFolder -Server $originVC) -type 'DatastoreFolder' -originVC $originVC -destinationVC $destinationVC -destinationroot (get-view (get-view $dc.DestinationObjectMoref -server $destinationVC).DatastoreFolder -Server $destinationVC) -DatabaseFile 'c:\databasefile.csv' -DestMorefDC ($dc.DestinationObjectMoref) 
}

###
###  COPY ROOT VC PERMISSION HERE
### 
### THIS PART IS ONLY IF YOUR LOCAL SSO DOMAIN CHANGES, MODIFY THIS IF IT IS THE SAME
$sourceSSODomain = 'VSPHERE.LOCAL'
$destinationSSODomain = 'TEST.LOCAL'

$tpermissionFile = 'databasefile.csv-Permissions.csv'
$VCSourceRootPermissions = (get-view -id 'Folder-group-d1' -server $originvc).permission |?{$_.Principal -notmatch "vpxd-|vsphere-webclient-"} 
#IF you don't want to change the local sso domain , hash the line below:
$VCSourceRootPermissions|? {$_.principal -match $sourceSSODomain} | %{$_.principal = [regex]::replace($_.Principal,$sourceSSODomain,$destinationSSODomain)}

$VCSourceRootPermissions | select @{n='OriginObjectMoref';e={$_.Entity.ToString()}},@{n='DestinationObjectMoref';e={$_.Entity.ToString()}}, Principal,RoleId,Propagate,Group | Export-Csv -NoTypeInformation -Append -Encoding 'UTF8' -LiteralPath $tpermissionFile


##
## END OF THE COPY OF VC PERMISSION
##



##
##Before replaying permissions you have to be sure that the SSO domain is the same for permissions, therefore we will replace old SSO domain with new SSO domain.
##
$RoleDB = Import-Csv -Encoding UTF8 -LiteralPath 'C:\RoleDB.csv'
$sourceSSODomain = (Get-AdvancedSetting -Entity ($global:DefaultVIServers|?{$_.Name -eq $originvc}) -Name 'config.vpxd.sso.default.admin').value.split('@')[1].ToUpper()
$destinationSSODomain = (Get-AdvancedSetting -Entity ($global:DefaultVIServers|?{$_.Name -eq $destinationvc}) -Name 'config.vpxd.sso.default.admin').value.split('@')[1].ToUpper()
$tpermissionFile = 'c:\databasefile.csv-Permissions.csv'
$permissions = import-csv -Encoding UTF8 -LiteralPath $tpermissionFile 
$permissions |% { $_.principal = [regex]::replace($_.Principal,$sourceSSODomain,$destinationSSODomain)  }
$permissions | export-csv -Encoding UTF8 -LiteralPath $tpermissionFile -NoTypeInformation

##
## REPLAY PERMISSIONS
##
$RoleDB = Import-Csv -Encoding UTF8 -LiteralPath 'C:\RoleDB.csv'
#$rolehash = @{}
#$roleDB | % { $roleHash += @{$_.SourceRoleId = get-virole -id $_.DestinationRoleID -Server $destinationVC}  }
#RoleHash is now [ID_SOURCE_ROLE]  || [ROLE_OBJECT_ON_DESTINATION]
#OriginObjectMoref      : Folder-group-v450
#DestinationObjectMoref : Folder-group-v972
#DestMorefDC            : Datacenter-datacenter-953
#Principal              : VSPHERE.LOCAL\greg
#RoleId                 : -1
#Propagate              : True
## FOLDERS DCs
## FOLDERS Hs
#### We Will need authorizationmanager from the destination VC now. method SetEntityPermissions         Method     void SetEntityPermissions(VMware.Vim.ManagedObjectReference entity, VMware.Vim.Permission[] permission)
##Entity     :
#Principal  :
#Group      : False
#RoleId     : 0
#Propagate  : False
##
##


$DestAM = get-view -id ($global:DefaultVIServers|?{$_.Name -eq $destinationvc}).extensiondata.content.AuthorizationManager -Server $DestinationVC

##
## HOSTS VIEW FOLDERS
##
Foreach ($entity in (import-csv -LiteralPath 'c:\databasefile.csv-permissions.csv' -Encoding UTF8 | ?{$_.OriginObjectMoref -like "Folder-group-h*"})){
$DestinationObjectPermission = New-Object VMware.vim.Permission
$DestinationObjectPermission.Principal = $entity.Principal
$DestinationObjectPermission.Group = [System.Convert]::ToBoolean($entity.Group)
$DestinationObjectPermission.RoleId = ($roleDB|?{$_.SourceRoleId -eq ($entity.RoleId)}).DestinationRoleId
$DestinationObjectPermission.Propagate = [System.Convert]::ToBoolean($entity.Propagate)
$DestinationObjectPermission
$DestAM.SetEntityPermissions($entity.DestinationObjectMoref, $DestinationObjectPermission)
}

##
## DATACENTERS NOW
##

Foreach ($entity in (import-csv -LiteralPath 'c:\databasefile.csv-permissions.csv' -Encoding UTF8 | ?{$_.OriginObjectMoref -like "Datacenter-datacenter-*"})){
$DestinationObjectPermission = New-Object VMware.vim.Permission
$DestinationObjectPermission.Principal = $entity.Principal
$DestinationObjectPermission.Group = [System.Convert]::ToBoolean($entity.Group)  
$DestinationObjectPermission.RoleId = ($roleDB|?{$_.SourceRoleId -eq ($entity.RoleId)}).DestinationRoleId
$DestinationObjectPermission.Propagate = [System.Convert]::ToBoolean($entity.Propagate)
$DestinationObjectPermission
$DestAM.SetEntityPermissions($entity.DestinationObjectMoref, $DestinationObjectPermission)
}

##
## CLUSTERS NOW
##

Foreach ($entity in (import-csv -LiteralPath 'c:\databasefile.csv-permissions.csv' -Encoding UTF8 | ?{$_.OriginObjectMoref -like "ClusterComputeResource-domain-c*"})){
$DestinationObjectPermission = New-Object VMware.vim.Permission
$DestinationObjectPermission.Principal = $entity.Principal
$DestinationObjectPermission.Group = [System.Convert]::ToBoolean($entity.Group)  
$DestinationObjectPermission.RoleId = ($roleDB|?{$_.SourceRoleId -eq ($entity.RoleId)}).DestinationRoleId
$DestinationObjectPermission.Propagate = [System.Convert]::ToBoolean($entity.Propagate)
$DestinationObjectPermission
$DestAM.SetEntityPermissions($entity.DestinationObjectMoref, $DestinationObjectPermission)
}

##
## NETWORK VIEW FOLDERS
##
Foreach ($entity in (import-csv -LiteralPath 'c:\databasefile.csv-permissions.csv' -Encoding UTF8 | ?{$_.OriginObjectMoref -like "Folder-group-n*"})){
$DestinationObjectPermission = New-Object VMware.vim.Permission
$DestinationObjectPermission.Principal = $entity.Principal
$DestinationObjectPermission.Group = [System.Convert]::ToBoolean($entity.Group)
$DestinationObjectPermission.RoleId = ($roleDB|?{$_.SourceRoleId -eq ($entity.RoleId)}).DestinationRoleId
$DestinationObjectPermission.Propagate = [System.Convert]::ToBoolean($entity.Propagate)
$DestinationObjectPermission
$DestAM.SetEntityPermissions($entity.DestinationObjectMoref, $DestinationObjectPermission)
}

##
## VM VIEW FOLDERS
##
Foreach ($entity in (import-csv -LiteralPath 'c:\databasefile.csv-permissions.csv' -Encoding UTF8 | ?{$_.OriginObjectMoref -like "Folder-group-v*"})){
$DestinationObjectPermission = New-Object VMware.vim.Permission
$DestinationObjectPermission.Principal = $entity.Principal
$DestinationObjectPermission.Group = [System.Convert]::ToBoolean($entity.Group)
$DestinationObjectPermission.RoleId = ($roleDB|?{$_.SourceRoleId -eq ($entity.RoleId)}).DestinationRoleId
$DestinationObjectPermission.Propagate = [System.Convert]::ToBoolean($entity.Propagate)
$DestinationObjectPermission
$DestAM.SetEntityPermissions($entity.DestinationObjectMoref, $DestinationObjectPermission)
}

##
## STORAGE FOLDERS VIEW FOLDERS
##
Foreach ($entity in (import-csv -LiteralPath 'c:\databasefile.csv-permissions.csv' -Encoding UTF8 | ?{$_.OriginObjectMoref -like "Folder-group-s*"})){
$DestinationObjectPermission = New-Object VMware.vim.Permission
$DestinationObjectPermission.Principal = $entity.Principal
$DestinationObjectPermission.Group = [System.Convert]::ToBoolean($entity.Group)
$DestinationObjectPermission.RoleId = ($roleDB|?{$_.SourceRoleId -eq ($entity.RoleId)}).DestinationRoleId
$DestinationObjectPermission.Propagate = [System.Convert]::ToBoolean($entity.Propagate)
$DestinationObjectPermission
$DestAM.SetEntityPermissions($entity.DestinationObjectMoref, $DestinationObjectPermission)
}

##
## STORAGE PODS VIEW FOLDERS
##
Foreach ($entity in (import-csv -LiteralPath 'c:\databasefile.csv-permissions.csv' -Encoding UTF8 | ?{$_.OriginObjectMoref -like "StoragePod-group-p*"})){
$DestinationObjectPermission = New-Object VMware.vim.Permission
$DestinationObjectPermission.Principal = $entity.Principal
$DestinationObjectPermission.Group = [System.Convert]::ToBoolean($entity.Group)
$DestinationObjectPermission.RoleId = ($roleDB|?{$_.SourceRoleId -eq ($entity.RoleId)}).DestinationRoleId
$DestinationObjectPermission.Propagate = [System.Convert]::ToBoolean($entity.Propagate)
$DestinationObjectPermission
$DestAM.SetEntityPermissions($entity.DestinationObjectMoref, $DestinationObjectPermission)
}


#Adding Hosts to cluster
Foreach ($cluster in ((import-csv -LiteralPath 'c:\databasefile.csv' -Encoding UTF8 | ?{$_.OriginObjectMoref -like "ClusterComputeResource-domain-c*"}) |?{$_.Objuuid} | Group-Object -Property destinationObjectMoref).group) 
{ 
$VMhostsInCluster = $cluster
$Clusterdestination = $VMhostsInCluster[0].DestinationObjectMoref
$location = get-view -id  $Clusterdestination -server $destinationVC| Get-VIObjectByVIView
foreach ($vmhost in $VMhostsInCluster) 
{
 Add-VMHost -Name $vmhost.ObjectName -Location $location -Credential $pscred -Force -Server $destinationVC
 }

}
#make sure that all pwd are the same

##
##Once all hosts are in place in the VC , we attach our templates
##
foreach ($vmtemplate in  (import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8 | ? {$_.OriginObjectMoref -like "Folder-group-v*" -and $_.vmtxpath})){
$location = get-view -id $vmtemplate.DestinationObjectMoref -server $destinationVC | Get-VIObjectByVIView
New-Template -Name $vmtemplate.ObjectName -TemplateFilePath $vmtemplate.vmtxpath -Location $location -vmhost $vmtemplate.vmtxHost
}


##
## VMHOSTS PERMISSIONS
##
Foreach ($entity in (import-csv -LiteralPath 'c:\databasefile.csv-permissions.csv' -Encoding UTF8 | ?{$_.OriginObjectMoref -like "HostSystem-host-*"})){
$DestinationObjectPermission = New-Object VMware.vim.Permission
$DestinationObjectPermission.Principal = $entity.Principal
$DestinationObjectPermission.Group = [System.Convert]::ToBoolean($entity.Group)
$DestinationObjectPermission.RoleId = ($roleDB|?{$_.SourceRoleId -eq ($entity.RoleId)}).DestinationRoleId
$DestinationObjectPermission.Propagate = [System.Convert]::ToBoolean($entity.Propagate)
$DestinationObjectPermission
#Here our destinationObjectMoref is actually vm host uuid value , not moref. We couldn't have moref as it was unknown.
$DestinationVMHost = get-view -ViewType HostSystem -Filter @{'Hardware.SystemInfo.Uuid'=$entity.DestinationObjectMoref} -Property Name -Server $destinationVC
#$destinationVMHost
$DestAM.SetEntityPermissions($DestinationVMHost.moref, $DestinationObjectPermission)
}



##
## Moving object to their correct location
##
##
## NETWORK VIEW ENTITIES
##!!!!!!!!!!!!!!!!!!!!!!!!!! We should move only those which are not located at the datacenter, otherwise , waste of time.
$DCnetworkFolderIDs = @((get-view -id ((import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8 | ? {$_.OriginObjectMoref -like "Folder-group-n*" -and $_.DestMorefDC -like "Datacenter-datacenter-*"}) |group-object -Property DestMorefDC).Name -Server $destinationVC).NetworkFolder |% {$_.ToString()})
$allNetworksInFolders = (import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8 | ? {$_.OriginObjectMoref -like "Folder-group-n*" -and $_.DestMorefDC -like "Datacenter-datacenter-*"}) | ? {$DCnetworkFolderIDs -notcontains $_.DestinationObjectMoref}
Foreach ($entity in $allNetworksInFolders){
#DestinationObjectMoref : Folder-group-n1575
$dof = get-view -id $entity.DestinationObjectMoref -server $destinationVC
$ntwkmoref = (get-view -server $destinationVC -searchroot $entity.DestMorefDC -viewtype 'Network' -filter @{'name'=$entity.ObjectName}).moref
$dof.MoveIntoFolder($ntwkmoref)
}

## VM VIEW ENTITIES
##!!!!!!!!!!!!!!!!!!!!!!!!!! We should move only those which are not located at the datacenter, otherwise , waste of time.
Foreach ($entity in (import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8 | ? {$_.OriginObjectMoref -like "Folder-group-v*" -and $_.DestMorefDC -like "Datacenter-datacenter-*"})){
#DestinationObjectMoref : Folder-group-n1575
'Object'
$entity

$dof = get-view -id $entity.DestinationObjectMoref -server $destinationVC
'Destination'
$dof.name
$vmmoref = (get-view -server $destinationVC -searchroot $entity.DestMorefDC -viewtype 'Virtualmachine' -filter @{'Config.Uuid'=$entity.Objuuid}).moref
'VM Object'
$vmmoref
$dof.MoveIntoFolder($vmmoref)
}

##
## Creating Vapps, moving VMs into Vapps, Applying Vapp start order
##
Foreach ($entity in (import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8 | ? {$_.OriginObjectMoref -like "VirtualApp-resgroup-v*" -and $_.OwnerMoref})){
#entity is now
#ObjectName             : LABS_Greg
#OriginObjectMoref      : VirtualApp-resgroup-v241
#DestinationObjectMoref : Folder-group-v4284
#Objuuid                : 5038914a-df12-abcc-77aa-2d2991ccaa2e
#DestMorefDC            :
#vmtxpath               :
#vmtxHost               :
#OwnerMoref             : ClusterComputeResource-domain-c7

#First we prepare the configs for our Vapp entity
$EntityMemoryAllocationXML = Import-Clixml -LiteralPath ('C:\'+$entity.Objuuid+'MemoryAllocation')
$EntityCpuAllocationXML = Import-Clixml -LiteralPath ('C:\'+$entity.Objuuid+'CpuAllocation')
$EntityConfig = Import-Clixml -LiteralPath ('C:\'+$entity.Objuuid+'EntityConfig')
$resSpec = New-Object VMware.Vim.ResourceConfigSpec
$resSpec.cpuAllocation = New-Object VMware.Vim.ResourceAllocationInfo
$resSpec.cpuAllocation.reservation = $EntityCpuAllocationXML.Reservation
$resSpec.cpuAllocation.expandableReservation = $EntityCpuAllocationXML.expandableReservation
$resSpec.cpuAllocation.limit = $EntityCpuAllocationXML.limit
$resSpec.cpuAllocation.shares = New-Object VMware.Vim.SharesInfo
$resSpec.cpuAllocation.shares.shares = $EntityCpuAllocationXML.shares.shares
$resSpec.cpuAllocation.shares.level = $EntityCpuAllocationXML.shares.level
$resSpec.memoryAllocation = New-Object VMware.Vim.ResourceAllocationInfo
$resSpec.memoryAllocation.reservation = $EntityMemoryAllocationXML.Reservation
$resSpec.memoryAllocation.expandableReservation = $EntityMemoryAllocationXML.expandableReservation
$resSpec.memoryAllocation.limit = $EntityMemoryAllocationXML.limit
$resSpec.memoryAllocation.shares = New-Object VMware.Vim.SharesInfo
$resSpec.memoryAllocation.shares.shares = $EntityMemoryAllocationXML.shares.shares
$resSpec.memoryAllocation.shares.level = $EntityMemoryAllocationXML.shares.level

$configSpec = New-Object VMware.Vim.VAppConfigSpec
$configSpec.InstanceUuid = $entity.Objuuid
$vmFolder = $Entity.DestinationObjectMoref


#(import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8| ?{$_.OriginObjectMoref -eq $data.OwnerMoref -and !$_.Objuuid})
#$ClusterResourcePool = (import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8| ?{$_.OriginObjectMoref -eq $data.Objuuid -and !$_.Objuuid}).DestinationObjectMoref

$ClusterResourcePool = get-view -id (get-view -id (import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8| ?{$_.OriginObjectMoref -eq $entity.OwnerMoref -and !$_.Objuuid}).DestinationObjectMoref -server $destinationVC).ResourcePool -Server $destinationVC

$CreatedVapp = get-view -id  $ClusterResourcePool.CreateVApp($entity.ObjectName, $resSpec, $configSpec, $vmFolder) -Server $destinationVC

if ( $CreatedVapp.vappconfig.InstanceUuid -ne $entity.Objuuid ) { Write-Error "We have failed to created vapp with the same uuid"}

#Moving vms into the vAPP
$VMsOldMorefs = $EntityConfig.Key|%{$_.toString()}
$OldVMs = import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8 | ? { $VMsOldMorefs -contains $_.vmmoref }
$newVMs = $oldVMs.Objuuid | % {get-view -viewtype virtualmachine -Filter @{'config.uuid'=$_} -Server $destinationVC}
$createdvapp.MoveIntoResourcePool($newVMs.moref)
#Let's make proper order in vapp

foreach ($entry in $EntityConfig)
{
$oldkey = (import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8 | ? {$_.vmmoref -eq $entry.Key.ToString() }).Objuuid
$newkey = (get-view -viewtype virtualmachine -Filter @{'config.uuid'=$oldkey} -Server $destinationVC).moref
$entry.key=$newkey

}

$newconfig = new-object VMware.Vim.VAppConfigSpec
foreach ($entry in $EntityConfig)
{

$newEntityconfig =  new-object VMware.Vim.VAppEntityConfigInfo
$newEntityconfig.Key = $entry.key
$newEntityconfig.Tag = $entry.tag
$newEntityconfig.StartOrder = $entry.StartOrder
$newEntityconfig.StartDelay = $entry.StartDelay
$newEntityconfig.WaitingForGuest = $entry.WaitingForGuest
$newEntityconfig.StartAction = $entry.StartAction
$newEntityconfig.StopDelay = $entry.StopDelay
$newEntityconfig.StopAction = $entry.StopAction
$newEntityconfig.DestroyWithParent = $entry.DestroyWithParent

$newConfig.EntityConfig += $newEntityconfig

}

$CreatedVapp.UpdateVAppConfig($newConfig)
}
#we have now updated entityconfig

For the vapps part :

Foreach ($entity in (import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8 | ? {$_.OriginObjectMoref -like "VirtualApp-resgroup-v*" -and $_.OwnerMoref})){
#entity is now
#ObjectName             : LABS_Greg
#OriginObjectMoref      : VirtualApp-resgroup-v241
#DestinationObjectMoref : Folder-group-v4284
#Objuuid                : 5038914a-df12-abcc-77aa-2d2991ccaa2e
#DestMorefDC            :
#vmtxpath               :
#vmtxHost               :
#OwnerMoref             : ClusterComputeResource-domain-c7

#First we prepare the configs for our Vapp entity
$EntityMemoryAllocationXML = Import-Clixml -LiteralPath ('C:\'+$data.Objuuid+'MemoryAllocation')
$EntityCpuAllocationXML = Import-Clixml -LiteralPath ('C:\'+$data.Objuuid+'CpuAllocation')
$EntityConfig = Import-Clixml -LiteralPath ('C:\'+$data.Objuuid+'EntityConfig')
$resSpec = New-Object VMware.Vim.ResourceConfigSpec
$resSpec.cpuAllocation = New-Object VMware.Vim.ResourceAllocationInfo
$resSpec.cpuAllocation.reservation = $EntityCpuAllocationXML.Reservation
$resSpec.cpuAllocation.expandableReservation = $EntityCpuAllocationXML.expandableReservation
$resSpec.cpuAllocation.limit = $EntityCpuAllocationXML.limit
$resSpec.cpuAllocation.shares = New-Object VMware.Vim.SharesInfo
$resSpec.cpuAllocation.shares.shares = $EntityCpuAllocationXML.shares.shares
$resSpec.cpuAllocation.shares.level = $EntityCpuAllocationXML.shares.level
$resSpec.memoryAllocation = New-Object VMware.Vim.ResourceAllocationInfo
$resSpec.memoryAllocation.reservation = $EntityMemoryAllocationXML.Reservation
$resSpec.memoryAllocation.expandableReservation = $EntityMemoryAllocationXML.expandableReservation
$resSpec.memoryAllocation.limit = $EntityMemoryAllocationXML.limit
$resSpec.memoryAllocation.shares = New-Object VMware.Vim.SharesInfo
$resSpec.memoryAllocation.shares.shares = $EntityMemoryAllocationXML.shares.shares
$resSpec.memoryAllocation.shares.level = $EntityMemoryAllocationXML.shares.level

$configSpec = New-Object VMware.Vim.VAppConfigSpec
$configSpec.InstanceUuid = $entity.Objuuid
$vmFolder = $Entity.DestinationObjectMoref


#(import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8| ?{$_.OriginObjectMoref -eq $data.OwnerMoref -and !$_.Objuuid})
#$ClusterResourcePool = (import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8| ?{$_.OriginObjectMoref -eq $data.Objuuid -and !$_.Objuuid}).DestinationObjectMoref

$ClusterResourcePool = get-view -id (get-view -id (import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8| ?{$_.OriginObjectMoref -eq $data.OwnerMoref -and !$_.Objuuid}).DestinationObjectMoref -server $destinationVC).ResourcePool -Server $destinationVC

$CreatedVapp = get-view -id  $ClusterResourcePool.CreateVApp($data.ObjectName, $resSpec, $configSpec, $vmFolder) -Server $destinationVC

if ( $CreatedVapp.vappconfig.InstanceUuid -ne $entity.Objuuid ) { Write-Error "We have failed to created vapp with the same uuid"}

#Moving vms into the vAPP
$VMsOldMorefs = $EntityConfig.Key|%{$_.toString()}
$OldVMs = import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8 | ? { $VMsOldMorefs -contains $_.vmmoref }
$newVMs = $oldVMs.Objuuid | % {get-view -viewtype virtualmachine -Filter @{'config.uuid'=$_} -Server $destinationVC}
$createdvapp.MoveIntoResourcePool($newVMs.moref)
#Let's make proper order in vapp

foreach ($entry in $EntityConfig)
{
$oldkey = (import-csv -LiteralPath C:\databasefile.csv -Encoding UTF8 | ? {$_.vmmoref -eq $entry.Key.ToString() }).Objuuid
$newkey = (get-view -viewtype virtualmachine -Filter @{'config.uuid'=$oldkey} -Server $destinationVC).moref
$entry.key=$newkey

}

$newconfig = new-object VMware.Vim.VAppConfigSpec
foreach ($entry in $EntityConfig)
{

$newEntityconfig =  new-object VMware.Vim.VAppEntityConfigInfo
$newEntityconfig.Key = $entry.key
$newEntityconfig.Tag = $entry.tag
$newEntityconfig.StartOrder = $entry.StartOrder
$newEntityconfig.StartDelay = $entry.StartDelay
$newEntityconfig.WaitingForGuest = $entry.WaitingForGuest
$newEntityconfig.StartAction = $entry.StartAction
$newEntityconfig.StopDelay = $entry.StopDelay
$newEntityconfig.StopAction = $entry.StopAction
$newEntityconfig.DestroyWithParent = $entry.DestroyWithParent

$newConfig.EntityConfig += $newEntityconfig

}

$CreatedVapp.UpdateVAppConfig($newConfig)
}
#we have now updated entityconfig