Change Child Enumeration's Parent Value

David_Sebba

I have two parent enumerations.  I want to move a child enumeration from one to the other.  I do not want to create it new under one, and delete it from the old.  I want to move the actual list item to preserve reporting, etc.

I can't figure out how to do this with Powershell, and I'm a little nervous about poking the DB.

Has anyone done this before?

Brian_Wiest

You have to pull out the management pack, update the XML and re import the management pack.
What enumeration list?

Brian_Wiest

Recommend to use Entity explorer to determine which management pack
https://gallery.technet.microsoft.com/SCSM-Entity-Explorer-68b86bd2
On the left will be a tab for Enumerations
Locate your enumeration and it will report the stored Managment pack
Export the pack
Locate the ID you will also see from the entity explorer
In the xml you should see a line like this
<EnumerationValue ID="Enum.62be27106ea84c528a3d4da8d733a115" Accessibility="Public" Parent="IncidentClassificationEnum.CIOverride" Ordinal="0" />

Since you are just moving the value to a new parent update only the Parent="" value. that will move its location in the tree. 
Make sure not to adjust the Value ID= That is the specific value matched to reporting.
Also be mind full of the Ordinal value. That is the value that specifies the order of the enumerations.

Brian_Wiest

You have to pull out the management pack, update the XML and re import the management pack.
What enumeration list?

David_Sebba

Cool, I'll see if I can figure that out.

Unfortunately, it's the Service Request Area, and when we originally implemented it we didn't delete the old values, so the actual values are mixed between two MPs.

Brian_Wiest

Recommend to use Entity explorer to determine which management pack
https://gallery.technet.microsoft.com/SCSM-Entity-Explorer-68b86bd2
On the left will be a tab for Enumerations
Locate your enumeration and it will report the stored Managment pack
Export the pack
Locate the ID you will also see from the entity explorer
In the xml you should see a line like this
<EnumerationValue ID="Enum.62be27106ea84c528a3d4da8d733a115" Accessibility="Public" Parent="IncidentClassificationEnum.CIOverride" Ordinal="0" />

Since you are just moving the value to a new parent update only the Parent="" value. that will move its location in the tree. 
Make sure not to adjust the Value ID= That is the specific value matched to reporting.
Also be mind full of the Ordinal value. That is the value that specifies the order of the enumerations.

David_Sebba

Hey, thanks so much!

David_Sebba

Hey Brian, just another "Thank you".  This worked like a charm!

Raisul_Islam

Hello, 
How can I add more parent & child item to the enumeration. I have add a lot of value. Going from SCSM Library>list takes a lot of time. 

is there any PowerShell or any other way I can update? 

Thanks in Advance, 
Rai 

Roland_Kind

Hi

maybe the following will help

https://community.cireson.com/discussion/921/import-and-manage-large-lists-in-scsm

Raisul_Islam

thank mate, much appreciated.