WSSQL query for multiple computers at once

Posted by Josh on Stack Overflow See other posts from Stack Overflow or by Josh
Published on 2010-04-11T19:12:21Z Indexed on 2010/04/11 19:23 UTC
Read the original article Hit count: 311

Filed under:
|
|
|

I can run normal searches just fine. Windows 7 won't let me add a network share to my local index, but I can query the remote index just fine. The problem is that I can't find a way to query two indexes at once. I was hoping that something like this would work:

SELECT System.ItemName 
FROM compA.SystemIndex, compB.SystemIndex 
WHERE SCOPE='file://compA/pathA' OR SCOPE='file://compB/pathB'

but it doesn't. For simple queries, I can query compA and compB separately and then merge the results myself, but I'm hoping for a better way. Anybody here have some experience with this?

© Stack Overflow or respective owner

Related posts about windows-7

Related posts about sql