Reporting user login and authentication type

[former_member243905]

Dear All,

I would like to trace user logins but also the authentication type, enterprise, ldap..etc.. I found the following query for query builder but the athentication info is missing:

SELECT SI_KIND, SI_NAME, SI_USERFULLNAME, SI_CREATION_TIME, SI_ALIASES,  SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS  WHERE  SI_KIND='User'

Do you know if this info is stored in repository for all login or for the las login or not at all?

Many thanks and best regards

Fab

[Former Member · Accepted solution]

Yes, the information is store in CMS database (InfoStore).

Your query should have the information you are looking for under SI_Aliases.

Here is an example:

If it is using windows AD authentication, it should say secWinAD.

[former_member243905 · Accepted solution]

Hi Bharath,

many thanks for your reply. I analyzed about 400 users and only in 5 cases I found 2 aliases, one of which was secAD. In most of the cases the SI_NAME was secEnterprise but since the user is usually directed to BO with sso it is really strange not to see usually ldap information. What is you thought about this?

Thanks again and regards

Fab

[former_member182521 · Accepted solution]

Please note when a user is created the SI_NAME would be the si_name of the first user alias.

Thanks

Mani

[former_member243905 · Accepted solution]

Many thanks Manikandan,

I found also this query:

select SI_OWNER, SI_DESCRIPTION, SI_NAME, SI_AUTHEN_METHOD, SI_LOGON_ALIAS, SI_CREATION_TIME, SI_UPDATE_TS FROM CI_SYSTEMOBJECTS  WHERE SI_KIND='Connection'

that is supposed to give me the current user connection list, but the data displayed refer in most of the cases to an enterprise connection, that is not coherent with the custom user addressing to BI configured in our system. I expect to see an ldap or server token or win AD authentication mode but I see secEnterprise in 99% of the logins. Do you have an explanation for this or should I trust this info and assume users are logging in through the enterprise mode?

Thanks again

Fab