WebtrendsQT is an interactive command line tool for querying a Webtrends analytics reporting web service via a Windows ODBC connection, allowing you to run
mysql like commands and raw SQL against databases respresenting reports.
- pyDBCLI >= 0.1
- PyODBC >= 2.0
- Webtrends Windows ODBC driver
WebtrendsQT using easy_install:
Or from the setup script:
python setup.py install
If you run
wtqt without any arguments, the standard usage message will tell you the list of optionala and mandatory arguments to prompt up a wtqt prompt.
To get you going here's an example:
PS C:\blah> wtqt -h subdomain.mywthosting.com -d Webtrends -p foo -t bar Webtrends Query Tool v0.1 wtqt#
This example was run in Windows PowerShell, a much nicer
cmd.exe replacement by Microsoft.
In this example we're relying on a System DSN already being setup in Windows called "Webtrends", with the username/password etc. PyODBC likes to complain if you don't provide it with a System DSN for the Webtrends driver, even if you override all the settings, right down to host and port.
To get started you can use
? to find out about available commands, most of which are based on
l), but also have some custom ones like
clear to clear the data cache (caches schema, lists,
\d output etc., but not queries, these are always re-run) and
\p which lists Webtrends profiles.