Metadata Update from List

Metadata Update from List

avatar

Hi,

Here is my script to create new sessions (or modify existing sessions) and fill in the Metadata from a file.

See attached file Fill-RDM-Data.ps1 Version 1.0.0

Regards,

Peter

<#.Synopsis

Fill-RDM-Data

.Description

Fill Data from erver into RDM

** Result:

0 = OK

<>0 = Number of Errors

.Parameter AddNewOnly

Does not update all Server, but only adds new Servers (No session existing)

.Parameter SetColors

Also sets default colors per network

.Notes

***** Versions

1.0.0 (16.04.2013): Peter.Cermak@porscheinformatik.at, Created

.Example

Fill-RDM-Data.ps1 -AddNewOnly

Add Session for new Servers

#>

param(

[parameter(mandatory=$false)][Switch]$AddNewOnly,

[parameter(mandatory=$false)][Switch]$SetColors

)

#######################################################################

# requires -version 2.0

# > Begin Background information

#######################################################################

# CSV File "d:\ServerList.txt" contians these lines:

#Server Location Rack Details PersonOS PersonApp Application Usage Network Description

#Server01 VCenter VM 0 User1 User3 App1 TEST NetInt Description1

#Server02 Loc2 Rack1 0 User2 User4 App2 QA NetWeb Description2

#Server03 Loc1 Blade01 3 User1 User4 App3 PROD NetDMZ Description3

# The fiels in the file mean:

# Server : Servername

# Location : Datacenter Location

# Rack : Rack Or Blade Enclosure Name

# Details : Rack Heigth Unit or Blade Enclosure Bay

# PersonOS : Responsible Person for the Servers OS

# PersonApp : Responsible Person for the Servers Main Application

# Application : The Servers Main Application

# Usage : PRODuctio, QualityAssurance, Test

# Network : Internal, Web or DMZ (used for Template Selectin, groups and optional colors)

# Description : Additional infos

# Existing Templates

# Template_RDP_NetInt

# Template_RDP_NetWeb

# Template_RDP_NetDMZ

#######################################################################

# > Begin Script

#######################################################################

$MyServerFile = "d:\ServerList.txt"

$ServerCSV = Import-Csv -Delimiter "`t" -Path $MyServerFile

# Define Session color (object) for the different Networks:

$SessionColor = "" | Select "NetInt","NetWeb","NetDMZ"

$SessionColor.NetInt = "#C0FFC0" # Green

$SessionColor.NetWeb = "#FF8080" # Red

$SessionColor.NetDMZ = "#FFFF00" # Yellow

# Initiate Statistics:

[int]$StatisticServerNew = 0

[int]$StatisticServerChanged = 0

[int]$StatisticServerSkipped = 0

[int]$StatisticServerError = 0

[int]$LineNow = 0

# Walk through the File

foreach ($ServerLine in $ServerCSV) {

$LineNow ++

# Define the Keywords from the File:

$Keywords = $ServerLine.Usage

$Keywords += "`r`n" + $ServerLine.Network

$Keywords += "`r`n" + $ServerLine.PersonApp

$Keywords += "`r`n" + $ServerLine.PersonOS

# Get Session for the current server:

$Session = $RDMSessions | where {$_.Name -eq "$($ServerLine.Server)"}

# If we don't find an existing session named after the server:

if ($Session.Name.length -lt 2) {

# New Server:

Write-Host ".Creating New Session '$($ServerLine.Server)'."

# Get the correct template for the servers network:

$TemplateID = ( Get-RDM-Template | where {$_.TemplateName -like "*$($ServerLine.Network)*"}).ID

# Create the Session:

$Session = New-RDM-Session -Group $($ServerLine.Network) -Host $($ServerLine.Server) -Kind "RDPConfigured" -Name $($ServerLine.Server) -TemplateID $TemplateID

# Workaround for shard Templates (needed in Version 8.2.0.0)

$Session.SharedTemplate = $false

# Never forget to save the created session:

$SaveRes = Set-RDM-Session -Session $Session

# Re-read the Session to metadata processing

$Session = $RDMSessions | where {$_.Name -eq "$($ServerLine.Server)"}

$StatisticServerNew ++

} else {

if ($AddNewOnly.IsPresent) {

Write-Verbose ".Skipping GHServer '$($ServerLine.Server)' because of parameter 'AddNewOnly'."

$StatisticServerSkipped ++

# next Server in list:

continue

}

$StatisticServerChanged ++

}

# Not existing or duplicate Session Name

if ( (-not $Session) -or ($Session.count -ge 2) ) {

Write-Host "-Error getting Session`r`n$(($Session | fl * | out-string).trim())" -BackgroundColor red

$StatisticServerError ++

# next Server in list:

Continue

}

# Don't refresh RDM:

Set-RDM-Session -Session $Session.session -NoRefresh

Write-Host ".Processing Server $LineNow '$($ServerLine.Server)', Session '$($Session.Name)', Network: '$($ServerLine.Network)'."

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "Keywords" -value "$KeyWords"

if ($SetColors.IsPresent) {

Set-RDM-Property -ID $Session.id -Property "Color" -Value $SessionColor.$($ServerLine.Network)

Set-RDM-Property -ID $Session.id -Property "GroupTab" -Value $ServerLine.Network

}

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "State" -Value $ServerLine.Rack

Set-RDM-Property -ID $Session.id -Property "Description" -Value $ServerLine.Description

# Defining The Server Hardware Type (VM, Blade, Rack) and set the corresponding fields:

if ($ServerLine.Rack -like "Blade*") {

$ServerType = "Blade"

# i use the ZIP code to identify the Blade Bay

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "ZipCode" -Value $ServerLine.Details

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "IsVirtualMachine" -Value "False"

# Integrated Lights out of HP Blade Enclosure Onboard Administrator:

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "ServerRemoteManagementUrl" -Value "https://$($ServerLine.Rack)-oa1"

# HP Mangement Homepage:

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "ServerHomePageUrl" -Value "https://$($Session.Name):2381/"

} elseif ($ServerLine.Standort -eq "VM") {

$ServerType = "VM"

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "IsVirtualMachine" -Value "true"

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "VirtualMachineName" -Value "$($Session.Name)"

} else {

$ServerType = "Rack"

# i use the ZIP code to identify the Racks Height unit where the server is locats

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "ZipCode" -Value $ServerLine.Details

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "IsVirtualMachine" -Value "false"

# Integrated Lights out of HP Rack mounted Server:

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "ServerRemoteManagementUrl" -Value "https://$($Session.Name)-ilo"

# HP Mangement Homepage:

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "ServerHomePageUrl" -Value "https://$($Session.Name):2381/"

} # < if ($ServerLine.Rack -like "Blade*")

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "CustomField1Title" -Value "PersonOS"

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "CustomField2Title" -Value "PersonApp"

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "CustomField3Title" -Value "Usage"

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "CustomField4Title" -Value "Application"

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "CustomField5Title" -Value "Description"

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "CustomField1Value" -Value $ServerLine.PersonOS

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "CustomField2Value" -Value $ServerLine.PersonApp

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "CustomField3Value" -Value $ServerLine.Usage

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "CustomField4Value" -Value $ServerLine.Application

Set-RDM-Property -ID $Session.id -Path "MetaInformation" -Property "CustomField5Value" -Value $ServerLine.Description

Write-Host "+Finished Server '$($Session.Name)', Type: '$ServerType'."

}

Write-Host ".Finished Fill-RDM-Data, Errors: $StatisticServerError , New: $StatisticServerNew , Changed: $StatisticServerchanged, Skipped: $StatisticServerSkipped"

return $StatisticServerError

edited by Peter Cermak (POI) on 4/16/2013

All Comments (1)

avatar

Peter,

Thank you for sharing. Job well done.

Best regards,

Stéfane Lavergne