Response Query File Sample

Here is a sample Query File taken from the All Logins.sql file:

%%[query name]

Find All

%%[query description]

List all logins to KANA Response.

%%[default date field]

loginview.LOGINDATE

%%[department user field]

loginview.KANAUSERID

%%[help page]

logins/all_logins.htm

%%[query]

SELECT

loginview.USERNAME, loginview.CONNECTED,

loginview.PROCESSINGTIME, loginview.LOGINDATE,

loginview.SESSIONID

FROM

{dbserver}.{dbname}.loginview loginview

WHERE

(loginview.PROCESSINGTIME > 0 or

loginview.PROCESSINGTIME is null) and

loginview.CONNECTED > 0 {where_sql}

ORDER BY

loginview.USERNAME ASC

%%[fields]

NAME={start_login_date}

VALUE=

FLAGS= startdate

LABEL=Beginning date:

DESCRIPTION=Login date from which to begin search

SQL={connector} loginview.LOGINDATE >= {start_login_date}

NAME={end_login_date}

VALUE=

FLAGS= enddate

LABEL=Ending date:

DESCRIPTION=Login date at which to end search

SQL={connector} loginview.LOGINDATE < {end_login_date}

NAME={user_name}

VALUE=

FLAGS= required

LABEL=User name:

DESCRIPTION=Name of user who logged in

VIEW=user tree