CMDB Relationships
Revision as of 17:44, 25 February 2008 by PeterHarding (talk | contribs)
A Configuration Management Schema Items Oriented around Change management
Derived from CMDB Relationship Diagram (pdf)
Table: HardwareCI
HardwareID RFCID ComponentTypeID VendorID DocumentID HardwareLocationID DateInstalled Version ModelNumber SerialNumber
Table: Location
LocationID LocationName LocationIPSubnet
Table: VendorInfo
VendorID VendorName ContactLastName ContactFirstName PhoneNumber FaxNumber MobileNumber EmailAddress
Table: DriverInformation
DriverID HardwareID RFCID VendorID Version DriverName DateInstalled
Table: SoftwareCI
SoftwareID RFCID VendorID DocumentID ApplicationName DateInstalled PhysicalSoftwareLocation Version ServicePack
Table: Licence
LicenceDetailsID SoftwareID LicenceDesc
Table: ServiceInfomation
ServiceID HardwareID SoftwareID EmployeePositionID ServiceName ServiceFunction
Table: EmployeePosition
EmployeePositionID PositionDescription Qualifications
Table: EmployeeInformation
EmployeeID EmployeePositionID FirstName LastName Email
Table: DocumentCI
DocumentID RFCID DocumentName DocumentLocation
Table: RequestForChange
RFCID EmployeeID ChangePriorityID ChangeCategorisationID DateImplemented ChangeOwner ChangeInitiator ReasonforChange ChangeDetails CABRecomendations DateAuthorised DateImplementationReviewed
Table: ChangePriority
ChangePriorityID PriorityDescription AuthorisationRequired
Table: ChangeCategorisation
ChangeCategorisationID ChangeCategorisationDesc AuthorisationRequired