LOGPARSER #20: Check Browser types split between your unique users

  • Article

My previous post (#2) gave you browser types, hits and post (#19) gave you additional information like hits and percentage of hits between browsers. This script will give you more details as it looks at browser type for each unique user and give you the sum of that.  Note: If a user have two different browsers it will count for both.

If you run this script it will give you each user and the browser they use

SELECT
DISTINCT cs-username,
cs(user-agent)
INTO
UserAgentsUniqueUsers1.csv
FROM
logs\iis\ex*.log
WHERE
cs-username <> NULL
GROUP BY
cs-username,
cs(user-agent)

If you then run this script you’ll get the percentage of unique users per user agent.

Note: Script nr 2 uses output from script nr 1

SELECT
cs(user-agent),
count(cs-username) as UniqueUsersPerAgent,
TO_INT(MUL(PROPCOUNT(*), 100)) AS Percentage
INTO
UniqueUsersPerAgent.txt
FROM
UserAgentsUniqueUsers1.csv
GROUP BY
cs(user-agent)
ORDER BY
UniqueUsersPerAgent
DESC

Can look something like this. 220 of your unique domain users have IE6 and 194 have IE7

image

 

//Anders