Availability of BigFix Compliance Analytics version 2.0.10

Release Announcements Compliance (Release Announcements)
3

To add STRING_SPLIT function to DB, execute this query on SQL Server.

CREATE FUNCTION dbo.STRING_SPLIT
(
    @List NVARCHAR(MAX),
    @Delim VARCHAR(1)
)
RETURNS TABLE
AS
    RETURN ( SELECT [value] FROM 
      ( 
        SELECT 
          [value] = LTRIM(RTRIM(SUBSTRING(@List, [Number],
          CHARINDEX(@Delim, @List + @Delim, [Number]) - [Number])))
        FROM (SELECT Number = ROW_NUMBER() OVER (ORDER BY name)
          FROM sys.all_objects) AS x
          WHERE Number <= LEN(@List)
          AND SUBSTRING(@Delim + @List, [Number], LEN(@Delim)) = @Delim
      ) AS y
    );