Skip to main content
lane_h
Helper ⭐️
August 1, 2017
Question

Deleting Usage Data

  • August 1, 2017
  • 4 replies
  • 88 views
We are trying to reduce our SFDC Storage. To do so, we need to remove some Usage Data. However, our CSM team is a heavy user of the Usage Widget. We would like to removed data for Customers in a certain plan or even customers who have canceled prior to April of this year. 

This will require a JOIN of some sort in SOQL between JBCXM__UsageData__c and JBCXM__CustomerInfo__c or the Account record.

The issue is, I'm not sure what the query would look like. I've done some research, but every time I try, WorkBench throws an error.

Can anyone help?

4 replies

smorrisgainsightcom
Helper ⭐️⭐️⭐️
August 1, 2017
Hey Lane what error are you getting when trying to get this to work?  Feel free to shoot me an email if that's easier as well.
lane_h
lane_hAuthor
Helper ⭐️
August 1, 2017
Thanks Scott! I shot you an email. I'm getting a Malformed Query error.
Director of CX and Scale Programs
smorrisgainsightcom
Helper ⭐️⭐️⭐️
August 1, 2017
Awesome glad we were able to figure it out!
lane_h
lane_hAuthor
Helper ⭐️
August 2, 2017
Thanks Scott! 
Director of CX and Scale Programs