Skip to Content
avatar image
Former Member

Password Expiration Date

I am trying to find the classes/objects used to retrieve password policy or set a policy for Enterprise Authentication using .NET SDK . Don't seem to find any details about it . my basic requirement is to find users whose password are about to expire in a day or two and update their passwords etc..

Does anyone has any ideas or details about it? if so, do you mind sharing your experiences?

Thanks for all your help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 19, 2015 at 10:34 PM

    You will need to include the field "SI_LAST_PASSWORD_CHANGE_TIME" in your query to get the relevant info for the user.

    To find out what the limit is for the system, use this query:

    select SI_ID, SI_MAX_PASSWORD_AGE from CI_SYSTEMOBJECTS where SI_NAME = 'secEnterprise'

    SI_MAX_PASSWORD_AGE will give you the maximum age in seconds that you can use to add to the SI_LAST_PASSWORD_CHANGE_TIME value to get what you're looking for.

    You'll probably only be able to get the Password Age value by going to the .Properties of the InfoObject returned from the query.

    -Dell


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dell, I think I spoke too soon. I am able to see that property from SDK (I tried from query builder and couldn't ). Thanks for your help. I am marking this as correct answeer.

      Thanks

  • avatar image
    Former Member
    Oct 21, 2015 at 06:35 PM

    Dell, Thank you for your response. I could find SI_MAX_PASSWORD_AGE , but not able to get SI_LAST_PASSWORD_CHANGE_TIME from user info object. I am using BI 4.1 SP6.

    Am I missing something?

    Thanks for your help

    Add comment
    10|10000 characters needed characters exceeded