From mboxrd@z Thu Jan 1 00:00:00 1970 From: Xavier Maillard Subject: Org mode as an helper tool for my job position (DBA) Date: Sat, 15 Mar 2008 09:49:30 +0000 (UTC) Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1JbEAO-0006yG-Hw for emacs-orgmode@gnu.org; Mon, 17 Mar 2008 08:10:12 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1JbEAN-0006x1-15 for emacs-orgmode@gnu.org; Mon, 17 Mar 2008 08:10:12 -0400 Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1JbEAM-0006wu-Vf for emacs-orgmode@gnu.org; Mon, 17 Mar 2008 08:10:10 -0400 Received: from main.gmane.org ([80.91.229.2] helo=ciao.gmane.org) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1JbEAM-0006wr-FJ for emacs-orgmode@gnu.org; Mon, 17 Mar 2008 08:10:10 -0400 Received: from root by ciao.gmane.org with local (Exim 4.43) id 1JbEAE-000323-R3 for emacs-orgmode@gnu.org; Mon, 17 Mar 2008 12:10:02 +0000 Received: from cha51-2-82-244-211-40.fbx.proxad.net ([82.244.211.40]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 17 Mar 2008 12:10:02 +0000 Received: from xma by cha51-2-82-244-211-40.fbx.proxad.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 17 Mar 2008 12:10:02 +0000 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org Hi, I am a DBA (database administrator) with really tons of database (more than 200) to "survey". As such, I have written many tools for various tasks. Currently these tools produce logs (tons of) in many different formats. That's not very homogeneous but that's something I want to remedy. My current (en)vision is quite simple: outlined document. That's where org-mode enters the dance :) Currently reading/parsing/getting the right information from each tools is rather time consuming. Having org-mode based log format would speed this by a factor of 1000 (at least). Let take the example of an update statistics. What informations are really relevant for me is simply this: 1. server name 2. start date/end date 3. return code 4. database name Then for each table/index of the given database, I need this: 1. object name 2. status 3. time spent Each object would have extra informations as a note under the entry. Producing the right org-mode file structure from any script/c code is rather simple, in fact, I have done this as a quick and dirty hack for one tool. Where I am failing is in having a column view of the document (I want to be able to only view time spent for each object name to measure the performance of the last update statistics run). What would I need to add for each of the table/index "todo" entry to have this information at hand ? As an example, updating index statistics will present an org file like this one: #title Update statistics of sql server * General information - start date - end date - return code * Index statistics (I want column view from here for each object name) ** Index name 1 informations for index name 1 go here (time spent, etc...) ** Index name 2 * Index name ... I hope I have been clear :) Thank you for your feedback. Regards Xavier