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


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


Skip to main content