OneStream Community

List of unused security user groups · 09-29-2022

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 OS that are no longer used/referenced anywhere in meta...

mathieu_cartel · 12-20-2023

Hi jkim, I just did that today. I'm not using the Remote BR, which probably explains the poor performances! But it's a first step: ' my own function that creates an insert statement string from a dataTable variable dt. Dim insertStatement As String =...

mathieu_cartel · 12-20-2023

I tried with SaveCustomDataTable and received a message saying it is not compatible with SIC. So for now, my best answer is with the insert statement which will only work with a small number of records

mathieu_cartel · 12-20-2023

Hi zwc Here is the code I use and it works: Using dbConn As DbConnInfo = BRApi.Database.CreateDbConnInfo(si, DbLocation.External,"[[your SIC Connection name]]")'.CreateCustomExternalDbConnInfo(si, DbProviderType.Gateway, "GRDWDB")dt = BRApi.Database....

Re: List of unused security user groups · 10-03-2022

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

OneStream Community

User Statistics

User Activity

List of unused security user groups

Re: Can we copy OS internal table data to external DB using SIC?

Re: SIC gateway connection to export OS table to SQL server

Re: SIC gateway connection to export OS table to SQL server

Re: List of unused security user groups