We are using Qlikview successfully with ODBC connection to ARS. I will give this one a try. Other record types have been easily retrieved using the ODBC SQL statments. Rick
________________________________ From: Tauf Chowdhury <[email protected]> To: [email protected] Sent: Wednesday, February 6, 2013 5:28 AM Subject: Re: Task DB Name for Reporting Rick, All tasks are stored in TMS:Task. What reporting tool are you using? BMC Analytics has the objects under the class, Change Management Tasks. The join is done using a field called RootRequestInstanceID (I think). You can do the same join by using Instance ID from the parent Change if you are using a different tool. If you are solely reporting on TMS:Task, you can probably do a LIKE search on the Parent request with a prefix of CRQ. Sent from my iPhone On Feb 6, 2013, at 12:55 AM, Rick Sharp <[email protected]> wrote: > Hi All - > > Were looking for the table name(s) that contain CRQ Task assignments. I've > tried sampling the most obvious TMS:Task and other in the TMS: list, to no > avail. > > Have you been successful reporting on CRQ Tasks? > > Thanks. > > > Rick Sharp via BB > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://www.arslist.org/ > "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
