+ Start a Discussion

Query Multiple Sites at Once


We are a Salesforce partner and manage multiple customer Salesforce instances. One of the areas we manage for the customers is understanding any impact to their sites for Critical updates and release changes.

For example the CSRF Critical update coming
SAML Single Sign-on

In each of these cases we put together some SOQL and then log into Workbench for each site and run the SOQL to see if there is any potential impact for their site. As you can imagine this is pretty time consuming to do for every customer site.

There is a Workbench enhancer plugin for Chrome that looks interesting to help at least save the queries so don't have to paste each time.

I'm totally stoked about the Winter '18 release & DX dev w/ the new CLI & Visual Studio Code support w/ Artifacts.

The SFDX cli now supports WorkBench/Querying which is awesome and I'm now able to using the JWT auth w/ certificates to run WorkBench/SOQL querying against all our customer sites from a single script call.

This provides a report back of all the sites so we can better gauge any customer impact and focus efforts on deeper dive into the sites that are potentially impacted.

I'm looking at adding multi-site querying to the Salesforce WorkBench GitHub project to be able to select through the workbench experience to log into multiple sites using certificates and run for instance SOQL or other commands and the results would be coming for all the sites you specify & have Certificates loaded.

Is something anyone else would be interested in?  Know of any other ways to query multiple sites at once?

Thanks Dave