Forum Discussion
mathieu_cartel
OneStream Employee
OneStream EmployeeList of unused security user groups
Hello all,
Asking for a client: they've been live for several years and they would like to perform a clean up of their security user groups. They need to obtain a list of the groups that exist in O...
JackLacavaOneStream Employee
OneStream EmployeeHey Mathieu,
I suspect deleting groups might not be a good idea because of references in historic data and audit tables, so after you've found the unused groups, maybe just rename them to X_HISTORIC_* and remove all members.
To locate fields, you might want to get clever with the API guide, which includes all schemas. If you look at the files contained in OneStreamAPIDetailsandDocumentation.zip, in the APIDetails folder there is an .hhc folder - that's a text file. I would search for things like "GroupUniqueID" to start with.
Hope this helps!
mathieu_cartelOneStream Employee
OneStream EmployeeThanks Jack and sorry for the late answer. I didn't know we had the schema fully documented in there so I'll take a look. I took a quick look at the DB from the SQL Server client and I know for sure that the field isn't always called like that which is going to make things a little longer. Cheers!