searching over all vaults and generate a report

searching over all vaults and generate a report

avatar

hello there

i am looking for a way to generate a report. the report roughly corresponds to the default report "expired guarantees". I am interested in the guarantees that will expire in the next 6 or 12 months

I should also have the fields OS and comments. The query should also search across all vaults, since we have a separate vault for each customer (approx. 300).

how can i do this exacly?
how does such a query look like?
can i get a csv or xlsx as a result?

Thank you for your support

All Comments (6)

avatar

Hello,
It does not exists for now and it's not easy to do inside of RDM since we don't load all the vault (for performance reason). It's a good idea that we could add in DPS since it has access to all the content.

Regards

David Hervieux

avatar

I do not quite understand. dps = devolutions Password server?
we have no dps...

It's about the hardware guarantee, so we don't need passwords

avatar

Exactly DPS is Devolutions Password Server. It's can be used as a data source for RDM and it's a different architecture to store the data. RDM can load only one vault at the time. This is a known limitation. I will check with the support team if they could create a script to navigate in PowerShell all the vault and extract the information that you need.

Regards

David Hervieux

avatar

that would be great! RDM would only be slow if the script was executed. it doesn't matter if it would take several minutes (we have about 2000 entries for all vaults).

avatar

Hello,

Give me a bit of time so I can provide you with a basic script to achieve this.

Thanks for your patience!

Best regards,

Alex Belisle

avatar

Hello,

I hope this is what you had in mind :

# depending from where you run it, you might need to import the powershell module
Import-Module "C:\Program Files (x86)\Devolutions\Remote Desktop Manager\RemoteDesktopManager.PowerShellModule.psd1;"
#If you have multiple data source configured on your RDM installation ;
Set-RDMCurrentDataSource -DataSource (Get-RDMDataSource -Name '<DataSource Name>');
# Set a Parameter for the limit date and csv File name
$Expiration = get-date -Year 2021 -Month 4 -Day 7
$FileName = 'c:\temp\ExpirationReport.csv'

# Processing
$Vaults = Get-RDMRepository
Foreach ($v in $Vaults){
    Set-RDMCurrentRepository -Repository $v;
    Update-RDMUI;
    $Sessions = Get-RDMSession | ? {($_.MetaInformation.Warranty -is [datetime]) -and ($_.MetaInformation.Warranty -lt $Expiration)};
    ForEach ($s in $Sessions){
        $csvRecord = [PSCustomObject]@{
            'Vault' = $v.Name
            'EntryName' = $s.Name
            'OS' = $s.MetaInformation.OS
            'Comment' = $s.Description
            'WarrantyExpiration' = $s.MetaInformation.Warranty
        } #CustomObject
        Export-Csv -InputObject $csvRecord -Append -Path $FileName;
    } #Sessions

} #vaults


As you see, I only included the fields you mentioned, but you can quite easily enrich this report by using this technique : https://help.remotedesktopmanager.com/pstipsandtricks.html?q=clipboard+copy

I left the script very basic so you can adapt it to your ow needs, the important is you get the gist of it, from there sky is the limit ;)
Let us know if we can help further.

Have a great one, stay safe!

Best regards,

Alex Belisle