Difference between revisions of "CMDB Relationships"
PeterHarding (talk | contribs) (New page: =Some Configuration M<anagement Schema Items Oriented around Change management= ==Table: HardwareCI== <pre> HardwareID RFCID ComponentTypeID VendorID DocumentID HardwareLocationID DateIn...) |
(No difference)
|
Revision as of 16:42, 25 February 2008
Some Configuration M<anagement Schema Items Oriented around Change management
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