Client Management Suite

 View Only

  • 1.  Creating Altiris Filter using raw sql

    Posted Nov 10, 2011 04:37 AM

    Creating Altiris Filter using raw sql

    Hello,

    I am trying to create a dynamic filter using raw sql on Symantec CMDB 7.1 and the below query I am trying to run:

     

    select  [vri1_Computer].[Guid] AS [_ResourceGuid]  from [vRM_Computer_Item] AS [vri1_Computer]
           left join  [inv_hw_logical_device]  as [ld] on [vri1_Computer].[Guid]=[ld].[_ResourceGuid] 
                 where [ld].manufacturer  like '%Hewlett-Packard%' and [ld].Model like '%6545%'

     

    The above query runs perfectly fine on SQL management platform, returning all the records however when I try to create an Altiris filter it returns no records at all.

     

    Could you please help me find out what I am missing? Do I need to make it "CMDB-compatible" while creating a raw sql filter?

     

    Thanks in advance!

     

    DSouza S



  • 2.  RE: Creating Altiris Filter using raw sql
    Best Answer

    Posted Nov 10, 2011 10:12 AM

    oops, sorry, I had to press the "Update Membership".

     

    There goes 24 hours of my life that i am not going to get back.



  • 3.  RE: Creating Altiris Filter using raw sql

    Posted Nov 10, 2011 11:33 AM

    If you don't have this filter pointed at an active job, it won't update regularly.  This is as designed, and is the subject of a current enhancement request.  There is a built-in task you can add filters to so they will be forced to update along with the other filters.



  • 4.  RE: Creating Altiris Filter using raw sql

    Posted Nov 10, 2011 02:20 PM

    Which task are you referring to?



  • 5.  RE: Creating Altiris Filter using raw sql

    Posted Nov 11, 2011 03:22 AM

    in 7.0 (and I guess in 7.1 too) it's "Update Filter Membership".

    Select the filters & put it on a shared schedule.