Query to map data sources to profiles


Webtrends Analytics 8.5
Webtrends Analytics 8.7
Webtrends Analytics 9.x


For use when a complete list of data sources and their associated profile names is required


On the occasion when a complete single list of data sources and their associated profiles is required, the following query allows the user to query the system database to find those associations and put them in a single list.

You will need to install SQL Management Studio and connect to the Webtrends system database using the Webtrends Service Account.


Click on New Query, and paste in the following text, then click Execute.

USE [wtMaster]
SELECT p.[ProfileName] , d.[Name]AS DataSourceName
from [wt_Profile] p
JOIN [wt_DataSource] d
ON p.ProfileID = d.DataSourceID
JOIN [wt_ProfileDataSource] pd
ON d.DataSourceID = pd.DataSourceID
WHERE p.ProfileStatusID =1;

More Information

The WHERE p.ProfileStatusID =1 part of the query restricts the list to active profiles only and can be omitted if deleted profiles are also desired in the list.