Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Query to see what components or features are installed


Query to see what components or features are installed

Author
Message
graymer
graymer
SSC Journeyman
SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)

Group: General Forum Members
Points: 93 Visits: 287
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?
Richard Gardner-291039
Richard Gardner-291039
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 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.
RichardDouglas
RichardDouglas
SSC Eights!
SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)

Group: General Forum Members
Points: 991 Visits: 706
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



graymer
graymer
SSC Journeyman
SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)

Group: General Forum Members
Points: 93 Visits: 287
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.
RichardDouglas
RichardDouglas
SSC Eights!
SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)

Group: General Forum Members
Points: 991 Visits: 706
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



graymer
graymer
SSC Journeyman
SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)

Group: General Forum Members
Points: 93 Visits: 287
That's where I was at last just never got it ironed out...looked like a good prospect.
RichardDouglas
RichardDouglas
SSC Eights!
SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)

Group: General Forum Members
Points: 991 Visits: 706
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



Richard Gardner-291039
Richard Gardner-291039
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 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
Richard Gardner-291039
Richard Gardner-291039
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 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
RichardDouglas
RichardDouglas
SSC Eights!
SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)SSC Eights! (991 reputation)

Group: General Forum Members
Points: 991 Visits: 706
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



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search