Is there any way to generate a report according gived ComputerID list?

Reporting
1

(imported topic written by wazty200291)

Because the BESDuplicateRemoval-5.0 cannot list duplicated computers with multi custom property (I use MAC address to compare computers), I wonder is there a way to generate a report according to the computerID list, then I can count computers by other custom properties.

2

(imported comment written by wazty200291)

Is there anyone can help me?

3

(imported comment written by BenKus)

Hi wazty,

So you are asking for a report of which computers are sharing mac addresses?

Try this:

  1. Go to this page in your webreports:

http://servername:port/cgi-bin/besreports/besreports.exe?page=QNA

  1. Enter this relevance (change the property name as necessary):

(it, multiplicity of it) whose (item 1 of it > 1) of unique values of values of results (bes property “mac address”, bes computers)

This will list out each mac address that exists more than once in your BES Console.

Ben

4

(imported comment written by wazty200291)

I want show these results with another BES property named “Location” which generated by IP range, so that I can know how many duplicated MAC addresses in every location, thank you for your help!

5

(imported comment written by BenKus)

Try this:

(it, multiplicity of it) whose (item 1 of it > 0) of unique values of ((values of results (bes property “location”, it), values of results (bes property “mac address”, it) ) of bes computers as string)

Change property names as necessary.

Ben

6

(imported comment written by wazty200291)

It works fine, thank you Ben, you are so brilliant! :slight_smile: