Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Sunday, 5 February 2017

Query to Check for Multiple/Duplicate Logins

The relevant query is as follows:

1. Get the person_id for the employee
    select person_id     from per_people_f
    where last_name like &LASTNAME

2. Now use the person_id in the following SQL
    select count(*) from wf_users
    where orig_system_id = &PERSON_ID
    and status = 'ACTIVE'
If count is greater than one, you got duplicates

Share this article :

0 comments:

Post a Comment