Client Management Suite

 View Only
  • 1.  Question:how to Create filters for workgroup computers

    Posted Oct 18, 2012 02:29 AM

    Hi Everyone,

    I'm using SMP 7.1 SP2. I want to create filters for computers that are in the workgroup (not part of the windows domain). what do i specify in the filter to just show up computers in the workgroup ? and then how can the saved filter show up in the computer menu and organizational veiw menu.

    Asad

     

     



  • 2.  RE: Question:how to Create filters for workgroup computers

    Posted Oct 18, 2012 10:36 AM

    Hi Qatar525,

    You could you this simple query definition to your filter:

     

    select
    vc.guid
    where domain = 'workgroup'
     
    Please let us know the results, ok?
     
    Regards,


  • 3.  RE: Question:how to Create filters for workgroup computers

    Posted Oct 18, 2012 10:39 AM

    Yep, I have been using the query mentioned by Luke, works fine for me!



  • 4.  RE: Question:how to Create filters for workgroup computers

    Posted Oct 22, 2012 04:17 AM

    Hi luke,

     

    Thanks for the reply. I did give a try using the RAW SQL query but got an error message in the resloved query. Here is the message

    "Raw Sql Query cannot be Resolved:

    An unexpected SQL error occurred when retrieving the schema from the RawSqlDataSource."

    Please let me know if i'm doing it wrong.The query builder does not let me copy your code.

    thanks

     

     



  • 5.  RE: Question:how to Create filters for workgroup computers

    Posted Oct 22, 2012 08:04 AM

    Hi,

    there is something missing in the query, to get it work at raw sql:

    SELECT vc.[Guid]

    FROM vComputer vc

    WHERE vc.domain = 'workgroup'

     

    Regards



  • 6.  RE: Question:how to Create filters for workgroup computers
    Best Answer

    Posted Oct 22, 2012 02:42 PM

    Hi Qatar,

    Please use the following query. I´m missing one line... and use the Filter Definition: Query mode: Raw SQL

     


    select

    vc.guid

    from vcomputer vc

    where domain = 'workgroup'
     

     

    Regards

     



  • 7.  RE: Question:how to Create filters for workgroup computers

    Posted Nov 03, 2012 12:06 PM

    Sorry for the late reply. We were on EID holidays. I tried it again today. and its successful.

    All the computer in the workgroup now show up in the filters. smiley

    My next task is to show up these workgroup computer under Manage --> computes console. How do i make it appear ?