Duplicate computer report based on serial number

[JasonWalker]

Hi @jgallas,

I think the explanation here may be helpful. In my query, I show both the minimum and maximum of last report times for duplicated computers, you could of course report only one or the other.

Maximum Last Report Time for computers

Oops, forgot to limit it to only “real” computers. Each place we retrieve “BES Computers”, we’ll want to filter to bes computers whose (agent type of it = "Native") The final query, then, would be ( /* Properties of the computer (item 0 of it) with the minimum last report times */ id of item 0 of it, name of item 0 of it, last report time of item 0 of it, /* Properties of the computer (item 0 of it) with the maximum last report times */ id of item 1 of it, name of item 1 of it, last report…