1. Open a command prompt window.
2a. For installations of Webtrends which use MS SQL Server Express 2005, type the following command and then hit Enter:
sqlcmd -W -s , -S <server name>
...where <server name> is the name of the server hosting the SQL database.
2b. For installations of Webtrends which use MS SQL Server Express 2008, type the following command and then hit Enter:
sqlcmd -W -s , -S <server name>\<instance>
...where <server name> is the name of the server hosting the SQL database and <instance> is the name of the database instance. The default instance is "WTSYSTEMDB".
3. At the prompt (1>), enter one of the following to specify the part of the database used, then hit Enter:
use wtMaster
use wt_sched
4. Type in the following and hit Enter:
GO
"Changed database context to 'wtMaster/wt_sched'" displays.
5. Type in the queries and hit Enter. Multiple queries can be entered on separate lines. Type GO to execute a query or queries.
Example:
1> select * from wtmaster.dbo.wt_globalsettings where SettingID='36'
2> select WRC_ProfileID from wtmaster.dbo.wt_profile where ProfileID='1'
3> GO
|