Invalid Sessions Query of Informatica

Question

I want to do some cleanup in my project folder of Informatica. I need to find the list unused sessions/obsolete sessions in the folder. I am not able to get the correct set of record with the following query:

SELECT DISTINCT * FROM REP_ALL_TASKS A, REP_SESS_CONFIG_PARM B
WHERE A.TASK_ID = B.SESSION_ID AND TASK_TYPE_NAME = 'Session'
AND B.ATTR_ID = '202' and is_valid <> 1
AND A.SUBJECT_AREA like ('folder')
ORDER BY 1, 2

Can anyone help me?

Answer 1

Replace AND A.SUBJECT_AREA like ('folder') with AND A.SUBJECT_AREA IN ('folder') or AND A.SUBJECT_AREA like 'folder'

Answer 2

try this -
SELECT DISTINCT * FROM REP_ALL_TASKS A, REP_SESS_CONFIG_PARM B
WHERE A.TASK_ID = B.SESSION_ID AND TASK_TYPE_NAME = 'Session'
AND B.ATTR_ID = '202' and is_valid <> 1
AND A.SUBJECT_AREA like 'folder'
ORDER BY 1, 2