Users

All Posts (11)

avatar

(user deleted)

Disabled

Creating a nested folder structure with Powershell

avatar
avatar
avatar

Hello Richard and thanks, that works. Somehow my previous reply seems to be gone? I had answered last week already.

Creating a nested folder structure with Powershell

avatar
avatar
avatar

I'm in the process of automating our RDM SQL Database by fetching data from an Oracle DB inventory and transforming it into RDM Session objects.

The issue I run into is create subfolders. Let's say I want to create a folder for each customer and then a subfolder for their branch offices, so:

- ACME
---- Amsterdam
---- Brussels
---- Berlin
---- London
---- Paris

If I do

new-rdmsession -Type "Group" -Name "ACME"

I will get my folder on the first level alright. But on the second level, things go wrong. According to old documentation (your cmdlets are great but not very well documented), one can use

new-rdmsession -Type "Group" -Name "ACME\Amsterdam"

The interesting result is that I then get the following:

- ACME
---- ACME\Amsterdam
---- ACME\Brussels
---- ACME\Berlin
---- ACME\London
---- ACME\Paris

This happens independent of ACME already existing or not. It's a step in the right direction, but not entirely right. Am I doing something wrong or is this a bug? Using RDM Enterprise 2022.2.20.0 x64 by the way.

Thank you in advance.

Trouble with Active Directory Integration

avatar
avatar
avatar

Hello again Érica. It was a conceptual error from me: I connected RDM directly to the SQL server and not to the DPS!

A million thanks to Alexandre who spotted that!

Trouble with Active Directory Integration

avatar
avatar
avatar

Alrighty, I'm online.

Trouble with Active Directory Integration

avatar
avatar
avatar

Hello Érica and thank you. I'm available until 18:00 CET (which is 13:00 EST). If not otherwise possible, I can login from home after 21:00 CET (16:00 EST).

Trouble with Active Directory Integration

avatar
avatar
avatar

Hello. Sorry for my late reply, but I was on-site with a customer.

I created a new SQL instance and made a new DB. This time I used NetBios name instead of UPN (though I still don't understand why the behaviour would be different). The Vault website and Chrome plugin work fine now, but Remote Desktop Manager says user ACME\Bla cannot logon.

In principle I need to take a decision today (CET) on buying the product and I would really like to buy it, but I can't demo it to the people whose approval I need.

Trouble with Active Directory Integration

avatar
avatar
avatar

Hi. I'm testing the Vault until tomorrow before deciding to buy the product. I run into some trouble.

I copied the data from my RDM DB to DPS and defined roles. So far so good, but I have an issue with the user management. If I connect myself through the Password Server or RDM, it creates me as DOMAIN\username. When I try to use the DPS website or import from AD, it creates the user as username@DOMAIN (even though I logon to the website as DOMAIN\username). Somehow it does not see that those users are the same. Result: AD users cannot logon in RDM (... even though the error does show it couldn't login with DOMAIN\username) and users exist twice, once in every format. Which is a problem for the private vault. Can anyone explain why this is happening?

On a side note, the server is a single instance MSSQL Express with one DB for RDM and another DB for DPS.

RDM Database: where are the credentials stored?

avatar
avatar
avatar

Hi,

It's encrypted in the raw data. You should try to use the PowerShell SDK instead. I don't think it's a good idea or even easy to access the database directly.

https://help.remotedesktopmanager.com/index.html?tools_consoles_powershell.htm

Regards

Merci David. I wrote a PoSh script that does exactly what I want. Here's the relevant part:

$arrCredential = @()

$arrSession = @(get-rdmsession | where-object {$_.ConnectionType -eq 'credential'})

foreach ($objSession in $arrSession){

$objCredential = new-object -typename psobject

$objCredential | add-member -membertype noteproperty -name Group -value $objSession.Group

$objCredential | add-member -membertype noteproperty -name Name -value $objSession.Name

$objCredential | add-member -membertype noteproperty -name Domain -value $objSession.HostDomain

$objCredential | add-member -membertype noteproperty -name Username -value $($objSession | get-rdmsessionusername)

$objCredential | add-member -membertype noteproperty -name Password -value $($objSession | get-rdmsessionpassword -asplaintext)

$arrCredential += $objCredential

}

$arrCredential

Even though it's a different product: we are considering to buy Devolutions Password Server. The DB looks the same, but does it also have Powershell support so I can do the same? It's an important requirement for us to be able to export the data.

RDM Database: where are the credentials stored?

avatar
avatar
avatar

Hi. I need to compare credentials between different systems and an Oracle DB. I've been looking for a bit where these are hidden in the (in our case) MSSQL Express DB used by RDM. I can find pretty much all data in there but not credentials. They must be encoded in there or it wouldn't be possible to see them plain-text inside the app. The only thing I find is a dbo.Credential but that only has an ID column and seems empty. Now, I'm a sysadmin and not a real DBA, so I might be missing something here.

Devolutions Password Server uses the same DB structure I saw so I guess an answer to this question would be valid for the other product too.

Slightly different approach to the search function

avatar
avatar
avatar
avatar
avatar

Hello,

It's possible to use the boolean filter in RDM, like mentioned here

https://help.remotedesktopmanager.com/view_searchfilter.htm

Could you give it a try?

Best regards,

Hi. I wasn't aware of this. Works like a charm. I think && should be default behaviour personally, but I'm happy with this solution for myself, thanks a lot.

Slightly different approach to the search function

avatar
avatar
avatar
avatar
avatar

Hello dev team,

I manage about 1500 devices through RDM, so the search is very important for me. The thing that bothers me is that when looking for e.g. 'DC Paris' I only get machines with specifically the string 'DC Paris' in one of the DB fields. More interesting it would be to get a list of all machines that both have a tag or description with DC and one with Paris. Right now I search for DCs only or Paris only, but in both cases I have to look for my stuff in a big list with irrelevant hits.

So basically, I'd like the space in the search to be interpreted not literally but as a delimiter between search terms. For literal interpretation quotes could be used, like in most search engines.

Thank you for considering.

1 - 11 of 11 items