Page Comparison

Field name

Field type

Description

idRepoAccountingEvent

BIGINT

Unique column identifier for the accounting event

idImage

INT

ID 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

idEnterprise

INT

ID 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  

idImageTypeName

INT

The 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

idImageFormatName

INT

The 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   
Names are: VMDK_FLAT, RAW, etc. see the wiki API reference for further details

imageSize

BIGINT

Physical size of the repository image, in bytes

idRepository

INT

The ID of the image repository as defined in the kinton.repository table

idRepositoryName

INT

Deprecated - The 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

startTime

TIMESTAMP

The time at which the image was created in the repository

stopTime

TIMESTAMP

The time at which the image was deleted from the repository.  This value is NULL if the image still exists.

idDataCenter

INT

ID 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.  

consolidated

TINYINT

Indicates whether this row has been consoliated with other rows.   Currently this value is always 0.

version_c

INT

Software controlled data version.

Parameter name

idAccountingResourceType

VirtualMachine

1

VirtualMachine-vcpu

1

VirtualMachine-vram

2

VirtualMachine-vhd (datastores)

3

ExternalStorage

4

IPAddress/IPAddress (public IP)

5

VLAN

6

VirtualMachine-hypervisorType

7

VirtualMachine-haHosted

8

ReservedPhysicalMachine-cpu

9

ReservedPhysicalMachine-ram

10

RepositoryStorage

11

VirtualMachine-antiAffinity

12

VirtualMachine-tierhd (datastore tiers)

13

backup_usage/backup_policy

14

vm_usage_on/vm_on - cpu_usage_on/cpu_on

15

vm_usage_off/vm_off - cpu_usage_off/cpu_off

16

memory_usage_on/memory_on

17

memory_usage_off/memory_off

18

firewall_usage/firewall

19

loadbalancer_usage/loadbalancer

20

cost_code_usage

24

draas_protection_usage/draas_protection

25