troubleshooting Question

Script for getting the Downtime report of all databases in the server.

Avatar of AhmedAliShaik
AhmedAliShaikFlag for India asked on
ExchangeShell ScriptingMicrosoft Applications
2 Comments1 Solution364 ViewsLast Modified:

We are calculating SLA based on the downtime of each storage group.

For example:

OUr server has 50 SG groups. If we are dismounting the DB for some maintainance or troubleshooting & mount it. The time will be considered as downtime.

I have a shell command which gives me the date & time of all the dismount and mount status of a server.

get-eventlog -LogName Application -Newest 20000 | Where-Object { $_.EventID -like "103" } | ft timewritten, eventid

get-eventlog -LogName Application -Newest 20000 | Where-Object { $_.EventID -like "102" } | ft timewritten, eventid,

event 103 lists all dismounted SG list and 102 list all mounted DB list with date & time.

My question is:

Can we consolidate all in a excel sheet and calculate the downtime by substracting the dismount time - mount time in a good format.

Plz give me ur ideas.
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros