Bienabee

Applies To:  ALM 11.5, SQL Database Issue:  Find the last logon date of a user.  This will be helpful when trying to archive old, ...

Applies To:  HP Quality Center or ALM upgrade.   Issue:  Anytime a database is copied to another database server, the TD user needs to be m...

Applies To:  SQL Server Issue:  Find the size of all databases on the SQL Database server Resolution:  Execute this query in SQL ma...

Applies To:  HP ALM/QC 11.52, Oracle Database  Issue:  The user wants to report on old users.  Old users who they could potentially delete or ...

Applies To:  HP ALM/QC 11.52, Oracle Database  Issue:  The user wants to report on old projects and archive projects that have not been logged...

If you're migrating MSFT SQL Servers that host your ALM DB be sure to execute the queries below:   EXEC sp_change_users_login 'Report' E...

If you wish to find all of the orphaned run entities for a project then you can run the following query: SELECT rn_test_id FROM <PROJECT>.run ...

If you are in need of determining the version and patch level of a SQL Server DB you can run the following command: SELECT SERVERPROPERTY('produ...

This query will create a table that sums all the statuses of a specific run.  I used this to tally up step statuses and in an effort to record some sort of ...

Applies To:  HP ALM Issue:  The customer would like to see how many projects they have, and the last time the projects were logged into. Th...