Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

SharePoint Profile Property Query

  Asked By: Katie Phillips         Date: Nov 19, 2008      Category: Sharepoint      Views: 502
 

I need to have a query that will query the SharePoint database (or if it is
possible, do this in SharePoint somehow) so that I can tell any users who do
not have a specific profile property assigned to them.

For example, looking at the PropertyList table I see that my custom property
has a PropertyID of 10001. Now when I look in the table UserProfileValue I
get a listing of RecordID's (which correspond with the RecordID of the
UserProfile_Full table that has the actual users name) and multiple
PropertyID's associated with each RecordID. Such that each user can have
multiple properties. I am looking for users who do not have a PropertyID of
10001 listed.

I am not an expert at SQL queries and have found this hard to write. Anyone
have any ideas?


Do you know someone who can help? Share a link to this thread on twitter, or facebook.

Tagged:        

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on SharePoint Profile Property Query Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].