Alessio.Lucchetti asked a question.
Hello,
we configured the O365 connector but the only data I get is users and user count.
Despite the log says that all info are correctly fetched (and also no error reported), we're missing all subscrition data on SLM.
O365 Tables on DB are empty too.
Did someone else had the same issue? We cannot figure out how to solve this, I post the log:
2021-03-09 11:21:03,834 [3] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.Clients.Graph.DirectoryClient - Users successfully fetched.
2021-03-09 11:21:03,834 [3] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import - Applying domain filtering.
2021-03-09 11:21:03,834 [3] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.Clients.Graph.ReportClient - Fetching O365 report.
2021-03-09 11:21:07,540 [11] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.Clients.Graph.ReportClient - User activities successfully fetched
2021-03-09 11:21:08,415 [11] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import - Number of users with last activity data: 8925
2021-03-09 11:21:08,415 [11] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import - Finished fetching last user activities!
2021-03-09 11:21:08,415 [11] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import - Fetching subscriptions via PowerShell.
2021-03-09 11:21:11,087 [11] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import - Subscriptions successfully fetched.
2021-03-09 11:21:11,087 [11] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import - Preparing O365 data for SLM export.
2021-03-09 11:21:11,197 [11] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import - O365 data successfully prepared for SLM export.
2021-03-09 11:21:11,197 [11] INFO SnowSoftware.ExternalDataProvider.Providers.Office365.Office365InventoryProvider - Accounts.Size() == 1, Account.Skus.Count == 31, Account.Users.Count == 19623
2021-03-09 11:21:11,197 [11] INFO SnowSoftware.ExternalDataProvider.Providers.Office365.Office365InventoryProvider - Starting to export Office 365 data into SLM
2021-03-09 11:21:55,508 [11] INFO SnowSoftware.ExternalDataProvider.Providers.Office365.O365Export - SLM API ImportId: 7a98df11-f65b-4225-9606-b0801f786f32
2021-03-09 11:21:55,743 [11] INFO SnowSoftware.ExternalDataProvider.Providers.Office365.O365Export - Account was successfully exported.
2021-03-09 11:21:55,883 [11] INFO SnowSoftware.ExternalDataProvider.Providers.Office365.O365Export - Skus was successfully exported.
2021-03-09 11:21:56,571 [21] INFO SnowSoftware.ExternalDataProvider.Providers.Office365.O365Export - Users was successfully exported.
2021-03-09 11:21:57,227 [11] INFO SnowSoftware.ExternalDataProvider.Providers.Office365.O365Export - Users was successfully exported.
2021-03-09 11:21:57,884 [11] INFO SnowSoftware.ExternalDataProvider.Providers.Office365.O365Export - Users was successfully exported.
2021-03-09 11:21:58,384 [11] INFO SnowSoftware.ExternalDataProvider.Providers.Office365.O365Export - Users was successfully exported.
2021-03-09 11:21:59,716 [21] INFO SnowSoftware.ExternalDataProvider.Providers.Office365.O365Export - Commit was successfully exported.
2021-03-09 11:21:59,716 [21] INFO SnowSoftware.ExternalDataProvider.Providers.Office365.O365Export - Exporting was successful for account name[Alex]
2021-03-09 11:21:59,716 [21] INFO SnowSoftware.ExternalDataProvider.Providers.Office365.Office365InventoryProvider - Office 365 integration finished
SIM Version 5.25.0
Hi Alessio,
I'd suggest you to contact our Support team here: https://community.flexera.com/s/support-hub
They will help to analyze and troubleshoot your issue.
I hope this helps,
cheers
--
Ester Memoli
Customer Success Manager
Hi Ester,
thank you for the fast response.
There's already an open ticket about this, right now I'm also looking for community feedback :)
Have you ticked the "Include last activity" check box at the bottom of the connector settings?
Also i have seen this where the latest guide hasn't been followed exactly in terms of giving the right permissions to the User and App in O365/Azure portals. So may want to check it's been done correctly as per latest guide here:
https://community.flexera.com/s/article/UserGuideMicrosoftOffice365Connector
Hi Joe,
thank you for your help, I confirm that "Include last activity" is flagged.
We have already checked the documentation, the following are the permissions given:
Hi Alessio,
please update also your srs data via Snow update service
What is your SLM Version?
Thank you Detlev,
we'll also try updating srs data.
Here's about SLM: Version 9.8 Revision 01 Build 7618 SnowLicenseManager
Ok..
The newest version is 9.10 with a lot of new features and bugfixes..
Maybe you can update to the newer one. Please read also all releasenotes !
Thanks again, so far I've found realease notes up to 9.9 version
what version of SIM are you on too?
Hi Adam,
this is the configuration: