Adding tags (or IP addresses) enmasse

Hello Bill,

You would first need to use the advanced search to get the required servers - https://docs.devolutions.net/rdm/windows/commands/view/panels/search/advanced/

You can then apply a tag with the custom PowerShell command for multiple entries at the same time - https://docs.devolutions.net/rdm/windows/powershell-scripting/custom-powershell-commands/

For example (this would replace any existing tag):

$connection.MetaInformation.Keywords = 'new-tag';
$RDM.Save();

This can also be used directly in the Devolutions.PowerShell module, by searching for the entries, applying the tag, and saving them if you do not wish to use the GUI.

Best regards,

Awesome thank you.

To be a little more clear I'm not pulling the list of servers from RDM, I have a list there that is synchronized with Active Directory (and since DNS is borked it doesn't work well). I am exporting a list from a management console, or using a powershell command and dumping that list into an Excel file because that console allows me to identify specific properties of servers (such as manually provisioned versus cloned). Both system types are in various OU's and there is not a consistent naming pattern.

Perhaps I could export excel to XML and load that in the advanced search? If I could do that then I could easily tag them all in RDM.

Essentially, I dump a list of servers into excel, fliter on the properties I want and then I can cut and paste those systems into notepad or excel. So I need a method to match names from my list with names inside RDM and then apply the tag.

Is that doable?

Thank you.

Hello Bill,

Using the PowerShell module, you could. My simple example will assume your entries are all in the same vault, that the name only exists once, and the CSV only has a Name header.

if(-not (Get-Module Devolutions.PowerShell -ListAvailable)){
    Install-Module Devolutions.PowerShell -Scope CurrentUser
}

# Adapt the data source name
$ds = Get-RDMDataSource -Name "NameOfYourDataSourceHere"
Set-RDMCurrentDataSource $ds

#Change to the correct vault
$Vault = Get-RDMVault -Name "Vault-name"
Set-RDMCurrentRepository -Repository $Vault

#Read the CSV, retrieve the associated entry, and update the tag
Import-Csv "path\system.csv" | ForEach-Object {
    $Session = Get-RDMSession -Name $($_.Name)
	$Session.MetaInformation.Keywords = 'new-tag'
	Set-RDMSession $session
}

#refresh the entries
Update-RDMEntries

Best regards,

Thank you very much. That is awesome. I will give it a try.

Hello Bill,

My pleasure; let us know if you have any issues!

Best regards,

Here is the script that ended up working for me;

#Change to the correct vault
$Vault = Get-RDMVault -Name "VAULTNAME"
Set-RDMCurrentRepository -Repository $Vault

#Read the CSV, retrieve the associated entry, and update the tag
Import-Csv "C:\Temp\RDM\SessionList.csv" | ForEach-Object {
write-host "Running against: $_.Name"
$Session = Get-RDMSession -Name $_.Name
$tags = $Session.MetaInformation.Keywords
$tags = $tags += ' MCS '
$Session.MetaInformation.Keywords= $tags
Set-RDMSession $session
}

#refresh the entries
Update-RDMEntries

With the C:\Temp\RDM\SessionList.csv being formatted as follows:

Name
Session1
Session2
Session3
etc


Thank you!

Hello Bill,

Thank you for sharing it with the community!

Best regards,