'**************************************************************** ' Filename..: fileSearch.vbs ' Author....: ScriptZilla / SkatterBrainz / Dave ' Date......: 07/30/2012 ' Purpose...: search for files using WMI/CIM_DataFile '**************************************************************** time1 = Timer '---------------------------------------------------------------- ' comment: search parameters '---------------------------------------------------------------- strFileExt = "syn" strFileName = "*" strDriveLtr = "c:" strComputer = "." '---------------------------------------------------------------- ' function: '---------------------------------------------------------------- Function StringDate(dv) Dim xdy, xdm, xdd, xdh, xdn, tmp ' example: 20120729195837.171181-240 xdy = Mid(dv,1,4) ' year xdm = Mid(dv,5,2) ' month xdd = Mid(dv,7,2) ' day xdh = Mid(dv,9,2) ' hour xdn = Mid(dv,11,2) ' minute tmp = xdm & "/" & xdd & "/" & xdy & " " & xdh & ":" & xdn StringDate = FormatDateTime(tmp, vbShortDate) & " " & _ FormatDateTime(tmp, vbLongTime) End Function '---------------------------------------------------------------- ' comment: main script code begins '---------------------------------------------------------------- Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") If strFileName = "*" Then query = "Select * from CIM_DataFile Where Drive='" & strDriveLtr & "'" & _ " AND Extension='" & strFileExt & "'" Else query = "Select * from CIM_DataFile Where Drive='" & strDriveLtr & "'" & _ " AND FileName = '" & strFileName & "'" & _ " AND Extension='" & strFileExt & "'" End If wscript.echo "info: search criteria = " & strFileName & "." & strFileExt & " on " & strDriveLtr Set colFiles = objWMIService.ExecQuery(query) wscript.echo "info: beginning search..." counter = 0 For Each objFile in colFiles counter = counter + 1 wscript.echo objFile.Drive & objFile.Path & _ objFile.FileName & "." & objFile.Extension & _ vbTab & StringDate(objFile.CreationDate) & _ vbTab & StringDate(objFile.LastModified) & _ vbTab & objFile.FileSize Next wscript.echo "info: " & counter & " matching files found" wscript.echo "info: " & Timer - time1 & " seconds"
Tuesday, July 31, 2012
File Search using WMI CIM_DataFile with VBScript
I looked around, but didn't find a script example that did exactly what I wanted, but I ran across several good alternatives. One thing I found was that if I don't specify the drive letter, it takes WAAAAAAAYYYYY longer to execute. Just a tip. In any case, I hope this helps someone out there...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment