ThinPrint Tracking - Personal Printing
Contents
1. 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 Open a management tool for the database as for example Microsoft SQL Server Man agement Studio Express 1 With this tool you can administer the database created by the installer Illus 10 1 free download from Microsoft website Page 30 pay attention to the system requirements ThinPrint nstalation and configuration E Microsoft SQL Server Management Studio Express o Oj xj File Edit View Tools Window Community Help d New Query iG ih Bs E a PE SE Object Explorer E 4 Databases LA System Databases security Ej j PrintJobTracking SQLO7ISQLEXPRESSIDatabaseslPrintJobTi 6 Item s CI Database Diagrams La Tables 4 System Tables 2 dbo TPBCosts CB Users dbo TPBDestName Gia Roles dbo TPBDriverName Bl Schemas dbo TPBGroupName dbo TPBGroups E dbo TPBLogEntry dbo TPBMachineMame dbo TPBPaperSize dbo TPBPrinterName dbo TPBServerName E dbo TPBUserName dbo TPBVersionInfo LA Views Synonyms ati E Lg Asymmetric Keys LY Certi2. I mx Select a page amp Script 8 Help LA General A Server Roles E mda A SA User Mapping Login name mydomain ps13 earch A Securables Ll aero En Status ltd y C SOL Server authentication Password Confirm password v Enforce password policy v Enforce password expiration v User must change password at next login Mapped to certificate Certificate name Mapped to asymmetric key Connection Key name Server SQLOF SGLEXPRESS Default database master Connection Default language lt default gt sa 3 View connection properties E Error occurred Illus 13 Install login for Tracking Service Create a new account according to this sample lt domain gt lt Server name of Tracking Service Here mydomain ps13 ThinPrint __ _stalation and configuration E Login Properties MIDOMAIN ps13 ni x Select apage LS Script Help LAA General AAA SA Server Roles T A TE Mapping Users mapped to this login E Securables Database Default Schema SA Status O master F model m msdb Iv PrintJobT racking MYDOMAIN ps13 El O tempdb DL tptrack 7 Guest account enabled for PrindoBTracking Database role membership for PrintJobT racking Connection db_accessadmin iver db_backupoperator SQLOASQLEXPRESS L db datareader db datawriter Connection db ddladmin db denydatareader 34 Vie
3. CATEGORY Description PRINT JOBS Number of print jobs COSTS Print costs for the number of pages printed by the PAPER CONSUMPTION respective selection group s or users taking into account printer 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 Manage Groups Page 22 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 Cortado AG 2013 ThinPrint Tracking Manual ThinPrint Analyzingtrackingdata c mS fe minnszseess ai racking Dstibuionape FS CS A File Edit View Favorites Tools Help Je fer Dy mh v Page y Safety v Tools v Or ThinPrint Tracking Report Engine Logout Overview Manage Groups 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 i Group All Printer All End Predefined Previous Month v Print Jobs Ranking Users Groups Ranking Printers HP Color Laserjet 47003 152 168 116 1 5 HP Desidet 192 168 116 1 1 Illus 22 Ranking 21
4. MAL EN c s 3 300 b y Letter o 186 12 27 02 2006 ALLE EE c s 3 300 b y Letter o 186 t2 27 02 2006 ALLE Em 300 c v 300 300 b n Letter 0 1872 27 02 2006 ALLL 300 c v 300 300 b n Letter 0 187 7 27 02 2006 ALLE 3 m s 3 300 b n A4 o 1150 il 27 02 2006 1533 ERN 3 m s 3 300 b n A4 o 1150 13 27 02 2006 MAL BE mos 3 300 b y A4 0 1151 il 27 02 2006 ALLE 3 ms 3 300 b y A4 o 1151 il 27 02 2006 ALLE EN 3 m s 3 300 b y A4 o 1152 i 28 02 2006 MAL OBE ms 3 300 b y A4 0 1152 il 28 02 2006 ALLE 3 m s 3 300 b y A4 o 1453 il 28 02 2006 ALLE mg 3 m s 3 300 b y A4 o 1153 il 28 02 2006 MAL m s 600 d n 0 1 2 600 600 A4 1103 1 28 02 2006 ATL E mm gt Id 4 2 of 17702 bl b Illus 30 Microsoft SQL Server Management Studio Express example Data from the ThinPrint Tracking Service If printer drivers and applications in use on the source computer provide certain val ues and the specific version of ThinPrint Engine or Personal Printing also supports 3 Can be downloaded from the Microsoft website for free Page 30 note system requirements 4 The computer creating the print jobs that ThinPrint Engine sends to the ThinPrint Tracking Ser vice inal ThinPrint them the following information can be sent with each print job to the ThinPrint Tracking Service which will write it to the PrintJobTracking SQL database Val ThinPri ma ue Meaning Supported by ThinPrint in the d
5. 30 If you click FIND Now arrow above right groups are displayed Checkmark the desired group and confirm with OK ThinPrint Select Groups i l Select this object type Groups Object Types From this location Entire Director Common Queries Starts with Description Starts with Mame Disabled accounts Hon expiring password Dave since last logon Search results de Domain Users de Enterprise Ad Exchange Do A Exchange Ent de Group Policy ae Gruppe 1 d Helps ervices HX RAS and IAS Ji a Sales Mame RD M All domain users Designated admi Microsoft Excha Microsoft E scha Members in this Group for the He Servers in this Qr A Schema Admins Designated admi In Folder mpdomain com mydomain com mydamain com mydamain com mydomatin com mpdomain com mydomain com mydomain com mpdomain com mydomain com Illus 28 Database PrintJobTracking Analyzing tracking data 2 x Locations Columns Find How Stop Cancel The selected group will be displayed with the included users Costs On the Costs page Illus 29 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
6. Analyzing tracking data ThinPrint 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 above 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 NL Tracking Report Engine Overview Distribution Manage Groups Costs Here vou can see print activity for groups or printers in a specified time interval to survey a trend Category Print Jobs y T3 Group All E Printer All y Paper consumption End Simplex Predefined Current Month E Duplex Color Number of BlackiWite Print Jobs 1 0 2 O 3 0 O 5 O 6 O y i t 10 O S 11 O i 12 D 13 0 3 14 15 O 16 0 17 O 18 O 19 O 20 O 9 11 13 15 W 149 21 231252508 285 21 Day 22 68 23 12 Illus 23 Displaying trends here number of print jobs Manage Groups On the MANAGE GROUPS page Illus 24 you can define user groups to make the pre vious pages easier to read Include each user in one group only to avoid possible cor ruption of the general overviews Users can be arranged or redirected in any groups Note that users will only appear here after they have printed at least once or have been imported from a Active Directory group 22 Manual ThinPrint Tracking ETO 9V OPeulo O Cortado AG 2013 ThinPrint Anal
7. 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 workstation Illus 2 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 v Printer All T Start 6 1 2011 End 6 30 2011 Predefined CarmatMont v Print Jobs Paper Consumption Black White 270 Black White p 42 Color i o 36 Duplex y Illus 2 Analyzing SQL data in a web browser example ThinPrint Tracking Manua O1 Installation and configuration ThinPrint Installation and configuration Technical requirements Your architecture must meet the following requirements for running ThinPrint Track ing m ThinPrint Engine ThinPrint Tracking Service See the ThinPrint Server Engine or ThinPrint Application Server Engine manual or Personal Printing See Personal Printing manual m The SQL server additionally requires Microsoft SQL Server 2005 2008 or 2008 R2 m 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
8. SQL server is not a domain member Installshield Illus 7 Choose Windows authentication mode Here select also a database Illus 7 arrow above on which you wish to install Tracking Database Choose WINDOWS AUTHENTICATION bottom arrow and con firm with NEXT im ThinPrint Tracking Database 8 5 l X Windows Authentication a 3 ThinPrint Specify accounts For Windows authentication d E c Select this object type Groups Object Types From this location mydomain com Locations Enter the object names to select examples Check Names dmins Trackin po lt Back cancel Illus 8 Inherit groups from Active Directory Inst 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 ThinPrint im ThinPrint Tracking Database 8 6 x Windows Authentication 3 Specify accounts For Windows authentication Thi n Pri nt ThinPrint Tracking stores its information in a database Specify two domain groups to access the data and to login to Tracking Report Engine The First account has administrator permissions create modify database The second one is a read only account Tracking database administrator MDOMAIM Tracking dmins Browse Tracking database user My DOMAIN TrackingUsers Browse InstallShield
9. 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 CURRENCY PRINTER NEW PAPER SIZE SAVE SETTINGS DELETE APPLY Description Delete paper format Enter a currency three characters e Select printer or change template default value Define additional paper formats Save cost values for b w and color for the template or the selected printer Apply the same settings for other printers multiple selection with Ctrl and Shift keys Analyzing tracking data Thin Print Qv E ht 192168 16 41 trcking Settingsaspe e BIS Vv le http 192 168 116 141 tracking Settings aspx x 5 Bing dy Favorites 39 8 ThinPrint Tracking Rep X 8 ThinPrint Tracking Report ho E mr Pager Safetyw Toos Or osx vr Logout ThinPrint Tracking Report Engine AA Select the paper sizes below left that are used by the printer shown above Then enter the prices for color and b w printing This template can be used afterwards for all similar printers on the right Currency Template Template Apply this template to E the following printers HP Color erjet Color Lase HP DeskJet 192 168 116 1 1 o io io o o io o io lllus 29 Settings for estimated costs 26 Manual ThinPrint Tracking ETO OV opeuo ThinPrint Appendix Customer service and tech
10. ThinPrint CORTADO s Printing Technology ThinPrint Tracking Print job statistics version 8 6 Manual Cortado AG Alt Moabit 91 a b 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 team cortado com Chatswood NSW 2067 Web www thinprint com Australia Issued August 5 2013 v52 Notes ThinPrint Copyright This document is the intellectual property of Cortado AG 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 Cortado 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 Overview REM 4 THACKING SSI ICS 4 TCE REDOR PV a rai 5 Installation and configuration 0 0 00 rrenen 6 TECNICA Mio le io in O IONS EUDK CNN UR ATUS DES 6 Installation of Tracking Database ococococococonononoconononononononono
11. Tracking Service m ThinPrint Tracking Service receives data and writes it to an SQL database m ThinPrint Tracking Report Engine web component for clear analysis summary and graphic report of tracking results 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 9 Tracking Database Central print server s 0 Server Engine NA Tracking Report Engine T 2x ms m gt ma E A NL gt SQL server EU 5 A Web server Windows Terminal server farm Application Server Engine Illus 1 Example for using ThinPrint Tracking with ThinPrint Engine 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 ThinPrint Engine sends its tracking data to the server that has the tracking service installed Print data which can be analyzed and displayed by Tracking Report Engine Author of a print job user group Printer used Settings used Number of pages printed Information on any errors Costs Compression rates ThinPrint Engine only Print duration Print data during a defined period ThinPringe Overview 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
12. a web browser ThinPrint Tracking Manual iy Analyzing tracking data ThinPrint Overview The page OvERVIEW appears Illus 21 You see the following information for analy S S m Number of print jobs Color and b w grayscales e Simplex and duplex m Paper consumption Color and b w grayscales e Simplex and duplex You can also specify the information as follows Function Description GROUP Choice between a specific or all user groups see Manage Groups Page 22 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 period Cortado AG 2013 ThinPrint ThinPrint Tracking Report Engine Analyzing tracking data pr Logo ut Distribution Trend Manage Groups 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 End 6 30 2011 Print Jobs Group All Predefined Curator Printer All Paper Consumption ThinPrint Tracking Illus 21 Overview of number of printouts and paper usage Manual 19 Analyzing tracking data ThinPrint Distribution The DISTRIBUTION page allows analysis of which users groups or printers have printed the most Illus 22 You can specify the information as follows
13. and x64 Service Pack 2 Windows Server 2008 R2 x64 Service Pack 1 The following is required Microsoft NET Framework version 3 5 SP 1 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 Administrator Administrator permissions are required for all installation and configuration proce permissions dures It is therefore best to log on under Windows as Administrator Installation of Tracking Database Copy Setup exe onto the SQL server and open it with a double click Select the desired language and confirm with OK InstallShield Wizard opens see Illus 3 ThinPrint __stalation and configuration 5 ThinPrint Tracking Database 8 6 xl Welcome to the InstallShield Wizard for ThinPrint Tracking Database 8 6 Thi p The Install5hield R wizard will install the ThinPrint Tracking IN rl nt Database 8 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 5 6 43 E Cancel Illus 3 Start Install Wizard Click NEXT another window opens see Illus 4 2 ThinPrint Tracking Database 8 6 x Database Server Select database server and authentication method Thi ii Pri nt Databa
14. atabase Output Gateway MachineName IP address of the source computer e e g 192 168 131 30 DriverName not currently used DestName Host name of the target computer e g client 22 9 serverName Host name of the source computer e g server 03 9 PrinterName Name of the printer on the source computer e g HP LaserJet 4 client 22 6 ID ID in the SQL database UserName Name of the person who printed Account Orientation Orientation Paper orientation portrait or landscape PaperSize Papersize Paper format e g A4 Letter Executive PaperLength Paper length cm For user defined paper formats PaperWidth Paper width cm otherwise value O Copies Number of copies Qo DefaultSource Default paper source o PrintQuality Printout quality maximum value of XRes and YRes e g 600 dpi or quality level e g fine Color Color or grayscale b w Duplex Double sided or single sided duplex or simplex O XRes Horizontal resolution dpi YRes Vertical resolution dpi TTOption TTOption Load TrueType fonts embedded in the file as e bitmap as soft font or outline or information about what printer font is to be replaced dmCollate Sorting option e g print longer documents consecu depending on the appli tively cation FormName Name of the paper format e JobSize not currently used Appendix Value Supported by ThinPrint Meaning in the database Output Gateway JobTSize not currently used JobID Print job ID e Status Va
15. er 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 Mus 15 lower arrow Confirm with Next Another window opens see Illus 16 5 ThinPrint Tracking Report Engine 8 6 x Database Authentication Specify authentication mode Thi ii Pri nt Select authentication that Tracking Report Engine will use to connect to the Tracking database Windows authentication SOL server authentication InstallShield E Cancel Illus 16 Choose authentication mode Here select the authentication mode with which Tracking Report Engine estab lishes a connection to Tracking Database Confirm with NEXT and close InstallShield Wizard with FINISH ThinPrint __ _stalation and configuration Personal Printing The settings for Tracking are described in the Personal Printing manual Page 29 ThinPrint Engine Installation Please consult the ThinPrint Engine user manual for installation information Page 29 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 E
16. ficates Symmetric Keys ale Lj Server Objects Replication Management Illus 10 Database PrintJobTracking When you install Tracking database with SQL authentication a user account will be created with read permissions on the database This name of the user account will be TRACKINGUSER and the password is THINPRINT 1 Er SQL Server Configuration Manager Datei Aktion Ansicht amp Protocol Mame Status 5j Shared Memory Enabled Y Named Pipes Enabled SOLE WE TCPITP Enabled B 3 SOL Native Client pa Fra Disabled Illus 11 Enable protocols To access the SQL server remotely open SQL Server Manager and enable the proto cols NAMED PIPES and TCP IP Illus 11 Then start the SQL SERVER BROWSER in the services folder Installation and configuration ThinPrint E Microsoft SOL Server Management Studio Express E n x File Edit View Tools Window Community Help Quro DISA d B 3 PR Bs Object Explorer 3 3 m j Y f SOLOFISOLEXPRESS SQL Server 9 0 1399 sa Ca Databases de SQLO7 SQLEXPRESS LO Server Objects SQLOFISQLEXPRESS 5 Item s C3 Replication Management E E E E Illus 12 Install access for Tracking Service on the SQL server To ensure the Tracking Service gets access to the SQL server only in case of Windows authentication open Management Studio Express Illus 12 and enter with a right click in the FOLDER SECURITY on NEW and LOGIN A new window opens Illus 13
17. ing vill alter security policy re you sure vou want to perform this operation Cyes no gt es dded union code group with allcode membership condition to the Machine level uccess temp gt El Illus 25 Run caspol exe 2 Code Access Security Policy Tool ThinPrint Tracking Manual 23 Analyzing tracking data ThinPrint ca Eingabeaufforderung 10 x temp gt caspol m ag fill Code allcode FullTrust n ThinPrint icrosoft XR NET Framework CasPol 2 8 50727 4927 opyright lt c gt Microsoft Corporation All rights reserved he operation you are performing will alter security policy re you sure you want to perform this operation Cyes no gt es dded union code group with allcode membership condition to the Machine level uccess temp gt E Illus 26 Run Caspol script successfully If you import a new group from Active Directory You can also import users which have not yet printed To do so click the button IMPORT GROUP FROM ACTIVE DIRECTORY SEE Illus 28 arrow Another window opens see Illus 27 Click ADVANCED then choose the desired group from the Active Directory arrow in Illus 28 Select this object type Groups Object Types From this location Entire Directory Locations Enter the object names to select examples Check Names Advanced J Cancel Illus 27 Choose database and authentication mode Another window opens see Illus
18. lues G 1 Print job delivered 2 Successfully printed 3 Print job cancelled ClientID not currently used Pages Number of printed pages o TStamp Time of print job start of communication between 9 ThinPrint Engine and ThinPrint Tracking Service Duration Duration of the printout ms e DevMode device mode Data as blob binary large object PrintType Format of print data o values m EMF r RAW CompressionRate compression rate of the print job divides the value O jobTsize by value jobsize With ThinPrint Engine only DocumentName name of the document 9 Additional sources Further information about ThinPrint can be downloaded from our website Manuals The following manuals amongst others are available at www thinprint com gt PRODUCTS OVERVIEW product name gt m ThinPrint Application Server Engine m ThinPrint Server Engine m Personal Printing Current program m Download the ThinPrint Engine www thinprint com gt PRODUCTS versions gt OVERVIEW product name DEMO VERSION Update X f your software is more than one year old you also require a current license key for subscriptions product updates This key can be purchased inexpensively as a so called update sub scription For more information contact your dealer or info thinprint com Appendix ThinPrint Microsoft website Management software for SQL servers Microsoft SQL Server Management Studio Express can be downloaded for free at www microsof
19. narannnnnonononnnnnnnnrnrnnnnnnnnnnsnnnnss 6 nde 8 Installation of Tracking Report Engine on the webserver ccececeeeeeeeteeeeeteeeteeeeeeeeetensees 13 Ee PIDE E E A A E EA E Ge A 15 PPP 15 MSI ON 15 Preparing ThinPrint Engine and Tracking Service occocccccococococoneneconenonononenenonenenonononono 15 Analyzing tracking data sss 17 ThinPrint Tracking Report Engine static 17 A o ro A 18 Wage oa 20 Uo A 22 aE TOU re cocoa A 22 vl OmOEEE 25 Appendix aeee aeee 27 Customer service and technical support errar eres emere 27 SQL server management LOOIS siii ici triana 27 CNC eee eee eee ee eer ter eee re eet ener ee E 2 Data from the ThinPrint Tracking Service occocccococococonenenecenonononononononononononononenenenenonono 27 Additional SOUrCES AA 29 ADDreviatONS standard 30 overview ThinPrint Overview Print job tracking gathers information about print activities using ThinPrint Engine or Personal Printing With it print related data is gathered on the server and forwarded to an SQL database Illus 1 Print job tracking has the following components m ThinPrint Engine or Personal Printing sends data to the ThinPrint
20. ngine 1 Open configuration with START ALL PROGRAMS THINPRINT ENGINE CON FIGURATION 2 Mark the respective THINPRINT ENGINE node Illus 17 and select EDIT SETTINGS print Engine d 10 x File Action View Help gt g 23 print Engine P513 8 ThinPrint print Engine P513 El 4 AutoConnect The following table shows all events generated by print components which will also appear in the Windows Event Viewer Additionally you can V Layer Lae display the print spooler events here this can be enabled in the dialogue at the bottom There also the Tracking Service can be selected In the Dos Port Manager pm second table you ll find all services used by print components A Licenses Name Service Startup Type LF Print Spooler Spooler Running Auto CE TP AutoConnect Service TPAutoConnSvc Running Auto LE TP Tracking Service TPTrackSwc Running Auto Description ThinPrint print component that stores print job information in a database Server Settings Spooler Events Not supported for Windows Server 2008 R2 Log spooler error events Log spooler warning events Log spooler information events Tracking Status on Database Server SQLO SQLEXPRESS Database PrintJobT racking Illus 17 Selecting TRACKING SETTINGS b Start Service id Stop Service IP Restart Service EM Edit Settings 3h Send Configuration amp Refresh all Installation and config
21. nical support Customer Service Appendix www thinprint com gt SUPPORT www thinprint com Support 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 30 E Microsoft SQL Server Management Studio Express Of x File Edit View Query Designer T New Query Li Ge d g Ba 3 EA Nw e sx E change Type gt sou fm 3 8 Object Explorer E EE E E EE E E EE EE EE AAAA Ready L HS server 02 SQL Server 8 0 760 sa E Databases LY System Databases E uj TPTrack Database Diagrams E Tables System Tables C dbo TPBConfig E dbo TPBCosts C dbo TPBCurrencies C dbo TPBDestName C dbo TPBDriverName C dbo TPBGroupName 3 dbo TPBGroups dbo TPBLogEntry 3 dbo TPBMachineName 3 dbo TPBPaperSize C dbo TPBPrinterName C dbo TPBServerName C dbo TPBUserName Views Tools Window Help server 02 TPTr 5QLQuery1 sql Table dbo TPBLogEntry Summary X PrintQuality Color Duplex XRes YRes TTOption dmCollate FormName JobSize JobID Pages TStamp Duration n 600 c s 600 300 b y Letter o 1149 13 27 02 2006
22. se server where vou want to create an SQL database SQLD7TSQLESPRESS Browse Connect using Windows authentication credentials of current user M SOL server authentication using the login and password below Login sa Password ETT InstallShield lt Back Cancel Illus 4 Choose Database server and authentication to SQL server 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 m Windows authentication or m SQL server authentication Confirm with NEXT Another windows opens Illus 5 Installation and configuration Thin Print im ThinPrint Tracking Database 8 6 i X Database Authentication y E ThinPrint Specify database name and authentication mode Database name fPrintJobTracking Browse Database authentication mode C Windows authentication f SOL server authentication recommended Select SOL server authentication iF your SQL server is not a domain member InstallShield i Cancel Illus 5 Choose database server and Authentication mode Choose a name for the database in which the information about print jobs will be Stored PRINTJOBTRACKING for example Illus 5 top arrow Authentication mode Authentication mode Illus 5 lower arrow defines how the users and Tracking Ser vice access the stored print data via Tracking Repor
23. t Engine SQL server Create an account with administration permissions Illus 6 TRACKINGSERVICE Authentication for example Note the user name and password Confirm with NEXT and close InstallShield Wizard with FINISH 2 ThinPrint Tracking Database 8 6 X SOL Server Authentication y 3 ThinPrint Specify an SOL account For this database ThinPrinE Tracking stores its information in a database To access the data it is necessary bo 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 eme sis IF vau wish to create a new account make sure that the password is complex enough to meet the Windows policy requirements Installshield Illus 6 Create administrator account for the Database ThinPrint Installationand configuration Windows If you choose Windows Authentication Illus 7 all users and servers need to be authentication members of the same domain Users can log on with their user name and their domain password 5 ThinPrint Tracking Database 8 6 x Database Authentication E ThinPrint Specify database name and authentication mode Database name PrintJobTracking A Browse Database authentication mode Windows authentication SOL server authentication recommended Select SOL server authentication iF your
24. t Refresh 7 7 2011 12 50 57 PM Illus 19 Print job tracking enabled Cortado AG 2013 ThinPrint Analyzingtrackingdata For information about preparing Tracking on a print server cluster see the Microsoft Failover Clusters and ThinPrint white paper Page 29 Analyzing tracking data ThinPrint Tracking Report Engine 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 ps13 tracking Enterthe account created on the SQL server here TRACKINGSERVICE which has write permissions for the database PRINTJOBTRACKING Illus 20 Confirm with OK E ThinPrint Tracking Report Engine Microsoft Internet Explorer Datei Bearbeiten Ansicht Favoriten Extras O ar O x 2 fn suchen 5 gt Favoriten 4 dr a m Adresse http ffps1 tracking Wechseln zu Links Y a ThinPrint Tracking Report Engine ThinPrint User TrackingService Feto DT E menet d Illus 20 Open the Tracking Report Engine in
25. t com downloads details aspx Fami lyld C243A5AE A4BDI1 A4E3D 94B8 5AOF62BF7796 amp displaylang en Abbreviations ASP Active Server Pages DLL Dynamic Link Library dpi dots per inch EMF Enhanced Metafile ID Identification number HS Internet Information Service MMC Microsoft Management Console Output Gateway ThinPrint Output Gateway SQL Structured Query Language
26. uration ThinPrint 3 Enter the following settings in the TRACKING tab Illus 18 ENABLE TRACKING SQL server s address and name SQL server Windows authentication an account or the which has write per missions for the installed database PRINTJOBTRACKING e Encryption settings if the data are to sent encrypted to the SQL server e Name of the Tracking database PrintJobTracking Click OK to confirm The Result is shown in Illus 19 Server Properties x Tracking V Enable Tracking Enter information to store the print Tracking data into a Microsoft SQL database Choose SQL server and database name as well as authentication and encryption settings to connect Select or enter an SOL server name SQLOASQLEXPRESS y Refresh Log on to the server C Use Windows Authentication Use SQL Server Authentication User name ss i Password mmm SQL server connection settings Use encryption TCP port Trust server certification Select or enter a database name PrintJobT racking lt ss Cancel Search Cancel Apply Illus 18 Enable Tracking and enter settings Server Settings Y Edit Settings Spooler Events Not supported for Windows Server 2008 R2 gf Send Configuration Log spooler error events a Refresh All Log spooler warning events Log spooler information events Tracking Status on Database Server SQLO 7 SGLEXPRESS 4 Database PrintJobT racking Las
27. w connection properties db denydatawriter db owner db securityadmin v public Read Zz me TM TREUser OK E DX cs Illus 14 User mapping Put a checkmark at the database which is configured for Tracking here PRINTJOB TRACKING arrow above in Illus 14 and a checkmark at TREADMIN lower arrow in Illus 14 Then Tracking Service can access the database with Windows authentication 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 with a double click Select the desired language and confirm with OK InstallShield Wizard opens Installation and configuration ThinPrint im ThinPrint Tracking Report Engine 8 6 x Database Server Select database server authentication method and database Thi 1 Pri nt Database server that you are connecting to SQL ZTSOLESPRESS d Browse Connect using Windows authentication credentials of current user f SOL Server authentication using the login and password below 4 Login Tracking5ervice Password PEET Database name PrintJobTracking GG Browse InstallShield E Cancel Illus 15 Choose database and authentication mode Select the database serv
28. yzingtrackingdata ThinPrint Tracking Report Engine 2 tum Trena 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 y o Available MY DOMAINtadministrator MYDOMAINwser3 2 Creating a new group i Import a group from Active Directory Illus 24 Defining user groups If the Tracking Report Engine runs remotely and you wish to import groups from Active Directory it is necessary to run the Tracking Report Engine in Internet Explorer Additionally you have to run the CASPOL script on the command line on the local computer see Illus 25 and 26 m install CASPOL EXE component of NET Framework m run caspol m ag All Code allcode FullTrust n ThinPrint c Eingabeaufforderung temp gt dir Volume in Laufwerk C hat keine Bezeichnung Uolumeseriennummer F8C9 9E11 Verzeichnis von c temp 6 29 2611 11 16 AM lt DIR gt 6 29 2011 11 16 AM lt DIR gt 6 29 2011 16 51 AM 57 caspol kommandozeile txt 6 10 2009 11 22 PM 166 496 CasPol 2 Dateilen gt 106 553 Bytes 2 Verzeichnistse gt 96 342 616 Bytes frei temp gt caspol m ag fill Code allcode FullTrust n ThinPrint icrosoft lt R gt NET Framework CasPol 2 8 50727 4927 opyright c gt Microsoft Corporation All rights reserved he operation you are perform
Download Pdf Manuals
Related Search