LOGPARSER #3: Unique users per day
This is a combination of two scripts you need to use to get the unique number of users each day. This is for Logparser 2.2 and earlier if i remember correct. Maybe later version will give you this in another way. I’ve seen a variety of samples out there but this is the only true way I know if getting this.
First you need to run this script
cs-username <> NULL
Then you need to run this script towards the populated .CSV file
count(cs-username) as UniqueVisitors
You can really easy put this into a .BAT file to get this more automated. Then you can just click the .BAT file to get the numbers. Or even better schedule a work that run the .BAT file.
- Put each of the scripts into a separate .SQL file. Just put each script into notepad, save, and rename the file afterwards.
- Create a new notepad file and paste this into it. Rename to .BAT extension.
- Make sure the .BAT file is in your Logparser directory
Hope this helps!