Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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.

Asad

Comments 6 CommentsJump to latest comment

fabio.sanches's picture

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,
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.

thanks

mafoe's picture

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

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

select

vc.guid

from vcomputer vc

where domain = 'workgroup'
 

Regards

SOLUTION
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 ?