Hi,

I've extended my Service Request class containing a new field which is an enumeration.  It works fine excepting in the Datawarehouse.  I'm unable to find a table for the related enumeration similar to ServiceRequestPriorityvw or ServiceRequestStatusvw.  Please let me know how to create the corresponding table in the Datawarehouse.

Thanks

Sue.

ps.  the management pack is sealed.

• Edited by ss94460_scsm_sue Wednesday, January 28, 2015 2:55 AM added a note

Hi Sue,

I believe that list items (enumerations) are an exception, and do not have to be sealed in order to be imported into the data warehouse. As long as the list itself is defined in a sealed MP, the "configuration" (i.e. adding list items) to that list can be in an unsealed MP.

"Note: only sealed management packs will be sync'd from SCSM to the DW.  Exception to this: List items (aka "enumerations") and groups/queues will be sync'd to the DW regardless of whether they are in a sealed or unsealed MP."

Source: http://blogs.technet.com/b/servicemanager/archive/2009/03/28/data-warehouse-anatomy-of-management-pack-synchronization.aspx