Kusto query to get the below details CSV format

Question

Kusto query to get the below details CSV format

1. usedIpAddress connected or isolated to which backend (connected device)
2. PrivateIPv4address , attached to ,attached type

Answer 1

Assuming you have a table that stores the network and device information, here is an example query. You'll need to adjust the table and column names according to your actual schema.

// Sample table: DeviceConnections
// Columns: usedIpAddress, backendDevice, PrivateIPv4address, attachedTo, attachedType

DeviceConnections
| project usedIpAddress, backendDevice, PrivateIPv4address, attachedTo, attachedType
| project
    usedIpAddress,
    backendDevice,
    PrivateIPv4address,
    attachedTo,
    attachedType
| project-rename
    Used_IP_Address = usedIpAddress,
    Backend_Connection = backendDevice,
    Private_IPv4_Address = PrivateIPv4address,
    Attached_To = attachedTo,
    Attached_Type = attachedType
| serialize
| evaluate print_csv()