How do I get a list of all profile guids and names?

Products

Webtrends Analytics 8.x
Webtrends Analytics 9.x

Cause

Situation:
You want a list of all your profile guids and associated Profile IDs.

Solution:
For software customers, that information is available in the wt_profile table of the system database. In version 8.5 and later, use the following query:

SELECT WRC_profileID,ProfileName FROM wtmaster.dbo.wt_profile;

In 8.1a and earlier, the following query will work, unless you are using MS SQL, in which case you should use the above query:

SELECT WRC_profileID,ProfileName FROM wtmaster.wt_profile;

If you need help executing these queries, or have further questions, contact Webtrends Technical Support at (503) 223-3023.