AnsweredAssumed Answered

Ignore case in Account collector mapping

Question asked by Dj4bIamQPv7HFSpC1lG08vP2ANE8fvnDUNK3hVdVlsQ= on Jun 15, 2016
Latest reply on Jun 15, 2016 by Subash Chandra Behera

Hi,

 

In my account collector, i did not check the "Data is case senesitive" chekbox.

 

But i have some orphans accounts not mapped cause, it has some uppercase letters in its names

 

select count(*) from PV_ORPHANED_ACCOUNT, PV_USERS where lower(PV_ORPHANED_ACCOUNT.NAME)=lower(PV_USERS.ADMIN_USER_NAME) or lower(PV_ORPHANED_ACCOUNT.NAME)=lower(PV_USERS.USER_NAME).

 

that query return 392 orphan account.

Note: in PV_USERS all columns are in lowercase.

 

I want know, how can i ignore case in the account mapping?

 

Regards.

 

 

 

Outcomes