Tuesday, 14 February 2012

List of Workstations with microsoft .netframework less than 2.0

SELECT DISTINCT
                      dbo.v_R_System.Netbios_Name0, dbo.v_R_System.Operating_System_Name_and0, dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0,
                      dbo.v_GS_ADD_REMOVE_PROGRAMS.Version0
FROM         dbo.v_R_System INNER JOIN
                      dbo.v_GS_ADD_REMOVE_PROGRAMS ON dbo.v_R_System.ResourceID = dbo.v_GS_ADD_REMOVE_PROGRAMS.ResourceID
WHERE     (dbo.v_R_System.Operating_System_Name_and0 LIKE '%workstation%') AND
                      (dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 LIKE 'Microsoft .NET Framework%') AND (dbo.v_GS_ADD_REMOVE_PROGRAMS.Version0 < '2.0%')

1 comment:

  1. very informative blog and useful article thank you for sharing with us , keep posting learn

    more about Dot net
    .NET Online Training Hyderabad

    ReplyDelete