dcsimg

Identify a Webtrends installations abilities/components through MS SQL query

Products

Webtrends Analytics 9.x
Webtrends Analytics 8.x

Summary

To determine what abilities/components have been installed on a given Webtrends server log into the MS SQL database

Cause

To determine what abilities/components have been installed on a given Webtrends server log into the MS SQL database and execute the queries provided.

Resolution

Connect to the Webtrends system database using Microsoft Management Studio or Management Studio Express.

Run the following query on the wtmaster database by copying it into the Query Window and executing:

SELECT WTMS.ServerName as Server, WTMM.Description as Module
FROM wtmaster.dbo.WT_server WTMS
JOIN wtmaster.dbo.WT_ServerModule WTMSM
ON WTMS.ServerID = WTMSM.ServerID
JOIN wtmaster.dbo.wt_Module WTMM
ON WTMSM.ModuleID = WTMM.ModuleID
ORDER BY WTMS.ServerName

Run the following query on the wt_sched database by copying it into the Query Window and executing:

SELECT WTSH.HostName as Host, WTSC.DisplayName as Component
FROM WT_Sched.dbo.WT_Component WTSC
JOIN WT_Sched.dbo.WT_ComponentInstallation WTSCI
ON WTSC.ComponentID = WTSCI.ComponentID
JOIN WT_Sched.dbo.WT_Host WTSH
ON WTSCI.HostID = WTSH.HostID