How to find objects that are not locked? (4327507)

Is there a report or other manner to find out all the unlocked objects in Stat production? I don't want to have to check each of my open CSRs, one by one, to determine if I need to lock the objects associated with that environment that was offline but is now back up?

Solution:

Any of the '%' values can be changed to a specific value. It doesn't have a date range prompt in it, but that can be added.
Mainly, it is the same query used to show a developer what their locked objects are, but object_lock_status is set to 0 which is unlocked.
This can be run from the table dump utility and dumped to text, CSV or Excel.

Select

X.OBJECT_DEVELOPER AS OBJECT_DEVELOPER,
X.SD_CD AS SD_CD,
X.CSR_ID AS CSR_ID,
X.PS_DATABASE AS PS_DATABASE,
X.OBJECT_DISPLAY AS OBJECT_DISPLAY,
X.DESCR AS DESCR,
X.OBJECT_LOCK_STATUS AS OBJECT_LOCK_STATUS,
X.OBJECT_LOCK_DATE AS OBJECT_LOCK_DATE,
X.DUE_DT AS DUE_DT,
X.LAST_NAME AS LAST_NAME,
X.FIRST_NAME AS FIRST_NAME
FROM (SELECT A.OBJECT_DEVELOPER,
A.SD_CD,
A.CSR_ID,
A.PS_DATABASE,
B.OBJECT_DISPLAY,
C.DESCR,
A.OBJECT_LOCK_STATUS,
A.OBJECT_LOCK_DATE,
V.DUE_DT ,
F.LAST_NAME ,
F.FIRST_NAME,
V.CSR_STATUS_CD,
V.CLOSED_STATUS_FLAG,
V.STATISTICAL_STATUS_FLAG,
V.OPEN_DT,
V.APPL_CD,
V.QUEUE_ID,
V.CSR_TYPE,
B.OBJECT_TYPE,
B.OBJECT_CLASS,
V.PRIORITY_CD,
V.CHGMGMT_FLAG,
V.WRKFLW_ID

FROM CSR_PS_OBJECTS A,
PSOBJ_DECODE B,
STAT_OBJECT_TYPES C,
STAT_CSR_RPT_VW1 V,
STATUSER F
WHERE
( A.OBJECT_LOCK_STATUS = 0) AND
( V.SD_CD = A.SD_CD ) and
(V.CSR_ID = A.CSR_ID) and
( A.PS_OBJ_ID = B.PS_OBJ_ID ) AND
( B.OBJECT_CLASS = C.OBJECT_CLASS ) AND
( B.OBJECT_TYPE = C.OBJECT_TYPE ) AND
( A.OBJECT_DEVELOPER = F.USERID )

) X

Where
X.SD_CD LIKE '%' AND
X.CSR_STATUS_CD LIKE '%' AND
X.CLOSED_STATUS_FLAG LIKE 'N' AND
X.STATISTICAL_STATUS_FLAG LIKE '%' AND
X.APPL_CD LIKE '%' AND
X.QUEUE_ID LIKE '%' AND
X.CSR_TYPE LIKE '%' AND
X.CSR_ID BETWEEN 1 AND 999999 AND
X.OBJECT_TYPE LIKE '%' AND
X.OBJECT_CLASS LIKE '%' AND
X.OBJECT_DEVELOPER LIKE '%' AND
X.PS_DATABASE LIKE '%' AND
X.PRIORITY_CD LIKE '%' AND
X.CHGMGMT_FLAG LIKE '%' AND
X.WRKFLW_ID BETWEEN 0 AND 9999

Order BY
X.OBJECT_DEVELOPER ASC,
X.SD_CD ASC,
X.PS_DATABASE ASC,
X.CSR_ID ASC,
X.DESCR ASC,
X.OBJECT_DISPLAY ASC,
X.OBJECT_LOCK_STATUS ASC