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»»

Query to see what components or features are installed Expand / Collapse
Author
Message
Posted Tuesday, February 23, 2010 10:44 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 7, 2012 6:03 AM
Points: 93, Visits: 266
I've been trying to find a simple way to query to see what components and features are installed on my servers but it doesn't seem that simple. I'm looking for something that will identify components and features for a security audit and I'd prefer not to have to manually looking up each component to see if they're installed. Does anyone have anything hand that can accomplish this?
Post #871318
Posted Thursday, May 13, 2010 8:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 17, 2014 3:29 AM
Points: 238, Visits: 421
Hi Gabriel,

Did you find a way to do this? I'm in the same situation.

If you haven't let me know anyway, I'll tell you what I find out.
Post #921280
Posted Thursday, May 13, 2010 8:22 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:20 AM
Points: 974, Visits: 691
If you query sys.configurations this will tell you if a number of features have been enabled. You will also be able to tell if some of the default settings have been changed.

Take a look,
Rich


Hope this helps,
Rich



Post #921303
Posted Thursday, May 13, 2010 8:48 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 7, 2012 6:03 AM
Points: 93, Visits: 266
rdouglas66

sys.configurations does have some really good stuff in it but not what I was originally looking for. I'm trying to find somehting more like being able to query if the SSIS component is installed or BI Dev. Studio.


Rich I haven't had any luck on finding a way to query that, just had to do it the old fashion way. Look around. I haven't got back to it yet.

Good luck, cheers.
Post #921346
Posted Thursday, May 13, 2010 8:56 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:20 AM
Points: 974, Visits: 691
If you are looking for programs that are installed then you will need to query the registry do a google on xp_instance_regread.

Rich


Hope this helps,
Rich



Post #921358
Posted Thursday, May 13, 2010 9:02 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 7, 2012 6:03 AM
Points: 93, Visits: 266
That's where I was at last just never got it ironed out...looked like a good prospect.
Post #921367
Posted Thursday, May 13, 2010 9:20 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:20 AM
Points: 974, Visits: 691
I've never used it in anger, but I know it's part of Ola Hallengren's backup scripts which is where I got the idea from.

Hope this helps,
Rich



Post #921397
Posted Friday, May 14, 2010 2:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 17, 2014 3:29 AM
Points: 238, Visits: 421
Thanks for the answers Rich - I have had a look and I guess if I was scripting an enterprise solution it might be the best answer, but in truth I'd probably have to spend all day installing and uninstalling on a test server to work out which reg keys to use and I really just need to duplicate an installation.

This article looks very promising, it talks about an installation log file and something called Microsoft MAP, haven't looked at either of them yet but I'll report back.

http://www.sqldev.org/sql-server-setup--upgrade/what-is-the-best-way-to-determine-whether-individual-sql-server-2008-components-are-installed-92335.shtml
Post #921838
Posted Friday, May 14, 2010 6:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 17, 2014 3:29 AM
Points: 238, Visits: 421
Well that was useful, in truth the first thing I tried gave me the answer I need, so no need to go any further...

For reference this log file is it:

<drive>:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\LOG\Summary.txt

Here's the contents:

Overall summary:
Final result: Passed
Exit code (Decimal): 0
Exit message: Passed
Start time: 2010-03-30 09:59:51
End time: 2010-03-30 10:04:37
Requested action: Patch

Instance MSSQLSERVER overall summary:
Final result: Passed
Exit code (Decimal): 0
Exit message: Passed
Start time: 2010-03-30 10:01:33
End time: 2010-03-30 10:04:33
Requested action: Patch

Machine Properties:
Machine name:
Machine processor count: 1
OS version: Windows Server 2008
OS service pack:
OS region: Österreich
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Database Engine Services 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Full-Text Search 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Management Tools - Basic 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Management Tools - Complete 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Client Tools Connectivity 1033 Standard Edition 10.0.1600.22 No
Sql Server 2008 Client Tools Backwards Compatibility 1033 Standard Edition 10.0.1600.22 No

Package properties:
Description: SQL Server Database Services 2008
SQLProductFamilyCode: {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 1
KBArticle: KB968369
KBArticleHyperlink: http://support.microsoft.com/?kbid=968369
PatchType: SP
AssociateHotfixBuild: 0
Platform: x64
PatchLevel: 10.1.2531.0
ProductVersion: 10.0.1600.22
GDRReservedRange: 10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0
PackageName: SQLServer2008-KB968369-x64.exe
Installation location: e:\80c12d41dfb3c7d539\x64\setup\

Updated product edition:
Instance Edition
MSSQLSERVER STANDARD

User Input Settings:
ACTION: Patch
ALLINSTANCES: False
CLUSTERPASSIVE: False
CONFIGURATIONFILE:
HELP: False
INDICATEPROGRESS: False
INSTANCENAME: <empty>
QUIET: False
QUIETSIMPLE: False
X86: False
Post #921993
Posted Friday, May 14, 2010 7:04 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:20 AM
Points: 974, Visits: 691
MAPs is very useful, I used it at my current position when I joined to see how big the estate was, one thing to take note of is that it installs a named instance of SQLExpress called MAPS

I would have mentioned it but you said that you wanted it within a query and so wrongly assumed you were wrapping it inside another solution.


Hope this helps,
Rich



Post #921996
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse