Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Script to copy event logs

Posted on 2013-12-10
10
Medium Priority
?
517 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
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 1500 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Know what services you can and cannot, should and should not combine on your server.
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Suggested Courses

971 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