Hi, We have a requirement to check how many users are connected using outlook client 2013.

We have set of field users who are not allowed to configure outlook, hence we need to find whether they configured outlook in their personal or official machines.

Hello

tip:

with: Log Parser Studio
set log folder: "C:\Program Files\Microsoft\Exchange Server\V15\Logging\RPC Client Access"

EXTRACT_SUFFIX(client-name,0,'=') as User,

Hi,

Log Parser Studio is a very good choice.

Here are documents to introduce this tool.

http://blogs.technet.com/b/karywa/archive/2013/04/21/getting-started-with-log-parser-studio.aspx

Best Regards.

Hi, Nice Parser.

But i am unable to set the folder, as it looks for a file to be opened if you try yo add folder.

Secondly, Where to set the Log type :(

Hi,

Set the folder means set the location where you put these results. To set a new default output directory run LPS and go to Options > Preferences and it is the first option at the top.

Then Click File -> New -> Query and put the following conditions to new query and choose the log type:

SELECT TO_LOWERCASE(Client-Software) as Software, Client-Software-Version,

EXTRACT_SUFFIX(client-name,0,'=') as User,

TO_REAL(SUBSTR(TO_STRING(MUL(PROPCOUNT(*), 100.0)), 0, 5)) as Percent
FROM '[LOGFILEPATH]'
WHERE Software IS NOT NULL
GROUP BY client-software, Client-Software-Version, client-name
ORDER BY Percent DESC

Best Regards.

Thanks I am able to execute the query now. Please let me know how can this be achieved for Office 365 users.

Ex: I have run this command on our Exchange server 2013 & pulled the report. 

If the same needs to be done for users on office 365, what needs to be done?