SQL/SMP: List Package Servers

AeX_ListPackageServers.ps1

$PackageServers = Get-SMPSQLData -Instances "SQL0040" -Database "Symantec_CMDB_TNKNXSMP01" -CommandText 
"SELECT [FQDN] = [conn2].[FQDN], [Name] = UPPER([conn1].[Name]), [IP Address] = [conn1].[IP Address] FROM [vComputer] 
[conn1] LEFT JOIN [Inv_AeX_AC_Identification] [conn2] ON [conn1].[Guid] = [conn2].[_ResourceGuid] WHERE [conn1]. 
[Guid] IN (SELECT DISTINCT [PkgSvrId] FROM [SWDPackageServer]) ORDER BY [conn1].[Name]"

AeX_ListPackageServers.sql

SELECT
  [FQDN] = [conn2]. [FQDN]
  , [Name] = UPPER( [conn1].[Name] )
  , [IP Address] = [conn1].[IP Address]
FROM
  [vComputer] [conn1]
  LEFT JOIN [Inv_AeX_AC_Identification] [conn2] ON [conn1]. [Guid] = [conn2].[_ResourceGuid]
WHERE [conn1]. [Guid] IN (
  SELECT DISTINCT [PkgSvrId]
  FROM [SWDPackageServer]
  )
ORDER BY
[conn1].[Name]