Anonymous_User Absent Member.
Absent Member.
311 views

Understanding Identity Tracking reports

Hello,

I'm new to reporting.

Running the Identity Tracking Password Changes report and I get no
results. The report is empty. I'm trying to find out why.

The RDD: [sentinel.identity.rdd] Identity Currency data sync runs OK and
I have set the start time to 2013 Dec 2 00:00:00

The table it syncs to contains 1483 rows when I look at it using pgAdmin.

First question: What does the summary_time column mean in that table?

When I run the report it reports on the following period:

June 7, 2013 12:00:00 AM to December 3, 2013 11:59:59 PM CET

Where are those dates set? I.e. where can I find them in the report
definition?

How are the FromDate/FromDtQry and ToDate/ToDtQry parameters passed to
the report? Where can I find that information?

The report SQL query from iReport:

*************************************************************
SELECT
MAX("$P!{IdentityCurrencyTable}".summary_time) AS LAST_LOGIN_TIME,
USR_ACCOUNT_RPT_V.USER_NAME AS TARGET_USER_NAME,
USR_ACCOUNT_RPT_V.USER_DOMAIN AS TARGET_USER_DOMAIN,
TARGET_USR_IDENTITY.FULL_NAME AS FULL_NAME,
cast(TARGET_USR_IDENTITY.IDENTITY_GUID AS char(36)) AS TARGET_IDENTITY_GUID
FROM
$P!{IdentityCurrencyTable} AS "$P!{IdentityCurrencyTable}"
INNER JOIN CUST_RPT_V ON
"$P!{IdentityCurrencyTable}".rv39 = CUST_RPT_V.CUSTOMER_NAME
LEFT OUTER JOIN USR_IDENTITY_RPT_V AS TARGET_USR_IDENTITY ON
"$P!{IdentityCurrencyTable}".tuident = TARGET_USR_IDENTITY.IDENTITY_GUID
LEFT OUTER JOIN USR_ACCOUNT_RPT_V ON
CUST_RPT_V.CUST_ID = USR_ACCOUNT_RPT_V.CUST_ID AND
"$P!{IdentityCurrencyTable}".dun = USR_ACCOUNT_RPT_V.USER_NAME AND
"$P!{IdentityCurrencyTable}".rv45 = USR_ACCOUNT_RPT_V.USER_DOMAIN
WHERE
("$P!{IdentityCurrencyTable}".summary_time >= $P{FromDtQry} AND
"$P!{IdentityCurrencyTable}".summary_time <= $P{ToDtQry}) AND
(USR_ACCOUNT_RPT_V.CURRENT_F = TRUE OR USR_ACCOUNT_RPT_V.CURRENT_F =
't') AND
("$P!{IdentityCurrencyTable}".xdasclass = 0 AND
"$P!{IdentityCurrencyTable}".xdasid = 6) AND
TARGET_USR_IDENTITY.DEPARTMENT_NAME like $P{Dept} AND
TARGET_USR_IDENTITY.FULL_NAME IS NOT NULL
GROUP BY
USR_ACCOUNT_RPT_V.USER_NAME,
USR_ACCOUNT_RPT_V.USER_DOMAIN,
TARGET_USR_IDENTITY.IDENTITY_GUID,
TARGET_USR_IDENTITY.FULL_NAME
ORDER By
FULL_NAME,
TARGET_IDENTITY_GUID,
LAST_LOGIN_TIME
***************************************************************
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.