sunexchange
asked on
VB Script - Write to Log
Hello
I need help in writing all transactions of my vb script to a log file (success and error)
Can someone help?
Here is my Vb Script:
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------
'Delete Log files older than 1 day from vFiler - DB Backups
Option Explicit
Dim objNetwork
Dim strDriveLetter, strRemotePath, strUser, strPassword, strProfile, objShell
Dim strFolderToSearch, objFSO, objRootFolder, objFolder, colSubfolders, strOutput
Const strMatch = "Log"
'Delete connection if exists
Set objShell = CreateObject("WScript.Shel l")
Set objNetwork = CreateObject("WScript.Netw ork")
On Error Resume Next
objNetwork.RemoveNetworkDr ive "L:"
'Set UNC connection to vFiler
Set objNetwork = CreateObject("Wscript.Netw ork")
objNetwork.MapNetworkDrive "L:", "\\10.10.10.1\data\ProdBac kups\Datab ase", False, "username", "pwd"
strFolderToSearch = "\\10.10.10.1\data\ProdBac kups\Datab ase"
Set objFSO = CreateObject("Scripting.Fi leSystemOb ject")
Set objRootFolder = objFSO.GetFolder(strFolder ToSearch)
'msgbox objRootFolder
SearchFolders objRootFolder
Wscript.Quit
Sub SearchFolders(objBaseFolde r)
For Each objFolder in objBaseFolder.SubFolders
'msgbox objFolder.Path
If InStr(objFolder.Name, strMatch) Then
If DateDiff("d", objFolder.DateCreated, Now) >= 1 Then
'msgbox objFolder.Path
objFolder.Delete
Else
SearchFolders objFolder
End If
Else
SearchFolders objFolder
End If
Next
End Sub
On Error Resume Next
objNetwork.RemoveNetworkDr ive "L:"
I need help in writing all transactions of my vb script to a log file (success and error)
Can someone help?
Here is my Vb Script:
--------------------------
'Delete Log files older than 1 day from vFiler - DB Backups
Option Explicit
Dim objNetwork
Dim strDriveLetter, strRemotePath, strUser, strPassword, strProfile, objShell
Dim strFolderToSearch, objFSO, objRootFolder, objFolder, colSubfolders, strOutput
Const strMatch = "Log"
'Delete connection if exists
Set objShell = CreateObject("WScript.Shel
Set objNetwork = CreateObject("WScript.Netw
On Error Resume Next
objNetwork.RemoveNetworkDr
'Set UNC connection to vFiler
Set objNetwork = CreateObject("Wscript.Netw
objNetwork.MapNetworkDrive
strFolderToSearch = "\\10.10.10.1\data\ProdBac
Set objFSO = CreateObject("Scripting.Fi
Set objRootFolder = objFSO.GetFolder(strFolder
'msgbox objRootFolder
SearchFolders objRootFolder
Wscript.Quit
Sub SearchFolders(objBaseFolde
For Each objFolder in objBaseFolder.SubFolders
'msgbox objFolder.Path
If InStr(objFolder.Name, strMatch) Then
If DateDiff("d", objFolder.DateCreated, Now) >= 1 Then
'msgbox objFolder.Path
objFolder.Delete
Else
SearchFolders objFolder
End If
Else
SearchFolders objFolder
End If
Next
End Sub
On Error Resume Next
objNetwork.RemoveNetworkDr
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.