Indicate needed licenses with character in CSV export from User License Estimator report in D365F&O
The User License Estimator report is too demanding to analyze in large. The report is found under System Administration > Inquiries > License reports in Dynamics 365 Finance & Operations. The reason for being demanding to analyze is that in Excel format needed license per user is indicated by an image dot. Those dots cannot be complied and analyzed. In CSV format the content shows like if all users need all licenses. This idea is to per user indicate in text what licenses the user needs. We have outlined a suggested new CSV layout below.
userName,networkAlias,Finance License,Supply Chain Management License,Commerce License,Project License
Name1 Nameson1,Name1.Nameson1@domain.com,FINANCE,,,
Name2 Nameson2,Name2.Nameson2@domain.com,,SUPPLY CHAIN MANAGEMENT,,
Name3 Nameson3,Name3.Nameson3@domain.com,,,COMMERCE,
Name4 Nameson4,Name4.Nameson4@domain.com,,,,PROJECT
Name5 Nameson5,Name5.Nameson5@domain.com,FINANCE,SUPPLY CHAIN MANAGEMENT,COMMERCE,PROJECT
Name6 Nameson6,Name6.Nameson6@domain.com,FINANCE,SUPPLY CHAIN MANAGEMENT,,
Name7 Nameson7,Name7.Nameson7@domain.com,,,COMMERCE,PROJECT
Name8 Nameson8,Name8.Nameson8@domain.com,FINANCE,SUPPLY CHAIN MANAGEMENT,,
Name9 Nameson9,Name9.Nameson9@domain.com,FINANCE,,,
Name10 Nameson10,Name10.Nameson10@domain.com,FINANCE,,,