Avatar of raphabar
raphabar
 asked on

Script to copy event logs

Hello everyone,

Sorry if this question was posted before, but I did a search and it did not give me the details I needed.

I have an environment of 4 servers (2 Server 2008 and 2 Server 2003) that I would like to run some kind of a script to copy the event logs (Applications, System, and Security) logs to a remote location with a directory that will have the date listed.

I do have domain admin rights on the boxes.

Can someone please provide some help in this area?

Thank you for your time!
VB ScriptMicrosoft Server OSScripting Languages

Avatar of undefined
Last Comment
Member_2_6492660_1

8/22/2022 - Mon
Member_2_6492660_1

I use this

@echo off
for /f "Tokens=1-4 Delims=/ " %%i in ('date /t') do set dt=%%i-%%j-%%k-%%l
for /f "Tokens=1-4 Delims=/ " %%i in ('date /t') do set dtd=%%j%%k%%l
for /f "Tokens=1" %%i in ('time /t') do set tm=-%%i
set tm=%tm::=-%
set dtt=%dt%%tm%
del c:\util\selogbu.txt
"C:\Program Files\Event Log Explorer\elback.exe" "C:\Documents and Settings\Administrator.OUR\My Documents\servers elog bu.elb"
C:\Util\7zip\7za a -y "e:\event log backups\servers\SERV005-%dtt%.zip" "e:\event log backups\servers\SERV005*.*"
C:\Util\7zip\7za a -y "e:\event log backups\servers\SERV010-%dtt%.zip" "e:\event log backups\servers\SERV010*.*"
C:\Util\7zip\7za a -y "e:\event log backups\servers\SERV011-%dtt%.zip" "e:\event log backups\servers\SERV011*.*"
C:\Util\7zip\7za a -y "e:\event log backups\servers\SERV012-%dtt%.zip" "e:\event log backups\servers\SERV012*.*"
C:\Util\7zip\7za a -y "e:\event log backups\servers\SERV013-%dtt%.zip" "e:\event log backups\servers\SERV013*.*"
del "e:\event log backups\servers\*.evt" >selogbu.txt
dir "e:\event log backups\servers\*.*" >>selogbu.txt
c:\util\febooti\febootimail -from support@email.net -to support@mydomain.com -msg "Servers Event Log BU Report" -subj "Backup Servers Event Log" -dontupdate -attach c:\util\selogbu.txt -smtp 10.168.169.26
exit


This use three utilities

1.  ELBACK from Event Log Viewer
2. 7ZIP command line  Free
3. Febooti batch SMTP email

I run this one a week and then it emails me a report files are zipped up to conserve disk space.

There are other utilities you can use but this script can be modified to use your utils
raphabar

ASKER
Thank you for your prompt reply. Sorry for the simple question but I am not a scripting guy, can you tell me which variables I will need to change on this script so I can test it on my environment?

thanks!
Member_2_6492660_1

What machine you going to run it on?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
raphabar

ASKER
I am going to run it on a local machine that has access to 4 different servers (part of the domain)
Member_2_6492660_1

What is the OS of the machine?

I will work up the changes to the script

Do you have a way to send email via batch?

You can download 7Zip command line program it is free

The event log backup process depends on the OS running
raphabar

ASKER
The OS of the machine is Win 7. the servers are all Server 2008.

I really do not want to install any applications (like 7 zip)

if it is possible I just want the script to copy and move the logs.

thank you!
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Member_2_6492660_1

Ok on windows 7 you have wevtutil that will do what you need

this is a simple batch that you can modify to your environment

@echo off
for /f "Tokens=1-4 Delims=/ " %%i in ('date /t') do set dt=%%i-%%j-%%k-%%l
for /f "Tokens=1-4 Delims=/ " %%i in ('date /t') do set dtd=%%j%%k%%l
for /f "Tokens=1" %%i in ('time /t') do set tm=-%%i
set tm=%tm::=-%
set dtt=%dt%%tm%
wevtutil epl application "c:\eventlogs\serverapplication-%dtt&.evtx" /r:servername
wevtutil epl system "c:\eventlogs\serversystem-%dtt&.evtx" /r:servername
wevtutil epl security "c:\eventlogs\serversecurity-%dtt&.evtx" /r:servername

move "c:\eventlogs\serverapplication-%dtt&.evtx" x:\eventlogs
move "c:\eventlogs\serversystem-%dtt&.evtx" x:\eventlogs
move "c:\eventlogs\serversecurity-%dtt&.evtx" x:\eventlogs
exit

When you connect to the remote server you may need to use the /u parameter
you can see all the explations of wevtutil by going to a command prompt and typing wevtutil hit enter.
then wevtutil COMMAND /? for more information

Plug in your server name so that you can separate the names in the listing easier.

need anymore help let me know
raphabar

ASKER
Hello trgrassijr55,

Thank you for the help. Sorry but I am not familiar with scripting, so I was unable to get the script to work fully. I ran the script above on a local Win 7 machine to see what it will do and below are the changes that I made:

@echo off
for /f "Tokens=1-4 Delims=/ " %%i in ('date /t') do set dt=%%i-%%j-%%k-%%l
for /f "Tokens=1-4 Delims=/ " %%i in ('date /t') do set dtd=%%j%%k%%l
for /f "Tokens=1" %%i in ('time /t') do set tm=-%%i
set tm=%tm::=-%
set dtt=%dt%%tm%
wevtutil epl application "c:\eventlogs\serverapplication-%dtt&.evtx" /r:RDProject
wevtutil epl system "c:\eventlogs\serversystem-%dtt&.evtx" /r:RDProject
wevtutil epl security "c:\eventlogs\serversecurity-%dtt&.evtx" /r:RDProject

move "c:\eventlogs\serverapplication-%dtt&.evtx" E:\EVENTLOGS
move "c:\eventlogs\serversystem-%dtt&.evtx" E:\EVENTLOGS
move "c:\eventlogs\serversecurity-%dtt&.evtx" E:\EVENTLOGS
exit

RDProject is just a made up name for a server. The first part of the Script worked where it copied the files but I am not sure how to open these files to view them. please see attached image.

the Move part didn't work for me, im not sure why.

Any help is much appreciated.

Thank you
Image.JPG
raphabar

ASKER
Update:

Sorry. Never mind about the file extensions, I was able to add .evt at the end to allow event viewer to open the files.

Thanks!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Member_2_6492660_1

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.