Fields not visible on Export Definition

[ashy]

Hi All,

 I am new to servicenow and i have a requirement to schedule a report in export sets on "cmdb_rel_ci" table. Already there is a report on the same table, where they have selected all the required fields to be listed. The issue i am facing here is that if i try to look for the same field in export set, i am not able to see it in the "Available" slushbucket and the fields that are not visible are for eg.,child.storage type[storage device], child.chassis type [storage device], child.size bytes GB[storage device] etc.. I have used filter condition also.

Could anybody guide me on this? I really want to select those fields in export sets.Thanks in advance!

Best Regards,

Ashwini

[nayanawadhiya1]

Have you tried by clicking + icon?

If yes, then are those fields (storage type,chassis type,size bytes) in CMDB_CI Table?

If those are not in CMDB_CI Table because those fields in CHILD TABLE OF CMDB_CI.

[ashy]

Hello Nayan,

Yes i did the expansion of child field, by clicking on the plus sign. The table i have selected is cmdb_rel_ci, in which if i try to show related fields(in filter condition) upon child field, i am able to see the fields.This happens in Reports as well.

However it is not the case in in Export Definition.

Thanks,

Aswini K

[Ankur Bawiskar]

Hi Ashwini,

Can you check on which table the export definition is created?

You cannot have the fields present on child table in the available bucket if export definition is on Parent table.

For example: you have created a custom field on incident table i.e. Sample Date.

And your export definition is on Task table then the above field won't be shown in the Available since it is not at parent level but created at Child level.

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[ashy]

Hi Ankur,

Thanks for your response.

The situation is that i am able to see the same fields if i go to the table level and do the "show related fields".Also in the Reports, for the same table, i am able to select the fields. However , just in the export definition i am unable to see those fields. 

Thanks,

Ashwini