Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. drgonzo1967

    Not In?

    Thank you Very Much for your help!!! -mike
  2. drgonzo1967

    Not In?

    Joulius, you rock. I notice you are not even using the views I created. Can you tell me how the INNER JOIN, LEFT JOIN, and wks_ex work exactly? And Thanks Again!! -mike
  3. drgonzo1967

    Not In?

    Actually bborissov, 'NOT IN' may be incorrect. Because Ouery1 and Query2 both yeild PC3. Any ideas?
  4. drgonzo1967

    Not In?

    bborissov, thanks for the quick reply. Now the query completes sucessfully, but the objects in 'TEST' are still displayed. Is there a way that I could only display what is in 'WORKSTATIONS' w/o displaying what is in 'TEST' as well? ex: Objects in \WORKSTATIONS = PC1, PC2 Objects in...
  5. drgonzo1967

    Not In?

    Hello all. Just need a little help from someone who knows more sql then I (there must be millions). Quick background: Domain = DOMAIN.COM OU1 = WORKSTATIONS (under domain.com where wkstation objects are created) OU2 = TEST (located under WORKSTATIONS ou where objects are moved) Goal: To...
  6. drgonzo1967

    Unable to install packages with elevated priviles

    Try installing 'per computer' instead of 'per user'. -m
  7. drgonzo1967

    SQL AD Object/OU question

    Hey all. This should be a simple solution for some sql master out there. Say my domain is 'Domain.com'. Within there is a 'Workstations' OU where client computer objects are created. Under 'Workstations' is an OU called 'Locations'. When running a query from within the 'Collections' tab of...

Part and Inventory Search

Back
Top