Calculate Printer Page Count Per User

I have a script that pulls all print events from the main print server and
archive them. Now I would like to take those archives and come up with a
total page count for each user. Initially I am only looking to do this for
one particular printer.

I have a powershell function that returns the username and the page count
for that particular print job from the printer I want to report on. The
results look something like this:

domain\userone 2
domain\usertwo 3
domain\userone 21
domain\userthree 5
domain\usertwo 6
domain\userone 346

I can have the function return that comma separated if that will make things
easier.

Now in this same script I want to total the number of pages printed for each
user. Can someone point me in the right direction on how I should go about
summing the page count up for each user?

Thanks!
Jeffrey

If you have the raw data in a file called report.txt, then the following will
do the job:

$rep = gc report.txt
$totals = @{} #create a hash to hold totals
$rep | foreach-object {
($name, $pages) = $_.split(" "); #get the name and pagecount from one line
of file
($totals.$name) += [int]$pages #initialize or increment the total for the
hash entry keyed by $name
}
$totals # display the totals



"Jeffrey Tadlock" wrote:

> I have a script that pulls all print events from the main print server and
> archive them. Now I would like to take those archives and come up with a
> total page count for each user. Initially I am only looking to do this for
> one particular printer.
>
> I have a powershell function that returns the username and the page count
> for that particular print job from the printer I want to report on. The
> results look something like this:
>
> domain\userone 2
> domain\usertwo 3
> domain\userone 21
> domain\userthree 5
> domain\usertwo 6
> domain\userone 346
>
> I can have the function return that comma separated if that will make things
> easier.
>
> Now in this same script I want to total the number of pages printed for each
> user. Can someone point me in the right direction on how I should go about
> summing the page count up for each user?
>
> Thanks!
> Jeffrey
>
>
>

Thank you! This worked just as I needed. Your help is appreciated.

--Jeffrey

"forestial" <forestial@discussions.microsoft.com> wrote in message
news:6A87108F-904A-4445-A4BD-C59CAC976B33@microsoft.com...
> If you have the raw data in a file called report.txt, then the following
> will
> do the job:
>
> $rep = gc report.txt
> $totals = @{} #create a hash to hold totals
> $rep | foreach-object {
> ($name, $pages) = $_.split(" "); #get the name and pagecount from one
> line
> of file
> ($totals.$name) += [int]$pages #initialize or increment the total for
> the
> hash entry keyed by $name
> }
> $totals # display the totals
>
> "Jeffrey Tadlock" wrote:
>> I have a powershell function that returns the username and the page count
>> for that particular print job from the printer I want to report on. The
>> results look something like this:
>>
>> domain\userone 2
>> domain\usertwo 3
>> domain\userone 21
>> domain\userthree 5
>> domain\usertwo 6
>> domain\userone 346
>>
>> Now in this same script I want to total the number of pages printed for
>> each
>> user. Can someone point me in the right direction on how I should go
>> about
>> summing the page count up for each user?

"Jeffrey Tadlock"

> and come up with a total page
> count for each user.

>
> domain\userone 2
> domain\usertwo 3
> domain\userone 21
> domain\userthree 5
> domain\usertwo 6
> domain\userone 346
>

Perhaps Microsoft's Log Parser 2.2

PS> LogParser.exe "SELECT field1 AS User, SUM(field2) AS
PageCountTotals FROM pa
geCount.txt GROUP BY
User" -i:tsv -headerRowff -iSeparator:"space" -statsff
User PageCountTotals
---------------- ---------------
domain\userone 369
domain\usertwo 9
domain\userthree 5
PS>

Oh and using a chart really
shows paper usage!

PS> LogParser.exe "SELECT field1 AS User, SUM(field2) AS
PageCountTotals INTO Pa
geCounts.gif FROM pageCount.txt GROUP BY
User" -i:tsv -headerRowff -iSeparator
:"space" -statsff -chartType:BarStacked3D -chartTitle:"Paper
Counts" -viewn
PS>

Log Parser works in most Windows
shells and Windows languages.

Just another way!