Solved

Script to copy event logs

Posted on 2013-12-10
10
479 Views
Last Modified: 2013-12-12
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!
0
Comment
Question by:raphabar
  • 5
  • 5
10 Comments
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 39709707
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
0
 
LVL 1

Author Comment

by:raphabar
ID: 39709824
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!
0
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 39710023
What machine you going to run it on?
0
 
LVL 1

Author Comment

by:raphabar
ID: 39710195
I am going to run it on a local machine that has access to 4 different servers (part of the domain)
0
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 39710220
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
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 1

Author Comment

by:raphabar
ID: 39710253
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!
0
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 39711248
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
0
 
LVL 1

Author Comment

by:raphabar
ID: 39711447
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
0
 
LVL 1

Author Comment

by:raphabar
ID: 39711473
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!
0
 
LVL 23

Accepted Solution

by:
Thomas Grassi earned 500 total points
ID: 39711482
To view the files just use event viewer
right click on the file and select open.
or use event viewer and chose open saved logs option

test the move command manually first

rem out the echo off and exit command in the script

then you will see in the console the messages copy them and post

rem @echo off

rem exit
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I hope you'll find this tutorial useful and interesting. So let's try to extend Tcl with a new package.  For anyone more deeply interested please check out the book "Practical Programming in Tcl and Tk". It's really one of the best written books abo…
Know what services you can and cannot, should and should not combine on your server.
Learn the basics of modules and packages in Python. Every Python file is a module, ending in the suffix: .py: Modules are a collection of functions and variables.: Packages are a collection of modules.: Module functions and variables are accessed us…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now