Skip to Content

User valid to date in IDM

Hi All,

This might be annoying for many. But i do not find the user valid to date in view idmv_simple_entry or idmv_vallink_basic or idmv_value_basic

Regards

Plaban

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 29 at 02:12 PM

    Hello Plaban,

    if the attribute is empty, it will not show up in the tables. Have you checked with a user that the attribute is filled for? Which attribute do you look for (what's the name)?

    Don't forget to mention the IDM version and database you use.

    .

    Regards,

    Steffi.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 30 at 03:43 AM

    Hi Steffi,

    IDM 7.2, SQL Server 10.50

    The attribute is not empty, as i can see the values in UI. I am looking for the attribute which contains the valid from and valid to values.

    Regards

    Plaban

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 30 at 03:39 AM

    Hello Plaban,

    Could you please recheck your query. Valid To date value get stored under the MX_VALIDTO IDM attribute.

    If your query is correct then take any user (ex - ABC123), update its valid to date from IDM UI and then run the below query for that particular user and search for MX_VALIDTO attribute.

    Select * from idmv_vallink_basic where mskey in (select mcmskey from idmv_entry_simple where mcMskeyvalue = 'ABC123')

    Hope it will help.

    Regrds,

    C Kumar

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Kumar.

      i did get values but from idmv_vallink_simple. i will provide my query, after some time. Thanks a lot, for your efforts. I have provided IDM and DB version, in my previous post

      Regards

      Plaban