Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SharePoint Profile Property Query

  Asked By: Katie    Date: Nov 19    Category: Sharepoint    Views: 2044

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?



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.