When reporting on the sys_attachment table how can i tell which record it is attached to?

[RichardSaunders]

When reporting on the sys_attachment table how can i tell which record it is attached to?

I have a filter condition: table is cmdb_ci_service

But with the available column fields I can only get 'File Name' this is of any use, none of which tell me which service they are attached to.

Any help on this please?

[RichardSaunders]

Sorry for the late reply, thanks i have got it half working although i think i have the 'where clause' wrong?

[amlanpal]

Hi RichardSaunders,

My bad for reaching you this much late. Please set the where clause as of below screenshot and let me know:

I hope this helps.Please mark correct/helpful based on impact

[RichardSaunders]

I get this?

[amlanpal]

Hi Richard,

Did you try putting the Where clause as I have provided in the screenshot? I guess that the where clause is not set properly. Request you to provide the Full screenshot of the Database view.

[RichardSaunders]

See screenshot