License Statistics v6.21 - New features and enhancements

License Statistics v6.21 introduces improvements that reduce host duplication and simplify license activation

With License Statistics version 6.21, we’ve introduced new features and enhancements that reduce host duplication and simplify license activation, as well as improving performance, consistency of report grids, and data validation. Read on to find out more about what’s new in License Statistics v6.21.

Duplicated host merging

In most cases, both remote monitoring server output and imported log files contain the hostname and IP address of the host where the license is used. However, In some rare cases, the license server may not report complete host identification.

Multiple licenses from different license managers can be used on the same host, but if one server reports a hostname and another does not, this results in a duplicated host – one with a hostname and the second with only an IP address. In License Statistics reports, duplicated hosts are seen as two separate hosts and are counted twice to the licensing.

With the introduction of Host Merging in License Statistics v6.21, you can now resolve issues where there is a one-to-one match of a single known hostname and a single unknown hostname that have the same IP address by merging the duplicate hosts.

Note that if there are multiple hosts with different hostnames and the same IP address, they cannot be merged, because it is not possible to determine which hosts should be merged.

For complete information about using the new Host Merging capability, see License Statistics documentation.

Host details resolution

In addition to the Host Merging feature described above, License Statistics v6.21 also includes a new capability that allows finding missing host identification details during remote querying or log file importing, thereby avoiding duplicate hosts (a single known hostname and a single unknown hostname with the same IP address) in License Statistics reports.

The host details resolution options allow for DNS and/or Reverse DNS lookup:

  • DNS lookup finds the missing IP address in the network based on hostname
  • Reverse DNS lookup finds the missing hostname in the network based on IP address

The enabled lookup option(s) are executed automatically during remote querying of license servers or log file importing when a hostname or IP address is missing. The hostname(s) and/or IP address(es) that are found will then be used for future processing and report generation, thereby limiting the risk of duplicated hosts.

See the License Statistics documentation for complete information about using host details resolution for remote license servers and using host details resolution for import logs.

Simplified license activation for License Statistics hosts without internet connection

In past License Statistics versions, license activation could be performed directly from the License Statistics UI except when there was no internet connection on the License Statistics host. In such cases, activating a license required using License Activation Center (LAC) tools (License Activator or lacutil) on a different machine.

With this release, you can now activate the license directly in the License Statistics “Administration: Licensing” page, using a browser that has an internet connection (for example, a private laptop). You simply enter the activation key in the Management tab’s License Activation field (if not already filled in), and click Activate.

If successful, the activation process will be executed directly in the browser. In the rare cases that the activation is not successful (for example, there are network issues), you’ll be provided with a link to complete the activation in LAC.

As a result of this new capability, the LAC tools lacutil and License Activator have been removed as of License Statistics v6.21.

See License Statistics documentation for complete instructions on how to activate a License Statistics license on a machine without access to the internet.

Database tables updated to use lowercase

In prior versions of License Statistics, the use of capital letters in the database caused problems when moving from Windows (case-insensitive) to Linux (case-sensitive).

This new version of License Statistics solves this problem by making all tables lowercase, which significantly simplifies moving a License Statistics installation from one host to another.

See the License Statistics documentation for information about moving License Statistics from one host to another.

In addition to the new features and enhancements described above, this release includes many other enhancements that improve performance, consistency of report grids, and data validation. For a complete list of enhancements and fixes, see License Statistics v6.21 Release Notes.

With the improvements made in License Statistics v6.21, we hope we’ve made your license management even more efficient and effective. As always, we appreciate your feedback, so please let us know what you think of the License Statistics v6.21 new features and enhancements, and don’t hesitate to contact support@x-formation.com with any questions. We look forward to hearing from you!

X-Formation - Year in Review - 2023

X-Formation – Year in Review – 2023

It’s hard to believe–already, another year is coming to a conclusion. Looking back at the busy year that 2023 proved to be, we are filled with gratitude for all that each and every member of our team has contributed to X-Formation’s successes.

This gratitude extends to you, our customers. Since our beginnings nearly two decades ago, we’ve considered you to be our greatest collaborators. Your input about what’s important to you has provided invaluable guidance to help us to develop license management solutions that make a real difference to hundreds of organizations worldwide.

In this article, we’d like to share with you what we consider to be some of our most important accomplishments over the past year for both License Statistics and LM-X License Manager.

License Statistics

As usual, our License Statistics team has worked hard to expand and improve on all areas of License Statistics, from enhancing ease of use to increasing stability and performance. Let’s take a look at the most notable new features we added to License Statistics in 2023.

License Harvesting

We’ve added two new License Harvesting release methods–Dry Run and Suspend–that give you even greater flexibility for tracking and helping to reduce the waste of idle end-user applications.

Dry Run method

The new “Dry Run” release method is the least aggressive release method, particularly useful for testing how License Harvesting works with specific applications without taking action to close those applications.

This new method is perfect for situations where you want a history of license usage, but you’re concerned about disrupting end users’ work, as you can choose not to alert the user. In this case, application events will be detected and logged, but the end users of the monitored applications won’t receive any alerts for idle applications.

If you do choose to issue an alert, the Dry Run method will inform end-users that their application is idle and recommend that they close it. However, no action will be taken, giving the end user the choice to leave the application open or close the application, as best suits their current situation.

Suspend method

The new Suspend harvesting method gives you more flexibility in the way that you enforce the release of idle licenses. The Suspend method “freezes” the idle license so it can be released to the license pool, and issues an alert to the end user to inform them that use of the application is suspended.

Although the user cannot use the application while suspended, the application remains visible and no data is lost. The end user can resume using the application by responding to the alert or by using the License Harvesting tray icon.

License Statistics Agent

This past year has seen significant improvements for License Statistics Agent, with enhanced license server management, auto-update capabilities, and adjustable agent connection intervals.

License server management

With the addition of server mode for License Statistics Agent, License Statistics administrators can start, stop and restart license servers directly from the Administration > License Servers page within the License Statistics UI. Previously, license server management required going outside of the License Statistics UI, connecting to the proper license server host using SSH or a remote desktop, finding the service/administration tool, and restarting the server.

License Statistics Agent server mode adds convenience and can save considerable time, especially if you’re managing a large number of servers on different hosts or you’re handling numerous requests from users to free up licenses that have become unavailable (for example, due to an application closing ungracefully and taking a long time to release licenses back to the pool).

What’s more, License Management auto-detection using Server Agent detects the services available for the license servers on the host where the selected agent is installed, and the detected services can be used to manage the server remotely (start/stop/restart).

Auto-updating of Agents

Managing License Statistics Agents couldn’t be easier with our newly introduced automatic update capabilities. Simply toggle on the Auto Update option available from License Statistics’ End User Agents page, and License Statistics will schedule updating Agents (version 6.20 or newer) as a newer version becomes available.

You can also schedule updates for individual Agents manually. License Statistics informs you when a newer Agent version is available, and lets you schedule the update procedure with a single click.

Ability to adjust Agent connection interval

We added the ability to adjust the connection interval for License Statistics Agent. Previously, this interval was set to 30 seconds (still the default) and couldn’t be changed. Now, you can increase the interval to up to 10 minutes.

When there are a large number of End User Agents, increasing the connection interval setting will reduce the occurrence of redundant connections, thereby improving performance, with no impact on functionality or difference in the data that’s gathered.

User Experience

Over the past year, we’ve made improvements that help users to better work with and understand License Statistics reports, including dynamic date ranges and improved indicators in reports that show last update time.

Dynamic date ranges

Reports that were filtered using date ranges (for example, “Last Week,” “Last Month,” “Current Quarter,” etc.) used to be static, so reports added to the Dashboard became outdated, showing dates relative to the date the report was generated.

Our newly introduced dynamic date ranges base date ranges on the current date, so reports added to the Dashboard that are filtered using date ranges always contain data relative to today’s date. This alleviates the need to regenerate such reports, saving you time and ensuring that the data you’re viewing is more meaningful.

Last update time indicators

In the last update time color indicators displayed in grids, we now use query intervals elapsed rather than time elapsed, so it’s easier to understand when the last successful query was made.

Administration

We’re always looking for ways to make License Statistics administration easier and more flexible. License storage and management simplification, availability of API resource information, ability to close sessions manually from reports, and the addition of a new Command Line Interface (CLI) tool are among the major improvements introduced during the past year.

License storage and management

In previous versions, License Statistics had to scan the entire directory to find the best license file, since the file could be kept either in the default directory or in a user-specified location. Now, the License Statistics license is stored as an entry in the database, making license management more efficient and secure.

You can also now manage the license using a new Management tab on the Administration > Licensing page that lets you easily view the current Activation Key, reactivate the key, or activate a new key. With this new approach, License Statistics Administrators will find managing the license much more straightforward.

The Licensing page’s Management tab can also be used to upload a license file. This ability is particularly useful when there’s no internet connection on the License Statistics host, the license was activated on a different machine, the license was downloaded from the LAC end-user portal, or other cases where you already have a file to upload.

The Management tab even gives you a license preview, so you can see the current license contents and when the license was last uploaded.

Ability to view API resources

License Statistics reports now let you view details of the API request used to generate the report, including the headers, endpoint and used parameters. This information can be used to facilitate integration with other applications that you want to allow to access License Statistics data; for example, PowerBI or Excel.

Session closing from reports

License Statistics administrators can now more quickly and easily close sessions on the license server and return the license to the available pool using the Features Realtime Sessions and Users Realtime Sessions reports. (Currently available for LM-X and FlexNet license managers only.)

New CLI tool

A new CLI (Command Line Interface) tool replaces the use of scripts. The CLI can alternatively be used for license management as well as other administrative operations such as backing up the database and resetting the default admin user/password.

Linux installers

We’ve introduced the following new Linux installers to help make installations quicker and easier:

  • RPM (RedHat Enterprise Linux distributions)
  • DEB (Ubuntu and Debian distributions)
  • Generic, which allows for customization and/or installation on distributions other than RPM or DEB

The RPM and DEB installations will provide for automatic upgrades from v6.17 on. Upgrading older License Statistics versions to v6.17 and newer still requires a one-time manual upgrade, as done for all previous releases. However, after upgrading to v6.17, you’ll be able to upgrade License Statistics on Linux to v6.17 and newer without uninstalling.

LM-X License Manager Achievements

Over the past year, our LM-X team has stepped up to the challenge of fixing complex issues, ensuring good performance, and maintaining the stability that you’ve come to expect from our full-featured license manager solution. We appreciate your patience and cooperation as we’ve worked hard to solve your unique problems as quickly as possible while continuing to deliver improvements that meet your needs.

Let’s take a look at some of the new features and improvements made by the LM-X team over the past year.

Improved performance

Recognizing the need to optimize performance, we’ve made several improvements that add up to an incredible 30% overall performance increase, including:

  • Upgrading the system used for managing network connections
  • Adding caching for HAL servers state to reduce connection delay when the first server is down
  • Optimizing performance of LM-X license server and client
  • Improving client network optimization by reusing buffers
  • Making token loop detection quicker by performing it only once during license server startup

Expanded support

Many of our customers are moving their licensing to the cloud. To support this growing need, we’ve added a new CLOUD sharing type that gives you the ability to restrict licensing for cloud environments, and we’ve made improvements to optimize cloud detection.

In addition, we’ve added support for Linux 32 bit on ARM, increasing flexibility in how you license your software.

Improved logging and notifications

We’ve made several improvements that help you to get more detailed, focused information from logs, notifications and other types of reporting.

The information available in the client extended log during license checkin has been improved, including the ability to see the vendor’s environment variables, such as connection timeout. The contents of the startup log have also been improved, to give you more clear information about startup events.

In addition to improving logging to give you the information you need, we expanded other communications and notifications, including adding a new option to xmllicgen to display the expiration date, making more information available for harddisk HostIDs, and improving clock check error messages.

New filtering capabilities let you omit unneeded data, with the addition of a flag that filters out virtual ethernet adapters from the HostID list and the ability to filter out empty BIOS HostIDs.

API additions

The LM-X API has been expanded, with the addition of a new function that accommodates virtual machine discovery and cloud host detection. We also introduced brute force password protection and a new administrative API function that allows for password verification when adding an LM-X license server to License Statistics.

Installation improvements

The Linux installer checks for required packages prior to installation and does not proceed with the installation if any required packages are missing.

We’ve also replaced the deprecated license server System V init scripts with systemd init scripts, and added an option to the Windows installer to open required ports.

We want to thank YOU!

As we look back on all the hard work that’s gone into 2023 and recognize our incredible, talented X-Formation team, we want to also be sure to acknowledge you, our customers. We sincerely value the close working relationship that we’ve fostered together. Without your feedback about what’s working and what isn’t, your insightful ideas for improvements, and your willingness to stick with us as we work through tough problems, we couldn’t continue to do what we care so much about: help your business to be more successful.

Our X-Formation team extends our heartfelt thanks to you and yours, and we wish you a joyous, safe holiday and a Happy New Year!

Henrik Goldman
X-Formation Founder and CEO

License Statistics v6.20 - New features and enhancements

License Statistics v6.20 introduces new and improved features, boosting usability and performance

With License Statistics version 6.20, we’ve introduced new features and enhancements that improve usability, performance and stability. Read on to find out more about what’s new in License Statistics v6.20.

New “Dry Run” License Harvesting release method

If you’ve been using–or thinking about using–License Harvesting to track and cut down on idle end-user applications, but are concerned about disrupting your end users’ work, you’ll be interested in our new “Dry Run” release method. The Dry Run method is the least aggressive release method, particularly useful for testing how License Harvesting works with specific applications without taking action to close those applications.

The Dry Run method gathers information about application usage, and optionally issues an alert to inform end-users that their application is idle and recommend that they close it. The alert gives the end user complete control over whether to close the idle application. The user can choose to simply dismiss the message and leave the application open, or the user can close the application, as best suits their current situation.

If you just want to gather information about idle licenses, the Dry Run method lets you choose not to alert the user at all. The Dry Run method will continue to detect and log all application events, ensuring that the administrator has a history of the license usage, but won’t disrupt the end users of the monitored applications.

New auto-update capabilities for License Statistics Agent

This release makes managing License Statistics Agents even easier with the introduction of automatic updates. Simply toggle on the Auto Update option available from License Statistics’ End User Agents page, and License Statistics will schedule updating Agents (version 6.20 or newer) as a newer version becomes available.

You can also schedule updates for individual Agents manually. License Statistics informs you when a newer Agent version is available, and lets you schedule the update procedure with a single click. The request to update the Agent will be made on the next connection. The Agent will download the newer installer from the local License Statistics server (not from any external source or the internet), run the installer, update itself, and reconnect to License Statistics. The Agent informs you of the Update progress using an indicator in the End User Agents table.

(Note that the number of agents that License Statistics schedules to update at the same time is limited to 20 to avoid doing mass updates for setups that have a large number of Agents.)

Improved notifications and other user interface communications

With this release, we’ve made several improvements to the License Statistics user interface, including changes to the way that last update time is reported in grids. Now, last update time color indicators use query intervals elapsed rather than time elapsed, so it’s easier to understand when the last successful query was made.

License Statistics v6.20 also includes improvements to notifications and other communications, such as:

  • improved end-user notifications that display a Custom Application’s name instead of the executable name for Custom Applications
  • a new notification for mismatched operating system requirements
  • a more detailed message in the alert that displays when access to grid data is forbidden
  • more concise log information for “Unauthorized 401” errors

Fixes to prior versions of License Statistics

In addition to the new features and enhancements described above, this release fixes over a dozen issues that existed in previous versions of License Statistics. These fixes result in overall increased stability and improved performance across many areas of License Statistics, including the user interface, License Statistics Agent, license managers, the API, and the system architecture.

With these most recent improvements, we hope that License Statistics 6.20 will be even better at fulfilling your license management needs. As always, we appreciate your feedback, so please let us know what you think of the License Statistics v6.20 new features and enhancements, and don’t hesitate to contact support@x-formation.com with any questions. We look forward to hearing from you!

Why use License Statistics

Why LS

Software asset management is a critical part of nearly any business’s success. Software can be very expensive, as well as critical to productivity. A lack of control and understanding of how your software licenses are being used can negatively impact decision making when it comes time to renew or purchase software. Gaining clear insight into your license usage helps both lower the costs and increase the value of your software purchases.

License Statistics offers a complete solution for tracking license usage–whether on the cloud or in-house–that combines full features with unbeatable usability. With support for over 30 different license server types, plus the ability to configure custom applications for monitoring, License Statistics provides extensive flexibility, giving you the ability to monitor all your license servers individually, across your entire organization.

Perhaps best of all, you can begin realizing the benefits that License Statistics offers from day one. License Statistics reports your license tracking information using charts and graphs that anyone can understand, and getting up and running is quick and easy. Simply open License Statistics in any standard web browser, and instantly get the information you need to optimize your organization’s license usage, including:

  • Which users are consuming the greatest number of licenses, during what hours, and on which hosts, giving you insight into licensing needs per department or region:License Statistics - Current users
  • Which licenses are unused or underused, eliminating wasted software spend:License Statistics - Current utilization
  • Which licenses are in high demand, how often users are denied access to critical software, and when users keep licenses checked out unnecessarily:License Statistics - User denials
  • Comparison of current and historical usage, helping you to more accurately project optimal budgeting and purchasing strategies:License Statistics - Feature utilization
  • Which licenses are nearing expiration, so you you’re always up-to-date with your maintenance renewals:License Statistics - Feature expiring in next 12 months
  • Which license servers are up and running, helping you quickly differentiate between various license server statuses:License Statistics - License server uptime

License Statistics makes sharing all of this invaluable information between departments simple and straightforward. With a single click, any report can be exported to a CSV, XLSX or PDF file, so everyone in your organization, from individual software users, to IT administrators, to department managers, can stay informed and make sound decisions about software license usage.

Going beyond simple reporting, License Statistics automates license optimization with Custom Application Monitoring and License Harvesting, helping you cut down on underutilized licenses and associated costs. Custom Application Monitoring lets you monitor and control any Windows application, independently of the vendor and license server, gaining accurate information about your organization’s license usage and needs.

Any application set up for Custom Application Monitoring can also be set up for License Harvesting, which automates license sharing by detecting and releasing idle licenses.

License Statistics - Edit custom application

Using License Statistics Agent, License Harvesting monitors whether a configured application is actively used. Typically, License Harvesting is used to monitor applications that are licensed using network, token or pay-per-use licensing models, but can be used for any application that you want to prevent from running outside of predefined hours or being idle for a predetermined length of time on the host machine.

When an idle state is detected, License Harvesting releases the license using your preferred method, such as asking the user to close the application or closing it automatically.

License Statistics - License harvester

If you want to experience the cost-saving benefits of a truly robust, easy-to-use license management and optimization solution that can help you gain control over your IT assets and improve your company’s business operations and profitability, contact us today to find out more about License Statistics!

Get to know License Statistics

License Statistics - minimize software license waste and maximize productivity for reduced workforces

Make the most out of a reduced workforce with License Statistics

As many businesses continue to contend with a challenging global economy, reducing workforce to a bare minimum has been necessary for some to stay afloat. Usually taken as a last measure, cutting back on your number of employees may help provide some needed relief, but are you taking all the necessary steps to realize the maximum savings associated with having fewer employees?

One often-overlooked area when decreasing expenses related to individual employees is IT spend. You may not have considered the huge impact that unused or underused software licenses can have on your bottom line. Not only will License Statistics help you eliminate unnecessary IT spend, it will also help you make the most of your existing licenses, ensuring that your reduced workforce is as productive as possible.

Eliminate unused and underused software licenses

As a result of reducing your number of employees, your software license needs will undoubtedly change. Without effective license management in place, you run the risk of having expensive software licenses laying about entirely unused, while other software licenses may actually increase in demand as a result of shifting responsibilities and workloads.

Clearly, with many software licenses costing multiple hundreds or even thousands of dollars a year, not to mention related costs for support and hardware, your savings realized by cutting down on software license waste could be considerable.

Improve productivity

While you want to slash costs related to unused software, you also want to be sure that employees have reliable access to the software they need. Especially after changes in staffing levels, gaining a clear understanding of your new software license usage needs is crucial.

When employees have the latest technologies and consistent access to those resources, they’re able to do their jobs more productively. If reducing your workforce has increased the workload for your remaining employees, you must be particularly diligent in ensuring your remaining employees have all they need to get their work done efficiently.

Get a handle on IT spend

License Statistics delivers invaluable information about how your licenses are used so that you can reevaluate your IT spend. Properly managing your IT assets can have exponential effects. Not only is there an immediate savings on software spend, but as your IT team gains clarity regarding exactly what your expenses are and where you can reduce them, your license management program can continue to result in savings for your business year after year.

With support for over 30 different license managers, as well as the ability to be used with desktop applications and custom software, License Statistics is the only license management tool you need. License Statistics is easy to use and supplies readily understood, shareable reports on license usage throughout your organization.
Laying off employees is never easy. Make sure to get the maximum savings associated with a reduced workforce through proper IT management with License Statistics.

Get to know License Statistics

License Statistics v6.19 - New features and enhancements

License Statistics v6.19 brings you increased performance and versatility

With License Statistics version 6.19, we’ve introduced many new features and enhancements that are aimed at making License Statistics more versatile, as well helping you maximize its performance. Let’s take a look at some of the major improvements we’re bringing to you with License Statistics v6.19.

Dynamic date ranges

In previous versions of License Statistics, reports that were filtered using date ranges (for example, “Last Week” or “Current Quarter”) were static, so always showed results relative to the date the report was generated. With v6.19, we’ve greatly improved this capability by enabling dynamic date ranges, which are always relative to the current date.

With this new handling of date ranges, when you add a report to the Dashboard, you’ll always see the appropriate report for the current week, last week, current month, last quarter, etc., relative to today’s date.

Keep in mind that you’ll need to replace any existing reports you’ve added to the Dashboard with a newly generated report using v6.19 or newer in order to see dynamic date ranges in the Dashboard.

New Suspend License Harvesting method

This release adds a new Suspend harvesting method to the License Harvesting modes, giving you more flexibility in the way that you enforce the release of idle licenses.

The Suspend method “freezes” the application so it can be released to the license pool. Although the application cannot be used while suspended, it remains visible to the end user, and no unsaved data is lost. The end user can resume using the application by responding to an alert issued when the application first becomes suspended, or they can resume use of the application at any time using the License Harvesting tray icon.

To use the new Suspend method, you must have License Statistic Agent v6.19 and install the free Optional Harvesting Tools, which is easily done during installation or upgrade of License Statistics v6.19 (or newer).

Ability to adjust Agent connection interval

License Statistics v6.19 adds the ability to adjust the connection interval for License Statistics Agent, which can provide significant performance benefits.

In previous releases, this interval was set to 30 seconds (still the default) and could not be adjusted. Now, you can increase the interval to up to 600 seconds (10 minutes). When there are a large number of End User Agents, increasing the connection interval setting will reduce the occurrence of redundant connections, thereby improving performance, with no impact on functionality or difference in the data that’s gathered.

While increasing the interval can benefit performance, keep in mind that with a higher connection interval, configuration changes will be applied to Agents less often.

Manual session closing

License Statistics administrators will enjoy the added convenience of being able to close sessions on the license server directly from Features Realtime Sessions and Users Realtime Sessions reports.

Administrators can manually force the session to release on the corresponding license server and return the license to the available pool. (Available for LM-X and FlexNet license managers only.)

Additional new features and enhancements

In addition to the changes detailed above, this release brings you a number of other new features and enhancements, most notably:

We hope that the new features and enhancements we’ve incorporated into License Statistics will be valuable for meeting your license management needs. As always, we appreciate your feedback, so please let us know what you think of the new features and enhancements we’ve delivered with License Statistics v6.19, and don’t hesitate to contact support@x-formation.com with any questions. We look forward to hearing from you!

Importing License Statistics data to Amazon QuickSight

Amazon QuickSight is a cloud-scale business intelligence (BI) service that lets you connect to and combine your cloud data from many different sources – such as AWS data, spreadsheet data, third-party data, etc. – in a single dashboard. Many of our customers gain new insights into usage data by importing the data from License Statistics reports into QuickSight, where they can prepare and “Visualize” the data to be shown in dashboards.

As a SaaS solution, QuickSight doesn’t have direct access to License Statistics or its database that’s installed at the customer site. Although there are a few approaches you could take, our recommended solution for importing License Statistics data to QuickSight is to import a comma-separated file (.csv) to the QuickSight service, which we’ll cover in this article, including:

  1. Downloading License Statistics report data to a .csv file
  2. Creating a new dataset from an imported file
  3. Preparing and visualizing the data
  4. Updating the file contents if needed

This article does assume some basic knowledge of using QuickSight, so if you aren’t familiar with its usage, please see complete help for QuickSight at https://docs.aws.amazon.com/quicksight.

Let’s get started!

Download License Statistics report data to a .csv file

First, download the License Statistics report data you want to import to QuickSight. For our example, we’re exporting data to .csv format.

To download report data, select “.csv” from the options under the Save As button at the bottom right of any License Statistics usage data list. (Note that License Statistics handles exporting the report data, so downloading reports does not require an internet connection.)

License Statistics - download data to a comma-separated file (csv)

See License Statistics help for complete details on downloading License Statistics data.

Create a new dataset from an imported file in QuickSight

  1. Make sure your .csv file complies with QuickSight’s data source limits. Your file must be 1GB or less.
  2. From the Amazon QuickSight start page, click Datasets to access the Datasets page.
    License Statistics - Importing data to Amazon QuickSight - step 1 - datasets
  3. Click New dataset in the upper right of the page to open the Create a Data Set page, which allows you to create a new dataset.
    License Statistics - Importing data to Amazon QuickSight - step 2 - new dataset
  4. Click Upload a file in the upper left of the page to browse for an existing file.
    License Statistics - Importing data to Amazon QuickSight - step 3 - upload a file
  5. Browse to the location where you saved the .csv file, select the file, and click Open to open the file. (If you need to update the file, see “Refresh the existing dataset,” below.)
  6. You can either create an analysis using the License Statistics data as-is or prepare the data before creating the dataset.
    1. If no data preparation is needed, click Visualize. This will result in the dataset being named identically to the source file name. You can learn complete details about using QuickSight Visualization in the QuickSight documentation section, Visualizing data in Amazon QuickSight.
    2. If you need to prepare the data first, click Edit/Preview data. This will let you make any needed adjustments, as well as specify a dataset name, prior to using Visualization. You can learn complete details about data preparation in the QuickSight documentation section, Preparing data in Amazon QuickSight.

Refresh the existing dataset (optional)

Optionally, you can update files in your dataset whenever needed to get the latest version of the .csv file.

Note: Before updating a file, always make sure that the fields in the new file are identical and in the same order as the original file in the dataset. Otherwise, an error will occur and you’ll need to edit the new file to match the original file, and then try updating again. If you need to add new fields to the file, be sure to append them after the original fields.

To update the file:

  1. From the Datasets page, select the dataset you want to update, and then click Edit dataset. This will open a data preparation page.
  2. Click on the caret next to the file you want to update, and from the drop-down menu, choose Update file. This will open the Update file page.
    License Statistics - Importing data to Amazon QuickSight - step 4 - update file
  3. Click Upload file, and then navigate to and select the .csv file. QuickSight will scan the selected file.
  4. Click Confirm file update from the page that opens. You’ll see a preview of some of the sheet columns for reference to ensure you’ve selected the correct file.
  5. When the update is complete, a message at the upper right of the page will indicate the success of the update, and the table preview will refresh to display the new file contents.

We hope this article has helped you understand how to get even more value out of your License Statistics data by importing it to QuickSight. If you have questions or comments, please don’t hesitate to contact us!

Get to know License Statistics

License Statistics v6.18

License Statistics v6.18 is chock-full of major improvements and new features

With License Statistics version 6.18, we’ve introduced a combination of over 40 new features and enhancements that are sure to make License Statistics even more easy and efficient to use. Let’s take a look at some of the major improvements we’re bringing to you with License Statistics 6.18.

Auto-detection of license servers on the host with Server Agent

License Management auto-detection using Server Agent detects the services available for the license servers on the host where the selected agent is installed, and the detected services can be used to manage the server remotely (start/stop/restart).

License storage and management changes

One of the most significant changes in this version involves storage and management of the License Statistics license.

As of this version, the License Statistics license is no longer kept as a file, but as an entry in the database. In previous versions, License Statistics used to scan the entire directory to find the best license file, since the file could be kept either in the default directory or in a user-specified location. By storing the file in the database, license management has been made more efficient and secure. To configure the license, you can now use either the License Statistics Manager or the new CLI, giving you options that fit your needs.

Rather than using the License Statistics Manager, management of the license can now be done directly from the UI, using a new Management tab available on the Administration > Licensing page. As part of this change to the UI, the Licensing page is now split into three tabs: Usage, History, and Management.

With this new approach, License Statistics Administrators will find managing the license much more straightforward. The new Management tab lets you easily view the current Activation Key, reactivate the key, or activate a new key.

In addition, you can use the Licensing page’s Management tab to upload a license file (for example, if there’s no internet connection on the License Statistics host, the license was activated on a different machine, the license was downloaded from the LAC end-user portal, or other cases where you already have a file to upload.

The Management tab even gives you a license preview, so you can see the current license contents and when the license was last uploaded.

Introduction of new CLI tool

This version also introduces a new CLI (Command Line Interface) tool, which replaces the use of scripts. The CLI can alternatively be used for license management as well as other administrative operations such as backing up the database and resetting the default admin user/password.

Ability to view API resources

Along with numerous improvements to data made available in reports, License Statistics reports now include the ability to view API resources.

For most reports (other than Administration reports, which do not support a public API), you can see a preview of the API resources for that report by clicking a “Show API resource” icon at the upper right corner of the report.
After clicking this icon, an API Resource window opens, with details of the API request used to generate the report, including the headers, endpoint and used parameters. You can use this information to facilitate integration with other tools, such as PowerBI, Excel or any other application that you want to allow to access the License Statistics data.

Additional enhancements

In addition to the changes detailed above, this release contains nearly 40 enhancements, among them:

  • MySQL has been upgraded to v8.0
  • The Enable Harvesting area of the Harvesting tab has been redesigned, making it easier to set up triggers for harvesting
  • Anonymization of hosts now includes the IP address in addition to the host name
  • The main feature for Autodesk is now included in reports when using Feature Collections
  • New columns have been added to reports, including a License Server multicolumn for several reports and Expiration Date subcolumns for grids that contain a Feature multicolumn
  • You can now import FlexNet logs with multiple vendor daemons by setting the Vendor Daemon Name (this setting has been moved from the Remote Monitoring tab to the General tab under the License Servers page)
  • Autodesk features can now have human-readable display names
  • Restarting the service using License Statistics Agent has been improved by displaying a Restart confirmation message only when the service is up, and allowing you to restart directly from the confirmation message or at any time by using a new Restart tray option

We hope that these significant new features and enhancements will help to make License Statistics easier for you to use and manage. As always, we appreciate your feedback, so please let us know what you think of the new features and enhancements we’ve delivered with License Statistics v6.18, and don’t hesitate to contact support@x-formation.com with any questions. We look forward to hearing from you!

How to import data from License Statistics into Excel using Power Query

How to import data from License Statistics to Excel using Power Query

Many of our License Statistics customers are using Excel’s Power Query tool to transform and prepare data. Power Query not only lets you import data from a variety of sources, but gives you the ability to transform and use the data to suit your needs. Using Power Query, you can set up a query once, and then reuse the query by “refreshing” the data as often as needed.

This article gives you step-by-step instructions specifically for importing License Statistics data directly into Excel using Power Query.

  1. In Excel, click From Web under the Data ribbon to open the Power Query editor.
    Import License Statistics data into Excel using Power Query 1
  2. In the From Web pane, toggle on Advanced
    Import License Statistics data into Excel using Power Query
  3. Under the URL parts area, add lines for the parts as shown in the following table and illustration:
    Part typeSetting

    Host

    http://ls-lin-stage.int.x-formation.com

    API path

    /api/v3/license-server/15/usage-per-user/json

    Query parameters
    • lsid=15
    • sd=2023-01-01
    • ed=2023-01-31
    • grat=DAY
    • agrt=USER_HOST
    • offset=0
    • limit=100

    Import License Statistics data into Excel using Power Query 2

  4. Under “HTTP request header parameters,” add an X-Auth-token header using a token generated from License Statistics, and click Add header.Import License Statistics data into Excel using Power Query 3
  5. Click OK to continue.
  6. Choose Anonymous as the web content access type, and click Connect.Import License Statistics data into Excel using Power Query 4
  7. Click Info Table under the Content ribbon.
  8. Optionally, you can name the query using the Properties area under Query Settings. In our example, we named the query “Usage Per User” to indicate the type of data being retrieved.Import License Statistics data into Excel using Power Query 5
  9. Select data list from the table.Import License Statistics data into Excel using Power Query 6
  10. Click To Table under the Transform tab to convert the data list to a table.Import License Statistics data into Excel using Power Query 7
  11. In the resulting “To Table” pane, choose None as the delimiter, and choose Show as errors to handle extra columns.Import License Statistics data into Excel using Power Query 8
  12. Click OK.
  13. Click the expand icon in the upper right of the Queries table to expand the table columns.Import License Statistics data into Excel using Power Query 9
  14. Click Load more at the bottom of the list to load all the columns.
    Import License Statistics data into Excel using Power Query 10
  15. Select the columns to include in the query; for example:
    • un
    • hn
    • lsn
    • fns
    • fv
    • massage
    • hu
    • mu
    • ldtc
    • ft
      Import License Statistics data into Excel using Power Query 11
  1. Optionally, you can rename columns by right-clicking on the column header and choosing Rename from the right-click menu.Import License Statistics data into Excel using Power Query 12
    For example you might rename columns to their corresponding label found in License Statistics:
    • us = Username
    • hn = Host
    • lsn = License Server
    • fns = Feature Name
    • fv = Feature Version
    • musage = Max Usage
    • hu = Hours Used
    • mu = Max Used
    • ldtc = Denials
    • ft = Total
  1. Click Close & Load.Import License Statistics data into Excel using Power Query 14
  2. If you want to refresh data automatically, perform the following additional steps:
    • Go to Queries & Connections under Excel’s Data tab, and select Properties.
      Import License Statistics data into Excel using Power Query 15
    • In the External Data Properties dialog, click Query Properties.
      Import License Statistics data into Excel using Power Query 16
    • Under the Usage tab, set the refresh options as desired.
      Import License Statistics data into Excel using Power Query 17

We hope this article has been helpful for understanding all you need to know to import your License Statistics data into Excel using Power Query. If you have questions or comments, please don’t hesitate to contact us!

Get to know License Statistics

License Statistics - Siemens NX license server monitoring

How to set up Siemens NX license server monitoring

Based in Munich, Germany, and with offices abroad, Siemens Digital Industries Software (previously Siemens PLM) is Europe’s largest industrial manufacturing company. One of their most popular products is NX, a CAD/CAM/CAE commercial software suite that provides leading-edge design, simulation, and manufacturing solutions.

This article gives you all the details you need to quickly and easily set up a Siemens NX license server for monitoring with License Statistics, including enabling remote monitoring, which lets you see usage information from the time you add the license server to License Statistics. (Note that although NX has multiple licensing models, License Statistics supports only the floating license model.)

How to add a new Siemens NX license server

Adding your Siemens NX license server is quick and easy using the license server setup wizard in the License Statistics UI. (If you aren’t familiar with adding and editing license servers, see License Statistics help for complete information.)

You’ll need to have License Statistics administrator privileges to add a new license server. Setup will take just a few simple steps, including:

  1. Defining general information for the license server
  2. Enabling remote monitoring
  3. Setting up remote license server management (optional)
  4. Enabling log file importing (optional)

Read on to learn how to get your NX license server up and running in no time!

Enter the General license server information

  1. Open License Statistics, and go to Administration > License Servers. (You must have License Statistics administrator privileges to access this page.)
  2. Click Add to open the Add License Server wizard.

License Statistics - Add new license

  1. The General tab of the Add License Server wizard lets you define the license server.
    1. At a minimum, enter the license server name, and select FLEXlm/FlexNet as the license server type.
    2. Optionally, you can enter a description for the license manager, and under the Vendor section, add a name to display for the vendor in reports. (The Vendor Name entry will be automatically detected and visible after the first successful query or import.)

Add Siemens NX License Server

Enable remote monitoring

After you have completed entering the information in the General tab of the Add License Server wizard, you can move on to enabling remote monitoring, which lets you see usage information from the time the license server is added to License Statistics to be monitored.

To enable remote monitoring:

  1. From the General tab, click Next to go to the Remote Monitoring tab. (The Next button won’t be available until you’ve entered the required information in the General tab.)

Siemens NX license server monitoring - Enable remote monitoring

  1. In the Remote Monitoring tab, make sure that Enable Remote Monitoring is toggled on (this is the default).

Siemens NX license server monitoring - Enable remote monitoring

  1. Under the General section of the Remote Monitoring tab:
    1. If needed, edit the path for the query tool needed to monitor the server. This query tool is delivered by the application vendor.
    2. If multiple daemons are run on the same license server, enter the Vendor Daemon Name, which defaults to “ugslmd.”
    3. Select your desired query interval, which is the time in minutes between each license server query. You can choose between 1, 2, 5, and 10 minutes.
    4. Toggle on the data types you want to gather (FLEXlm/FlexNet license managers allow only for Usage data gathering).
      Siemens NX license server monitoring - 7
  1. Under the Connection section of the Remote Monitoring tab:
    1. Toggle on Redundant to enable redundant servers if desired. (If you toggle on redundant servers, you must enter the hostname and port information for three servers.)
    2. Enter the hostname for the Siemens NX server. (This is required, so you won’t be able to verify or save the server until you enter the hostname.)
    3. Change the port if needed. The default port is 28000. (Note that this differs from the default FlexNet port, 27000.)
      Siemens NX license server monitoring - 7
  2. If you want to check that your connection to the Siemens NX server is working, click Verify at the bottom of the Remote Monitoring tab. (Although recommended, this step isn’t required, because verification happens automatically when you save the license server.) The verification results appear in a popup window.

Siemens NX license server monitoring - configuration

  1. Click Save to File at the bottom of the verification results window to save the verification results to a file if needed (for example, if there are issues with verification, you may be requested to send this file to X-Formation Support to assist with troubleshooting).
  2. Click Close at the bottom of the verification results window to return to the Remote Monitoring tab.

After setting up remote monitoring, you’re ready to move on to the Server Agent tab, where you can enable remote license server management.

Set up remote license server management (optional)

Optionally, you can manage license servers remotely (currently limited to Start, Stop, and Restart operations for LM-X and FlexNet license managers only) by using a Server Agent.

You must first have an Agent installed, as described in Installing and configuring License Statistics Agent. (You may enable remote license server management either when initially creating the license server or by editing the license server later.)

To enable remote license server management:

  1. From the bottom of the Remote Monitoring tab, click Next to go to the Server Agent tab.

Remote license server management

  1. Select a Server Agent to use for the license server.

Finally, you will move on to the Importing tab, where you can enable log file importing for the license server.

Enable importing for the license server

Finally, you can enable importing the log file using the License Statistics UI or API.

To enable importing:

  1. Click Next from the bottom of the Server Agent tab to go to the Importing tab.

Add Siemens NX License Server - enable importing for the license server

  1. Toggle on Enable Importing to enable log file importing (the default).

Save the license server

From the Importing tab, click Save and Close to save the license server and close the Add License Server wizard.

Siemens NX license server monitoring - save settings

Your Siemens NX license server monitoring setup is complete, and after a minute or so, will start automatically. License Statistics will display the data for your Siemens NX license usage in its usual easy-to-read grids and reports.

Get to know License Statistics

Let us know what you think!

We hope this article was helpful in walking you through configuring License Statistics to track your Siemens NX license server usage. You can learn more by visiting the License Statistics documentation, and as always, feel free to contact us at support@x-formation.com with your questions or comments.