Query to see what components or features are installed

  • graymer

    SSC Eights!

    Points: 975

    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

    Hall of Fame

    Points: 3603

    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

    SSCarpal Tunnel

    Points: 4029

    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

    [p]
    [/p]

  • graymer

    SSC Eights!

    Points: 975

    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

    SSCarpal Tunnel

    Points: 4029

    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

    [p]
    [/p]

  • graymer

    SSC Eights!

    Points: 975

    That's where I was at last just never got it ironed out...looked like a good prospect.

  • RichardDouglas

    SSCarpal Tunnel

    Points: 4029

    I've never used it in anger, but I know it's part of Ola Hallengren's backup scripts[/url] which is where I got the idea from.

    Hope this helps,
    Rich

    [p]
    [/p]

  • Richard Gardner-291039

    Hall of Fame

    Points: 3603

    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

    Hall of Fame

    Points: 3603

    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

    SSCarpal Tunnel

    Points: 4029

    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

    [p]
    [/p]

  • Richard Gardner-291039

    Hall of Fame

    Points: 3603

    I think Gabriel's problem might be a little more involved.

    I hate to be all 1980's about this but maybe just picking up and parsing the log file would be the simplest solution if you wanted to automate it....

  • smithp-937849

    Valued Member

    Points: 61

    Found this on the web

    Check what are the SQL Components installed on the Server using T-SQL

    http://pawansingh1431.blogspot.co.uk/2011/02/check-what-are-sql-components-installed.html

    Regards

    Paul

  • graymer

    SSC Eights!

    Points: 975

    Paul,

    Thanks for the share. That was what I was looking for. I've only done a prelim test but it looked pretty good. I'm just wondering how dynamic it is.

    Cheers,

    Gabe

  • sivaram.jangamsetty

    SSC Rookie

    Points: 30

    Thanks a lot

    It solved my problem

    -

    Sivaram J

  • swoozie

    SSCrazy

    Points: 2710

    I am looking for the same thing, however that link is no longer valid. does anyone have another reference or actual answer?

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply