SELECT
    date,
    STRCAT(TO_STRING(sc-status),  
    STRCAT('.', TO_STRING(sc-substatus))) As Status,  
    COUNT(*) AS Hits  
    FROM C:\iislogs\*.log
WHERE cs-uri-stem = '/AgrGpsService.asmx'
GROUP BY Status, date