Page Comparison

starttime

TIMESTAMP

Start of the time slice

endTime

TIMESTAMP

End of the time slice

idAccountingResourceType

TINYINT

Resource type posted, for example:
virtualmachine-vcpu, virtualmachine-vram, virtualmachine-vhd,
ExternalStorage, IPAddress, VLAN, VirtualMachine-hypervisorType

resourceType

VARCHAR

Resource type (text)

resourceName

VARCHAR

Resource Name to account for.
A new resource type 'VirtualMachine-hypervisorType' is now recorded for each VM.
The Hypervisor Type is recorded in this 'resourceName' column.

resourceUnits

BIGINT

Resource units to account for

idEnterprise

INTEGER

ID enterprise resource owner

idVirtualDataCenter

INTEGER

ID virtual datacenter owner

idVirtualApp

INTEGER

ID virtual app resource owner

idVirtualMachine

INTEGER

ID virtual machine owning the resource

enterpriseName

VARCHAR

Company name resource owner

virtualDataCenter

VARCHAR

Virtual datacenter name resource owner

virtualApp

VARCHAR

Virtual app name resource owner

virtualmachine

VARCHAR

Virtual machine name resource owner

costCode

VARCHAR

Cost code of virtual image. Only valid when the idAccountingResourceType is 1 (virtualmachine-vcpu), hardware profile, or VM

idStorageTier

INTEGER

Code associated with this storage resource's QoS/Tier level. Only valid for the 'External Storage' resource type
For storage resource types

costCodeName

varchar(255)

Name of cost code

storageTierName

varchar(40)

Name of storage tier 

idDataCenter

int(11)

ID of datacenter

dataCenterName

varchar(255)

Name of datacenter

idHardwareProfile

int(11)

ID of hardware profile 

idAccountingEvent

bigint(20)

ID of accounting event 

hypervisorType

varchar(255)

Hypervisor type (includes public cloud provider type) 

region

varchar(255)

Name of datacenter or public cloud region 

internal_provider_id

varchar(255)

ProviderID of the resource

account_id

varchar(255)

Optional, can be set with the enterprise property “internal_customer_id”