United Kingdom Endpoint Management User Group

 View Only
  • 1.  DS 6.9 computer filters

    Posted Jun 02, 2015 02:42 AM

    Hello all,

    Does anyone know the sql behind the computer filters as I do not seem to be able to capture it via SQL Profiler? 

    SK



  • 2.  RE: DS 6.9 computer filters
    Best Answer

    Posted Jun 05, 2015 06:28 AM

    Hello all,

    I received this from support: 

     

    It’s actually doing small query reading “filter_condition” table.

     

    declare @p1 int

    set @p1=1076378635

    declare @p2 int

    set @p2=185626639

    declare @p5 int

    set @p5=1

    declare @p6 int

    set @p6=4

    declare @p7 int

    set @p7=3

    exec sp_cursorprepexec @p1 output,@p2 output,NULL,N'SELECT "filter_id","item_seq","field_type","oper_type","key_value","drive","conjunct"  FROM "filter_condition" WHERE filter_id = 8000005',@p5 output,@p6 output,@p7 output

    select @p1, @p2, @p5, @p6, @p7