How to get list of all properties from Credentials

[Ernest1]

Hello everyone,

I am looking for a good solution to get all properties from credentials without knowing the name of each properties.

Some of our processes reference Properties Values ​​in the BP data vault. However, I would like to get a list of all available properties from given Credential (just the name is enough) as a collection, and then get the value. Is this even possible?

The thing is I don't know all the property names that are exist there, so I'd like to download them all to look through. Unfortunately I don't have access to the Credentials screen.

Any suggestions are great.

Many thanks,

[VanamalaSrinivas]

Hi @Ernest1,

If you know the credential name, using the database we can achieve this (considering you have read access to DB).

In Blue Prism Database we have tables related to credentials. So, consider you credential name is 'Login' and has property names as 'AppId' and 'ObjectID' which we create in 'Credentials' in System Tab.
This credential name (our case its 'Login') gets stored in 'BPACredentials' Table and the properties get stored in 'BPACredentialsProperties' Table in Blue Prism database.

Hence using this, we can write a query using both the tables 

select name

from [dbo].[BPACredentialsProperties] 

where credentialid in 

(select id from [dbo].[BPACredentials] where name = 'Login')
this would give you all the property names of a given credential.
To get this into the collection, we could use the 'Data OLEDB' VBO and the actions - Set connection, Open Connection, Get Collection and Close.
Here the connection string we need to pass the necessary access credentials to establish the connection between BP and DB.

Thank you!
Srinivas

[david.l.morris]

[Edit: I just noticed the OP's post is from 6 months ago. I think it's still a good idea to have answered it, but I imagine it's too late to help the OP. Whoops.]

I don't know why this doesn't exist, but it doesn't as far as I know. It is valid to do a query on the BP database to get that, but frankly if I were you'd I'd just ask for permission to the Credentials view. If this is just in DV, I don't see why that would be a problem unless you are only given access to specific credentials. If they are limiting your access to only certain credentials, then the only valid way I'd say is to ask someone with access to screenshot the properties for you.

[david.l.morris]

I was thinking about this more. There is at least one other way to determine what properties a credential has, but it requires access to the Releases tab and the ability to create/edit packages and releases. Even if you don't have access to Manage Credentials, you can create a package that contains the credentials in the environment, and then export a release of that package. It does not export any of the masked information of course. It's more just a shell of the credential, but it does have the list of properties when it exports. Then you can look at the release in something like Notepad or Notepad++, and there will be a section for each credential called 'properties' if that credential has any properties.

Of course this doesn't help if you're trying to dynamically retrieve the properties list for some reason. But I don't know why you'd want to do that. So, if it's just so you can develop and use the credential and for some reason no one is telling you the property names, then you could use this method to figure it out. It does seem like someone is not helping you who should be though.