'****************************************************************
' 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