Managing files to compare
Subtopics
The License Renewal Comparison Tool requires the following input files:
One or more license server inventory file or files (*.txt) generated by the getOrderNumbers tool.
Portal download file of already renewed licenses (Renewed-*-date .csv
Optionally, you can load the portal download file of still to be renewed licenses (To-Be-Renewed-*-date .csv
The comparison tool processes these files against the data in the Product Number Key tab. This data is provided with the yearly updated version of the tool (see How to install and start the Comparison Tool ).
License server inventory .txt files
In most cases you will have a single license server inventory file (getOrderNumbers output file).
This is the case if your licensing setup consists of a single FLEXlm license server, if it is a three-license-server redundancy configuration, or for multiple independent license servers in a network. For these configurations you will have one license server inventory file showing the installed licenses for all license servers.
Only in case of multiple license servers in independent networks you will have one license server inventory file per network. In this case you must run the getOrderNumbers tool on a server in each network.
You must use a .txt file name extension for each file, for example license-inventory-server01.txt.
Renewed-*-date .csv files
You must visit the License Renewal Portal before running the Comparison Tool. The portal allows you to download a record file which lists the already renewed licenses (Renewed-*-date .csv
To-Be-Renewed-*-date .csv files
The License Renewal Portal also allows you to download record file of still to be renewed licenses (To-Be-Renewed-*-date .csv
Collect in single directory
The License Renewal Portal writes both .csv record files into a License.zip
Advantest recommends to create a single directory or folder, for example verigy-license-renewal-year
The directory of your collected input files may look as follows:verigy-license-renewal-2009/license-inventory-server01.txtverigy-license-renewal-2009/Renewed-*-date .csvverigy-license-renewal-2009/To-Be-Renewed-*-date .csv
How to restart and reload files
Restarting the comparison process or reloading files may be required when you have additional or updated input data.
About this task
If you restart the process, you follow the prompts of the License Renewal Comparison Tool and reload the files as requested. (See the procedure instructions below.)
You can also reload single files individually or load additional license server inventory files. In this case click and select the required files.
In both cases, once the last required file is loaded, the Comparison Tool automatically reprocesses the currently loaded files and displays the result.
Before you begin
To restart the comparison process or to reload updated files, the Comparison Tool must be running and you must have completed the comparison process at least once. Make sure you have the additional or updated files available. If not, you cannot complete the task and the Comparison Tool will close.
Procedure
To restart the comparison process, click The Portal Export Available dialog appears and asks you to load the portal export file of renewed licenses (Renewed-*-date .csv) .
If you have the required portal export file click Yes
Navigate to the directory containing the portal export files, and double-click the Renewed-*-date .csv To-Be-Renewed-*-date .csv
If you have the To-Be-Renewed-*-date .csv Yes and load the file. If you Do not have the file click No .
In both cases the next dialog appears and asks you to load your license server inventory *.txt
If you have the license server inventory *.txt Yes
Click the *.txt my_licenses.txt ) and Open Shift Ctrl An additional tab opens in the Comparison Tool's main window and the Additional Server Inventory Files? dialog appears.
If you have any additional license server inventory *.txt Yes No
Results
The Comparison Tool's main window now shows up to seven tabs, and displays the Matched tab in the foreground.
How to filter license data
Filtering allows you to reduce the amount of displayed license data.
About this task
To reduce the amount of displayed data you can filter the data either based on
customers,
license server host IDs,
order IDs,
product descriptions, or
license expiration dates.
To sharpen the focus even further you can also combine these filter parameters.
Before you begin
All required files must be loaded and the Comparison Tool must have completed the comparison process.
Procedure
To filter based on product descriptions, for example, click The filter dialog appears. On the left it shows the included items, on the left the excluded items.
To move an individual parameter to the right to be excluded, click first the parameter then click > <
To move all parameters to the right, click >> .<<
To complete the filtering and close the dialog click OK .
Results
The selected filter parameters are applied and the Comparison Tool shows a reduced amount of data in all tabs.
The filtering parameters will stay applied until you exit the tool or click
Example
How to view and sort data
Toggling between list and matrix views views plus sorting data columns allows you to improve readability or display data according to your needs.
About this task
You can toggle the view of the tabs
Renewed_in_Portal
To_Be_Renewed_in_Portal (if data loaded)
License_Server_Output
Data columns can be sorted in list views that show the raw data without coloring. The current sort column is marked by a green arrow, pointing either upwards (ascending) or downwards (descending).
Colored matrix views are fixed and cannot be sorted. In this matrix view, you can display tool tips with a product description for each product number.
Before you begin
You must have loaded all files and the tool must have completed the comparison before you can toggle views or sort data.
Procedure
To toggle a view:
Right-click a supported tab and click Toggle ... View
To sort a data column:
In a list view click any data column header. The whole table is rearranged based on the alphanumerical sort order of this column. A green arrow indicates the sorted column.
The first click produces an ascending order, a second click produces a descending order. The third click brings it it back to its original order.
To display tool tips:
In a colored matrix view move the pointer over a product number in the header. The appearing tooltip displays the more familiar product description.
Example
How to save resulting files
The License Renewal Comparison Tool displays the result of the comparison process in several tabs, for example the Matched tab. You can save each tab in a .csv spreadsheet file.
About this task
Saving the comparison results allows you to view the .csv files in a spreadsheet software like MS Excel.
Before you begin
The Comparison Tool must be running and must have completed the comparison at least once.
Procedure
To save the contents of a tab, click the tab to bring it to the foreground.
Click Save As... .A save dialog opens. Default location is your home directory. Default file name is the name of the tab plus the current date and time: Nameyymmddhhmm.csv , for example Matched200901210915.csv
To accept the default location and file name click Save
Results
The result file is saved and ready to be opened in a spreadsheet software.
Example
How to view and save the log file
The License Renewal Comparison Tool provides a log file which lists all files you loaded and any issues during the comparison process.
About this task
Checking the log file will give you confidence that the comparison process ran successfully without errors. In case of errors you can review the log file for information. This file may also be requested by Advantest support personnel to debug any tool issues.
Before you begin
The Comparison Tool must be running and must have completed the comparison at least once.
Procedure
To view the log file click
To save the log file click Save As... The default location is your home directory. The default file name is RenewalLog.txt.
Example
Your log file may look as follows:
Tuesday, October 21, 2008 - 11:33 AM
>>>> Logging Started <<<<
Tuesday, October 21, 2008 - 11:33 AM
V93000 License Renewal Utility, Version 2009 (build 20080805.2211)
Tuesday, October 21, 2008 - 11:33 AM
Copyright(c) 2008, 2009 Verigy Limited, Verigy US Incorporated, All Rights Reserved.
Tuesday, October 21, 2008 - 11:33 AM
Loaded Verigy Products with Features File: products_with_features.csv
Tuesday, October 21, 2008 - 11:34 AM
Loaded Portal License Renewal Export File: Renewed_name -date .csv
Tuesday, October 21, 2008 - 11:34 AM
Loaded Portal To-Be-Renewed License Export File: To-Be-Renewed_name -date .csv
Tuesday, October 21, 2008 - 11:35 AM
Loaded Server Inventory File: license-inventory-server01.txt
