Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

SQL query for new filter

Updated: 21 May 2010 | 3 comments
pragmmativco's picture
+1 1 Vote
Login to vote

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

Comments

pragmmativco's picture
09
Jun
2009
1 Vote +1
Login to vote

any tips for the query

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

jharings's picture
17
Jun
2009
0 Votes 0
Login to vote

What are you trying to accomplish with the filter?

Can you share what your desired outcome would be?

Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.

pragmmativco's picture
17
Jun
2009
0 Votes 0
Login to vote

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