Query Exchange

 View Only
Expand all | Collapse all

Detect Static IP

  • 1.  Detect Static IP

    Broadcom Employee
    Posted Dec 22, 2022 09:01 PM

    Description: This query looks for any system that has a static IP set.

    What The Data Shows: The data shows if the endpoint has had it IP manually set, which could cause networking issues

    SQL:

    SELECT interface, address, type FROM interface_addresses WHERE type = 'manual'

     


    #Windows
    #Compliance
    #HelpDeskOperations
    #CarbonBlack
    #Linux
    #ITHygiene


  • 2.  RE: Detect Static IP

    Broadcom Employee
    Posted Dec 23, 2022 06:58 PM

     thanks for your contribution!