SQL Report - CMS7.1 - Add IP address to report.
Hello. This is a query to show computers with the Symantec Management Agent.
The SQL query is below, I would like to add a IP address columb to this.
Please can someone assist. Thanks.
vc.Name, pu.[User], vc.[OS Name], vc.[System Type], vc.IsManaged, vc.CreatedDate
Inv_AeX_AC_Primary_User pu ON pu._ResourceGuid = vc.Guid