Accessing Storage DB tables to generate custom reports

2 posts, 0 answers
  1. Pravallika
    Pravallika avatar
    14 posts
    Member since:
    Dec 2014

    Posted 29 Jun 2015 Link to this post

    Hi Team,


    I have been working with the Test Studio Scheduling Service from the past few days and approaching you with a lot of questions.

    The test list results are stored in the storage DB in the metadata format. I would like to know any information on where the actual information related to the test lists - tests, result files, logs etc, of the scheduled test list in order to generate custom reports after each run of the schedule.

    I searched the DB and I'm not able to find the actual data files. (in the dbo.TestListResults, dbo.TestLists, dbo.Results table, Its all encrypted)


    Kindly help me in finding the same.





  2. Konstantin Petkov
    Konstantin Petkov avatar
    1911 posts

    Posted 01 Jul 2015 Link to this post


    Thank you for your question.

    Regrettably the Storage DB has not been designed for custom reports and we don't support that for the time being. However there is a development effort already in progress to rework the database addressing performance issues. That target to get the solution live is R3'15 in October. Building custom reports queries is one of the requirement as well.

    Can you please elaborate more on the exact queries you need? We're thinking to provide samples like this run results for test list A for specified date range. Is there anything else you would need?

    Konstantin Petkov
    The New Release of Telerik Test Studio Is Here! Download, install,
    and send us your feedback!
Back to Top