Hi folks,
We're moving to a new HCO/SWOSH environment that I've been building recently. Rather than carry all the cruft of 8 years of old and current data from our existing 2023.3 Orion platform we're starting from scratch for all the customer nodes etc. However, some things like alerts I did want to move over. Thanks to the folks here and my own epiphany in how the SWIS powershell cmdlets worked I've got nearly everything either moved or ready to move.
This leaves user accounts. All our users are authenticated via SAML, so there's a whole bunch of SAML groups of varying levels of privilege that need to be transferred. Rather than sit with two web GUIs side by side checking every single setting from current production to new production I've been looking at exporting the accounts.
Before I go down the rabbit hole of modifying some export/import scripts has anyone done this before?
I can see that orion.accounts has a 'create user' verb that you feed XML bundles to, which is fine if I can export into XML in the first place, but the nitty gritty of each group account's privileges/views is stored in the orion.usersettings table. That table doesn't have any command verbs associated with it, so I'd have to manually insert each group account into that table in SQL studio.
One thing I have to beware of is the time taken to research and build/test these scripts offset with the time taken to do a manual transfer of a couple of dozen groups by hand 
Anyone?
Cheers
Adrian
