SQL query for new filter

pragmmativco's picture

Hi,

I need to create a sql query to add computer by name to a new filter (folder) in NS 7, I tried to use similar input ( query mode: raw sql) used in NS 6 but it did not work...... I am wondering if someone has a sample 'sql query' to run for a new filter for notification server V7

Thanks

pragmmativco's picture

any tips for the query

Any tips will be appreciated to work on it.........

jharings's picture

What are you trying to accomplish with the filter?

Can you share what your desired outcome would be?

Jim Harings
Technical Solutions Consultant
Xcend Group
http://xcendgroup.com

pragmmativco's picture

filter accomplish

I need to create filters for different areas in the students Laboratories, such as B1, B2, B3.....and add computers under those filter according to name convension, I did that in v6 with a script, so everytime a new computer is added to the system, the script will add it to the specific filter automatically rather than manually....then when policies or task are created can be associated to those filters...the options are query mode, query builder...

Thanks in advance for any help...