Difference between revisions of "CMDB Relationships"
Jump to navigation
Jump to search
PeterHarding (talk | contribs) |
PeterHarding (talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
=A Configuration Management Schema Items Oriented around Change management= | =A Configuration Management Schema Items Oriented around Change management= | ||
Derived from http://www.performiq.com.au/kb/images/2004818151257_CMDB_Relationship_Diagram.pdf | Derived from [http://www.performiq.com.au/kb/images/2004818151257_CMDB_Relationship_Diagram.pdf CMDB Relationship Diagram (pdf)] | ||
==Table: HardwareCI== | ==Table: HardwareCI== | ||
| Line 28: | Line 28: | ||
==Table: VendorInfo== | ==Table: VendorInfo== | ||
<pre> | |||
VendorID | VendorID | ||
VendorName | VendorName | ||
| Line 36: | Line 37: | ||
MobileNumber | MobileNumber | ||
EmailAddress | EmailAddress | ||
</pre> | |||
==Table: DriverInformation== | ==Table: DriverInformation== | ||
<pre> | |||
DriverID | DriverID | ||
HardwareID | HardwareID | ||
| Line 46: | Line 49: | ||
DriverName | DriverName | ||
DateInstalled | DateInstalled | ||
</pre> | |||
==Table: SoftwareCI== | ==Table: SoftwareCI== | ||
<pre> | |||
SoftwareID | SoftwareID | ||
RFCID | RFCID | ||
| Line 58: | Line 63: | ||
Version | Version | ||
ServicePack | ServicePack | ||
</pre> | |||
==Table: Licence== | ==Table: Licence== | ||
<pre> | |||
LicenceDetailsID | LicenceDetailsID | ||
SoftwareID | SoftwareID | ||
LicenceDesc | LicenceDesc | ||
</pre> | |||
==Table: ServiceInfomation== | ==Table: ServiceInfomation== | ||
<pre> | |||
ServiceID | ServiceID | ||
HardwareID | HardwareID | ||
| Line 73: | Line 82: | ||
ServiceName | ServiceName | ||
ServiceFunction | ServiceFunction | ||
</pre> | |||
==Table: EmployeePosition== | ==Table: EmployeePosition== | ||
<pre> | |||
EmployeePositionID | EmployeePositionID | ||
PositionDescription | PositionDescription | ||
Qualifications | Qualifications | ||
</pre> | |||
==Table: EmployeeInformation== | ==Table: EmployeeInformation== | ||
<pre> | |||
EmployeeID | EmployeeID | ||
EmployeePositionID | EmployeePositionID | ||
| Line 87: | Line 100: | ||
LastName | LastName | ||
Email | Email | ||
</pre> | |||
==Table: DocumentCI== | ==Table: DocumentCI== | ||
<pre> | |||
DocumentID | DocumentID | ||
RFCID | RFCID | ||
DocumentName | DocumentName | ||
DocumentLocation | DocumentLocation | ||
</pre> | |||
==Table: RequestForChange== | ==Table: RequestForChange== | ||
<pre> | |||
RFCID | RFCID | ||
EmployeeID | EmployeeID | ||
| Line 109: | Line 126: | ||
DateAuthorised | DateAuthorised | ||
DateImplementationReviewed | DateImplementationReviewed | ||
</pre> | |||
==Table: ChangePriority== | ==Table: ChangePriority== | ||
<pre> | |||
ChangePriorityID | ChangePriorityID | ||
PriorityDescription | PriorityDescription | ||
AuthorisationRequired | AuthorisationRequired | ||
</pre> | |||
==Table: ChangeCategorisation== | ==Table: ChangeCategorisation== | ||
<pre> | |||
ChangeCategorisationID | ChangeCategorisationID | ||
ChangeCategorisationDesc | ChangeCategorisationDesc | ||
AuthorisationRequired | AuthorisationRequired | ||
</pre> | |||
[[Category:ITIL]][[Category:CMDB]] | [[Category:ITIL]][[Category:CMDB]] | ||
Latest revision as of 17:44, 25 February 2008
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