<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns:MadCap="http://www.madcapsoftware.com/Schemas/MadCap.xsd" MadCap:tocPath="About the RMS License Manager" MadCap:InPreviewMode="false" MadCap:PreloadImages="false" MadCap:RuntimeFileType="Topic" MadCap:TargetType="WebHelp" lang="en-US" xml:lang="en-US" MadCap:PathToHelpSystem="../" MadCap:HelpSystemFileName="Default.xml" MadCap:SearchType="Stem">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Creating License Manager Use Reports</title>
        <link href="SkinSupport/MadCap.css" rel="stylesheet" />
        <link href="Resources/Stylesheets/SFNT_Flare.css" rel="stylesheet" />
        <script src="SkinSupport/MadCapAll.js">
        </script>
    </head>
    <body>
        <p class="MCWebHelpFramesetLink MCWebHelpFramesetLinkTop" style="display: none;"><a href="../Default_CSH.htm#Creating_LicManager_Use_Reports.htm" style="font-weight: bold;">Open the Table of Contents</a>
        </p>
        <div class="MCBreadcrumbsBox_0"><span class="MCBreadcrumbsPrefix">You are here: </span><a class="MCBreadcrumbsLink" href="RMS_License_Manager_Overview.htm">About the RMS License Manager</a><span class="MCBreadcrumbsDivider"> &gt; </span><span class="MCBreadcrumbs">License Manager Reports</span>
        </div>
        <h1><a name="kanchor23"></a>Creating License Manager Use Reports</h1>
        <p>Sentinel RMS  provides the ability on Windows computers 
 to use Microsoft Access 97 to create graphical reports of License Manager 
 use. To use this feature, you will need to use the <a href="lsusage_Log.htm">lsusage -c 
 option</a> to create a comma-separated values (CSV) file from the License Manager log file. See the section above for information on this option. 
 By use of other lsusage options, you can create an output file with use 
 data for specific features and for specific time periods. Once you have 
 created the CSV file, here is how to create graphical reports:</p>
        <p class="SFNT_Note">You must have 
 Microsoft Access 97 on the computer on which you want to run reports. 
 Also, keep the number of features for which you are generating reports 
 to a reasonable number (15 to 20) or the reports may not be very easy 
 to read because there simply won’t be room for a clear display.</p>
        <div class="MCDropDown">
            <div class="MCDropDownHead_0"><a class="MCDropDownHotSpot_0" href="javascript:void(0);" id="MCDropDownHotSpot_1608659422_0" onclick="FMCDropDown( this ); return false;"><img style="border: none;margin-right: 5px;" src="SkinSupport/DropDownClosed.gif" MadCap:altsrc="SkinSupport/DropDownOpen.gif" onload="if ( typeof( FMCPreloadImage ) == 'function' ) { FMCPreloadImage( 'SkinSupport/DropDownOpen.gif' ); }" class="MCDropDownIcon" />To Import the CSV File</a>
            </div>
            <div class="MCDropDownBody" id="MCDropDownBody_1608659422_0" style="display: none;">
                <ul>
                    <li class="Numbered_Steps" value="1">Within Microsoft 
 Access, open the MDB 
 file provided with Sentinel RMS Development Kit: <span style="font-style: italic;">ReportDB.mdb</span>.</li>
                    <li class="Numbered_Steps" value="2">Select the <span style="font-weight: bold;">Table</span> tab.</li>
                    <li class="Numbered_Steps" value="3">Click <span style="font-weight: bold;">New.</span></li>
                    <li class="Numbered_Steps" value="4">Select <span style="font-weight: bold;">Import Table</span>.</li>
                    <li class="Numbered_Steps" value="5">Select the CSV 
 file you created with <span style="font-weight: bold;">lsusage</span> 
 and click <span style="font-weight: bold;">Import</span>.</li>
                </ul>
                <h3 class="SpacedHead"><span style="font-weight: bold;">Tip:</span> <![CDATA[ ]]></h3>
                <p class="SpacedPara2">In Microsoft 
 Access, not all file types are installed by default. If you do not have 
 the text file type installed, run the Access Setup program, click <span style="font-weight: bold;">Add/ Remove</span>, then select <span style="font-weight: bold;">Data 
 Access</span> and <span style="font-weight: bold;">Change Option</span> 
 to install the text file type.</p>
                <ul start="6">
                    <li class="Numbered_Steps" value="6">The <span style="font-weight: bold;">Import 
 Text Wizard</span> is displayed. Continue to click <span style="font-weight: bold;">Next</span> 
 until it asks “Where would you like to store your data?” </li>
                    <li class="Numbered_Steps" value="7">Select In an 
 existing table and select the table <span style="font-style: italic;">Lservlog</span>. 
 (If instead of adding to an existing <span style="font-style: italic;">Lservlog</span> 
 table you want to create a new one, delete any rows that are already in 
 the Lservlog table before importing new data.)</li>
                    <li class="Numbered_Steps" value="8">Click <span style="font-weight: bold;">Finish</span>. 
 Don’t forget to keep the table name set to <span style="font-style: italic;">Lservlog</span>.</li>
                </ul>
            </div>
        </div>
        <div class="MCDropDown">
            <div class="MCDropDownHead_0"><a class="MCDropDownHotSpot_0" href="javascript:void(0);" id="MCDropDownHotSpot_1608659422_1" onclick="FMCDropDown( this ); return false;"><img style="border: none;margin-right: 5px;" src="SkinSupport/DropDownClosed.gif" MadCap:altsrc="SkinSupport/DropDownOpen.gif" onload="if ( typeof( FMCPreloadImage ) == 'function' ) { FMCPreloadImage( 'SkinSupport/DropDownOpen.gif' ); }" class="MCDropDownIcon" />Creating Reports</a>
            </div>
            <div class="MCDropDownBody" id="MCDropDownBody_1608659422_1" style="display: none;">
                <p>Once the log file use data is imported into the <span style="font-style: italic;">Lservlog</span> 
 table as discussed above, you can now create reports for that data.</p>
                <ol>
                    <li class="Numbered_Steps" value="1">Within Microsoft 
 Access, open the <span style="font-style: italic;">ReportDB.mdb</span> 
 file. You will immediately see the Sentinel RMS Development Kit report 
 selection screen.</li>
                    <li class="Numbered_Steps" value="2">You can now select 
 the date range of the report by specifying <span style="font-weight: bold;">Start 
 Date</span> and <span style="font-weight: bold;">End Date</span>.</li>
                    <li class="Numbered_Steps" value="3">Now select the 
 type of report you want to create. </li>
                </ol>
                <p class="SFNT_Note">The "per 
 user" and "per host" versions of the reports mentioned 
 below also exist. </p>
                <ul>
                    <li class="Bullets_1" value="1"><span style="font-weight: bold;">Total 
 Tokens Granted Per Feature</span>: This report demonstrates the total 
 number of license tokens granted in the specified date range for each 
 feature. </li>
                    <li class="Bullets_1" value="2"><span style="font-weight: bold;">Maximum 
 Tokens Granted Per Feature</span>: This report demonstrates the maximum 
 number of token granted for a feature in a single request done specified 
 date range. </li>
                    <li class="Bullets_1" value="3"><span style="font-weight: bold;">Average 
 Tokens Granted Per Feature</span>: This reports the average number of 
 feature tokens granted for date range on the basis of minutes/hours/days/weeks. 
 </li>
                    <li class="Bullets_1" value="4"><span style="font-weight: bold;">Total 
 Minutes Used Per Feature</span>: &#160;This 
 report demonstrates the total time (in minutes) each feature was used 
 in the specified date range. </li>
                    <li class="Bullets_1" value="5"><span style="font-weight: bold;">Total 
 No. Of Tokens Denied Per Feature</span>: This report demonstrates the 
 total number of license tokens for which request was denied in the specified 
 date range. </li>
                    <li class="Bullets_1" value="6"><span style="font-weight: bold;">Percentage 
 Tokens Denied Per Feature</span>: This report demonstrates the percentage 
 of tokens for which request was denied in the specified date range. This 
 percentage is calculated over total number of tokens requested per feature.</li>
                </ul>
                <h3 class="SpacedHead"><span style="font-weight: bold;">Tip:</span> <![CDATA[ ]]></h3>
                <p class="SpacedPara2">When using lsusage 
 to create the CSV file that is the input to these reports, you can limit 
 the data to usage information for specific features and versions.</p>
            </div>
        </div>
        <p>&#160;</p>
        <script type="text/javascript" src="SkinSupport/MadCapBodyEnd.js">
        </script>
    </body>
</html>