Endpoint Protection

 View Only

  • 1.  Details of deployed Unmanaged detectors in SEPM

    Posted Aug 16, 2018 07:40 AM

    Hello All 

    I need to know SEPM way to know list of all unmanaged detectors(UMD) deployed in network. 
    Prefebly using API/DB query to know all details of UMD and match with my network segments if there is any IP segment without UMD. 



  • 2.  RE: Details of deployed Unmanaged detectors in SEPM
    Best Answer

    Posted Aug 16, 2018 07:52 AM

     

    use [sem5]
    SELECT  CL.COMPUTER_NAME AS "Unmanaged Detector"
      , DD.DELETED
      , DD.IP_ADDRESS_TEXT
    FROM V_LAN_DEVICE_DETECTED AS DD
    INNER JOIN SEM_CLIENT AS CL ON DD.COMPUTER_ID = CL.COMPUTER_ID

    reference link: https://www.symantec.com/connect/articles/handy-sql-queries-sepm-v14