Solved

Server downtime reporting

Posted on 2006-06-19
8
583 Views
Last Modified: 2011-10-03
Recently management requested quarterly downtime reports.  We currently use intermapper to monitor around 300 servers.  However, it has no downtime reporting feature.  I'd really like to avoid logging downtimes manually into a spreadsheet.  I'm hoping to find a simple ping or snmp utility that can handle at least 300 nodes and allow for downtime reports to be run at a later time.

I'm looking for a free solution.
0
Comment
Question by:Cerixus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 13

Expert Comment

by:2hype
ID: 16936146
http://www.soft32.com/download_1011.html

The software above should work
0
 
LVL 13

Expert Comment

by:2hype
ID: 16936156
oops its free for only 3 nodes unless you buy.  Forgot about the 300 nodes
0
 
LVL 22

Expert Comment

by:mcsween
ID: 16937058
I wrote this VBscript which works pretty well.  Only 1 stipulation is it must be run as a Domain Admin in the same domain as the servers  you are checking, so if you want to check servers in multiple domains you will have to setup one instance of this script for each domain.  I suggest scheduling this to run every 10 or 15 minutes with task scheduler.

Create a folder anywhere on the box that will run the script.
Create servers.txt in that folder and place the name of each server you want to check on it's own line with no spaces before or after, also DO NOT include the "\\"

Create another file called CheckStatus.vbs and copy the following text to that file.  The output will be written to ServerStatus.csv in the same folder.  You can use Excel to create reports/graphs/etc... from this file.

'~~~~~~~~~START SCRIPT~~~~~~~~~~~
Option Explicit
On Error Resume Next

Dim servername, WMI, fso, serverlist, outfile

Set fso = CreateObject("Scripting.FileSystemObject")
Set serverlist = fso.OpenTextFile("./servers.txt",1)
If fso.FileExists("./ServerStatus.csv") = True Then
      Set outfile = fso.OpenTextFile("./ServerStatus.csv",8)
Else
      Set outfile = fso.CreateTextFile("./ServerStatus.csv",True)
      outfile.WriteLine "Server Name, Date/Time, Status"
End If

Do While serverlist.AtEndOfStream = False
      servername = serverlist.ReadLine
      Set WMI = GetObject("winmgmts:\\" & servername & "\root\cimv2")
      If WMI Is Nothing Then
            outfile.WriteLine servername & ", " & Now & ", DOWN"
      Else
            outfile.WriteLine servername & ", " & Now & ", UP"
      End If
Loop
'~~~~~~~~~END~~~~~~~~~~~~~~~~
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 22

Expert Comment

by:mcsween
ID: 16937100
Crap, I missed some cleanup in that script above, use this portion as the VBScript instead

'~~~~~~~~~START SCRIPT~~~~~~~~~~~
Option Explicit
On Error Resume Next

Dim servername, WMI, fso, serverlist, outfile

Set fso = CreateObject("Scripting.FileSystemObject")
Set serverlist = fso.OpenTextFile("./servers.txt",1)
If fso.FileExists("./ServerStatus.csv") = True Then
      Set outfile = fso.OpenTextFile("./ServerStatus.csv",8)
Else
      Set outfile = fso.CreateTextFile("./ServerStatus.csv",True)
      outfile.WriteLine "Server Name, Date/Time, Status"
End If

Do While serverlist.AtEndOfStream = False
      servername = serverlist.ReadLine
      Set WMI = GetObject("winmgmts:\\" & servername & "\root\cimv2")
      If WMI Is Nothing Then
            outfile.WriteLine servername & ", " & Now & ", DOWN"
      Else
            outfile.WriteLine servername & ", " & Now & ", UP"
      End If
      Set WMI = Nothing
Loop
'~~~~~~~~~END~~~~~~~~~~~~~~~~
0
 
LVL 1

Author Comment

by:Cerixus
ID: 16937203
Gah.  I typed up a nice response to your solution just to get an error saying "Invalid question (ID:0)".

In short, that won't really work.  I need a shorter poll interval (to catch reboots) and better reporting options.
0
 
LVL 8

Accepted Solution

by:
ksearch earned 500 total points
ID: 16941867
I'm not sure of your environment, but since you posted in the "microsoft network" forum, I'm assuming it's micrsoft. There is a free tool from microsoft called uptime.  It's simple, command line driven and gives all kinds of good stats.  You could use a script to get it to run against all 300 nodes and dump to a log.   It's free, easy to try, and worth a shot.  




0
 
LVL 1

Author Comment

by:Cerixus
ID: 16942267
Wow.  Now THAT may be something I can work with.  With the /p:90 /s switches, it's almost exactly what I need already.

I'll play with it a bit and come back and award points later if there are no better solutions.

Thanks.
0
 
LVL 1

Author Comment

by:Cerixus
ID: 17012920
Not exactly what I had in mind, but I think it will work.

Thanks.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to scan rdp  ''only'' open port 3333? 5 152
Using Windows Firewall to separate 2 networks on PC with dual NICS? 5 110
Setting up a VPN 60 205
Cannot Change Local DNS 9 71
Downtime reduced, data recovered by utilizing an Experts Exchange Business Account Challenge The United States Marine Corps employs more than 200,000 active-duty Marines with operations in four continents, all requiring complex networking system…
The Need In an Active Directory enviroment, the PDC emulator provide time synchronization for the domain. This is important since Active Directory uses Kerberos for authentication.  By default, if the time difference between systems is off by more …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

762 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