Database Reference
In-Depth Information
Getting ready
Before we can start extending the data warehouse, we need to have some custom classes,
relationships, and enumerations that we want to transfer to the data warehouse. You can
define new entity types using authoring tools such as the System Center Service Manager
Authoring Tool. Service Manager authoring is out of the scope of this topic. For more in-
formation on how to author for Service Manager, we recommend
System Center 2012 Ser-
vice Manager Cookbook
, which can be found at
http://www.packtpub.com/microsoft-
In this example, we have defined a custom configuration item class for mobile phones. This
class has a
Manufacturer
property, which is an enumeration. Furthermore, the mobile
phone class relates to the user class through the
MobilePhoneOwnedByUser
relation-
ship, as shown in the following code:
<TypeDefinitions>
<EntityTypes>
<ClassTypes>
<ClassType ID="Custom.MobilePhone"
Accessibility="Public" Abstract="false"
Base="System!System.ConfigItem" Hosted="false"
Singleton="false" Extension="false">
<Property ID="MobilePhoneID" Type="string"
AutoIncrement="true" Key="true" CaseSensitive="false"
MaxLength="256" MinLength="0" Required="false" Scale="0"
DefaultValue="MP{0}" />
<Property ID="SerialNumber" Type="string"
AutoIncrement="false" Key="false" CaseSensitive="false"
MaxLength="256" MinLength="0" Required="false" Scale="0" />
<Property ID="Manufacturer" Type="enum"
AutoIncrement="false" Key="false" CaseSensitive="false"
MaxLength="256" MinLength="0" Required="false" Scale="0"
EnumType="MobilePhoneManufacturerEnum" />
</ClassType>
</ClassTypes>
<RelationshipTypes>
<RelationshipType ID="MobilePhoneOwnedByUser"
Accessibility="Public" Abstract="false"
