ptrex Posted September 3, 2007 Share Posted September 3, 2007 (edited) MS indexing Search Engine Most of you know the MS indexing Search Engine on Win 2000 and later systems. The Query object of Indexing Service supports methods and properties that allow you to formulate a query and define an ActiveX® Data Objects (ADO) recordset to manage and display the results of the query.Condition is well that your Indexing Service is running. Well this can be accessed by the following COM objects : expandcollapse popupDim $strQuery ; The text of our query Dim $objQuery ; The index server query object Dim $rstResults ; A recordset of results returned from I.S. Dim $objField ; Field object for loop Dim $sRet ; Retrieve Service State Const $strComputer = "127.0.0.1" ; Initialize error handler $oMyError = ObjEvent("AutoIt.Error","MyErrFunc") ; Retreive the query from the querystring $strQuery = "au3" ; "#filename *.htm" _ServiceState() If StringInStr($sRet,"stopped") Then MsgBox(0,"State ","Sercice is not Running, I will start it ...") _ServiceStart() Sleep(1000) Else ; If the query isn't blank then proceed If $strQuery <> "" Then ; Create our index server object $objQuery = ObjCreate("ixsso.Query") ; $objQuery.Catalog = "query://search.microsoft.com/kb" ; query://hostname/indexname ; Set it's properties With $objQuery .Catalog = "query://" & $strComputer &"/System" ; Catalog to query .Query = $strQuery ; Query text .MaxRecords = 100 ; Max # of records to return ; What to sort records by. I'm sorting by rank [d] ; which is [d]escending by how pertinent Index Server ; thinks the result is. This way the most applicable ; result should be first. .SortBy = "rank [d]" ; Which columns to return. Column names must ; be the same as the catalog's properties. Some ; of them are: contents, filename, size, path, ; vpath, hitcount, rank, create, write, DocTitle ; DocSubject, DocAuthor, DocKeywords... .Columns = "filename, path, vpath, size, write, " _ & "characterization, DocTitle, DocAuthor, " _ & "DocKeywords, rank, hitcount" EndWith ; Get a recordset of our results back from Index Server $rstResults = $objQuery.CreateRecordset("nonsequential") If @error Then Msgbox (0,"Error","Service not started") Exit EndIf ; Get rid of our Query object $objQuery = "" ; Check for no records If $rstResults.EOF Then Consolewrite( "Sorry. No results found." & @CRLF) Else ; Print out # of results Consolewrite("Records # : " & $rstResults.RecordCount & @CRLF) ; Loop through results While Not $rstResults.EOF ; Loop through Fields ; Formatting leaves something to be desired, ; but it'll work for now. For $objField in $rstResults.Fields Consolewrite( $objField.Name & " : ") Consolewrite( $rstResults.Fields($objField.Name).Value & @CRLF) Next ; Spacing between results Consolewrite( @CRLF) ; Move to next result $rstResults.MoveNext WEnd EndIf EndIf EndIf Func _ServiceState() $objWMIService = ObjGet("winmgmts:" & "{impersonationLevel=impersonate}!\\" & $strComputer & "\root\cimv2") $Services = $objWMIService.ExecQuery("Select * from Win32_Service where Name Like 'cisvc%'") For $objService in $Services $sRet = ($objService.DisplayName & " | " & $objService.State) ;MsgBox(0,"Service State",$sRet) Next Return $sRet EndFunc Func _ServiceStart() $objWMIService = ObjGet("winmgmts:" & "{impersonationLevel=impersonate}!\\" & $strComputer & "\root\cimv2") $Services = $objWMIService.ExecQuery("Select * from Win32_Service where Name Like 'cisvc%'") For $objService in $Services $objService.StartService() MsgBox(0,"Service State","Service Started") Next EndFunc ;------------------------------ This is a COM Error handler -------------------------------- Func MyErrFunc() $HexNumber=hex($oMyError.number,8) Msgbox(0,"COM Error Test","We intercepted a COM Error !" & @CRLF & @CRLF & _ "err.description is: " & @TAB & $oMyError.description & @CRLF & _ "err.windescription:" & @TAB & $oMyError.windescription & @CRLF & _ "err.number is: " & @TAB & $HexNumber & @CRLF & _ "err.lastdllerror is: " & @TAB & $oMyError.lastdllerror & @CRLF & _ "err.scriptline is: " & @TAB & $oMyError.scriptline & @CRLF & _ "err.source is: " & @TAB & $oMyError.source & @CRLF & _ "err.helpfile is: " & @TAB & $oMyError.helpfile & @CRLF & _ "err.helpcontext is: " & @TAB & $oMyError.helpcontext _ ) SetError(1) ; to check for after this function returns EndfuncoÝ÷ Ù«¢+ØìÌͽÁ¹µMÉ¥ÁÐM½Á¡Ý¥Ñ Ñ¡ÁÑ èÀäÈíMÉ¥ÁÑ̤Ѽ¸%¹á¥¹MÉ٥ѱ½¹µMÉ¥ÁРѱ½½¸Ñ¡±½°½µÁÕÑȸ((ÀÌØí½©µ¥¹%Lô=© ÉÑ ÅÕ½Ðí5¥É½Í½Ð¹%M´ÅÕ½Ðì¤(ÀÌØí½© ѱ½ôÀÌØí½©µ¥¹%L¹Ñ ѱ½ å9µ ÅÕ½ÐíMÉ¥ÁРѱ½ÅÕ½Ðì¤(ÀÌØí½©M½ÁôÀÌØí½© ѱ½¹M½Á ÅÕ½ÐíèÀäÈíÍÉ¥ÁÑÌÀäÈí%¹á¥¹MÉÙÈÅÕ½Ð찱ͤ(ÀÌØí½©M½Á¹±¥ÌôÅÕ½ÐíMÉ¥ÁÐͽÁÅÕ½Ðì(ÀÌØí½©M½Á¹AÑ ôÅÕ½ÐíèÀäÈíÍÉ¥ÁÑÌÅÕ½ÐìoÝ÷ Ù«¢+Øì ½¹¥ÕÉÌÑ¡%¹á¥¹MÉÙ¥½¸Ñ¡±½°½µÁÕÑÈѼÕѽµÑ¥±±äÍÑÉРѥµÑ¡½µÁÕÑÈÍÑÉÑ̸(ìQ¼½¹¥ÕÉÑ¡%¹á¥¹MÉÙ¥½Èµ¹Õ°ÍÑÉаÍÐÑ¡ÁɵÑÈÁÍÍѼѡ¹± $µÑ¡½Ñ¼±ÍÉÑ¡ÈÑ¡¸QÉÕ¸(ì5¹Õ°ÍÑÉÐ¥ÌÑ¡Õ±ÐÍÑÑ¥¹½ÈÑ¡%¹á¥¹MÉÙ¥¸((ÀÌØí½©µ¥¹%Lô=© ÉÑ ÅÕ½Ðí5¥É½Í½Ð¹%M´ÅÕ½Ðì¤(ÀÌØí½©µ¥¹%L¹¹± $¡QÉÕ¤oÝ÷ Ù«¢+ØìIÑÕɹ̥¹½ÉµÑ¥½¸½Õб°Ñ¡%¹á¥¹MÉ٥ѱ½ÌÙ¥±±½¸Ñ¡±½°½µÁÕÑȸ((ÀÌØí½©µ¥¹%Lô=© ÉÑ ÅÕ½Ðí5¥É½Í½Ð¹%M´ÅÕ½Ðì¤(ÀÌØí½© ѱ½ôÀÌØí½©µ¥¹%L¹¥¹¥ÉÍÑ Ñ±½ ¤)% ÀÌØí½© ѱ½¤Q¡¸(ÀÌØí½© Ñ´ôÀÌØí½©µ¥¹%L¹Ñ ѱ½ ¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí ѱ½±½Ñ¥½¸èÅÕ½ÐìµÀìÀÌØí½© Ñ´¹ ѱ½1½Ñ¥½¸µÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí ѱ½¹µèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹ ѱ½9µµÀì I1¤(% ÀÌØí½©µ¥¹%L¹%ÍIÕ¹¹¥¹¤Q¡¸( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí%ÌÍѽÁÁèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹%Í Ñ±½MѽÁÁµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí%ÌÁÕÍèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹%Í Ñ±½AÕ͵Àì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí%ÌÉÕ¹¹¥¹èÅÕ½ÐìµÀìÀÌØí½© Ñ´¹%Í Ñ±½IÕ¹¹¥¹µÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí±å¥±ÑȽչÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹±å¥±ÑÉ ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí½Õµ¹ÑÌѼ¥±ÑÈèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹½Õµ¹ÑÍQ½¥±ÑȵÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí¥±Ñɽյ¹Ð½Õ¹ÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹¥±Ñɽյ¹Ñ ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíÉÍ ÑÍнչÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹ÉÍ¡QÍÑ ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí%¹àÍ¥éèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹%¹áM¥éµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíAɹеɽµÁ±ÑèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹AÑ5É ½µÁ±ÑµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíA¹¥¹Í¸½Õ¹ÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹A¹¥¹M¹ ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíAÉÍ¥ÍѹХ¹à½Õ¹ÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹AÉÍ¥ÍѹÑ%¹á ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíEÕÉä½Õ¹ÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹EÕÉå ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíMÑÑ¥¹¼èÅÕ½ÐìµÀìÀÌØí½© Ñ´¹MÑÑ%¹¼µÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíQ½Ñ°½Õµ¹Ð½Õ¹ÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹Q½Ñ±½Õµ¹Ñ ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíU¹¥ÅÕä½Õ¹ÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹U¹¥ÅÕ-å ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí]½É±¥ÍнչÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹]½É1¥ÍÑ ½Õ¹ÐµÀì I1¤(¹%)¹%($% ½¹Í½±Ýɥѡ I1¤)]¡¥±Ä(ÀÌØí½© ѱ½ôÀÌØí½©µ¥¹%L¹¥¹9áÑ Ñ±½ ¤(% ÀÌØí½© ѱ½¤Q¡¸(ÀÌØí½© Ñ´ôÀÌØí½©µ¥¹%L¹Ñ ѱ½ ¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí ѱ½±½Ñ¥½¸èÅÕ½ÐìµÀìÀÌØí½© Ñ´¹ ѱ½1½Ñ¥½¸µÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí ѱ½¹µèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹ ѱ½9µµÀì I1¤(% ÀÌØí½©µ¥¹%L¹%ÍIÕ¹¹¥¹¤Q¡¸( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí%ÌÍѽÁÁèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹%Í Ñ±½MѽÁÁµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí%ÌÁÕÍèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹%Í Ñ±½AÕ͵Àì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí%ÌÉÕ¹¹¥¹èÅÕ½ÐìµÀìÀÌØí½© Ñ´¹%Í Ñ±½IÕ¹¹¥¹µÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí±å¥±ÑȽչÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹±å¥±ÑÉ ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí½Õµ¹ÑÌѼ¥±ÑÈèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹½Õµ¹ÑÍQ½¥±ÑȵÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí¥±Ñɽյ¹Ð½Õ¹ÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹¥±Ñɽյ¹Ñ ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíÉÍ ÑÍнչÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹ÉÍ¡QÍÑ ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí%¹àÍ¥éèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹%¹áM¥éµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíAɹеɽµÁ±ÑèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹AÑ5É ½µÁ±ÑµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíA¹¥¹Í¸½Õ¹ÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹A¹¥¹M¹ ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíAÉÍ¥ÍѹХ¹à½Õ¹ÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹AÉÍ¥ÍѹÑ%¹á ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíEÕÉä½Õ¹ÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹EÕÉå ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíMÑÑ¥¹¼èÅÕ½ÐìµÀìÀÌØí½© Ñ´¹MÑÑ%¹¼µÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíQ½Ñ°½Õµ¹Ð½Õ¹ÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹Q½Ñ±½Õµ¹Ñ ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíU¹¥ÅÕä½Õ¹ÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹U¹¥ÅÕ-å ½Õ¹ÐµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí]½É±¥ÍнչÐèÅÕ½ÐìµÀìÀÌØí½© Ñ´¹]½É1¥ÍÑ ½Õ¹ÐµÀì I1¤(¹%(±Í(á¥Ð(¹%)]¹oÝ÷ Ù«¢+ØìIÑÕɹ̥¹½ÉµÑ¥½¸½Õб°Ñ¡%¹á¥¹MÉ٥ͽÁ̽չ½¸Ñ¡±½°½µÁÕÑȸ((ÀÌØí½©µ¥¹%Lô=© ÉÑ ÅÕ½Ðí5¥É½Í½Ð¹%M´ÅÕ½Ðì¤(ÀÌØí½© ѱ½ôÀÌØí½©µ¥¹%L¹¥¹¥ÉÍÑ Ñ±½ ¤)% ÀÌØí½© ѱ½¤Q¡¸(ÀÌØí½© Ñ´ôÀÌØí½©µ¥¹%L¹Ñ ѱ½ ¤(ÀÌØí½©M½Á´ôÀÌØí½© Ñ´¹ÑM½Á ¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí±¥ÌèÅÕ½ÐìµÀìÀÌØí½©M½Á´¹±¥ÌµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðíá±ÕͽÁèÅÕ½ÐìµÀìÀÌØí½©M½Á´¹á±ÕM½ÁµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí1½½¸èÅÕ½ÐìµÀìÀÌØí½©M½Á´¹1½½¸µÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíAÑ èÅÕ½ÐìµÀìÀÌØí½©M½Á´¹AÑ µÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíY¥ÉÑհͽÁèÅÕ½ÐìµÀìÀÌØí½©M½Á´¹Y¥ÉÑÕ±M½ÁµÀì I1¤)¹%(% ½¹Í½±]ɥѡ I1¤)Ý¡¥±Ä(ÀÌØí½© ѱ½ôÀÌØí½©µ¥¹%L¹¥¹9áÑ Ñ±½ ¤(% ÀÌØí½© ѱ½¤Q¡¸(ÀÌØí½© Ñ´ôÀÌØí½©µ¥¹%L¹Ñ ѱ½ ¤(ÀÌØí½©M½Á´ôÀÌØí½© Ñ´¹ÑM½Á ¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí±¥ÌèÅÕ½ÐìµÀìÀÌØí½©M½Á´¹±¥ÌµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðíá±ÕͽÁèÅÕ½ÐìµÀìÀÌØí½©M½Á´¹á±ÕM½ÁµÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½Ðí1½½¸èÅÕ½ÐìµÀìÀÌØí½©M½Á´¹1½½¸µÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíAÑ èÅÕ½ÐìµÀìÀÌØí½©M½Á´¹AÑ µÀì I1¤( ½¹Í½±ÝÉ¥Ñ ÅÕ½ÐíY¥ÉÑհͽÁèÅÕ½ÐìµÀìÀÌØí½©M½Á´¹Y¥ÉÑÕ±M½ÁµÀì I1¤(±Í(á¥Ð(¹%)]¹ Regards, ptrex Edited September 10, 2007 by ptrex mLipok 1 Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
randallc Posted September 3, 2007 Share Posted September 3, 2007 Condition is well that your Indexing Service is running.Possible to get it runnig if not...? Best, randall [but it does slow down systems a lot, doesn't it?....] ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
ptrex Posted September 3, 2007 Author Share Posted September 3, 2007 Hi randallc,Possible to get it runnig if not...?What do you mean ? You can't get it running ?but it does slow down systems a lot, doesn't it?....]Not realy because it only runs when the system is Idle.regards,ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
randallc Posted September 3, 2007 Share Posted September 3, 2007 Hi, i can't get it running by script, if someone's computer doesn't already have it running (some of mine don't, ; i could do it manually, but that won't help when I'm not there....) Best, randall ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
ptrex Posted September 3, 2007 Author Share Posted September 3, 2007 @randallc - If the service is not running I can extend the script to check the status of the service and start it if needed. - Or you can set the service to start automaticallly go to Services - Indexing Service - set it to start up AUTOMATICALLY. If you want me to extand the script let me know. regards pterx Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
randallc Posted September 3, 2007 Share Posted September 3, 2007 Yes, thanks, that would be useful for other people's computers; I would like it to run automatically for them, too, rather than telling them how to do it manually... If you can do it easily, thanks, Randall ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
ptrex Posted September 3, 2007 Author Share Posted September 3, 2007 @randallc Updated first post with the check on the service State and / or Starting Service. Regards, ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
randallc Posted September 3, 2007 Share Posted September 3, 2007 @randallc Updated first post with the check on the service State and / or Starting Service.Regards,ptrexMany thanks; seems to be working, I'll look..Randall ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
ptrex Posted September 4, 2007 Author Share Posted September 4, 2007 (edited) @allFor those who are not familiar with the build-in Indexing service in your system.Have look here on how to activate it : What is MS Indexing ServiceCheck this on how to set the performance tuning : Regarding the overhead, this is fully configurable as well :Performance tuningCheck this on how to use the advanced SQL features :SQL for MS Indexing ServiceFurthermore for adding PDF support you can download the addon from here :PDF iFilter extensionThis will add content search on PDF files as well.Certainly the MS indexing Service is an on of the most undervaluated features in Windows, so far. Let's change this right now. regards,ptrex Edited September 4, 2007 by ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
ptrex Posted September 4, 2007 Author Share Posted September 4, 2007 @all Added the link to extend your system with the iFilter interface for Adobe PDF content search. see previous post. Enjoy !! ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
randallc Posted September 4, 2007 Share Posted September 4, 2007 (edited) Hi, Much more complex, of course than a simple name searching... but if I use it in a script, thanks for putting _ServiceState(),_ServiceStart() - when a script starts on any given computer, we won't know if indexing on, or performed lately? 1. Can we know when we can start searching? _ServiceCompleted() or IndexingFinishedFirstTime() perhaps? [else we wait 30 mins as we do with MS XP search if indexing has been off?] - or get incomplete results 2. Does this work on Win 9x? 3. It is going to be a new learning exercise just to understand the index and its return; I get only 10 (not 100) files returned if i revert to filename matching only; and only from 19th August, for example, of about 554 matches with my index and search; so I presume it is making 3A) assumptions about best match -which i will have to learn to workaround, 3B) not indexing since 19th August, and this program has not restarted it? - What do you think? 4. what do we know about speed of finding matches? Thanks, Randall [PS - for me, the MS info links for info above do not tell how to do this by script in AutoIt? - do they for anyone?] Edited September 4, 2007 by randallc ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
ptrex Posted September 5, 2007 Author Share Posted September 5, 2007 (edited) @Randallcwhen a script starts on any given computer, we won't know if indexing on, or performed lately?This is like in any indexing sytem, you can't start untill the index is complete. 1. Can we know when we can start searching? The status of the index can be monitored through the PC management console. In there you can see the status of the indexing system, as well as the nr. of docs which are indexed, and how many still to do.See post 9 where I showed you links to a tutorial on how to do this.2. Does this work on Win 9x?No, only available as of Win2K.3. It is going to be a new learning exercise just to understand the index and its return3A) assumptions about best match -which i will have to learn to workaround, 3B) not indexing since 19th August, and this program has not restarted it? - What do you think?It all depends on how good you use the SQL statements of course.4. what do we know about speed of finding matches?On my rather old laptop it gets 100 results (looking for the word AU3) as extension and content, in 0.477 Secs.MS info links for info above do not tell how to do this by script in AutoIt? - do they for anyone?If you want to start using the MS inidexing Service in AU3, you will have to start at the beginning.What is MS Indexing Serviceregards,ptrex Edited September 5, 2007 by ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
randallc Posted September 5, 2007 Share Posted September 5, 2007 (edited) h,Thanks for your input..The status of the index can be monitored through the PC management console.I presume you mean this is so difficult to script that it isn't easy even for you! - So I have little hope of getting it going! - my next plan is just to use it as an option for people who know their MS index is working! -nice addition, and thanks!If you want to start using the MS inidexing Service in AU3What is MS Indexing ServiceI added this to my searchMiner as an option to use for searching, just for a trial..; when I fine-tuned it (not the current version at the link in my sig.. which shows MSIndex way slower), it was only 20-30% slower than my searches for file names only..I understand the extra benefits if you are searching for content... not in my planning.best, Randall Edited September 5, 2007 by randallc ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
ptrex Posted September 5, 2007 Author Share Posted September 5, 2007 @Randallc I presume you mean this is so difficult to script that it isn't easy even for you!Not realy. But you can't expect me to give you all possibilities in this thread, do you ? This is the property to check for monitoring the Index status. If (objQuery.OutofDate = TRUE) Then ' Report this condition. End if You will have to do a little digging yourself in order to understand all possibilities. regards ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
randallc Posted September 5, 2007 Share Posted September 5, 2007 If (objQuery.OutofDate = TRUE) Then ' Report this condition. End ifOk, thanks; are you saying that "digging" was available in the links you suggested?; I couldn't see it, and have had no luck on Gooogle for "script configuration MS Index" and similar, except to find that original script you posted (as vbs)... ? Best, Randall ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
ptrex Posted September 6, 2007 Author Share Posted September 6, 2007 @Randallc When I said "digging" I meant start reading the MSDN relating to MS Indexing Service. As posted in my link post 12. This contains all information needed to get started. I know it rather boring to start reading, but that the only descend way to understand what it's about. It includes example scripts as well. Later on you can start "Googling" some example scripts. If you have things you can't find I am willing to point you out where to look. Regards, ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
randallc Posted September 10, 2007 Share Posted September 10, 2007 OK, thanks. I have added mS Index to search as an option to my SearchMiner front end [filename search only]; PM me if anyone wants, not yet uploaded; you no longer need any index at all; but if MS Index not running, and no generated index, can only search from scriptdirectory and subs.. Best, randall ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
ptrex Posted September 10, 2007 Author Share Posted September 10, 2007 @randallc Thanks for adding this feature. But best is to upload the sourcecode otherwise people can't see if they can use it. In the mean time I will give you some more candy to chew on. See first post. Regards ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
randallc Posted September 22, 2007 Share Posted September 22, 2007 (edited) @randallc ;)Thanks for adding this feature.But best is to upload the sourcecode otherwise people can't see if they can use it.In the mean time I will give you some more candy to chew on. See first post.RegardsptrexOK,Low enough bug number that I have posted it now!;See link to "SearchMiner" in signature..Best, randall[if no custom index, list "as you type" only shows files in script directory...; then "Search" gives MSIndex files if running ...]still faster for both if you go to the Index option and allow the 5-10 minutes;...even if only once..best,randall Edited September 22, 2007 by randallc ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
ptrex Posted September 23, 2007 Author Share Posted September 23, 2007 @ Thanks for the update !! regards ptrex Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File FinderSQLite3 Database functionality - USB Monitoring - Reading Excel using SQLRun Au3 as a Windows Service - File Monitor - Embedded Flash PlayerDynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in WindowsRead data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD WebserverMS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB ProtocolFinancial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing ControlsGuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - Update - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM - New Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now