141
Hello,
I am currently working on reducing our storage capacity and one of our top 10 storage cause tables is the "UserQueryBase".
This currently occupies ~8 GB in our production environment.
Does anyone have experience with this table and can answer the following:
Many thanks in advance!
Click on Validate Query after that it will show Record Count in below highlighted part then click on Delete Records:
Hello!
Thank you for your fast answer.
I would like to try it out in our test instance and loaded the bulk delete tool. I tried to write down the code like you but it doesnt look like on your end. What did I do wrong here?:
Hi,
Please check below link about "User Query Base".
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/reference/userquery?view=dataverse-latest
1. when is this table filled?
Answer- It store the personal views owned by CRM user.
2. how can this table be reduced?
Answer:- You can Bulk Delete Tool of XRMtoolbox with below query
Below I have used
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (