Отчёт о запуске программ на компьютерах пользователей

SELECT TOP (100) PERCENT Computer AS [Имя компьютера], UserName AS [Учетная запись], program AS Программа, start_time AS [Время запуска], 
       stop_time AS [Время завершения], dbo.FU_GET_FULL_QTY_TEST(CONVERT(VARCHAR, DATEDIFF(SECOND, start_time, stop_time) / 3600)) 
       + ':' + dbo.FU_GET_FULL_QTY_TEST(CONVERT(VARCHAR, DATEDIFF(SECOND, start_time, stop_time) % 3600 / 60)) 
       + ':' + dbo.FU_GET_FULL_QTY_TEST(CONVERT(VARCHAR, DATEDIFF(SECOND, start_time, stop_time) % 3600 % 60)) AS Длительность
FROM   (SELECT r.Computer, s.UserName, r.programID, r.id AS R_ID, MIN(s.id) AS S_ID, r.program, r.Tg AS start_time, MIN(s.Tg) AS stop_time
        FROM   (SELECT  id, eId, Tg, UserName, Computer, image_id AS programID, image AS program
                                FROM    dbo.WARNING__TABLE_NAME_FOR_CHANGE
                                WHERE   (eId = 4688)
                                AND     (Tg > CONVERT(DATETIME, '2013-01-01 00:00:00.000', 102))
                                AND     image not like '%.scr') AS r 
                                INNER JOIN
                                (SELECT  id, eId, Tg, UserName, Computer, image AS programID, name AS program
                                FROM    dbo.WARNING__TABLE_NAME_FOR_CHANGE
                                WHERE   (eId = 4689)
                                AND     name not like '%.scr') AS s 
                                ON r.programID = s.programID AND r.program = s.program AND r.UserName = s.UserName AND r.id <= s.id
         GROUP BY r.Computer, s.UserName, r.programID, r.id, r.program, r.Tg) AS DERIVEDTBL
UNION ALL
SELECT  TOP (100) PERCENT Computer AS [Имя компьютера], UserName AS [Учетная запись], program AS Программа, start_time AS [Время запуска], 
        stop_time AS [Время завершения], dbo.FU_GET_FULL_QTY_TEST(CONVERT(VARCHAR, DATEDIFF(SECOND, start_time, stop_time) / 3600)) 
        + ':' + dbo.FU_GET_FULL_QTY_TEST(CONVERT(VARCHAR, DATEDIFF(SECOND, start_time, stop_time) % 3600 / 60)) 
        + ':' + dbo.FU_GET_FULL_QTY_TEST(CONVERT(VARCHAR, DATEDIFF(SECOND, start_time, stop_time) % 3600 % 60)) AS Длительность
FROM    (SELECT r.Computer, s.UserName, r.programID, r.id AS R_ID, MIN(s.id) AS S_ID, r.program, r.Tg AS start_time, MIN(s.Tg) AS stop_time
         FROM   (SELECT  id, eId, Tg, UserName, Computer, image_id AS programID, image AS program
                                 FROM    dbo.WARNING__TABLE_NAME_FOR_CHANGE
                 WHERE   (eId = 4688)
                 AND     (Tg > CONVERT(DATETIME, '2013-01-01 00:00:00.000', 102))
                                 AND     image like '%.scr') AS r 
                                 INNER JOIN
                (SELECT  id, eId, Tg, UserName, Computer, image AS programID, name AS program
                 FROM    dbo.WARNING__TABLE_NAME_FOR_CHANGE
                 WHERE   (eId = 4689)
                                 AND     name like '%.scr') AS s 
                                 ON r.programID = s.programID AND r.program = s.program AND r.id <= s.id
         GROUP BY r.Computer, s.UserName, r.programID, r.id, r.program, r.Tg) AS DERIVEDTBL2
ORDER BY 'Время запуска' DESC 

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.