Total SQL Server Systems Query


  • Hi,

    I need to create Query for Total SQL Server installed systems  as below Query  i tried but below Query add remove program 64 bit list is not showing how to write Query Kindly help.

    I Need all sql servers Versions instlled in add remove program list kindly help

                          dbo.v_R_System.Name0, dbo.v_R_System.User_Name0, dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 AS [Software Name],
                          dbo.v_GS_ADD_REMOVE_PROGRAMS.Version0 AS [Installed Version], dbo.v_RA_System_IPAddresses.IP_Addresses0 AS IPAddress,
                          dbo.v_GS_ADD_REMOVE_PROGRAMS.TimeStamp AS [Last Time Stamp], dbo.v_GS_ADD_REMOVE_PROGRAMS.InstallDate0 AS [Software Installed Date]
    FROM         dbo.v_R_System INNER JOIN
                          dbo.CollectionMembers ON dbo.CollectionMembers.MachineID = dbo.v_R_System.ResourceID INNER JOIN
                          dbo.v_GS_ADD_REMOVE_PROGRAMS ON dbo.v_R_System.ResourceID = dbo.v_GS_ADD_REMOVE_PROGRAMS.ResourceID INNER JOIN
                          dbo.v_RA_System_IPAddresses ON dbo.v_R_System.ResourceID = dbo.v_RA_System_IPAddresses.ResourceID
    WHERE     (dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 LIKE 'Microsoft SQL Server 2008')or (dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 LIKE 'Microsoft SQL Server 2005')or (dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 LIKE 'Microsoft SQL Server 2000')or (dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 LIKE 'Microsoft SQL Server 2008 R2 (64-bit)') AND (dbo.CollectionMembers.SiteID IN ('SMS00001'))


    Monday, March 12, 2012 2:03 PM


  • Try this. I removed the Time Stamp column as it is not needed.

    • Marked as answer by Kiran Navuru Monday, March 12, 2012 5:06 PM
    Monday, March 12, 2012 2:19 PM
  • Hi Kiran,

    Add or Remove has a separate table to save 64-bit application entries, the best way to get the accurate data of both 32-bit and 64-bit data is to use the

    "v_GS_INSTALLED_SOFTWARE" this table contains more accurate data, otherwise join the v_GS_ADD_REMOVE_PROGRAMS_64 in the existing report to get the 64-bit data

    Ur's -> SithaYuvaraj.

    • Marked as answer by Kiran Navuru Monday, March 12, 2012 5:06 PM
    Monday, March 12, 2012 3:34 PM

All replies