Automating Microsoft SPLA Reporting With SPL Tracker – Part 4

In the final post of our series on automating Microsoft SPLA reporting, it’s time to show how reports get automated and how you gather in-depth analysis from the usage and inactive user data generated by SPL Tracker in Steps 3 and 4.

Automating Microsoft SPLA ReportingThree Different Report Types for Automating Microsoft SPLA Reporting

When you build reports with SPL Tracker, whether they are run manually, or on a scheduled basis, you can create up to three different report types.

Concurrent License Assessment

The Current License Assessment Report is always generated by SPL Tracker. This report details the specific users who had access to particular license types in the preceding reporting period (e.g. prior month), and is suitable for sending to your licensing authority.

SPL Tracker's Current License Assessment Report helps in automating Microsoft SPLA reporting.
The Current License Assessment Report in SPL Tracker.

License Utilization Report

The License Utilization Report is an optional report for internal use, which contrasts the number of users with access to a certain license type, versus those who actually used a particular class of license in the preceding reporting period.

This report is excellent at displaying waste percentages per license type, and then showing you in detail the particular inactive users who represent the waste.

The Current License Utilization Report in SPL Tracker by RDPSoft
The Current License Utilization Report in SPL Tracker can solves a huge part of the problem in automating Microsoft SPLA reporting.

License Control Adjustment Report

Finally, if you decided back in Step 4 that you wanted to remove some inactive users representing waste for the upcoming reporting period, you can elect to generate a License Access Control Adjustment Report. This report documents the group membership adjustments you made to remove access to one or more license types for a specific set of users.

License Access Control Adjustment Report in RDPSoft's SPL Tracker
Don’t forget those inactive users. The License Access Control Adjustment Report in RDPSoft’s SPL Tracker.

In addition to selecting the reports you want to build, the SPL Tracker has numerous adjustable preferences so you can tune it for the specific needs of your environment.

For instance, you can have SPL Tracker create and email the reports to you on a scheduled basis, and you can distinguish those emailed reports by the domain they originate from (which is very useful for MSPs with multiple client domains).

And, yes, you can also personalize the logo used in the reports.

Running a Report in SPL Tracker
Time to confirm and finish your plan for automating Microsoft SPLA reporting with SPL Tracker.

A Master Report For Automating Microsoft SPLA Report Needs

Finally, it’s worth noting that the Current License Assessment Report is always generated in CSV format (as well as the other formats like PDF, Microsoft Word, or Excel). The CSV format allows you to combine all of your different domains’ license assessments into one master report you can submit to your licensing authority.

We’ll take a look at how to set this up in our upcoming “SPLA Reporting Tips and Tricks” blog posts.

Get notified of new posts. Follow us on Twitter @RDPSoft.

Leave a Reply

Your email address will not be published. Required fields are marked *