Products
Webtrends Analytics 8.5
Webtrends Analytics 8.7
Webtrends Analytics 9.x
Summary
For use when a complete list of data sources and their associated profile names is required
Cause
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.
Resolution
Click on New Query, and paste in the following text, then click Execute.
USE [wtMaster]
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.