USP_GET_DIRECTORY_USAGE_TRACKING_DATA

    create procedure dbo.USP_GET_DIRECTORY_USAGE_TRACKING_DATA(
      @LastProcessingDate DateTime,
      @ProductName varchar(4)      
    )
    as
    begin
      DECLARE @OrganizationDetails NVARCHAR(400)

      SELECT @OrganizationDetails = CLARIFYSITEID,
             @OrganizationDetails = @OrganizationDetails + ' - '
                                    + INSTALLATIONNAME
      FROM   dbo.INSTALLATIONINFO;

      SELECT @ProductName + '-' + 'DirectoryMessaging' + '-'
             + @OrganizationDetails  AS 'Group',
             Sum(AnonymousCount)     AS MessagesSentByAnnonymousUsers,
             Sum(LoggedInUserCount)  AS MessagesSentByLoggedInUsers,
             MonthMessageSent,
             YearMessageSent,
             Max(MaxMessagingDate) AS MaxMessagingDate
      FROM   (SELECT Count(ID)                              AS AnonymousCount,
                     0                                      AS LoggedInUserCount,
                     Month(DIRECTORYMESSAGESTATS.DateAdded) AS MonthMessageSent,
                     Year(DIRECTORYMESSAGESTATS.DateAdded)  AS YearMessageSent,
                     Max(DIRECTORYMESSAGESTATS.DateAdded)   AS MaxMessagingDate
              FROM   dbo.DIRECTORYMESSAGESTATS
              WHERE  DIRECTORYMESSAGESTATS.DateAdded > @LastProcessingDate
                     AND DIRECTORYMESSAGESTATS.USERNAME = 'Anonymous'
              GROUP  BY Month(DIRECTORYMESSAGESTATS.DateAdded),
                        Year(DIRECTORYMESSAGESTATS.DateAdded)
              UNION
              SELECT 0                                      AS AnonymousCount,
                     Count(ID)                              AS LoggedInUserCount,
                     Month(DIRECTORYMESSAGESTATS.DateAdded) AS MonthMessageSent,
                     Year(DIRECTORYMESSAGESTATS.DateAdded)  AS YearMessageSent,
                     Max(DIRECTORYMESSAGESTATS.DateAdded)   AS MaxMessagingDate
              FROM   dbo.DIRECTORYMESSAGESTATS
              WHERE  DIRECTORYMESSAGESTATS.DateAdded > @LastProcessingDate
                     AND DIRECTORYMESSAGESTATS.USERNAME <> 'Anonymous'
              GROUP  BY Month(DIRECTORYMESSAGESTATS.DateAdded),
                        Year(DIRECTORYMESSAGESTATS.DateAdded)) AS A
      GROUP  BY YearMessageSent,
                MonthMessageSent 
    end