Hi Tony,

I did follow all the steps defined above.

Here is the query I am using:

select * from OPENQUERY(SERVICENOW,'select [label],element,dependent_value,[hint],language,cast(sequence as int),sys_id,value from sys_choice order by [label] asc')

I am getting correct data for only 'label' column. All other columns show up as NULL, though they have data in them.

Hi Tony,

I created a ACL on column 'element' and I was able to pull data for that column. Will try to create ACLs for other columns as well and see if it works. But not sure why I have to create at column level when I already have one at table level.

Thanks,

Hemant

Thanks Tony. sys_choice.* works well..

Cheers!

Hi Hemant,

Excellent news!

All good now? If not, can you update with further questions.

If yes consider marking the question as answered, and marking replies as helpful as appropriate.

Best Regards

Tony