locked
How to get report of users who are all connected through Only Outlook Client in exchange 2013? RRS feed

  • Question

  • 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.


    Manju Gowda

    Tuesday, March 3, 2015 2:41 PM

Answers

  • Hello

    tip:

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

    log type: EELLog

    to new query:

    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



    sorry my english

    • Proposed as answer by Lynn-Li Wednesday, March 4, 2015 9:22 AM
    • Marked as answer by Lynn-Li Tuesday, March 24, 2015 1:05 AM
    Tuesday, March 3, 2015 6:24 PM
  • 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.


    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com

    Lynn-Li
    TechNet Community Support

    • Proposed as answer by Lynn-Li Wednesday, March 18, 2015 8:03 AM
    • Marked as answer by Lynn-Li Tuesday, March 24, 2015 1:05 AM
    Thursday, March 5, 2015 8:54 AM

All replies

  • Hello

    tip:

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

    log type: EELLog

    to new query:

    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



    sorry my english

    • Proposed as answer by Lynn-Li Wednesday, March 4, 2015 9:22 AM
    • Marked as answer by Lynn-Li Tuesday, March 24, 2015 1:05 AM
    Tuesday, March 3, 2015 6:24 PM
  • 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.


    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com

    Lynn-Li
    TechNet Community Support

    Wednesday, March 4, 2015 9:25 AM
  • 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 :(


    Manju Gowda

    Wednesday, March 4, 2015 9:50 AM
  • 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.


    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com

    Lynn-Li
    TechNet Community Support

    • Proposed as answer by Lynn-Li Wednesday, March 18, 2015 8:03 AM
    • Marked as answer by Lynn-Li Tuesday, March 24, 2015 1:05 AM
    Thursday, March 5, 2015 8:54 AM
  • 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?


    Manju Gowda

    Tuesday, March 10, 2015 3:42 AM