User Account List

[Chad Slater]

User Account List

Is there a way to extract all user accounts from Request Center? Ideally into a spreadsheet that includes their names and user id's as well as whether they are active or inactive. We have a "no longer with the company process" and we need to make sure when someone leaves we make their account inactive. If I can pull a list of accounts they can be compared against a monthly list of users that are no longer with the company.

We are using RequestCenter 2007.1.2

[Tylor Hagerman]

We're on 2006.0.6, but as long as the DIR tables haven't changed much, this SQL should extract what you're looking for:

select p.FirstName, p.LastName, n.LoginName, p.IsInactive
            from DirPerson p,
                 DirContactInfo c,
                 DirNetworkInfo n
           where p.Personid = n.PersonId
             and c.Personid = n.PersonId
             and c.ContactTypeId = 1
             order by lastname, firstname

[Chad Slater]

Thanks Tylor I will give this a try.