script powercli to Assign tag in a category to vms and update

[CG21]

Hi,

I have a script to assign a tag in a category to vms from a csv

it works well  with powercli 6.5

but I have to replace the tag when the tag exists

or a powercli script to erase the tag with the category Application_Patch

the powercli scrip is :

Connect-viserver vcenter1 -user vcenteruser -pass vcenterpassword

$pathDev ="C:\Scripts\Tags_patch\ressources\"

set-location $pathDev

$CMDBInfo = Import-CSV C:\Scripts\Tags_patch\ressources\cmdbinfo.csv

ForEach ($item in $CMDBInfo)

{

$Name = $item.Name

$Tag = $item.Application_Patch

#Write-host "Nom SRV : " $name " Categorie"  $tag

Write-Host ".... Assigning $Tag in Category Application_Patch to $Name "

Get-VM $Name | New-TagAssignment -Tag $Tag

the csv file is like this :

"Name","Application_Patch"

"srv1","5_Autres"

"srv2","4_Nuit"

Thank you for your help

[LucD]

You could do something like this

Connect-viserver vcenter1 -user vcenteruser -pass vcenterpassword

$pathDev ="C:\Scripts\Tags_patch\ressources\"

set-location $pathDev

$CMDBInfo = Import-CSV C:\Scripts\Tags_patch\ressources\cmdbinfo.csv

ForEach ($item in $CMDBInfo)

{

    $Name = $item.Name

    $Tag = $item.Application_Patch

    #Write-host "Nom SRV : " $name " Categorie"  $tag

    Write-Host ".... Assigning $Tag in Category Application_Patch to $Name "

    $vm = Get-VM -Name $Name

    Get-TagAssignment -Entity $vm | where{$_.Tag.Name -eq $Tag} | Remove-TagAssignment -Confirm:$false

    New-TagAssignment -Entity $vm -Tag $Tag

}

[CG21]

it works tag addition but when I restart the script with another csv to replace the tag it does not replace it but adds it in the tags

[LucD]

What is in the other CSV? The same VMs, with another Tag?
Can you perhaps show what happens with a screenshot or the output of a Get-TagAssignment?

[CG21]

Yes the other csv is the same vms with another tag.

the assignment works well but it add the tag that is in the new csv,

and what I would like is replaced only the tag of the category _patch Application

Thank you for your help

[CG21]

if not the simplest is to have a script that erases the tags of each vms of the category Application_patch

[LucD]

It would probably be a lot easier when the TagCategory 'Application_Patch' had a Cardinality of Single instead of Multiple.

Then you could only have just 1 Tag in that TagCategory assigned.

I assume that is what you want?
Only one Tag assigned in the 'Application_Patch' Category?

If yes, you could do like this

Connect-viserver vcenter1 -user vcenteruser -pass vcenterpassword

$pathDev ="C:\Scripts\Tags_patch\ressources\"

set-location $pathDev

$CMDBInfo = Import-CSV C:\Scripts\Tags_patch\ressources\cmdbinfo.csv

ForEach ($item in $CMDBInfo)

{

    $Name = $item.Name

    $Tag = $item.Application_Patch

    #Write-host "Nom SRV : " $name " Categorie"  $tag

    Write-Host ".... Assigning $Tag in Category Application_Patch to $Name "

    $vm = Get-VM -Name $Name

    Get-TagAssignment -Entity $vm | where{$_.Tag.Category -eq 'Application_Patch'} | Remove-TagAssignment -Confirm:$false

    New-TagAssignment -Entity $vm -Tag $Tag

}

[CG21]

actually that's what I would like to do

or otherwise delete the tags of this category Aplication_patch to restart my script that works very well.
I just tried changing the category _patch Application cardinalite simple, it does not work. I enclose the error encountered

[LucD]

Did you try the last script I provided?

The error you see seems to be exactly what the Carnality Single should be doing, only allow one Tag in the Category to be assigned.

[CG21]

yes the error that I joined, is with the last script you provided

[LucD]

That is strange, because my last script didn't contain a line with 'Get-VM $Name | New-TagAssignment -Tag $Tag'.

Can you perhaps show the script you are using?

[CG21]

the script that i'm using:

Connect-viserver vcenter01 -user vcenteruser -pass vcenterpassword

$pathDev ="C:\Scripts\Tags_patch\ressources\"

set-location $pathDev

$CMDBInfo = Import-CSV C:\Scripts\Tags_patch\ressources\cmdbinfo.csv

ForEach ($item in $CMDBInfo)

{

    $Name = $item.Name

    $Tag = $item.Application_Patch

    #Write-host "Nom SRV : " $name " Categorie"  $tag

    Write-Host ".... Assigning $Tag in Category Application_Patch to $Name "

    $vm = Get-VM -Name $Name

    Get-TagAssignment -Entity $vm | where{$_.Tag.Category -eq 'Application_Patch'} | Remove-TagAssignment -Confirm:$false

    New-TagAssignment -Entity $vm -Tag $Tag

}

[LucD]

Now I'm really confused.

The last error message you included doesn't come from this script.

[CG21]

however it is this script that I launch, see attachment

I have to make a mistake somewhere but I do not see where

[LucD]

Now the error corresponds with the script you included.
Ok, the error seems to indicate that there is a Tag in the Application_Patch Category assigned, which the script doesn't seem to remove.

Hence the error on the New-TagAssignment.

Can you show the Tags assigned to the VM before the script runs?

Web Client - VM - Summary -Tags

[CG21]

"Can you show the Tags assigned to the VM before the script runs?

Web Client - VM - Summary -Tags"

--> should I put this in the script? to do what ?
or do I have to show you a print screen of the tag on a vm?

if not have you a script to erase the tag of the category Application_patch in each vm ?

[LucD]

Can you check if this removes all the Tags in the Tag Category 'Application_Patch' on the VMs?

Get-VM | Get-TagAssignment | where{$_.Tag.Category -eq 'Application_Patch'} | Remove-TagAssignment -Confirm:$false

[CG21]

the script runs without there is nothing happening

[LucD]

Strange, and does this show the Tag associations?

Get-VM | Get-TagAssignment | where{$_.Tag.Category -eq 'Application_Patch'} 

[LucD]

My bad, I forgot the Name for the Tag Category.

Try like this

Connect-viserver vcenter1 -user vcenteruser -pass vcenterpassword

$pathDev ="C:\Scripts\Tags_patch\ressources\"

set-location $pathDev

$CMDBInfo = Import-CSV C:\Scripts\Tags_patch\ressources\cmdbinfo.csv

ForEach ($item in $CMDBInfo)

{

    $Name = $item.Name

    $Tag = $item.Application_Patch

    #Write-host "Nom SRV : " $name " Categorie"  $tag

    Write-Host ".... Assigning $Tag in Category Application_Patch to $Name "

    $vm = Get-VM -Name $Name

    Get-TagAssignment -Entity $vm | where{$_.Tag.Category.Name -eq 'Application_Patch'} | Remove-TagAssignment -Confirm:$false

    New-TagAssignment -Entity $vm -Tag $Tag

}

[CG21]

thank you a lot . it works perfectly with the last script.

[Elahine8]

Hello, I just tried this script, unfortunately it shows me the following error message :

Apparently my category Name in my CSV is misinformed? Yet there are the names of my machines ... I do not understand, do you know what I can do? Thank you in advance for your answer.

Marion

[LucD]

I think the error refers to the VM Name in your CSV, not the Category Name

[Elahine8]

ok thank you, I will watch...

[Elahine8]

I still have a message that says that ... But no more name problem

[LucD]

Do all the Tags you are trying to assign already exist?

[Elahine8]

No. In fact I want to add the names of the owners of the machines.

So I have the category "proprietary" and my tags are the names of the people concerned. Only the "proprietary" category exists.

[LucD]

Can you show the script you are using, then we can add the Tag creation (if needed) at the correct location?

[Elahine8]

$pathDev ="C:\données\"

set-location $pathDev

$CMDBInfo = Import-CSV C:\données\Inventaire.csv

ForEach ($item in $CMDBInfo)

{

    $Name = $item.Name

    $Tag = $item.Propriétaire

    Write-Host ".... Assigning $Tag in Category Propriétaire to $Name "

    $vm = Get-VM -Name $Name

    Get-TagAssignment -Entity $vm | where{$_.Tag.Category.Name -eq 'Propriétaire'} | Remove-TagAssignment -Confirm:$false

    New-TagAssignment -Entity $vm -Tag $Tag

}

[LucD]

Try like this.

It uses a Try-Catch construct to create the Tag when it doesn't exist.

$pathDev = "C:\données\"

set-location $pathDev

$CMDBInfo = Import-CSV C:\données\Inventaire.csv

ForEach ($item in $CMDBInfo) {

   $Name = $item.Name

   $cat = Get-TagCategory -Name 'Propriétaire'

   Try {

   $tag = Get-Tag -Name $item.Propriétaire -Category $cat -ErrorAction Stop

   }

   Catch {

   $tag = New-Tag -Name $item.Propriétaire -Category $cat

   }

   Write-Host ".... Assigning $Tag in Category Propriétaire to $Name "

 

   $vm = Get-VM -Name $Name

   Get-TagAssignment -Entity $vm -Category $cat | Remove-TagAssignment -Confirm:$false

   New-TagAssignment -Entity $vm -Tag $tag

}

[Elahine8]

Connect-VIServer -Server 192.168.60.196 -Protocol https -User mcartalasadm -Password %MegaOzentis2014%

$pathDev ="C:\données\"

set-location $pathDev

$CMDBInfo = Import-CSV C:\données\Inventaire.csv

ForEach ($item in $CMDBInfo)

{

    $Name = $item.Name

    $Tag = $item.Tag

    Write-Host ".... Assigning $Tag in Category Propriétaire to $Name "

    $vm = Get-VM -Name $Name

    Get-TagAssignment -Entity $vm | where{$_.Tag.Category.Name -eq 'Propriétaire'} | Remove-TagAssignment -Confirm:$false

    New-TagAssignment -Entity $vm -Tag $Tag

}

thank you very much for your answers but I just found the error in the script. I highlighted the problem in bold, keeping everything going;)

[Ami01]

Thanks for this!

I was browsing the web and came across your script for updating VM tags. It worked well, however, doesn't assign a new tag to the VM. I've modified the script you provided as below... 

So main goal is to update the current tag of the VM that has the category "BACKUP" and replace it with a new tag that's in the same BACKUP category. Thanks in advance!

CSV content:

Name,PolicyName

ServerA,PolicyA

ServerB,PolicyA

Current VM setting:

VMName - Category - Tag

ServerA - BACKUP - Policy1

ServerB - BACKUP - Policy2

I'd like to update the tag as follows (as per the CSV file)

VMName - Category - Tag

ServerA - BACKUP - PolicyA

ServerB - BACKUP - PolicyA

______________

$pathDev = "C:\temp\TEMP_Anna\tagtag"
Set-Location $pathDev
$CMDBInfo = Import-Csv C:\temp\TEMP_Anna\tagtag\poltag.csv
ForEach ($item in $CMDBInfo)
{
    $Name = $item.Name
    $Tag = $item.PolicyName
    #Write-host "Nom SRV : "$name "Category"" $tag
    Write-Host "...Assigning $Tag in Category BACKUP to $Name "
    $vm = Get-VM -Name $Name
    Get-TagAssignment -Entity $vm | where{$_.Tag.Category.Name -eq 'BACKUP'} | Remove-TagAssignment -Confirm:$false
    New-TagAssignment -Entity $vm -Tag $Tag
}