SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 health report
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

DBA007
Posting Yak Master

India
145 Posts

Posted - 01/04/2013 :  09:46:20  Show Profile  Reply with Quote
Hi Team,

I need a help for the below

1.sqldatabase backup job failures from all servers

2.diskspace utilization from all servers

3.Logspace utilization from all servers

These need to be generated as single Excel file and send to mailid everday

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3383 Posts

Posted - 01/04/2013 :  09:53:55  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
What sort of connectivity do you have and do you have a list of the servers you need to access?
Might be better to do this on the servers and send the info out as it might cause issues if a server wasn't contactable.

You might also look at a monitoring product.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

DBA007
Posting Yak Master

India
145 Posts

Posted - 01/04/2013 :  09:56:31  Show Profile  Reply with Quote
my client is not ready to buy a monitoring product
Go to Top of Page

DBA007
Posting Yak Master

India
145 Posts

Posted - 01/09/2013 :  01:09:20  Show Profile  Reply with Quote
Hi Team,

No one has implemented this in your environment?
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 01/11/2013 :  14:28:25  Show Profile  Reply with Quote
quote:
Originally posted by DBA007

Hi Team,

I need a help for the below

1.sqldatabase backup job failures from all servers
Check for msdb.Sys.sysjobs
2.diskspace utilization from all servers
You can create linked server for all and query xp_fixeddrives store it in table
3.Logspace utilization from all servers
Do you different drive for logspace
These need to be generated as single Excel file and send to mailid everday

Go to Top of Page

srimami
Posting Yak Master

160 Posts

Posted - 01/15/2013 :  08:44:19  Show Profile  Reply with Quote
Hi DBA007,

If all the servers are on the same network domain, you can use sqlcmd to generate a single csv file or excel file and send email.

Thanks,
Sridhar.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000