We are in need of removing current visitor groups from our content and switching them to a different visitor group.The Visitor groups are mapped across multiple pieces of content as well as multiple sites.I am trying to build a SQL query for EpiServerCMS DB to piece together what content has what Visitor group associated with it so that we can pinpoint the changes and make them.
Is there a different tool I could use to access this information/is there a pre-existing query to pull this information together?
There wes a similar question on the forum not so long ago so it would be worth taking a look at the answers to that but, in summary, yes, there is a ready-built tool you could use to identify visitor group usage. It's called CMS Audit and it's available on the Episerver NuGet feed here:https://nuget.episerver.com/package/?id=N1990.Episerver.Cms.Audit
We supposedly tested this a year ago and it tanked our performace, but it looks like there were sufficient updates and this is quite the nifty tool.I'd still like to discover a way to query the database directly with SQL to acquire this information, but this will do.Thanks!