Solved

SharePoint 2010 Term Store Reporting

Posted on 2010-09-22
1
771 Views
Last Modified: 2012-08-01
We use an instance of SharePoint 2010 for our employee intranet/portal. We use the Managed Metadata Service to create term stores for Certifications, Education, and Skills and then the User Profile Service to track what certification, education, and skills credentials each employee has.

We are interested in reporting off of the SharePoint databases to determine the certifications, education, and skills of our employees. Where is the management metadata and user profile information stored in the SharePoint databases? Is it stored in such a way to make it easy to report off of?
0
Comment
Question by:rdracer58
1 Comment
 
LVL 21

Accepted Solution

by:
chapmanjw earned 500 total points
Comment Utility
In your SQL database that SharePoint is configured for, you should see a database called Managed Metadata. It will have a GUID (xxxxxxx-xxxx-xxxx-xxxxxxxxxxxx) in the name as well.

I have yet to find a map of how the data is stored in there, but that's where it is stored.  You can do some digging through the tables to find the data you are looking for.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Grid querry results 41 51
using BEGIN END with IF statement.. 12 35
IN with @variable 5 16
SQL Server Communications Audit 5 19
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now