License Statistics v6.22 - New features and enhancements

License Statistics v6.22 introduces improved permissions handling, including the ability to create custom roles

With License Statistics version 6.22, we’ve introduced improvements to managing License Statistics account permissions–including the ability to create custom account roles to separate permissions from visibility settings–along with other new features, enhancements, and bug fixes. Read on to find out more about what’s new in License Statistics v6.22.

New License Statistics account permissions management

Previously, License Statistics account permission roles were limited to Administrator and User roles, and there was no ability to limit access to individual reports.

As of v6.22, License Statistics administrators can create new custom roles in addition to Administrator and User roles. License Statistics administrators can now use these roles to set permissions that allow or forbid access to both license servers and reports per License Statistics user account. As part of this improvement:

  • The Permissions tab in the “Create/Edit Account” form was removed
  • New custom roles can be created, based on the User role
  • Non-administrator License Statistics accounts have access only to their permitted license servers and reports
  • Each account can control the visibility of their account’s permissible license servers and features
  • Existing permissions will be migrated from prior versions of License Statistics as outlined in Account permissions migration.

For complete information about setting permissions, see Managing License Statistics user accounts in the License Statistics documentation.

License Statistics Agent group auto-assign filtering

License Statistics v6.22 added the ability to automatically assign Agents to groups using new Auto Assign options:

  • By Matching Hostname: Assigns Agents to the group when the Agent’s hostname matches a specified hostname pattern, which lets you use wildcards to search for matches.
  • By Matching Subnet Mask: Assigns Agents to the group when the Agent’s IP Address matches the range specified by a subnet mask.

See Agent groups in the License Statistics documentation for complete information about Agent group auto-assignment.

Other new features and enhancements

In addition to the major new features detailed above, in this release, we’ve:

  • Extended LDAP configuration to include Follow Referrals and related Referrals Hop Limit options, giving users the ability to customize these settings for performance and large network needs
  • Added support for log file import for Managed Dassault Systemes License Server (Managed DSLS)
  • Added notifications for errors and warnings detected and/or reported by License Statistics Agent
  • Improved consistency and clarity of a number of labels, messages and notifications
  • Added an estimated counters preview to the Data Deletion form that shows the number of users and hosts that will be removed from the database, giving you better information to determine whether the data should be deleted

For a complete list of enhancements and fixes, see License Statistics v6.22 Release Notes.

With the improvements made in License Statistics v6.22, 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.22 new features and enhancements, and don’t hesitate to contact support@x-formation.com with any questions. We look forward to hearing from you!

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!

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!

License Statistics with Microsoft Power BI

Benefits of using Power BI with usage data gathered from License Statistics

Microsoft Power BI, a cloud-based business intelligence platform, is growing in popularity with many of today’s businesses. Power BI’s interactive dashboards provide advanced data visualization, transforming unrelated data sources into accessible, cohesive insights into key metrics throughout your organization.

As explained in our related blog article, Generating Custom Reports from License Statistics with Microsoft Power BI, the License Statistics API gives you complete access to all the software license usage data that License Statistics tracks, which you can use as input for Power BI.

Power BI gives you the ability to aggregate data from multiple sources, so you can combine License Statistics’ detailed license usage data with virtually any other data sources  — such as your organization’s CRM, CMS, databases, and cloud services — to create correlated reports, dashboards, and charts.

For example, you could create reports that take data from License Statistics along with data from your security system, user directory (AD, LDAP), and company calendar to correlate license usage with hours reported for a particular project or to analyze when users have active licenses but are spending time doing other activities (such as meetings or scheduled breaks).

License Statistics - Power Bi reports

It’s easy to see how using License Statistics usage data with Power BI can bring you new insights into your license usage that help you optimize license management across your entire organization.

For complete information about using License Statistics with Power BI, see Using the API with Power BI in License Statistics Online Help.

License Statistics helps businesses contend with recession by reducing software license costs

License Statistics helps businesses contend with recession by reducing software license costs

Let’s face it. Times are hard, with a myriad of factors causing stress on the global economy. If you’re an owner or manager of just about any business, you’ve likely been keeping a wary eye on the looming recession, already affecting both the US and Europe, and predicted to worsen over the coming year. Recessions wreak havoc on businesses, with decreased sales and profits spurring businesses to take whatever measures are necessary to cut costs. Some businesses even face bankruptcy and closure.

Often, businesses react to a recession by turning to “solutions” that include layoffs, reduced investments, and slashed research, development and marketing budgets. While cutting costs may be necessary to stay afloat, these tactics may have negative impacts on the health of your business. You end up with a reduced, overloaded workforce that’s more likely to experience burnout, low productivity, and less satisfaction in their jobs, and risk harming your competitive edge by losing traction in innovations and your ability to reach your consumers.

It’s all in the numbers

For businesses that rely on software to get their jobs done—and these days, what business doesn’t?— there may be a better way to reduce costs: effective software license management.

Don’t underestimate the impact of your software license costs. As stated in a 4-year, global software waste study conducted by 1E, The Real Cost of Unused Software, which concluded that a staggering one third or more of all software spend is wasted, “Cutting the waste out of software spend by reclaiming what goes unused would give organizations back almost 35% of their budget to spend on the kind of innovation that will give them competitive edge.”

Recent statistics show that small businesses spend nearly 7% and mid-sized companies spend over 4% of their revenue on IT, while larger companies are closer to spending around 3% of their revenue on software costs. And these costs are only rising as companies rely more and more on sophisticated IT to do everything from customer relations to product development.

Do you know the true cost of your wasted software licenses?

Regardless of the size of your business, no one has the money to waste on inefficient software license management; yet many companies today lack understanding of the true cost of business software, and whether their licenses are under-serving or over-serving their employees. Neither case helps your bottom line.

Some licenses may be entirely unused, while other licenses are in high demand and insufficient to reliably keep your workforce productive. Network licenses shared among your workforce may be inadvertently taken up during non-working hours or by someone out of the office on leave, wasting expensive licenses and leaving too few for others who need them to do their work.

If you haven’t been managing your licenses using a tool that’s made for the job, you’re likely overspending on your licenses. The only question is, how much? Users of License Statistics, a leading license management solution, have reported slashing as much as 30% or even more in license software costs, in-line with the results of the study performed by 1E.

Get the help you need to cut software license costs and improve productivity

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. On top of these savings, consider the intrinsic value of increased productivity and efficiency associated with having licenses available when they’re needed.

License Statistics not only gives you clear, concise information about your license usage to help you make smart decisions about your IT spend; it actually helps you to regain idle licenses–say, from the person who’s gone on vacation or left for the day and accidentally left a license checked out–by detecting and taking back idle licenses so they’re available for other users. Surpassing the capabilities of most other license management software tools, License Statistics is a complete solution, with support for over 30 different license managers and usable even for desktop applications and custom software.

Unlike reductions to staffing, R&D, and marketing, there is no down-side to reducing spending on wasted software licenses. If you’re looking for a tool to help you get the most out of your software licensing budget in these belt-tightening times—and statistics show you should be—look no further than License Statistics.

Get to know License Statistics