About idmv_ovalue_basic_all and idmv_linkaudit_basic

[Former Member]

Hello Experts,

we are running IDM 7.2 SP4 patch 1.

We created a custom attribute representing a link between an identity and its position. It has a uniqueID, a reason, a validfrom date and a validto date. And it is a reference attribute to a custom entrytype called position.

We upload all links between users and position with a fromASCII file and we have to create an "History" for every user, meaning that we create links in the past.

We already found out that to be able to do this, we first have to create the link with only a validfrom date and then modify it, adding the validto. When the validto is in the past, the link is immediately deleted. To create those links, i use a uSetValue in a script.

Then, we want to see all past links (and other deleted attributes) in a visual composer report. So we created a procedure to retrieve everything, using the idmv_ovalue_basic_all view in sql.

Our trouble is that some of the links appear in the old_value table and some of them don't. Based on idm documentation, I know that idmv_ovalue_basic_all is supposed to be excluding reference attributes but since some of them end up in it, i would like to understand why some don't. I know that all my links are correctly created, since I can find all of them in the idmv_linkaudit_basic view, but unfortunately, this view doesn't give me as much info as the idmv_ovalue_basic_all.

So, the questions are : does someone know why some links are in my idmv_ovalue_basic_all and some aren't, and then which view would be more appropriate to use for my purpose?

Thanks a lot,

Clotilde

[Former Member]

Hi Clotilde,

You said that in IdM documentation it says that idmv_ovalue_basic_all is supposed to exlude reference attributes.  I checked a few of my systems and this is not the case.  Can you please let me know what document you're looking at.  I'll track down who wrote it and try to find an answer for you.

Thanks,

Chris

[Former Member]

Hi Chris,

to be accurate, I read that the views with a dataset set to value retrieves regular (non-reference) attributes, but for ovalues it just says retrieves historical values from mxi_old_values, and so I figured that it would be the same, with only regular attributes. It is page 15 in the document called Sap Netweaver Identity Management - Migration guide.

Since apparently i was mistaken, and so every historical value is supposed to be in my old values table, do you know why some of my links would disappear? Do you think it may be caused because i use a uSetValue and not an toIdentityStore pass for example?

Thank you,

Clotilde