report endpoint without an agent

[Toppenberg]

How to create a report of all endpoints that are in "ASSET INVENTORY" that don't have an Cortex XDR agent ?

[aspatil]

Hello @Toppenberg ,

Thanks for reaching out on LiveCommunity!

Unfortunately there is no dataset available for asset inventory.

For more information, please refer to below article:
https://live.paloaltonetworks.com/t5/cortex-xdr-discussions/using-xdr-asset-inventory-and-xql-to-rep...

Hope this helps.

If you feel this has answered your query, please let us know by clicking on "mark this as a Solution".

[Toppenberg]

There is no other way that I can make an report of all the endpoints detected by "Network mapper" that don't have an Cortex XDR agent ?

[aspatil]

Hello @Toppenberg ,

Please refer the live community link shared with you. We have shared the required information.

You can create a correlation rule or query that should identify the assets without XDR agent installed. Dataset you need is "panw_network_mapper_raw", which contain output of Network Mapper scans. You can compare this dataset with "endpoints" dataset mainly with reference to IP address. So basically, first dataset will have complete list of assets (For given IP range in Network Mapper scan) and you can subtract assets from second dataset which are having agent installed on them.

Below is an example query that you can refer and build something according to your use case.

dataset = panw_network_mapper_raw
| filter ip not in (dataset = endpoints | arrayexpand ip_address |fields ip_address )
|fields ip,hostname  

Please refer below document for XQL queries.

https://docs-cortex.paloaltonetworks.com/r/Cortex-XDR/Cortex-XDR-XQL-Language-Reference/Get-Started-...

A

[aspatil]

You can create a correlation rule or query that should identify the assets without XDR agent installed. Dataset you need is "panw_network_mapper_raw", which contain output of Network Mapper scans. You can compare this dataset with "endpoints" dataset mainly with reference to IP address. So basically, first dataset will have complete list of assets (For given IP range in Network Mapper scan) and you can subtract assets from second dataset which are having agent installed on them.

Below is an example query that you can refer and build something according to your use case.

dataset = panw_network_mapper_raw
| filter ip not in (dataset = endpoints | arrayexpand ip_address |fields ip_address )
|fields ip,hostname  

Please refer below document for XQL queries.

https://docs-cortex.paloaltonetworks.com/r/Cortex-XDR/Cortex-XDR-XQL-Language-Reference/Get-Started-...