Retriveing active users at active directory from sharepoint database
I am using sharepoint server 2007,and I want to retrieve users info that are retrieved from active directory so I used this query Select nvarchar1 ,nvarchar12,nvarchar4,nvarchar8,nvarchar9 from dbo.alluserdata where tp_contenttype = 'Person' and bit4=1 order by nvarchar1 but it retrieves all users of sharepoint whether they are active at active directory or not,I want to retrieve only active users at the active directory
May 12th, 2010 2:21pm

Hi, As per my understanding you can do so by querying the table UserInfo. Something like select tp_Login, tp_IsActive from dbo.UserInfo where tp_IsActive = 1 a bit value of 1 shows all active users while 0 being the other value in it. Hope it helps;)Best Regards, Mukesh Giri Sr.System Executive. Posting is provided "AS IS" with no warranties, and confers no rights
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2010 2:57pm

Hi: I too agree with Magnus and previously also i had advised ( for your other query :)) you not to go for playing with content DB's. You can import user profile information of only ENABLED user accounts from AD to sharepoint server and then just export it to a excel file or try to go with object model.Best Regards, Mukesh Giri Sr.System Executive. Posting is provided "AS IS" with no warranties, and confers no rights
May 12th, 2010 4:48pm

can you give me more information about how to import user profile information of only ENABLED user accounts from AD to sharepoint server and then just export it to a excel file
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2010 4:56pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics