Which is the master table (parent) in Service Now that shows CI / Asset Status "In Use", "Retired" etc ?

[YASHIK]

Using my PDI, I opened the table name "life_cycle_stage_status" which i thought is an parent table and changed the value from "In Stock" to "In Stock - Virtual" just to casually test whether all the hardware assets with status  "In Stock" has turned to "In Stock - Virtual". But this did not happen to me. So i am keen to know what was i doing wrong?

I was under the impression that tables in Service Now are extended as a Class (object oriented) hence if i modify values in the parent table the changes will flow through to the child table as well.

[Allen Andreas]

Hi,

You'd want to navigate to a sample hardware asset record and then check the dictionary entry for the relevant field to see where it's getting it's choices from. That will tell you whether changing it on that table would have/should have done anything.

For instance on the alm_hardware table, out of box, the "State" field, which has choices like: "In use", "In stock", "In transit", etc. but those choices lives on the sys_choice table and are defined directly on the "State" field for alm_hardware.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[YASHIK]

Hi Allen, Appreciate your effort in sending me a reply but i don't seem to clearly get what you are trying to explain but may require further info as i am relatively new to the admin side of things.

I was under the impression that State of the Asset or CI should be only 1 master or parent table and all i need to know is how to work backwards to find that table to make changes to the values. But it looks so complicated in Service Now. Don't know why ?

[Allen Andreas]

Hi,

Please navigate to your record, as I mentioned above, and right-click on the field label for the field you're inquiring about. Then choose: Configure > Dictionary. From there, you'll see the dictionary settings of that field. You'll see if it's a reference field pointing to another table...or if it's a choice or string field with choices (the choices are in the related list at the bottom of the page). That would be where the selections are coming from.

I've listed a table and other things in my reply above, so please understand that context.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[YASHIK]

Below are the steps i followed.

1. 1st i selected Hardware Assets 

2. From the list view i selected the "State" label to select Configure>Dictionary 

3. I got to the below screen after that but i don't know what to do next. I believe you are referring to the "asset_function" column with Type: Choice as a further piece of work that i need to focus on.