Subject: CRA gamozaxebebis analizi
From: Zurab Batiashvili
To: Dimitri Chkheidze "([email-masked])<[email-masked]>[email-masked]" "ov.ge<[email-masked]>" <[email-masked]>, [email-masked]
Date: Fri, 18 Nov 2016 11:44:00 +0000

გიგზავნით ა.წ. ოქტომბრის მონაცემებს

-- select count(*) from REQUESTS_V01 where DT > '20161001' and DT < '20161101'        -- 18 599 771

-- select count(*) from [CRA_LOG_201610]..REQUESTS_V01 where  USERI like N'Hmis%'       -- 18 149 707

select 18599771 - 18149707             -- 450 064

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where USERI USERI like 'Reporting%'   --     107 795

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where USERI like 'STOP_C%'           -- 19 679

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where USERI like 'SaesaAdd%'         -- 23 244

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where USERI like '3rdChild%'         -- 930

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where USERI like 'elRecepti%' -- 24988

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where USERI like 'ANDROID_PERSON_SOCIAL_INFO%' -- 168

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where USERI like 'atipfund%'                --     11

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where USERI like 'camlebi_%'                -- 11 301

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where USERI like 'hesperus%'                -- 80 561

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where USERI like 'PersonSearch%'            -- 26 592

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where USERI like 'SAESA_V3%'                -- 148 084

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where USERI like 'system%'                  -- 2 054

-- SELECT count(*) FROM [CRA_LOG_201610].[dbo].[REQUESTS_V01] where  USERI < 'a' and USERI <> '3rdChild'    -- 1 579

ზურა