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