SFDCUtil

SFDCUtil is a command line utility for interacting with the salesforce.com platform.

My initial goal was to be able to query the salesforce.com trust site via the command line.  This would allow me to do some neat things like write a script to email me if any of the PODs went down or to print the overall status on my desktop background with Geektool.  So far this is working pretty well.

Install it from Ruby Gems or download the code from github.

At this point you can query the trust site for all PODs or a single POD.  Recently I was asked what else I’m planning for this command line utility so here are my thoughts.

  • Generalized Query functionality based on the awesome databasedotcom package
  • Ability to query and modify the standard object configurations
  • Ability to query and update non-object based configuration
  • Ability to compare multiple salesforce.com instances/sandboxes
  • Ability to do bulk import/export (I’ll probably get this for free with the databasecom package but I don’t know yet)
  • Ability to print out the POD stats

Let me know what you think would be useful for a package like this.

I don’t get paid for this package so show some love by staring the package on github or posting a comment.

Example Usage

For now you can quickly get an update of the instance status using this command such as the following;

sfdcutil status
    Instance Status
 AP0 (Japan) Instance available
  AP1 (APAC) Instance available
  EU0 (EMEA) Instance available
         EU1 Instance available
         EU2 Instance available
   NA0 (SSL) Instance available
         NA1 Instance available
         NA2 Instance available
         NA3 Instance available
         NA4 Instance available
         NA5 Instance available
         NA6 Instance available
         NA7 Instance available
         NA8 Instance available
         NA9 Instance available
        NA10 Instance available
        NA11 Instance available
        NA12 Instance available
        NA13 Instance available
        NA14 Instance available
 CS0 (TAPP0) Instance available
         CS1 Instance available
         CS2 Instance available
         CS3 Instance available
         CS4 Instance available
         CS5 Instance available
         CS6 Instance available
         CS7 Instance available
         CS8 Instance available
         CS9 Instance available
        CS10 Instance available
        CS11 Instance available
        CS12 Instance available
        CS13 Instance available
        CS14 Instance available
        CS15 Instance available
        CS16 Instance available
        CS17 Instance available

Or you can just check a specific instance

$ sfdcutil status --instance "NA1"
    Instance Status
         NA1 Instance available

Project Links

John Rizzo
Director of Technology
Chief Technology Officer with over 17 years experience and expertise in design and delivery of cost-effective, high-performance financial technology solutions. All of these skills have been used to support rapid international growth with budget responsibilities exceeding $25 million annually. Senior Enterprise Architect with extensive hands-on development experience, as well as formal design and architecture background on many successful projects. A seasoned mentor for advanced SDLC practices. Exceptional at team building and motivating either at a peer-to-peer level, or in a leadership role. Excellent communications skills and ability to adapt to diverse environments and cultures effortlessly.

Full software life cycle experience with many industry standard methodologies including Agile development with Scrum and Extreme Programming (XP). Well versed in Test Driven Design (TDD) and Domain Driven Design (DDD). Can adapt to any phase of an existing project from Business
Modeling to Production Support. Technical strengths include OOA/OOD, Ruby, Python, C#, .NET 3.5/4.0, Java, J2EE, Internet Technologies, MSSQL, MySQL and Enterprise Integration.