Monday, January 18, 2010

How to get ITM agent data in CSV format using GBSCMD

Here is a commonly asked question from our customers. How do I get the real time agent data exported to excel format (CSV) from command line for further analysis? Even though this can be done from Portal using a combination of logical workspaces and table view, it is real simple  with gbscmd tool.
 
With GBSCMD, you just invoke ct_get subcommand providing agent name and attribute group you're interested in.  For example, if you want to get the list of current disk usage information from a Windows OS agent, you can use the following command.
 
./gbscmd ct_get --auth itm62.auth --Object NT_Logical_Disk --target Primary:ITM62:NT  >> disk_usage.csv
 
If you would like to get this information on set of windows agents, you can easily loop thru them one after another like the example below.
 
for agent in `cat myagents.list`
do
 ./gbscmd ct_get --auth itm62.auth --Object NT_Logical_Disk --target $agent  >> disk_usage.csv
done
   
Hope you find this tip useful.

5 comments:

  1. Great stuff as usual Gulf Breeze. Your contributions to the ITM community are greatly valued.

    ReplyDelete
  2. Thank you very much for your appreciation!

    -venkat

    ReplyDelete
  3. Do we have a solution to get a csv file of what all is currently being monitored for a particular server.
    It's like generating a monitoring configuration report for a server.

    Thanks,
    Jasjit

    ReplyDelete
  4. Is there a way to generate a csv file for current attributes which are being monitored for a particular server.
    Something like generating a monitoring configuration report for a server.

    ReplyDelete
  5. Jasjit,

    There are couple of ways to acheive this. You can use "gbscmd showsit --managedsystem --auth " syntax to list the situations running on a particular managed system.

    There is a "tacmd listsit -m " as well.

    Hope this helps,
    -Venkat

    ReplyDelete