Tables in QC - Test Set - Used to generate Excel Reports

TABLE: CYCLE (Test Sets)

CY_CYCLE_ID The ID of the test set record.
CY_CYCLE The test set name assigned by the creator of the test set.
51 CY_FOLDER_ID The CYCL_FOLD.CF_ITEM_ID of the folder containing the test set.
CY_ASSIGN_RCYC The RELEASE_CYCLES.RCYC_ID of the release cycle with which the test set is associated.


TABLE: CYCL_FOLD (The test set folder tree.)

CF_ITEM_ID The record ID.
CF_ITEM_NAME The folder name.
CF_FATHER_ID The CF_ITEM_ID of the folder containing this item. Root folders have CF_FATHER_ID = 0.
CF_ASSIGN_RCYC The RELEASE_CYCLES.RCYC_ID of the release cycle with which the folder is associated.

TABLE: TESTCYCL (Instances of design tests in test sets.)

TC_TESTCYCL_ID The record ID.
TC_CYCLE_ID The CYCLE.CY_CYCLE_ID of the test set containing this test. (test set ID)
TC_STATUS The status of the last run of the test instance. The values are from the Status custom list.
Typical values are: Not Completed, No Run, Passed, N/A, Failed.
TC_ASSIGN_RCYC The RELEASE_CYCLES.RCYC_ID of the release cycle with which the test instance is associated.

How to become a QC Administrator - QC Administration Terminology

Site Administrator: A User who can access the "Quality center Site administration" Tool.

TD Admin or Project Administrator:A User who can Customize a Specific QC Project .

Quality Center Site Administration: A tool that allows a site Administrator to become a TD Admin,Create and modify Projects,Add Users and Configure QC.Project level Customization is excluded from this tool.

Requirements for Load Testing

Questions that need to be answered for coming up with test scenarios:

1.What would be the max number of users logged in and using the system at one time?
2.Which transactions (features) are most commonly used?
3.What would be the max number of users processing a transaction at one time?
4.How many of each transaction takes place per day?
5.What time of day do certain transactions take place?
6.What are the transactions acceptable response times?
7.What connection speeds would be used by how many users for each transaction?
8.What transactions would be taking place at the same time and how many?

Folder Structure in QTP Package

The high level explanation could be as follows:

1.

2.
a. Action folders : , , ....
b. Files inside the :
1. .cfg file -
This holds the run time information like addins loaded, user information, etc.

2. .prm file -
Hlds the information about the number of iterations and the parameters that are used within the script / action.

3. .usr file -
This will be generated to hold the name of the script, the objectRepository info, etc.

4. .lck file -
This is a lock file.

5. .mtr file -
(No idea)

6. .xls sheet -
The default sheet that holds the parameters used within the script.

7. .prm.bak file -
backup file.

8. .usp file -
Stores some RUnLogic information for the script.

9. thin_usr.dat file -
similar to the thick usr file. The diff is not clear exactly.

10. thick_usr.dat file -
Stores high level info about all the above and below files indicating what set of files was created, etc.

11. .tsp file -
??

3. folder:
This is a default folder that is created to hold the following:

a. folder:
This will hold all the active screen files which are zipped, pertaining to that action.

b. Resource.mtr file -
This file holds info regarding the object rep used, the shared libraries used, and possibly maitains a track of how the script is being accessed through the code. Ie. the call chain.

c. Script.mts -
This is the script file actually.

d. .tsr -
The object rep file if used in per action mode.

e. The result file.

f. The action excel sheets.

The subsequent action folders hold similar set of files.