Favorite Export Method

[jhanna]

Operations Manager exports in a delimited format when you click on the "Link to graph data in spreadsheet format" button. Reports can also be exported in csv, html, text, perl, xls, and xml (with supporting css file!). Often, users will employ perl to "massage" the xml into specific formats such as MS Word xml and then use that xml to populate audit documents, for example. Another use of xml is to combine it with a css (Cascading Style Sheet format) file and incorporate it with a "web dashboard."

Do you export data from Operations Manager? What format do you export in most often? How do you use that exported data?

[reinoud7]

We use xls and parse the result automatically in SQL2005 (a script that runs every day).

[raja]

Using the 'dfm graph' command, you can also get the graph images shown in Ops Manager UI.

dfm graph [<options>] <graph-name> <name-or-id-to-graph> 
 
The options are
-s <start-date>
-e <end-date>
-D <date-format>
-F <output-format>

The <output-format> is the type of format in which the output will be generated. Supported output formats are text, html, csv, xls, png and gif.

The output for html, png and gif is in binary format and needs to be redirected to a file with proper extension to open it.

For example, to see the output of the graph 'volume-usage'

in gif format, issue the command like below

$ dfm graph -F gif volume-usage > graph.gif