Create Custom Copy Actions in Context Menu
0 vote
I am creating a 'Custom Credential Entry'*. I would like to have custom copy actions. We currently have a number of Oracle databases, and we find ourselves needing two types of strings:
1) And sql connection string that looks like this:
sqlplus %USERNAME%/%PASSWORD%@%HOST%/%SERVICE_NAME%
2) A tnsnames.ora type of string that looks like this:
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = %HOST%)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = %SERVICE_NAME%))
My current work around is to use the Domain field for this. I have two separate $Result.Domain commands defined, but I have to comment one out as I can only have one defined at a time:
$Result.Domain = "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = $PARAMETER3$)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = $PARAMETER4$)))";
#$Result.Domain = "sqlplus $PARAMETER1$/$PARAMETER2$@$PARAMETER3$/$PARAMETER4$";
NOTE: I have the appropriate username, password, host etc...defined in the Parameters section
So what I would like to be able to do/add is have more Copy Commands:
*NOTE: I know I can access the 'Copy Connection String' option if I create a credential type of Connection String. But there are many fields blocked that I cannot edit:
Perhaps this is a permissions issue on my end, but I cannot change the Data source field. I cannot modify the host, username, or password field. So the only field I can enter is the connection string. If I want to be able to copy the TNS Names definition and the SQL Connection string, I must create two credentials entry:
1) A 'Custom' credential entry where I define the Domain as the tnsnames.ora definition (hacky workaround)
2) A 'Connection String' credential entry, where I define the connection string
I would like to avoid having to create two credential entries for the same database, and be able to just add some copy commands to one credential entry. Perhaps I can do this using some powershell scripts? Can I add Custom Fields to the Clipboard context menu?
All Comments (4)
Hello,
For clarification, about the Connection String entry, you can either enter the connection string manually in the field, or you can press the [...] browse button to enter the fields manually there, according to the type of connection string you want. The reason the Host/Username/Password fields are there and in read-only mode is because they are extracted from the connection string itself. For this type of entry, RDM only saves the connection string, not all the values within it. Hope that makes sense.
For your request about improving the "Custom credential" entry with custom copy buttons, I think we could do something for that. We will have to figure out a way to make it flexible but I think it's a great idea and would add a lot of use cases for the Custom Credential entry. I have opened a ticket internally.
Regards,
Hubert Mireault
Thank you! That would be very helpful!
Another use case I have would be copying a string that is formatted like this:
Domain\Username
I see there is a copy action for username\password, but not one for Domain\Username
I often have to log into dozens of servers, and run processes as a service account, and
these accounts can be in different domains.
If we could somehow define our own copy commands, I could easily create a copy command for this
Obviously, it isn't too difficult to manually type in the domain, so this isn't a 'need to have', just a 'nice to have'
If you never want to copy the username by itself and always want "domain\username", you could change the "Username format" in your credential entry for "{Domain}\{User}":
Perhaps it could make things less annoying for you while waiting for the feature.
Regards,
Hubert Mireault
Thank you! That works for several of our accounts where we always will want that Domain\Username.
There are more accounts where I would need either/or. But this is certainly an acceptable work around for now.