SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

April 2010 - Posts

  • Find servers with SQL 2k and 2k5

    SELECT DISTINCT
        FCM.Name,
        OPSYS.Caption0,
        OPSYS.Version0,
        ARP.Displayname0
    FROM
        dbo.v_FullCollectionMembership FCM
        JOIN dbo.v_GS_OPERATING_SYSTEM OPSYS on FCM.ResourceID = OPSYS.ResourceID
        join dbo.v_GS_SYSTEM SYS on SYS.ResourceID = FCM.ResourceID
        Join dbo.v_Add_Remove_Programs ARP on ARP.ResourceID = FCM.ResourceID
    WHERE
        SYS.SystemRole0 = 'Server'
        and ARP.Displayname0 in ('Microsoft SQL Server 2005','Microsoft SQL Server 2000') 

    Digg This

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems