We have added an extra text field called comments in the Additional ITSM field of our tickets to be used as a quick status update, we then want to use SQL Server Reporting Services to pull this information through and link it to the specific ticket it is associated with.

I have identified that the text I enter in to comments box shows up in the table dynamic_field_value in the value_text column and has an associated field_id of 46

What I cannot work out is how to associate this to the specific ticket the comment was entered in to so I can pull this info forward to SRSS

Any ideas/suggestions

Matt Roche

IT Support Analyst

MIQ Logistics Limited

Unit 1, Alpha Way
Thorpe Industrial Park
Egham, Surrey
TW20 8RZ
United Kingdom

Direct Tel: +44 (0) 1784 480136
Facsimile: +44 (0) 1784 480177

Email: Matthew.Roche@MIQ.COM
Website: www.miq.com

Newsfeed: www.miq-rss.info

Twitter: http://twitter.com/miqlogistics

Directions:www.multimap.com/map/browse.cgi?lat=51.4169&lon=-0.5289&scale=10000&icon=x

Except as otherwise agreed in writing, signed by a director of MIQ Logistics, all storage, picking and packing services are carried out subject to the United Kingdom Warehousing Association’s conditions of contract current at the time of contract (UKWA) and all other services provided by MIQ Logistics are provided subject to the British International Freight Association’s standard trading conditions current at the time of contract (BIFA). Hyperlinks to the current UKWA & BIFA conditions are included at the foot of this email. Your attention is specifically drawn to the limitations of liability in respect of loss or damage contained in those conditions. Consequentially, customers should notify their own insurers to ensure that adequate insurance cover is in place in connection with any services provided by MIQ Logistics.

http://www.bifa.org/_attachments/Resources/1105_S4.pdf

http://www.ukwa.org.uk/_files/6-conditions-of-contract-sample-6.pdf