Video Screencast Help

Question:how to Create filters for workgroup computers

Created: 17 Oct 2012 • Updated: 03 Nov 2012 | 6 comments
This issue has been solved. See solution.

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.


Comments 6 CommentsJump to latest comment

fabio.sanches's picture

Hi Qatar525,

You could you this simple query definition to your filter:

where domain = 'workgroup'
Please let us know the results, ok?
KESH MAN's picture

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

Altiris Administrator

Eli Lilly and Company, Indianapolis, USA

For Forum threads, please click "Mark as Solution" if answered

Qatar525's picture

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.


mafoe's picture


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

SELECT vc.[Guid]

FROM vComputer vc

WHERE vc.domain = 'workgroup'


fabio.sanches's picture

Hi Qatar,

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



from vcomputer vc

where domain = 'workgroup'


Qatar525's picture

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 ?