You’ll also be charged for over-usage as well as the audit itself. In the event of an audit, you can be fined for using 5% more than your Microsoft license rights. It’s important to keep track of your Office 365 licenses. A user account will then be generated and assigned to each individual comprising the license total. When you purchase a Microsoft 365 subscription, the number of licenses should reflect the number of employees who intend to use the apps and services. In this article, we walk you through the simple process of accessing and exporting your usage reports. Microsoft 365 usage analytics (must first be enabled in your dashboard).Last activity date for each active user per service.Number of active/inactive users per service in the past 7, 30, 90, or 180 days.Number of daily activities per service.Number of daily active users per service.Leveraging these features lets you easily track user activity across all your Microsoft 365 applications and services, including: Regardless, this should be the first report to generate when assessing Office 365 license usage.Microsoft software usage reports provide businesses with important activity information. If office 365 subscription is primarily used for Project Online, then this caveat is not an issue. ![]() To fine tune this query and find more unused licenses, one of the previous two methods I discovered would need to be applied. The one caveat with this report is that if a Project Online licensed user frequently access something unrelated to Project Online in this subscription of SharePoint Online, he/she would still be identified as active. I personally would set 90 days back because somebody could be on a 30-day vacation. Now, if a user has zero page views in your set time frame and is assigned a Project Online license, this user can be considered available for license removal. I recommend exporting to CSV and opening it in Excel, the list should then include the Product assigned column.įigure 6 – Exporting CSV with type of Licenses We can do this by exporting a list and including a column to indicate which licenses each user is assigned with. In the SharePoint Usage Report, we want to isolate Project Online usage. The SharePoint usage view will show all the SharePoint activity.įigure 5 – SharePoint Usage Report for last 30 Days To get one related to our inquiry, click Usage then SharePoint files. I discovered an existing report that all Office 365 administrators can use to run a usage report. I looked at this simple solution but was not completely satisfied, so I did some more snooping around with an Office 365 administrator account and found the best technique. To get a solution designed for the PWA homepage, go to After waiting for a month or so, we would then be able to look at the list and see who is active. The script would write user name and date to a custom list. The next and most popular method was to incorporate a custom JavaScript file on the home page of the Project Web Application (PWA), Project Site, or on a commonly used Project Detail Page. In which case, further research would be needed. Having been a SharePoint administrator in the past, I knew this could put a performance hit on the environment and I could identify scenarios where an active user could falsely ne identified as inactive. The first method was to enable the “Reporting” site collection feature, configure to capture searches and edits, wait for a while, and then generate an Audit log excel report. And found two main methods people use, although I didn’t really like either of them. I researched in Google to find solutions on how to get license usage list. Unfortunately, Microsoft has removed this feature on the update late in 2016. However, things have changed in Project Online. When requested for this list, I thought of the following UI: However, it turned out to be a challenge. ![]() At first, I thought this is ‘easy’, it is a simple task and I know where to export a list. One way to reduce license costs is to transfer unused licenses before purchasing new ones and this was exactly what our client intended to do. I recently had a request by a company to provide a list of inactive Project Online licenses in Office 365. Posted by: EPM Partners on August 18, 2017
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |