USP_GET_OTHER_AGGREGATE_STATS_USAGE_TRACKING_DATA

    create procedure dbo.USP_GET_OTHER_AGGREGATE_STATS_USAGE_TRACKING_DATA  (
    @ProductName varchar(4)
    )
    AS
    begin
          DECLARE @SiteId INT;
        DECLARE @OrganizationDetails NVARCHAR(400);
        DECLARE @IsHosted BIT;

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

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

        DECLARE @SiteStats TABLE
          (
             LivePages          INT,
             LiveTemplates      INT,
             LiveParts          INT,
             LiveStyleSheets    INT,
             LiveImages         INT,
             LiveLayouts        INT,
             LiveVanityURLs     INT,
             LiveEmailTemplates INT,
             LiveEcardTemplates INT
          )
        DECLARE DATABASE_CURSOR CURSOR static FOR
          (SELECT ID
           FROM   ClientSites);

        OPEN DATABASE_CURSOR;

        FETCH next FROM DATABASE_CURSOR INTO @SiteId;

        WHILE ( @@FETCH_STATUS = 0 )
          BEGIN
              INSERT INTO @SiteStats
              EXEC Spgetsiteassestscount
                @SiteId,
                0,
                0

              FETCH next FROM DATABASE_CURSOR INTO @SiteId;
          END

        CLOSE DATABASE_CURSOR;

        DEALLOCATE DATABASE_CURSOR;

        SELECT @ProductName + '-' + 'OtherAggregateStats' + '-'
               + @OrganizationDetails  AS 'Group',
               @IsHosted               AS 'IsHostedClient',
               Sum(LivePages)          LivePages,
               Sum(LiveTemplates)      LiveTemplates,
               Sum(LiveParts)          LiveParts,
               Sum(LiveStyleSheets)    LiveStyleSheets,
               Sum(LiveImages)         LiveImages,
               Sum(LiveLayouts)        LiveLayouts,
               Sum(LiveVanityURLs)     LiveVanityURLs,
               Sum(LiveEmailTemplates) LiveEmailTemplates,
               Sum(LiveEcardTemplates) LiveEcardTemplates
        FROM   @SiteStats 

    end