Hi everybody,

I require some help for filtering the Active sync report. We are using the below script

SELECT  TOP 50

            eas-user-alias,

            eas-user-domain,

            eas-device-type,

            SUM (TotalClientEmailSync) AS TotalClientEmailSyncs,

            SUM (TotalServerEmailSync) AS TotalServerEmailSyncs,

            ADD (TotalClientEmailSyncs, TotalServerEmailSyncs) AS TotalEmailSyncs,

            SUM (TotalClientContactSync) AS TotalClientContactSyncs,

            SUM (TotalServerContactSync) AS TotalServerContactSyncs,

            ADD (TotalClientContactSyncs, TotalServerContactSyncs) AS TotalContactSyncs,

            SUM (TotalClientCalendarSync) AS TotalClientCalendarSyncs,

            SUM (TotalServerCalendarSync) AS TotalServerCalendarSyncs,

            ADD (TotalClientCalendarSyncs, TotalServerCalendarSyncs) AS TotalCalendarSyncs,

            ADD (TotalEmailSyncs, ADD (TotalContactSyncs, TotalCalendarSyncs)) AS TotalSyncs   

 

USING

 

            CASE eas-folder-data-type

                        WHEN 'Em' THEN

                               ADD(eas-client-adds,

                               ADD (eas-client-changes,

                               ADD (eas-client-deletes, eas-client-fetches)))

                        ELSE 0

            END AS TotalClientEmailSync,

 

            CASE eas-folder-data-type

                        WHEN 'Em' THEN

                               ADD(eas-server-adds,

                               ADD (eas-server-changes, eas-server-deletes))

                        ELSE 0

            END AS TotalServerEmailSync,

           

            CASE eas-folder-data-type

                        WHEN 'Co' THEN

                               ADD(eas-client-adds,

                               ADD (eas-client-changes,

                               ADD (eas-client-deletes, eas-client-fetches)))

                        ELSE 0

            END AS TotalClientContactSync,

 

            CASE eas-folder-data-type

                        WHEN 'Co' THEN

                               ADD(eas-server-adds,

                               ADD (eas-server-changes, eas-server-deletes))

                        ELSE 0

            END AS TotalServerContactSync,

 

            CASE eas-folder-data-type

                        WHEN 'Ca' THEN

                               ADD(eas-client-adds,

                               ADD (eas-client-changes,

                               ADD (eas-client-deletes, eas-client-fetches)))

                        ELSE 0

            END AS TotalClientCalendarSync,

 

            CASE eas-folder-data-type

                        WHEN 'Ca' THEN

                               ADD(eas-server-adds,

                               ADD (eas-server-changes, eas-server-deletes))

                        ELSE 0

            END AS TotalServerCalendarSync

 

INTO C:\Public\LogParserOutput\EAS_User_Statistics.html

 

 

/* Substitute this directory location with the location of your logs.  Wildcards are allowed.

  

*/

 

FROM C:\Public\Logs\*.log

 

GROUP BY

            eas-user-alias,

            eas-user-domain,

            eas-device-type