Options
Change Child Enumeration's Parent Value
David_Sebba
Customer IT Monkey ✭
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?
0
Best Answers
-
Options
Brian_Wiest
Customer Super IT Monkey ✭✭✭✭✭
You have to pull out the management pack, update the XML and re import the management pack.
What enumeration list?5 -
OptionsBrian_Wiest
Customer Super IT Monkey ✭✭✭✭✭
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.
7
Answers
What enumeration list?
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.
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.
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
Hi
maybe the following will help
https://community.cireson.com/discussion/921/import-and-manage-large-lists-in-scsm