Your company's ad could live here and reach over 50,000 people a month!

Share This Post

Total SQL Server Systems Query

See forum post for full details: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/51ead03a-a43d-46df-b0ab-059d9322e432

 

SELECT DISTINCT 
  R.Name0, 
  R.User_Name0, 
  ARP.DisplayName0 AS [Software Name],
  ARP.Version0 AS [Installed Version], 
  IP.IP_Addresses0 AS IPAddress,
--  ARP.TimeStamp AS [Last Time Stamp], 
  ARP.InstallDate0 AS [Software Installed Date]
 FROM
  dbo.v_R_System R
  inner join dbo.v_FullCollectionMembership FCM ON FCM.ResourceID  = R.ResourceID 
  INNER JOIN dbo.v_Add_REMOVE_PROGRAMS ARP ON R.ResourceID = ARP.ResourceID 
  INNER JOIN dbo.v_RA_System_IPAddresses IP ON R.ResourceID = IP.ResourceID
 WHERE     
  (ARP.DisplayName0 LIKE 'Microsoft SQL Server 2008')
  or (ARP.DisplayName0 LIKE 'Microsoft SQL Server 2005')
  or (ARP.DisplayName0 LIKE 'Microsoft SQL Server 2000')
  or (ARP.DisplayName0 LIKE 'Microsoft SQL Server 2008 R2 (64-bit)') 
  AND (FCM.CollectionID IN ('SMS00001')) 


Share This Post

Leave a Reply

Share This Post

Total SQL Server Systems Query

See forum post for full details: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/51ead03a-a43d-46df-b0ab-059d9322e432

 

SELECT DISTINCT 
  R.Name0, 
  R.User_Name0, 
  ARP.DisplayName0 AS [Software Name],
  ARP.Version0 AS [Installed Version], 
  IP.IP_Addresses0 AS IPAddress,
--  ARP.TimeStamp AS [Last Time Stamp], 
  ARP.InstallDate0 AS [Software Installed Date]
 FROM
  dbo.v_R_System R
  inner join dbo.v_FullCollectionMembership FCM ON FCM.ResourceID  = R.ResourceID 
  INNER JOIN dbo.v_Add_REMOVE_PROGRAMS ARP ON R.ResourceID = ARP.ResourceID 
  INNER JOIN dbo.v_RA_System_IPAddresses IP ON R.ResourceID = IP.ResourceID
 WHERE     
  (ARP.DisplayName0 LIKE 'Microsoft SQL Server 2008')
  or (ARP.DisplayName0 LIKE 'Microsoft SQL Server 2005')
  or (ARP.DisplayName0 LIKE 'Microsoft SQL Server 2000')
  or (ARP.DisplayName0 LIKE 'Microsoft SQL Server 2008 R2 (64-bit)') 
  AND (FCM.CollectionID IN ('SMS00001')) 


Share This Post