IT Management Suite

Hi, All.

I would like some help regarding modifying the reports to include IP address in the column next to the Computer Name. Any way I can achieve this? I am not well-versed in SQL btw so some help in this would be greatly appreciated.

 

add ip information in altiris agent report (raw sql) https://www.symantec.com/connect/forums/add-ip-information-altiris-agent-report-raw-sql SELECT DISTINCT vc.Guid AS '_ItemGuid', vc.Name, vc.Domain, vc.[IP Address], vc.[OS Name], vc.Guid AS [Machine Guid], vc.Server FROM Inv_AeX_AC_Client_Agent ca INNER JOIN vComputer vc ON vc.Guid = ca._ResourceGuid WHERE vc.[OS Name] LIKE '%Windows%' AND vc.IsManaged = 1 AND (UPPER(ca.[Agent Name]) IN ('ALTIRIS EXPRESS NS CLIENT', 'ALTIRIS AGENT')) So if your Report is using vComputer that has a field called [IP Address]

Hi, Alex.

Thanks for the code. May I know if this can be used together in Patch Management reports such as Compliance by Computers? I would like to display the Computer's IP address in a column next to the Computer Name.

I’m sure “Compliance by Computers” uses vComputer, so yes, just check what it’s called and if it has an alias of vc then the vc.[IP Address] is fine to add.