5.2.7 Metering Log Output Command

Command Name: fscsm_meteringexport

Format

fscsm_meteringexport [-start startingdate] [-end endingdate] -file output-file [-format formattype]

Description

Outputs a metering log. The log is output as a file in CSV or XML format.

In startingdate, specify the start date of the target period for which metering logs are to be output, in the format, YYYY-MM-DD. When omitted, the date of the oldest data in the metering log is regarded as the start date.

In endingdate, specify the end date of the target period for which metering logs are to be output, in the format, YYYY-MM-DD. When omitted, the day before the date of command execution is regarded as the end date.

In output-file, specify the file name using a character string containing alphanumeric characters, hyphens ("-"), underscores ("_"), and periods ("."). This parameter cannot be omitted. If the specified file already exists, it will be overwritten.

In formattype, enter the file format of the file to be output. Specify "csv" to output in CSV format, or specify "xml" to output in XML format. This parameter can be omitted. When it is omitted, the log is output in CSV format.

Example

When outputting the information for May 2015 in the metering log as a CSV file

>fscsm_meteringexport -start 2015-05-01 -end 2015-05-31 -file meter201505.csv<RETURN>

When outputting all information up until the end of 2014 in the metering log as an XML file
```
>fscsm_meteringexport -end 2014-12-31 -file mater2014.xml -format xml<RETURN>
```

Output Format

When the metering log is output in CSV format, the content of the output file should look like the following:

# version, eventTime, event, resourceType, projectId, bizSystemId, menuId, extendedOptions, userId, resourceId, resourceIdentifier, systemDiskImage, dataDiskType, dataDiskNum, snapshotSize

2, "2015-01-01 00:00:00.000+0900", "ADD", "system", "prj001", "bizsys001", "menu001", "optionA,optionB", "user001", "", "", "", "", ,

2, "2015-01-01 01:00:00.000+0900", "ADD", "vm", "prj001", "bizsys001", "", "", "", "vm001", "type_small", "WS2012", "type_middle", 1,

2, "2015-01-01 02:00:00.000+0900", "START", "vm", "prj001", "bizsys001", "", "", "", "vm001", "", "", "", ,

2, "2015-01-01 03:00:00.000+0900", "STOP", "vm", "prj001", "bizsys001", "", "", "", "vm001", "", "", "", ,

2, "2015-01-01 04:00:00.000+0900", "CHANGE", "vm", "prj001", "bizsys001", "", "", "", "vm001", "type_middle", "WS2012", "type_middle", 1,

2, "2015-01-01 05:00:00.000+0900", "ADD", "slb", "prj001", "bizsys001", "", "", "", "slb001", "optionSLB", "", "", ,

2, "2015-01-01 05:00:00.000+0900", "ADD", "rdb", "prj001", "bizsys001", "", "", "", "rdb001", "optionRDB", "", "", ,

2, "2015-01-01 06:00:00.000+0900", "DELETE", "slb", "prj001", "bizsys001", "", "", "", "slb001", "", "", "", ,

2, "2015-01-01 06:00:00.000+0900", "DELETE", "rdb", "prj001", "bizsys001", "", "", "", "rdb001", "", "", "", ,

2, "2015-01-01 06:00:00.000+0900", "DELETE", "vm", "prj001", "bizsys001", "", "", "", "vm001", "", "", "", ,

2, "2015-01-01 07:00:00.000+0900", "DELETE", "system", "prj001", "bizsys001", "", "", "", "", "", "", "", ,