How to configure a Reference Field that would containt a list of CI classes.

[kydomingo]

Hello and Good Afternoon.

apologies as am a newbiew and am playing around on the PDI ( particular, creating offerings.forms). One of the offering/form, for that matter, would required to have field that contains a lookup to a list of active CI Classes.  Did quite a bit of search, but can't seem to get it to work..  have tried using cmdb_categories as the reference table, although it is returning the "display name" (e.g., cmdb_ci_aix_server) but would be ideal if it contains the actual class name (AIX Server)... not even sure if using the cmdb_categories as the reference table is correct.

Any assistance/directions is greatly appreciated.

Thank you very much in advance.

Best regards,

ken

[Sujatha V M]

@kydomingo As an admin you will be able to retrieve the data and display it on the form. But there is ACL restriction on the CMDB tables. 

On impersonation, if that user doesn't have the respective role to read the data from that table. It will not display any records. 

User without role : 

Admin:

Reference : https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0826533

Above configuration was achieved referring to Tables [sys_db_object] (ACL control is applied) with a simple condition filter, 

 

Note: I request you to kindly refrain from exposing the core tables. Instead you can have a custom drop down choice value listed for selection. 

Please mark this as helpful and accept it as a solution if this resolves your query.

Thanks,

Sujatha V.M.

[kydomingo]

Thank you very much Sujatha.

I ended up using a lookup... but as you have mentioned, have to test it by impersonating other users.  and unfortunately, I do not see the "impersonate" option in the service portal but is available on both the standard UI and Employee Work space..  Would need to open another post to request for assistance.

thank you.

br

ken

[Sujatha V M]

Glad that it had helped you! Sure shall help you out on the delegate in Service Portal. Share/mention my name with @ on that post. 

Please accept it as a solution and mark this post as helpful if this resolves your query.

Thanks,

Sujatha V.M.