Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
devenoza
Starting Member
14 Posts |
 Posted - 2013-04-24 : 12:01:20
|
| In my company there are 500 SQL servers; how can I find out if SSIS is installed or not on those servers? I want to list out the servers who has SSIS installed on it. I dont want to do it manually going in one by one each server. Is there a scipt I can use/make? Can it be done using policy based management? any idea would be appriciated. Thank you,Dev |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-04-24 : 15:47:44
|
| I think dm_server_services lists information about only SQL Server, Full-Text, and SQL Server Agent services.Powershell is ideally suited for doing what you want to do - i.e., traverse through several remote servers. The name of the Integration Service is MsDtsServ100 (or similar). So a simple Powershell script such as Get-Service | where-object {$_.name -like "MsDtsServ*" } would get you the info about the service (including whether it is running etc.) on each machine. |
 |
|
|
devenoza
Starting Member
14 Posts |
Posted - 2013-04-24 : 17:06:22
|
| I have used powershell and it worked. Thank you Visakh and James! |
|
|
|
|
|
|
How to find out if SSIS is installed or not