New Challenge - Use ICON to find boxes missing agents S1/IDR

A new challenge for the minds of this comm :cowboy_hat_face:

I can export all the agents from S1 and IDR but manually checking which machine has one but not the other is something I’d rather not do in 10 lifetimes. Ideas?

Do you have a list of each set?

If so, you might be able to use some of the actions in Type Converter to get the difference between the lists. Check out the array functions here:

If you are also using InsightVM to scan your network you can get a list of assets without agent “built-in”:

image

I have 2 csvs to use one from each tool.

What is the best way to do this?

trigger on new email with a csv → convert to json → ? → list diff action in TC plugin

struggling on the json to 2 string arrays part…

You can get the CSV data out with this:
CSV:

To get the files in you could use one of these, just depends on what tools you want to use:
FTP:

Get URL:

Google Drive:

since I have 2 columns in my csv containing just hostnames this is what I get from csv to json

[
{
“Endpoint Name”: “IDR_1”,
“Hostname”: “S1_1”
},
{
“Endpoint Name”: “IDR_2”,
“Hostname”: “S1_2”
}
[

You should be able to do a loop step now to consolidate that into a list.

the json object has 40 K lines :face_with_head_bandage:

It should still work fairly quickly provided you’re not doing anything with the data in the loop. You can also use a python step to consolidate that quickly too.