Reporting: Missing history resource data

[dbuschke]

Hi,
I want to query the role/resource/entitlement assocations of a specific date from IDM Reporting but I hit a history gap in IDM 4.7.0. Here is what I have done for tests:

1. create role "test_delete_role"
2. create resource "test_delete_res" with entitlement (use a random one, does not matter)
3. associate "test_delete_res" and "test_delete_role"
4. assign "test_delete_role" to an user

At this point wait a few minutes and have a look into IDM Reporting. Everything looks fine here. Now do following:

1. delete role "test_delete_role"
2. delete resource "test_delete_res"

Again wait a few minutes. After DCS updated the IDM Reporting database execute following SQL query:

SELECT
	role.idmrpt_valid_from,
	role.idmrpt_valid_to,
	role.idmrpt_deleted
FROM
	idm_rpt_data.idmrpt_role_v AS role
WHERE
	role.role_name = 'test_delete_role'

 You'll receive two rows. One with valid date from creation until deleting and one from deleting until deleted. Thats fine.

Also execute following SQL query:

SELECT
	res.idmrpt_valid_from,
	res.idmrpt_valid_to,
	res.idmrpt_deleted
FROM
	idm_rpt_data.idmrpt_resource_all_v AS res
WHERE
	res.res_name = 'test_delete_res'

You'll only receive one row with valid dates from after deleting. So I miss the one from creation until deleting. This makes it unpossible to get the history state of a resource.

Is this a bug or I am missing something?

regards
Daniel