Прошу прощения за некропостинг. А есть у кого-нибудь версия этого отчета с конвертированной в human формат productState0 из вьюхи v_GS_ANTIVIRUSPRODUCT?
DECLARE @DIFF AS INT
SET @DIFF = DATEDIFF(MINUTE, GETUTCDATE(), GETDATE())
SELECT DISTINCT
s.Name0 AS ComputerName,
av.displayName0 AS DisplayName,
CAST((av.ProductState0 & 12288) AS BIT) AS ProductState,
CAST((av.productState0 & 4096) AS BIT) AS ProtectionState,
~CAST((av.productState0 & 255) AS BIT) AS DefinitionState,
PARSE(av.timestamp0 AS DATETIME USING 'en-US') AS ProductTimeStamp,
DATEADD(MINUTE, @DIFF, cs.LastHW) AS InventoryTimeStamp
FROM v_R_System s
INNER JOIN v_FullCollectionMembership cm
ON s.ResourceID = cm.ResourceID
INNER JOIN v_CH_ClientSummary cs
ON s.ResourceID = cs.ResourceID
LEFT JOIN v_GS_ANTIVIRUSPRODUCT av
ON s.ResourceID = av.ResourceID
WHERE cm.CollectionID = @CollID
AND s.Client0 = 1