Hi Garrett. As you're in an onDemand environment, there are some tips & tricks you'll need to know to export out your documents.
I just ran a quick test against a client's Development environment. The attached text file shows the XOG I ran and the output received. Note the value in the documentLocation argument - it needs to be somewhere the onDemand server can understand and reach.
The /fs0/clarity1/share path is relative; each environment you're in intrinsically understands what this path is, so you don't have to modify your XOG as you move from Dev to Test to Prod. The test I ran was against the development environment, so the files have been placed in /home/[Client ID]/sftp/Development/... If I'd run the same test in the Test environment, the files would have been output to /home/[Client ID]/sftp/Testing/...
You're going to need a FTP client (I use FileZilla) to get at the documents which the XOG outputs, and access to your FTP site (assuming CA haven't already given this). The attached PNG file shows the output I received from the XOG I ran (please excuse the redactions!).
I've only run a quick & dirty test for the purpose of answering your main questions; I haven't yet established whether the XOG can (for example) recreate the folder path and proper file names/extensions. If not, you may need to create a manual or semi-automated (Excel and VBA?) process for this.
A couple of additional points. First, given the number of projects you're intending to interrogate I'd recommend using a GEL process. This will give the advantage of (a) automating the XOG and (b) providing feedback messages and exception handling. I'd also recommend working with the onDemand team to agree a mechanism for transferring the files from the FTP across to your company's environment - with 2000 projects you're likely to have a sizeable amount of data and the FTP will probably be unable to handle it (or it will take a month of Sundays).
My company has experience with the outcome you're trying to achieve, and we would be more than happy to work with you on this activity. Let me know if we can offer any assistance.
Thanks, and good luck!
Alistair Miller