Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

User Account List

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

Everyone's tags (1)
2 REPLIES
New Member

User Account List

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

New Member

User Account List

Thanks Tylor I will give this a try.

264
Views
0
Helpful
2
Replies
CreatePlease login to create content