periicles

Hi everyone,

I need to create a report for Pcanywhere installed in our pc environment, the current defaul report specify host name, but what I need is to include the ip address of the host too....

environment: altiris v7

this is a copy of the default sql

...........start script................

SELECT DISTINCT
i._ResourceGuid [Guid],
i.Name [Host Machine (Target)],
ISNULL(p.[pcA_Version_Major],'') +
CASE WHEN ISNULL(p.[pcA_Version_Minor],'') = '' THEN '' ELSE '.'+ p.[pcA_Version_Minor] END +
CASE WHEN ISNULL(p.[pcA_Version_Patch],'') = '' THEN '' ELSE '.'+ p.[pcA_Version_Patch] END +
CASE WHEN ISNULL(p.[pcA_Version_Build_Number],'') = '' THEN '' ELSE '.'+ p.[pcA_Version_Build_Number] END AS [pcAnywhere Host],
i.[OS Name] [OS]
FROM dbo.Inv_Symantec_pcAnywhere_Host_State hs
JOIN Inv_Symantec_pcAnywhere_Product_Info p
ON p._ResourceGuid = hs._ResourceGuid
JOIN Inv_AeX_AC_Identification i
ON i._ResourceGuid=p._ResourceGuid
JOIN CollectionMembership cm
ON i._ResourceGuid = cm.ResourceGuid
JOIN vCollection c
ON cm.CollectionGuid = c.Guid
WHERE upper(c.Guid) LIKE upper('%Collection%')
ORDER BY i.Name,
ISNULL(p.[pcA_Version_Major],'') +
CASE WHEN ISNULL(p.[pcA_Version_Minor],'') = '' THEN '' ELSE '.'+ p.[pcA_Version_Minor] END +
CASE WHEN ISNULL(p.[pcA_Version_Patch],'') = '' THEN '' ELSE '.'+ p.[pcA_Version_Patch] END +
CASE WHEN ISNULL(p.[pcA_Version_Build_Number],'') = '' THEN '' ELSE '.'+ p.[pcA_Version_Build_Number] END,
i.[OS Name]

...........end of report...........


If you know how to add extra lines to include the ip address on this report, I will really appreciate your help

Thanks