Search Files By Name

Hackoo · May 30, 2011

SearchFileByName.vbs : This is a VBScript to find files by name and generate the search results in a table in HTML citing information on these files such that their paths, creation date, modification date, size and attributes.

Update On 29/05/2011: Adding and Displaying Miniature differents types of images when searching Eg if the search includes image files will be displayed as thumbnails.

if there is something to improve this script please post it.

Thank you !

'SearchFileByName.vbs © Hackoo Le 26/05/2011 : C'est un Vbscript pour rechercher des fichiers par leurs noms 
'et générer le Résultat de recherche dans un Tableau en HTML en citant les informations 
'sur ces fichiers tels que leurs Chemins ,la date de création,la date de modification,la Taille et leurs attributs 
'Mise à jour Le 29/05/2011 : Ajout et Affichage des miniatures de diffrentes types d'images lors de la recherche 
'Càd si la Recherche comporte des fichiers images elles seront affichées en miniatures 
Dim fso, OutFile, sDrv, sFName, sReport, sFile, sTitle ,strHTML 
sTitle = "Recherche des Fichiers Par leurs Noms" 
Set fso = CreateObject("Scripting.FileSystemObject") 
OutFile = "Recherche.html" 
If fso.FileExists(OutFile) Then fso.DeleteFile(OutFile) 

Set sReport = fso.OpenTextFile(OutFile, 8, True) 
sDrv = InputBox("Entrez la lettre du lecteur à la recherche (lettre seulement)" &amp; vbcrlf&amp;_ 
"ou bien " &amp; vbcrlf &amp; "(Saisissez * pour rechercher dans toutes les lettres de lecteur local)", sTitle) 
If sDrv = "" Then WScript.Quit 

sFName = InputBox ("Entrez le nom du fichier à rechercher (sans extension)", sTitle) 
If sFName = "" Then WScript.Quit 

strHTML="&lt;html&gt;&lt;body text=white&gt;&lt;style type='text/css'&gt;"&amp;_ 
"a:link {color: #F19105;}"&amp;_ 
"a:visited {color: #F19105;}"&amp;_ 
"a:active {color: #F19105;}"&amp;_ 
"a:hover {color: #FF9900;background-color: rgb(255, 255, 255);}"&amp;_ 
"&lt;/style&gt;" 

strHTML=strHTML &amp;"&lt;center&gt;&lt;h2&gt;&lt;B&gt; &lt;font color=Red&gt;[COUNT] &lt;/font&gt;Fichiers Trouvés dont le Nom est &lt;font color=red&gt;"""&amp; sFName &amp;""" &lt;/font&gt; sur le lecteur &lt;font color=red&gt;"&amp; UCase(sDrv) &amp; ":&lt;/B&gt;&lt;/font&gt;&lt;/h2&gt;&lt;/center&gt;"&amp;_ 
"&lt;center&gt;&lt;body bgcolor=#1234568&gt;&lt;table border='3' cellpadding='1' style='border-collapse: collapse; font size:11pt' bordercolor='#CCCCCC' width='100%' id='Table1'&gt;&lt;/center&gt;" &amp; _ 
"&lt;td&gt;&lt;center&gt;&lt;strong&gt;Chemin :&lt;/strong&gt;&lt;/center&gt;&lt;/td&gt;"&amp;_ 
"&lt;td&gt;&lt;center&gt;&lt;strong&gt;Date de Création :&lt;/strong&gt;&lt;/center&gt;&lt;/td&gt;"&amp; _ 
"&lt;td&gt;&lt;center&gt;&lt;strong&gt;Date de Modification :&lt;/strong&gt;&lt;/center&gt;&lt;/td&gt;"&amp;_ 
"&lt;td&gt;&lt;center&gt;&lt;strong&gt;Taille :&lt;/strong&gt;&lt;/center&gt;&lt;/td&gt;"&amp;_ 
"&lt;td&gt;&lt;center&gt;&lt;strong&gt;Attributs:&lt;/strong&gt;&lt;/center&gt;&lt;/td&gt;" 

If sDrv = "*" Then 
Dim d,dc,racine 
     Set fso = CreateObject("Scripting.FileSystemObject") 
     Set dc = fso.Drives 
     For Each d in dc 
          racine = d.Driveletter &amp; ":" 
          If d.IsReady Then 
          GetResults racine , sFName      
          End If 
     Next 
Else 
GetResults sDrv &amp; ":", sFName 
End If 
sReport.WriteLine strHTML &amp;"&lt;/table&gt;&lt;/body&gt;&lt;/html&gt;" 
Wscript.CreateObject("WScript.Shell").Run OutFile 

Sub GetResults(drv, fname) 
Dim sWQL, oFile, sAttrib,sFilePath,size 
ext = Array("png","jpg","jpeg","gif","bmp","psd","tif") 
sWQL = "select * from cim_datafile where Drive='" &amp; _ 
drv &amp; "' AND FileName = '" &amp; fname &amp; "'" 
Results = 0 
For Each oFile In GetObject("winmgmts:").execquery(sWQL) 
Results = Results + 1 
sFile = oFile.Name 
Set f = fso.GetFile(sFile) 

SizeKo = Round(FormatNumber(f.Size)/(1024),1) &amp; " Ko" 'Taille en Ko avec 1 chiffre après la Virgule 
SizeMo = Round(FormatNumber(f.Size)/(1048576),1) &amp; " Mo" 'Taille en Mo avec 1 chiffre après la Virgule 
SizeGo = Round(FormatNumber(f.Size)/(1073741824),1) &amp; " Go" 'Taille en Go avec 1 chiffre après la Virgule 

If f.size &lt; 1024 Then 
Size = f.size &amp; " Octets" 
elseif f.size &lt; 1048576 Then 
Size = SizeKo 
elseif f.size &lt; 1073741824 Then 
Size = SizeMo 
else 
Size = SizeGo 
end if 
sFilePath = f.Path 
If oFile.Archive Then sAttrib = "Archive " 
If oFile.Compressed Then sAttrib = sAttrib &amp; " Compressé " 
If oFile.Encrypted Then sAttrib = sAttrib &amp; " Crypté " 
If oFile.Hidden Then sAttrib = sAttrib &amp; " Caché " 
If oFile.System Then sAttrib = sAttrib &amp; " Système " 
If oFile.Readable Then sAttrib = sAttrib &amp; " Lecture " 
If oFile.Writeable Then sAttrib = sAttrib &amp; " Ecriture " 

If UCase(ext(0)) = UCase(fso.GetExtensionName(oFile.Name)) or UCase(ext(1)) = UCase(fso.GetExtensionName(oFile.Name))or UCase(ext(2)) = UCase(fso.GetExtensionName(oFile.Name)) or UCase(ext(3)) = UCase(fso.GetExtensionName(oFile.Name)) or UCase(ext(4)) = UCase(fso.GetExtensionName(oFile.Name)) or UCase(ext(5)) = UCase(fso.GetExtensionName(oFile.Name)) or UCase(ext(6)) = UCase(fso.GetExtensionName(oFile.Name)) Then 

ImgFileName = oFile.Name 
strHTML=strHTML &amp; "&lt;tr&gt;&lt;td&gt;&lt;a target=_Blank href='"&amp; sFilePath &amp;"'&gt;"&amp;ImgFileName&amp;"&lt;br&gt;&lt;img src='"&amp; sFilePath &amp;"' border=1 height=50 width=80&gt;&lt;/center&gt;&lt;/td&gt;&lt;td&gt;&lt;center&gt;" &amp; f.DateCreated &amp; "&lt;/center&gt;&lt;/td&gt;" &amp; _ 
"&lt;td&gt;&lt;center&gt;" &amp; f.DateLastModified &amp; "&lt;/center&gt;&lt;/td&gt;&lt;td&gt;&lt;center&gt;"&amp; Size &amp; "&lt;/center&gt;&lt;/td&gt;"&amp;_ 
"&lt;td&gt;&lt;center&gt;" &amp; sAttrib &amp; "&lt;/center&gt;&lt;/td&gt;&lt;/tr&gt;" 
else 
strHTML=strHTML &amp; "&lt;tr&gt;&lt;td&gt;&lt;a target=_Blank href='" &amp; sFilePath &amp; "'&gt;" &amp; _ 
sFilePath &amp; "&lt;/a&gt;&lt;/td&gt;&lt;td&gt;&lt;center&gt;" &amp; f.DateCreated &amp; "&lt;/center&gt;&lt;/td&gt;" &amp; _ 
"&lt;td&gt;&lt;center&gt;" &amp; f.DateLastModified &amp; "&lt;/center&gt;&lt;/td&gt;&lt;td&gt;&lt;center&gt;"&amp; Size &amp; "&lt;/center&gt;&lt;/td&gt;"&amp;_ 
"&lt;td&gt;&lt;center&gt;" &amp; sAttrib &amp; "&lt;/center&gt;&lt;/td&gt;&lt;/tr&gt;" 
end if 
Next 
strHTML = Replace(strHTML, "[COUNT]", Results) 
End Sub

Edited May 30, 2011 by Hackoo

Sign In

Search Files By Name

Recommended Posts

Hackoo

Link to comment

Share on other sites

Join the conversation

Recently Browsing 0 members

Browse

Activity