Clean up "Duplicate groups"

Hello,

You could select all items in that report dialog and paste it into a .csv file.

Otherwise, I can ask an engineer if it is possible to send you a SQL statement to extract that information from the database.

Best regards,

If I do delete the entries with Powershell, should I leave all but one? Does the duplicate list display only non-essential duplicates, or would it include the "parent" as well (meaning I shouldn't delete "everything" in the list)?

Hello,

It will be impossible to remove duplicate groups with the PowerShell module because these non-essentials groups are not available through the Get-RDMSession or the Remove-RDMSession cmdlets. They must be removed with a SQL statement.

The list displays all duplicate groups. It also includes the group that is used in the tree view. So you must be careful when you delete an entry and only choose the one that is not displayed in the tree view.

I will check with an engineer and send you tomorrow by private message the information on how to remove those duplicate group with a SQL statement.

@everyone : If you also have duplicate groups in your data source, please write us an email at ticket@devolutions.net and we will send you the steps to remove them.

Best regards,

Coming back to this, I have >8000 duplicate groups now (says Database Diagnostics). Can you create a SQL Agent Job or something to delete these that comes with the product? Still unsure how to delete these, or if they're actually problematic.

Hello,

The feature to get rid of those duplicated groups has already been requested and it's still on our to do list. I will ask to increase the priority for this request.

In the meantime, could you please send an email to ticket@devolutions.net and will send you back the procedure to remove duplicated groups in the SQL database.

Best regards,