Kusto query to get the below details CSV format usedIpAddress connected or isolated to which backend (connected device) PrivateIPv4address , attached to ,attached type

Kusto query to get the below details CSV format

Monalisa 60

Kusto query to get the below details CSV format

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

PRADEEPCHEEKATLA 90,241 Reputation points

2024-06-10T06:51:42.8266667+00:00

@Monalisa - Thanks for the question and using MS Q&A platform.

Are you using Kusto queries in Azure Data Explorer or Azure Monitor or some other Azure Service?

Looking forward for your response.
PRADEEPCHEEKATLA 90,241 Reputation points

2024-06-12T05:52:01.2233333+00:00

@Monalisa - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Monalisa 60 Reputation points

2024-06-18T11:02:44.77+00:00

Hi @PRADEEPCHEEKATLA Sorry for the late reply. We are using Azure Data Explorer
PRADEEPCHEEKATLA 90,241 Reputation points

2024-06-19T03:56:25.03+00:00

@Monalisa - Just checking in to see if the below answer provided by @Rahul Gosavi helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Rahul Gosavi 166

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()

Share via

Kusto query to get the below details CSV format

1 answer

Your answer