Office365 connector issue

Viktors asked a question.

October 25, 2017 at 7:00 AM

Hello! Have a problem with SIM connector - O365. We are using 5.5 SIM version. Connector is configured regarding Snow documentation. From SLM side (8.2 version) I'm able to see information about subscriptions and total users. But there is no information about Active users - Active Directory discovery for users is enabled. From the log side, I have got this kind of warning: 2017-10-25 12:08:24,962 [1] WARN SnowSoftware.ExternalDataProvider.Providers.Office365.PsRunner [()] [()] - PowerShell script returned error messages: System.Management.Automation.CommandNotFoundException: The term ' Get-CsUserActivitiesReport ' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. at System.Management.Automation.CommandDiscovery.LookupCommandInfo(String commandName, CommandTypes commandTypes, SearchResolutionOptions searchResolutionOptions, CommandOrigin commandOrigin, ExecutionContext context) at System.Management.Automation.CommandDiscovery.LookupCommandProcessor(String commandName, CommandOrigin commandOrigin, able`1 useLocalScope) at System.Management.Automation.ExecutionContext.CreateCommand(String command, Boolean dotSource) at System.Management.Automation.PipelineOps.AddCommand(PipelineProcessor pipe, CommandParameterInternal[] commandElements, CommandBaseAst commandBaseAst, CommandRedirection[] redirections, ExecutionContext context) at System.Management.Automation.PipelineOps.InvokePipeline(Object input, Boolean ignoreInput, CommandParameterInternal[][] pipeElements, CommandBaseAst[] pipeElementAsts, CommandRedirection[][] commandRedirections, FunctionContext funcContext) at System.Management.Automation.Interpreter.ActionCallInstruction`6.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) -> CommandNotFoundException 2017-10-25 12:08:25,024 [1] WARN SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import [()] [()] - No results returned for last skype activity All connection tests are successful (API user and Office365 account with Skype Administrator permissions). Are there any suggestions regarding this issue? Bestr regards, Viktors

Portal User
9 years ago
Victor that means the import worked. Try running the Office 365 connector again and let's see if you get an error now.
Expand Post
Portal User
9 years ago
I am getting the same error message as well. Getting the account info but no user data. 2017-11-02 11:10:01,896 [1] INFO SnowSoftware.ExternalDataProvider.Aggregator [()] [()] - SIM version 5.5.0.343 2017-11-02 11:10:02,037 [1] INFO Microsoft Office 365_1 [()] [()] - Starting import of Office 365 data 2017-11-02 11:10:02,037 [1] INFO Microsoft Office 365_1 [()] [()] - Importing resources 2017-11-02 11:10:14,428 [1] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import [()] [()] - Fetching subscriptions 2017-11-02 11:10:17,991 [1] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import [()] [()] - Fetching users 2017-11-02 11:11:25,601 [1] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import [()] [()] - Fetching last skype activity 2017-11-02 11:11:45,542 [1] WARN SnowSoftware.ExternalDataProvider.Providers.Office365.PsRunner [()] [()] - PowerShell script returned error messages: System.Management.Automation.CommandNotFoundException: The term 'Get-CsUserActivitiesReport' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. at System.Management.Automation.CommandDiscovery.LookupCommandInfo(String commandName, CommandTypes commandTypes, SearchResolutionOptions searchResolutionOptions, CommandOrigin commandOrigin, ExecutionContext context) at System.Management.Automation.CommandDiscovery.LookupCommandProcessor(String commandName, CommandOrigin commandOrigin, able`1 useLocalScope) at System.Management.Automation.ExecutionContext.CreateCommand(String command, Boolean dotSource) at System.Management.Automation.PipelineOps.AddCommand(PipelineProcessor pipe, CommandParameterInternal[] commandElements, CommandBaseAst commandBaseAst, CommandRedirection[] redirections, ExecutionContext context) at System.Management.Automation.PipelineOps.InvokePipeline(Object input, Boolean ignoreInput, CommandParameterInternal[][] pipeElements, CommandBaseAst[] pipeElementAsts, CommandRedirection[][] commandRedirections, FunctionContext funcContext) at System.Management.Automation.Interpreter.ActionCallInstruction`6.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) -> CommandNotFoundException 2017-11-02 11:11:45,542 [1] WARN SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import [()] [()] - No results returned for last skype activity 2017-11-02 11:11:45,542 [1] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import [()] [()] - Fetching Exchange online user principal names 2017-11-02 11:12:04,233 [1] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import [()] [()] - Found 1 users. Starting to fetch LastLogonDate in batches of #1000 2017-11-02 11:12:22,751 [1] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import [()] [()] - Retrieved #1 of 1 2017-11-02 11:12:22,751 [1] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.O365Import [()] [()] - Finished fetching Exchange Online activities! 2017-11-02 11:12:25,720 [1] DEBUG SnowSoftware.ExternalDataProvider.Providers.Office365.DtoConverter
Expand Post
- Portal User
  9 years ago
  I can see in the stack trace that the function Get-CsUserActivitiesReport cannot be recognised. This function is included in the AzureAD/ Exchange online cmdlet. From the machines where you run the SIM tool, please run the following command in a PowerShell window: Find-Module AzureAD | Install-Module This command will install the AzureAD cmdlet that includes all the needed functions for O365. If this does not resolve the issue, please open a ticket with support. The account you use to connect to Exchange Online must be enabled for remote PowerShell. For more information, see Enable or disable access to Exchange Online PowerShell .
  Expand Post
  - Viktors
    9 years ago
    Thank you for this information. After running the command, got this error: Powershell version: PS C:\Windows\system32> $PSVersionTable.PSVersion Major Minor Build Revision ----- ----- ----- -------- 4 0 -1 -1 Best regards, Viktors
    Expand Post
    Portal User
    9 years ago
    The feature Find-Module was first introduced in PS 5.0.1. Can you confirm that the following two modules are installed on the server? Microsoft Online Services Sign-In Assistant (64-bit version): https://www.microsoft.com/en-us/download/details.aspx?id=41950 ◦ Windows Azure Active Directory Module for Windows PowerShell (64-bit version): http://go.microsoft.com/fwlink/p/?linkid=236297
    Expand Post
Community Manager (Flexera Software)
9 years ago
Hello Viktors, Did you already tried to re-configure the O365 connector? Meaning that you remove the existing one, save that by closing the SIM. Starting the SIM again and adding the connector with the same details. Best, Kadir
Expand Post
- Viktors
  9 years ago
  Hello Kadir! Yes, I tried to re-configure it, but the problem still exists. Best regards, Viktors
  Expand Post
Portal User
9 years ago
Vicktor, Open Powershell and run the following command. See if that will work for you. Import-Module MSOnline
Expand Post
- Viktors
  9 years ago
  Nothing happened
  Expand Post
Portal User
9 years ago
‌ Did that work for you?
Expand Post

10 of 13

Related Product Forums

→ Flexera One

→ Snow Atlas

→ FlexNet Manager

→ Snow License Manager

→ App Broker

Need help finding an answer?

Ask a Question →