CMDB Relationships - Revision history

PeterHarding at 06:44, 25 February 2008

2008-02-25T06:44:49Z

← Older revision		Revision as of 16:44, 25 February 2008
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]]

PeterHarding: /* A Configuration Management Schema Items Oriented around Change management */

2008-02-25T06:43:13Z

A Configuration Management Schema Items Oriented around Change management

← Older revision		Revision as of 16:43, 25 February 2008
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==

PeterHarding: /* Some Configuration M
2008-02-25T06:42:39Z

Some Configuration M<anagement Schema Items Oriented around Change management

← Older revision Revision as of 16:42, 25 February 2008
Line 1: Line 1:

=Some Configuration M<anagement 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

==Table: HardwareCI==
==Table: HardwareCI==

PeterHarding: New page: =Some Configuration M HardwareID RFCID ComponentTypeID VendorID DocumentID HardwareLocationID DateIn...

2008-02-25T06:42:06Z

New page: =Some Configuration M<anagement Schema Items Oriented around Change management= ==Table: HardwareCI== <pre> HardwareID RFCID ComponentTypeID VendorID DocumentID HardwareLocationID DateIn...

New page

=Some Configuration M<anagement Schema Items Oriented around Change management=

==Table: HardwareCI==

<pre>
HardwareID
RFCID
ComponentTypeID
VendorID
DocumentID
HardwareLocationID
DateInstalled
Version
ModelNumber
SerialNumber
</pre>

==Table: Location==

<pre>
LocationID
LocationName
LocationIPSubnet
</pre>

==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

[[Category:ITIL]][[Category:CMDB]]

← Older revision		Revision as of 16:42, 25 February 2008
Line 1:		Line 1:
	=~~Some~~ Configuration ~~M<anagement~~ 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

	==Table: HardwareCI==		==Table: HardwareCI==