Home

User's Guide PLCS Reporter

1. O O_ _ AAA The operation completed successfully but some files were not processed There were no other errors or warnings This return code is very common Files are not processed for various reasons The most common reasons are e The file is in an exclude list e The file was in use by another application and could not be accessed e The file changed during the operation to an extent prohibited by the copy serialization attribute The operation completed with at least one warning message Review dsmerror log and dsmsched log for scheduled Copyright O 2014 87 Reporter C E and to assess their impact A The operation completed with at least one error message except for error messages for skipped files For scheduled events the status will be Failed Review the dsmerror log file and dsmsched log file for scheduled events to determine what error messages were issued and to assess their impact As a general rule this retum code means that the error was severe enough to prevent the successful completion of the operation For scheduled operations where the scheduled action is COMMAND the return code will be the return code from the command that was executed If the return code is 0 the status of the scheduled operation will be Completed If the return code is nonzero then the status will be Failed 88 Copyright O 2014 Reporter GUI 6 5 2 Menus The only menu item on the ribbon can b
2. z File Tools Help Number 0 1 2 TSMSERVER TSM Server Name General Configuration Logging Database Scheduler Schedules Operational VM Settings wmi Settings TSM Server Config MCESERVER Server Number TSM server name Database Name Last time run Status License Key Eqpires TSM Server Address 1 TSMSERVER 192 168 250 3 1500 TSMPLCS 29 May 2010 16 03 A No current log file available 02 February 2020 Configuration Manager with general tab selected In this tab the following information is available Reporter server number TSM server name TSM server address MSSQL Database name Last Collector Agent run Status indicates status of the collector Agent last log License key expiration date A A newly configured TSM server connection is by default scheduled for data collection in the Schedules tab To disable the TSM server data collection select the Schedules tab then the database name and select right mouse menu Inactive then click Apply 54 Copyright 2014 Application Components 5 2 3 2 Configuration Tab The second tab in the Configuration Manager is the Configuration tab This tab allows you to configure and validate the TSM server connection Select the TSM server instance you would like to configure from the list on the left The connection number 0 Reporter cannot be selected with this tab File Tools Help
3. x in ver do set cmdver x set cmdver cmdver Version call parse cmdver call ver scmdver call Report goto End clean Ensure we don t inherit values from previous runs set _verCmd set _verMajor set _verMinor set _verBuild set _verWin goto eof Parse_cmdver Turn 5 1 2306 string into actionable variables for f tokens 1 2 3 delims g in Scmdver S do set major g set minor h set build i goto eof Report goto eof Report2 26 Copyright 2014 Installing set _ver goto eof ver6 1 7600 ver6 1 7601 set longver Windows 7 or Windows Server 2008 R2 set shortver Win7 Server2008R2 if Sshortver S NEQ Win7 Server2008R2 goto End REM Set Powershell for RemoteSigned c Windows System32 WindowsPowerShell vl 0 powershell exe Set ExecutionPolicy RemoteSigned REM Open firewall port 1433 set tempfile S dp0temp psl ho Sport New Object ComObject HNetCfg FWOpenPort gt temp psl ho Sport Port 1433 gt gt temp psl ho Sport Name MSSOQL Port 1433 gt gt temp psl ho port Enabled true gt gt temp psl ho SfwMgr New Object ComObject HNetCfg FwMgr gt gt temp psl ho profile fwMgr LocalPolicy CurrentProfile gt gt temp psl ho Sprofile GloballyOpenPorts Add Sport gt gt temp psl Windows System32 WindowsPowerShell vl 0 powershell exe tempfile Add NET framework 3 5 ho Import Module ServerManager gt temp psl ho Add Wi
4. M1NN941N_ ACCENT CEDVCDA MING 12 03 2010 08 53 21 Starting Agent version 2 5 0 1 12 03 2010 08 53 21 Reading server1 configuration from registry 12 03 2010 08 53 21 Start processing server server 12 03 2010 08 53 21 MSSQL database name TSMPLCS 12 03 2010 08 53 36 Connecting to address tsmserver ples nl 1500 12 03 2010 08 53 38 TSM server version 5 5 3 0 12 03 2010 08 53 38 Checking TSM server 12 03 2010 08 53 41 TSM server name TSMSERVER 12 03 2010 08 53 41 TSM server install date 24 05 2002 13 53 40 12 03 2010 08 53 41 TSM server restart date 03 03 2010 03 15 24 12 03 2010 08 53 41 Restart date is the same as in database 12 03 2010 08 53 41 Skipping actlog messages with text REPORTER 12 03 2010 08 53 41 Dropping table COLUMNS 12 03 2010 08 53 41 Creating table COLUMNS 12 03 2010 08 53 42 Inserting records COLUMNS 12 03 2010 08 53 48 Records inserted COLUMNS 860 12 03 2010 08 53 48 Validating tables 12 03 2010 08 53 50 Creating table LICENSES 12 03 2010 08 53 51 Validation done 12 03 2010 08 53 53 Starting record insertion 12 03 2010 08 53 53 Inserting records ACTLOG Configuration Manager with logging tab selected Information shown in the logs is related to the TSM connection and the ODBC database driver The log contains information about failures errors amount of records inserted database creation etc Please refer to Troubleshooting section when errors occur Copyright 2014
5. You may change the default installation path of PLCS Reporter click Next to continue the install 40 Copyright O 2014 Installing Select Start Menu Folder Where should Setup place the program s shortcuts A Setup will create the program s shortcuts in the following Start Menu folder To continue click Next If you would like to select a different folder click Browse PLCS Reporter Browse You may change the default start menu shortcut folder of PLCS Reporter click Next to continue the install Ready to Install Setup is now ready to begin installing PLCS Reporter on your computer Click Install to continue with the installation or click Back if you want to review or change any settings Destination location C Program Files PLCS Reporter Start Menu folder PLCS Reporter Last dialog before installation starts click Install to start the installation Next step is to Configure the Installation Copyright 2014 41 Reporter 4 4 Configure The next step in installing PLCS Reporter is configuring a TSM server connection The Configuration Manager has automatically started If this is not the case start the Configuration Manager from the Windows start menu under Start Menu All Programs PLCS Reporter Configuration Manager Select the Database Tab in the Configuration Manager and verify the configuration of the database settings a Test connection is available click Apply after a successf
6. Account Index Description XML file path Sample WMI settings tab There are three ways of getting WMI information from Windows clients IP address which does a scan of that IP address only information of a Windows system will be retrieved o IP range with a starting and ending address where all clients in that range are scanned only information of a Windows system will be retrieved e All nodes TCP IP addresses backing up to the TSM server Copyright 2014 63 Reporter Steps for adding WMI configurations 1 First add accounts credentials Type in a domain name user name and password Click Add If this is the default choose the account and then click Set Default Accounts Domain Name Index Doman User Name Default 1 PLCSEU Administrator YES User Name Password Set Default Add Remove 2 Next add a address range Select one of the following IP Address IP Range or All TSM client node IP addresses Choose the account index to be used which was added in step 1 M Address Ranges Type jiP Address y IP Ade Start Address End Address Descriptio 1 0 0 0 0 All TSM C IP Address IPR anae TSM Node IP Addresses Account Index ad Description Add Remove The WMI scan is scheduled from the Schedules tab the type named OTHER with database name VM_WMI This process is by default scheduled for the first S
7. Node Collocation Node Collocation allows you to easily create collocation groups and script 9 History Report History allows you to view previously generated reports Copyright O 2014 71 Reporter 72 View Ribbon Groups The View ribbon groups of PLCS Reporter are the Database Tools and Configuration groups ES View Ribbon with Tools Configuration and Database groups The View item buttons have the following functions available O Database Select opens sidebar select database if hidden gt Database Browse opens a window that allows you to browse the local TSM database copy O Tools Activity Log opens a window with the TSM activity log Tools Command Line opens a window with a smart TSM command line Servers Grouping opens a dialog that allows you to create TSM servers groups In Reporter o Nodes Grouping opens a dialog that allows you to create TSM node groups On the TSM server O Configuration Settings opens a window that allows you to configure PLCS Reporter program settings Action Ribbon Groups The Action ribbon groups of PLCS Reporter are the Output Filter and Window groups The Output group with its output function can be used with almost all the presentation windows like Report Viewer and Node Performance SA Report View Action Help Juas Js aS E ta la ab RFE Save XI Save CSV Save JPG Save HT Set Clear Close CloseA X v J H S c o A Action Ribbon with Output Filt
8. A simple workaround on a given PC Start regedit program and browse to registry key HKEY_LOCAL_MACHINE SOFT WARE Microsoft Cry ptography Defaults Provider Find its subkey named Microsoft Enhanced RSA and AES Cryptographic Provider Prototype export it to a reg file edit the reg file with e g notepad and remove Prototype from its name Then import it back into the registry the original key will be duplicated to the new key without the Prototype text with the same contents SHA256CryptoServiceProvider should now work on Windows XP SP3 machines Copyright 2014 19 Reporter 20 Important note for Windows 2003 and WMI Error when running ClientAgent exe WMI in Win32_ Product Error message when you query the Win32_Product class after you install applications by using Microsoft Windows Installer MSI 4 5 together with the Per User option in Windows Server 2003 and in Windows XP 0x80041001 Generic failure Considering the following scenario You install Microsoft Windows Installer MSI 4 5 on a computer that is running Windows Server 2003 Service Pack 2 SP2 or that is running a 64 bit version of Windows XP Professional Service Pack 2 SP2 You install multiple applications by using MSI together with the Per User option For example you run the following command to install a MSI package named application msi MSlexec exe i application msi ALLUSERS In this scenario when you run a Windows Man
9. VMWare 150 VMWare SDK Toolkit 62 Volume Report 117 W Welcome Page 7 Windows Management Instrumentation 147 WMI 147 155
10. View Action Help MEA Enterprise Assets Asset Info PLCS_SEOpens a new windows that allows you to configure and use the best cost model for allocating charges in a TSM environment 168 249 1 Intel Xeon CPU E5410 2 33GHz picsvm01 plcs nl 168 249 1 Intel Xeon CPU E5410 2 33GHz picsvm01 ples nl 168 250 1 Intel Xeon CPU E5410 2 33GHz plesvm01 ples nl 168 250 166 Intel Xeon CPU E5410 2 33GHz plesvm02 ples nl 168 250 12 Intel Xeon CPU E5410 2 33GHz picsvm01 plos nl 168 250 35 Intel Xeon CPU E5410 2 33GHz No 168 248 1 Intel Xeon CPU E5410 2 33GHz 168 200 2 Unknown no WMI or VM data collected l Current TSM server name TSMSERVER and MS SQL database name TSMPLCS Last record in activity log 07 45 01 on 16 March 2010 Sample Asset window with processor CPU Core and PVU information Notes e In case there is no processor information the Client Agent might not have run yet It is scheduled for the first Saturday after installation of PLCS Reporter e The Client Agent can also be manually started refer to section Client Agent e Processor information might be missing because of failure to communicate with the client Please refer to section WMI information 6 4 1 Asset and File Spaces Enterprise Asset File Spaces on the ribbon under the Report tab Enterprise section opens a window with file space asset information of a group
11. 0 1 TSM Server Name TSMSERVER et cota a Dann Schedules Operational VM Settings WMI Settings Status Ca Running Stat Stop Update Log Time 14 03 2010 12 50 25 14 03 2010 12 55 42 14 03 2010 12 55 42 14 03 2010 12 55 58 15 03 2010 08 30 38 15 03 2010 08 30 52 15 03 2010 09 00 38 15 03 2010 09 08 28 15 03 2010 10 00 40 15 03 2010 10 00 58 16 03 2010 08 41 00 16 03 2010 08 42 00 16 03 2010 09 00 38 16 03 2010 09 03 44 16 03 2010 10 00 38 16 03 2010 10 00 52 Message Executing job number 4 AgentC exe m Job 4 has run successful Executing job number 5 ReporterCmd exe database TSMPLCS html mailto robert Job 5 has run successful Executing job number 1 AgentC exe k server 4 Job 1 has run successful Executing job number 4 AgentC exe m Job 4 has run successful Executing job number 5 ReporterCmd exe database TSMPLCS html mailto robert Job 5 has run successful Executing job number 1 AgentC exe k serverl 4 Job 1 has run successful Executing job number 2 AgentC exe m Job 2 has run successful Executing job number 3 ReporterCmd exe database TSMPLCS html mailto robert __ Job 3 has run successful l Configuration Manager with scheduler tab selected The buttons on the Scheduler tab page allow you to Copyright 2014 Start is disabled when the service is running start the Scheduler service Stop is di
12. 28 plesk01 c TSM Match WMI TSMSERVER PLCSDEV 192 168 250 166 25 08 2010 08 00 eporterdev c lc lc TSM Match WMI TSMSERVER PLCSOO p 192 168 250 3 24 08 2010 20 00 picsO0 fS F TSMSERVER PLCSOO 192 168 250 3 24 08 2010 20 00 pics00 e ell fecal i y le TSMSERVER PLOSOO s00 192 168 250 3 24 08 2010 20 00 plcs00 ds TSM Match WMI TSMSERVER PLCSOO 192 168 250 3 24 08 2010 20 00 plcs00 c TSM No WMI TSMSERVER AVG S01 192 168 200 2 25 08 2010 07 34 avg s01 d TOM Ma MAAM TCMCCOVCDO Aun Cnt 4107 1c0 NN gt LEIDO FINAN NF IA Wan ate 4 Current TSM server name TSMSERVER and MS SQL database name TSMPLCS Last record in activity log 10 29 42 on 26 August 2010 Sample File Space asset match using WMI TSM File Spaces and VMware server information Notes e API client nodes are not matched because file spaces cannot be matched to a local drive e File spaces can only be matched if the Client Agent has run performing the WMI or VM scan e In case file space asset detects a local drive with out a TSM file space it is marked in status as No TSM File space verify the TSM domain statement in a client option file whether it reflects the correct number of disks to be backed up or use the all local option Copyright 2014 83 Reporter 6 5 Timeline The Timeline window gives you a graphical overview in time of all TSM activity e g processes drive tape mounts a
13. 57 Reporter 5 2 3 4 Database Tab The last and fifth tab page configures the database connection and local backup The information in the Settings group allows you to configure the database connection information Server address database server address note use the TCP IP address or DNS name of the database server TCP IP port number database server communication port SQL port is automatically read from registry if available o User name SQL user name defined by user a Password After changing database connection settings click on the Test button In case the connection verifies successfully click Apply File Tools Help Nurser iTSM Server Name General Configuration Logging Scheduler Schedules Operational VM Settings wmi Settings 0 Settings 1 TSMSERVER Server address localhost TCP IP port number 1433 User Name sa Password Configuration Manager with database tab selected Making a regular database backups of the database is recommended To backup a MS SOL databases use Microsoft SQL Server Management Studio Express The TSM TDP for Mail client does not support MS SQL Express 58 Copyright 2014 Application Components 5 2 3 5 Scheduler Tab The next tab in the Configuration Manager is the Scheduler tab This tab page is a management page for the Scheduler service one Scheduler service is installed for all TSM instances File Tools Help Number
14. Ci number 293 OFFSITE RECLAMATION COPYPOOLO2 e RECLAMATION TAPEPOOLO1 1 J E E eee RECLAMATION TAPEPOOLO2 i i i i STGPOOL BACKUP DISKPOOLO01 gt COPYPOOLO1 H F STGPOOL BACKUP DISKPOOLO2 gt COPYPOOLO2 iY a me 0203 2010 aasa DISKPOOLO3 gt COPYPOOLO2 T T End time 02 03 2010 15 57 13 DISKPOOLO4 gt COPYPOOLOT i ii j 1 Duration 03 23 19 TAPEPOOLO1 gt COPYPOOLO1 STGPOOL BACKUP TAPEPOOLO2 gt COPYPOOLO2_ a i Data 54 38 GBytes Transfer rate 15 14 MBytes sec Examined 80 969 mee Affected 80 969 Total media wait 02 22 00 01 03 17 00 21 00 1 17 00 21 00 1 00 DRIVE1 MT3 1 0 0 0 EE lll e DRIVE2 MT3 2 0 0 DRIVE3 MT2 2 0 0 DRIVES MT3 4 0 0 DRIVES MT3 5 0 0 Current TSM server name TSM_BACKUP and MS SQL database name BACKUP Last record in activity log 16 49 31 on 03 March 2010 Timeline window with process information popup 84 Copyright 2014 Reporter GUI 6 5 1 Timeline View To change the date select the calendar drop down on the top left of the window and select a date The graph will update to that date Timeline View TSM_BACKUP Date 03 March 2010 Br Past day s 2 2 V Processes V Mounts Clients V Synced Zoom Show Active amp Missed Save View Timeline window options Viewing multiple days use the Past days and press the up down to increase decrease the amount of days on the screen you can view
15. Private Reading XML resource Microsoft SqlServer Configuration Cluster ClusterNodesStat usPublicConf ig xml Microsoft SqlServer Conf iguration Cluster ClusterNodesStatusPublicConf loaded into datastore path Datastore ProductSettings ClusterNodesStatu LoadPackageDatastoreO0bjects returned True Running Action InitializelnputSettingStore In the console you see what actions are taking place in the installation process The GUI of MS SQL will popup and it shows the graphical installation fase Copyright O 2014 31 Reporter ver 2008 181 Installation Progress Installation Progress Performing Windows Installer actions Install_sql_engine_core_shared_Cpu32_Action RemoveSupportFiles_32 Removing temporary files Target packag 1e39566b bd bhaf 2662317192311 7 x86 setup sq1_common_core_locf _msi 1633 sql_common_core_loc msi InstallPackage MsilnstallProduct returned the result code RunMsiCore succeeded Checkpoint INSTALL_SQL_COMMON_CORE_LOC_CPU32_1633_ACTION Completed Action Install_sql re_loc_Cpu32_1833_fAction returned True Install_sqincli_Cpu32_fAction Target packag coc 1e39566b3 bd bhaf 2662317192311 7 x86 setup x86 sqincli msi InstallPackage MsilnstallProduct returned the result code B RunMsiCore succeeded Checkpoint INSTALL_SQLNCLI_CPU32_ACTION Completed Action Install_sqincli_ Install_Msxml16_Cpu3 Target packag c 1e39566b3hbhd9 bhaf 2662317192311 7 x86 setup x86 msx
16. SQL manually before installing PLCS Reporter A On the Windows system where you wish to install PLCS Reporter you need Administrative rights Start the installer on the system where you wish to install To start the installation double click or run the install executable from a Windows Command line Welcome to the PLCS Reporter Setup Wizard This will install PLCS Reporter on your computer lt is recommended that you close all other applications before continuing Click Next to continue or Cancel to exit Setup Select Next to continue installation Copyright 2014 39 Reporter Please read the following important information before continuing Please read the following License Agreement You must accept the terms of this agreement before continuing with the installation End User License Agreement EULA amp End User Maintenance Agreement gt do not accept the agreement Carefully read the terms and conditions of this agreement i EULA and EUMA before installing this software Installing this software indicates your acceptance of these terms and conditions Click Next to continue the installation Select Destination Location Where should PLCS Reporter be installed A Setup wil install PLCS Reporter into the following folder To continue click Next f you would like to select a different folder click Browse Browse At least 46 6 MB of free disk space is required
17. Server In case you are using Microsoft SQL Server you need to install it manually First download the package from the Microsoft website http www microsoft com sqlserver en us editions express aspx Then install SQL Server and SQL Server Management Studio Express on the system When installation is completed and your SQL Server is running start SQL Server Management Studio Logon with the default account Click with right mouse on the root of the tree on the left and select properties Select the security page Change Server Authentication to SQL Server and Windows Authentication mode Click OK Then open on the tree the Security branch Right mouse click the Login branch and choose New Login Fill in a Login name e g reporter Select SQL Server authentication and type in a password Remove User must change password at next login Select Server Roles page Tag the sysadmin server role Then click OK Close SQL Server Management Studio Restart the SQL Server engine Connecting to MSSQL Start the Configuration Manager and select the Database tab then click test If you receive the following error message 136 Copyright 2014 Troubleshooting o Cannot connect Error A network related or instance specific error occurred while establishing a connection to SQL Server The server was not found or was not accessible Verify that the instance name is correct and that SQL Server is configured to allow remote connectio
18. e5bd232bf54bf0d051 dad93faS Microsoft Windows x Please wait while Setup configures the components This might take several minutes The installer unpacks the files and installs NET framework This might take a while up to 30 minutes Copyright O 2014 29 Reporter Software Update Installation Wizard Updating Your System Ay a Please wait while setup inspects your current configuration archives your current files and updates your files Inspecting your current configuration Details Inspecting Windows installer is installed when it is not present on the system Checking system Microsoft NET Framework version 3 5 SP1 is not installed Installing Microsoft NET Framework version 3 5 SP Windows versio 5 2 3790 32 bit installed Windows platform Installing Windows Installer 4 5 Redistributable After all prerequisites are installed the installer asks to reboot the system To perform the reboot click Yes E You must reboot this machine First reboot now After the reboot manually restart setup cmd to continue installation 30 Copyright O 2014 Installing When setup is executed it verifies and shows the packages that have been installed earlier Checking system Microsoft NET Framework version 3 5 SP1 is already installed Windows version 2663 Windows OS version 5 2 3790 Windows platform 32 bit Powershell is already installed Windows version 26
19. hour Network Data Transfer Rate in Copyright O 2014 Reporter GUI Node Perform TSMSERVER Node_Name Start_Time MENTREX01 16 03 2010 00 00 16 03 2010 00 34 0 33 46 aseqeieq pl 16 03 2010 20 01 16 03 2010 20 09 0 8 9 16 03 2010 20 19 17 03 2010 01 02 4 42 23 15274676760 16 03 2010 20 30 16 03 2010 22 49 2 19 18 1 49GB 1601631187 187 1 PLCSK01_EXCH AVG S01 16 03 2010 22 06 Sample of the Node Performance window 16 03 2010 21 14 16 03 2010 21 16 0 2 0 147 03 MB 154167498 1254 6 16 03 2010 22 39 0 32 57 97 51 MB 102245196 50 5 6 7 1 Menus The Node Performance window has a context menu on the data grid 2010 01 02 2010 22 49 2 19 18 4 Day Select Hide Column 2010 21 16 0 2 Show All Columns Filter 97 51 MB Node Performance context menu Click on the right mouse button and the context menu opens with the following menu items o Day Select by default last 24 hours are shown Hide Column hides the column under the mouse pointer Show All Columns shows all hidden columns Filter Set Reset sets or resets a filter put on the data grid Menu item Day Select will show you a dialog in which you can select a date range Change the date by clicking on the small calendar Then click OK to update the data Copyright O 2014 93 Reporter grid Dependent on the selected range and amount of n
20. on the plus minus signs Right mouse click anywhere on the context menu to Expand Collapse the whole tree V Summary Operational Stat Trending Y Summary Related Trending Y Config Logging Trending Config Volumes Trending Config Triggers Trending Y Performance Trending Wamings and Erors Trending Y History Usage Trending Right mouse context menu Save or Load Report Selection To Save a currently selected report click on the Save button and name the selected report To recall a saved report click on the Load button and select the report file with extension RPT Start Report Generation After you have made your selection select OK to start report generation The following dialog is shown with a progress bar 100 does not mean generation is finished Please wait while reports are generated DE Generating report number 28 Time to generate current report 0 Seconds Total time to generate selected reports 11 Seconds A Less information Generating reports with more information showing When the reports have been generated the Report Viewer window opens Copyright 2014 75 Reporter 6 2 1 Report Viewer The Report Viewer is the interface to view and print a report generated by PLCS Reporter This window opens after you use the Enterprise or Server Generate function k a a Report
21. schedule Job Schedule Active O Yes No Date amp Time 12 04 2011 08 00 00 Period 1 Period Unit DAYS Arguments Type OPERATIONAL Database Name TSMPLCS Executable ReporterCmd exe Report file Data operational xml as E mail to operational group Admin y Send Alert E mail Only Arguments database TSMPLCS html mailto gun Sample dialog when adding or editing a schedule Then click Apply to save the Schedules 8 3 Query Editor The Query Editor PLCS Reporter can be used to create your own queries for operational reporting In the configuration manager application click on the Tools menu and select the Query Editor menu select a TSM connection first s Node Grouping base Namel General Config Query Editor DRTER 7 TSM Poms c Options a ir SS SERVE Server Numbe TSM server nz TSM Server A Matahaca Man The following dialog window will open Here select a operational report file e g the default report file operational xml If you wish to create your own operational query file browse to the report directory default C Program Files PLCS Reporter Data 128 Copyright 2014 Operational Reports Then copy the sample_operational xml file and rename it with extension XML Reopen the Query Editor dialog and now the file will appear in the drop down box ID INAC ISRO REPORTTYP TEXT QUERY_TSM6 Operational Custom Summary SELECT Server Platfor
22. the data grid and dragging the cursor down the amount of selected lines can be viewed Scroll back in the data grid to view earlier commands Text in the data grid can be copied to the clipboard with right mouse menu or CTRL C Slider on the right bottom allows user to enlarge text zoom in the window Time stamp is provided with every command executed Save queries as XML or CSV The follow hot keys are available in the command window Fi Get command help in HTML F4 Drop down the command line to view previous commands CRTL H Hide Show console window CTRL R Clear command line history Use the Commands dock slide to access many of the available TSM commands Copyright 2014 105 Reporter 6 14 Settings The Settings window allows you to change report defaults application paths and shortcut keys To open the Settings window select the Info icon on the ribbon under the Tools tab F gt i Report View Action Help View Ribbon Tab with Settings selected The Settings window has two tabs Report and Application Report Tab The report tab allows the user to configure parts of the report generation Chart show all report charts with amount of days configures how many days the charts in the reports will show Default each chart has its own amount of days history Restore Show all report charts with amount of days Estimated file creation speed on OS files hour 7days Windows platform 100
23. the installation 36 Copyright 2014 Installing cx C WINDOWS system32 cmd exe Checking system Microsoft NET Framework version 3 5 SP1 is already installed i WS version 2003 OS version 5 2 3790 ws platform 32 bit Powershell is already installed Windows version 2003 Windows OS version 5 2 3790 Windows platform 32 bit Installer 4 5 or higher Redistributable is already installed Installing MSSQL 2668 Express MSSQL installation was succesfull Reporter was succesfully installed Press any key to continue Press any key to end the installation script setup cmd and close the command window Pr My Computer mm y My Network Places A y Intermet Explorer a PLCS Reporter On the desktop a shortcut to start PLCS Reporter has been created PLCS Reporter can only start when you have a valid license Read here to see how you can obtain a license number for your system End of installation procedure Copyright 2014 37 Reporter 4 3 4 3 1 38 Manual Installation and Configuration Follow the following topics for manual installation of MS SQL Database or Reporter Otherwise use the automatic installation J Database installation and configuration CJ Reporter installation Database The following steps need to be performed for PLCS Reporter to work with a Microsoft SQL Server A completed install of Microsoft SQL Server Complete the following steps e On the Micro
24. the organization to manage the IT Asset Portfolio with respect to risk cost control IT Governance compliance and business performance objectives as established by the business IT Asset Management is an integrated software solution that works with all departments that are involved in the procurement deployment management and expense reporting of IT assets 1 Goals of ITAM ITAM business practices have a common set of goals e Uncover savings through process improvement and support for strategic decision making Gain control of the inventory Increase accountability to ensure compliance Enhance performance of assets and the life cycle management Risk reduction through standardization proper documentation loss detection Copyright 2014 145 Reporter 146 Process ITAM business practices are process driven and matured through iterative and focused improvements Most successful ITAM programs are invasive to the organization involving everyone at some level such as end users educating on compliance budget managers redeployment as a choice IT service departments providing information on warranties and finance invoice reconciliation updates for fixed asset inventories test IT asset management generally uses automation to manage the discovery of assets so inventory can be compared to ownership information Full business management of IT assets requires a repository of multiple types of information about the asset
25. up to 31 days Enabling views of Processes Mounts or Clients click on the check boxes Synced zoom option will allow you to simultaneously zoom all open charts in the Timeline window Show Active and Missed will display the currently active processes mounts client sessions and the missed client schedules The Save View button will store the selected check boxes for when opening a new Timeline window Each chart has the ability to zoom into a smaller time slice hold the left mouse button and drag it to the end point in the chart then release the mouse button The graph will show a zoomed view To zoom out click on the left upper corner of the chart 3 00 15 00 17 00 19 00 2 S 16 30 16 45 17 00 17 15 17 30 i17 Zoom into a time section Zoomed section The Synced Zoom checkbox option gives you the ability to zoom into all charts at the same time into the same time section Copyright 2014 85 Reporter Bar Information The bars on the charts are color coded each color has a different meaning o Gen successful process po Rea Unsuccessful process pC Purple Process match with tape mount Purple Tape mount match with process or session Tape mount dela Successful backup restore archive retrieve darker Pp Cd Yellow Failed return code 4 8 or Running Po Rea Failed return code 12 or Missed Purple Session match with tape mount With the mouse pointer you can acquire more infor
26. 000 O Aime Unix platform 400000 D 90 days 180 days Tape Drives Default of chart Mount and dismount delay seconds 90 Other 28 days Top Count Show top amount in report 53 10 5 20 Apply Sample of setting window with report tab Restore estimated file creation speed on O S allows you to configure the maximum amount of files the Operating System Windows and Unix can create per hour This parameter is used in the restore time estimation of a client node Please refer to section Reports for more information about these settings Tape drives mount and dismount delay seconds is the amount of time it takes for a 106 Copyright 2014 Reporter GUI tape to mount and dismount This parameter is also used in the restore time estimation of a client node Application Tab The application tab allows the user to configure application specific parameters such as Charge back calculation simple or complex calculation currently only simple available gt Application Ribbon Color Scheme color of the ribbon Silver Blue or Black _ Settings Repot E Charge back Color Type of calculation Application Ribbon Color Scheme 9 Simple VistaGlass x Complex Sample of settings window with Application tab Copyright 2014 107 Reporter 6 15 Howto use the Filter The filter function of PLCS Reporter can be used to filter information in a data grid The filter function is available f
27. 09 09 10 2009 09 10 2009 08 10 2009 09 10 2009 ENU exe 17 52 15 41 15 38 15 54 15 41 5 File s Installing 3 193 pwrshell vbs 5 422 373 Windows6 0 KB928439 x64 msu 5 279 681 Windows6 0 KB928439 x86 msu 1 691 696 WindowsServer2003 KB926139 v2 x86 ENU exe 2 297 392 WindowsServer2003 WindowsXP KB926139 v2 x64 14 694 335 bytes Directory of C Install Reporter_Install Pre Requisites wininst45 09 10 2009 09 10 2009 07 10 2009 08 10 2009 07 10 2009 12 10 2009 Copyright 2014 15 02 15 02 16 39 12 32 16 39 17 57 lt DIR gt lt DIR gt j 1 768 236 Windows6 0 KB942288 v2 x86 msu 4 691 480 WindowsServer2003 KB942288 v4 x64 exe 3 071 512 WindowsServer2003 KB942288 v4 x86 exe 2 786 wininst45 vbs 9 534 014 bytes 25 Reporter 4 2 2 Details of Script For an automated installation of PLCS Reporter start the Install_Reporter cmd script Install_Reporter cmd in detail echo off cls REM Check for sufficient rights whoami groups findstr b BUILTIN Administrators findstr c Enabled group amp amp goto isadministrator Not sufficient administrative rights Start the install with Run as Administrator isadministrator REM Check OS for Windows 2008 R2 setlocal PROCESSOR_ARCHITECTURE x86 set pro_arch 32 Bit x86 SPROCESSOR_ARCHITECTURES AMD64 set pro_arch 64 Bit AMD64 PROCESSOR_ARCHITECTURE IA64 set pro_arch Itanium 64 Bit IA64 Main call clean for f tokens 2 delims
28. 424 24 MB 444852378 0 7 Sample of a data grid Help Ribbon Groups The Help ribbon group contains the button items for Help opens a internet browser with online help 0 About opens a dialog with the version number FA y ESAS ERE Sample of Help tab Copyright O 2014 73 Reporter 6 2 Generate Report PLCS Reporter has many functions but the most important are Enterprise and Server Report Generation The amount of reports that PLCS Reporter can generate are plentiful To generate a Enterprise Report select on the ribbon menu Report tab Enterprise Reports Generate or shortcut keys ALT R E First you will be prompted to select a TSM server or group of TSM servers How to create a TSM server group To generate a Server Report select on the ribbon menu Report tab Server Reports Generate or shortcut keys ALT R G a a v Reporter ry Report View Action Help L 2 Q wt a 3 Info Performance List Collocatior Generate Charge Back Assets an AAC OF Ok eport Generate Opens a dialog containing all the reporting queries available You can select the reports that you like to generate qeeg Y Server Report Generate selected and shortcut keys showing The Select Report dialog will open and you can make a selection of the reports you would like to be generated by clicking on the check boxes in the left pane The list window on the right will display the se
29. 63 Windows OS version 5 2 3790 Windows platform 32 bit Installer 4 5 or higher Redistributable is already installed Installing MSSQL 2668 Express Extracting File x86 setup sgl_engine_core_inst_msi pfiles sqls To Directory c 11e39560b3bd9bbaf26623171923117 After that the MS SQL installer will unpack and start installing AN SQL Server 2008 Please wait while SOL Server 2008 Setup processes the curent operation The SQL installer package will open a console screen DO NOT CLOSE THIS WINDOW Reading schema resource Microsoft SqlServer Configuration Cluster ClusterNodePuWY blicConfig xsd Reading XML resource Microsoft SqlServer Conf iguration Cluster ClusterNodePubli cConfig xml Microsoft SqlServer Conf iguration Cluster ClusterNodePublicConf ig xml validated with schema Microsoft SqlServer Configuration Cluster ClusterNodePub licConfig xsd loaded into datastore path Datastore ProductSett ings ClusterNod e Public Reading schema resource Microsoft SqlServer Configuration SlpExtension SQLServe rSCPPrivateSettings xsd Reading XML resource Microsoft SqlServer Configuration SlpExtension SQLServerSC PPrivateSettings xml Document Microsoft SqlServer Configuration SlpExtension SQLServerSCPPrivateSett ings xml validated with schema Microsoft SqlServer Configuration SlpExtension SQLServerSCPPrivateSettings xsd loaded into datastore path Datastore ProductS ettings SQLServerSCP
30. Add Features Wizard as shown below Click Cancel and expand NET Framework 3 5 1 Features and then check NET Framework 3 5 1 check box below it Copyright 2014 Installing add Features wizard x Add role services and features required for NET Framework 3 5 1 Features Ks You cannot install NET Framework 3 5 1 Features unless the required role services and features are also installed Role Services Description Web Server IIS Web Server 115 provides a reliable Web Server manageable and scalable Web application infrastructure Application Development B Securty El Windows Process Activation Service Process Model NET Environment You cannot install NET Framework 3 5 1 Features unless the required role services and features are also installed 1 In the Confirm Installation Selections interface review the selections and then click Install 2 Allow the installation process to complete and then click Close Copyright O 2014 21 Reporter 4 2 22 Automatic Installation Start the Install_Reporter cmd script referral to the Details of Script Before you start please have your machine fully patched with all Microsoft Updates The automated installation performs the following tasks Installs Microsoft NET framework 3 5 SP1 or higher Installs Microsoft installer version 4 5 or higher Installs Microsoft patches needed for packages of NET Installs Microsoft Powershell If the packages are
31. CS Reporter the separate license keys have been replaced by a single license file After sending the license request with either the following information on the TSM Admin command line perform a Querty STatus e TSM server name e TSM server DNS or IP address e TSM server port address or perform a QUERY STATUS from the TSM server command line You will receive a license lic file copy this file into the PLCS Reporter installation directory path e g C Program Files Reporter After this start the Reporter executable and the license will be read Copyright 2014 45 5 5 1 Application Components Application Components PLCS Reporter consists of the following components PLCS Reporter Report creator viewer and user interface Configuration Manager Configuration user interface Scheduler Service Scheduler service Agent Command line Agent for collecting data from TSM from command line Client Agent Agent for collecting WMI and VMware server data Reporter Command line Command line report generator Reporter The Reporter is the main user interface of PLCS Reporter This program allows you to tap into the data that was collected by the Reporter Agent from a database The PLCS Reporter user interface provides some of the following functions View and Generate Reports Node Info drill down reports of TSM client nodes Create Node Collocation groups Node Performance report list Database Browser Tim
32. E02 j 26 07 GB TSMSERVER Current TSM server name TSMSERVER and MS SQL database name TSMPLCS Last record in activity log 07 23 58 on 12 March 2010 Sample Charge Back window simple version In the Charge Back window it is possible to print save as XML and CSV and filter the content by selecting the action ribbon in Reporter 80 Copyright 2014 Reporter GUI 6 4 Asset Node and CPU Enterprise Asset on the ribbon under the Report tab Enterprise section opens a window with CPU asset info of a groups of TSM servers The CPU asset info is configured in the Configuration Manager the VM Settings tab for VMware servers or a Virtual Center the WMI Settings tab can be used to add IP addresses and ranges for Windows servers Then the collection of data needs to run this can also be done in the Configuration Manager in the Schedules tab and running the WMI_VM schedule Other To view the information click on the Asset button and the following group selection dialog opens Select TSM server or a group of servers Group or Server Name Description Server Names PLCS_SERVERS TSMSERVER UNGROUPED All nodes or clients not backed up by TSM NONE 4 m E Show only groups with multiple servers Cancel If there are no groups available create a Enterprise Group first Select a group of TSM server clients for viewing and click OK Copyright O 2014 81 Reporter Reporter Report
33. LCS 2 MCESERVER MCESERVE Group E mail adress es E mail Address es admins company com Sample of the operational tab with email address After configuring the E mail destination you need to set up a schedule to create the report for a TSM server Copyright 2014 Operational Reports File Tools Help Number TSM Server Name General Configuration Logging Database Scheduier Schedules Operational VM Settings WMI Settings 0 1 TSMSERVER Number Type Database Name Start Time Period Units i Priority 1 COLLECT TSMPLCS 2010 03 17 08 30 00 DAYS 1 2 COLLECT REPORTER 2010 03 17 09 00 00 DAYS 2 3 OPERATIONAL TSMPLCS 2010 03 17 10 00 00 3 4 2010 03 13 06 00 00 3 Sample of Schedule tab with a operational schedule selected To create the schedule perform the following steps Click on the Schedules tab and click Add Select the schedule options e g Start Date and Time Period Period Unit Select a schedule with type OPERATIONAL Select the database name of the TSM server Select or leave the default report file Choose if you like to E mail the report to a group Check the Send Alert E mail Only in case you like to send a mail only incase a threshold is exceeded e g no scratch backups failed etc Review the arguments in the dialog and click OK Copyright 2014 127 Reporter
34. NG RE PORE AAE O T 118 Restore Report e a a ia ii il id iii 120 Entenprise i a Fit a Wee eed ch ed vee eel Pes eae cee ee a 121 Server Re pOr Aa ceda donde cade 121 Database Report vivida A aa r aa aa a e A EA ep a aaae AEEA 121 Drives Report iii AA ALI a Ad ae 121 Copyright O 2014 Contents OCCUPAN EY RE POM icono sion aia a r AAA IAEA LEA A EE 121 Processing Report miooo canon eS A AAA ALA ais 122 Schedules Re pOT diia rasca 122 Volumes Report miccional naa AENA caia reinan 122 Client Repo E a a e a a ra IAEA A AAA as a a e 122 Part VIII Operational Reports 125 a ER File a E T E T T T TA 125 PE EE E E E E N E E 126 Query Editorsin aaa ae a dato 128 Part IX Troubleshooting 136 Manual installing SQL Servel ccccscececeeeeeeeeeeeeeeeeeeeeeeeeeaaeeeeeeaeeeeeeeaeseeeeeaaeeeeeeaaeeeeenes 136 Reporter Schedule tii cciciccssectecasectsicseutecectenteeveccvertesesneneie a 138 Reporter Agente eii 140 PartX Contacting Support 142 Part XI Appendix 144 1 Asset Manageme tii cic cccciccccicccdsceccetecsteticteeteeindeneetecaiennededectediessenneedeoeersdaveenetecoveenaaas 145 Whatis WMlitiiiionrisa iaeaea aaa setae aaaea 147 Micros ofto WM lic iia 148 Virtual Systems VMWARE oooococcccconccccncccnnoccnnnnnnnnnccnnnn cnn canon cnn 150 2 Backup Database i aic ccn arere a A ceases tes divece aean e Saadia naaa A E a aae aeaio a daana 151 End User License AgreeMent o ocoonccconnncconnconocnnonnnnnnnnonnnnnonnnnannnnnnnncnnnrena
35. Number TSM Server Name General Configuration Logging Database Scheduler Schedules Operational VM Settings WMI Settings 0 TSM Connection 1 TSMSERVER User name reporter Password Wi Server address tsmserver ples nl TCP IP port number 1500 Exclude Options Activity log Message Excludes REPORTER Excluded Tables Activity Log Remove TSM server actlog records from database older than days Configuration Manager with configuration tab selected Following parameters can be configured User name TSM user account with System Privilege Account password TSM server address TCP IP or DNS address TSM administrative port address License key expiration not configurable License key generation date not configurable After changing one of the settings click Test The Configuration manager will contact the TSM server and validate the new values One of the following messages will pop up TSM server connection was verified TSM server port address is incorrect verify settings correct the parameter and try again TSM server address is incorrect verify settings correct the parameter and try again TSM server user is incorrect verify settings correct the parameter and try again TSM server password is incorrect verify password correct the parameter and try again Copyright O 2014 55 Reporter 56 Then after a successful test click Apply to save settings In the Exclude Optio
36. Operating System in 1 hour The duration is calculated with the total amount of files on the TSM server The speed for file creation can be configured in Settings on the report tab group restore These numbers are experience figures for file creation on a Operating System Estimated time for mounting and dismounting tapes from either primary or copy pool tapes These three numbers have to be added together to get a estimated restore time this is probably worst case scenario but should be close to reality Copyright 2014 Reports 7 2 Enterprise In this chapter the enterprise reports that can be generated are explained 7 2 1 Server Report The Server report Enterprise Generate Report describes in short the TSM servers in the group and any data collection inconsistancies 7 2 2 Database Report The Database report describes TSM server group database related information Database information like 2 Utilization and capacity in chart 2 Utilization and capacity per server 7 23 Drives Report The Drive and Library report describes TSM server group tape drive related information Drive information like a Drive utilization 2 Number of tape mounts 28 days 7 24 Occupancy Report The Occupancy report describes all grouped TSM servers and their client occupancy related information Occupancy information like a Total occupancy Copyright O 2014 121 Reporter a Historic growth Calculated increase decrea
37. Report tab Node section wt a Info Performance List Report Node History Generate TSM Collocation Groups Opens a new window that allows you to create and edit collocation groups and save them as a macro or save them directly as a script on the Tivoli Storage Manager server Ribbon with Node Collocation select The Node Collocation window consists of a Ta Collocation Gr TSMSERVER settings pane on the left for configuring 3 Settings the collocation settings shown on the E Select policy domain or storage pool right and a data grid on the right with PD STANDARD z all client nodes and their collocation group aga ia ER 500 The settings pane allows you to configure A ae the collocation groups 4 The following settings can be adjusted Collocation group name TSMSERVER_STANDARD O Policy domain or storage pool Empty nodes collocation group name N EMPTY_NODES O Average volume filling 0 Maximum amount of volumes per Total collocation group Node count O Collocation group name numbers are 46 automatically added pon il uid PS po GS Collocation group name for empty lt a client nodes Node Collocation window options Copyright 2014 97 Reporter How to create collocation groups First select a storage pool of policy domain It is advised you use a storage pool to configure the collocation groups The average volume filling has been queried from volume data from the TSM serv
38. SM data collection is possible without a license key In the Configuration Manager select the TSM server for which you wish to request a license key which has been added in Configure Then select in the menu File Request License Key a message box will prompt you with the question Would you like this request to be sent by E mail in case you can access a SMTP server click Yes otherwise No If you have chosen Yes a dialog box will ask you for the SMTP settings SMTP Settings Server address your mail server com User Account Password Sender Address reporter your mail domain com Test Options dialog for SMTP settings Fill in the SMTP server address and the sender address User account and password are optional Click test to send a Test Message to the sender A message box will display the status of the E mail sent action Then click OK to send the license key request In case you have chosen No Notepad will open with the following text TSM Server Properties TSM server name TSMSERVER TCP IP or DNS address tsmserver domain com TCP IP port number 1500 Please send this key request information to info plcs eu Copy paste the text into a E mail and send it to info plcs eu Copyright 2014 4 6 Installing After receiving the license file copy the file into the program path and start PLCS Reporter to verify the license s License File In the current version PL
39. SOFTWARE THE COLLECTIVE LIABILITIES OF SELLER AND ITS THIRD PARTY SUPPLIERS SHALL BE LIMITED TO THE LIABILITIES STATED IN THIS LICENSE AGREEMENT Seller s third party suppliers are intended third party beneficiaries of all limitations of liability and disclaimer terms included in this agreement If you have any suggestions or questions do not hesitate and send us an email info plcs eu You can download software updates documentation enhancements and obtain further information at www plcs eu 152 Copyright O 2014 Appendix 11 4 How to License PLCS Reporter is licensed per TSM server instance Advised Database s on a collector The maximum amount of PLCS Reporter licenses per database server is up to 15 TSM instances with MS SQL Express and up to 30 TSM instances with SQL Enterprise Editions Microsoft SQL Server Database The maximum amount of PLCS Reporter licenses per database server is up to 15 TSM instances with MS SQL Server Express Edition and up to 30 TSM instances with SQL Server Workgroup Standard and Enterprise Editions SQL Server versions other then express like Standard and Enterprise Editions are not free of charge Important If you choose to run your database on a SQL Server other then SQL Express you need to obtain a license for that database server at Microsoft Licenses other than MS SQL Express are not included View usage criteria here Copyright 2014 153 Reporter Index A Activ
40. a made for Tivoli Storage Manager PLCS Reporter for IBM Tivoli Storage Manager User s Guide Last revised April 2014 This guide contains information that is needed to install configure maintain and use the Reporter product Version 2 8 C2 PL CS Copyright 2014 Reporter Copyright 2014 All rights reserved No parts of this work may be reproduced or transmitted in any form or by any means graphic electronic or mechanical including photocopying recording taping or information storage and retrieval systems without the written permission of the publisher Products that are referred to in this document may be either trademarks and or registered trademarks of the respective owners The publisher and the author make no claim to these trademarks While every precaution has been taken in the preparation of this document the publisher and the author assume no responsibility for errors or omissions or for damages resulting from the use of information contained in this document or from the use of programs and source code that may accompanyit In no event shall the publisher and the author be liable for any loss of profit or any other commercial damage caused or alleged to have been caused directly or indirectly by this document PLCS Reporter for TSM is a product of P L C S BV PLCS based in The Netherlands Adobe and Adobe Acrobatis a registered trademarks of Adobe systems Inc IBM AIX and RS 6000 are reg
41. a aa aidien aaa AAA 90 MENUS E e E E E E E A E E indi 91 Node Performa ne ia 92 Menus Node List Menus Histor Y N 99 A goeecicescapsaas cate dues suds ade daeddes asueetusssneeauesaeduaidedex soeseussuieusiedeasestedecdsntendeestepenie 100 ACtivity LOG 223 E a ANN 101 A O O 102 Browse Database id 103 Command ING iii na 104 SUING O 106 How to use the Filteny viiiccicciscccsccsvecsiceveweeescceneiecsecetsccsieesitesetevedaseteecsaseesencaetiesicenetevetae 108 Reports 112 SCMVG Pi iii ina inde 112 A O O 112 Database Report 112 Drives and Library Re POM ici 113 DRM RE DO diia Ai ALS A Ad iaa 113 LOGUREDOF ccceiccsscescnkscvesecanssesoneacoccetsecceastexesscessacsessecuseteatesaceuccdsevesscusessouedchactesedseasucechsussdasssaaesessneniusisenestiens 114 Node Re Port isccisceccsccscssucvscaveseescesccacvaccecctucessvecusstesusevessceunccevetecesateesguvesuceceiusacssucusaus susbestubavenscesersucesuacevescerss 114 O ONO 114 Performance RO pOT aa a a a eaa a ae a Ea aa daa aaa Ee re ae eeraa ra aaa E a Ve aaae iii 115 Processing Report 116 Schedules Report 116 Security Report 116 Storage Pool Retina 117 VETS IONS Report s ciscvsssccieccseisncecesaceccesciucusscvesciveesecaeuesveassuaseiansesvvetesssereuceevsicedseectasessvesteiseesccusstesveatsancesiess 117 VOlUM EG RE pOT i r r a a a aa r E E rea OPE S A Ee a Ae ae Aa surpresibsvesecaverccesseesuvctesves 117 TP ROMCUI
42. agement Instrumentation WMI query against the Win32_Product class to obtain a list of installed applications you receive an error message that resembles the following Error Number 0x80041001 Facility WMI Description Generic failure After the error the list of installed applications is not obtained Note This problem does not occur in Microsoft Windows Installer 3 1 How to verify if NET Framework 3 5 SP1 is installed Windows Server 2008 R2 Here are the steps to verify that NET Framework 3 5 1 is installed on Windows Server 2008 R2 1 Click the Start button in the lower left hand corner of the display 2 Highlight Administrative Tools and select Server Manager 3 In the Server Manager interface click Features to display all the installed Features in the right hand pane Verify that NET Framework 3 5 1 is listed If NET Framework 3 5 1 feature is not listed you can use either of the following methods to install it Using Server Manager Interface 1 In the Server Manager interface select Add Features to displays a list of possible features 2 In the Select Features interface expand NET Framework 3 5 1 Features 3 Once you expand NET Framework 3 5 1 Features you will see two check boxes One for NET Framework 3 5 1 and other for WCF Activation Check the box next to NET Framework 3 5 1 and click Next Note If you do not expand NET Framework 3 5 1 Features and check it you will get a pop up titled
43. allation End User License Agreement EULA amp End User Maintenance Agreement Click I accept the agreement if you accept the agreement and then press Next Copyright 2014 33 Reporter Select Destination Location Where should PLCS Reporter be installed A Setup will install PLCS Reporter into the following folder To continue click Next If you would like to select a different folder click Browse At least 46 6 MB of free disk space is required The installer will prompt you for the location to install PLCS Reporter on your system Select Start Menu Folder Where should Setup place the program s shortcuts A Setup will create the program s shortcuts in the following Start Menu folder To continue click Next f you would like to select a different folder click Browse PLCS Reporter Browse 34 Copyright 2014 Installing Setup PLCS Reporter Ready to Install Setup is now ready to begin installing PLCS Reporter on your computer Click Install to continue with the installation or click Back if you want to review or change any settings Destination location C Program Files PLCS Reporter Start Menu folder PLCS Reporter Click Install the PLCS Reporter will now be installed After the package has been installed the Configuration Manager will open You might be prompted to configure and validate the database connection MS SQL General Configu
44. already installed they are skipped during installation otherwise the installer performs an installation of the needed items After the installation of these items a reboot is required Once the reboot is done run the setup cmd again and the remaining checks are done then if all packages are installed correctly the installation of Microsoft SQL takes place This is also done automatically including all the configuration steps Once Microsoft SQL is installed the setup script runs the setup of Reporter When Reporter is on the last stage it will popup the Reporter Configuration Manager and asks you to confirm correct communications with the MS SQL database Then add a TSM server connection as described in Add TSM Server Copyright 2014 Installing 4 21 Downloading the Package On the following URL http upload plcs nl download All the packages are available for download MSSQL Install Reporter Manual PLCS_Reporter_x x pdf Reporter Executable Reporter_Setup_x x x x Zip Reporter_Setup_x x x x exe FILE NAME ENU x64 MS SQL Express Installation package ASQLEXPRWT_x64_ENU exe Reporter_Setup_version exe Setup of Reporter or Reporter_Setup_version zip Setup of Reporter in zip format Reporter_version pfg Reporter Manual in PDF Please download all the packages and unpack them Note The path may not contain any SPACES Copyright O 2014 23 Reporter 4 2 1 1 24 File Location Directory structure of the a
45. am this message 5 will be displayed on the server as the connection is suddenly closed by table A server is cure SERVER the client A network failure can also cause this message to be SS j displayed If a large number of these messages occur simultaneously check the network for failure and correct any problems than 60 minutes SE SERVER 12 02 2011 21 50 482 W ANR0482W Session 24819 for node PLCSO5V WinNT terminated idle for more than 60 minutes SE SERVER 13 02 2011 00 35 4008 13 02 2011 00 35 403 Sample activity log window with only warnings and errors ANE4008E Error var db2 fmed Jock file is temporarily unavailable SESSION 24891 CLIENT PLCSVMO02 r T ANE4037E File cil 20 stats pa during processing File CLIENT PLCSVMO2 mimimim By default the Activity Log window will open the log of the last hour of activity log that is available The Activity Log window from and until time and date can be changed then click Update to update the data grid In case that the amount of records cannot be displayed in the viewer in one go the Next button will enable Clicking the Next button will forward the viewer to the next set of records The three Show options allow you to show All messages only the Warnings and Error messages or only Error messages with one click Moving the mouse over the message number or severity will show a popup with t
46. ary 2011 Dr Past days 1 Y Processes Y Mounts E Clients Y Synod Data 297 63 MBytes Processes Transfer rate 12 40 MBytes sec Gis Examined 295 Affected 295 13 00 13 15 13 30 13 45 14 00 14 15 14 30 14 45 Total media wait 00 00 26 700 EXPIRATION ops f i t ji t f Mounted volumes first 10 only MIGRATION DISKPOOL i STGPOOL BACKUP ARCHPOOL gt ARCHCOPY STGPOOL BACKUP ARCHPOOL gt ARCHXTR i i STGPOOL BACKUP BACKPOOL gt BACKCOPY i I i 3 j STGPOOL BACKUP DISKPOOL gt BACKCOPY _ i I 000139L3 in DRIVEL mt1 0 0 2 Mounts 13 02 13 00 13 15 13 30 13 45 14 00 14 15 14 30 14 45 15 00 15 15 15 30 15 45 16 00 16 15 16 30 16 45 17 00 DRIVET MT1 0 0 2 i i i 4 ji m DRIVE2 MT2 0 0 2 j N co lll Sample timeline with tape mounts matched with a reclaim process When moving the mouse over a process or session that can be matched to a tape mount or vice versa it will mark that tape mount by coloring it purple In the popup all the mounted tapes are listed up to 10 volumes The tape mount match is performed by the Reporter Agent after a successful data collection In some cases it might not be possible to match some of the tape mounts with a session Clients Chart Popup Moving the mouse over a bar in the Client Chart will allow you to see more information about that session In case the session is linked to a client schedule one of the following codes is displayed Explanation _
47. as configured TSM server name TSMSERVER Server address 192 168 222 2 TCP IP port number reporter SERVERO1 A _ a Reporter The wizard will show a final configuration screen Click Finish to complete the configuration After the wizard has closed you might need to enable the TSM server for data collection File Tools Help odas Ey ae ae i Configuration Logging Database Scheduler s 0 TSM Server Config 1 TSMSERVER Server Number 1 TSM server name TSMSERVER TSM Server Address tsmserver pics nl 1500 Database Name TSMPLCS Last time run 15 March 2010 14 43 Status O Configuration Manager with general tab selected To view general configuration select the TSM server that you just created in the left pane Click on the database tab to verify the database connection click test and then apply in case the test is successful Select the scheduler tab and verify if the scheduler was installed and is running if not click install and then start Data collection of the TSM server should start within a few minutes Click update log to refresh the last scheduler events Copyright O 2014 51 Reporter 5 2 2 Remove TSM Server To remove a TSM server connection from data collection Select the server connection in the list then select File from the drop down menu and click Remove TSM Server File Tools Help Add TSM Server er Configurati ai Rem
48. as well as integration with other systems such as supply chain help desk procurement and HR systems ITAM and PLCS Reporter Seeing as a reporting product for backup archive and disaster recovery the need to know what is behind this data and application landscape Reporter has a set of tools to perform automated discovery and request information about the components used components during a IBM Tivoli Storage Manager operation Currently supported are the following systems Physical systems Virtual Systems Windows all clients currently in supported VMware Server 1 x 2 x e Windows XP VMware ESX 3 5 e Windows 2003 SP2 VMware ESX 4 0 vSphere e Windows 2008 VMware ESXi 3 5 e Windows Vista VMware ESXi 4 0 i VMware ESXi 4 1 VMware workstation 6 x 7 x referral here VMware GSX and components Component support VM Component support File space detection File space detection CPU core detection CPU core detection Windows TSM node detection Linux OS release detection Oo Oo e Windows OS release detection Windows OS release detection Oo e Windows TSM TDP detection PLCS Reporter supports two methods of asset management detections one is thru the VMware c toolkit which communicates with the SDK web services The other method is thru Windows WMI Windows Management Instrumentation services VMware support is done via connecting to either Virtual Center or directly to the VMware server system to collect informatio
49. aturday morning following the installation of Reporter The process will detect and scan WMI information which in then inserted into Reporter database Using the collected information reports can be generated about CPU cores filespaces and other sources of information If a Windows system is detected without a configured TSM client this system is then added to the list as ungrouped node 5 2 4 E mail Configuration E mail features in PLCS Reporter are currently used for a license key request and operational reporting 64 Copyright O 2014 Application Components To configure the E mail facility select from the drop down menu in the Configuration Manager Tools Options Server in TSM sen State Configuration Manager Tools menu Options item selected In the Options dialog on the SMTP tab fill in SMTP server address and sender address In case your SMTP server requires validation also add user account and password SMTP Settings Server address your mail server com User Account Password Sender Address reporter your mail domain com Options dialog window for E mail settings Click on the Test button to send a test e mail to the senders address Select OK button to confirm the settings Copyright 2014 65 Reporter 5 3 66 Reporter Scheduler The Reporter Scheduler program is a scheduler for starting the data colloctor agent command line generat
50. b allows you to view previously generated reports a mi co Ga Info Performance List Collocation Node Histor Report History Opens a new window that contains all previously generated reports Report Ribbon History selected A window with a tree similar to the Report Viewer opens with the difference that you can select previously generated reports To view a previously generated report select the report section in the tree on the left full reports cannot be viewed but can be printed Selecting the root History and Report root will not load the reports as this is a program restriction Like the Report Viewer window reports can be printed by section or whole report to a printer of PDF file Previously generated reports are kept until the user deletes them 2 See Menu s to remove old reports Copyright 2014 99 Reporter 6 10 1 Menus History Context Menu Right click on the report This opens the context menu with the following functions o Refresh Content will reload and refresh the tree gt Expand All will expand the complete tree in full Collapse All will collapse the tree and expand it from the root Delete Tree will delete all reports under that branch user will be prompted first Ta _ Report History Viewer L E Refresh Content 5 Expand All gt E Collapse All 2010 03 12 TSMPLCS T Report History Viewer tree with context menu 100 Copy
51. bbon Tab These node groups will then be created only locally on the Microsoft SQL database It is possible to create as many groups as needed and a TSM node can also be in multiple groups The procedure to create a nodes group is as follows e Click the Nodes grouping icon on the view tab e Type or select a group on the right top selection box e Then add TSM nodes on the left side that you like to have in the group by either double click or Add button You may add a group description on the bottom right e Then click OK the group is created on the TSM server and the dialog window will close Note To create a group of nodes that covers multiple TSM server create a group with the same name on each of the TSM server Copyright O 2014 79 Reporter 6 3 Charge Back Charge Back item on the ribbon under the Report tab Enterprise section opens a window with a groups of TSM servers In the Charge Back window you may change the cost per megabyte from the default 0 0001 cent per megabyte Charge back allows you to charge for copy pool occupancy To update click on the update button on the data grid you will see the total cost per node Info Performance List Collocation PLCSKO1 267 72 GB TSMSERVER REMCO_THUIS i 191 06 GB TSMSERVER PLCS02 121 83 GB TSMSERVER PLCSSERVER 5 110 57GB TSMSERVER PLCSO1 83 28 GB TSMSERVER AVG S01 i 66 82 GB TSMSERVER ROCS_EXCHANGE 50 63 GB TSMSERVER OPTEND
52. ber of Scratch Volumes Number of Unavailable Volumes Number of Read Only Volumes Number of Destroyed Volumes oo ooon Sample HTML Reporter Operational Report Copyright 2014 125 Reporter 8 2 126 The operational report is purely for quick overview and 24 hours statistics The report is generated after a data is collected into the SQL database Reports are generated from the SQL database The last data collection point is displayed in the last Activity log date Not all items have been created as they were available in IBM s TOR e mail report In case you need a certain report added please contact us through the support web site and make your request Configure Configuring Reporter Operational Reports ROR in the configuration manager You can enable Reporter to generate the Operational Reports and mail them to a group For the operational reports a separate Operational tab in the Configuration Manager is available to define a group name with E mail address es where the report should be sent to In case you like to E mail a ROR enter a group name and one or multiple E mail addresses separated by a and click the Add button To remove a E mail group select the group name and click the Delete button File Tools Help Number TSM Server Name Database Name General Configuration Logging Database Scheduler Schedules Operational vm Settings WMI 0 REPORTER 1 TSMSERVER TSMP
53. ber on MSDN If you do not receive an error number when running the script you can look for errors in the WMI log files found in the windir system32 wbem logs folder If it is difficult to determine which errors resulted from the script you just ran delete all the logs and run the script again This should make it easier to find errors related to your script If you cant find any errors in the log files you might need to reset the logging level for the logs To get maximum information set the logging level to verbose On Windows 2000 Windows NT and Windows Me 98 95 you need to restart WMI after changing the logging levels this is not required for Windows XP and Windows Server 2003 For detailed information on configuring the logging levels go to http msdn microsoft con library default asp and search for Logging WMI Activity Errors might also be recorded in the Windows event logs Look for events with the source Winmgmt On Windows XP or Windows Server 2003 you can use MSFT_WMlIProvider classes to troubleshoot provider operations such as loading and unloading the provider responding to a query executing a method etc For example WMI generates an instance of the class MSFT_WmiProvider_CancelQuery_Pre immediately before the provider cancels the response to a query An instance of MSFT_WmiProvider_CancelQuery_Post is generated after the cancellation occurs If a query operation in a particular script is failing you can write a scri
54. cupancy Backup maximum and average within last 28 days All client schedule information Client default backup copy group Generating the list depending on the amount of nodes might take a while data is collected from e g activity log schedule and backup copy group tables Copyright 2014 95 Reporter 6 8 1 96 Menus The Node List window has a context menu on the data grid Click on the right mouse button and the context menu opens with the following menu items Hide Column hides the column under the mouse pointer Show All Columns shows all hidden columns D Filter Set Reset sets or resets a filter put on the data grid Hide Column menu item will hide the column under the cursor when printing the data grid the column will not show up on the print or PDF Show All Columns menu item will unhide all columns that were previously hidden by the Hide Column command Filter Set Clear menu items allow the user to filter the data for specific data Refer to How to use the Filter function Copyright 2014 Reporter GUI 6 9 Node Collocation TSM server version 5 3 and up is needed to use collocation groups A storage pool configured to use group collocation is needed The Node Collocation window allows you to create collocation group quickly and save the commands as macro or put directly on the TSM server as a script To open the Node Collocation window select the Collocation icon on the ribbon under the
55. curity Report 116 The Security report Generate Report describes all TSM security related information Security information like Locked admins and nodes Inactive admins and nodes Most active admins HALT performed Password minimum length and invalid sign on count Client attribute changes Filespace deleted Copyright O 2014 Reports 7 1 12 Storage Pool Report The Storage Pool report Generate Report describes all TSM storage pool related information Storage Pool information like Capacity and usage Total amount and number of files Node count per storage pool Caching and collocation information 7 1 13 Versions Report The Versions report Generate Report describes all TSM version related information Versions information like Server version Client version Version compliancy Licenses in use 7 1 14 Volume Report The Volume report Generate Report describes all TSM volume related information Volume information like Copyright 2014 Filling per storage pool Average filling per storage pool and device class Historic information Scratch and private distribution Volume count over last year Reclaim eligible volumes Private volumes not in use 117 Reporter 7 1 15 Trending Report 118 The formulas used in the trend reports are explained in the following part Exponential Growth Rate Exponential growth or geometric growth occurs when the growth rate of a mathematical function is propor
56. d 153875 VMware Server 2 0 0 build 116503 4 m Sample of VM settings tab The following functions are available 62 Copyright 2014 5 2 3 9 Application Components a Add validates and adds a VMWare server connection to the list CJ Edit edit a existing VM connection Delete removes a existing connection After VM data collection has run the ClientAgent exe the servers list will display the VMWare servers information when selecting the connection WMI Settings Tab Last tab is WMI Settings tab WMI Windows Management Instrumentation is a component of Windows which is described here in detail This tab is used for creating an inventory of your Windows Servers for Asset reporting in Reporter Using WMI information can be retrieve from any Windows system This is supported for physical and also virtual systems WMI is also used for detection of local file systems on the a client To run the WMI collection manually you need to run from the Windows command line the ClientAgent exe wmi command File Tools Help Abe ee General Configuration Logging Database Scheduler Schedules Operational VM Settings WM Settings 0 1 TSMSERVER Accounts Domain Name Index Domain User Name Default User Name 1 PLCSEU Administrator YES Password Set Defaut Add Remove Address Ranges Type IP Address Y Account Ind IP Address 1 1
57. e answer to a database query gt Data grid with multiple columns and rows answers to a database query 76 Copyright O 2014 Reporter GUI a Chart with multiple answers to a database query Charts can be e g Pie Line Bar Spline 6 2 2 Menus The following menu items on the ribbon can be used with the report viewer From the output ribbon the print menu can be used to print to a printer or a Adobe Portable Document Format PDF file Report Tree Context Menu Right mouse click on the report viewer tree opens the context menu with the following functions Change Sort Order ascending or descending sort order of the tree view Refresh Content will reload and refresh the tree view Expand All will expand the complete tree in full Collapse All will collapse the tree and expand it from the root Delete Tree will delete the selected tree branch also removes the files Ta _ Report History Viewer _ of e ra Change Sort Order a Server Database Refresh Content Drives and Lit Expand All DRM Log Collapse All Client Delete Tree Occupancy Performance Praressina Right mouse context menu Report Sections Context Menu Right click on the report This opens the context menu with the following functions 0 Copy will copy content into clipboard text data grid and charts o Show last number of days charts only zoom in function to zoom out in a chart click on the
58. e of computer systems much like the dashboard instruments of cars can retrieve and display information about the state of the engine On what platforms is WMI available WMI is available in all recent versions of Windows WMI is installed with Windows Me Windows 2000 Windows XP and Windows Server 2003 For Windows 98 and Windows NT 4 0 WMI is available as an Internet download from http www microsoft com downloads Search for the download Windows Management Instrumentation WMI CORE 1 5 Windows 95 98 NT 4 0 Note that Windows NT 4 0 requires Service Pack 4 or later before you can install and run WMI Additional software requirements for WMI include Microsoft Internet Explorer version 5 0 or later Windows Script Host WSH WSH ships with Windows 2000 Windows XP Windows Server 2003 and Windows Me but not with Windows NT4 or Windows 98 You can download WSH from http www microsoft com downloads The latest version which ships with Windows XP and Windows Server 2003 is WSH 5 6 Copyright 2014 Appendix Why is a WMI operation returning an error To begin with make sure that the error in question is really a WMI error WMI error numbers start with 8004xxxx e g 80041001 You can look up WMI error numbers and return codes by going to http msdn microsoft com library default asp and searching for WMI Return Codes If you can t find the information you need try searching for the specific error num
59. e used with the Timeline window is Save JPG Timeline Context Menu Right mouse click on the chart The context menu opens with the following functions e Open activity log opens the activity log in a data grid within the selected time period Save as JPG save this chart to JPEG 3 00 5 00 7 00 9 11 00 13 00 15 00 17 00 19 00 Open Activity Log Save as JPG a 3 00 5 00 7 00 9 00 11 00 13 00 15 00 17 00 19 00 z Right mouse click on the bar The context menu opens with the following functions a Open activity log opens the activity log in a data grid with the selected bar process mount or client activity gt Save as JPG save this chart to JPEG Copyright O 2014 89 Reporter 6 6 Node Information The Node Info window shows you drill down information of a specific client node To open the Node Info window select the Info icon on the ribbon under the Report tab Node group section Help Generate Time Line le Ge Performance List Collocatior Server J Node Node Info Drill Down View Opens a new window that o you to drill down to all jon concerning a Tivoli re Manager client node Report Ribbon Node Info Drill Down selected The following Node Info window is displayed This window displays a full list of client nodes with node specific information 7 Reporter Report View Action Help Gf Pf OSS wae Generate Charge Back Assets Gene
60. ected The Info Browser window displays a list with all tables present in the database Select a table name in the list the right data grid will fill with data of that table _ Info Browser TSMSERVER LOG Sample of Browse Database window Tabel Name DRMPSTGPOOLS DRMRECOVERYMEDIA DRMSRPF DRMSTANZA DRMSTATUS DRMTRPF EVENTS FILESPACES GROUP_MEMBER LIBRARIES LIBVOLUMES LICENSE_DETAILS LICENSES View the query by clicking the button Show SQL button Filter Set Clear menu items allow the user to filter the data for specific data Refer to How to use the Filter function Copyright 2014 103 Reporter 6 13 Command Line The Command Line window gives you a old fashioned TSM command line with console and extra features DSMADMC To open the Command Line window select the Command icon on the ribbon under the View tab View Action Help 2 SS le ae Servers Nodes Settings Grouping Config Smart Administrative Command Line ser Query Browser Activity Log abase Tools Open a new window that allows you to perform all administrative directly on the Tivoli Storage Manager server View Ribbon Tab with Command Line selected First you will be prompted for a username and password to access the TSM server command line password can be saved for the next time User name Password od V Save password TSM login prompt Click OK to validate use
61. ed client node The following dialog is shown with a progress bar 100 does not mean generation is finished Report generation progress bar The client node report generated can be viewed from this window or from the Report History viewer window The node drill down report uses the same kind of report sections as the Report viewer window refer to this section Copyright 2014 91 Reporter 6 7 Node Performance The Node Performance window gives you performance information like client node transfer speeds and data amounts within a selected period of time To open the Node Performance window select the Info icon on the ribbon under the Report tab Node section A Generating the list depending on the amount of nodes might take a while data is collected from e g activity log table Report View Action Help 12 2 2 Gui a S ate Charge Back Assets Generate Time Line Info Enterprise Il Server List Collocation Re Node Performance Open a new window with backup performance figures NTREX01 16 03 2010 00 34 16 03 2010 00 35 0 0 31 Ribbon Node Performance selected The Node Performance window shows a data grid with client node performance 92 Node name and domain name Start end time and duration of backup Data amount average file size and compression KBytes sec Number of examined and affected files Media wait in seconds Transfer speeds in KBytes sec GBytes
62. eline browser graphical overview of process client and drive utilization Export possibilities in XML CSV and PDF format A smart TSM administrative Command Line Activity log viewer with advanced filter capabilities Restore speed estimation Enterprise Reporting Charge Back and many other functions All functions of PLCS Reporter are described in section Reporter GUI Copyright 2014 47 Reporter 5 2 Configuration Manager A x The Configuration Manager is a program for managing PLCS Reporter 4 X The program can be started from the Start Menu All Programs PLCS Reporter Configuration Manager The Configuration Manager allows you to Add TSM server and Remove TSM server Configure the time of the data collection Review data collection logs Control the Reporter Collector Stop Start Restart Control database backup time and location Performa license key request 5 2 1 Add TSM Server The Configuration Manager to add a new TSM server connection e Select in the drop down menu under File e Click Add TSM Server e This will then open the Add a TSM Server Wizard File Tools Help Add TSM Server Remove TSM Server Request License Key Exit Drop down file menu With the help of this wizard you are configuring a connection to the TSM server 48 Copyright 2014 Application Components Welcome to the Add a Tivoli Storage Manager Server Wizard Thi
63. eneral node related information Node information like Total count Different IP addresses Last access Nodes without schedule or client option set Node top X in backup Node count over last year Inactive nodes 7 1 7 Occupancy Report The Occupancy report Generate Report describes all TSM client occupancy related information Occupancy information like g Top X nodes total amount stored gt Top X nodes total amount files stored 114 Copyright O 2014 gt Historic growth Calculated increase decrease gt Total occupancy 7 1 8 Performance Report The Performance report Generate Report describes all TSM server and client performance related information Performance information like Performance parameters Top X in fastest client transfer Top X in slowest client transfer Average backup speeds Copyright O 2014 Reports 115 Reporter 7 1 9 Processing Report The Processing report Generate Report describes all TSM processing related information Processing information like Failed processes Failed files and database files Warning and errors count in last 24 hours Total media wait Time spent on housekeeping processes Database backup and expiration speeds Running restores 7 1 10 Schedules Report The Schedules report Generate Report describes all TSM client schedule related information Schedules information like Completed Failed Missed Completed with attention required 7 1 11 Se
64. er Report View Action Help 02305943530 Generate Charge Back Assets Generate Time Line Info Performance List Collocation Report Enterprise Server Node l History Report Viewer TSMSERVER E Report t Server 204 Client schedule status ofthe previous day Database Drives and Library 4 DRM Log Client Occupancy Performance Processing gt Schedules History Wamings and E Security Storage Pool Trending Versions Volume a TSM V6 aseqejeg 3 MMM Completed Completed with warning Failed MW Missed 4 m t 4 m Current TSM server name TSMSERVER and MS SQL database name TSMPLCS Last record in activity log 07 23 58 on 12 March 2010 Sample screen of the PLCS Reporter interface with report viewer window This picture shows an example of a report Selecting Report Section Selecting a report section can be done on the left side of the report viewer window a tree shows the selectable sections of the report Click on the plus signs to unfold the tree Click on the subsection to select a report the selected report will be loaded on the right side Selecting the root Report label will not load the report as this is a program restriction Report Sections To present the information generated by the report generator the report viewer utilizes 3 types of display components The three types of presentation in a report are e Text with singl
65. er you may adjust this value The initial value of the maximum amount of volumes per collocation group is 2 you may adjust this value You may also change the suggested collocation group names In case you like to change the order in which group collocation is performed you may sort the data grid columns differently Initially the group collocation order starts with the smallest client nodes and up Then click Preview to see the group collocation preview in the column COLLOCGROUP_NAME When you are satisfied with the groups created click Generate The data grid pane on the right will decease in height and a text pane will appear You can now copy paste save as macro click on Save as Macro or create a TSM script directly on the TSM server click on the Create TSM Script When you select Create TSM Script a connection to the TSM server will be made and the script created and the message will show after the script has been created A TSM administrator still needs to run the script on the TSM server e g run S_CG_TSMSERVER_BACKPOOL gt The following script has been defined on the TSM server Ly S CG_TSMSERVER_STANDARD Message box shown after creating a script on TSM A Warning keep in mind NOT to put some client nodes into a single collocation group in case performance is a issue with Disaster Recovery 98 Copyright 2014 Reporter GUI 6 10 History The History menu item on the ribbon Report ta
66. er a period of time of some element of the business for example revenue units delivered registered users etc Copyright 2014 Reports Linear Regression Linear regression is a form of regression analysis in which data are modeled by a least squares function which is a linear combination of the model parameters and depends on one or more independent variables In simple linear regression the model function represents a Straight line The results of data fitting are subject to statistical analysis Example of linear regression with one independent variable Copyright 2014 119 Reporter 7 1 16 Restore Report 120 The Restore report is a section in the Node Information windows The parameters and sections of this report are explained and elaborated in the following part Restore Time Factors like file system performance speed of file creation and throughput network performance LAN WAN throughput and number of tape mounts mounts and dismounts of tapes The time durations in this section can be used to estimate a TSM client node restore A restore can be estimated with the following steps Estimated data restore time the speed is based on the average backup speed over the past 28 days This speed is used by dividing the total amount of occupancy on the client with this speed Estimated file creation time the speed is the time it takes to create for instance 100 000 files on the file system of the
67. er and Window groups The Filter group allows you to filter content of a data grid The Window group has two items which allow you to Close a open child window or Close All open windows The Output group has the following functions available Copyright 2014 Reporter GUI Save XML saves a data grid into a XML file Save CSV saves a data grid into a comma separated values CSV file can be opened in Excel O JPG saves a graph to JPEG file O Filter Set allows you to filter the content of a data grid e g Activity Log Node List Node Performance Node Collocation Filter Clear allows you to reset clear the filter Window Close and Close All allow you to Close a open child window or Close All open windows EN Asset Info PLCS SERVERS _ Node Perform TSMSERVER S Node_Name Start_Time Data_Amount Data_Amount_Bytes NDTR_KB_Sec PAULATHUIS 15 03 2010 10 33 1 2010 10 43 0 10 13 1 30 GB 1398218575 2227 5 6 2804 31 3 ROCSSERVER 15 03 2010 20 02 15 03 2010 23 44 3 41 53 14 03 GB 15063720357 1105 0 3 8 4349 94 15 03 2010 20 24 0 11 2 98 72 MB 103514954 05 216 78 MENTREX01 15 03 2010 20 13 152 7 TRAC 15 03 2010 20 41 26 7 15 03 2010 20 42 0 0 31 826 24 KB 846068 01 20656 16 ROCS_EXCHANGE 15 03 2010 21 16 15 03 2010 21 17 0 0 44 88 02 MB 92290778 2048 4 7 0 1 0 MENTREX01 16 03 2010 00 00 16 03 2010 00 34 0 33 46
68. express sql download To manage MS SQL please download management studio from web page http www microsoft conyexpress Database InstallOptions aspx The PLCS Reporter installation includes a Microsoft SQL Server Express package The user will be prompted to install the database server Please use the automated installation package Copyright O 2014 3 4 3 4 1 Introduction Supported Database PLCS Reporter is a data server client This is an application that allows you to run commands and SQL statements against a database server connect to a remote or local database server and access its databases The following database engine is supported o Microsoft SQL Server 2012 R2 Express Not included in the package other releases of MS SQL Server are supported for example SQL Server Enterprise does require a separate license of MS SQL Server All database engines have different levels please review the database type and their edition limitation Utilizing a existing SQL Server which is already present in your organization is supported adviced is to install Reporter modules on a separate system and connect to your central SQL Server please use a separate user id e g Reporter and password for the SQL Server which needs dbcreator rights to create the database Refer to Database manual installation for more information Microsoft SQL Database PLCS Reporter supports all Microsoft SQL Server versions of 2008 and 2012 o
69. h existing management standards such as Desktop Management Interface DMI and SNMP WMI complements these other standards by providing a uniform model This model represents the managed environment through which management data from any source can be accessed in a common way Overview In order to unify the management techniques for the sake of simplicity the DMTF defined CIM to represent real world manageable entities in a unified way The CIM object model is an object database model using terms and semantics that are unique to all constructors and software developers This object model is implemented in a database called the CIM repository Based on the CIM model WMI includes real world manageable components available from the DMTF standards with some specific extensions that represent the various Windows components Moreover WMI exposes a collection of COM scriptable objects that allow various applications to take advantage of the management information As part of the installation process most of the Microsoft applications available today e g SQL Server Exchange Server Microsoft Office Internet Explorer Host Integration Server Automated Deployment Services extend the standard CIM object model to add the representation of their manageable entities in the CIM repository This representation is called a WMI class and it exposes information through properties and Copyright 2014 147 Reporter allows the execution of some acti
70. he information of that message Copyright O 2014 101 Reporter 6 11 1 Menus The Activity Log window has a context menu on the data grid A for node PLCSO5V WinNT terminated idle for more than 60 minutes SE SER for node PAULATHUIS Edit M Help SER doc vas Search the Internet with Google ae pa DSS Copy Text To Clipboard SER for node PLCSO5V Win j SER Filter gt divserver c Windo CUE var db2 fmed Jock file is temporarily unavailable SESSION 24891 CLIE Context menu on ActLog window Click on the right mouse button and the context menu opens with the following menu items Edit Message Help shows TSM help for selected message and allows you to add or change the popup message Search Internet open the default web browser and Googles the message number o Copy Text to Clipboard Filter Set Reset sets or resets a filter put on the data grid Filter Set Clear menu items allow the user to filter the data for specific data Refer to How to use the Filter function 102 Copyright O 2014 Reporter GUI 6 12 Browse Database Browse Database opens a window with a view to almost all database data To open the Info Browser window select the Info icon on the ribbon under the View tab aseqejeg Ey containing a copy of the Tivoli database Storage p You can filter and sort data Create your own queries and test them View Ribbon Tab with Browse Database sel
71. he item will be removed from the list and can be edited in the text boxes Delete select a email address and group name then click delete the item will be removed from the list Settings are saved with every change Copyright 2014 61 Reporter O Note Verify the group name in a schedule type OPERATIONAL The email information in the schedule might not update automatically 5 2 3 8 VM Settings Tab In the VM Settings tab you can enter the DNS or TCP IP address of the following components o Virtual Center VC gt Webinterface of a GSX VMWare server gt Any VMWare server or VI component above version 3 x is supported also vSphere 4 is tested This tab is used for creating an inventory of your VMWare Servers or VM vCenter for Asset reporting in Reporter Note To connect to VMWare version 4 the SDK webservices VI toolkit is used which is backwards compatible File Tools Help Number TSM Server Name 0 1 TSMSERVER Delete Server Address https 192 168 250 35 8333 sdk https 192 168 252 182 443 sdk https 192 168 250 33 8333 sdk https 192 168 250 35 8333 sdk https 192 168 252 182 443 sdk https 192 168 252 182 443 sdk https 192 168 250 33 8333 sdk Server Address plesvm02 ples nl plesdesx01 demo pics nl 192 168 252 186 plcsvm01 ples nl VM Type VMware Server 2 0 0 build 116503 VMware ESX Server 3 5 0 build 153875 VMware ESX Server 3 5 0 buil
72. he sorting rows page of the wizard column sorting and order can be changed Also on this page it is possible to specify a maximum number of results the show top value Enter a numeric value here e g 10 will show only first 10 entries returned from the query Copyright 2014 131 Reporter Shows the query for review SELECT NODE_NAME FILESPACE_NAME CAPACITY PCT_UTIL BACKUP_START BACKUP_END FROM FILESPACES WHERE dtindex SELECT MAX dtindex FROM FILESPACES AND NODE_NAME IN SELECT node_name FROM nodegroup WHERE nodegroup_name PLCS AND PCT_UTIL gt 80 The query review page allows you to change and validate the query Click Test Query to verify it a message box will popup and inform you about the result O Query was successfully executed In the Query Editor dialog behind the wizard the result of the query will be displayed Click next in case the query is satisfactory changes to the query can always be made laten 132 Copyright O 2014 Operational Reports Select Report Specifies which report to add the query Query text my operational In the last page in the wizard type a query caption text you wish to see in the report And select the report file you wish to add this query Click Finish now the new query is added to the report file and can be reviewed in the Query Editor dialog Edit Query To edit a existing query select a report file and the
73. ing reports generating HTML report emailing reports collecting information for the enterprise database and scheduling the VM and WMI agent The Reporter Collector is a Windows service application and cannot be started directly from the command line it can be started with net start Reporter Scheduler The program is configured by the Configuration Manager and is managed by the Windows Service interface To start or stop the Reporter Collector you can use the Configuration Manager The Configuration Manager can be found under the Start Menu All Programs PLCS Reporter Configuration Manager Select the Scheduler tab in the Configuration Manager the Reporter Scheduler is controlled by the buttons in this tab The Reporter Scheduler can also be started and stopped from the systems Computer Management interface File Action View Help 9 2hlS kab uA gt a n p 2 Computer Managem Name Description System Tools E3 Storage Ey Services and App SA Services ij WMI Control G SQL Server Ce Remote Procedure Call RPC L Manages the RPC name service datz 4 ReadyBoost Provides support for improving syst Services Remote Access Auto Connecti Creates a connection to a remote ne More Actions Remote Access Connection Ma Manages dial up and virtual private E Reporter Scheduler Remote Procedure Call RPC Serves as the endpoint mapper and More Actions S Remote Registry Enables remote users to m
74. istered trademarks of International Business machines Corporation Microsoft Windows and MS SQL are registered trademarks of Microsoft Corporation Tivoli and Tivoli Storage Manager are registered trademarks of Tivoli Systems Inc IBM VMware is a registered trademark of VMware Incorporated All other brand and product names mentioned herein may be trademarks or registered trademarks of their respective holders Contents Table of Contents Part Welcome 7 Part Il Disclaimer 9 Part Ill Introduction 11 1 Product OVerVie Wisconsin dei cacon csaa 12 2 System Requirements ccoonccccconnncccnononcccnonncnnnnnnnnnrnnnnnnnrr nro 13 3 Software Re quire me mts iii Ai dia dd 14 A Supported Database vi coccion cian artis scechandds Ai ir 15 Microsoft SQL Database iscciiscscesssiscscecosicissescssscecscectecnesbenvecotectcosscadesecuacesesterscisevessctesessessocussed esbesvetwedetiseeste 15 Part IV Installing 18 Important NOIE sci aa r ae A A a 19 2 A t maticInsta ll ti n id 22 Downloading the Package o ieaiao aenean aaaea rca 23 File Location Details of Script Installation Steps 3 Manual Installation and ConfiguratiON oommccconnnnccnnnnnnnnnnnnnnnnnnnnnnnn cnn nnnrr nn nnrrrrn nr 38 Dad 38 Reporter siecicsiecssnsevesccscetevicivecsscevasevsauceveucsvesnesiceveasecedenseresnsevsived etevvsiseussedsenbevsausevetesvessisiesbeustersandeveansrveiveveets 39 A CONQUE A A AA da AA di 42 License Requestinniicoi
75. ity Log 101 Add TSM Server 48 Administrative Rights 18 28 39 Application Components 47 Asset Management 145 Automatic Collection Schedules 60 Automatic Install Package 14 Automatic TSM collocation script 97 Average File Size 92 B Backup the Database 151 Browse Database 103 Cu Client Schedules 95 Compound Annual Growth Rate 118 Configuration Manager 48 Configuration Manager Configuration Tab 55 Configuration Manager Database Tab 58 Configuration Manager General Tab 54 Configuration Manager Logging Tab 57 Configuration Manager Scheduler Tab 59 Configuration Manager Tab Pages 53 Configuring ROR 126 Contacting Support 142 Creating Collocation Groups 97 D Database Report 112 Database Slide Window 70 Delete Reports 100 Disclaimer 9 Do not close SQL installer 31 Drives and Library Report 113 DRM Report 113 DSMADMC EXE 104 Sa E mail Configuration 64 154 E mail report 125 EULA 152 Exponential Growth Rate 118 Es Filter 108 Ce Generate Report 74 H History 99 How to create collocation groups 98 How to License 153 How to use the Filter 108 HTML File 125 Installing HCR 18 Installing Package 39 Introduction 11 Es License Request 44 Linear Regression 118 Log Report 114 Management Classes 95 Menu Activity Log 102 Menu Node Drill Down 91 Menu Node Info 91 Menu Node List 96 Menu Node Performance 93 Menu Time Line View 89 Microsoft on WMI 148 Microsoft SQL Se
76. lation including MS SQL Server Express and NET 3 5 SP1 Run time disk space depends on amount of data collected from the TSM server into the database s Requirements might vary between 1 GB to 4 GB per TSM server per year gt Any Ethernet adapter supported by the host operating system o 16 bit or 32 bit display adapter recommended with minimum resolution 1024 860 Recommended hardware for a PLCS Reporter server with 15 TSM databases are 2 processor cores and 2 GB RAM dependent on the server config a different license might be necessary for MS SQL o 30 TSM databases are 4 processor cores and 4 GB RAM dependent on the server config a different license might be necessary for MS SQL Also see How to License Copyright O 2014 13 Reporter 3 3 14 Software Requirements PLCS Reporter is available for the following Windows platforms One of the following Operating Systems is required 1 Windows 7 e Windows 2008 or Windows 2008 R2 gt Windows 2012 or Windows 2012 R2 The following software needs to be installed on the system prior to installing PLCS Reporter for IBM Tivoli Storage Manager gt NET Framework v3 5 SP1 or higher On Windows servers the NET 3 5 package must be installed through ROLES on the server http www microsoft com downloads dotnet framework 3 _5 SP1 SQL Server Express delivered with PLCS Reporter Or download the free version of Microsoft SQL server 64 bit http www microsoft cony
77. lected reports Report i Query Trending First monitoring date Trending Amount of data stored in primary pool at start date Trending Date 365 days ago from last monitoring date Trending Amount of data stored in primary pool 365 days ag Trending Last monitoring date Trending Amount of data stored in primary pool at end date Performance Trending Amount of days between first and last monitoring c Processing Trending Difference of amount of data Schedules Trending Occupancy over the complete period of all pools Security Trending Exponential growth rate over total monitoring perio Storage Pool Trending Compound Annual Growth Rate CAGR over tota gaas r L ISISISISSSSIS lt Ed Trending Trending Compound annual growth and exponential growth v Summary Trending Calculated linear regression slope MB day Y Summary Node Versions Volume 1 4 TSM V6 Trending Calculated linear regression yintercept MB Trending Trend using lineair regression for the following 2 ye Trending Graphical trend using lineair regression for the folle Trending Period of monitoring Trending Node count over the total period Trending Calculated linear regression slope node day Trending Report selection dialog 74 Copyright O 2014 Reporter GUI The tree window can be expanded or collapsed by clicking
78. lter will look something like this e g PLATFORM_NAME contains WinNT and LOCKED equal to NO OR Group1 PLATFORM_NAME contains Win32 Copyright O 2014 109 Reporter Quick Filter The quick filter function of PLCS Reporter can be used to filter information in some of the data grids The filter function is available for the following windows Node Performance Node List Activity Log Browse Database Right click on the column header of the data grid The following dialog will popup and you may select and type the filter you like to use Sample of quick filter popup on a data grid view It is possible to use multiple quick filters at the same time To clear the filters either click on the ribbon bar clear filter or in the right mouse popup dialog on one of the icons with a cross 110 Copyright 2014 Reporter 7 7 1 112 Reports In this chapter the Enterprise and Server reports that can be generated are explained In case you need a certain report please contact us through the support web site and make your request Server In this chapter the server specific reports that can be generated are explained Server Report The Server report Generate Report describes in short the current TSM server and connected TSM server s Database Report The Database report Generate Report describes all TSM database related information Database information like Size and utilization Frag
79. m a Osean Cumo Summary SELECT ae EM CR 5 ii opemimal Caton Sumay SELECT tam AD 7 i ovas Cuo Sumay SELECT Admite 4 m r New Que EatQuey DelteQuey ox cms Copyright O 2014 129 Reporter New Query To create a new query using the Query Wizard click on the New Query button in the Query Editor dialog Welcome to the Query Wizard This wizard will guide you through the query creation process Select the main table and columns for the query FILESPACES NODE_NAME FILESPACE NAME FILESPACE_ID FILESPACE_TYPE CAPACITY PCT_UTIL BACKUP_START BACKUP END DELETE_OCCURRED UNICODE_FILESPACE FILESPACE_HEXNAME In the next page select the table you want to use in the query and next select the columns you would like to see in the report query Click next for the next step query conditions 130 Copyright 2014 Operational Reports PCT_UTIL y gt ed NODE_NAME IN SELECT node_name FROM nodegroup WHERE nodegro In the query conditions page the WHERE clauses are added to the query Select the appropriate condition and click Add to add the condition to the query in one of the next pages you will be able to review the query and change it Click next when you are done adding conditions Specifies how to sort the query result Sorting column Sorting order In t
80. m16 msi InstallPackage MsilnstallProduct returned the result code RunMsiCore succeeded Checkpoint INSTALL_MSXML6_CPU32_ACTION Completed Action Install_Msxml16_Cpu32_Action returned True Install_sql_engine_core_shared_Cpu32_Action Target packag co 2 1e39566b3 hd bhaf 2662317192311 7 x86 setup sql_engine_core_shal red_msi sql_engine_core_shared msi Checking system Microsoft NET Framework version 3 5 SP1 is already installed Windows version 2663 Windows OS version 5 2 3790 Windows platform 32 bit Powershell is already installed Windows version 2663 Windows OS version 5 2 3790 Windows platform 32 bit Installer 4 5 or higher Redistributable is already installed Installing MSSQL 2668 Express MSSQL installation was succesfull After a successful installation you see the message that MS SQL installation was successful 32 Copyright 2014 Installing Welcome to the PLCS Reporter Setup Wizard This will install PLCS Reporter on your computer lt is recommended that you close all other applications before continuing Click Next to continue or Cancel to exit Setup As the next step the PLCS Reporter setup is started Press next to get the following step in the installation process License Please read the following important information before continuing Please read the following License Agreement You must accept the terms of this agreement before continuing with the inst
81. managing your IBM Tivoli Storage Manager servers PLCS Reporter is ideal for TSM performance validation Growth prediction Historic data review Conformity checks Auditing of policies Reporting on almost anything and more Enterprise reporting Charge back Software installed asset tracking Copyright 2014 3 2 Introduction System Requirements What do you need to get the most out of PLCS Reporter Take the following list of requirements as a starting point Like physical computers virtual machines running under e g VMWare generally perform better if they have faster processors and more memory The exact configuration you need to support your environment with satisfactory response time will vary depending on the size of the objects and other factors Individual display response times vary depending on workstation speed memory size of objects and network and server workload The following minimum configurations need to be evaluated and adjusted according to your unique requirements Disk space recommendations described here are for product installation and working space only The actual hard disk required varies depending on your installation Hardware for running Windows operating systems Minimum CPU 2 GHz Pentium processor or equivalent or higher D A minimum of 1 GB RAM advised is 2GB of RAM dependent on the server config a different license might be necessary for MS SQL 800 MB disk space for instal
82. mation from the bars hold the mouse pointer on top of the bar it will discolor then a pop up will show you information about the process mount or client activity 86 __Charttype _Informaton o Process numberandcount A EAS Q96 6 lt lt _S Start end time and duration ______________ Oooo Amountofdata S pel AAA AS Transfer rate Total media mount wait O TATI po Q 3 on Start end time and duration O OU Volume name S y O Ooo l bay y poo o oO O O Use data or database backup Session number and count OOOO Start end time and duration OOOO Amountofdata ss Transferrate oo Filesexaminedandaffected O ETA TI Ol Scheduled actual start if available ES EA fl Status if available Return code and reason if available Copyright O 2014 Reporter GUI Tape Mount Match Moving the mouse over a bar will allow you to a popup with more information about that process tape mount or client session shown in the graph o Reporter Report View Action Help D a Process STGPOOL BACKUP DISKPOOL gt BACKCOPY 282 OCS Www a mows Process count 1 Generate Charge Back Assets Generate Timeline Info Performance List Collocation Report Succesful YES L Enterprise il Server j Node History J Start time 13 02 2011 15 00 00 Timeline View TSMSERVER End time 13 02 2011 15 00 50 K Duration 00 00 50 Date 14 Febu
83. me of the tables are not processed by the Agent e g ARCHIVES BACKUPS CONTENTS tables This program can also be started manually from the command line e g AgentC exe k serverl Syntax AgentC exe k serverinstance Server instance name e g serverl f Optional Output to file instead of screen Client Agent The Client Agent is a Windows console program that connects to the Windows systems on the LAN and VMWare servers to extract information and insert this into the database When the Client Agent program is run for the first time it will create a database and create all necessary tables and fill them with the Windows Management Instrumentation WMI and VMWare information This program can also be started manually from the command line e g ClientAgent exe vm wmi logfile Syntax ClientAgent exe vm Perform Windows Management Instrumentation server data collection wmi Perform VMWare server data collection logfile Optional Output to file instead of screen Copyright O 2014 67 6 Reporter GUI Reporter GUI In this part PLCS Reporter graphical user interface GUI and all its functions and menu s are explained Before you get started make sure that you have a valid License File and that the Reporter Agent has run Start Reporter To start PLCS Reporter select from either the desktop the Reporter icon or from Start Menu All Programs PLCS Reporter Reporter When the Reporter has started you are prom
84. mentation Cache hit Volume configuration Trigger configuration Warnings and errors Historic data Copyright 2014 Reports 37 TSM database backup speed per date within 48 days KPages Hour and lower threshold 30000 25000 20000 15000 10000 5000 0 5 24 01 2010 31 01 2010 07 02 2010 14 02 2010 21 02 2010 28 02 2010 07 03 2010 14 03 2010 KPAGES_HOUR THRESHOLD Sample database backup performance chart with performance dip showing 7 13 Drives and Library Report The Drive and Library report Generate Report describes all TSM tape drive and library related information Drive information like Device list Offline drives and paths Drive utilization Number of tape mounts 7 days 28 days Media wait Drive errors Library information 7 1 4 DRM Report The DRM report Generate Report describes all Disaster Recovery Manager related information DRM information like 2 Volume count in various states gt Last database backup J Reuse delay of storage pools Copyright 2014 113 Reporter Errors on DR volumes Last prepare command and file 7 15 Log Report The Log report Generate Report describes all TSM log related information Log information like Size and utilization Warnings and errors Historic information Offline log volumes Database backup trigger Log mirror mode 7 1 6 Node Report The Node report Generate Report describes all TSM g
85. n For WMI queries are run to the Windows host using remote procedure calls Information is collected about physical components and also registry information which can be matched with information gathered within the PLCS Reporter SQL database Copyright 2014 Appendix 11 1 1 What is WMI Windows Management Instrumentation From Wikipedia the free encyclopedia Windows Management Instrumentation WMI or Windows Management Interface is a set of extensions to the Windows Driver Model that provides an operating system interface through which instrumented components provide information and notification WMI is Microsoft s implementation of the Web Based Enterprise Management WBEM and Common Information Model CIM standards from the Distributed Management Task Force DMTF WMI allows scripting languages like VBScript or Windows PowerShell to manage Microsoft Windows personal computers and servers both locally and remotely WMI is preinstalled in Windows 2000 and newer OS s It is available as a download for Windows 95 and Windows 98 2 Microsoft also provides a command line interface to WMI called Windows Management Instrumentation Command line WMIC 3 Purpose of WMI The purpose of WMI is to define a non proprietary set of environment independent specifications which allow management information to be shared between management applications WMI prescribes enterprise management standards and related technologies that work wit
86. n Windows Microsoft SQL server is a relational database management system that delivers data to its SQL data server clients You need to install a Microsoft SQL Server if you plan to use a database that resides on this computer For more information about MS SQL servers go to http msdn microsoft con en us library dd692930 v sql 10 aspx What are the restrictions for SQL Server Express O SQL Server 2012 R2 Express no charge non warranted Limited to lesser of 1 Socket or 4 cores No more than 1 GB of memory per instance Maximum relational Database size 10 GB Use Microsoft SQL 2012 R2 Express when possible Copyright O 2014 15 Reporter SQL Server 2012 is available in many editions to help meet the needs of your organization please check out http msdn microsoft com en us library cc645993 aspx 16 Copyright O 2014 Reporter 4 Installing Before beginning the installation verify that your system meets all Hardware Operating System and Software requirements This chapter discusses the following topics Installation Package Configure the Installation How to Request a License Add your License File Manual installation and configuration A Please review the release notes first i For release notes please refer to Release Notes txt file Copyright 2008 2014 PLCS E mail info plcs eu 18 Copyright 2014 Se O 4 1 Important Notes Disclaimer for CPU core detection with Windows XP SP2 o
87. n double click on the query in the grid or select the query in the grid and click Edit Query The following dialog will be shown some of the options here include Active or Inactive Row Yes will allow value comparison or No Report label text Query before TSM v6 x Query from TSM v6 1 and on Comparison lt gt lt gt gt lt like and not like Value comparison value When compare is true display as warning yellow or error red Copyright 2014 133 Reporter 134 hd Filespaces gt 80 of nodegroup PLCS SELECT NODE_NAME FILESPACE_NAME CAPACITY PCT_UTIL BACKUP_START BACKUP_END FROM FILESPACES WHERE dtindex SELECT MAX dtindex FROM FILESPACES AND NODE_NAME IN SELECT node_name FROM nodegroup WHERE nodegroup_name PLCS AND PCT_UTIL gt 80 In case the query needs to work on a TSM v6 x version the Query TSM gt 6 x box needs to be supplied The report generator will know which query to use when generating the report the user needs to provide the query in case this is different from before version 6 Delete Query To delete a query select a report file and then select the query in the grid and click Delete Query Copyright O 2014 Reporter 9 Troubleshooting This section contains information that may help you avoid or analyze a problem with PLCS Reporter Manual installing SQL Server C Reporter Scheduler CJ Reporter Agent 9 1 Manual installing SQL
88. nd client sessions To open the Timeline window select the Timeline icon on the ribbon under the Report tab Server group a A y y Repot View Action Help Pm 2 0 Generate Charge Back Assets Generate Ti Server Ya a l Info Performance List Colloc X Ddd Enterprise Opens a new window that shows all Tivoli Storage Manager server processes tape mounts and client actions as bars in a timeline graph aseqejeq Y Ribbon with Timeline item selected This Timeline window shows 24 hours of Server processing tape mounts and client activity in a Gantt style chart It allows you to go back in time or show multiple days of processing in the past up to 30 days in one view mn Aa Reporter Mi Report View Action Help L HM OCBGwawaw G Generate Charge Back Assets Generate Time Info Performance List Collocation j Node History Enterprise Server _ Timeline View TSM_BACKUP E HE aS us Date 03 March 2010 Gy Pastdays 2 Y Processes Y Mounts E Cients Y Synced Zoom E Show Active 8 Missed Processes 01 03 02 03 03 03 17 00 21 00 1 00 5 00 9 00 13 00 17 00 21 00 1 00 EXPIRATION i j E i i FULL DBBACKUP HM XENA MIGRATION DISKPOOLO1 H ji i H MIGRATION DISKPOOLO2 ae 1 i H E ua a MOVE DATA AVS230L1 gt DISKPOOLO1 mu H i j i MIGRATION DISKPOOLO1 OFFSITE RECLAMATION COPYPOOLO1 E E ae z ji
89. ndowsFeature as net framework gt gt temp psl echo on c Windows System32 WindowsPowerShell vl 0 powershell exe Stempfile echo off del Stempfiles REM Install MSSQL SQLEXPRWT_x64 ENU exe Configurationfile dp0 ConfigurationFile ini TAcceptSQLServerLicenseTerms QS REM Install Reporter pause End Copyright 2014 27 Reporter 423 Installation Steps Once you have downloaded all packages in a directory structure referal for more information A To install PLCS Reporter on a Windows system you need Administrative rights Unpack the files from the zip file C Reporter_Install Reporter_Install File Edit view Favorites Tools Help a Q Back 5 BL Search gt Folders ES gt I a Address la C Reporter_Install Reporter_Install Go 9550L_2008 File Folder 14 10 2009 15 36 5 Pre Requisites File Folder 14 10 2009 15 36 Reporter_Setup_2 3 0 4 exe 13 851 KB Application 12 10 2009 16 26 A setup cmd 1KB Windows Command 12 10 2009 17 55 A Run the setup cmd file 28 Copyright O 2014 Installing In case the system is completely patched the following output will be displayed Checking system Install_Reporter cmd is executed and it shows Checking system Microsoft NET Framework version 3 5 SP1 is not installed Pi Installing Microsoft NET Framework version 3 5 continue Extracting Files Extracting File To Directory c
90. niiiiia ii id ci 44 6 License File coco ntc deen 45 Part V Application Components 47 ROPA A A E aE FEE aE 47 2 Configuration Manager A s Remove TSM Server Tab Pages iiini General Tab Configuration Tabarca AA A A A A anne Logging Tab Database Tab Scheduler Tab cece Schedules Tab Operational Tabi e edi Asin en A a ieee enna VM Settings Tab WMI Settings Tab E mail Configuration 3 Reporter Scheduler oiicimomiai iii il 4 Rep rter Agentai iaraa aa Ear Ad 67 5 Client Agent sordei ena a AREE EEEE AREENA AREE EAEEREN EASE 67 Copyright 2014 3 Reporter Part VI 11 12 13 14 15 Part VII 1 2 Reporter GUI 69 RIDD ON carta ronca E E a a aaa acond 71 Generate RepOTbdiio conininiiica ii naaa aeva aa da Waaa visas sivas evened esse veer 74 Report Vie WE aa A iasucencaedecnaevessocsiameesuacexsunce taases a a aaa 76 MG MUS A cauevtoducvveaucnscedeusscedeverstivesdste 77 GROUPING A aicevsosvenscetexes cessive sees succes setrbaisersadccevssteetoeissiec ens 78 Charge Back cine cocoa anar cansa 80 Asset Node and CPU ica a aia 81 Assetand File Spaces a a a desa at 82 Timeline e e aao aE a tinea ines aa a aa EE aE E aa eE aao Eaa aa DENEA 84 A A O 85 MENUS csecedessetisesevesccsdettvvcsvecsacesacsensesteccecevesha a a raae rada Naaa Aa Eana raa araa aaa erdi raaraa sivas aiaa aada Naua Naaa Viat 89 Node iInf rmation iae a aa a eae ne aeaa Eaa diaa aaa KAA Eea ar ae
91. nnnnnnncnanenennnns 152 4 How to License ieia ai 153 Index 154 Copyright 2014 5 1 Welcome Welcome Thank you for choosing PLCS Reporter The powerful reporting tool for enterprise storage administrators e 1 made for Tivoli Storage Manager Real time accurate reporting alerting and trending for IBM Tivoli Storage Manager servers Make sure your Tivoli Storage Manager server is running smoothly In this User s Guide Getting started Product Overview System Requirements Supported O S Supported Database Automated installation Application Components Reporter Configuration Manager Reporter Scheduler Reporter Agent Copyright 2014 PLCS Reporter Generate a Report Activity in a Timeline Create Collocation Groups Client Node Drill Down Information Node Performance Info Activity Log Browser Charge Back TSM Command Line Enterprise Reporting Browsing the Database More Help Troubleshooting How to License EULA Agreement 2 Disclaimer Disclaimer PLCS Reporter for Tivoli Storage Manager software is provided as is and any expressed or implied warranties including but not limited to the implied warranties of merchantability and fitness for a particular purpose are disclaimed In no event shall PLCS or its contributors be liable for any direct indirect incidental special exemplary or consequential damages including but not limited to procurement of substit
92. ns provider TCP Provider error 0 No connection could be made because the target machine actively refused it Start the SQL Server Configuration Manager and verify if the SQL Server Network Configuration Protocols and TCP IP is enabled and the IP Addresses IP All TCP Port is assigned to e g 1433 Copyright 2014 137 Reporter 9 2 Reporter Scheduler The Reporter Scheduler is a Windows service application It cannot be started directly or from the command line The executable can be found in the same directory as the PLCS Reporter application and is called scheduler exe Install Automatically Starting the Configuration Manager will automatically register and start the Reporter Scheduler In case the Reporter Scheduler is not running the user will be prompted to start the service Install Manually In case the service is not visible in the Windows services list Reporter Scheduler you can register the scheduler application manually Open a DOS command line and change the path to the installation path of the PLCS Reporter application Install the scheduler perform on Windows command line scheduler exe install verify the scheduler log file in the same directory Other Commands Other ways to control the Reporter Collector using the Windows command line net start Reporter Scheduler net stop Reporter Scheduler Install scheduler exe install scheduler exe uninstall A file scheduler log i
93. ns group it is possible to exclude Activity Log messages from being collected into the database Type the text inside the box you wish to exclude separated by a semicolon e g REPORTER EXCLUDE MESSAGE The second option in the Exclude Options group allows you to exclude complete tables from being collected into the database This feature is commonly used when there is a error in on of the TSM tables a TSM database audit might be necessary This will have effect on the reports and or working of PLCS Reporter The last item in the Configuration tab allows you to remove Activity log entries from the database This option is configured in number of days and is used in case you like to expire old activity log entries Copyright O 2014 Application Components 5 2 3 3 Logging Tab The third tab in the Configuration Manager is the Logging tab This tab allows you to view the connection logs of the data collector agent and enterprise agent Select the TSM server instance you would like to configure from the list on the left 7 Configuration Manager File Tools Help Number TSM Server Name General Configuration Logging Database Scheduler Schedules Operational VM Settings wmi Settings 8 Date Log File File Check a 1 TSMSERVER 2010 0315 AGENT_SERVER1_15 L0G E 2010 03 14 AGENT_SERVER1_14 L0G 2010 03 13 AGENT_SERVER1_13 LOG 2010 03 12 AGENT_SERVER1_12 LOG 2010 03 11 AGENT_SERVER1_11 LOG
94. odes acquiring the information might take a moment Start from date 16 March 2010 Until date 17 Marh 2010 Node Performance Day Select Hide Column menu item will hide the column under the cursor when printing the data grid the column will not show up on the print or PDF Show All Columns menu item will unhide all columns that were previously hidden by the Hide Column command Filter Set Clear menu items allow the user to filter the data for specific data Refer to How to use the Filter function 94 Copyright 2014 Reporter GUI 6 8 Node List The Node List window shows you node occupancy backup copy group and scheduling information of all client node in one view To open the Node List window select the Info icon on the ribbon under the Report tab Node section Gathering all client node information might take a moment vy Reporter Report View Action Help a oa id a Ss Generate Charge Back Assets Generate Time Line Info Performance List Collocation iac A c Hi i Ple E elj Report ribbon tab with Node List selected The Node Performance window show you a data grid with information in relation to client node performance Node name TCP name TCP address Platform Domain Client version OS version Archive and Backup Occupancy primary and copy pool Total amount of objects files Archive Occupancy and number of files Amount of volumes in use primary and copy Audit oc
95. odify regi reporte Scheduler Reporter Scheduler Service staris eol Routing and Remote Access Offers routing services to businesses SeaPort Enables the detection download an Secondary Logon Enables starting processes under alt Secure Socket Tunneling Proto Provides support for the Secure Socl Security Accounts Manager The startup of this service signals ot S Security Center Monitors system security settings ar Gh Server Supports file print and named pipe s ServiceLayer Shell Hardware Detection Provides notifications for AutoPlay 4 SL UI Notification Service Provides Software Licensing activati S amp Smart Card Manages access to smart cards read g lt m Extended Standard Windows Computer Management interface Services management Select the Scheduler service Click stop to stop the Scheduler service Click start to start the Scheduler service For problems and troubleshooting the Collector refer to the section Troubleshooting Reporter Scheduler Copyright 2014 5 4 5 5 Application Components Reporter Agent The Reporter Agent is a Windows console program that connects to the TSM server by utilizing the TSM dsmadmc and queries the TSM server The meta data is then inserted into the local database using a ODBC driver When the Reporter Agent program is run for the first time it will create a database and recreate all TSM tables and fill them with the TSM meta data So
96. ommand Line can be run When the Reporter Agent program is run for the first time it will create a database and recreate all TSM tables and fill them with the TSM meta data Data from tables ARCHIVES BACKUPS CONTENTS is not processed as this would be too much information The executable is named AgentC exe and can be found in the installation path of the Reporter AgentC exe can be manually run from a Windows command line The syntax of the Reporter Agent when run from a Windows command line Syntax AgentC exe k serverinstance Server instance name f Optional Output to file instead of screen m Reporter enterprise database creation and collection Copyright 2014 Reporter 10 142 Contacting Support If you need further assistance with the PLCS Reporter contact PLCS Reporter Support To obtain the phone number for your region go to www plcs eu and click Contact us Customers with an active support agreement may submit their request via the PLCS Reporter Support Web site Go to www plcs eu and click Support PLCS support may request that you submit specific application information Use the user name and password you used previously login and select create new ticket When describing the problem please mention the version of PLCS Reporter and Windows platform Copyright 2014 Reporter 11 Appendix In this section samples how to license and other information related to PLCS Reporter 144 Copy
97. ons via methods The access to the manageable entities is made via a software component called a provider which is simply a DLL implementing a COM object written in C C Because a provider is designed to access some specific management information the CIM repository is also logically divided into several areas called namespaces Each namespace contains a set of providers with their related classes specific to a management area i e RootDirectoryDAP for Active Directory RootSNMP for SNMP information or RootMicrosoftIISv2 for Internet Information Services information To locate the huge amount of management information available from the CIM repository WMI comes with a SQL like language called the WMI Query Language WQL 11 1 2 Microsoft on WMI 148 What is WMI and what can it do for me Windows Management Instrumentation WMI is a core Windows management technology WMI can be used to manage both local and remote computers WMI provides a consistent approach to carrying out day to day management tasks with programming or scripting languages For example you can Start a process on a remote computer Schedule a process to run at specific times on specific days Reboot a computer remotely Get a list of applications installed on a local or remote computer Query the Windows event logs on a local or remote computer The word Instrumentation in WMI refers to the fact that WMI can get information about the internal stat
98. or the following windows Node Performance Node List Node Colloction Activity Log Browse Database Command Line The Filter Set function is available through the ribbon under tab View and shortcut keys ALT A S The Filter Clear function is available through the ribbon under tab View and shortcut keys ALT A C After selecting the ribbon button or pressing the shortcut keys the Filter dialog box will open Node Perform TSMSERVER ode_Name Start_Time Main Group Node_Name contains PLCS AND Data_Amount_Bytes Greater Than 1000000 Node_Name v contains w PLCS Data_Amount_Bytes v Sample of the filter dialog with filter set The Filter dialog box allow you to set complex filters with AND and OR operators 108 Copyright O 2014 Reporter GUI For instance you can filter on a list NODE_NAME contains NODE and DOMAIN_NAME equal to STANDARD Click OK to set the filter With the help of the filter dialog box you can create complex filters The items available to use in the filter are O perator both filter options must be true Operator each filter option must be true Removes filter from list at location Inserts filter into list at location Make Subgroup Creates a subgroup of operators Sets last filter E g Open the database browser and select NODES from the table list Then set a filter selecting from a list of not locked nodes all Windows machines and all Windows TDP s the fi
99. ove TSM Server Request License Key Server instance Exit TSM server name State Last time run Status File drop down menu of Configuration Manager Next you need to confirm the removal of the selected server Remove TSM server message The removed TSM server will no longer be on the TSM server list The data collection schedule in the Schedules tab the COLLECT schedule will be removed from the list 52 Copyright 2014 Application Components 5 2 3 Tab Pages The Configuration Manager uses a tab interface for the most common functions To configure and view a TSM server connection first select the TSM server instance on the left in the list Then select one of the tab pages the following tab pages are available General connection information and license information Configuration Configures the TSM connection aging Logging information of a TSM server data collection S Database connection management Scheduler Reporter Scheduler management chedules Schedules management for data collection report generation etc Operational Operational Email management VM Settings VMWare server connection management WMI Settings WMI account and connection management Copyright 2014 53 Reporter 5 2 3 1 General Tab The first tab is the General tab This tab page displays information about the selected TSM server Select a TSM server connection you would like to configure from the list on the left
100. pt to wait for instances of these event classes to be generated When your monitoring script receives one of these events the data tells you the provider involved the type of provider the query being processed and the namespace involved For more information go to http msdn microsoft com library default asp and search for Troubleshooting Classes Following is a sample script that troubleshoots problems with the Ping provider The script reports all the actions that take place as part of a Ping operation including such things as provider loading query receipt and error generation This information can help you determine whether the problems you are having occurred in the provider or in the WMI service In the output look for events where the ResultCode is not equal to 0 in general an error code other than 0 indicates that an operation failed Copyright O 2014 149 Reporter 11 1 3 Virtual Systems VMWARE VMWare is currently the only PLCS Reporter supported virtual system PLCS Reporter uses the VI toolkit of VMWare and it is possible that on a technical level everything is functional but might not be able to support any outstanding issues Existing MADE Future Applications VMware vCenter Suite Scalablity VMotion vShield Zones DRS Storage vMotion VMSafe Hot Add HA Fault Tolerance Data Recovery vStorage vNetwork VMFS Distributed Switch Thin Provisioning Internal Cloud External Cloud Currentl
101. pted to select a TSM server database in TSM server name TSM Server Name Database Alias License Expiration MCESERVER Address MCESERVE TSMSERVER Address TSMSERVER View mode No Address No Alias No License Select a database dialog Select a database and click OK Now the main user interface opens On the left side of the window you can see a tab named Databases This is a sliding tab holding the mouse pointer for a second the sliding window will slide open which allows you to select another TSM server database Copyright O 2014 69 Reporter Selecting Database To select another database mouse the mouse over the database tab To select double click the database or right mouse click and select click Select Database 7 Report View Action Help 2 92 030 Generate Charge Back Assets Generate Time Line Info Performance List Colle X Select a database from the slide tab window Database Slide Window In case the sliding window was closed use the Database icon on the ribbon menu bar to open the Database select window To auto hide the slide window click on the pin to make the window hide a Report View Action Help L 2089 4330 Richt e na TSM server name Database Name DNS IP Address Port Address License Expiration Generate Charge Back Assets Database select slide tab window pinned 70 Copyright O 2014 6 1 Reporter GUI Ribbon The
102. r next the Admin Command Line window will open The TSM command line allows you to give all TSM commands available 104 Copyright 2014 Reporter GUI View Action Help CNO a we Generate Charge Back Assets Generate Time Line Info Performance List Collocation Enterprise 2 o 5 El o D M 2 3 3 3 TS Search ative Command Line Interface Console Description ession re established with server TSMPLCS Cancel all client sessions Display CLIENT schedules Display database information Display information for unsuccessful Display information on all device clas Display information on the recovery log Display processor value unit estimate Query a collocation group Query activity log last 1 minute Query activity log last 10 minutes Query activity log last 5 minutes Query client node associations with a Query copy groups Archive Query copy groups Backup Query drives Query nodes Query path definitions Query processes Query sessions Query storage pools Query storage utilization of FILE direc Query system parameters Query the client option sets M Command line window with Commands dock window The TSM Command Line window has the following extra features History of commands by using up and down key or by using the command line drop down menu Line counter on the tsm label on the left bottom by holding the mouse down in
103. r Windows Server 2003 SP2 Hot fix KB932370 is required The number of physical hyper threading enabled processors or the number of physical multi core processors is incorrectly reported in Windows Server 2003 There is a 32 and a 64bits fix available Windows versions NumberOfLogicalProcessors and NumberOfCores property can not be used NumberOfLogicalProcessors and NumberOfCores property can not use in Windows XP Service Pack 2 and earlier In Windows XP Service Pack 3 NumberOfLogicalProcessors and NumberOfCores property is available In Windows Server 2003 Service Pack 2 and earlier NumberOfLogicalProcessors and NumberOfCores property is not available But applied KB932370 hotfix NumberOfLogicalProcessors and NumberOfCores property is available See The number of physical hyperthreading enabled processors or the number of physical multicore processors is incorrectly reported in Windows Server 2003 http support microsoft com kb 932370 In Windows Vista Windows 7 and Windows 2008 NumberOfLogicalProcessors and NumberOfCores property are available Important note for Windows XP SP3 SHAxxxCryptoServiceProvider error on Windows XP SP3 The MSDN documentation is right in the sense that it should be supported in XP SP3 by design and if it is not it s only because of a bug in NET 3 5 The constructors of SHAxxxCry ptoServiceProvider classes does not check the Prototype name and this is why it fails in Windows XP
104. rate Time Line nfo Performance List Collocation Report Enterprise Server Node History Ta Node Info TSMSERVER y 9 23 02 2010 20 17 58 BACKUP 3 88GB 286 530 ess lo o E 24 02 2010 20 27 88 BACKUP 1071GB 2880588 81 lo lo 25 02 2010 20 02 56 BACKUP 343GB 289 les Jo Cd 26 02 2010 20 07 51 BACKUP 312GB 288937 177 To To PLCSO3FS CMS IOMA ana W RACKIIP 224 2A MR 222 QWA 146 n n PLCS05_ARCHIVE_Di D PLCSO5V j 28 Data transfered in the last28 days GBytes PLCS10 20 157 ol gt 15 02 2010 18 02 2010 21 02 2010 24 02 2010 27 02 2010 02 03 2010 05 03 2010 08 03 2010 11 03 2010 14 03 2010 17 03 2010 Node Info windows in horizontal view with a node drill down report 90 Copyright 2014 Reporter GUI 6 6 1 Menus The Node Info window has a context menu on the data grid First select a client node then click on the right mouse button and the context menu opens with the following menu items Generate Node Report generates client node drill down reports of the selected node s 2 Generate All Node Reports generates client node drill down reports of all the selected nodes gt Vertical Horizontal View toggles between data grid vertical or horizontal view 104 a Generate Node Report Generate All Node Reports Vertical Horizontal View Di FCUM Node List context menu Select report Generate Node Report to generate a drill down report for the select
105. ration Logging Database Scheduler Schedules Operational VM Settings WMI Settings Settings Server address 192 168 222 125 TCP IP port number 1433 User Name sa Password AN The MS SQL connection configuration fields are filled in automatically if this is not the case please fill in the information The server address uses the DNS or TCP IP address do not use localhost or 127 0 0 1 In case the Configuration Manager is installed on the same system as Microsoft SQL Server 2012 R2 Express it will detect the communication port on the system For the database connection a default usemame and password is defined during installation The default user name and password are User name sa Password p sswOrd amp Copyright 2014 35 Reporter Then click on the test button If everything is configured correctly you will see the above message click Apply to save the settings After this section a TSM server connection can be added please refer to Add TSM Server section After a successful data collection you will see a message at the bottom which states Cleanup Agent The data collection is done setup PLCS Reporter 1501 xi Completing the PLCS Reporter Setup Wizard Setup has finished installing PLCS Reporter on your computer The application may be launched by selecting the installed icons Click Finish to exit Setup Press finish at the installation screen to end
106. ribbon tabs in PLCS Reporter are grouped by relevant commands Each ribbon item will be discussed in detail Most ribbon items are disabled when using the view mode of PLCS Reporter Report Ribbon Groups FR e Reporter A CLP OBS Generate Charge Back Assets Generate Time Line Info Performance List Collocation X X X Enterprise ii Server Node _ History _ Ra Ribbon with Report tab showing with keyboard shortcuts The Report item buttons have the following functions available d Database show the side bar if hidden which allows you to select another TSM database Quick Access Toolbar Enterprise Report Generate allows you to generate enterprise reports for a single or group TSM servers a Enterprise Charge Back allows you to calculate a charge back scheme for a single or group TSM servers Enterprise Assets allows you to manage your license assets for a single or group TSM servers Generate Server Generate Report allows you to generate a new report of the selected TSM server Server Timeline a graphical overview in time of all TSM activity gt Node Info Node Information allows you to get drill down information of a TSM client node Node Perf Node Performance show a list of last X days of backups performance information Node List Node List shows a list of all TSM client nodes for selected TSM server with average backup occupancy schedule backup copy group information
107. right 2014 11 1 Appendix Asset Management What is Asset Management IT asset management From Wikipedia the free encyclopedia all rights and c Wikipedia IT asset management ITAM is the set of business practices that join financial contractual and inventory functions to support life cycle management and strategic decision making for the IT environment Assets include all elements of software and hardware that are found in the business environment Contents 1 Hardware asset management 2 Role of IT asset management in an organization 3 Goals of ITAM 4 Process Hardware asset management Hardware asset management entails the management of the physical components of computers and computer networks from acquisition through disposal Common business practices include request and approval process procurement management life cycle management redeployment and disposal management A key component is capturing the financial information about the hardware life cycle which aids the organization in making business decisions based on meaningful and measurable financial objectives Role of IT asset management in an organization The IT Asset Management function is the primary point of accountability for the life cycle management of information technology assets throughout the organization Included in this responsibility are development and maintenance of policies standards processes systems and measurements that enable
108. right 2014 Reporter GUI 6 11 Activity Log The Activity Log window provides information about activity of the client and server To open the Activity Log window select the ActLog icon on the ribbon under the View tab Select Browser Opens a new window containing the Tivoli Storage Manager activity log You can filter and sort data from the activity log View Ribbon Tab with Activity Log selected Activity Log TSMSERVER From 12 49 le 12 02 2011 Ey Until 1249 la 1402772011 By Prev Nex Show Al Wamings amp Erors Erors Show last hours _ aseqejeg Ey Date_Time Msgno Se 25 1 W A Warning Server Message ANRO480W ethan 60 minute 12 02 2011 15 03 2111 W Session session number for node node name client platform z terminated connection with client severed SSION 24704 PROC SERVER Explanation The specified client session is ended because the communications link has been closed by a network error or by the client ESSION 24704 PROC SERVER program 12 02 2011 15 07 9678 V 12 02 2011 17 01 96 W 12 02 2011 18 02 482 W 12 02 2011 20 06 4042 ANE4042E Object name usr share doc console ools examples contains one or more unrecog CLIENT PLCS CRM System action Server operation continues table A server is cure SERVER User response If a user breaks out of a client progr
109. round icon on the left bottom of the chart Copyright O 2014 77 Reporter 6 2 3 78 Grouping There are two grouping options one for creating groups of TSM servers and one for TSM nodes These server and node groups are not created on the TSM server only on the MSSQL database Servers Grouping To create TSM server groups click on the Servers icon on the View Ribbon Tab Database TD View Ribbon Tab with Grouping selected The Grouping dialog window allows you to group several TSM servers into a group for Enterprise reporting It is possible to create as many groups as needed and a TSM server can also be in multiple groups The procedure to create a servers group is as follows e Click the Servers grouping icon on the view tab e Type or select a group on the right top selection box e Then add TSM servers on the left side that you like to have in the group by either double click or Add button You may add a group description on the bottom right e Then click Save the group is saved and dialog window is cleared Copyright 2014 Reporter GUI Select server name Type a new group or select one Server Name Database Name Address Server Name TSMSERVER TSMPLCS 192 168 250 3 TSMSERVER TSMPLCS Database Name Group description PLCS TSM Servers Sample of Servers grouping dialog window Nodes Grouping To create TSM node groups click on the Nodes icon on the View Ri
110. rver 2008 15 Microsoft SQL Server manually 136 MS SQL Backup 151 Network Transfer Speeds 92 Copyright O 2014 Newly Created Instance 54 Node Collocation 97 Node Drill Down 90 Node Information 90 Node List 95 Node Performance 92 Node Report 114 0 Occupancy Report 114 Operational Reporting 125 Operational Reporting Schedule 62 P Performance Overview 92 Performance Report 115 Processing Report 116 Product Overview 12 Query Editor 128 Query Wizard 128 R Remove TSM Server 52 Report History 99 Report Sections 76 Report Sections Context Menu 77 Report Tree Context Menu 77 Report Viewer 76 Reporter 47 Reporter Agent 67 Reporter Collector 66 Reporter GUI 69 Reports 112 Restore Report 120 Ribbon Color 106 Ribbon Menu 71 ROR 125 Su Save or Load Report Selection 75 Schedules Report 116 Security Report 116 Selecting Database 70 Copyright 2014 Index Selecting Report Section 76 Server Report 112 Settings 106 Software Requirements 14 Start Report Generation 75 Start Reporter 69 Storage Pool Report 117 Supported Database 15 System Privilege 50 System Requirements 13 Ta Terms and Conditions 40 Time Line View 85 Timeline 84 Timeline Context Menu 89 Top 10 106 Top 20 106 Top3 106 Trending Report 118 Troubleshoot Agent 140 Troubleshoot Scheduler 138 Troubleshooting 136 TSM Command Line 104 V Versions Report 117 View TSM activity log 85 Virtual Systems 150
111. s created when executing the install and uninstall functions The file can be opened with notepad to verify that the service was correctly installed or removed 138 Copyright 2014 Scheduler Restart Troubleshooting In case the Reporter Scheduler service has not started after a Windows reboot make sure the service is set to Automatic or Automatic with Delay in case the database services need more time to start ties Local Computer LOcd Log On Recovery Dependencies Service name Scheduler Display name Reporter Scheduler ition Reporter Scheduler Service starts collection Description ad reporting and other processes Path to executable D data projects Manager Manager bin Debug Scheduler exe Startup type Automatic Delayed Start Help me confiqure service startup options Service status Started You can specify the start parameters that apply when you start the service from here Reporter Scheduler service properties Copyright O 2014 139 Reporter 9 3 140 Reporter Agent The Reporter Agent is a command line Windows application It connects to the TSM server through the TSM admin command line queries the TSM server tables and inserts that information into the database this is done though the ODBC driver It is regularly started by the Reporter Scheduler service A TSM server connection needs to be configured before Reporter Agent C
112. s of TSM servers Click on the Asset button and the group selection dialog opens select a TSM server group from the list and click OK The file space and local drive match will now open a window and start matching the TSM file spaces with the local drives 82 Copyright 2014 Reporter GUI Matching is done by using the WMI and VMware server information in the Reporter database Action Help dd ET Info Performance List Collocation Status a Server_Name Node_Name Host_Name TCP_Address Last_Access_Time Tsm_Filespace_Na Local_Drive No TSM Filespace TSMSERVER REPORTER DEV reporterdev 192 168 250 166 No TSM Filespace TSMSERVER REPORTER DEV reporter dev 192 168 250 166 SM Match VM TSMSERVER TRAC 192 168 250 11 25 08 2010 04 59 usr TSMSERVER TRAC 192 168 250 11 25 08 2010 04 59 home TSMSERVER TRAC 192 168 250 11 25 08 2010 04 59 TSMSERVER DJVSERVER 192 168 249 1 25 08 2010 05 36 divserver e TSM Match VM TSMSERVER DJVSERVER 192 168 249 1 25 08 2010 05 36 divserver c TSM Match WMI TSMSERVER ROCSSERVER 192 168 248 1 25 08 2010 07 24 rocsserver f TSM Match WMI TSMSERVER ROCSSERVER 192 168 248 1 25 08 2010 07 24 rocsserver e E TSM Match WMI TSMSERVER ROCSSERVER 192 168 248 1 25 08 2010 07 24 Wwocsservenos C TSM Match WMI TSMSERVER PLCSKO1 192 168 250 12 25 08 2010 08 28 plcsk01 es E TSM Match WMI TSMSERVER PLCSKO1 i y 192 168 250 12 25 08 2010 08
113. s wizard helps you configure a new TSM server connection Before you start find out the TSM server DNS IPaddress and Port address Clicking Next will contact the TSM server TSM Server address TCP IP or DNS name tsmserver company com TCP IP port number 1500 Fill in the TSM servers TCP IP address or DNS address and change the port address in case the default port 1500 was changed then click Next The connection is verified If this is incorrect you will see the following message x TSM server address is incorrect verify settings 0h Message when TSM connection test fails Copyright 2014 49 Reporter Change the settings to reflect the accurate TSM connection The next wizard page is displayed Fill in the account settings that you using to connect to the TSM server An account with System Privilege is necessary The password is encrypted and kept in the Windows registry A It is recommended to create a separate TSM user account for this purpose with System Privilege e g reporter The TSM user account must be a admin account Fill in the user name and password click Next to validate The database will be created with the following name Provide a database name SERVERO Fill in a database name MS SQL for the data of use the suggested name 50 Copyright 2014 Application Components Add a Tivoli Storage Manager Server Wizard has finished The TSM connection w
114. sabled when it is stopped stop the running Scheduler service Show log will query the Windows Event log for events of the Scheduler service Reset will reset the Reporter Agent start date and restart the Scheduler service 59 Reporter 5 2 3 6 Schedules Tab The Scheduler tab in the Configuration Manager is used for scheduling processes for data collection report generation operational report email generation enterprise reporting WMI and VMWare data collection The schedule type COLLECT are automatically added and removed from A the schedules A user can only adjust the moment they execute or deactivate them File Tools Help Number TSM Server Name General Configuration Logging Database Scheduler Schedules Operational VM Settings WMI Settings 0 1 TSMSERVER Number Type Entity Start Time Period Units Period 2 MCESERVER COLLECT TSMPLCS 2010 06 21 08 00 00 COLLECT MCESERVE 2010 06 21 08 00 00 COLLECT REPORTER 2010 05 26 10 00 00 OTHER VM_WMI 2010 05 01 06 00 00 Sample of Configuration Manager with Schedules tab open The following types of schedules can be added or configured in the Schedules tab COLLECT cannot be added or removed by user are generated by adding a TSM server connection OPERATIONAL are added by user to generate a operational HTML report GENERATE are added by user to generate a enterprise server or node Reporter repor
115. se Liniear regression for next 2 years 7 25 Processing Report The Processing report describes all grouped TSM servers processing related information Processing information like El Total amount of data per day gt Total amount of backup and archive data per day a Failed processes over last 48 hours 7 2 6 Schedules Report The Schedules report describes all grouped TSM servers and their client schedule related information Schedules information like gt Pie chart of status over last 28 days El Total status count chart of last 28 days 7 2 7 Volumes Report The Volume report describes all grouped TSM servers volume related information Volume information like 2 Scratch and private distribution a Last recorded scratch and private count Chart of the total amount of volumes per device class 7 2 8 Client Report 122 Copyright O 2014 Reports The Client report shows the amount of client nodes registered during the last months Client information like Total client nodes registered per month Ld Total client nodes registered in last 3 months a Chart of total client nodes registered on TSM server group Copyright 2014 123 Operational Reports 8 8 1 Operational Reports Since TSM version 4 x IBM was providing a free reporting tool named Tivoli Operational Reports TOR This product was able to generate a HTML based report with fixed numbers and details The report was generated by a query on the TSM da
116. slations of the Software except as permitted by applicable law without the possibility of contractual waiver and shall not have the right to disclose the Software except as permitted therein Buyer is prohibited from the making of a copy of the Software except for backup and archival purposes Buyer is not authorized to sublicense rent lease assign or otherwise transfer this Software Buyer is authorized to use the Software on one machine only at any one time Software is considered to be in use for purposes of this agreement when it resides in or otherwise is stored on a machine All Software components acquired from Seller s Third Party suppliers are copyrighted and licensed not sold and title to the Software components are note transferred to Buyer SELLER DISCLAIMS ALL WARRANTIES WITH RESPECT TO SOFTWARE COMPONENTS PROVIDED BY ITS THIRD PARTY SUPPLIERS INCLUDING THE IMPLIED WARRANTIES OF MERCHANTABILITY NON INFRINGEMENT AND FITNESS FOR A PARTICULAR PURPOSE SELLER DISCLAIMS ALL LIABILITY FOR LOST REVENUES LOST PROFITS LOST SAVINGS OR ANY OTHER INCIDENTAL SPECIAL OR INDIRECT CONSEQUENTIAL DAMAGES EVEN IF ADVISED IN ADVANCE OF THE POSSIBILITY OF SUCH DAMAGES SELLER DISCLAIMS ALL LIABILITY FOR LOSS OF OR DAMAGE TO RECORDS OR DATA SELLER DISCLAIMS ALL LIABILITY FOR UNINTERRUPTED OR ERROR FREE OPERATION SELLER S LIABILITY IS LIMITED TO A REASONABLE AMOUNT NOT TO EXCEED THE AMOUNT THAT WAS PAID BY BUYER FOR THE
117. soft SQL Server open the SQL Server Configuration Manager and open the branch for Network Configuration e Right mouse click on TCP IP and Enable the protocol you need to restart the SQL service e Double click on the TCP IP protocol entry and select the IP Addresses tab page scroll down and verify the TCP dynamic port you need this address later Complete the next steps Open the SQL Server Management Studio and select the root click with right mouse on properties Select the security page and select SQL server and Windows Authentication mode and click OK Select in the tree the Security branch and right mouse click in the Logins Summary Tab e Select New Login In the dialog Login New type a new login name e g reporter and select SQL Server authentication Choose a password and confirm the password e g p sswOrd amp Uncheck Enforce password expiration and User must change password at next login Select the Server Roles page and check dbcreator Click on the OK button Now you can install Reporter software and validate the connection with the PLCS Reporter Configuration Manager Copyright 2014 Installing 4 3 2 Reporter Copy the PLCS Reporter Installation Package to the machine or run it directly from its current path The installation package is provided together with Microsoft SQL Server package When installing PLCS Reporter manually Microsoft SQL Server will not install automatically please install MS
118. t e OTHER are added by user ot automatically by VM WMI for scheduling data collection Notes and rules for schedules All schedules can be set to either Active or InActive The scheduled time and date can also be changed After changing a schedule click Apply It a schedule is running the schedules cannot be changed Schedules type COLLECT are added and removed automatically when adding or removing a TSM server connection 60 Copyright O 2014 Application Components e A Reporter Collect is by default created to do data gathering for the enterprise database e Default a COLLECT type schedule is performed once a day by decreasing the execute period data collection can be performed several times a day 5 2 3 7 Operational Tab The next tab in the Configuration Manager is the Operational tab This tab page is a management page for the configuring Email addresses for mailing the HTML reports a File Configuration Manager Tools Help Number 0 1 2 TSM Server Name TSMSERVER MCESERVER General Configuration Logging Database Scheduler Schedules Sample of Operational tab Group E mail adress es E mail Address es info company com The following functions are available Add type a group name and an email address or multiple seperated by a semicolon click Add Edit change the group name and or the email address t
119. t is also possible to run the update manually e g ClientAgent exe vm 42 Copyright 2014 Installing Add WMI Settings The WMI tab offers Asset information about Windows servers on the LAN through WMI To add a WMI servers scan click on the WMI Settings tab e Add a domain name e Type in a user with enough rights e And the password of this user e Click Add e Click Save Then you need to add a IP address IP address range or All TSM server addresses and select the user ID from previously added account Then click Add and the Save The ClientAgent will then read the config and query the added connections The ClientAgent is scheduled on the first Saturday following the installation Check the Schedules tab for a type OTHER schedule and database name VM_WMI It is also possible to run the update manually e g ClientAgent exe wmi To use the PLCS Reporter application with the newly created database you need a license or demo key Please refer to the next section License Request Copyright 2014 43 Reporter 4 5 License Request For using the software a license per TSM server instance is needed e g 2 TSM servers means 2 license keys for PLCS Reporter even if the TSM server instances are situated on the same hardware Requesting a license key can be done through the Configuration Manager or by E mail Without a license key you can use the PLCS Reporter only in View Mode no reports can be generated T
120. tabase and the output convert into HTML pages Beside having the HTML output on the report system the report could be E mailed IBM released a new version of TSM version 6 and support and functions for TOR are based on TSM5 5 and will not be upgraded to TSM version 6 Customers who did like to use the functionality of TOR can now with our Reporter release 2 4 and higher use this based on data collection with the Agent and report generation is done on the MS SQL database The TSM server s are not queried for these HTML reports Operational Reporting has been created in the same way as IBM has created this on request of our customers The main difference is that this reports is kept in HTML purely as figures and numbers without any graphics as Reporter offers this functionality already HTML File The Operational Reports can be mailed and can also be found in the report file path and can be opened with a web browser After opening the HTML file with a web browser the page is by default shown in a folded form Click the plus sign or expand all to show all report sections Expand All Collapse All ITEM RESULT Last Activity in Database 2009 12 03 08 02 52 Administrative Schedules Successful 5 Administrative Schedules Errors D Administrative Schedules Failed 0 Administrative Schedules Missed 0 Client Schedules Completed with No Errors 9 Client Schedules Failed Total Number of Volumes Except DISK devclass Num
121. tional to the function s current value Such growth is said to follow an exponential law the simple exponential growth model is known as the Malthusian growth model For any exponentially growing quantity the larger the quantity gets the faster it grows An alternative saying is The rate of growth is proportional to the state of growth The relationship between the size of the dependent variable and its rate of growth is governed by a strict law of the simplest kind direct proportion It is proved in calculus that this law requires that the quantity is given by the exponential function when using the correct time scale This explains the name Formula used to calculate rate r In Amount last day Amount first day Total days 365 Rate times 100 is the growth rate in percentages Compound Annual Growth Rate Compound Annual Growth Rate CAGR is a business and investing specific term for the geometric mean growth rate on an annualized basis CAGR is used to describe the growth over a period of time of some element of the business usually revenue although other measures may be used such as the number of units delivered registered users etc CAGR is not an accounting term but remains widely used particularly in growth industries or to compare the growth rates of two investments because CAGR dampens the effect of volatility of periodic returns that can render arithmetic means irrelevant CAGR is often used to describe the growth ov
122. troduction Welcome to the PLCS Reporter manual This manual contains information that you need to install configure maintain and use the PLCS Reporter product This chapter discusses the following topics Product Overview System Requirements Software Requirements Supported Database Copyright 2014 11 Reporter 3 1 12 Product Overview PLCS Reporter is a reporting and monitoring tool for IBM Tivoli Storage Manager PLCS Reporter for IBM Tivoli Storage Manager TSM keeps an eye on your TSM environment when you cant Reporter provides live data gathering and one button analysis reporting and trending of your critical backup servers and clients PLCS Reporter s data collection process runs continuously to capture data from your TSM servers and store it in its own database Reporter uses that data to provide reports and alerts of your server environment and to generate reports for problem analysis trending hardware utilization statistics and configuration inconsistencies Since Reporter uses its own database to analyze data and generate reports your TSM servers are not impacted by long running queries or select statements The historical views provided by PLCS Reporter of your TSM environment and operations are a great troubleshooting and problem determination tool for hard to diagnose problems like intermittent client or process failures and network bandwidth issues With PLCS Reporter you spend less time monitoring and
123. ul test Then refer to Add TSM Server to add a new TSM server connection After the wizard has closed a update schedule has been added to the Schedules tab with type COLLECT and the database name Also a schedule to update the enterprise database Reporter To view the settings of the added TSM server connection select the TSM server on the left in the list Select the Scheduler tab in the Configuration Manager and check if the Scheduler has been installed and started If prompted click Yes this will start the Scheduler Service Data collection of the TSM server should start within a few minutes You can verify that data collection has started in the Logging tab of the Configuration Manager If this is not the case please refer to the section Troubleshooting Add VM Settings The VM tab offers Asset information for VMware servers and Virtual Center To add a VMware server select the VM Setting tab and type e Server address IP or DNS name with its port e g 192 168 1 120 8080 e User name e Password Then click add the connection and password will be verified and the server address will be extended e g https 192 168 1 120 8080 sdk to use the VM SDK Click Save to store this information The ClientAgent will then read the config and query the added connections The ClientAgent is scheduled on the first Saturday following the installation Check the Schedules tab for a type OTHER schedule and database name VM_WMI I
124. ute goods or services loss of use data or profits or business interruption however caused and on any theory of liability whether in contract strict liability or tort including negligence or otherwise arising in any way out of the use of this software even if advised of the possibility of such damage The information herein is believed to be accurate However neither PLCS nor its successors or assigns may be held liable for any loss or damage customers may incur as a result of errors contained herein The implementation of these techniques is the customer s responsibility and depends upon the customer s ability to evaluate and integrate them into the customer s environment PLCS will provide best endeavors to support for PLCS Reporter with the current and future releases of Tivoli Storage Manager If you have any suggestions or questions do not hesitate and send us an email info plcs eu The software updates documentation enhancements and obtain further information can be downloaded at www plcs eu PLCS Reporter documentation is distributed in HTML and Adobe Acrobat format Any information published in this manual or on any public information is copyright by PLCS and may not be used in any other form or any other way without written permission PLCS Reporter for TSM is a registered trademark of PLCS based and or represented in The Netherlands Belgium Germany France and Ireland Copyright 2014 9 Introduction 3 In
125. utomatic installation package Sizes and date stamps may differ with other versions Files and directories 12 10 2009 21 46 509 692 047 Reporter_Install zip FULL PACKAGE Expands into 14 10 2009 11 11 lt DIR gt Reporter_Install Directory of C Install Reporter_Install no spaces in the directory name 14 10 2009 10 53 lt DIR gt 14 10 2009 10 53 lt DIR gt 09 10 2009 15 02 lt DIR gt MSSQL_2008 09 10 2009 15 02 lt DIR gt Pre Requisites 12 10 2009 16 26 14 182 473 Reporter_Setup_2 3 0 4 exe 12 10 2009 17 55 462 setup cmd 7 File s 523 874 096 bytes Directory of C Install Reporter_Install MSSQL_2008 15 02 lt DIR gt 15 02 lt DIR gt i 18 30 1 788 mssql2008 vbs 16 00 4 753 sql 2008 express ini 15 01 229 169 680 SQLEXPRWT_x86_ENU exe 3 File s 229 176 221 bytes Directory of C Install Reporter_Install Pre Requisites 09 10 2009 15 02 lt DIR gt 09 10 2009 15 02 lt DIR gt i 09 10 2009 15 03 lt DIR gt net35sp1 09 10 2009 15 01 lt DIR gt pwrshell 09 10 2009 15 20 828 server_test vbs 09 10 2009 15 02 lt DIR gt wininst45 1 File s 828 bytes Directory of C Install Reporter_Install Pre Requisites net35sp1 09 10 2009 15 03 lt DIR gt 09 10 2009 15 03 lt DIR gt ve 242 743 296 dotnetfx35 exe 1 855 net35sp1 vbs 2 File s 242 745 151 bytes Directory of C Install Reporter_Install Pre Requisites pwrshell 09 10 2009 15 01 lt DIR gt 09 10 2009 15 01 lt DIR gt Copyright 2014 12 10 20
126. y supported platforms are ESX virtual center VC and VMWare servers PLCS Reporter has successfully been tested with Virtual Center VC 3 5 4 0 and 4 1 VMWare Server 1 and 2 150 Copyright 2014 Appendix 11 2 Backup Database This section only applies to PLCS Reporter with a MS SQL database Make sure SQL Server Management Studio is installed on the MS SQL database server SQL Server Management Studio Express is free of charge To use go to http www microsoft com en us default aspx and search for SQL Server Management Studio download and install the software To perform a manual backup to disk open the SQL Server Management Studio via the Start Menu connect and open Databases folder Select the database that you like to backup and then right click with the right mouse button and select Tasks Backup a dialog window will open verify the settings and click OK Copyright 2014 151 Reporter 11 3 End User License Agreement This Software License Agreement Agreement is entered into between PLCS and the Customer Computer programs provided by the Seller constituting or incorporated in Products together with updates enhancements and new releases or versions thereof provided hereunder collectively Software are provided to Buyer under a non exclusive worldwide license subject to the following terms a Buyer shall not have the right to modify reverse assemble reverse compile or make other tran

User's Guide PLCS Reporter

Contents

Download Pdf Manuals

Related Search

Related Contents