SQL query to get In-Active users in project at ALM

  • Questions
  • SQL query to get In-Active users in project at ALM
Question ID: 106768
0
0

Need a dynamic sql query to retrieve In-Active users from all the project in ALM.

Marked as spam
Posted by (Questions: 23, Answers: 3)
Asked on April 20, 2016 1:02 pm
8 views
Answers (1)
0
Private answer

Below query was ran in Oracle. SO if you are using MySQL you would have to change db parameters to td.

SELECT
user_name,
full_name,
email,
us_is_active
FROM
qcsiteadmin_db.users qu, _db.users pu
WHERE
pu.us_username = qu.user_name
AND
qu.us_is_active = 'Y'

Marked as spam
Posted by (Questions: 30, Answers: 35)
Answered on September 14, 2019 4:06 pm