"Out of office delegation" and "raw data collection" reports

[ArmelLupapi1]

Hi,

Has any of you know of a query that can be used to report on:

1. "Users with Out of Office delegation"?

2. an existing DB view or a report script that can list the below details from the entitlements collection

[MHelmy · Accepted solution]

1. I remember I tried finding any view for this information but couldn't find any. I wrote this SQL query nearly a year ago, I believe it is still valid but please do doublecheck:

SELECT usr.USER_ID,

     usr.AVAILABILITY_STATUS,

     ooo.DATE1   AS OOO_START_DATE,

     ooo.DATE2   AS OOO_END_DATE,

     dlg.USER_ID AS DELEGATE_USER_ID

FROM AVUSER.T_MASTER_ENTERPRISE_USERS usr

JOIN AVUSER.T_AV_USER_STATUS ooo

ON usr.ID=ooo.MEU_ID

JOIN AVUSER.T_MASTER_ENTERPRISE_USERS dlg

ON dlg.ID=ooo.OBJID1;

2. Yes you should be able to use the V_DC_SOURCEDATA_* views for each type of object/relation in the raw data. Usually you would filter by RUN_ID (Run ID) and DC_ID (Collector ID) for faster results.