Client Management Suite

 View Only

  • 1.  relevent report of ip address with mac

    Posted Jul 22, 2014 03:53 AM

    Can i able to see the relevent report of ip address with mac?



  • 2.  RE: relevent report of ip address with mac
    Best Answer

    Posted Jul 22, 2014 03:57 AM

    Check it

    https://www-secure.symantec.com/connect/downloads/sql-query-computer-ip-address-and-mac-address-inventory-report

    https://www-secure.symantec.com/connect/forums/help-report-mac-addresses

     

    SQL Query

    ----------- Begin of Code ---------

    SELECT DISTINCT
    V1.[Name] AS 'Computer Name',
    V1.[OS Name],
    V1.[OS Version],
    V1.[Domain],
    V1.[IP Address],
    V1.[MAC Address]
    FROM vComputer V1
    JOIN Inv_AeX_AC_Identification ID     
    ON V1.GUID = ID._ResourceGUID
    AND V1.[Domain]=ID.[Domain]

    Order by V1.[Name]

    ----------- End of Code ---------