SQL to remove accounts from groups?
SQL to remove accounts from groups?
Comments
-
I have moved a copy of our production environment to a test environment, because of this I have groups with accounts that I want to empty. Is there an SQL query that can help with this?
-
Hello!
This is the query you could use for that purpose:
select * from account_group_join
where account_id != ADMINISTRATOR ACCOUNTIf you turn this into a delete statement, it will delete all group associations except the default admin account of course. Also note that you can filter GROUP_ID to exclude "GROUP" to return more specified associations.
entity_group is the group table to reference if youre looking for group names. You will need to perform a restart for these changes to be effective.
Howdy, Stranger!
Categories
- 4.2K All Categories
- 68 General
- 11 Training
- 203 Installation / Setup
- 1.1K Flows
- 108 Rules
- 264 Administration
- 212 Portal
- 494 General Q & A
- 702 Forms
- 334 Reports
- 3 Designer Extensions
- 47 Example Flows
- 53 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 180 Pages
- 5 Process Mining
- New Features
- 181 Datastructures
- 69 Repository
- 222 Integrations
- 28 Multi-Tenant
- 27 SDK
- 81 Modules
- 57 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 106 Lunch And Learn Questions