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'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