tag:blogger.com,1999:blog-1769054949521075757.post3109631358671750866..comments2023-03-29T17:23:28.012+03:00Comments on Quality Testing With QTP & Loadrunner: Getting defect time report for status change actionsMehmethttp://www.blogger.com/profile/01533376970886210170noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-1769054949521075757.post-59368081943011170172015-01-21T13:28:25.635+02:002015-01-21T13:28:25.635+02:00Hello Razvan,
If you are running these SQLs from ...Hello Razvan,<br /><br />If you are running these SQLs from an excel report that is in the analysis view you can remove schema name and the dot ("<<>>."). It is going to be executed for the current project that you logged in.<br /><br />If you want to execute this report for another QC project you have to put the schema names. You can check the schema names by following query:<br /><br />select project_name, db_name from <<>>.projects (marked part is being asked during the installation, if you don't know this part your DBA can tell you what is the correct schema name)<br /><br />Probably your DBA has the necessary rights to execute this query.<br />And your DBA has to give select permissions to your user (the db_name for your logged in project) on BUG, AUDIT_LOG and AUDIT_PROPERTIES tables.Mehmethttps://www.blogger.com/profile/01533376970886210170noreply@blogger.comtag:blogger.com,1999:blog-1769054949521075757.post-48498840745196335712015-01-09T14:05:04.670+02:002015-01-09T14:05:04.670+02:00Hi and thank you for the script.
One question:
W...Hi and thank you for the script.<br /><br />One question:<br /><br />Where can i find my project schema as for the moment i removed the "<<>>" from the script and it is displaying all the defects from DB. <br /><br />Thank you,Anonymoushttps://www.blogger.com/profile/12583559056188275566noreply@blogger.comtag:blogger.com,1999:blog-1769054949521075757.post-19972119421294922272014-09-03T19:38:58.766+03:002014-09-03T19:38:58.766+03:00Hello Rajesh,
Connection to Oracle DB is describe...Hello Rajesh,<br /><br />Connection to Oracle DB is described in the following post.<br /><br />http://qualitesting.blogspot.com.tr/2013/01/qtp-integration-with-oracle-db.htmlMehmethttps://www.blogger.com/profile/01533376970886210170noreply@blogger.comtag:blogger.com,1999:blog-1769054949521075757.post-70079106568563312302014-08-21T12:29:18.301+03:002014-08-21T12:29:18.301+03:00How do we establish an SQL connection with QTP? I ...How do we establish an SQL connection with QTP? I mean server,db and connection details?Rajeshhttps://www.blogger.com/profile/10000327340979094632noreply@blogger.com