Top
ServerView Resource Orchestrator Cloud Edition V3.2.0 User's Guide for Infrastructure Administrators
FUJITSU Software

6.2.6 CSV File Items

Use the [Save in CSV format] button to display downloaded CSV file items by category.
Note that the CSV file encoding is Shift-JIS.

6.2.6.1 Effective resource use (VMware virtual machine relocation)

This section describes CSV file items for different reports.

VMware rsc. usage cond. (List of host)

Item

Column name

Explanation

Unit

Description

CPU(VMW_PCPU)

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

Physical.CPU

recid

Record ID

VMW_PCPU

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmpcpul

CPU utilization

%

Average CPU usage ratio for physical CPUs

CPU(VMW_PCPU2)

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

_Total

recid

Record ID

VMW_PCPU2

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmpcusemhz

CPU usage

MHz

vmpccorenum

CPU core Number

number

vmpccoremhz

CPU speed per core

MHz

Memory (VMW_PMEM)

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

Physical.Memory

recid

Record ID

VMW_PMEM

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmpmemm

Physical memory size

Mbytes

vmpmusedmem

Memory usage

Mbytes

Disk(VMW_PDISK)

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

Name of the device inside VMware

recid

Record ID

VMW_PDISK

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmpdreads

Disk reading count

reads

Physical disk

vmpdwrites

Disk writing count

writes

Physical disk

vmpdmbread

Read size

Mbytes

Physical disk

vmpdmbwrt

Write size

Mbytes

Physical disk

Network (VMW_NET)

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

Names beginning with "vmnic" are physical NIC names; additionally, if the virtual machine name follows a colon, it is a virtual NIC.

recid

Record ID

VMW_NET

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmnppckttr

No. of outbound packets

packets

Physical or virtual network device port units

vmnpmvtr

Send size

Mbits

Physical or virtual network device port units

vmnppcktrecv

No. of inbound packets

packets

Physical or virtual network device port units

vmnpmbrecv

Receive size

Mbits

Physical or virtual network device port units

vmnvmname

Virtual machine name

If it is a virtual NIC, the virtual machine name is included.

Hardware resources information (VMW_PCPU2)

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

_Total

recid

Record ID

VMW_PCPU2

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmpcusemhz

CPU usage

MHz

vmpccorenum

CPU core Number

number

vmpccoremhz

CPU speed per core

MHz

Hardware resources information (VMW_PMEM)

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

Physical.Memory

recid

Record ID

VMW_PMEM

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmpmemm

Memory size

Mbytes

Physical memory size

vmpmusedmem

Memory usage

Mbytes

VMware rsc. usage cond. (Virtual machine stack)

Item

Column name

Explanation

Unit

Description

CPU

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

VMware unique ID is specified before the colon, and the virtual machine name is specified after the colon.

recid

Record ID

VMW_GCPU

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmgcusemhz

Virtual machine CPU usage

MHz

vmname

Virtual machine name

Memory

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

VMware unique ID is specified before the colon, and the virtual machine name is specified after the colon.

recid

Record ID

VMW_MEM

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmgmtm

Estimated size of the working set of a resource pool or a virtual machine

Mbytes

vmmvmname

Virtual machine name

Disk

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

recid

Record ID

VMW_DISK

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmdreads

Disk reading count

reads

Physical disk

vmdwrites

Disk writing count

writes

Physical disk

vmdmbread

Read size

Mbytes

Physical disk

vmdmbwrt

Write size

Mbytes

Physical disk

vmdvmname

Virtual machine name

Network

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

recid

Record ID

VMW_NET

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmnppckttr

No. of outbound packets

packets

Physical or virtual network device port units

vmnpmvtr

Send size

Mbits

Physical or virtual network device port units

vmnppcktrecv

No. of inbound packets

packets

Physical or virtual network device port units

vmnpmbrecv

Receive size

Mbits

Physical or virtual network device port units

vmnvmname

Virtual machine name

If it is a virtual NIC, the virtual machine name is included.


VMware virtual machine relocation simulation

Item

Column name

Explanation

Unit

Description

CPU

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

recid

Record ID

VMW_GCPU

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmgcusemhz

Virtual machine CPU usage

MHz

Memory

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

recid

Record ID

VMW_MEM

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmgmtm

Estimated size of the working set of a resource pool or a virtual machine

Mbytes

Disk

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

recid

Record ID

VMW_DISK

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmdreads

Disk reading count

reads

Physical disk

vmdwrites

Disk writing count

writes

Physical disk

vmdmbread

Read size

Mbytes

Physical disk

vmdmbwrt

Write size

Mbytes

Physical disk

Network

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

recid

Record ID

VMW_NET

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmnppckttr

No. of outbound packets

packets

Physical or virtual network device port units

vmnpmvtr

Send size

Mbits

Physical or virtual network device port units

vmnppcktrecv

No. of inbound packets

packets

Physical or virtual network device port units

vmnpmbrecv

Receive size

Mbits

Physical or virtual network device port units

Note

About the data output as CSV

At the collection start time, information for the analysis period is output. Data for anticipated periods in the future is not output.

6.2.6.2 Effective resource use (VMware resource allocation optimization)

This section describes CSV file items for different reports.

VMware rsc. usage cond. (List of virtual machine)

Item

Column name

Explanation

Unit

Description

CPU

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

VMware unique ID is specified before the colon, and the virtual machine name is specified after the colon.

recid

Record ID

VMW_GCPU

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmgcused

CPU utilization

%

vmgcallmin

resource allocation (reserved) of a resource pool or a virtual machine

MHz

vmgcallmax

resource allocation (Limit) of a resource pool or a virtual machine

MHz

If there is no limit, -1 will be displayed.

vmgcallshrs

resource allocation (Shared) of a resource pool or a virtual machine

MHz

The value for the shared memory of a VMware virtual machine

vmgcnumcpu

CPU number

number

vmgcusemhz

Virtual machine CPU usage

MHz

Memory

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

VMware unique ID is specified before the colon, and the virtual machine name is specified after the colon.

recid

Record ID

VMW_MEM

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmgmallim

reserved memory of a resource pool or a virtual machine

Kbytes

vmgmallmax

upper limit memory size of a resource pool or a virtual machine

Kbytes

If there is no limit, -1 will be displayed.

vmgmallsh

shared memory of a resource pool or a virtual machine

Kbytes

The value for the shared memory of a VMware virtual machine

vmgmmems

Physical memory size

Mbytes

resource pool or virtual machine units

vmgmtm

Estimated size of the working set

Mbytes

resource pool or virtual machine units

vmgmacest

Ratio of physical memory in use

%

resource pool or virtual machine units (instant value)<VMware ESX>

Note

About the data output as CSV

At the collection start time, information for the analysis period is output. Data for anticipated periods in the future is not output.

6.2.6.3 Demand Forecast (Resource pool)

This section describes CSV file items for different reports.

VM pool (CPU) (demand forecast)

Column name

Explanation

Unit

Description

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

tenanl name:/pool name

recid

Record ID

ROR_VMPOOLCPU

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmpoolprocused

VMPool CPU usage

GHz

vmpoolproctotal

VMPool CPU total size

GHz


VM pool (Memory) (demand forecast)

Column name

Explanation

Unit

Description

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

tenanl name:/pool name

recid

Record ID

ROR_VMPOOLMEM

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmpoolmemused

VMPool memory usage

Gbytes

vmpoolmemtotal

VMPool total memory

Gbytes


Storage pool (demand forecast)

Column name

Explanation

Unit

Description

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

tenanl name:/pool name

recid

Record ID

ROR_STORAGEPOOL

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmpoolserverused

StoragePool usage

Gbytes

vmpoolservertotal

StoragePool total capacity

Gbytes


Network pool (demand forecast)

Column name

Explanation

Unit

Description

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

tenanl name:/pool name

recid

Record ID

ROR_NETWORKPOOL

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmpoolnetworkused

Number of addresses being used by NetworkPool

number

vmpoolnetworktotal

Total number of NetworkPool addresses

number


Server pool (demand forecast)

Column name

Explanation

Unit

Description

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

tenanl name:/pool name

recid

Record ID

ROR_SERVERPOOL

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmpoolserverused

Number of servers used by ServerPool

number

vmpoolservertotal

Total number of ServerPool servers

number


Address pool (demand forecast)

Column name

Explanation

Unit

Description

sdattim

Collection start time

yyyy/mm/dd HH:mm:ss

sysname

System name

resrcid

Resource ID

tenanl name:/pool name

recid

Record ID

ROR_ADDRESSPOOL

consflag

Interval (flag displayed)

  • If collection interval is 10 minutes: 1

  • If collection interval is 1 hour: 2

  • If collection interval is 24 hours: 3

consintl

Interval

second

  • If collection interval is 10 minutes: 600

  • If collection interval is 1 hour: 3600

  • If collection interval is 24 hours:86400

coverage

Data coverage ratio

Displays the ratio of data collected during the interval from 0 through 1

vmpooladdressused

Number of addresses used by AddressPool

number

vmpooladdresstotal

Total number of AddressPool addresses

number

Note

About the data output as CSV

At the collection start time, information for the analysis period is output. Data for anticipated periods in the future is not output.