CMDBuild database schema Class list name

description

is process

is superclass superclass

APN

APN

Network

Application

Application

ServerSW

AssetMgt

Asset management

AssetTmpl

Grid - Asset

Building

Building

BusinessService

Business service

CI

Configuration item

ChangeMgt

Change management

ChangeMgtWOTmpl

CM Workorder template

ClientHW

Client hardware

true

Hardware

ClientPeripheral

Client peripheral

true

ClientHW

ClientSW

Client software

true

SWInstance

Cluster

Cluster

Component

Component

Computer

Computer

Database

Database

ServerSW

Desktop

Desktop

Computer

DesktopDevice

Desktop device

PhoneHW

Employee

Employee

ExternalEmployee

External employee

Floor

Floor

GenericClientSW

Client software

GridIPAddresses

Grid - IP address (widget)

Hardware

Hardware

IPAddressMgt

IP Addresses management

IPRange

IP range

ITProc

IT Process

ITProcArea

IT process area

ITProcCategory

IT process category

ITProcClassification

IT process classification

ITProcExtraMgt

IT process extra management

ITProcPriority

IT process priority

ITProcSubcategory

IT process subcategory

ITProcWOTmpl

Grid - WO template

IncidentMgt

Incident management

InfrastructureSW

Infrastructure software

ServerSW

InternalEmployee

Internal employee

Employee

KPI

KPI

true

Activity CI

Service true true

ITProc WorkorderTmpl

ServerSW true

ClientHW

true Employee

ClientSW

true true

true

true

CI Activity

true

Activity

Activity

WorkorderTmpl true

ITProc

name

description

is process

is superclass superclass

KnowledgeBase

Knowledge base

Link

Link

Mobile

Mobile

Computer

MobileDevice

Mobile device

PhoneHW

Monitor

Monitor

ClientPeripheral

Network

Network

NetworkBox

Network box

ServerHW

NetworkDevice

Network device

ServerHW

NetworkInterface

Network interface

News

News

Notebook

Notebook

OU

Organizational unit

Parameter

Parameter

PhoneHW

Phone hardware

PhysicalServer

Physical server

Server

Printer

Printer

ClientPeripheral

PurchOrderRowTmpl

Grid - Purch. order row

PurchaseOrder

Purchase order

PurchaseOrderRow

Purchase order row

Rack

Rack

ReqFulfil

Request fulfilment

ReqFulfilWOTmpl

RF Workorder template

Role

Groups

Room

Room

SIM

SIM

SLA_ITProc

SLA IT Process

SWCatalogue

Software catalogue

SWInstance

Software instance

SWLicense

Software license

Server

Server

true

ServerHW

ServerHW

Server hardware

true

Hardware

ServerSW

Server software

true

SWInstance

Service

Service

true

CI

ServiceCategory

Service category

ServiceContract

Service contract

ServiceRequest

Service request

Storage

Storage

Supplier

Supplier

SupplierEmployee

Supplier employee

TechnicalService

Technical service

true

Computer

true

Hardware

ServerHW true

ITProc WorkorderTmpl

PhoneHW true

Activity

true

CI CI

ServerHW

Service

name

description

is process

is superclass superclass

TelephoneExchange

Telephone exchange

User

Users

VLAN

VLAN

Network

VPN

VPN

Network

VirtualIP

Virtual IP

VirtualServer

Virtual server

WiringMgt

Wiring management

WorkorderTmpl

Workorder template

_Templates

Templates

PhoneHW

Server true

Activity true

Class detail APN Description

APN

Is process Superclass

Network

Is superclass Attribute list

Domain list

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

false

false

text

false

false

Subnet

inet

false

false

Netmask

inet

false

false

Name

varchar

true

true

100

reference domain

name

class1

class2

cardinality

APNSIM

APN

SIM

1:N

Application Description

Application

Is process Superclass

ServerSW

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

reference domain

false

false

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

true

false

State

lookup

false

false

OrderRow

reference

false

false

OrderRowCI

Product

reference

false

false

SWCatalogueInstance

License

reference

false

false

SWLicenceInstance

100

BuildingCI

CI - State

Page 4 of

85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

Version

varchar

50

InstallationDate

false

false

date

false

false

ExecutionServer

reference

true

false

Type

lookup

false

false

reference domain

ExecServerServerSW Application -

name

class1

class2

cardinality

ApplicationComponent

Application

Component

1:N

AssetMgt Description

Asset management

Is process

true

Superclass

Activity

Is superclass Attribute list

Domain list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

text

Description

varchar

CreationTimestamp

timestamp

Number

varchar

ProcessStatus

reference domain

false

false

false

false

false

false

false

false

false

false

lookup

false

false

ITProc -

Type

lookup

false

false

AssetMgt - Type

ClosureTimestamp

timestamp

false

false

Supplier

reference

false

false

GRHeaderAction

lookup

false

false

AssetMgt -

Message

lookup

false

false

ITProc -

Confirm

bool

false

false

Order

reference

false

false

SendEmail

bool

false

false

OrderRowBrand

lookup

false

false

OrderRowQty

int4

false

false

GRAssetsAction

lookup

false

false

DstWrhouse

reference

false

false

DstWrhouseAssetMgt

OrigWrhouse

reference

false

false

OrigWrhouseAssetMgt

OrigUser

reference

false

false

OrigUserAssetMgt

DstUser

reference

false

false

DstUserAssetMgt

DstStatus

lookup

false

false

OrigRoom

reference

false

false

OrigRoomAssetMgt

DstRoom

reference

false

false

DstRoomAssetMgt

Wrhouse

reference

false

false

WrhouseAssetMgt

OrderRow

reference

false

false

OrderRowAssetMgt

OrderRowCMDBClass

lookup

false

false

OrderRowModel

varchar

false

false

250

10

100

SupplierAssetMgt

PurchaseOrderAssetMgt

CI - Brand

AssetMgt -

AssetMgt -

PurchaseOrder

name

class1

class2

cardinality

AssetMgtCI

AssetMgt

CI

N:N

Page 5 of

85

Domain list

name

class1

class2

cardinality

DstRoomAssetMgt

Room

AssetMgt

1:N

DstUserAssetMgt

Employee

AssetMgt

1:N

DstWrhouseAssetMgt

Room

AssetMgt

1:N

OrderRowAssetMgt

PurchaseOrderRow

AssetMgt

1:N

OrigRoomAssetMgt

Room

AssetMgt

1:N

OrigUserAssetMgt

Employee

AssetMgt

1:N

OrigWrhouseAssetMgt

Room

AssetMgt

1:N

PurchaseOrderAssetMgt

PurchaseOrder

AssetMgt

1:N

SupplierAssetMgt

Supplier

AssetMgt

1:N

WrhouseAssetMgt

Room

AssetMgt

1:N

AssetTmpl Description

Grid - Asset

Is process Superclass

CI

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

true

false

Description

varchar

250

true

false

Building

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

true

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

100

reference domain

BuildingCI

CI - State

Page 6 of

85

Building Description

Building

Is process Superclass Is superclass Attribute list

Domain list

name

type

lengthnotnull unique lookup

reference domain

Code

varchar

100

true

true

Description

varchar

250

true

true

Notes

text

false

false

Address

varchar

200

false

false

Postcode

varchar

50

false

false

City

varchar

100

false

false

Region

lookup

false

false

Region

Country

lookup

false

false

Country

name

class1

class2

cardinality

BuildingCI

Building

CI

1:N

BuildingFloor

Building

Floor

1:N

BuildingRoom

Building

Room

1:N

BusinessService Description

Business service

Is process Superclass

Service

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

reference domain

true

true

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

100

BuildingCI

CI - State

Page 7 of

85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

Name

varchar

100

true

false

ExtendedDescription

varchar

250

false

false

OrderRow

reference

false

false

OrderRowCI

Category

reference

true

false

CategoryService

Recipients

varchar

false

false

Conditions

text

false

false

ServiceAvailability

text

false

false

HowToRequest

text

false

false

SupportMethods

text

false

false

ActivationDate

date

false

false

Impact

lookup

true

false

DeactivationDate

date

false

false

TechContactPerson

reference

false

false

ServiceState

lookup

true

false

AdditionalSLA

text

false

false

BusinessContactPerson

reference

false

false

ShowInCatalogue

bool

false

false

GrantForAll

bool

false

false

Icon

varchar

false

false

250

100

reference domain

BusinessService

TechContactService Service - State

BusinessContactService

name

class1

class2

cardinality

BusinessContactService

Employee

BusinessService

1:N

CI Description

Configuration item

Is process Superclass Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

15/06/11 21:42

reference domain

false

false

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

BuildingCI

CI - Availability

Page 8 of

85

Attribute list

Domain list

name

type

Brand

lookup

Model

varchar

State OrderRow

lengthnotnull unique lookup false

false

false

false

lookup

false

false

reference

false

false

100

reference domain

CI - Brand

CI - State OrderRowCI

name

class1

class2

cardinality

AssetMgtCI

AssetMgt

CI

N:N

AssigneeCI

Employee

CI

1:N

BuildingCI

Building

CI

1:N

CIDependency

CI

CI

N:N

CIEmployee

CI

Employee

N:N

FloorCI

Floor

CI

1:N

ITProcCI

ITProc

CI

N:N

OrderRowCI

PurchaseOrderRow

CI

1:N

PurchaseOrderCI

PurchaseOrder

CI

1:N

RoomCI

Room

CI

1:N

SupplierCI

Supplier

CI

1:N

ChangeMgt Description

Change management

Is process

true

Superclass

ITProc

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

text

Description

varchar

CreationTimestamp

timestamp

Number

varchar

ProcessStatus

reference domain

false

false

false

false

false

false

false

false

false

false

lookup

false

false

ClosureTimestamp

timestamp

false

false

Message

lookup

false

false

Confirm

bool

false

false

ShortDescr

text

false

false

ExtDescr

text

false

false

Area

lookup

false

false

Requester

reference

false

false

Channel

lookup

false

false

RelatedITProc

reference

false

false

RelatedITProc

Category

reference

false

false

ITProcCategory

Subcategory

reference

false

false

ITProcSubcategory

Urgency

lookup

false

false

ITProc -

Impact

lookup

false

false

ITProc - Impact

Priority

lookup

false

false

ITProc - Priority

250

10

ITProc -

ITProc -

ITProc - Area RequesterITProc ITProc -

Page 9 of

85

Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

reference domain

Outcome

lookup

false

false

Answer

text

false

false

ExpectedClosureDate

date

false

false

ParentProcess

reference

false

false

Register

text

false

false

KB

reference

false

false

ITProcKB

LastHelpdesk

reference

false

false

LastHelpdeskITProc

OpeningChannel

lookup

false

false

CurrentUser

reference

false

false

SPClassificNotes

text

false

false

CurrentRole

reference

false

false

SPClassificAction

lookup

false

false

AllowDelay

bool

false

false

SPNextRole

reference

false

false

SPNextRoleCM

SPSuggOperator

reference

false

false

SPSuggOperatorCM

StartApprNotes

text

false

false

StartApprAction

lookup

false

false

PrevSPAnalysisTime

numeric

false

false

SPAnalysisTime

numeric

false

false

SPAnalysisNotes

text

false

false

AnalysisApprNotes

text

false

false

AnalysisApprAction

lookup

false

false

ChangeMgt -

Message1

lookup

false

false

ITProc -

Message2

lookup

false

false

ITProc -

Message3

lookup

false

false

ITProc -

Message4

lookup

false

false

ITProc -

Message5

lookup

false

false

ITProc -

ActivityName1

varchar

100

false

false

ActivityName2

varchar

100

false

false

ActivityName3

varchar

100

false

false

ActivityName4

varchar

100

false

false

ActivityName5

varchar

100

false

false

ActivityDescription1

varchar

250

false

false

ActivityDescription2

varchar

250

false

false

ActivityDescription3

varchar

250

false

false

ActivityDescription4

varchar

250

false

false

ActivityDescription5

varchar

250

false

false

PrecActivityName1

varchar

100

false

false

PrecActivityName2

varchar

100

false

false

PrecActivityName3

varchar

100

false

false

PrecActivityName4

varchar

100

false

false

PrecActivityName5

varchar

100

false

false

ExpectedTime1

numeric

false

false

ExpectedTime2

numeric

false

false

ITProc -

GeneratedITProc

ITProc CurrentUserITProc

CurrentRoleITProc ChangeMgt -

ChangeMgt -

Page 10 of 85

Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

reference domain

ExpectedTime3

numeric

false

false

ExpectedTime4

numeric

false

false

ExpectedTime5

numeric

false

false

PrevExecTime1

numeric

false

false

PrevExecTime2

numeric

false

false

PrevExecTime3

numeric

false

false

PrevExecTime4

numeric

false

false

PrevExecTime5

numeric

false

false

ExecTime1

numeric

false

false

ExecTime2

numeric

false

false

ExecTime3

numeric

false

false

ExecTime4

numeric

false

false

ExecTime5

numeric

false

false

ExecNotes1

text

false

false

ExecNotes2

text

false

false

ExecNotes3

text

false

false

ExecNotes4

text

false

false

ExecNotes5

text

false

false

ExecAction1

lookup

false

false

ChangeMgt -

ExecAction2

lookup

false

false

ChangeMgt -

ExecAction3

lookup

false

false

ChangeMgt -

ExecAction4

lookup

false

false

ChangeMgt -

ExecAction5

lookup

false

false

ChangeMgt -

SuspNotes1

text

false

false

SuspNotes2

text

false

false

SuspNotes3

text

false

false

SuspNotes4

text

false

false

SuspNotes5

text

false

false

SuspAction1

lookup

false

false

ChangeMgt -

SuspAction2

lookup

false

false

ChangeMgt -

SuspAction3

lookup

false

false

ChangeMgt -

SuspAction4

lookup

false

false

ChangeMgt -

SuspAction5

lookup

false

false

ChangeMgt -

ClosureApprNotes

text

false

false

ClosureApprAction

lookup

false

false

HDClosureNotes

text

false

false

SPOpeningRole

reference

false

false

SPOpeningRoleCM

SPOpeningOperator

reference

false

false

SPOpeningOperatorCM

LastSpecialist

reference

false

false

LastSpecialistCM

LastApprover

reference

false

false

LastApproverCM

SPAnalysisAction

lookup

false

false

ClosureNotes1

text

false

false

ClosureNotes2

text

false

false

ClosureNotes3

text

false

false

ChangeMgt -

ChangeMgt -

Page 11 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

ClosureNotes4

text

false

false

ClosureNotes5

text

false

false

reference domain

name

class1

class2

cardinality

LastApproverCM

Role

ChangeMgt

1:N

LastSpecialistCM

Role

ChangeMgt

1:N

SPNextRoleCM

Role

ChangeMgt

1:N

SPOpeningOperatorCM

User

ChangeMgt

1:N

SPOpeningRoleCM

Role

ChangeMgt

1:N

SPSuggOperatorCM

User

ChangeMgt

1:N

ChangeMgtWOTmpl Description

CM Workorder template

Is process Superclass

WorkorderTmpl

Is superclass Attribute list

Domain list

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

text

ActivityName

varchar

ActivityDescription

varchar

ExpectedTime

false

false

false

false

100

true

false

250

true

false

numeric

false

false

ExecutorRole

reference

true

false

State

lookup

true

false

TargetClass

varchar

false

false

100

reference domain

ExecutorRoleWOTmpl WorkorderTmpl

name

class1

class2

cardinality

ITProcClassificCMWOTmpl

ITProcClassification

ChangeMgtWOTmpl

N:N

ClientHW Description

Client hardware

Is process Superclass

Hardware

Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

false

false

Building

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

15/06/11 21:42

reference domain

BuildingCI

Page 12 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OrderRow

reference

false

false

OS

lookup

false

false

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

100

50

50

reference domain

OrderRowCI HW - OS

Server -

name

class1

class2

cardinality

ClientHWClientSW

ClientHW

ClientSW

1:N

ClientPeripheral Description

Client peripheral

Is process Superclass

ClientHW

Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

false

false

Building

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

false

false

15/06/11 21:42

50

reference domain

BuildingCI

Page 13 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

PartNumber

varchar

50

Availability

reference domain

false

false

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OrderRow

reference

false

false

OS

lookup

false

false

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

Computer

reference

false

false

100

50

50

OrderRowCI HW - OS

Server -

ComputerPeripheral

name

class1

class2

cardinality

ComputerPeripheral

Computer

ClientPeripheral

1:N

ClientSW Description

Client software

Is process Superclass

SWInstance

Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

15/06/11 21:42

reference domain

false

false

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

100

BuildingCI

CI - State

Page 14 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

OrderRow

reference

false

false

OrderRowCI

Product

reference

false

false

SWCatalogueInstance

License

reference

false

false

SWLicenceInstance

Version

varchar

false

false

InstallationDate

date

false

false

ComputerClient

reference

false

false

50

reference domain

ClientHWClientSW

name

class1

class2

cardinality

ClientHWClientSW

ClientHW

ClientSW

1:N

Cluster Description

Cluster

Is process Superclass Is superclass Attribute list

Domain list

name

type

lengthnotnull unique lookup

Name

varchar

100

true

false

Code

varchar

100

false

false

Notes

text

false

false

reference domain

name

class1

class2

cardinality

ClusterPhysicalServer

Cluster

PhysicalServer

1:N

ExecutionClusterVirtualServer

Cluster

VirtualServer

1:N

ServedClusterVirtualServer

Cluster

VirtualServer

1:N

Component Description

Component

Is process Superclass

ServerSW

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

reference domain

false

false

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

false

false

50

BuildingCI

Page 15 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

PartNumber

varchar

50

Availability

reference domain

false

false

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

true

false

State

lookup

false

false

OrderRow

reference

false

false

OrderRowCI

Product

reference

false

false

SWCatalogueInstance

License

reference

false

false

SWLicenceInstance

Version

varchar

false

false

InstallationDate

date

false

false

Application

reference

false

false

ApplicationComponent

ExecutionServer

reference

true

false

ExecServerServerSW

100

50

CI - State

name

class1

class2

cardinality

ApplicationComponent

Application

Component

1:N

Computer Description

Computer

Is process Superclass

ClientHW

Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

false

false

Building

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OrderRow

reference

false

false

OS

lookup

false

false

15/06/11 21:42

100

reference domain

BuildingCI

OrderRowCI HW - OS

Page 16 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

OSVersion

varchar

50

RAM

false

false

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

50

reference domain

Server -

name

class1

class2

cardinality

ComputerPeripheral

Computer

ClientPeripheral

1:N

Database Description

Database

Is process Superclass

ServerSW

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

reference domain

false

false

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

true

false

State

lookup

false

false

OrderRow

reference

false

false

OrderRowCI

Product

reference

false

false

SWCatalogueInstance

License

reference

false

false

SWLicenceInstance

Version

varchar

false

false

InstallationDate

date

false

false

ExecutionServer

reference

true

false

100

50

BuildingCI

CI - State

ExecServerServerSW

Page 17 of 85

Desktop Description

Desktop

Is process Superclass

Computer

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

true

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

100

50

50

reference domain

Server -

Page 18 of 85

DesktopDevice Description

Desktop device

Is process Superclass

PhoneHW

Is superclass Attribute list

Domain list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

true

false

Hostname

varchar

50

false

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

Type

lookup

false

false

TelephoneExchange

reference

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

100

50

50

reference domain

DesktopDevice PhoneExchangeDeskDevice Server -

name

class1

class2

cardinality

PhoneExchangeDeskDevice

TelephoneExchange

DesktopDevice

1:N

Page 19 of 85

Employee Description

Employee

Is process Superclass Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

LastName

varchar

100

false

false

Notes

text

false

false

FirstName

varchar

100

false

false

Email

varchar

100

false

false

Phone

varchar

50

false

false

State

lookup

false

false

Employee -

Type

lookup

false

false

Employee -

ContractStart

date

false

false

ContractEnd

date

false

false

OU

reference

false

false

Domain list

reference domain

OUEmployee

name

class1

class2

cardinality

AdditionalManagerOU

Employee

OU

N:N

ApproverSuggEmpl

Employee

ReqFulfil

1:N

AssigneeCI

Employee

CI

1:N

BusinessContactService

Employee

BusinessService

1:N

CIEmployee

CI

Employee

N:N

DstUserAssetMgt

Employee

AssetMgt

1:N

EmployeeServiceContract

Employee

ServiceContract

1:N

GrantedEmplService

Employee

Service

N:N

ManagerOU

Employee

OU

1:N

OUEmployee

OU

Employee

1:N

OrigUserAssetMgt

Employee

AssetMgt

1:N

RequesterITProc

Employee

ITProc

1:N

TechContactService

Employee

Service

1:N

ExternalEmployee Description

External employee

Is process Superclass

Employee

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

false

false

text

false

false

Supplier

reference

false

false

LastName

varchar

100

true

false

FirstName

varchar

100

true

false

reference domain

SupplierExternalEmployee

Page 20 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

reference domain

Email

varchar

100

true

false

Phone

varchar

50

false

false

State

lookup

false

false

Employee -

Type

lookup

false

false

Employee -

ContractStart

date

false

false

ContractEnd

date

false

false

OU

reference

false

false

OUEmployee

name

class1

class2

cardinality

SupplierExternalEmployee

Supplier

ExternalEmployee

1:N

Floor Description

Floor

Is process Superclass Is superclass Attribute list

Domain list

name

type

Building

reference

Code

varchar

Notes Level

lengthnotnull unique lookup true

false

false

false

text

false

false

lookup

true

false

100

reference domain BuildingFloor

Floor - Level

name

class1

class2

cardinality

BuildingFloor

Building

Floor

1:N

FloorCI

Floor

CI

1:N

FloorRoom

Floor

Room

1:N

GenericClientSW Description

Client software

Is process Superclass

ClientSW

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

reference domain

false

false

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

BuildingCI

Page 21 of 85

Attribute list

name

type

DisposalDate

date

SerialNumber

varchar

PartNumber

varchar

Availability

lengthnotnull unique lookup

reference domain

false

false

50

false

false

50

false

false

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

true

false

State

lookup

false

false

OrderRow

reference

false

false

OrderRowCI

Product

reference

false

false

SWCatalogueInstance

License

reference

false

false

SWLicenceInstance

Version

varchar

false

false

InstallationDate

date

false

false

ComputerClient

reference

true

false

Environment

lookup

false

false

100

50

CI - State

ClientHWClientSW GenericClientS

GridIPAddresses Description

Grid - IP address (widget)

Is process Superclass Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Description

varchar

250

false

false

Notes

text

false

false

InterfaceName

varchar

true

false

InterfaceType

lookup

false

false

IPAddress

inet

true

false

VirtualIP

bool

false

false

IdInterface

int4

false

false

IdVirtualIP

int4

false

false

150

reference domain

NetworkInterfac

Page 22 of 85

Hardware Description

Hardware

Is process Superclass

CI

Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

false

false

Building

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

OrderRow

reference

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

Domain list

15/06/11 21:42

100

50

50

reference domain

BuildingCI

OrderRowCI

Server -

name

class1

class2

cardinality

DstHWFirstNodeWiringMgt

Hardware

WiringMgt

1:N

DstHWOtherNodesWiringMgt

Hardware

WiringMgt

1:N

DstHWWiringMgt

Hardware

WiringMgt

1:N

HardwareIPAddressMgt

Hardware

IPAddressMgt

1:N

HardwareNetworkInterface

Hardware

NetworkInterface

1:N

HardwareSIM

Hardware

SIM

1:N

OrigHWWiringMgt

Hardware

WiringMgt

1:N

SubstitHWWiringMgt

Hardware

WiringMgt

1:N

Page 23 of 85

IPAddressMgt Description

IP Addresses management

Is process

true

Superclass

Activity

Is superclass Attribute list

Domain list

name

type

Notes

text

Code

varchar

Description

lengthnotnull unique lookup false

false

100

false

false

varchar

250

false

false

Number

varchar

10

false

false

CreationTimestamp

timestamp

false

false

Hardware

reference

false

false

Message

lookup

false

false

ClosureTimestamp

timestamp

false

false

reference domain

HardwareIPAddressMgt ITProc -

name

class1

class2

cardinality

HardwareIPAddressMgt

Hardware

IPAddressMgt

1:N

IPRange Description

IP range

Is process Superclass Is superclass Attribute list

Domain list

name

type

Network

reference

Code

varchar

Notes

lengthnotnull unique lookup true

false

false

false

text

false

false

FirstIP

inet

true

false

LastIP

inet

true

false

100

reference domain NetworkIPRange

name

class1

class2

cardinality

NetworkIPRange

Network

IPRange

1:N

ITProc Description

IT Process

Is process

true

Superclass

Activity

Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

text

Description

varchar

CreationTimestamp

timestamp

Number

varchar

15/06/11 21:42

250

10

false

false

false

false

false

false

false

false

false

false

reference domain

Page 24 of 85

Attribute list

Domain list

15/06/11 21:42

name

type

lengthnotnull unique lookup

reference domain

ProcessStatus

lookup

false

false

ClosureTimestamp

timestamp

false

false

Message

lookup

false

false

Confirm

bool

false

false

ShortDescr

text

false

false

ExtDescr

text

false

false

Area

lookup

false

false

Requester

reference

false

false

Channel

lookup

false

false

RelatedITProc

reference

false

false

RelatedITProc

Category

reference

false

false

ITProcCategory

Subcategory

reference

false

false

ITProcSubcategory

Urgency

lookup

false

false

ITProc -

Impact

lookup

false

false

ITProc - Impact

Priority

lookup

false

false

ITProc - Priority

Outcome

lookup

false

false

ITProc -

Answer

text

false

false

ExpectedClosureDate

date

false

false

ParentProcess

reference

false

false

Register

text

false

false

KB

reference

false

false

ITProcKB

LastHelpdesk

reference

false

false

LastHelpdeskITProc

OpeningChannel

lookup

false

false

CurrentUser

reference

false

false

CurrentUserITProc

CurrentRole

reference

false

false

CurrentRoleITProc

AllowDelay

bool

false

false

ITProc -

ITProc -

ITProc - Area RequesterITProc ITProc -

GeneratedITProc

ITProc -

name

class1

class2

cardinality

CurrentRoleITProc

Role

ITProc

1:N

CurrentUserITProc

User

ITProc

1:N

GeneratedITProc

ITProc

ITProc

1:N

ITProcCI

ITProc

CI

N:N

ITProcCategory

ITProc

ITProcCategory

N:1

ITProcKB

ITProc

KnowledgeBase

N:1

ITProcService

ITProc

Service

N:N

ITProcSubcategory

ITProc

ITProcSubcategory

N:1

ITProc_Extra

ITProc

ITProcExtraMgt

1:N

LastHelpdeskITProc

Role

ITProc

1:N

LinkedITProc

ITProc

ITProc

N:N

RelatedITProc

ITProc

ITProc

1:N

RequesterITProc

Employee

ITProc

1:N

Page 25 of 85

ITProcArea Description

IT process area

Is process Superclass Is superclass Attribute list

Domain list

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

false

false

text

false

false

Area

lookup

true

false

Role

reference

true

false

Active

bool

true

false

reference domain

ITProc - Area RoleITArea

name

class1

class2

cardinality

RoleITArea

Role

ITProcArea

1:N

ITProcCategory Description

IT process category

Is process Superclass Is superclass Attribute list

Domain list

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

text

true

true

false

false

reference domain

name

class1

class2

cardinality

CategoryITClassification

ITProcCategory

ITProcClassification

1:N

ITProcCategory

ITProc

ITProcCategory

N:1

ITProcCategorySubcategory

ITProcCategory

ITProcSubcategory

1:N

ITProcClassification Description

IT process classification

Is process Superclass Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

reference domain

Notes

text

false

false

Workflow

lookup

true

false

Category

reference

true

false

CategoryITClassification

Subcategory

reference

true

false

SubcategoryITClassification

HDRole

reference

false

false

RoleHDITClassification

SPRole

reference

false

false

RoleSPITClassification

ApproverRole

reference

false

false

RoleApproverITClassification

Active

bool

false

false

Threshold1Delay

int4

false

false

ITProcessClassif

Page 26 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

reference domain

Threshold2Delay

int4

false

false

Notify1Delay

lookup

false

false

ITProc - Delay

Notify2Delay

lookup

false

false

ITProc - Delay

name

class1

class2

cardinality

CategoryITClassification

ITProcCategory

ITProcClassification

1:N

ITProcClassificCMWOTmpl

ITProcClassification

ChangeMgtWOTmpl

N:N

RoleApproverITClassification

Role

ITProcClassification

1:N

RoleHDITClassification

Role

ITProcClassification

1:N

RoleSPITClassification

Role

ITProcClassification

1:N

SubcategoryITClassification

ITProcSubcategory

ITProcClassification

1:N

ITProcExtraMgt Description

IT process extra management

Is process

true

Superclass

Activity

Is superclass Attribute list

Domain list

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

text

Description

varchar

CreationTimestamp

reference domain

false

false

false

false

false

false

timestamp

false

false

Process

reference

false

false

ProcessType

lookup

false

false

Manual SLA

Operation

lookup

false

false

Manual SLA

Message

lookup

false

false

ITProc -

250

ITProc_Extra

name

class1

class2

cardinality

ITProc_Extra

ITProc

ITProcExtraMgt

1:N

ITProcPriority Description

IT process priority

Is process Superclass Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

false

false

text

false

false

Urgency

lookup

true

false

ITProc -

Impact

lookup

true

false

ITProc - Impact

Priority

lookup

true

false

ITProc - Priority

reference domain

Page 27 of 85

ITProcSubcategory Description

IT process subcategory

Is process Superclass Is superclass Attribute list

Domain list

name

type

Category

reference

Code

varchar

Notes

text

lengthnotnull unique lookup

100

true

false

true

false

false

false

reference domain ITProcCategorySubcategory

name

class1

class2

cardinality

ITProcCategorySubcategory

ITProcCategory

ITProcSubcategory

1:N

ITProcSubcategory

ITProc

ITProcSubcategory

N:1

SubcategoryITClassification

ITProcSubcategory

ITProcClassification

1:N

ITProcWOTmpl Description

Grid - WO template

Is process Superclass

WorkorderTmpl

Is superclass Attribute list

Domain list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Description

varchar

250

false

false

Notes

text

false

false

ActivityName

varchar

100

false

false

ActivityDescription

varchar

250

false

false

ExpectedTime

numeric

false

false

State

lookup

false

false

ExecutorRole

reference

false

false

ExecutorRoleWOTmpl

PrecWO

reference

false

false

PreviousWOTmpl

TargetClass

varchar

false

false

100

reference domain

WorkorderTmpl

name

class1

class2

cardinality

PreviousWOTmpl

WorkorderTmpl

ITProcWOTmpl

1:N

Page 28 of 85

IncidentMgt Description

Incident management

Is process

true

Superclass

ITProc

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

text

Description

varchar

CreationTimestamp

timestamp

Number

varchar

ProcessStatus

reference domain

false

false

false

false

false

false

false

false

false

false

lookup

false

false

ClosureTimestamp

timestamp

false

false

Message

lookup

false

false

Confirm

bool

false

false

ShortDescr

text

false

false

ExtDescr

text

false

false

Area

lookup

false

false

Requester

reference

false

false

Channel

lookup

false

false

Category

reference

false

false

ITProcCategory

Subcategory

reference

false

false

ITProcSubcategory

Urgency

lookup

false

false

ITProc -

Impact

lookup

false

false

ITProc - Impact

Priority

lookup

false

false

ITProc - Priority

Outcome

lookup

false

false

ITProc -

Answer

text

false

false

ExpectedClosureDate

date

false

false

HDClassificNotes

text

false

false

ParentProcess

reference

false

false

Register

text

false

false

HDClassificAction

lookup

false

false

KB

reference

false

false

ITProcKB

HDNextRole

reference

false

false

HDNextRoleIM

LastHelpdesk

reference

false

false

LastHelpdeskITProc

OpeningChannel

lookup

false

false

CurrentUser

reference

false

false

HDAnalysisNotes

text

false

false

RelatedITProc

reference

false

false

RelatedITProc

CurrentRole

reference

false

false

CurrentRoleITProc

HDAnalysisAction

lookup

false

false

AllowDelay

bool

false

false

CMShortDescr

text

false

false

CMExtDescr

text

false

false

250

10

ITProc -

ITProc -

ITProc - Area RequesterITProc ITProc -

GeneratedITProc

IncidentMgt -

ITProc CurrentUserITProc

IncidentMgt -

Page 29 of 85

Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

HDSuggOperator

reference

false

false

HDStartCMNotes

text

false

false

HDStartCMAction

lookup

false

false

HDExecNotes

text

false

false

HDExecAction

lookup

false

false

IncidentMgt -

HDSuspType

lookup

false

false

IncidentMgt -

HDClosureNotes

text

false

false

HDSuspNotes

text

false

false

HDSuspAction

lookup

false

false

SPClassificNotes

text

false

false

SPClassificAction

lookup

false

false

SPAnalysisNotes

text

false

false

SPAnalysisAction

lookup

false

false

SPStartCMNotes

text

false

false

SPStartCMAction

lookup

false

false

SPExecNotes

text

false

false

SPExecAction

lookup

false

false

IncidentMgt -

SPSuspType

lookup

false

false

IncidentMgt -

SPSuspNotes

text

false

false

SPSuspAction

lookup

false

false

SPClosureNotes

text

false

false

SPClosureAction

lookup

false

false

SPNextRole

reference

false

false

HDAnalysisTime

numeric

false

false

HDExecTime

numeric

false

false

SPAnalysisTime

numeric

false

false

SPExecTime

numeric

false

false

PrevHDAnalysisTime

numeric

false

false

PrevHDExecTime

numeric

false

false

PrevSPAnalysisTime

numeric

false

false

PrevSPExecTime

numeric

false

false

STHDClassification

timestamp

false

false

STSPClassification

timestamp

false

false

CTHDClassification

timestamp

false

false

CTSPClassification

timestamp

false

false

TTHDClassification

int4

false

false

TTSPClassification

int4

false

false

STHDAnalysis

timestamp

false

false

CTHDAnalysis

timestamp

false

false

TTHDAnalysis

int4

false

false

STSPAnalysis

timestamp

false

false

CTSPAnalysis

timestamp

false

false

TTSPAnalysis

int4

false

false

STHDExecution

timestamp

false

false

reference domain HDSuggOperatorIM

IncidentMgt -

IncidentMgt -

IncidentMgt -

IncidentMgt -

IncidentMgt -

IncidentMgt -

IncidentMgt SPNextRoleIM

Page 30 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

CTHDExecution

timestamp

false

false

TTHDExecution

int4

false

false

STSPExecution

timestamp

false

false

CTSPExecution

timestamp

false

false

TTSPExecution

int4

false

false

STHDStartCM

timestamp

false

false

CTHDStartCM

timestamp

false

false

TTHDStartCM

int4

false

false

STSPStartCM

timestamp

false

false

CTSPStartCM

timestamp

false

false

TTSPStartCM

int4

false

false

STHDSuspension

timestamp

false

false

CTHDSuspension

timestamp

false

false

TTHDSuspension

int4

false

false

STSPSuspension

timestamp

false

false

CTSPSuspension

timestamp

false

false

TTSPSuspension

int4

false

false

STHDClosure

timestamp

false

false

CTHDClosure

timestamp

false

false

TTHDClosure

int4

false

false

SPSuggOperator

reference

false

false

STSPClosure

timestamp

false

false

CTSPClosure

timestamp

false

false

TTSPClosure

int4

false

false

HDClosureAction

lookup

false

false

reference domain

SPSuggOperatorIM

IncidentMgt -

name

class1

class2

cardinality

HDNextRoleIM

Role

IncidentMgt

1:N

HDSuggOperatorIM

User

IncidentMgt

1:N

SPNextRoleIM

Role

IncidentMgt

1:N

SPSuggOperatorIM

User

IncidentMgt

1:N

InfrastructureSW Description

Infrastructure software

Is process Superclass

ServerSW

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

reference domain

false

false

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

BuildingCI

Page 31 of 85

Attribute list

name

type

lengthnotnull unique lookup

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

true

false

State

lookup

false

false

OrderRow

reference

false

false

OrderRowCI

Product

reference

false

false

SWCatalogueInstance

License

reference

false

false

SWLicenceInstance

Version

varchar

false

false

InstallationDate

date

false

false

ExecutionServer

reference

true

false

Type

lookup

false

false

100

50

reference domain

CI - State

ExecServerServerSW InfrastructureS

InternalEmployee Description

Internal employee

Is process Superclass

Employee

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

text

Number

varchar

LastName

false

false

false

false

50

false

false

varchar

100

true

false

FirstName

varchar

100

true

false

Email

varchar

100

true

false

Phone

varchar

50

false

false

State

lookup

false

false

Employee -

Type

lookup

false

false

Employee -

ContractStart

date

false

false

ContractEnd

date

false

false

OU

reference

false

false

reference domain

OUEmployee

Page 32 of 85

KPI Description

KPI

Is process Superclass Is superclass Attribute list

Domain list

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Description

varchar

250

true

true

Notes

text

false

false

Type

lookup

true

false

Value

varchar

true

false

StandardContract

reference

false

false

ServiceKPI

CustomContract

reference

false

false

ServiceContractKPI

100

reference domain

KPI - Type

name

class1

class2

cardinality

ServiceContractKPI

ServiceContract

KPI

1:N

ServiceKPI

Service

KPI

1:N

KnowledgeBase Description

Knowledge base

Is process Superclass Is superclass Attribute list

Domain list

name

type

Category

lookup

Code

varchar

Notes

text

Index

varchar

Publish Text

lengthnotnull unique lookup true

false

true

false

false

false

false

false

bool

false

false

text

true

false

100

5

reference domain

KB - Category

name

class1

class2

cardinality

ITProcKB

ITProc

KnowledgeBase

N:1

Link Description

Link

Is process Superclass Is superclass Attribute list

15/06/11 21:42

name

type

Category

lookup

Code

varchar

Description

varchar

Notes

text

lengthnotnull unique lookup false

false

100

false

false

250

false

false

false

false

reference domain

Link - Category

Page 33 of 85

Attribute list

name

type

lengthnotnull unique lookup

URL

varchar

250

Publish

bool

true

false

false

false

reference domain

Mobile Description

Mobile

Is process Superclass

Computer

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

true

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

Type

lookup

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

ScreenSize

lookup

false

false

100

50

50

reference domain

Mobile - Type

Server -

ScreenSize

Page 34 of 85

MobileDevice Description

Mobile device

Is process Superclass

PhoneHW

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

true

false

Hostname

varchar

50

false

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

Type

lookup

false

false

IMEI

varchar

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

100

50

20

50

reference domain

MobileDevice -

Server -

Page 35 of 85

Monitor Description

Monitor

Is process Superclass

ClientPeripheral

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Description

varchar

250

true

true

Hostname

varchar

50

false

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

Computer

reference

false

false

ScreenSize

lookup

false

false

ScreenSize

Type

lookup

false

false

Monitor - Type

100

50

50

reference domain

Server -

ComputerPeripheral

Page 36 of 85

Network Description

Network

Is process Superclass Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

Domain list

false

false

text

false

false

Subnet

inet

false

false

Netmask

inet

false

false

Name

varchar

false

false

100

reference domain

name

class1

class2

cardinality

NetworkIPRange

Network

IPRange

1:N

NetworkNetworkInterface

Network

NetworkInterface

1:N

NetworkVirtualIP

Network

VirtualIP

1:N

NetworkBox Description

Network box

Is process Superclass

ServerHW

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

true

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

100

reference domain

Page 37 of 85

Attribute list

name

type

OS

lookup

OSVersion

varchar

RAM

lengthnotnull unique lookup false

false

false

false

int4

false

false

HDSize

int4

false

false

Rack

reference

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

RackUnit

int4

false

false

RackPosition

lookup

false

false

CPU

varchar

false

false

Consumption

int4

false

false

TotalCPUs

int4

false

false

BTU

float8

false

false

ChassisType

lookup

false

false

TotalPowerSupplies

int4

false

false

NumOfUnits

int4

false

false

Monitored

bool

false

false

50

50

reference domain

HW - OS

RackServerHW

Server -

ServerHW -

ServerHW -

NetworkDevice Description

Network device

Is process Superclass

ServerHW

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

reference domain

Code

varchar

100

false

false

Hostname

varchar

50

true

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Page 38 of 85

Attribute list

name

type

Brand

lookup

Model

varchar

State

lengthnotnull unique lookup false

false

false

false

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

Rack

reference

false

false

RackUnit

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

RackPosition

lookup

false

false

TotalCPUs

int4

false

false

Consumption

int4

false

false

BTU

float8

false

false

ChassisType

lookup

false

false

TotalPowerSupplies

int4

false

false

NumOfUnits

int4

false

false

Type

lookup

false

false

Monitored

bool

false

false

AuthType

lookup

false

false

FWRelease

varchar

50

false

false

name

type

lengthnotnull unique lookup

Code

varchar

100

Hardware

100

50

50

reference domain

CI - Brand

RackServerHW

Server -

ServerHW -

ServerHW -

NetworkDevice

NetworkDevice

NetworkInterface Description

Network interface

Is process Superclass Is superclass Attribute list

15/06/11 21:42

true

false

reference

true

false

Notes

text

false

false

Name

varchar

false

false

Type

lookup

false

false

Network

reference

false

false

IPAddress

inet

false

false

DstPort

reference

false

false

MACAddress

varchar

false

false

Mask

inet

false

false

50

50

reference domain

HardwareNetworkInterface

NetworkInterfac NetworkNetworkInterface

DstPortNetworkInterface

Page 39 of 85

Attribute list

Domain list

name

type

Gateway

inet

DNS

varchar

Speed

float8

lengthnotnull unique lookup

50

false

false

false

false

false

false

reference domain

name

class1

class2

cardinality

DstInterfFirstNodeWiringMgt

NetworkInterface

WiringMgt

1:N

DstInterfOtherNodesWiringMgt

NetworkInterface

WiringMgt

1:N

DstInterfWiringMgt

NetworkInterface

WiringMgt

1:N

DstPortNetworkInterface

NetworkInterface

NetworkInterface

1:N

HardwareNetworkInterface

Hardware

NetworkInterface

1:N

NetworkInterfaceVirtualIP

NetworkInterface

VirtualIP

1:N

NetworkNetworkInterface

Network

NetworkInterface

1:N

OrigInterfOtherNodesWiringMgt

NetworkInterface

WiringMgt

1:N

OrigInterfWiringMgt

NetworkInterface

WiringMgt

1:N

SubstitInterfWiringMgt

NetworkInterface

WiringMgt

1:N

News Description

News

Is process Superclass Is superclass Attribute list

name

type

Date

timestamp

Code

varchar

Notes

lengthnotnull unique lookup true

false

true

false

text

false

false

Text

text

true

false

Publish

bool

false

false

PublishFrom

timestamp

false

false

PublishUntil

timestamp

false

false

100

reference domain

Notebook Description

Notebook

Is process Superclass

Computer

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

reference domain

Code

varchar

100

false

false

Hostname

varchar

50

true

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Page 40 of 85

Attribute list

name

type

lengthnotnull unique lookup

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

ScreenSize

lookup

false

false

100

50

50

reference domain

Server -

ScreenSize

OU Description

Organizational unit

Is process Superclass Is superclass Attribute list

Domain list

15/06/11 21:42

name

type

Parent

reference

Code

varchar

Description

varchar

Notes

lengthnotnull unique lookup false

false

100

false

false

250

true

true

text

false

false

Level

lookup

false

false

Manager

reference

true

false

reference domain OUParentOU

OU - Level ManagerOU

name

class1

class2

cardinality

AdditionalManagerOU

Employee

OU

N:N

ApproverOUServiceReq

OU

ServiceRequest

1:N

Page 41 of 85

Domain list

name

class1

class2

cardinality

GrantedOUService

OU

Service

N:N

ManagerOU

Employee

OU

1:N

OUEmployee

OU

Employee

1:N

OUParentOU

OU

OU

1:N

Parameter Description

Parameter

Is process Superclass Is superclass Attribute list

name

type

Area

lookup

Code

varchar

Description

varchar

Notes Value

lengthnotnull unique lookup false

false

100

true

true

250

false

false

text

false

false

text

true

false

reference domain

Parameter -

PhoneHW Description

Phone hardware

Is process Superclass

Hardware

Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

false

false

Building

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

15/06/11 21:42

100

reference domain

BuildingCI

Page 42 of 85

Attribute list

name

type

lengthnotnull unique lookup

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OrderRow

reference

false

false

OS

lookup

false

false

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

50

50

reference domain

OrderRowCI HW - OS

Server -

PhysicalServer Description

Physical server

Is process Superclass

Server

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

true

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

100

50

reference domain

Page 43 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

RAM

int4

false

false

HDSize

int4

false

false

Rack

reference

false

false

CPUSpeed

int4

false

false

RackUnit

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

RackPosition

lookup

false

false

TotalCPUs

int4

false

false

Consumption

int4

false

false

BTU

float8

false

false

ChassisType

lookup

false

false

TotalPowerSupplies

int4

false

false

NumOfUnits

int4

false

false

Monitored

bool

false

false

ServedCluster

reference

false

false

RAIDType

lookup

false

false

50

reference domain

RackServerHW

Server -

ServerHW -

ServerHW -

ClusterPhysicalServer PhysicalServer -

name

class1

class2

cardinality

ClusterPhysicalServer

Cluster

PhysicalServer

1:N

Printer Description

Printer

Is process Superclass

ClientPeripheral

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

reference domain

Code

varchar

100

false

false

Hostname

varchar

50

false

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Page 44 of 85

Attribute list

name

type

Brand

lookup

Model

varchar

State

lengthnotnull unique lookup false

false

false

false

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

Computer

reference

false

false

Format

lookup

false

false

Printer - Format

Type

lookup

false

false

Printer - Type

100

50

50

reference domain

CI - Brand

Server -

ComputerPeripheral

PurchOrderRowTmpl Description

Grid - Purch. order row

Is process Superclass Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Description

varchar

250

false

false

CMDBClass

lookup

false

false

Notes

text

false

false

Brand

lookup

false

false

Model

varchar

false

false

Quantity

int4

false

false

DeliveredQuantity

int4

false

false

DeliveryQuantity

int4

true

false

EarlyClosure

bool

false

false

100

reference domain

PurchaseOrder

CI - Brand

Page 45 of 85

PurchaseOrder Description

Purchase order

Is process Superclass Is superclass Attribute list

Domain list

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

true

false

text

false

false

Supplier

reference

true

false

Type

lookup

false

false

SigningDate

date

true

false

State

lookup

false

false

reference domain

SupplierPurchaseOrder SupplierContrac

PurchaseOrder

name

class1

class2

cardinality

PurchaseOrderAssetMgt

PurchaseOrder

AssetMgt

1:N

PurchaseOrderCI

PurchaseOrder

CI

1:N

PurchaseOrderOrderRow

PurchaseOrder

PurchaseOrderRow

1:N

SupplierPurchaseOrder

Supplier

PurchaseOrder

1:N

PurchaseOrderRow Description

Purchase order row

Is process Superclass Is superclass Attribute list

Domain list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Order

reference

true

false

Notes

text

false

false

Description

varchar

false

false

CMDBClass

lookup

true

false

PurchaseOrder

Brand

lookup

true

false

CI - Brand

Model

varchar

true

false

Quantity

int4

true

false

DeliveredQuantity

int4

false

false

DeliveryQuantity

int4

false

false

EarlyClosure

bool

false

false

Position

varchar

false

false

250

100

2

reference domain PurchaseOrderOrderRow

name

class1

class2

cardinality

OrderRowAssetMgt

PurchaseOrderRow

AssetMgt

1:N

OrderRowCI

PurchaseOrderRow

CI

1:N

PurchaseOrderOrderRow

PurchaseOrder

PurchaseOrderRow

1:N

Page 46 of 85

Rack Description

Rack

Is process Superclass

ServerHW

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

true

true

Hostname

varchar

50

false

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

Rack

reference

false

false

CPUSpeed

int4

false

false

RackUnit

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

RackPosition

lookup

false

false

TotalCPUs

int4

false

false

Consumption

int4

false

false

BTU

float8

false

false

ChassisType

lookup

false

false

TotalPowerSupplies

int4

false

false

NumOfUnits

int4

false

false

TotalUnits

int4

false

false

100

50

50

reference domain

RackServerHW

Server -

ServerHW -

ServerHW -

Page 47 of 85

Attribute list

Domain list

name

type

Monitored

bool

lengthnotnull unique lookup false

reference domain

false

name

class1

class2

cardinality

RackServerHW

Rack

ServerHW

1:N

ReqFulfil Description

Request fulfilment

Is process

true

Superclass

ITProc

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

text

Description

varchar

CreationTimestamp

timestamp

Number

varchar

ProcessStatus

reference domain

false

false

false

false

false

false

false

false

false

false

lookup

false

false

ClosureTimestamp

timestamp

false

false

Message

lookup

false

false

Confirm

bool

false

false

ShortDescr

text

false

false

ExtDescr

text

false

false

Area

lookup

false

false

Requester

reference

false

false

Channel

lookup

false

false

RelatedITProc

reference

false

false

RelatedITProc

Category

reference

false

false

ITProcCategory

Subcategory

reference

false

false

ITProcSubcategory

Urgency

lookup

false

false

ITProc -

Impact

lookup

false

false

ITProc - Impact

Priority

lookup

false

false

ITProc - Priority

Outcome

lookup

false

false

ITProc -

Answer

text

false

false

ExpectedClosureDate

date

false

false

ParentProcess

reference

false

false

Register

text

false

false

KB

reference

false

false

RequestType

lookup

false

false

LastHelpdesk

reference

false

false

LastHelpdeskITProc

Service

reference

false

false

ServiceReqFulfil

OpeningChannel

lookup

false

false

ServiceReq

reference

false

false

ServiceReqReqFulfil

CurrentUser

reference

false

false

CurrentUserITProc

CurrentRole

reference

false

false

CurrentRoleITProc

250

10

ITProc -

ITProc -

ITProc - Area RequesterITProc ITProc -

GeneratedITProc

ITProcKB ReqFulfil -

ITProc -

Page 48 of 85

Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

HDClassificNotes

text

false

false

AllowDelay

bool

false

false

HDClassificAction

lookup

false

false

HDNextRole

reference

false

false

HDNextRoleRF

HDSuggOperator

reference

false

false

HDSuggOperatorRF

HDStartCMNotes

text

false

false

HDStartIMNotes

text

false

false

HDInfoMgtNotes

text

false

false

HDAnswer

text

false

false

HDAssignNotes

text

false

false

HDAssignAction

lookup

false

false

ApprovalNotes

text

false

false

ActivityName1

varchar

false

false

ApprovalAction

lookup

false

false

ActivityName2

varchar

100

false

false

ActivityName3

varchar

100

false

false

ActivityName4

varchar

100

false

false

ActivityName5

varchar

100

false

false

ActivityDescription1

varchar

250

false

false

ActivityDescription2

varchar

250

false

false

ActivityDescription3

varchar

250

false

false

ActivityDescription4

varchar

250

false

false

ActivityDescription5

varchar

250

false

false

ExpectedTime1

numeric

false

false

ExpectedTime2

numeric

false

false

ExpectedTime3

numeric

false

false

ExpectedTime4

numeric

false

false

ExpectedTime5

numeric

false

false

PrevExecTime1

numeric

false

false

PrevExecTime2

numeric

false

false

PrevExecTime3

numeric

false

false

PrevExecTime4

numeric

false

false

PrevExecTime5

numeric

false

false

ExecTime1

numeric

false

false

ExecTime2

numeric

false

false

ExecTime3

numeric

false

false

ExecTime4

numeric

false

false

ExecTime5

numeric

false

false

ExecNotes1

text

false

false

ExecNotes2

text

false

false

ExecNotes3

text

false

false

ExecNotes4

text

false

false

ExecNotes5

text

false

false

ClosureNotes1

text

false

false

100

reference domain

ReqFulfil -

ReqFulfil -

ReqFulfil -

Page 49 of 85

Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

reference domain

ClosureNotes2

text

false

false

ClosureNotes3

text

false

false

ClosureNotes4

text

false

false

ClosureNotes5

text

false

false

SPClassificNotes

text

false

false

SPNextRole

reference

false

false

SPNextRoleRF

SPSuggOperator

reference

false

false

SPSuggOperatorRF

SPInfoMgtNotes

text

false

false

SPAnswer

text

false

false

HDInfoMgtAction

lookup

false

false

ReqFulfil -

SPInfoMgtAction

lookup

false

false

ReqFulfil -

SPClosureNotes

text

false

false

SPClosureAction

lookup

false

false

HDClosureNotes

text

false

false

STHDClassification

timestamp

false

false

CTHDClassification

timestamp

false

false

TTHDClassification

int4

false

false

STHDStartCM

timestamp

false

false

CTHDStartCM

timestamp

false

false

TTHDStartCM

int4

false

false

STHDStartIM

timestamp

false

false

CTHDStartIM

timestamp

false

false

TTHDStartIM

int4

false

false

STHDInfoMgt

timestamp

false

false

CTHDInfoMgt

timestamp

false

false

TTHDInfoMgt

int4

false

false

STHDAssign

timestamp

false

false

CTHDAssign

timestamp

false

false

TTHDAssign

int4

false

false

STApproval

timestamp

false

false

CTApproval

timestamp

false

false

TTApproval

int4

false

false

STWorkorders

timestamp

false

false

CTWorkorders

timestamp

false

false

TTWorkorders

int4

false

false

STSPInfoMgt

timestamp

false

false

CTSPInfoMgt

timestamp

false

false

TTSPInfoMgt

int4

false

false

STSPClosure

timestamp

false

false

CTSPClosure

timestamp

false

false

TTSPClosure

int4

false

false

STHDClosure

timestamp

false

false

CTHDClosure

timestamp

false

false

TTHDClosure

int4

false

false

ReqFulfil -

Page 50 of 85

Attribute list

Domain list

15/06/11 21:42

name

type

lengthnotnull unique lookup

reference domain

SPClassificAction

lookup

false

false

STSPClassification

timestamp

false

false

CTSPClassification

timestamp

false

false

TTSPClassification

int4

false

false

HDStartIMAction

lookup

false

false

PrecActivityName1

varchar

100

false

false

PrecActivityName2

varchar

100

false

false

PrecActivityName3

varchar

100

false

false

PrecActivityName4

varchar

100

false

false

PrecActivityName5

varchar

100

false

false

Message1

lookup

false

false

ITProc -

Message2

lookup

false

false

ITProc -

Message3

lookup

false

false

ITProc -

Message4

lookup

false

false

ITProc -

Message5

lookup

false

false

ITProc -

ApproverSuggOp

reference

false

false

ApproverSuggOp

ApproverSuggEmpl

reference

false

false

ApproverSuggEmpl

ExecAction1

lookup

false

false

ReqFulfil -

ExecAction2

lookup

false

false

ReqFulfil -

ExecAction3

lookup

false

false

ReqFulfil -

ExecAction4

lookup

false

false

ReqFulfil -

ExecAction5

lookup

false

false

ReqFulfil -

SuspAction1

lookup

false

false

ReqFulfil -

SuspAction2

lookup

false

false

ReqFulfil -

SuspAction3

lookup

false

false

ReqFulfil -

SuspAction4

lookup

false

false

ReqFulfil -

SuspAction5

lookup

false

false

ReqFulfil -

SuspNotes1

text

false

false

SuspNotes2

text

false

false

SuspNotes3

text

false

false

SuspNotes4

text

false

false

SuspNotes5

text

false

false

SuspTime1

numeric

false

false

SuspTime2

numeric

false

false

SuspTime3

numeric

false

false

SuspTime4

numeric

false

false

SuspTime5

numeric

false

false

ReqFulfil -

ReqFulfil -

name

class1

class2

cardinality

ApproverSuggEmpl

Employee

ReqFulfil

1:N

ApproverSuggOp

User

ReqFulfil

1:N

HDNextRoleRF

Role

ReqFulfil

1:N

HDSuggOperatorRF

User

ReqFulfil

1:N

SPNextRoleRF

Role

ReqFulfil

1:N

SPSuggOperatorRF

User

ReqFulfil

1:N

Page 51 of 85

Domain list

name

class1

class2

cardinality

ServiceReqFulfil

Service

ReqFulfil

1:N

ServiceReqReqFulfil

ServiceRequest

ReqFulfil

1:N

ReqFulfilWOTmpl Description

RF Workorder template

Is process Superclass

WorkorderTmpl

Is superclass Attribute list

Domain list

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

text

ActivityName

varchar

ActivityDescription

varchar

ExpectedTime

false

false

false

false

100

true

false

250

true

false

numeric

false

false

State

lookup

true

false

ExecutorRole

reference

true

false

TargetClass

varchar

false

false

100

reference domain

WorkorderTmpl ExecutorRoleWOTmpl

name

class1

class2

cardinality

ServiceRequestWOTmpl

ServiceRequest

ReqFulfilWOTmpl

N:N

Role Description

Groups

Is process Superclass Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Active

bool

true

false

CloudAdmin

bool

true

false

DisabledCardTabs

_varchar

false

false

DisabledModules

_varchar

false

false

DisabledProcessTabs

_varchar

false

false

FullScreenMode

bool

true

false

HideSidePanel

bool

true

false

ProcessWidgetAlwaysEnab bool

true

false

SimpleHistoryModeForCar bool

true

false

SimpleHistoryModeForPro bool

true

false

Code

varchar

100

false

false

Description

varchar

250

false

false

Notes

text

false

false

Administrator

bool

false

false

startingClass

regclass

false

false

Email

varchar

false

false

320

reference domain

Page 52 of 85

Domain list

name

class1

class2

cardinality

ApproverRoleServiceReq

Role

ServiceRequest

1:N

CurrentRoleITProc

Role

ITProc

1:N

ExecutorRoleWOTmpl

Role

WorkorderTmpl

1:N

HDNextRoleIM

Role

IncidentMgt

1:N

HDNextRoleRF

Role

ReqFulfil

1:N

LastApproverCM

Role

ChangeMgt

1:N

LastHelpdeskITProc

Role

ITProc

1:N

LastSpecialistCM

Role

ChangeMgt

1:N

RoleApproverITClassification

Role

ITProcClassification

1:N

RoleHDITClassification

Role

ITProcClassification

1:N

RoleHDServiceCat

Role

ServiceCategory

1:N

RoleITArea

Role

ITProcArea

1:N

RoleSPITClassification

Role

ITProcClassification

1:N

SPNextRoleCM

Role

ChangeMgt

1:N

SPNextRoleIM

Role

IncidentMgt

1:N

SPNextRoleRF

Role

ReqFulfil

1:N

SPOpeningRoleCM

Role

ChangeMgt

1:N

Room Description

Room

Is process Superclass Is superclass Attribute list

Domain list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Building

reference

true

false

BuildingRoom

Floor

reference

true

false

FloorRoom

Code

varchar

true

false

Notes

text

false

false

Use

lookup

false

false

100

reference domain

Room - Use

name

class1

class2

cardinality

BuildingRoom

Building

Room

1:N

DstRoomAssetMgt

Room

AssetMgt

1:N

DstWrhouseAssetMgt

Room

AssetMgt

1:N

FloorRoom

Floor

Room

1:N

OrigRoomAssetMgt

Room

AssetMgt

1:N

OrigWrhouseAssetMgt

Room

AssetMgt

1:N

RoomCI

Room

CI

1:N

WrhouseAssetMgt

Room

AssetMgt

1:N

Page 53 of 85

SIM Description

SIM

Is process Superclass

PhoneHW

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

true

false

Hostname

varchar

50

false

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

PhoneNumber

varchar

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

Server -

Type

lookup

false

false

SIM - Type

ICCID

varchar

50

false

false

CPU

varchar

50

false

false

PIN

varchar

50

false

false

TotalCPUs

int4

false

false

PUK

varchar

false

false

Operator

lookup

false

false

SIM - Operator

LicenseType

lookup

false

false

SIM -

APN

reference

false

false

APNSIM

Device

reference

false

false

HardwareSIM

100

50

50

50

reference domain

Page 54 of 85

Domain list

name

class1

class2

cardinality

APNSIM

APN

SIM

1:N

HardwareSIM

Hardware

SIM

1:N

SLA_ITProc Description

SLA IT Process

Is process

true

Superclass

Activity

Is superclass Attribute list

name

type

lengthnotnull unique lookup

Notes

text

false

false

CreationTimestamp

timestamp

false

false

Code

varchar

100

false

false

Description

varchar

250

false

false

Workflow

lookup

false

false

reference domain

Manual SLA

SWCatalogue Description

Software catalogue

Is process Superclass Is superclass Attribute list

Domain list

15/06/11 21:42

name

type

Category

lookup

Code

varchar

Notes

lengthnotnull unique lookup false

false

false

false

text

false

false

Brand

lookup

true

false

Model

varchar

100

true

false

Version

varchar

50

true

false

IdentifyingPattern

varchar

150

false

false

100

reference domain

SWCatalogue -

CI - Brand

name

class1

class2

cardinality

SWCatalogueInstance

SWCatalogue

SWInstance

1:N

Page 55 of 85

SWInstance Description

Software instance

Is process Superclass

CI

Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

Domain list

reference domain

false

false

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

OrderRow

reference

false

false

OrderRowCI

Product

reference

false

false

SWCatalogueInstance

License

reference

false

false

SWLicenceInstance

Version

varchar

false

false

InstallationDate

date

false

false

100

50

BuildingCI

CI - State

name

class1

class2

cardinality

SWCatalogueInstance

SWCatalogue

SWInstance

1:N

SWLicenceInstance

SWLicense

SWInstance

1:N

SWLicense Description

Software license

Is process Superclass

CI

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

false

false

reference

false

false

Notes

text

false

false

Floor

reference

false

false

reference domain

BuildingCI

FloorCI

Page 56 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

true

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

Name

varchar

false

false

OrderRow

reference

false

false

Type

lookup

false

false

NumOfInstances

int4

false

false

100

50

reference domain

CI - State

OrderRowCI SWLicense -

name

class1

class2

cardinality

SWLicenceInstance

SWLicense

SWInstance

1:N

Server Description

Server

Is process Superclass

ServerHW

Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

false

false

Building

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

15/06/11 21:42

reference domain

BuildingCI

CI - Availability

Page 57 of 85

Attribute list

Domain list

name

type

Brand

lookup

Model

varchar

State

lengthnotnull unique lookup

reference domain

false

false

false

false

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OrderRow

reference

false

false

OS

lookup

false

false

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

Rack

reference

false

false

CPUType

lookup

false

false

RackUnit

int4

false

false

CPU

varchar

false

false

RackPosition

lookup

false

false

Consumption

int4

false

false

TotalCPUs

int4

false

false

BTU

float8

false

false

ChassisType

lookup

false

false

TotalPowerSupplies

int4

false

false

NumOfUnits

int4

false

false

Monitored

bool

false

false

100

50

50

CI - Brand

OrderRowCI HW - OS

RackServerHW Server -

ServerHW -

ServerHW -

name

class1

class2

cardinality

ExecServerServerSW

Server

ServerSW

1:N

ServerSWServer

Server

ServerSW

N:N

ServerHW Description

Server hardware

Is process Superclass

Hardware

Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

false

false

Building

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

15/06/11 21:42

reference domain

BuildingCI

Page 58 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OrderRow

reference

false

false

OS

lookup

false

false

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

Rack

reference

false

false

CPUType

lookup

false

false

RackUnit

int4

false

false

CPU

varchar

false

false

RackPosition

lookup

false

false

Consumption

int4

false

false

TotalCPUs

int4

false

false

BTU

float8

false

false

ChassisType

lookup

false

false

TotalPowerSupplies

int4

false

false

NumOfUnits

int4

false

false

Monitored

bool

false

false

100

50

50

reference domain

OrderRowCI HW - OS

RackServerHW Server -

ServerHW -

ServerHW -

name

class1

class2

cardinality

RackServerHW

Rack

ServerHW

1:N

ServerSW Description

Server software

Is process Superclass

SWInstance

Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

15/06/11 21:42

reference domain

false

false

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

BuildingCI

Page 59 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

Order

reference

false

false

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

OrderRow

reference

false

false

OrderRowCI

Product

reference

false

false

SWCatalogueInstance

License

reference

false

false

SWLicenceInstance

Version

varchar

false

false

InstallationDate

date

false

false

ExecutionServer

reference

false

false

100

50

reference domain PurchaseOrderCI

CI - State

ExecServerServerSW

name

class1

class2

cardinality

ExecServerServerSW

Server

ServerSW

1:N

ServerSWServer

Server

ServerSW

N:N

Service Description

Service

Is process Superclass

CI

Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

15/06/11 21:42

reference domain

false

false

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

BuildingCI

Page 60 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

Model

varchar

100

State

lookup

Name

varchar

ExtendedDescription

varchar

OrderRow

reference domain

false

false

false

false

100

false

false

250

false

false

reference

false

false

OrderRowCI

Category

reference

false

false

CategoryService

Recipients

varchar

false

false

Conditions

text

false

false

ServiceAvailability

text

false

false

HowToRequest

text

false

false

SupportMethods

text

false

false

ActivationDate

date

false

false

DeactivationDate

date

false

false

TechContactPerson

reference

false

false

ServiceState

lookup

false

false

AdditionalSLA

text

false

false

ShowInCatalogue

bool

false

false

GrantForAll

bool

false

false

Icon

varchar

false

false

250

100

CI - State

TechContactService Service - State

name

class1

class2

cardinality

AdditionalServiceCategory

ServiceCategory

Service

N:N

CategoryService

ServiceCategory

Service

1:N

GrantedEmplService

Employee

Service

N:N

GrantedOUService

OU

Service

N:N

ITProcService

ITProc

Service

N:N

ServiceKPI

Service

KPI

1:N

ServiceReqFulfil

Service

ReqFulfil

1:N

ServiceServiceContract

Service

ServiceContract

1:N

ServiceServiceRequest

Service

ServiceRequest

1:N

TechContactService

Employee

Service

1:N

ServiceCategory Description

Service category

Is process Superclass Is superclass Attribute list

15/06/11 21:42

name

type

Parent

reference

Code

varchar

Description

varchar

Notes

lengthnotnull unique lookup false

false

100

false

false

250

true

true

text

false

false

State

lookup

true

false

Index

varchar

true

false

10

reference domain ParentServiceCategory

ServiceCategory

Page 61 of 85

Attribute list

Domain list

name

type

HDRole

reference

lengthnotnull unique lookup true

reference domain

false

RoleHDServiceCat

name

class1

class2

cardinality

AdditionalServiceCategory

ServiceCategory

Service

N:N

CategoryService

ServiceCategory

Service

1:N

ParentServiceCategory

ServiceCategory

ServiceCategory

1:N

RoleHDServiceCat

Role

ServiceCategory

1:N

ServiceContract Description

Service contract

Is process Superclass Is superclass Attribute list

Domain list

name

type

lengthnotnull unique lookup

Service

reference

true

false

ServiceServiceContract

Employee

reference

true

false

EmployeeServiceContract

Notes

text

false

false

Description

varchar

true

true

ServiceAvailability

text

false

false

SupportMethods

text

false

false

AdditionalSLA

text

false

false

State

lookup

true

false

StartDate

date

false

false

ExpirationDate

date

false

false

RequestChannel

lookup

false

false

250

reference domain

ServiceContract

ITProc -

name

class1

class2

cardinality

EmployeeServiceContract

Employee

ServiceContract

1:N

ServiceContractKPI

ServiceContract

KPI

1:N

ServiceServiceContract

Service

ServiceContract

1:N

ServiceRequest Description

Service request

Is process Superclass Is superclass Attribute list

15/06/11 21:42

name

type

Service

reference

Code

varchar

Name

varchar

Notes

lengthnotnull unique lookup true

false

100

true

true

100

true

false

text

false

false

Type

lookup

false

false

ToApprove

bool

false

false

ApproverOU

reference

false

false

reference domain ServiceServiceRequest

ServiceRequest

ApproverOUServiceReq

Page 62 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

ApproverRole

reference

false

false

DirectClosure

bool

false

false

reference domain ApproverRoleServiceReq

name

class1

class2

cardinality

ApproverOUServiceReq

OU

ServiceRequest

1:N

ApproverRoleServiceReq

Role

ServiceRequest

1:N

ServiceReqReqFulfil

ServiceRequest

ReqFulfil

1:N

ServiceRequestWOTmpl

ServiceRequest

ReqFulfilWOTmpl

N:N

ServiceServiceRequest

Service

ServiceRequest

1:N

Storage Description

Storage

Is process Superclass

ServerHW

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

true

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

Rack

reference

false

false

CPUSpeed

int4

false

false

RackUnit

int4

false

false

100

50

reference domain

RackServerHW

Page 63 of 85

Attribute list

name

type

CPUType

lookup

CPU

varchar

RackPosition

lengthnotnull unique lookup false

false

false

false

lookup

false

false

TotalCPUs

int4

false

false

Consumption

int4

false

false

BTU

float8

false

false

ChassisType

lookup

false

false

TotalPowerSupplies

int4

false

false

NumOfUnits

int4

false

false

Type

lookup

false

false

Monitored

bool

false

false

Size

int4

false

false

50

reference domain

Server -

ServerHW -

ServerHW -

Storage - Type

Supplier Description

Supplier

Is process Superclass Is superclass Attribute list

Domain list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

text

CompanyTitle

varchar

Address

reference domain

true

false

false

false

100

true

false

varchar

200

false

false

Postcode

varchar

50

false

false

City

varchar

100

false

false

Region

lookup

false

false

Region

Country

lookup

false

false

Country

Type

lookup

false

false

Supplier - Type

ActivationChannel

lookup

false

false

Supplier -

Phone

varchar

50

false

false

Fax

varchar

50

false

false

Email

varchar

100

false

false

Website

varchar

50

false

false

name

class1

class2

cardinality

SupplierAssetMgt

Supplier

AssetMgt

1:N

SupplierCI

Supplier

CI

1:N

SupplierExternalEmployee

Supplier

ExternalEmployee

1:N

SupplierPurchaseOrder

Supplier

PurchaseOrder

1:N

SupplierSupplierEmployee

Supplier

SupplierEmployee

1:N

Page 64 of 85

SupplierEmployee Description

Supplier employee

Is process Superclass Is superclass Attribute list

Domain list

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

false

false

text

false

false

Supplier

reference

true

false

LastName

varchar

100

true

false

FirstName

varchar

100

true

false

Phone

varchar

50

false

false

Mobile

varchar

50

false

false

Email

varchar

100

false

false

Type

lookup

false

false

reference domain

SupplierSupplierEmployee

SupplierEmploy

name

class1

class2

cardinality

SupplierSupplierEmployee

Supplier

SupplierEmployee

1:N

TechnicalService Description

Technical service

Is process Superclass

Service

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

Building

reference domain

true

true

reference

false

false

Notes

text

false

false

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

Name

varchar

true

false

100

100

BuildingCI

CI - State

Page 65 of 85

Attribute list

name

type

lengthnotnull unique lookup

ExtendedDescription

varchar

250

OrderRow

reference domain

false

false

reference

false

false

OrderRowCI

Category

reference

true

false

CategoryService

Recipients

varchar

false

false

Conditions

text

false

false

ServiceAvailability

text

false

false

HowToRequest

text

false

false

SupportMethods

text

false

false

ActivationDate

date

false

false

DeactivationDate

date

false

false

TechContactPerson

reference

false

false

ServiceState

lookup

true

false

AdditionalSLA

text

false

false

ShowInCatalogue

bool

false

false

GrantForAll

bool

false

false

Icon

varchar

100

false

false

name

type

lengthnotnull unique lookup

Code

varchar

100

true

false

Hostname

varchar

50

false

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

250

TechContactService Service - State

TelephoneExchange Description

Telephone exchange

Is process Superclass

PhoneHW

Is superclass Attribute list

15/06/11 21:42

reference domain

Page 66 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

Model

varchar

100

State

reference domain

false

false

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

CPUSpeed

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

TotalCPUs

int4

false

false

50

50

Server -

name

class1

class2

cardinality

PhoneExchangeDeskDevice

TelephoneExchange

DesktopDevice

1:N

User Description

Users

Is process Superclass Is superclass Attribute list

Domain list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Description

varchar

250

false

false

Notes

text

false

false

reference domain

name

class1

class2

cardinality

ApproverSuggOp

User

ReqFulfil

1:N

CurrentUserITProc

User

ITProc

1:N

HDSuggOperatorIM

User

IncidentMgt

1:N

HDSuggOperatorRF

User

ReqFulfil

1:N

SPOpeningOperatorCM

User

ChangeMgt

1:N

SPSuggOperatorCM

User

ChangeMgt

1:N

SPSuggOperatorIM

User

IncidentMgt

1:N

SPSuggOperatorRF

User

ReqFulfil

1:N

Page 67 of 85

VLAN Description

VLAN

Is process Superclass

Network

Is superclass Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

false

false

text

false

false

Subnet

inet

false

false

Netmask

inet

false

false

Name

varchar

100

true

true

Number

varchar

50

false

false

name

type

lengthnotnull unique lookup

Code

varchar

100

Notes

reference domain

VPN Description

VPN

Is process Superclass

Network

Is superclass Attribute list

false

false

text

false

false

Subnet

inet

false

false

Netmask

inet

false

false

Name

varchar

100

true

true

name

type

lengthnotnull unique lookup

NetworkInterface

reference

true

false

Notes

text

false

false

Network

reference

false

false

IPAddress

inet

true

false

reference domain

VirtualIP Description

Virtual IP

Is process Superclass Is superclass Attribute list

Domain list

15/06/11 21:42

reference domain NetworkInterfaceVirtualIP

NetworkVirtualIP

name

class1

class2

cardinality

NetworkInterfaceVirtualIP

NetworkInterface

VirtualIP

1:N

NetworkVirtualIP

Network

VirtualIP

1:N

Page 68 of 85

VirtualServer Description

Virtual server

Is process Superclass

Server

Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Hostname

varchar

50

true

false

Notes

text

false

false

Building

reference

false

false

BuildingCI

Floor

reference

false

false

FloorCI

Room

reference

false

false

RoomCI

Assignee

reference

false

false

AssigneeCI

Supplier

reference

false

false

SupplierCI

Order

reference

false

false

PurchaseOrderCI

OrderRow

reference

false

false

OrderRowCI

WarrantyEnd

date

false

false

DeliveryDate

date

false

false

AcceptanceDate

date

false

false

DisposalDate

date

false

false

SerialNumber

varchar

50

false

false

PartNumber

varchar

50

false

false

Availability

lookup

false

false

CI - Availability

Brand

lookup

false

false

CI - Brand

Model

varchar

false

false

State

lookup

false

false

CI - State

Environment

lookup

false

false

HW -

OS

lookup

false

false

HW - OS

OSVersion

varchar

false

false

RAM

int4

false

false

HDSize

int4

false

false

Rack

reference

false

false

CPUSpeed

int4

false

false

RackUnit

int4

false

false

CPUType

lookup

false

false

CPU

varchar

false

false

RackPosition

lookup

false

false

Consumption

int4

false

false

TotalCPUs

int4

false

false

BTU

float8

false

false

ChassisType

lookup

false

false

TotalPowerSupplies

int4

false

false

NumOfUnits

int4

false

false

Monitored

bool

false

false

100

50

50

reference domain

RackServerHW

Server -

ServerHW -

ServerHW -

Page 69 of 85

Attribute list

Domain list

name

type

lengthnotnull unique lookup

ExecutionCluster

reference

false

false

ExecutionClusterVirtualServer

ServedCluster

reference

false

false

ServedClusterVirtualServer

Type

lookup

false

false

Alias

varchar

false

false

VSState

lookup

false

false

100

reference domain

VirtualServer -

VirtualServer -

name

class1

class2

cardinality

ExecutionClusterVirtualServer

Cluster

VirtualServer

1:N

ServedClusterVirtualServer

Cluster

VirtualServer

1:N

WiringMgt Description

Wiring management

Is process

true

Superclass

Activity

Is superclass Attribute list

Domain list

15/06/11 21:42

name

type

Notes

text

Code

varchar

Description

varchar

ProcessStatus

lookup

Number

varchar

CreationTimestamp

lengthnotnull unique lookup

reference domain

false

false

100

false

false

250

false

false

false

false

false

false

timestamp

false

false

OpeningAction

lookup

false

false

OrigHW

reference

false

false

OrigHWWiringMgt

OrigInterf

reference

false

false

OrigInterfWiringMgt

DstHW

reference

false

false

DstHWWiringMgt

CableColour

lookup

false

false

DstInterf

reference

false

false

DstInterfWiringMgt

OrigInterfOtherNodes

reference

false

false

OrigInterfOtherNodesWiringMgt

SubstitHW

reference

false

false

SubstitHWWiringMgt

SubstitInterf

reference

false

false

SubstitInterfWiringMgt

DstInterfFirstNode

reference

false

false

DstInterfFirstNodeWiringMgt

DstInterfOtherNodes

reference

false

false

DstInterfOtherNodesWiringMgt

CreateAction

lookup

false

false

DstHWFirstNode

reference

false

false

ModifyAction

lookup

false

false

WiringMgt -

DeleteFirstNodeAction

lookup

false

false

WiringMgt -

DeleteOtherNodesAction lookup

false

false

WiringMgt -

DstHWOtherNodes

reference

false

false

Message

lookup

false

false

ClosureTimestamp

timestamp

false

false

10

ITProc -

WiringMgt -

NetworkInterfac

WiringMgt DstHWFirstNodeWiringMgt

DstHWOtherNodesWiringMgt ITProc -

name

class1

class2

cardinality

DstHWFirstNodeWiringMgt

Hardware

WiringMgt

1:N

DstHWOtherNodesWiringMgt

Hardware

WiringMgt

1:N

Page 70 of 85

Domain list

name

class1

class2

cardinality

DstHWWiringMgt

Hardware

WiringMgt

1:N

DstInterfFirstNodeWiringMgt

NetworkInterface

WiringMgt

1:N

DstInterfOtherNodesWiringMgt

NetworkInterface

WiringMgt

1:N

DstInterfWiringMgt

NetworkInterface

WiringMgt

1:N

OrigHWWiringMgt

Hardware

WiringMgt

1:N

OrigInterfOtherNodesWiringMgt

NetworkInterface

WiringMgt

1:N

OrigInterfWiringMgt

NetworkInterface

WiringMgt

1:N

SubstitHWWiringMgt

Hardware

WiringMgt

1:N

SubstitInterfWiringMgt

NetworkInterface

WiringMgt

1:N

WorkorderTmpl Description

Workorder template

Is process Superclass Is superclass

true

Attribute list

name

type

lengthnotnull unique lookup

Code

varchar

100

false

false

Description

varchar

250

false

false

Notes

text

false

false

ActivityName

varchar

100

false

false

ActivityDescription

varchar

250

false

false

ExpectedTime

numeric

false

false

State

lookup

false

false

ExecutorRole

reference

false

false

TargetClass

varchar

false

false

Domain list

100

reference domain

WorkorderTmpl ExecutorRoleWOTmpl

name

class1

class2

cardinality

ExecutorRoleWOTmpl

Role

WorkorderTmpl

1:N

PreviousWOTmpl

WorkorderTmpl

ITProcWOTmpl

1:N

_Templates Description

Templates

Is process Superclass Is superclass Attribute list

15/06/11 21:42

name

type

lengthnotnull unique lookup

Name

text

true

false

Template

text

true

false

reference domain

Page 71 of 85

Lookup values AlfrescoCategory Document Image ITPortal-Icon

Application - Type ApplicationServer

Application server

WebServer

Web server

AssetMgt - DstStatus Maintenance

Maintenance

Available

Available

Disused

Disused

AssetMgt - GRAssetsAction

AssetMgt - GRHeaderAction Continue

Continue registering a delivery

Close

Close

AssetMgt - Type GoodReceipt

Good receipt

Acceptance

Acceptance

Assignment

Assignment

Withdrawal

Withdrawal

Replacement

Replacement

TransferBtwUsers

Transfer between users

TransferBtwWarehouses

Transfer between warehouses

MoveUser

Move user

Disposal

Disposal

AssetMgtCI - Direction +

To warehouse

-

From warehouse

=

--

BusinessService - Impact High

High

Medium

Medium

Low

Low

CI - Availability Owned

Owned

Rented

Rented

Leasing

Leasing

CI - Brand Apple

Apple

HP

HP

IBM

IBM

Sony

Sony

SAP

SAP

CMDBuild

CMDBuild

CI - State Available

Available

InUse

In use

Acceptance

Acceptance

Maintenance

Maintenance

Disused

Disused

Disposed

Disposed

CIEmployee - Role

CIReportClass Monitor

Monitor

Printer

Printer

Desktop

Desktop computer

Mobile

Mobile

Notebook

Notebook

DesktopDevice

Phone - Desktop device

MobileDevice

Phone - Mobile device

SIM

Phone SIM

TelephoneExchange

Telephone exchange

NetworkBox

Network box

NetworkDevice

Network device

Rack

Rack

PhysicalServer

Physical server

VirtualServer

Virtual server

Storage

Storage

ChangeMgt - AnalysisAppr Action Approve

Approve

Reject

Reject

ChangeMgt - ClosureAppr Action Approve

Approve closure

Analysis

Return to analysis

ChangeMgt - Exec Action Continue

Continue execution

Closure

Closure

Suspension

Suspension

ChangeMgt - SPAnalysis Action Execution

Execution

Classification

Return to classification

Analysis

Continue analysis

ChangeMgt - SPClassification Action SPAnalysis

Specialist analysis

EscalationSP

Escalation to specialists

Closure

Closure

ChangeMgt - StartAppr Action Approve

Approve

Reject

Reject

ChangeMgt - Susp Action Execution

Execution

Closure

Closure

Country ITA

Italy

US

United States of America

UK

United Kingdom

Dashboards - ProcessStatus Open

Open

Closed

Closed

DesktopDevice - Type Desktop

Desktop

Cordless

Cordless

EmailStatus New

New

Received

Received

Draft

Draft

Outgoing

Outgoing

Sent

Sent

Employee - State Active

Active

NonActive

Non-active

Suspended

Suspended

Employee - Type Manager

Manager

Regular

Regular

Trainee

Trainee

Floor - Level -1

-1

00

00

01

01

02

02

FlowStatus open.running

Running

open.not_running.suspended

Suspended

closed.completed

Completed

closed.terminated

Terminated

closed.aborted

Aborted

GenericClientSW - Environment Production

Production

Test

Test

HW - Environment Production

Production

Development

Development

Test

Test

HW - OS Windows

Windows

Linux

Linux

MacOS

Mac OS

Holidays 0101

New year's day

0501

Labour Day

1225

Christmas

ITPortal - NewsToShow 7 days

Last week

30 days

Last month

ITProc - Area HW

Hardware

SW

Software

NW

Network

ITProc - Channel Mail

Mail

Phone

Phone

Fax

Fax

Portal

Portal

ITProc - Delay notification type Operator

Current operator

Manager

Manager

ITProc - Impact Low

Low

Medium

Medium

High

High

ITProc - Message AM-OrderRowsInstructions AM-DeliveredAssetsInstructions

Click on Edit order rows and set the current delivery quantity or choose Early closure for not registering deliveries for the row Click on Edit delivered assets

AM-ConfirmEarlyClosure

Confirm the early closure

AM-EmptySelection AMEmptySelectionForReplacement WR-OrigInterfaceConnected

You have not selected any hardware. Click Confirm or leave the checkbox unflagged for going back You have not selected any hardware to assign or withdraw. Click Confirm or leave the checkbox unflagged for going back Origin interface already connected

IM-RoleChange

Changing group is allowed only for escalation-type actions

WR-DestInterfaceConnected

Destination interface already connected

RF-WaitPrec

For advancing this workorder you must wait the completion of its preceding activity

IP-NetInterfWrongFlag

Virtual IP flag not allowed for existing network interface

WR-DstInterfaceMissing

Specify a destination interface to continue

IP-VirtualIPWrongFlag

Virtual IP flag mandatory for existing vitual IP

IP-NetInterfDuplicated

More than one network interface with same name

IP-NetInterfUndefined

Virtual IP refers to undefined network interface

CM-WaitPrec

For advancing this workorder you must wait the completion of its preceding activity

RF-WrongOpeningData

For requests with type "Service", fields Service and ServiceRequest are compulsory

RF-NoServiceContract AM-CheckNewAssets

No contracts found for current Service and Requester. Click Confirm or leave the checkbox unflagged for going back Click on New assets for checking/editing the new assets

AM-ErrorCreatingAssets

An error occured while creating the new assets

SLA-Confirmation

Execution ended correctly

RF-WrongAction

Manage service request action not allowed for a request of information

SLA-Error

An error has occurred: please try again. See the logs for more details.

SLA-Mail

Please complete the e-mail template and advance the wofkflow to send the notification

ITProc - Opening channel Mail

Mail

Phone

Phone

Fax

Fax

ITProc - Outcome Resolved

Resolved

Not resolved

Not resolved

Invalid

Invalid

ITProc - Priority Low

3 - Low

Medium

2 - Medium

High

1 - High

ITProc - ProcessStatus Execution

Execution

Closed

Closed

Classification

Classification

Closure

Closure

Suspended

Suspended

StartCM

Start Change

Analysis

Analysis

Assignment

Assignment

Closure

Closure

Approval

Approval

ITProc - Urgency Low

Low

Medium

Medium

High

High

ITProcessClassification - Workflow IM

Incident management

CM

Change management

RF

Request fulfilment

IncidentMgt - HDAnalysis Action Continue

Continue analysis

Execution

Execution

Suspension

Suspension

StartChange

Start change management

Classification

Return to classification

Closure

Closure

IncidentMgt - HDClassification Action HDAnalysis

Helpdesk analysis

EscalationHD

Escalation to helpdesk

EscalationSP

Escalation to specialists

Closure

Closure

StartRF

Close incident, open request

StartCM

Close incident, open change

IncidentMgt - HDClosure Action Closure

Closure

Analysis

Back in analysis

IncidentMgt - HDExecution Action Continue

Continue execution

Suspension

Suspension

Classification

Return to classification

Closure

Closure

IncidentMgt - HDStartCM Action StartCM

Start change management

Cancel

Cancel and return to analysis

IncidentMgt - HDSusp Action Execution

Execution

Closure

Closure

IncidentMgt - SPAnalysis Action Continue

Continue analysis

Execution

Execution

Suspension

Suspension

StartChange

Start change management

Classification

Return to classification

Closure

Closure

IncidentMgt - SPClassification Action SPAnalysis

Specialist analysis

DescalationHD

Descalation to helpdesk

EscalationSP

Escalation to specialists

Closure

Closure

IncidentMgt - SPClosure Action Closure

Closure

HDClosure

Closure through helpdesk

IncidentMgt - SPExecution Action Suspension

Suspension

Classification

Return to classification

Closure

Closure

IncidentMgt - SPStartCM Action StartCM

Start change management

Cancel

Cancel and return to analysis

IncidentMgt - SPSusp Action Execution

Execution

Closure

Closure

IncidentMgt - Suspension type User

Waiting for user feedback

Repair

Waiting for repair

Supplier

Waiting for supplier

InfrastructureSW - Type WebServer

Web server

KB - Category Email

Email

Printer

Printer

KB - ParentCategory Communication

Communication

Hardware

Hardware

KB - State Active

Active

NonActive

Non-active

KPI - Type

Link - Category Utilities

Utilities

General

General

Manual SLA operation Ignore

Ignore delay and avoid notifications

Restore

Restore delay notifications

Force

Force delay notification

Manual SLA workflow IM

Incident Management

Mobile - Type Ultrabook

Ultrabook

Smartphone

Smartphone

Tablet

Tablet

MobileDevice - Type DualBandGSM

Dual band - GSM

DualBandGPRS

Dual band - GPRS

QuadriBandGPRS

Quadri band - GPRS

Monitor - Type LCD

LCD

LED

LED

CRT

CRT

Month 01

January

02

February

03

March

04

April

05

May

06

June

07

July

08

August

09

September

10

October

11

November

12

December

NetworkDevice - AuthType Kerberos

Kerberos

Radius

Radius

Locale

Locale

NetworkDevice - Type Firewall

Firewall

PatchPanel

Patch panel

Router

Router

Switch

Switch

NetworkInterface - CableColour Red

Red

Blue

Blue

Grey

Grey

NetworkInterface - Type ILO

iLO

Physical

Physical

Virtual

Virtual

OU - Level LOW

Low

MEDIUM

Medium

HIGH

High

Parameter - Area ITPortal

IT Portal

AssetLifecycle

Asset lifecycle

General

General

PhysicalServer - RAIDType Raid1

RAID 1

Raid2

RAID 2

Raid3

RAID 3

Raid4

RAID 4

Raid5

RAID 5

Raid6

RAID 6

Printer - Format A4

A4

A3

A3

A0

A0

Printer - Type Laser

Laser

Inkjet

Inkjet

Plotter

Plotter

PurchaseOrder - State Delivered

Delivered

PartiallyDelivered

Partially delivered

NotDelivered

Not delivered

PurchaseOrderRow - CMDBClass Monitor

Monitor

Printer

Printer

Desktop

Desktop

Region

ReqFulfil - Approval Action Approve

Approve

Reject

Reject

ReqFulfil - Exec Action Continue

Continue execution

Closure

Closure

ReqFulfil - HDAssign Action Approval

Approval

SPAcceptance

Specialists acceptance

ReqFulfil - HDClassific Action ManageStdReq

Manage service request

ManageReqInfo

Manage request for information

EscalationHD

Escalation to helpdesk

EscalationSP

Escalation to specialists

Closure

Closure

StartCM

Close request, open change

StartIM

Close request, open incident

ReqFulfil - HDInfoMgt Action Continue

Continue request for information management

Closure

Closure

HDClassific

Return to classification

ReqFulfil - HDStartIM Action StartIM

Start incident management

Cancel

Cancel e return to classification

ReqFulfil - RequestType Service

Service

Information

Information

ReqFulfil - SPClassific Action EscalationSP

Escalation to specialists

ManageReqInfo

Manage request for information

DeEscalationHD

De-escalation to helpdesk

ReqFulfil - SPClosure Action Close

Close

HDClosure

Forward to helpdesk for closure

ReqFulfil - SPInfoMgt Action Continue

Continue request for information management

Closure

Closure

SPClassific

Return to classification

ReqFulfil - WOExec Action Suspension

Suspension

Execution

Continue execution

Closure

Closure

ReqFulfil - WOSusp Action Execution

Execution

Closure

Closure

Room - Use Office

Office

Warehouse

Warehouse

MeetingRoom

Meeting room

Laboratory

Laboratory

SIM - LicenseType

SIM - Operator

SIM - Type

SWCatalogue - Category CAD

CAD

GraphicsEditor

Graphics editor

Utility

Utility

SWLicense - Type Site

Per site

Server

Per server

CPU

Per CPU

ScreenSize 13'

13'

15'

15'

17'

17'

21'

21'

Server - CPUType 32bit

32-bit

64bit

64-bit

ServerHW - ChassisType Tower

Tower

Blade

Blade

AllInOne

All in one

ServerHW - RackPosition Front

Front

Back

Back

Whole

Whole

Service - State Active

Active

NonActive

Non active

ServiceCategory - State Active

Active

NotActive

Not active

ServiceContract - Channel Portal

Portal

ServiceContract - State Active

Active

NotActive

Not active

ServiceRequest - Type Start

Start service

End

End service

Storage - Type ExternalHD

External HD

SSD

SSD

NAS

NAS

Supplier - ActivationChannel

Supplier - Type

SupplierContract - Type Hardware

Hardware

Software

Software

Maintenance

Maintenance

Services

Services

SupplierEmployee - Type

VirtualServer - State On

Powered on

Off

Powered off

Suspended

Suspended

Eliminated

Eliminated

VirtualServer - Type RunningOnVirtualEnv

Running on virtual environment

RunningOnPhysicalHost

Running on physical environment

WiringMgt - Create Action

ConnectAndExit

Connect and exit

ConnectAndContinueFromOrigin

Connect and continue from origin

ConnectAndContinueFromDestin ation Exit

Connect and continue from destination Exit

WiringMgt - DeleteFirstNode Action DisconnectAndExit

Disconnect and exit

DisconnectAndContinueFromOrig in DisconnectAndContinueFromDes tination DisconnectAllInterfaces

Disconnect and continue from origin

DisconnectAllInterfacesConnectS ubstitute Exit

Disconnect all interfaces and connect substitute hardware

Disconnect and continue from destination Disconnect all interfaces

Exit

WiringMgt - DeleteOtherNodes Action DisconnectAndExit

Disconnect and exit

DisconnectAndContinueFromOrig in DisconnectAndContinueFromDes tination Exit

Disconnect and continue from origin Disconnect and continue from destination Exit

WiringMgt - Modify Action ReconnectAndExit

Reconnect and exit

Exit

Exit

WiringMgt - Opening Action Create

Create connections

Delete

Remove connections

Update

Modify connections

Working hours 0

Sunday

1

Monday

2

Tuesday

3

Wednesday

4

Thursday

5

Friday

6

Saturday

WorkorderTmpl - State Active

Active

NotActive

Not active

CMDBuild database schema -

Application. Application ... InfrastructureSW. Infrastructure software ...... Apple. Apple. HP. HP. IBM. IBM. Sony. Sony. SAP. SAP. CMDBuild. CMDBuild. CI - State.

201KB Sizes 29 Downloads 293 Views

Recommend Documents

CMDBuild database schema -
News. News. Notebook. Notebook. Computer. OU. Organizational unit. Parameter. Parameter. PhoneHW ..... Superclass. ITProc. 15/06/11 21:42. Page 9 of 85 ...

CMDBuild and Shark Update - HowTo -
Nov 5, 2014 - Liquid Telecom. Progetto: CMDBuild and Shark Update - HowTo. Autore: Lisa Pedrazzi Tecnoteca srl. SOMMARIO. CMDBuild updating.

CMDBuild and Shark Update - HowTo -
Nov 5, 2014 - 3. save possible loaded gis icons present in: ${tomcat_home_cmdbuild}/webapps/${cmdbuild_instance}/upload/images/gis. 4. delete the ...

Image Schema
through space, our manipulations of objects, and our perceptual interactions” (1987: 29). Image schemas behave as .... insofar as they constitute 'spaces' sectioned into areas without specifying actual magnitude, shape, or material. Lack of ......

XML Schema (Second Edition)
Nov 26, 2007 - Different companies all proposed different variations of ... XML Data (MS, Arbortext, Inso), January 1998 ... Storage of application information ...

LDAP Schema Design
Schema is the term used to describe the shape of the ... the relational model used by most well-known database systems, and this affects the way LDAP .... delegated management: if all the people in the Customer Service Department are .... Used to sto

Printing Stampa schema -
ESPB266:1L19341. IL19341. Titino.cu. Sheet: /. File: SST_V2.sch. Title: Souiliss Thermostat. Size: A4. Date: 2016-11-08. KiCad E.D.A. eeschema 4.0.4-stable.

Schema-Free XQuery
Ancestor Structure (MLCAS) for finding related nodes within an XML document. By automat- ically computing MLCAS and expanding am- biguous tag names, we add new functionality to. XQuery and enable users to take full advantage of XQuery in querying XML

Minimally Cognitive Robotics: Body Schema, Forward ... - eSMCs
strated, the complexity of tasks the agents could master remained lim- ited. ... their compatibility with different cognitive science paradigms will be dis- cussed. ..... of the body can be exploited to extract information about the body itself and.

Schema 7e period 4.pdf
Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. Schema 7e period 4.pdf. Schema 7e period 4.pdf. Open. Extract.

Schema schoolfotograaf 2017.pdf
14.00 uur groep Inger. 14.30 uur groep Lisa. Page 1 of 1. Schema schoolfotograaf 2017.pdf. Schema schoolfotograaf 2017.pdf. Open. Extract. Open with. Sign In.

Clustering Similar Schema Elements Across ...
identify similar schema elements from heterogeneous data sources, based on ... large data sources due to various kinds of semantic heterogeneities among ..... engineering practice, this information is often outdated, incomplete, incorrect, ...

2013-Marking Schema - Aurora Computer Studies
Where student.studentld = studentsport.studentid and. studentSport.capacity = captain. Student. Studentspend. |spens. عوا. (J) erro Hrne Co na osnous nem hal.

XML Schema (Second Edition) - Fas Harvard
Establish a contract with trading partners. ▫ Documentation. ▫ Augmentation of instance with default values. ▫ Storage of application information ...

2013-Marking Schema - Aurora Computer Studies
:D :ද :b :b 3 9 : 36. 37. 38. .... When only the foreign key definition is given: 1 mark only. 2. ... Three tables to represent student, sport and participate: 1 mark. 2.

XML Schema (Second Edition) - Fas Harvard
After the release of XML 1.0, DTDs were soon recognized as insufficient. ▫ Work towards new schema standards began in early 1998. ▫ Different companies all ...

Minimally Cognitive Robotics: Body Schema, Forward ... - eSMCs
to support purposeful and timely action in the real world, the ”cognitive” axis needs to be ... hand, end up on the other end of spectrum: The chess computer, Deep Blue, is definitely capable of offline ...... A, 365:199–220, 2007. 7. R. A. Bro

Schema Powerbuilding 1.pdf
Preacher curl 60 sec 3 12. Russian Twist 60 sec 3 10. Page 2 of 2. Schema Powerbuilding 1.pdf. Schema Powerbuilding 1.pdf. Open. Extract. Open with. Sign In.