MS indexing Search Engine

[DerMedizinmann]

the script is working just fine!

Thank you veeerrryyy much!!

[ptrex]

@DerMedizinmann

Good to hear this.

And welcome to this forum !!

regards,

ptrex

[randallc]

Hi,

OMG,

I have looked at all the MS sites you have quoted, and , as far as I can see, there are -no- examples of usage!

How hopeless are they!

could you possibly show me

1. How to do a query which retrieves -all- the results ("*" or "*.*" retrieve nothing, that I can see?)

2. Why leading or trailing "*" seem to mess up getting a result?

3. All results; is there a default for "Max"?

Preferably with examples I can modify?

TIA, if you have the time, \ interest...?

Best, randall

Edited October 22, 2007 by randallc

[ptrex]

@randallc

Example of a Predefined Indexing Query :

$objConnection = ObjCreate("ADODB.Connection")
$objConnection.ConnectionString = "provider=msidxs;"
$objConnection.Properties("Data Source") = "system" ; Script Catalog
$objConnection.Open
 
$objCommand = ObjCreate("ADODB.Command")
 
; $strQuery = "Create View #AllProps as Select * from Scope()"
 
$objRecordset= $objConnection.Execute("Select * from Extended_FileInfo")
 
While Not $objRecordSet.EOF
    ConsoleWrite(  $objRecordSet("Filename") & ", " & $objRecordSet("Size") & _
        ", " & $objRecordSet("DocAuthor")& @LF)
    $objRecordSet.MoveNext
WEnd

As you can see it all come up to get the correct SQL statements do to the job.

This will get you started.

regards

ptrex

[randallc]

Hi,

Thanks for your efforts,

but I can't see which, if any, of my questions 1, 2 or 3, that answers?

Best, randall

PS, Are you in any way still referring to post #1 which you started here?; or starting another method altogether?

Edited October 22, 2007 by randallc

[ptrex]

@randallc

First of all all examples are still relating to the Indexing Service.

Nevertheless it seems confusing, but it still does.

Why an "ADODB.Connection", because this is the fastest way to do so.

1. How to do a query which retrieves -all- the results ("*" or "*.*" retrieve nothing, that I can see?)

"Select * from Extended_FileInfo" -> Meaning to select all

2. I don't know, never used this.

3. MAX. Not sure best is to check out the SQL syntax for Indexing services here :

SQL Syntax for Indexing Service

I hope this get's you going.

regards

ptrex

[randallc]

Hi,

So maybe it is just my computers?

1. Neither of the scripts in post #24 return anything at all.

2. From post #1, if ".query" is "*sea*", or "s*", I return empty results; [whereas "sea*" returns appropriate results]!

I think it is not worth persisting with, even though it seems logical to use the MSindex already present! There is not enough info on MS sites to get it working, in my opinion, and I have yet to find examples anywhere which work reproducably. At least I understand the results with "in house" index!

Best, randall

[ptrex]

@Randallc

I am sorry to hear you are giving up so soon.

Saying there are no examples I can hardly believe this.

Google is bulking of it.

This is one for .NET but surely you can understand this.

MS Indexing Example

If you look for Indexing Service + VBscript you will see quite some usefull examples.

But of course before scripting it, you first need to understand the nature of the beast

On quick way of doing a search is like this :

Go the your Desktop -> right click -> choose Manage -> Services and Applications -> Indexing Service -> System -> Query the Catalog

and voila !! You have access to your search Engine Natively.

First try the first steps before scritping the engine.

Once you have a grip on that you can take the next step.

I hope this keeps you going.

regards

ptrex