Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Powershell and Administration Expand / Collapse
Author
Message
Posted Friday, January 8, 2010 9:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 15, 2014 6:39 AM
Points: 7, Visits: 156
Has anyone used PowerShell 1.0 to configure ReportServices in Sql Server 2008?
Post #844448
Posted Monday, July 9, 2012 6:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:53 AM
Points: 40, Visits: 167
I have just started to use it.....so far I have created scripts to:

1. Show all SQL Agent jobs with status - across all of my SQL servers
2. Show all backup dates - across all of my SQL servers
3. Collect information on my databases - across all of my SQL servers

All 3 reports get put into an excel spreadsheet.....

I would be interested in how you filter out the log messages across your servers....
Post #1326793
Posted Monday, July 9, 2012 9:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:27 PM
Points: 7,107, Visits: 12,657
If just starting out I highly recommend getting into PowerShell. It really has no peer in the Microsoft stack in terms of a command-line scripting tool. VBScript and JavaScript are not in the same league. A Windows build of Perl, or a combination of Perl plus some of the Linux/Unix shells running in Cygwin might be the closest comparison I could make. I use PowerShell for lots of things. Since I am almost always in an environment where I am responsible for some aspect of multiple instances PowerShell is where I go. Running the same script against multiple instances can be done in a SSMS multi-query window, but that's a manual chore and quite a PITA if doing something non-trivial or trying to compile results for more analysis. PowerShell lets me automate most everything. My most ambitious use of PS to date is a script that runs a set of Policies against ~20 SQL 2008R2 instances, stores the results in a table and emails a report of failed policies. I also use it to read Windows Event logs on all those servers and bring them into a central table so I can report on Windows errors. PowerShell is a strategic play for Microsoft so it is a safe bet to invest in learning. I would encourage you to embrace it, especially now since you're just starting out and already have a programming background. I think it would be a natural fit for you.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1326926
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse