Network printer usage tracker

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,750
Hi all,

We have network printers located in a common area.

It has been a recurring problem that after a while, there are so many printouts that nobody ever claims. Pile keeps building up.

Is there any software that sort of tracks who printed what at the end of each day, including the number of pages?

Or how do you guys handle it in your own offices?

Thanks for any input.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
If you have logging enabled, you could probably use Excel to read through the log files.

We used to have a similar setting where the IT would run a code to read through the text logs generated.
 
If you have logging enabled, you could probably use Excel to read through the log files.

We used to have a similar setting where the IT would run a code to read through the text logs generated.

I am all ears, mate..:)

Can you elaborate, or do you have the codes to share?
 
Unfortunately, the fellow who did this is no longer with the company. I'll see if I can dig around for the code (we've stopped logging since the past year or so).

If you have your logs as text files, there are many posts on the board that give the codes for that, and you could probably modify them to suit your purpose. Here are some of them

http://www.mrexcel.com/forum/showthread.php?t=328512
http://www.mrexcel.com/forum/showthread.php?t=271784
http://www.mrexcel.com/forum/showthread.php?t=490950
http://www.mrexcel.com/forum/showthread.php?t=406417

If the text file is delimited, you could probably import the text file in Excel and do your searching in Excel itself.
 

Forum statistics

Threads
1,222,628
Messages
6,167,174
Members
452,101
Latest member
xuebohan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top