How to restart(stop and start) ALM server

Sometimes ALM admin users would require restarting ALM server. If you have ALM server installed in Linux server then we have more problems in restarting ALM server.

Following are steps to do that

1. Connect to Putty
2. Login with user who has rights on deployment directory

3. Navigate to directory

Example: cd .../deployment/wrapper/

4. Run following command to stop the ALM application server

./HPLAM stop

5. Run following command to start again

./HPLAM start

Note: It takes 5-10 minutes time to start ALM, so please wait for sometime. you can verify the server status in the log files being generated.

Extracting all user email ids from ALM/QC

There is no easy option available to extract all user email ids from ALM at one go.

Usually to have few users email ids we can login to SiteAdmin from ALM and select user to extract the mail id but this is painful and rigorous activity.

We can overcome this issue if we have SiteAdmin database access. Please follow below steps for the same

Connect to any frontend database
Access to SiteAdmin Schema
Connect to USERS schema and fire following query to extract all user email ids

SELECT EMAIL, USER_NAME
FROM td.USERS U
WHERE EXISTS
(SELECT * FROM td.USERS_PROJECTS P
WHERE U.USER_ID = P.USER_ID)
AND EMAIL IS NOT NULL AND EMAIL <> ''
ORDER BY USER_NAME;

*in the above query "td" refers site admin schema