Versions Compared

Version Old Version 9 New Version 10
Changes made by

MS

Lou M (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table accounting_event_vm

 

Field Namename

Field Typetype

Description

idVMAccountingEvent

BIGINT

ID event unique

idVM

INTEGER

ID of virtual machine owning the resource

idEnterprise

INTEGER

ID of Enterprise enterprise resource owner

idVirtualDataCenter

INTEGER

ID of Virtual Datacenter virtual datacenter facility owner

idVirtualApp

INTEGER

ID Virtual App virtual app resource owner

cpu

INTEGER

'cores' units

ram

INTEGER

Memory, in megabytes (MB)

hd

BIGINT

Local storage, in bytes (B)

startTime

TIMESTAMP

When a resource was created

stopTime

TIMESTAMP

When a resources was destroyed

consolidated

TINYINT

Flag for processed or not

costCode

TINYINT

Cost code assigned for pricing purposes

hypervisorType

VARCHAR

The type of hypervisor hosting the virtual machine

idDataCenterINTEGERID of Datacenterdatacenter
VirtualMachine-haHostedINTEGERFlag for hosted on HA-enabled PM or not (haEnabled)
antiAffinityINTEGERFor VMs in an anti-affinity layer
idHardwareProfileINTEGERID of hardware profile

...

This table stores details of reserved physical servers - one row for each reserved server.

 

Field NamenameField TypetypeDescription
idPMAccountingEventBIGINTUnique column identifier for the accounting event
idPhysicalMachineINTID of the physical machine, as defined in the kinton.physicalmachine table.
NOTE: Use the kinton_accounting ABQ_PM_ID_TO_NAME(id) function to obtain the machine name associated with the ID
idEnterpriseINTID of the ENTERPRISE, as defined in the kinton.enterprise table.
NOTE: Use the kinton_accounting ABQ_ENT_ID_TO_NAME(id) function to obtain the machine name associated with the ID
cpuINTThe number of physical CPUs in the machine
ramINTThe physical machine’s RAM (in MB)
startTimeTIMESTAMPThe time at which the machine reservation started
stopTimeTIMESTAMPThe time at which the reservation finished.   This value is NULL if the reservation is still active
idDataCenterINTID of the physical datacenter, as defined in the kinton.datacenter table.
NOTE: Use the kinton_accounting ABQ_DC_ID_TO_NAME(id) function to obtain the datacenter name associated with the ID
consolidatedTINYINTIndicates whether this row has been consoliated with other rows.   Currently this value is always 0
version_cINTSoftware controlled data version

 

Table accounting_event_repository

This table contains details of the repository usage. There is one row for each VM Template and Instance stored in the repository. Persistent VM templates are not included in this table, because they are stored as external volumes and charged separately.

 

Field NamenameField TypetypeDescription
idRepoAccountingEventBIGINTUnique column identifier for the accounting event
idImageINTID of the repository image, as defined in the kinton.virtualimage table.
NOTE: Use the kinton_accounting ABQ_IMG_ID_TO_NAME(id) function to obtain the image name associated with the ID
idEnterpriseINTID of the ENTERPRISE, as defined in the kinton.enterprise table.
NOTE: Use the kinton_accounting ABQ_ENT_ID_TO_NAME(id) function to obtain the machine name associated with the ID  
idImageTypeNameINTThe ID of the image type name in the generic accounting name table, use the kinton_accounting ABQ_OBJECT_ID_TO_NAME (id)  function to retrieve the actual type name.   Names are one of:
INSTANCE, TEMPLATE, INSTANCE-CONVERSION, TEMPLATE-CONVERSION
idImageFormatNameINTThe ID of the image format name in the generic accounting name table, use the kinton_accounting ABQ_OBJECT_ID_TO_NAME (id)  function to retrieve the actual format name.   Names are: VMDK_FLAT, RAW, etc. see the wiki API reference for further details
imageSizeBIGINTPhysical Size size of the repository image, in bytes
idRepositoryINTThe ID of the image repository as defined in the kinton.repository table
idRepositoryName (minus)INTThe ID of the repository name in the generic accounting name table, use the kinton_accounting ABQ_OBJECT_ID_TO_NAME (id)  function to retrieve the actual repository name. THIS FIELD WAS DEPRECATED IN ABIQUO 3.4
startTimeTIMESTAMPThe time at which the image was created in the repository
stopTimeTIMESTAMPThe time at which the image was deleted from the repository.  This value is NULL if the image still exists.
idDataCenterINTID of the physical datacenter, as defined in the kinton.datacenter table.
NOTE: Use the kinton_accounting ABQ_DC_ID_TO_NAME(id) function to obtain the datacenter name associated with the ID.  
consolidatedTINYINTIndicates whether this row has been consoliated with other rows.   Currently this value is always 0.
version_cINTSoftware controlled data version.


List of accounting event tables

The accounting event tables include the following.

  • backup
  • ds_storage
  • firewall
  • ips
  • loadbalancer
  • pm
  • protect
  • repository
  • storage
  • vlan
  • vm
  • vm_off
  • vm_on


...

The following rows are returned from ACCOUNT_PERIOD_USAGE_VW view:


Field

Name

name

Field

Type

type

Description

starttime

TIMESTAMP

Start of the time slice

endTime

TIMESTAMP

End of the time slice

idAccountingResourceType

TINYINT

Resource type posted: 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

enterprise resource owner

idVirtualDataCenter

INTEGER

ID

Virtual Datacenter

virtual datacenter owner

idVirtualApp

INTEGER

ID

Virtual App

virtual app resource owner

idVirtualMachine

INTEGER

ID virtual machine owning the resource

enterpriseName

VARCHAR

Company

Name

name resource owner

virtualDataCenter

VARCHAR

Virtual

Datacenter

datacenter name resource owner

virtualApp

VARCHAR

Virtual

App Name

app name resource owner

virtualmachine

VARCHAR

Virtual

Machine Name

machine name resource owner

costCode

VARCHAR

Cost code of

Virtual Image

virtual image. Only valid when the idAccountingResourceType is 1 (virtualmachine-vcpu)

idStorageTier

INTEGER

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

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)

(question)

(question) Public cloud region 

internal_provider_id

varchar(255)

(question)

(question)

account_id

varchar(255)

(question)

(question)


Every hour, the status of each resource implemented in the system is recorded, which can generate a large number of rows. Abiquo recommends that the table is periodically purged of resource information which is no longer required.

...

The resources in the accounting_event_detail table are represented with a numerical value, as defined in the table below in the idAccountingResourceType column.

Parameter Namename

idAccountingResourceType

VirtualMachine-vcpu

1

VirtualMachine-vram

2

VirtualMachine-vhd

3

ExternalStorage

4

IPAddress

5

VLAN

6

VirtualMachine-hypervisorType

7

VirtualMachine-haHosted

8

ReservedPhysicalMachine-cpu

9

ReservedPhysicalMachine-ram

10

RepositoryStorage

11

VirtualMachine-antiAffinity12
VirtualMachine-tierhd13
backup_usage/backup_policy14
vm_usage_on/vm_on - cpu_usage_on/cpu_on15
vm_usage_off/vm_off - cpu_usage_off/cpu_off16
memory_usage_on/memory_on17
memory_usage_off/memory_off18
firewall_usage/firewall19
loadbalancer_usage/loadbalancer20
draas_protection_usage/draas_protection25

...

Description of resource owners

1. Virtual Machinemachine

  • Cores
  • RAM
  • Local storage

  • Cost codes (if the VM template has a cost code)

    Note

    Grouped virtual machine components and virtual machines are accounted per group, not per individual virtual machine.


2. Virtual Applianceappliance

  • Groups of virtual machines
    • Cores
    • RAM
    • Local storage

    • Cost codes (if the VM template has a cost code)

      Note

      Grouped virtual appliances are accounted per group, not per individual virtual appliance.


3. Virtual Datacenterdatacenter

  • Groups of virtual machines
  • Groups of virtual appliances
    • Cores
    • RAM
    • Local storage
    • VLANS
    • Public IPs

    • External storage

      Note

      Virtual Datacenter accounting is the total of the resources reserved and/or consumed by the Virtual Machines, Virtual Appliances, and users of a Virtual Datacenter.


...