Papercut Print Logger Free edition - Log Distiller ASP page

[Edu-IT]

Thanks for the additional tables.

[JOrdan01070]

Hope you you don't mind synack, i have added a table that just shows user and how many they have printed in colour and how may in black and white.

i have attached the file just in case anybody else wants it.

[Little-Miss]

webwasher says no.....grrr...will try again later..

[JOrdan01070]

in internet explorer have you got the server name entered on the proxy exceptions because i had the same problem untill i entered it.

[OutToLunch]

Hope you you don't mind synack, i have added a table that just shows user and how many they have printed in colour and how may in black and white.

i have attached the file just in case anybody else wants it.

I get

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

[Microsoft][ODBC Text Driver] You tried to execute a query that does not include the specified expression 'Lcase(User)' as part of an aggregate function. 

/PrintUsage/PrintUsage.asp, line 154

thrown on this one... Just going to roll back to the 'official' V2 and try that. Great work though, thanks to both of you!

[JOrdan01070]

Sorry my fault

try now

[Little-Miss]

Have added server to exceptions and am now getting HTTP Error 404 - File or directory not found i guess its pointing me back to how i've set it up. I've followed SYNACK's guide..

[ChrisP]

Anyone think of a creative way of grabbing the CSV from another server other than the printserver?

I have 2 printservers and i want to server this application from a seperate iis box i use.

At the moment i have to have 2 seperate .asp files pointing to two seperate folders. I am having to use a batch file to copy/update the CSVs to the webserver.

[JOrdan01070]

Little Miss is allow active server pages enabled in the web service extension in iis

[Little-Miss]

Thank you so much Jordan!!

[SYNACK]

Hope you you don't mind synack, i have added a table that just shows user and how many they have printed in colour and how may in black and white.

Not a problem, I am glad that other people are finding it useful and extending it. Just a note the colour attribute is not set by all printer drivers so the count may not be correct depending on the printers you use. This is one of the reasons why our printers are set up with multiple instances for colour and black and white. These can then easily be counted and controlled individually.

Have added server to exceptions and am now getting HTTP Error 404 - File or directory not found i guess its pointing me back to how i've set it up. I've followed SYNACK's guide..

The easiest way to test this would be to go into IIS and navigate to where the PrintUsage.asp file is then right click on it and hit browse. This should take you right there but to access it from other computers you would need to replace localhost with the servername. Edit: was sure ASP was enabled by default - oops

[Little-Miss]

Edit: was sure ASP was enabled by default - oops

Not to worry, thanks for the funky add on

[Newton]

Brill, after a bit of banging my head on screen (always helps solve a problem), and knowing nothing of IIS, got it working!!!

Great bit of work there and thanks to Little-Ms who had the same problem, and solved it!

[Little-Miss]

Woo hoo me!

[bmdixon]

Just wanted to say this is brilliant!
I used to do something like this manually to try and find out how much we'd been printing but didn't do it per user.. now i know whose printing loads!
Thanks!