Link to home
Start Free TrialLog in
Avatar of AhmedAliShaik
AhmedAliShaikFlag for India

asked on

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

Team,

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.
ASKER CERTIFIED SOLUTION
Avatar of Gerwin Jansen
Gerwin Jansen
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AhmedAliShaik

ASKER

Thankyou