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
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
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
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
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).
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
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