Print Job Tracking (English)
Contents
1. mydomain com mydomain com miydomain com mydomain cor mydomain com mydomain cor midomain corn mydomain corm midomain corn mydomain com 2 x Locations Columns Find Now Illus 26 Select group from Active Directory The selected group will be displayed with the included users Include each user in one group only to avoid possible corruption of the general overviews Users can be arranged or redirected in any groups Analyzing tracking data ThinPrint Note that users will only appear here after they have printed at least once or have been imported from an Active Directory group Costs On the Costs page Illus 27 you can define costs to analyze the financial effects of printing Given values are the estimated values of toner and paper consumption Because these costs can vary greatly for different printers and types of printouts ThinPrint recommends changing the default values to reflect your individual factors To do so select a PRINTER and enter its average costs Function Description Currency Enter a currency three characters Printer Select printer or change template default value New Paper Size Define additional paper formats Save Settings Save cost values for b w and color for the template or the selected printer Delete Delete paper format Apply Apply the same settings for other printers multiple selection2. Manage Tracking Database Rx Microsoft SQL Server Management Studio Express ioj x n ile Edit view Tools Window Community Help N wo ly a7 a a Soa Databases E System Databases ig Security J PrintJobTracking SQLO7 SQLEXPRESS Databases PrintJobTi 6 Item s CI Database Diagrams E Ca System Tables E dbo TPBCosts Gia Users SJ dbo TPBDestName EE Roles E dbo TPBDriverName Ba Schemas dbo TPBGroupName PEREAT EA EI dbo TPBGroups C Certificates E dbo TPBLogEntry f E dbo TPBMachineName La Symmetric Keys SJ dbo TPBRaperSize E dbo TPBPrinterName E dbo TPBServerName dbo TPBUserName E dbo TPBYersionInfo Views Synonyms C Prograrmmability E F a Ga rk JOCU 0a Server Objects C Replication 9 Management Illus 10 Database here PrintJobTracking Open a management tool for the database as for example Microsoft SQL Server Management Studio Express With this tool you can administer the database created by the installer Illus 10 ThinPrint Installation and configuration With SQL authenti When you install Tracking database with SQL authentication a user account will be cation created with read permissions on the database This name of the user account will be TRACKINGUSER and the pass
3. ThinPrint ThinPrint Tracking Print job statistics version 8 6 Manual ThinPrint GmbH Alt Moabit 91 a 10559 Berlin Germany Alemania Cortado Inc 7600 Grandview Avenue Suite 200 Denver Colorado 80002 USA EEUU Cortado Pty Ltd Level 20 The Zenith Centre Tower A 821 Pacific Highway E Mail info cortado com Chatswood NSW 2067 Web www thinprint com Australia Issued June 9 2015 v159 Notes o ThinPrint Copyright This document is the intellectual property of ThinPrint GmbH This document may be copied in whole or in part provided this Copyright notice is included in every copy Registered trade marks All hardware and software names mentioned in this document are the registered trademarks of their respective companies or should be regarded as such Safety warning All ThinPrint products are pure software solutions Please note the safety warnings in the technical docu mentation from your hardware vendor and from the manufacturer of each device and component Before beginning installation we recommend closing all windows and applications and deactivating any virus scanner ThinPrint Contents OVELVIQW onic cccccscecescececesceceseecessseecaseseeseveserteteteesetersevetateetesererteteneetenten 4 THACKING SSI ICS sini vaca dctandasienesaseuetemnisiarcsuemsicadmedecaamadd E a huteaneiewbdnsnemdeacenideauabeeensans 4 HC TV We MOU PV UNS te ceten casa e scrclana tare E ecient E A N A EEEO 5 Insta
4. e Mapped to certificate e Mapped to asymmetric key Server SOLO 74 SQLEXPRESS Connection S View connection properties Illus 13 Install login for Tracking Service Puta checkmark at the database which is configured for Tracking here PRINT JOBTRACKING arrow above in Illus 14 and a checkmark at TREADMIN lower arrow in Illus 14 E Login Properties MYDOMAIN ps13 tempdb tptrack Guest account enabled for Print ob racking db_accessadmin db_backupoperator Server SQLO SQLEXPRESS a Connection d sa b_datawriter b_ddladmin db_denydatareader S View connection properties O db_denydatawriter C db_owner C db_securityadmin V public Tie eee C TREUser m m m O O O Illus 14 User mapping Then Tracking Service can access the database with Windows authentication 12 Manual Tracking Manual fm GTO HOWD uudulyLl ThinPrint irstallation and configuration Installation of Tracking Report Engine on the webserver Please consider that Tracking Report Engine cannot be installed on Windows 2003 x64 machines Make sure that the following Windows components are installed and Started IIS and ASPNET Copy SETUP EXE of Tracking Report Engine onto the web server and open it Select the desired language and confirm with OK InstallShield Wizard opens ie ThinPrint Tracking Report Engine 6 6 x Database Server 2 s Select database server
5. authentication method and database Thi n Pri nt Database server that you are connecting ta SQLOFISQLEXPRESS Y Browse Connect using Windows authentication credentials of current user i f SOL Server authentication using the login and password below Login TrackingService Password sssssss Database name PrintJobTracking _ Browse Imstalsmield EEE SSsSS S E Cancel Illus 15 Choose database and authentication mode Select the database server on which Tracking Database has been installed Illus 15 arrow above Then select the same authentication mode which you have selected during Tracking database installation Illus 5 here SQL SERVER AUTHENTICATION Illus 15 middle arrow Finally indicate the database which has been created by Tracking database installer here PRINTJOBTRACKING Illus 15 lower arrow Confirm with NEXT x i ThinPrint Tracking Report Engine 6 6 Database Authentication Specify authentication mode Thi i Pri nt Select authentication that Tracking Report Engine will use to connect ta the Tracking database i Windows authentication SOL server authentication InstallShield E Cancel Illus 16 Choose authentication mode Installation and configuration Th l n Print Here select the authentication mode with which Tracking Report Engine esta blishes a connection to Tracking Datab
6. Tracking Report Engine gt a Illus 1 Example for using ThinPrint Tracking Tracking is part of the following ThinPrint products e ThinPrint Engine with a ThinPrint Engine Premium license or e Personal Printing If not yet installed an SQL server must be installed to enable use of the tracking fea ture within the ThinPrint Engine This program is not included in the ThinPrint Engine software Tracking Service You can gather information about the print jobs sent with the ThinPrint Engine for your statistics tracking To do so you must set up a Microsoft SQL server The Thin ThinPrint verve Print Engine sends its tracking data to the server that has the tracking service instal led Print data which can be analyzed and displayed by Tracking Report Engine are e Author of a print job user group e Printer used e Settings used e Number of pages printed e Information on any errors e Costs e Compression rates ThinPrint Engine only e Print duration e Print data during a defined period The SQL server can collect print data from different sources from ThinPrint Engines on application or print servers or from Personal Printing servers Tracking Report Engine ThinPrint Tracking includes a web application for viewing the tracking data This pro gram represents the SQL data graphically in its web interface installed on a web server The tracking data can therefore be analyzed from the web browser on any
7. a L Illus 28 Microsoft SQL Server Management Studio Express Data from the ThinPrint Tracking Service If printer drivers and applications in use on the source computer provide certain values and the specific version of ThinPrint Engine or Personal Printing also sup 2 Can be downloaded from the Microsoft website for free www microsoft com Page 25 note sys tem requirements 3 The computer creating the print jobs that ThinPrint Engine sends to the ThinPrint Tracking Ser vice Appendix Value in the database MachineName DriverName DestName ServerName PrinterName ID UserName Orientation PaperSize PaperLength PaperWidth Copies DefaultSource PrintQuality Color Duplex XRes YRes TTOption dmCollate FormName JobSize ThinPrint ports them the following information can be sent with each print job to the ThinPrint Tracking Service which will write it to the SQL database here PrintJobTracking Supported by Meaning ThinPrint Output Gateway IP address of the source computer e g 192 168 131 300 not currently used Host name of the target computer e g client 22 Host name of the source computer e g server O3 Name of the printer on the source computer e g HP LaserJet 4 client 22 6 ID in the SQL database Name of the person who printed Account Paper orientation portrait or landscape Paper format e g A4 Letter Executive For user defined p
8. of print jobs e Color and b w grayscales e Simplex and duplex 16 Manual Tracking Manual fm TAN GTO HOWD JU quIy ThinPrint GmbH 2015 ThinPrint Analyzing tracking data e Paper consumption e Color and b w grayscales e Simplex and duplex You can also specify the information as follows Function Group Printer Start End Predefined Tracking Manual tm Description Choice between a specific or all user groups see Managing Groups Page 20 Choice between a specific or all printers Start of a report period display and input End of a report period display and input Choice of a report period ThinPrint Tracking Report Engine Here you can see the amount of print jobs and printed pages You can filter user groups or single printers Additionally you can specify a time interval Groups can be defined in the menu Manage Groups Group All Y Printer All v Start 6 1 2011 End 6 30 2011 Predefined CurreatMowt v Print Jobs Paper Consumption Black White 270 Black White l Color l Total 546 Color 42 Illus 21 Overview of number of printouts and paper usage Manual 17 Analyzing tracking data ThinPrint Distribution The DISTRIBUTION page allows analysis of which users groups or printers have prin ted the most Illus 22 You can specify the information as follows CATEGORY Description Print Jobs Number of print jobs Costs Print costs for
9. the number of pages printed by the respec Paper Consumption tive selection group s or users taking into account prin ter specific costs per page Number of sheets used for printing Simplex Number of pages printed one sided Duplex Number of pages printed on both sides Black White Number of pages printed in black and white Color Number of pages printed in color Errors Number of failed print jobs Group Choice between a specific or all user groups see Managing Groups Page 20 Printer Choice between a specific or all printers Start Start of a report period display and input End End of a report period display and input Predefined Choice of a report periods ThinPrint Analyzing tracking data ThinPrint gout Tracking Report Engine rm ES coo Here you can see print activity for groups or printers which can be filtered according to criteria such as cost compression or failed print jobs Category Print Jobs v i Group AJl v Printer AJl v Start 6 1 2011 End 6 30 2011 Predefined Previous Month Print Jobs Ranking Users Groups Ranking Printers MYDOMAIN administrator 43 pilareen arm pr a 54 MYDOMAIN user2 29 p MYDOMAIN Ser1 17 DeskJet 192 168 116 1 1 46 MYDOMAINwsert 17 MYDOMAIN ser3 11 MYDOMAINiadmin 43 Illus 22 Ranking Trend The TREND page gives an overview of how the frequency of printing has developed across a set timeframe The example in Illus 23 shows a cost trend See ab
10. tracking data ThinPrint For information about preparing Tracking on a print server cluster see the Microsoft Failover Clusters and ThinPrint documentation Page 25 Analyzing tracking data The ThinPrint Tracking Report Engine makes it possible to display data from the SQL database as an overview in a web browser All significant information on print jobs can be summarized by various criteria sorted and graphically displayed You can analyze the data with the included Tracking Report Engine or any other tool to retrieve the database To analyze the tracking data start your web browser and call up the website of the server that ThinPrint Tracking Report Engine is installed on http lt webserver gt tracking Example http osl3 cracking Enter the account created on the SQL server here TRACKINGSERVICE which has write permissions for the database here PRINTJOBTRACKING Illus 20 E ThinPrint Tracking Report Engine Microsoft Internet Explorer Datei Bearbeiten Ansicht Favoriten Extras 7 GD zur ck EQ x 2 A Suchen Favoriten i gt Adresse http ipsi 3 tracking wechseln zu Links ThinPrint Tracking Report Engine ThinPrint User TrackingService PassivOrds 0 ccc a ofl p Internet a ire o ooo Illus 20 Open the Tracking Report Engine in a web browser Overview The page OVERVIEW appears Illus 21 You see the following information for analy SIS e Number
11. with Ctrl and Shift keys ThinPrint Logout Tracking Report Engine ee pect _ Select the paper sizes below left that are used by the printer shovm above Then enter the prices for color and b w printing This template can be used afterwerds for all similar printers on the right Currency Template Template Apply this template to P a the following printers 10X11 0 00 0 00 amm HP Color LaserJet 4700 192 164 10X14 0 00 0 00 HP DeskJet 192 168 116 1 1 11X17 000 0 00 7 E gt A4 0 04 0 20 E ad A3 006 g 025 lt _ gt LEGAL 0 04 E 0 20 LETTER 004 0 20 Pe Wadia Tet ae A lt gt 12X11 000 000 Other 0 04 0 20 15X11 x Illus 27 Settings for estimated costs 22 Manual Tracking Manual fm GIOZ HAW juuquIUL ThinPrint A perniix Appendix Customer service and technical support www thinprint com gt RESOURCES amp SUPPORT www thinprint com en us resourcessupport supportrequest aspx SQL server management tools Overview In addition to the ThinPrint Tracking Report Engine you can also use management tools for directly accessing the SQL database such as Microsoft SQL Server Manage ment Studio Express This has the advantage that you can both create a database and analyze all data stored in the database Illus 28 Rx Microsoft SQL Server Managem
12. workstation Illus 2 ThinPrint Tracking Report Engine ou can see the amount of printjobs and printed pages You can filter user groups or single printers Additionally you can specify a interval Groups can be defined in the menu Manage Groups Start 6 1 2011 End 6 30 2011 Predefined CareatMorti v Print Jobs Illus 2 Analyzing SQL data in a web browser example Installation and configuration Th i n Pri nt Installation and configuration Technical requirements Your architecture must meet the following requirements for running ThinPrint Tra cking e ThinPrint Engine ThinPrint Tracking Service See the ThinPrint Engine manual on terminal servers or print servers on Page 25 or Personal Printing See Personal Printing manual onPage 25 e The SQL server additionally requires e Microsoft SQL Server 2005 2008 or 2008 R2 e The ThinPrint Tracking Report Engine can be run on the following servers as a web server e Windows Server 2003 x86 with Service Pack 2 or later e Windows Server 2008 x86 and x64 Service Pack 2 e Windows Server 2008 R2 x64 Service Pack 1 The following is required e Microsoft NET Framework version 3 5 SP 1 e ASP NET can be enabled as a Windows component or installed as a part of the NET Framework e Internet Information Services IIS 5 1 or later Port 80 is used by default Do not change this port number and make sure that no other programs are using this port Note Please not
13. aper formats otherwise value O Paper length cm Paper width cm Number of copies Default paper source Printout quality maximum value of XRes and YRes e g 600 dpi or quality level e g fine Color or grayscale b w Double sided or single sided duplex or simplex Horizontal resolution dpi Vertical resolution dpi TTOption Load TrueType fonts embedded in the file as bit map as soft font or outline or information about what prin ter font is to be replaced depending on the application Sorting option e g print longer documents consecutively Name of the paper format not currently used ThinPrint Value in the database JobTSize JobID Status ClientID Pages TStamp Duration DevMode Printlype Compressi onRate DocumentName ThinPrint Microsoft website Meaning not currently used Print job ID Values 1 Print job delivered 2 Successfully printed 3 Print job cancelled not currently used Number of printed pages Time of print job start of communication between ThinPrint Engine and ThinPrint Tracking Service Duration of the printout ms device mode Data as blob binary large object Format of print data values m EMF r RAW compression rate of the print job divides the value JobTSize by value JobSize With ThinPrint Engine only name of the document Additional sources Appendix Supported by ThinPrint Output Gat
14. ase Confirm with NEXT and close InstallShield Wizard with FINISH Personal Printing and Tracking The settings for Tracking are described in the Personal Printing manual Page 25 ThinPrint Engine and Tracking Installation Please consult the ThinPrint Engine user manual for installation information Page 25 Preparing ThinPrint Engine and Tracking Service To prepare the ThinPrint Engine for sending data of sent print jobs to the SQL server you must make the following settings in the configuration for the ThinPrint Engine 1 Open configuration with START ALL PROGRAMS THINPRINT ENGINE CON FIGURATION 2 Mark the respective THINPRINT ENGINE node Illus 17 and select EDIT SETTINGS aio x Fie Action Yiew Hep e I hnPnrt Print Engine P513 5 E 29 print Encine P513 ge AutoCornect s The fuluwiny abe shuas dl events generale by piri cu pur eis which wll dso cupear in be Wir doas Evan Viewer Aduiliur dly vue var WeLeyer F display tie p int ssooler ever s here this zan 3 erabled inthe dia ogae al ths bo tom here also the razking 3smice cen be selectec In Ihe eecond chle youll find al serviczs uscd by aint comaonerts lp Pot Manage n a Licenses Servize S arbap Typ b rart sarare CF Pint Sproule Speer Furr inte Sop Service LF IP ArkcLoniect termice Pautolonrsvc Kunrme LF TP Trackirg Servize TPT rackS ve Nuning l gt Restert Service Ds crp iion ThiaPint prin c
15. e with ThinPrint Tracking that data printed via a ThinPrint Port is collected Administrator permissions are required for all installation and configuration procedu res Installation of Tracking Database Open SETUP EXE onto the SQL server Select the desired language InstallShield Wizard opens see Illus 3 and click Next ThinPrint stalation and configuration ThinPrint Tracking Database 8 6 x Welcome to the InstallShield Wizard for ThinPrint Tracking Database 8 6 Thi p The InstallShield R Wizard will install the ThinPrint Tracking inl rl nt Database 6 6 on your computer To continue click Next ThinPrint Tracking Database Version 8 6 WARMING This program is protected by copyright law and international treaties ThinPrint 2 6 43 E Cancel Illus 3 Start InstallShield Wizard Select the SQL server on which you wish to install Tracking database arrow above in Illus 4 Then specify how do you wish to access the database Illus 4 bottom arrow e Windows authentication or e SQL server authentication Confirm with NEXT ie ThinPrint Tracking Database 6 6 x Database Server q 2 Select database server and authentication method Thi ii Pri nt Database server where you want to create an SOL database SOLO7 SOLEXPRESS Connect using Browse Windows authentication credentials of current user _ gt SOL server authentication using the l
16. ent Studio Express oj x File Edit View Query Designer Tools Window Help New Query D oF A at B CS BB SS Ee a a BM chance twe 2 f fo le Object Explorer server 02 TPTr 5QLQuery1 sql Table dbo TPBLogEntry Summary PrintQuality Color Duplex XRes YRes TTOption dmCollate FormName JobSize JobID Pages TStamp Duration E y server 02 SQL Server 8 0 760 sa a c y Letter 0 3 27 02 2006 Lj Databases Letter 27 02 2006 System Databases E TPTrack Letter 27 02 2006 Database Diagrams Letter 27 02 2006 Lj Tables Letter 27 02 2006 E System Tables E dbo TPBConfig E dbo TPBCosts E dbo TPBCurrencies J dbo TPBDestName SJ dbo TPBDriverName E dbo TPBGroupName SJ dbo TPBGroups Bel dbo TPBLogEntry dbo TPBMachineName dbo TPBPaperSize E dbo TPBPrinterName SJ dbo TPBServerName SJ dbo TPBUserName yj views of 17702 gt Pl be Ad Ad Ad Ad Ad Ad Ad Ad Ad 27 02 2006 27 02 2006 27 02 2006 28 02 2006 28 02 2006 28 02 2006 28 02 2006 28 02 2006 HH Eeeee o oOo oo 30 03D 8b FO Oo Oo fo Oo O 3 3 3 3 3 3 3 3 w wn wn wv wn wn wv wn wn lt lt wn wv wn i wO OU OU U UU UU U U 2 X X X X x x a3 a a3 2a j ji SIS 3 3 1 3 3 3 3 3 9 a ja oO oO oO oO Oo Oo oO aTwnvesteia g oecoTgroen9 crvrioorveicotioTvcvrijgdtdavtTwor ARs
17. eway The following manuals and technical documentations amongst others are available at www thinprint com manuals e ThinPrint Engine for terminal server e ThinPrint Engine for print server e Personal Printing Microsoft failover clusters and ThinPrint Management software for SQL servers Microsoft SQL Server Management Studio Express can be downloaded for free at http www microsoft com en us download details aspx id 8961 Appendix ASP dpi EMF ID IIS MMC Output Gateway SQL Abbreviations Active Server Pages dots per inch Enhanced Metafile Identification number Internet Information Service Microsoft Management Console ThinPrint Output Gateway Structured Query Language ThinPrint
18. llation and configuration 0 0 00 rrenen 6 Technical TOCUINCINCEIS shacnaessnensecaresneesaaneensasreeecaeseeesg san oiiyencumeecnanenecargsuean A 6 Installation of Tracking Database ccccecscsceceeeeeeeeeeeeteeetaeaeseeeeeeeeteateetatataeseatetettataeas 6 Select authentication mode for the users cececec ee eeeeeeeeeeeeeeeceeeeeeeeeeeseeeeeeeaeaeeeseaeaeaeees 8 Manage Tracking Bk 1 ic 6 sic eee ee ere ERE eee eee ee ee LO Installation of Tracking Report Engine on the webserver ccececeeeeeeeeeeeeeteeeeeeeeeeeeeteteees 13 Personal Frinune and TACNE sicacascmarandcuntakecicovaaodatwieren E E aE 14 TIME TIES NC And IT ACKING scaaisewarsetiaastsepsaneioteosttoteossatewueseieuarsessaeueicssourentepasanaweres 14 WS el LOO a EAE a ui acteurs aac Sette E te nen E N 14 Preparing ThinPrint Engine and Tracking Service ccceceececeeeeeeeeeeeeeeeeaeeeeeeteeaeeeetess 14 Analyzing tracking data oo errre 16 OSE eee siecrniececrancusceceaenaneweencveueey AE EEE OEE 16 LD SUM DURE O Ul case sieeowdecaataneamatiucectneneaesmaae ataucenedtamanaadsmatoncamatenecsmisaenceteitonduaadenmenseassanices 18 IEEE a a E E E E A E E A A E E E sarevenseneaue eas 19 a GOW OS orr A E E 20 SS ac a T E E E E E A A E E T 22 Appendix Qc cree 23 Customer service and technical support ccccecececeeeeeeeeeeetetteceeseeeeeeseeeteeseateseneneaeeees 23 SQL Server management toolS ccsccececececeecececeeeeeeeseseeeeseeesesesese
19. n 2 ThinPrint Specify an SQL account for this database ThinPrint Tracking stores its information in a database To access the data it is necessary to create a new user or to specify an existing one This account will have administrator permissions on the database and is needed For the ThinPrint Engine and the Tracking Report Engine Login TrackingService Password CO the password is complex enough ta meet the Windows T IF vou wish to create a new account make sure that policy requirements Installshield E Cancel Illus 6 Create administrator account for the Database Windows authenti If you choose Windows Authentication Illus 7 all users and servers need to be cation members of the same domain Users can log on with their user name and their domain password ThinPrint Installation and configuration i ThinPrint Tracking Database 8 6 x Database Authentication z z Specify database name and authentication mode Thi n Pri nt Database name PrintJobTracking A Browse Database authentication mode i Windows authentication lt q SOL server authentication recommended Select SOL server authentication if your SOL server is nok a domain member Installshield E Cancel Illus 7 Choose Windows authentication mode Choose WINDOWS AUTHENTICATION Illus 7 lower arrow and confirm with NEXT iis ThinPrint Tracking Database 8 6 l x Windows Authentication z k Specify accounts F
20. ogin and password below Login Isa Password seecenes Installshield lt Back Cancel Illus 4 Choose Database server and authentication to SQL server Choose a name for the database in which the information about print jobs will be stored PRINTJOBTRACKING for example Illus 5 upper arrow Incase of a software update you can select an existing database by clicking on the button BROWSE Installation and configuration Th n Pri nt x ie ThinPrint Tracking Database 6 6 Database Authentication z z ThinPrint Specify database name and authentication mode Database name PrintJobTracking lt i Browse Database authentication mode i Windows authentication f SOL server authentication recommended j Select SOL server authentication if your SOL server is nok a domain member Installshield E Cancel Illus 5 Choose database server and Authentication mode Select authentication mode for the users Authentication mode Illus 6 defines how the users and Tracking Service access the stored print data via Tracking Report Engine Note SQL server authentication is recommended SQL server Authen Create an account with administration permissions Illus 6 TRACKINGSERVICE tication for example Or specify an existing one Note the user name and password Confirm with NEXT and close InstallShield Wizard with FINISH jp ThinPrint Tracking Database 8 6 xX SQL Server Authenticatio
21. omporen Iha stores p int job hormatan in 2 da cbase Server Settings SY Edt Sectings Spooler Everts Not supported to Windows Serwer ZUUY H2 4 Seid Configiratior ou ag spocler err events m Refresh Al Lag spocler wcrning gt vert ag snocler infarratinn wert Tracking Status o Ddabase Sarve SOLOZSQLESPRESS Liastabase Hrintlob racking Illus 17 Selecting TRACKING SETTINGS ThinPrint GmbH 2015 ThinPrint irstallation and configuration 3 Enter the following settings in the TRACKING tab Illus 18 e ENABLE TRACKING e SQL server s address and name e SQL server Windows authentication an account or the which has write per missions for the installed database here PRINTJOBTRACKING e Encryption settings if the data are to sent encrypted to the SQL server e Name of the Tracking database here PrintJobTracking fi Server Properties M SQLO 74 SQLEXPRESS Bancel Search Illus 18 Enable Tracking and enter settings Server Settings E Edit Settings Spooler Events Not supported for Windows Server 2008 R2 M Send Configuration Log spooler error events Refresh All E Log spooler warning events Log spooler information events Tracking Status on Database Server SQLO SGLEXPRESS lt g ___ Database PrintJobT racking Last Refresh 7 7 2011 12 50 57 PM Illus 19 Print job tracking enabled Tracking Manual fm Manual 15 Analyzing
22. or Windows authentication Thi n Pri nt d E ica Select this object type Groups Object Types From this location mydomain com Locations Enter the object names to select examples TrackingAdmins Check Mames Z Inst lt Back Cancel Illus 8 Inherit groups from Active Directory You can select user groups from the Active Directory which should be able to access Tracking Database For this click ADVANCED arrow in Illus 8 Installation and configuration Th n Print ThinPrint Tracking Database 8 6 x Windows Authentication z z Specify accounts For Windows authentication Thi Pri nt ThinPrint Tracking stores its information in a database Specify twa domain groups to access the data and to login to Tracking Report Engine The First account has administrator permissions fcreate modify database The second one is a read only account Tracking database administrator MYDOMAIN Tracking dmins i Browse Tracking database user hyYDOMAINYTrackingLisers cj Browse Installshield E Cancel Illus 9 Define administrator groups and user groups During installation of Tracking database Tracking database administrators Illus 9 arrow above with read and write permissions will be created as well as users with read permissions only see Illus 9 bottom arrow Finally conclude Tracking database installation in InstallShield Wizard with INSTALL and FINISH
23. ove for a description of available functions Additionally you have the option to display compression rates of print jobs when printing with a ThinPrint Engine arrow in Illus 23 ThinPrint GmbH 2015 Tracking Manual tm Manual 19 Analyzing tracking data ThinPrint ThinPrint Bout Tracking Report Engine SS puertencn _ Here you can see print activity for groups or printers in a specified time interval to survey a trend Category Printer All v End i Predefined Current Morth Number of 2 Print Jobs i 0 2 0 3 0 4 0 5 D 6 0 7 0 8 0 9 0 10 0 11 0 12 0 13 0 14 0 15 0 16 0 17 0 18 0 19 0 20 0 7 8 HH 8 S amp TT OW 2 e 21 0 Day 22 68 23 12 Illus 23 Displaying trends here number of print jobs Managing Groups On the MANAGE GROUPS page Illus 24 you can define user groups to make the pre vious pages easier to read ThinPrint Wout Tracking Report Engine E msennnon Here you can assign users to a group create new groups or use existing groups from Active Directory This allows you to track print data per user group Users are first listed when they have printed on at least one occasion Group x T lt q Available MYDOMAMactrinistrator MYDOMANuserl MYDOMAINwser2 MYDOMAINwuser3 tari Creatng a new group A Import a group from Active Directory Illus 24 Defining user groups 20 Manual Tracking Manual fm GTO HOWD JUN quIy ThinPrint Analyzing t
24. racking data Note To do this you have to use the Internet Explorer browser on the same web server on which the Tracking Report Engine was installed It is not pos sible in this situation to gain remote access from just any computer To do so click the button IMPORT A GROUP FROM ACTIVE DIRECTORY Illus 24 Then click ADVANCED arrow in Illus 25 Select Groups Select this object type Groups Object Types From this location 2 Entire Directory Locations Enter the object names to select examples Check Mames OF Cancel 4A Illus 25 User import from Active Directory Click FIND Now Illus 26 upper arrow Groups are displayed Checkmark the desired group Illus 26 lower arrow and confirm with OK Select Groups Select this object type Groups Object Types From this location Entire Director Common Queries Starts with Description Starts with Mame P Disabled accounts Non expiring password Dave since last logon z Search results a Domain Users A Enterprize Ad ae Group Policy Gruppe_1 ae Helps ervices ae Sales ae Exchange Do ae Exchange Ent HP RAS and IAS All domain users Designated admi Microsoft Excha Microsoft E scha Members in this Group tor the He Servers in this gr ar Schema Admins Designated admi In Folder
25. seaeeeeetatststatatatatanatas 23 OC ere ewan A enn ccc E rece daearne EEA ate enw teneandere 23 Data from the ThinPrint Tracking Service cccccseceseseseeeeseseeeeeeeteeeeetatetettetatetnetens 23 POUN OCES a E E A 29 ADDV OWS accanusanstentcdnacessacvoresacurusececciosodadewsecanensetaccsioustasseuasaateeesacancisecesossielawscactueeeses 26 Overview CCCsCS WAP Overview ThinPrint Tracking allows you to oversee your print volume How many printers are overloaded Which are hardly used How many color or black amp white printouts are printed on a daily basis What are the resulting costs How it works The print data of ThinPrint Ports is compiled by the server and transferred into an SQL database From there they can be graphically presented as a website using the Tracking Report Engine which also allows for many other settings such as querying print volumes for a certain branch during a certain time period Authorized individu als can access the website from anywhere Print job tracking has the following components Illus 1 e ThinPrint Engine or Personal Printing sends data to the ThinPrint Tracking Service e ThinPrint Tracking Service receives data and writes it to an SQL database e ThinPrint Tracking Report Engine web component for clear analysis summary and graphic report of tracking results Print Server ThinPrint Engine or Personal Printing S Tracking data base Web Server Windows
26. word is THINPRINT 1 Datei Aktion Ansicht 7 Status Y Shared Memory Enabled A Named Pipes Enabled W TCPIIP Enabled Y VIA Disabled om 8 SOL Native Client EIET Illus 11 Enable protocols To access the SQL server remotely open SQL Server Manager and enable the protocols NAMED PIPES and TCP IP Illus 11 Then start the SQL SERVER BROWSER in the services folder With Windows To ensure the Tracking Service gets access to the SQL server open Management authentication Studio Express Illus 12 and enter with a right click in the FOLDER SECURITY on NEW and LOGIN E Microsoft SOL Server Management Studio Express q ioj x File Edit wiew Tools Window Community Help El new Query iy Gy kel a Bs i Be aG Object Explorer i i A SOLOFISQLEXPRESS SOL Server 9 0 1399 sa Ca Databases sone SOLO7 SQLEXPRESS Server Objects SOLOTISQLEXPRESS 5 Itemis Replication Management Re Refresh Manageme Illus 12 Install access for Tracking Service on the SQL server 1 Can be downloaded from the Microsoft website for free www microsoft com Page 25 note sys tem requirements Installation and configuration ThinPrint Create a new account according to this sample Illus 13 lt domain gt lt Server name of Tracking Service gt Here mydomain ps13 Login New EE Sach Ess A Enforce password policy M Enforce password expiration IV User must change password at next login
Download Pdf Manuals
Related Search