Hi,
Just a quick query, I've currently been investigating setting up a Scheduling Server and publishing results to it via the ArtOfTest.Runner.exe commandline.
I was wondering with the information that is published to this database, is it intended that these tables could be reported over using SQL Reporting (e.g. SSRS) or are they primarily just for Test Studio's use?
I saw there was a help page around reporting over the load testing database, so that got me thinking that maybe we could report over the execution test results database as well :)
Thanks!
Just a quick query, I've currently been investigating setting up a Scheduling Server and publishing results to it via the ArtOfTest.Runner.exe commandline.
I was wondering with the information that is published to this database, is it intended that these tables could be reported over using SQL Reporting (e.g. SSRS) or are they primarily just for Test Studio's use?
I saw there was a help page around reporting over the load testing database, so that got me thinking that maybe we could report over the execution test results database as well :)
Thanks!
5 Answers, 1 is accepted
0
Hello Scott,
Boyan Boev
the Telerik team
TestStudioReportingDB is a regular database like any other (see the attached screen shot).
You can manage it in any way you want.
Boyan Boev
the Telerik team
Quickly become an expert in Test Studio, check out our new training sessions!
Test Studio Trainings
Test Studio Trainings
0
Scott
Top achievements
Rank 1
Rank 1
answered on 19 Mar 2013, 08:31 PM
Hi Boyan,
In your attached screenshot that looks like the load testing results db? I was meaning the database that gets created when you configure the scheduling server and has the test list run results published to it. (screenshot of tables attached)
Cheers,
Scott
In your attached screenshot that looks like the load testing results db? I was meaning the database that gets created when you configure the scheduling server and has the test list run results published to it. (screenshot of tables attached)
Cheers,
Scott
0
Hi Scott,
Boyan Boev
the Telerik team
It is one and the same database (see the screen shot).
Regards,Boyan Boev
the Telerik team
Quickly become an expert in Test Studio, check out our new training sessions!
Test Studio Trainings
Test Studio Trainings
0
Scott
Top achievements
Rank 1
Rank 1
answered on 20 Mar 2013, 08:24 PM
Ah right, I see, I didn't realise they were all in the same database :) We're not currently using the load testing side so that would be why I didn't see the extra tables
It looks like only the load testing result tables have relationships between them, the tables ending with _d_b (where the test list results seem to be published) don't seem to be linked so it might not be as easy to report over those ones
It looks like only the load testing result tables have relationships between them, the tables ending with _d_b (where the test list results seem to be published) don't seem to be linked so it might not be as easy to report over those ones
0
Hi Scott,
Boyan Boev
the Telerik team
Yes, unfortunately this is done by design.
Note that manually editing the DB is at your own risk.
Boyan Boev
the Telerik team
Quickly become an expert in Test Studio, check out our new training sessions!
Test Studio Trainings
Test Studio Trainings