Upgrading from TSM Studio Server V2 to TSM Studio Server V3
TSM Studio Server V3 requires new licenses, if your support maintenance is up-to-date or you have purchased TSM Studio Server after the 1st of August 2013 then the licenses are free of charge, for all other TSM Studio Server V2 customers the upgrade cost is 75% of the full price.
We will be issuing licenses to eligible customers over the coming months. If you would like your upgrade keys sooner please send an email to licensing@spiritsoftware.biz
Configuring access to the database has changed so please read the installation instructions found here https://www.spiritsoftware.biz/tsm-studio-documentation/. But you can point to your version 2 database. TSM Studio Server V3 will upgragde the database the first time it connects to the database.
TSM Console Manager Web Edition – Release Notes
Requirements:
Dotnet Framework 4.5
IBM TSM Admin Client
Cookies Enabled
NOTE:
IIS is NOT required
Point the brower to http://hostname:9000/TSMConsoleManager
Intial login is admin and the password is also admin
Currently Implemented Features
View Console for single TSM Servers
Setup Color Filters
Show Sessions
Show Processes
Submit TSM Commands
Configuration GUI
Changing admin password
Active Directory Support
Auto Column Sizing
TSM Server Group Support
SSL Support ( We will have a document out shortly on how to set this up, for those tech savy, use the netsh command to assign the certificate to the port )
Exclude Message Filter
Features not yet Implemented
Saving Column Sizes
TSM Studio Server – Whats New
- Improved Alerts Console performance
- Improved performance when collecting data from TSM Servers
- Added Alert Email Rate Limiting
- Added Ability to request data for custom reports
- Added Client Total Data Backed up With Duration Datasource
- Added Health Check Reporting
- Fixed Issue that the worksheet name was unable to be edited in the Multi-Worksheet Excel scheduler
- Backend Service will now retry to reconnect to database if it is not available at service startup
- Fixed Issue with MYSQL displaying open datareader error
- Added Chronic Backup Failure Report
- Fixed Issue with Real-Time alerts not shutting down dsmadmc processes when closing down
- Added Replication Datasource
- Added Replication Alert
- Added new Themes and Color support
- Added Capacity Used Datasource
- Added Failed VMWare Backups Alert
- Added Failed Non-TSM Scheduled Backup Alert
- Added Non TSM Scheduled Backup Datasource
- Added Ability to Schedule multiple datasource reports and have each one on a separate worksheet in the excel spread sheet
- Fixed issue with report template datasource dates not always showing correctly
- Added new reporting only role
- Fixed Issues with Alerting Console when more than 3000 alerts
- Added new datasource – Consolidated Backups
- Added ability to run heartbeart alert across multiple interfaces on the same TSM Server
- Fixed Issue with Client Node Groups Filespaces sometimes displaying key not found message
- Added new datasource – Client Schedule Results with Missed File
- Fixed Issue with some charts displaying no data available message
- Fixed issue with Session times collection
- Fixed Issue that was causing Kill Collector to return null object reference message
- Added Collection Hung Alert
- Added Collection completed with Errors Alert
- Added Memory Utilization Alert
- Fixed Issue with date format when collection Data Domain performance streaming data
- Added Alets Audit Log to show all emails sent from alerts and if there were any errors while sending the email
- Added SMTP SSL Support
- Fixed Null Object Exception when updating SMTP configuration for the first time
- Fixed Issue with Email Groups not showing up on on Alert Notifications
- Added ability to create static client groups by importing a client list
- Fixed issue with saving to disk
- Fixed issue with some dataviews not opening
- Improved Performance of Data Purging Routines
- Added Standalone Data Purging Application
- Fixed issue with Email groups not persisting when creating datasource and sql query schedules
- Fixed issue with TSM Query commands not running when using the short form ‘Q’ instead of Query
- Updated System Stats charts Memory, CPU and Disk to allow selection of a date range
- Added retry interval option for TSM Server Heartbeat check
- Fixed Issue with some alerts not triggering
- Add dotnet framework to install package
- Fixed issue with occupancy collections
- Updated Data Domain Retry Functionality
- Cleaned Up messages in Log File
- Fixed Issue with Activity Log Filters not running when Activity Log Collector is disabled
- Added Individual and Multi Client Node Details dataview
- Added Client Node Detail Changes dataview to show the changes to a Client Node status over the select period
- Fixed Issue with Forward Forecasting in Charts
- Fixed Issue with Series Click Thru’s in Charts
- Fixed Issue with no licenses available when editing sql queries
- Fixed Issue with report templates asking to change bindings to expressions when opened
- Fixed Issue with Installer resetting modified logon for TSM Studio Server Service back to LocalSystem on each upgrade (NOTE: Upgrading to this version will still exhibit the same issue, but for future upgrades the windows service logon will be left unchanged)
- All Report Type Outputs (including Report Templates, SQL Queries and Data Sources) can now be scheduled to be saved directly into the backend database for later viewing
- Fixed Issue when disabling Real Time Alert Filters
- Added Trace option to Real Time Alerts
- Fixed issue with Realtime Alerting
- Fixed Performance Issue with Enterprise–>Client Nodes dataview
- Fixed some Performance Issues
- Fixed issue with click-thru’s on chart displays
- Fixed issue with chart markers not showing on initial display of a chart
- Fixed Issue with Library Volumes Collector not populating the Total Counts field correctly
- Fixed Issue with reports publishing using the HTML Embedded option displaying the same data multiple times
- Added Data Domain Health Check Summary Data Source
- Added Alert to show Current Data Domain Alerts that the Data Domain is current reporting on
- Fixed Issue with memory leak in Dashboard Schedules
- Added Total Storage by TSM Server dashboard data source
- Added the ability to periodically issue TSM Commands to the Command Schedules Workflow
- Fixed Issue with TSM Database Space Collector
- Purge Stats results screen data is now sorted correctly and the date formatting has been corrected
- Added Categories to the Dashboard Schedules
- Fixed Issue with Data Purging
- Added Client Schedule Results with no summary record data source
- Added TSM Database Space Collector and data source ( this gives the database space for the individual database directories )
- Fixed issue when cloning Dashboard Schedules
- Modified Client Node Last Backup Status and Client Node Last Backup Status with Schedule Details data sources to produce a unique row for each client node and schedule
- Fixed issue when updating email addresses in Dashboard Schedules
- Added option to be able to change the height and width of the output of scheduled dashboards
- Fixed issue with Scheduled Dashboard job causing TSM Studio Server or crash
- Added the following features to Dashboard Designer
- Option to choose Mock Data or Real Data
- Ability to choose the date period for Historical Data Sources
- Added a new Report Template – Data Domain Utilization
- Added ability for schedule dashboards to be published in an image format
- Client Node Object Comparison now has a history summary view
- Fixed the Report Execution on the main Reporting ribbon opening the dashboard execution history instead of the reporting execution history
- Fixed issue with directory names in operational reporting not translating correctly
- Fixed issue with dashboard schedules not enabling correctly from the summary view
- Fixed issue with corrupt dashboard templates
- Added the ability to join data sources (currently can only be used with custom data sources )
- Added new Client Node Last Backup Status with Client Schedule Details Data Source
- Added Contact field to the definition of all Device Types (TSM Server, TS3500 Library, Data Domain and ACSLS Servers)
- Fixed Dashboard Scheduling Issue
- Added MSSql Table Growth Data Source and Dataview
- Added Total Rows Deleted, Total Collections Deleted and Finished in Deletion Window to Deletion Stats Dialog
- Fixed Issue with Custom Data Source asking for a device to be selected for a System Data Source
- Added Dashboard Scheduling
- Added Client Node Last Back Status Data Source
- Added Data Domain Average Daily Growth Data Sources
- Fixed Issue with collected data not being correctly deleted
- Fixed Issue with DateTime showing 01/01/1900 instead of a blank value when the field is null in grids
- Fixed issue with automated volume auditing allowing the addition of blank volume names
- Added Operational Reporting Web Viewer. Requires IIS
- Fixed Issue with null reference error when displaying the default dashboard
- Added Data Source Schema Viewer to the Reporting Tab and also is accessible from Data Source Scheduler and Report Template Designer
- Added Client Node Schedule Results with Client Node Details Data Source
- Fixed issue with some summary based alerts not correctly firing
3.0.5.6
- Fixed issue with bookmarks in published pdf’s not working
3.0.5.5
- Fixed issue with some summary based alerts not correctly firing
3.0.5.4
- Fixed issue with SQL Queries not correctly merging when using in a report template
- Added Option to specify decimal and thousands seperator
- Fixed issued with Report Template scheduler not correctly showing the device type
3.0.5.3
- Report Designer saves and restores windows layout on closing and opening
- Operational Reporting run now dialog now has the same options as in the Operational Report Schedule
- Added new option to pack the client side database into the Client Side Options dialog
- Report Designer now pre-populates the Data Member field with the data source that has the most rows
- Data Source and SQL Query scheduler advanced options now match the Report Template Scheduler advanced options
- Fixes issue with Operational Reporting status dialog not updating correctly when two schedules start at exactly the same time
- Operational Reporting now has an option to format the name of the output file when using the save to disk option
3.0.5.2
- Fixed issues with reports with multiple data sources showing blank fields
- Added ability to specify a name for Operational Reporting attachments in emails
- Navigation Tree will now automatically update when changes to objects are made externally
3.0.5.1
- Fixes flash form not created error when testing sql query
- Added ability to add real time alert description to email subject and message body
- Added Refresh option to Data Domain Container
- Fixed issue with Email Groups not showing when adding new Report Schedules
- Fixed issue when running reports from the navigation tree not working correctly when individual TSM Servers are selected
3.0.5.0
- Fixed Issue with internal SQL Parser not translating field types correctly with complex SQL queries
- Fixed Issue with Reporting Scheduler Advanced options for splitting reports based on devices not working as expected
3.0.4.9
- Added Network Ping (tests if Network is available, can be found under system alerts)
- Fixed Issue with some Real-time Alerts not showing in the Real-time Alert Console
3.0.4.8
- Fixed issue with Collection Reset not correctly removing all runtime date data
- Activity Log Collections will now collect all activity log data when there are no include filters setup, once a filter is created then only data in the include filters will be stored in the TSM Studio Server database
- Added new Activity Log Search Feature. This allows for the creation of often used searches of the Activity Log
3.0.4.7
- Fixed issue with Operational Report Schedules not being loaded or running after upgrade from V2 to V3
3.0.4.6
- Fixed issue with TSM Commands only being issued for Alerts in a warning state
- Alerts Console messages are now updated on every alert poll
- Added Data Domain Groups
- Modified Data Domain MTrees not replicated Alert to ignore deleted MTrees
- Modified the dialog for adding and updating Client Node Static Groups to make it easier to see which Client Nodes are in the group
3.0.4.5
- Added new Client Node, File Space, Storage Pool to Occupancy Correlation data source
- Modified MTrees not replicated Alert to ignore MTrees that are a replication destination
- Modified Replication Lag Alert to ignore disabled replications
- Modified the columns on the Data Domain data source to make them more meaningful
- Fixed Issue with Data Domain Systems Properties sometimes showing a blank view
3.0.4.4
- Fixed issue with TSM Studio Server Database and Log Alert showing once for each TSM Server defined
- Fixed issue that emails are not being sent if an email rule is defined using Alert Variables
- Added the following Data Domain Alerts
- Disable Replication
- File System Disabled
- Heart Beat
- MTrees not replicated
- Aged AUTO Snapshots
- Aged RESYNC-RESERVE snapshots
- Replication Lag
- Uninitialized Replication
- VTL Subsystem disabled
- Add following Data Domain Data Sources
- MTree Growth (which shows the growth of an MTree during the selected Period)
- System Summary
- Usage Summary
- Snapshot List
- Replication Status
- Replication Config
- All Data Domain views now also available under Enterprise Category
- Added new Data Domain File Comparison Tool to be able to compare directories from different Data Domain Appliances
3.0.4.3
- Added Tracing to Email Rules to help validate which rules are being triggered
3.0.4.2
- Added Option to be able to reset Client Schedule Alerts
- Fixed Issue with email rules alert message field not being correctly set
- Email Rules now have alert variables and related data as filter options
- Fixed Issue when editing TSM Server Groups
- Fixed Issue when displaying TSM Server Group charts
- Fixed Issue with hiding Chart Series
3.0.4.1
- Fixed Issue with Data Domain Alerts only triggering once
- Change alert notification messages to be more generalized to allow for more device types such as Data Domain and System Alerts
3.0.4.0
- Added ability to cancel when testing a connection to a TSM Server, Data Domain Appliance or TS3500 Library
- Added Data Domain Active and Archive Tier Utilization Alerts
- Fixed Issue with TSM Studio Server Database alerts being run against TSM Servers
- Added Client Schedules Totals – Summed Data Source
- Added Client Schedules Totals – Summed Data Source Pie Chart that can be used in a Pie Chart Graph
3.0.3.7
- Fixed issue with Static Client Node Groups not correctly showing the previously saved Client Nodes
3.0.3.6
- Data Domain Active and Archive Tier Utilization Datasources now support showing the Latest Collections
- Fixed Issue with Intra-Day schedules asking for a month value to be entered
3.0.3.5
- Fixed Issue with Invalid Integer when retrieving SNMP data from TS3500 Library
3.0.3.4
- Fixed Issue with Data Domain Test Communication button only working if community name is public
- Added Related Data variables option to subject and message fields context menu when overriding TSM Alert emails.
3.0.3.3
- Fixed Issue with new Auditor Role not allowing logins
- Local Windows Users can now login to TSM Studio Server
3.0.3.2
- Added Chronic Failed and Missed Schedule Data Sources
3.0.3.0
- Fixed Issue with Client Node Statistics not saving data due to database locking issue
- Added Support for TS3500 Tape Libraries, includes collection of Tape and Library statistics
- Added option to pause and rerun Command Schedules
- Add Options to Alerts to stop occurrence count update on State Changes
- Added Quick Access Short-cuts On device context menus ( for device configuration and schedules)
- Added new Tool to compare backed up objects of Client Nodes on different TSM Servers
3.0.2.9
- Fixed Issue with Email Settings not being saved correctly for overridden Alerts
- Fixed Issue with Real Time Alerts not displaying correctly in Real Time Alerts Console
- TSM Servers and Data Domain Appliances can be tested on bulk
- Add Location field for TSM Servers and Data Domain Appliances
- Added Data Domain Usage Summary Data source
- Added Activity Size Monitor Alert
- Added override to stop Operational Reporting using up all memory when the TSM Server Activity Log is extremely large
- Added Activity Log Stats to Operational Reporting Custom Summary
- Add Collection for Data Domain File System, Replication and NFS statistics
- Data Domain Appliances can now be put in Maintenance Mode
- Data Domain and TSM Servers can set the end date and time when putting a device in Maintenance Mode
- Fixed Issue when save chart settings that data was also saved which was causing incorrect data to be displayed on subsequent viewing of charts
- Client Node Charts now have the option to choose which TSM Server to view data from
3.0.2.8
- Added Storage Hierarchy Diagram for each TSM Server under Storage Category
- Fixed Issue with Client Schedules result field returning a -1 value
3.0.2.7
- Fixed Issue when adding Custom SQL to an Operational Report
- Time is now displayed in DateTime columns when exporting to xlsx format
- Added Audit Occupancy by Domain Data Source
- Added Device Class Collection and Datasource
- Added Font Color option when creating SQL Queries as in some of the themes the default color can be hard to see
- Column Positions and Placements are now saved in the Alerts Consoles
3.0.2.6
- Added hot object tracking to charts so they now show the series name and value when the mouse is hovered over them
- Added Scratch Tape and Storage Pool Utilization Dashboard datasources
- Added Management Class Verification Alerts
- Added option to change font color when editing SQL Queries
- Fixed Issue with incorrect Categories showing when editing an SQL Query
3.0.2.5
- Fixed Issue with EMail Rules not triggering correctly
- Fixed Issue with Automated Volume Auditing Lists audited the same volume more than once in a policy
- Added Node,Domain,Schedule and Scheduled Start fields to Client Node Scheduled Alerts
- Added option to reset occurence counter on Alerts Console
- Fixed issue with Data Domain MTree Collection
- Updated EULA
- Added Enterprise Occupancy by Node by Filespace Dataview
- Fixed Issue with collections deadlocking when running at the same time as data purging
- Add setting to Start TSM Studio Client Maximized
- Fixed Issue with Cloning Datasource Schedules not cloning all settings
- When opening Client Node Charts the option to select the TSM Server is now available
- Added option for individual alerts to reset the Occurrence Counter to 0 when an Alert returns to an OK State
3.0.2.4
- Added new Email Groups Feature which can be used with Reporting and Alerting
- Added Individual Alerts console for Client Node Schedules and RealTime Alerts
- Added new Alert Client Schedules that have not Completed
- Added Data Domain NFS Exports Collection
- Fixed Issue with Report Schedules having a zero weekly schedule preventing the schedule from running
- Added Enhanced Color Filter to Datagrid
- Added Timeout option to handle long running Data Domain commands
- Enhanced the Calculated Column Add dialog to make it easier to add Calculated Columns
- Alerts can now have a customized message on the console
- Added the following features to Alert Consoles
- Filters
- Color Rules Engine
- Line Numbers
- Ability to Disable Client Schedule Alerts and Realtime Alerts from main console
- New Feature to log ticket numbers against Alerts
- New Tickets View
- Grid Settings Dialog to change the way copy and paste works and different filter options
- Ability to display the number of occurrences for each alert
3.0.2.3
- Fixed issue with license not auto applying after a TSM Server is deleted
- Added the following Dashboard Data sources Client Schedules (Percentage), Session Node Count and Session Admin Count
3.0.2.2
- Fixed issue with license not being released when a TSM Server is deleted
- Added Custom Datasource folder to navigation view. Allows for datasources to be customized and added to navigation tree
3.0.2.1
- Fixed issue with Operational Reporting Data not sorting correctly
- Fixed issue when trying to delete multiple Operational Reporting Schedules
- Operational Reports can can be scheduled to run for periods other the other last 24 hours
- Added Report Start Time and Number of Hours Processed to Operational Reporting Front Page
- Added Ability to view and Clear TSM Server Connection Errors
- Fixed Issue when editing TSM Server that the licensing information is removed from the display
- Added Support for IBM Capacity Macro
- Added Licensing–>TSM Capacity Licensing Dataview
- Added Hyper-V backups dataview to Virtual Environments Category
- Added Hyper-V backups section to Operational Reporting
- Added TCPIP version 6 support
- Added ability to Schedule SQL Queries and Report Templates directly
- Fiexed Issue when editing TSM Servers from the navigation window
- Fixed issue with Client Node Statistics Dataviews not displaying correct values (read more here)
- Added Failed Admin Schedules Alert
- Fixed Alert Private Library Volumes not in Volumes not clearing correctly
- Added select all option to Alerts Console
- Added ability to hide alerts for a set amount of time
3.0.1.7
- Fixed Issue with Libraries with no drives not being collected
- Fixed issue with override scratch tape count alert not correctly alerting when the library has no scratch tapes
3.0.1.6
- Added Check to ensure Client and Server versions match
- Completed Audits can now be shown by Policy Name
- Added feature to hide Alerts in the Alerts Console for a given time period
- Alerts in the Alerts Console are now sorted by last logged date so the newest updated entries will always appear at the top of the console
3.0.1.5
- Fixed Issue with TSM Commands appearing twice in Alerts
- Fixed issue with Report Templates not showing in Reporting Scheduler
- Automated Volume Auditing – Fixed Issue with Written since Last Audit field not updating correctly
- Automated Volume Auditing – Added option to audit by last written date
- Fixed issue when adding a Report Template using an SQL Query asking for a date
- Fixed issue with Test SQL Button not showing any output
- Added Intra-Day Scheduling for Reports, SQL Queries and Datasources
3.0.1.4
- Fixed Issue with selecting dates when adding\editing a report template in a schedule
- Added Current Month and Today as Date Types when scheduling a Report Template
- Added VMWare Backups Datasource
- Add Alert Statistics Datasource
- Fixed the Activity log collector looping and collecting the same info
3.0.1.3
- Added Enterprise Virtual Environment Category
- Added VMWare Backups Dataview
- Added Summary Extended Collection
- Added Summary Extended Datasource
- Added Diskpool Sizer Tool
- Modified Activity Log Collection algorithm to be more memory efficient and have less impact on the database log
- Checked “Console Alerts” to read “Real Time Alerts” in the Alerts Console
- Real Time Alerts and Polled Alerts can now trigger TSM Commands
- Real Time Alerts can now have custom subjects
- Real Time Alerts can now have more complex comparison so both the message number and message text can be searched
- Fixed Email Configuration dialog not sizing correctly
- Real Time Related Data now contains message and message number of the actlog message that triggered it
- Added Alert Reclamation Ended due to excessive errors
- Datasource Fields Table now shows Included Fields instead of excluded fields to make the view more intuitive
- Added Management Class Collector
- Added Management Class Dataviews
- Fixed Issue that Operational Reports could only be scheduled when the Operational Packages view was open and not from Schedule Option on the Ribbon.
- Added Option on SNMP Trap Destination Dialog to send send a test trap
- Added Option on Real Time Alerts Dialog to manually restart the session to the TSM Server
- Added VMWare Backups Operational Reporting Section
- Added Per Day and Total Alert Statistics
3.0.1.2
- Fixed Issue that TSM Studio Server Configuration hanging when updating the schema
- Added Operational Report Viewer
- Removed Beta Code to de-activate TSM Studio Server on 30-Sep-2014
- Fixed Issue when adding a TSM Server in DEMO would display a license error
- Fixed Longing Running Process Alert generating incorrect alerts
- Fixed Longing Running Session Alert generating incorrect alerts
- Fixed titles not showing correctly for some charts
- Fixed Operational Report generating an extra .pdf file extension on email attachment
3.0.1.1
- Fixed Issue that TSM Instances werent auto licensed when adding unlimited license
- Added Data Domain Active and Archive Tier Utilization Datasource
- Added Data Domain Active and Archive Tier Utilization Charts
- Added Data Domain Active and Archive Tier Utilization Dashboard Datasource
3.0.1.0
- Add Client Added and Client Deleted Alert
- Fixed Issue with Chart Settings not saving correctly
- Added FileSpaces Advanced with Client Node Details Datasource
- Enhanced Logging
- Client Node Decommission now saves Management Class information before deleting the node
- Dataviews now display object information in tab
- Fixed Issue with some Data Domain dataviews
- If you have been using previous versions of TSM Studio Server 3 you may get an error saying the DEMO period has expired. In that case please use the following license key – QLJ1F-K3221-5DAID-I2K3P-X7TJG-8JWFE
3.0.0.8
- Fixed TSM Studio Server and Server Groups showing Enterprise Data
- Moved all Client Node Related Charts and Dataviews into the Client Node Category
- Automated Volume Auditing now produces an Alert when a Bad Volume is found
- Node Decommission tasks now produces an Alert when a Node Decommission Task Fails
- New Alerts for Storage Pools found in ReadOnly and Unavailable States
3.0.0.7
- New Ribbon Based User Interface
- TSM Studio Server now has its own client and does not require a copy of TSM Studio
- Navigation Tree displays a description of each item by hovering the mouse over the item
- Reports and SQL Queries now now be accessed directly in the navigation window
- New Client Node Decommission Workflow
- New Chart Viewer offering more display and setting options
- New Data Domains Charts and Datasources including statistics for CPU,Memory, Replication, NFS, CIFS,Disk and NVRAM
- Fixed Issue when adding new SQL Query that it always went into unassigned category even if a category was entered
- Fixed Issue with Non-Responsive TSM Server Alert firing too soon
- Fixed Wildcard Search String in Realtime alerts to correctly use * and ?
- Added Contain, Starts With and Ends With search options to Real Time Alerts
- Scheduling Data view now displays Queued,Running and Totals for Alert,Reports and Collections
- Changed the Internal statistics reporting option to reduce memory usage and speed up data collection from the TSM Servers
- New Alert Email Rules processing to redirect alert emails based on the alert content
Operational Reporting – Whats New
- Fixed Proxy not found error
- Added Easy Date Selection when Filtering Operational Reports
SP Studio – Whats New
- Added ability to create client node groups (both static and dynamic) and run reports for the clients in those groups
- Added the datasource designer to be able to manipulate current datasources including joining and grouping
- Added Occupancy by TCP Name By Storage Pool view
- Updated Admin Client to 8.1.8
- Fixed issue with Define Server command
- Add search option to ribbon bar
- Fixed issue with TSM Command Routing
- Fixed issue with showing script contents
- Fixed issue with Admin Task Time Line chart
- Added the option to open Submit Command output in a grid, this will make it easier to copy to an excel spreadsheet
- Fixed issue with not being able to change retention values to zero
- Enhanced submit command dialog to allow for more control over the output
- Fixed issue with updating Node Group Members
- Updated Multi-Client node register to allow multiple schedules to be selected
- Updated Multi-Client node register to all for variables to be used in the password fields
- Updated Multi-Client node register to allow coping names
- Fixes issue with Database integrity error message popup displaying during start up event through database have no issue
- Added ability to add dynamic and static Client Node Groups to report against
- Added Custom Pivot Grids, allows for customizable Pivot Grids
- Fixed issue where only 10 clients are displayed in Multi-Client Node dataviews and commands dialogs
- Added Delete NodeGroupMember command to Multi Client Commands
- Added option to add wild characters to lines in the Add List feature when using Multi-Client node dataviews and commands
- Updated Custom SQL to better handles different quote types
- Added dotnet framework to the installer
- Update Add List in Multi-Client Dataviews and Commands to support wildcards
3.1.0.7
- Added Enhanced Filtering to Multi-Client Views and Commands
- Added Rename Multi Client Command
- Added Update Contact Multi Client Command
- Added Reporting Module with Report Designer
- Added Manual Backups Dataview
- Added Remove Replication Command
- Added some sample dashboards (more to come)
- Added option to change TSM Server for each dashboard
- Added Query Dedup Stats
- Added File Count by Management Class dataview
- Added Storage Used by Management Class dataview
- Fixed Issue with Scripts not displaying
- Fixed issue with loading saved xml dataviews
- Removed duplicate “Move Data” commands from a number of dataviews
- Updated Storage Metrics Help
- Added Reporting Module
- Added Operational Report
- Added Storage Metrics to Storage Related Dataviews allowing the ability to choose between bytes, KB, MB, GB and TB in the dataviews
- Fixed Issue with Library\Drive Path Add\Update dialog not correctly showing sources field
- Fixed Issue with Percentage controls not updating correctly when running multiple commands
- Fixed Issue with Volume – Library Volumes Cross Reference view not opening
- Fixed Issue with erroneous User Cancelled messages displaying when open Library Slots view
- Updated Connection Error dialogs to display the entire TSM error message
- Fixed Issues with Admin and Client Schedules Time of Day dataviews
- Added new Backup and Policy Information Dataview, this dataview shows the client nodes backup schedules, last access, last backup details and the policy information for each client.
- Fixed Issue with View Session Log and Process Log not showing on sessions and summary related dataviews
- Fixed Issue with timer icon not being displayed when a timer is enabled in a dataview
- Fixed Issue with Tape Drive Daily Summary Chart and Added options to modify the chart legend
- Fixed Issue with Unavailable volumes in library
- Fixed Issue in charts not allowing dates to be changed
- Fixed Issue with Tape Drive Usage Daily Summary not displaying data
- Fixed Issue with DisAssoicate all schedules from a client command menu item
- Fixed Issue with TSM Connection Errors not correctly clearing
- Fixed Issue with quotes not being being placed around option set values when being edited
3.0.3.1
- Script Editor has been fixed to better handle single and double quotes
- Script Editor has been updated to better handle error conditions where the script could be left in an incomplete state
- Added more Health Check Items
- Health Check Messages can now be drilled into by double clicking on them to provide a detailed view of the Health Check Issue
- Added more Health Check Items
- Added more Custom Chart Items
- Custom SQL Queries and Query Commands can now have input parameters added to allow for user input
- Added more Health Check Items
- Health Check can now be run against a TSM Server Group
- Added Ability to add Date Periods to Health Check Items
- Added better visual indications to health check progress and errors
- Fixed Performance Issue causing SP Studio slow downs
- Fixed Issue with Capacity Macro Licensing not showing any values
- Fixed Health Check View
- Added ability to add custom items to the Health Check
- Fixed Session Log and Process Log views
- Re-Enabled adding user commands and views to Dataviews
- Added Ability to choose which version of TSM help files are loaded
- Added support for Directory Containers
- Added TSM 8.1 Help Files
- Fixed Policy Set Editor crashing issue
- Add Custom Charts feature allowing for the creation of your own charts using SQL or provided data sources. A number of samples are provided
- Made it easier include or exclude TSM Servers in the console
- Fixed issue with ribbon configuration changes not being saved
- Added feature to change fonts and colors on preview window
- Added feature to change fonts and colors on all all sql editor windows
- Fixed bug where SP Studio would crash when building a TSM Command for a TSM server that is not responsive
- Added Storage Pool Directories Dataview
- Fixed Issue with multiple calls being made to TSM Server when opening a dataview slowing down the display of the data
- Fixed Device not found error when testing TSM Server connectivity
- Fixed some performance issues
- Fixed some issues using SP Studio with Spectrum Protect 8.1
- Notify Subscribers on TSM Server context menu is now working
- Added Notify Subscribers ALL Profiles to the TSM Server context menu
- Fixed Issue with Migrate Storage Pool command when applied to Primary Random Pools
- Added new Health Check Functionality
- Added Licensing
- Added Summary based Charts from V2
- Added ability easily see which TSM Servers are having communication issues
- Fixed Issue with Process Tracker not correctly displaying a message when the process ended
- Console now saves the column witdths
- Added ability to set the decimal and thousands separator on a per TSM Server basis
- Added Show and Clear TSM Server Connection Errors to TSM Server context menu
- Fixed issue when using Add Like for Client Nodes on TSM Servers 7.1.1 and above
- Fixed issue with platform and version not updating in a timely manner
- Fixed issue when exporting diagrams to PDF
- Bought across the Tape Audit Feature from TSM Studio V2
- Added Show Event Server to the TSM Server context menu
- Added Library command to delete a library along with all the defined paths and drives
- Added command to change the library being used by a devclass, this can be run from both the device classes view and the storage pools view
- Added Custom Options tab to Register Multi Client Nodes function. This allows for the addition of custom parameters
- Fixed an issue with the Add Like command on the Client Nodes dataview adding 2 KEEPNO= parameters to the REGISTER NODE command
- Added TSM Studio V2 to SP Studio V3 Importer (pulls in TSM Server, Group and User Profile configuration)
- Color Rules on dataviews now working
- Fixed Issue with Client Schedule Definitions using locale time instead of US time
- SP Studio startup time has been improved
- Added option under configuration–>options to allow SP Studio to start maximized
- Fixed Issue with Profile Subscription dialog not filling in all the fields correctly
- Fixed Issue with Define Path dialog not filling in all the fields correctly
- Fixed Issue with Console not restarting the connection to the TSM Server
- Fixed Issue with Grid not refreshing correctly if it was initially blank
- New Interface
- Activity Log Search feature
- Easy Add SQL Queries
- Dataview Engine Rewriiten
- Updated Online TSM Help
TSM Studio Server – Whats New
- Fixed Issue with time not displaying in DateTime columns when exporting to XLSX format
- Fixed Issue with generating csv attachments
- Fixed Issue with SQL Queries not displaying correctly
- Added Report Schedule description field
- Fixed Issue when windows firewall was disabled that the configuration would display an error regarding a missing com endpoint
- Fixed issue with failed NAS Backup Alerts not triggering
- Fixed issue when upgrading from earlier versions and when the backend is MySql that the schema update fails with an index create error
- Fixed Issue with import\exporting of Report Templates
- Fixed Issue with some of the Dialogs needing to be refreshed when first opened
- New single Installer includes both 32 and 64 bit versions
- Fixed Test Translation Button Operational and Reporting Schedules not showing correct translations
- Fixed Issue with Real-Time Alerts Restart Option not restarting the Console Session Correctly
- Added Option to Restart Real-Time Alerts if an alert is not received in a specified amount of time
- Fixed Issue with Activity Log section of Operational Report sometimes showing incorrect values in the Message Number Field
2.9.2.8
- Fixed Null Reference error when saving Query Commands
- Fixed Issue when adding new SQL Query that it always went into unassigned category even if a category was entered
- Fixed Issue with Non-Responsive TSM Server Alert firing too soon
- Fixed Wildcard Search String in Realtime alerts to correctly use * and ?
- Added Contain, Starts With and Ends With search options to Real Time Alerts
- Scheduling Data view now displays Queued,Running and Totals for Alert,Reports and Collections
- Changed the Internal statistics reporting option to reduce memory usage and speed up data collection from the TSM Servers
(NOTE: The wildcard fix for the Realtime Alerts may break rules using the Wildcard search option, TSM Studio Server will attempt to resolve these but it is advised to use the “Generate Activity Log Message” option on the Real Time Alerts toolbar to ensure alert rules are triggering as expected)
2.9.2.2
- Added Log to view Setup Data
- Fixed Issue that in some cases System Files were not loading when TSM Studio Server started
2.9.2.1
- Add MG,GB and TB fields to the Summary dataview to complement the existing Bytes field
- Added GB and TB fields to to the following datasources
- Audit Occupancy
- Database
- FileSpaces
- Node Data
- Occupancy
- Volumes
2.9.2.0
- Fixed a memory and handle leak caused by TSM Studio Server Collectors not releasing resources correctly
- Created separate thread pool for Client Node collections to fix thread deadlock issue
2.9.1.7
- Added option to send test email in the Alerts Default Notifications Dialog
2.9.1.6
- Added transaction limits when deleting data from a MSSQL database to better control database log growth
- Added Alerts to monitor TSM Studio Server Database and Log utilization
2.9.1.5
- Fixed issue when adding exclude alerts in the Real-Time Monitor
- Updated debug messages to display more relevant information around where the error message is originating from
2.9.1.4
- Fixed issue when adding Schedules with Templates that do not require dates, that dates were being requested
- Fixed issue with Client Node groups History by Schedule showing Key not found in dictionary error
2.9.1.2
- Added Support for new version 3 TSM Studio Server GUI
- Fixed Issue with error message about bad servers check is already scheduled when connecting to TSM Studio Server for a second time
2.9.1.1
- Fixed Slow logon issue
- Fixed Issue with Wait Screen on report designer not closing
- TSM Studio Security has been enhanced and no longer uses the registry.
- Report Designers now open to a maximized window
- Fixed Issue when creating a User Defined SQL in the Custom Summary when entering a ( in the sql statement caused a nul exception error
- User Defined SQL editor now correctly show tables and columns
2.9.0.11
- Added Support for Operational Reporting Viewer
- Added Security Groups and Roles to allow finer grained access
- Fixed Top N Client Section in Operational Report so it only shows clients for the TSM Server being reported on
- Fixed Total Storage Report in Operational Report as it was showing incorrect figures under certain circumstances
- Tape Usage Detailed and Tape Usage Summary Operational Report sections now show only 20 drives per chart, this is configurable under Configuration–>TSM Studio Server Properties
- Fixed Null Exception error when adding a new Datasource Schedule
- Fixed Issue Editing and Deleting TSM Studio Servers
2.9.0.10
- Fixed Issue with editing and deleting TSM Studio Servers
- Fixed Issue with some reports not running
- Fixed Issue with Scheduled SQL Queries adding incorrect suffix to xlsx generated output
2.9.0.9
- Fixed given key not present error when adding an operational reporting schedule
- Operational Reporting will now produce Table of Contents bookmarks for navigation in Adobe Reader
- Operational Reports can now be stored in TSM Studio Server database and viewed using TSM Studio and the soon to be released Operational Reporting Viewer
- Added Total Storage Used section to Operational Reports
- Added Top N Clients, show the top clients consuming storage. N is a configurable number
- Columns in exported Excel spreadsheets are now properly sized
- Fixed Issue that a large number of alerts could not be simultaneously deleted from the alerts console
- Added alert throttling so that the same alert wont be continually repeated until a set time limit has passed, can be set globally and on a per alert basis
2.9.0.8
- Fixed bug with cloning Report Schedules, Datasource Schedules and SQL Query Schedules
- Added ability to throttle real-time\activity log alerts for a given period of time so that the alert console and email are not flooded with the same alert
2.9.0.7
- Fully rebuilt the scheduling engine for more stability and reliable scheduling
- Added more control over the amount of collectors and reports that can run to resolve database transaction log growth issues and high memory utilization issues
- Resolved issue with purge process not removing all data
- Charts in the Reports can now contain calculated fields
- Collector event logging to the event log can now be disabled
- TSM Server can now be individual excluded from Real-Time and TSM Alerts
- Library Scratch tape count alert can be setup with different thresholds for different TSM Servers and Libraries
- Added Command Schedules to execute TSM Commands at a designated time and capture the output
- Added Drive Paths Alert
- Add Event Trigger to generate an email when TSM Admin or Client node tasks complete
- Support for TSM 7.1
- Fixed Last TSM Database backup Alert that would erroneously report a large number when a backup was actually in progress
2.8.9.0
- Fixed Activity Log Monitor Alerting not alerting on message numbers
- Fixed Volumes Collector not picking up Write Errors correctly
- Installation Directory for TSM Studio Server can now be selected as part of the install
- Fixed issue when exporting of Reports that have an SQL Query as a datasource do not export the SQL Query and after export the datasource is blank and cannot be changed
- Fixed Client Node Group – Client Schedules chart is prompting for a specific client instead of just showing the data for all the client nodes in the group
- Fixed issue when using Storage Pools as a Datasource in a Report Template an error displays that the field CollectionDateTimeStamp does not belong to this datasource
- Fixed issue with missing dll causing the Report Designer to crash
- Fixed issue that report fields were missing when using more than one SQL Query as a datasource to a report template
- When reducing retention times for collected data, deletion has now been changed to only delete per collection period to reduce amount of transaction log required
- Increased trial period of TSM Studio Server to 120 days
- Fixed issue with some data showing blank TSM Server Names
- Fixed issue that data wasnt being removed after deleting a TSM Server from TSM Studio Server
- Added Empty volumes chart
- Added Pending volumes chart
- Added Volume Count by Storage Pool Chart
- Added Total Storage per Storage Pool Chart
- Fixed issue with %!TSMServer!% not correctly translating when more than one TSM Server is selected for the report
- Individual TSM Servers can be excluded from Alerts
- Fixed Issue with Report Designed crashing if the designer is moved off the main screen
- Fixed Issue when deleting a top level folder from the Documentation Libray, the folder is still displayed until the dialog is closed and reopened
- Fixed Issue with Collector not getting TSM Status Information
- Datasource to expose TSM Status Information has been added
- Collector now collects TSM Server information and a datasource has been created to expose this data
- Add new view to see History for a client node definition
- Enterprise Missed Files Totals was showing totals for individual TSM Servers this has been corrected to show Enterprise totals
- Fixed Issue when Summary Charts when clicked through were not show data for the correct dates
- Example Supplied Report Templates have been cleaned up
- Markers on Charts can now be disabled
- Added the ability to show cross-hair cursor on the charts
- Fixed Issue with TSM Studio Server dialog not correctly refreshing TSM Server definitions when a modification was made
- Operational Reporting User Defined SQL’s can now be created in the custom summary section
2.8.8.0
NOTE: There are a number of Index and Table modifications made when upgrading to this version which may take up anywhere from 30mins to 2 hours to complete, during this period you will not be able to connect to TSM Studio Server
- Added Event Triggers, can trigger an email or report when a Client (Backup, Restore etc ) or Server Activity ( Database backup, Migration etc ) completes.
- Added Process Ended event to the event triggers
- Fixed up the issues around the Enterprise Dashboards and the added the Readonly Enterprise Dashboard viewer application
- Added framework for SmartAlerts ( Currently only applied to Noes not in a Collocation Group, nodes can now be automatically placed in a Collocation Group when this alert is triggered )
- Made the Date Dialog consistent across all the Charts and Dataviews
- Client Node based Collectors ( Filespaces, NodeData, Occupancy and VolumeUsage ) have been changed to collect data on a node by node basis. The Collectors are Multi-Threads which improves the performance of the collections
- The following Datasources have been added
- Duplicate Volumes
- Database Capacity
- Client Node Totals
- Client Node Added Totals
- Node Occupancy and Network Traffic by TCPName
- Avg Node Occupancy and Network Traffic by TCPName
- Avg Node Occupancy and Network Traffic by TCPName Summary
- Client Nodes Outside Backup Window
- Volume Usage with Volume Details
- Client Nodes with no data
- Node Occupancy Deltas Physical(MB)
- Node Occupancy Totals Physical(MB)
- Node Occupancy Totals Logical(MB)
- Node Occupancy Deltas Logical(MB)
- Node Occupancy Deltas Number of Files
- Node Occupancy Totals Number of Files
- Node Occupancy Logical(MB) Growth Summary
- Client Node Network Traffic Summary
- Count of Client Status by TSM Server,Activity,Month
2.8.7.0
- Fixed Issue with TSM Studio Server not creating entire schema on new install
- Fixed issue with Operational Reports producing null exception error
- Modified Volume Collections to use Query Volume command instead of select * from volumes to get around bug in TSM 6.2.2
- Added Collection for ACSLS objects
- Added Alert for ACSLS Scratch Tapes per pool
- Added Client Node Annotations dialogs to allow attaching notes, tickets and customer information to a client note
- Add Document Library so that Documentation can be added to TSM Studio
- For point in time data it is now possible to select the actual date snapshot you wich to see
- Removed Trend container from servers
- Added option when showing graphs to display date range, interval range, min, max and sum of points in the charts
- Added Dudeplication and Replication Charts
- Datasource Scheduler
- Added fixup for issue with outlook removing what it deems as unneccessary line breaks
- Added Avg Occupancy with Network Summary Dataview
- Added Avg Occupancy with Network Summary Dataview Summary
- Added Filter to Datasource Viewer
- Added SLA – Client Nodes out of Backup Window Datasource
- Seperated Client Side and Server Side Database Access to ensure consistent performance from GUI
2.8.6.1
- Added Volume Usage Daily views to TSM Studio Server
- Added more Debugging Options
- Modified Thread Priorities so that Operating Reports and Reports are schedules are not missed
- Fixed Issue with incorrect column lengths in Client Node Details Table ( requires a Client Node Collection to occur to rebuild the table )
- Fixed Field Type issue when collecting volume history data from Version 6 TSM Servers
- Added Enterprise Session Load Chart
- Added Session Load Chart to Operational Reports
- Fixed Tape Drive Chart in Operational Report showing more tha 100% usage in certain environments
- Fixed Custom Summary GB fields ( were show MB not GB )
- Added Node Attributes Changed Alert
- Modifed Failed Reclaimations to be trigger key to be the volume number to stop flooding of messages
- Added Newly Added Nodes Report
- Added Support for Spirit Software Report Warehouse
- Added more Report Generation output options ( HTML, MHT, RTF and XLSX )
- Reports can now be Embeded in the email
- Reports can now be viewed online when run from the Run Now button
- Fixed issue when selecting individual TSM Servers for a Report
- Add Node not in a collocation group datasource
- Reports can now be scheduled monthly
- All Enterprise Reports are now available for individual TSM Servers and TSM Server Groups
- Added New Database Utilization Report for last 2 weeks to Operational Reporting
- Reports can now have a Filter applied when collecting data from internal datasoources
- Fixed Performance Issue with TSM Studio Server on Large TSM Environments
2.8.4.7
- Added Dynamic Client Groups
- Added a number of Client Group Charts
- Fixed Issue on Click through on most charts so they data behind the points can be viewed
- Major Change to Operational Reporting Model to allow different Operational reports to be run against the TSM Servers
- Fix to Client Schedules and Summary based datasources
- Added TSM Server Groups to TSM Studio Server
- Added Client Node Dataview Option to TSM Studio Server ( pulls data from TSM Studio Server Database )
- Fixed Issue with Emil addressed on Operational Reporting so that mutliple addresses are now accepted
- Fixed Scheduling Issues with Parameter Collection and Operational Reporting
- Setup Limit to number of Operational Reports that run similtaneously
- Added TSM Server Hung Alert
- Added Summary History and File Spaces Dataview to Client Node Dataviews List
- Merged Alerts and Collections Scheduling to Improve Performance
- Cleaned up Operational Reports and resolved issue with Custom Summary and Table of Contents
- Added DRM Operational Reports
- Added Completed with Non-Zero Result Code Operational Report
- Improved Deletion speeds when running clean up jobs
- Added new Operational Section – Tape Detailed Usage
- Added new Operational Section – Tape Usage Summary
2.8.3.4
- Fixed a number of bugs in the Alerting module
- Alerts can now be sent to EMail, Event Log, Scripts and as SNMPTraps
- Fixed issue collecting Log information from TSM v6 Servers
- Alerts can now be seen in the Windows Applications Event Log (SNMP Traps and Scripts coming shortly)
- Fixed small issues around enter licensing information with spaces or blank lines
- Added Activity Log Collection ( as this may generate a large amount of data in the Database it has been disabled by default)
- Operational Report Templates and Custom Summaries can now be exported and imported into another TSM Studio Server
- Reports can now have input parameters
- Report Templates can now be exportedimported
- Summary and Event Collection can now be done intra-day
2.5.0.3
- Add Following Sections to Operational Reporting
Expiration Statistics
Reclamation Statistics
Migration Statistics
Missed File Details
Missed File Summary
Server Processes
Node Activity Summary
Node Backup Statistics - Added Log Utilization Alert
2.5.0.1
- Fixed Spelling Mistake in Operational Reporting
2.5.0.0
- Added Advanced Alerting
- Added Operational Reporting
- Added Report and SQL Query Scheduling
TSM Script Editor – Whats New
2.2.0.0
- Fixed Issue when saving Sript Editor when the window is maximized then after re-opening Script Editor the applicaiton window will not be displayed
2.0.0.0
- Fixed the way we were updating scripts so that profile associations are not lost
- Windows can now be split horizontallay and vertically
- Script Editor window size and position are now saved
1.1.0.0
- Fixed Issue with TSM port number always displaying 1500 when editing
- Some new Look and Feel Skins
- Console Windows can now float ( At least one window must be docked but all the others can float ), Just double click the header
TSM Console Manager – Whats New
2.1.0.03.0.0.0
- Console view now supports Multiple TSM Servers in a single pane
- Added some new Look and Feel Themes
- Fixed Issue when saving Console Manager when the window is maximized then after re-opening Console Manager the application window will not be displayed
2.0.0.3
- Add Server Name to Process and Session Tabs
- Fixed Issue with Test TSM Server Connection Dialog
2.0.0.2
- Show Running Processes
- Show Running Sessions
- Console Windows can now be split horizontally and vertically
1.1.0.0
- Fixed Issue with TSM port number always displaying 1500 when editing
- Some new Look and Feel Skins
- Console Windows can now float ( At least one window must be docked but all the others can float ), Just double click the header
Version 1.0.1