(imported topic written by zpt8mjs)
Greetings,
I have a process that populates the client setting _BESClient_Register_Affiliation_SeekList with values based on subnet address. If the value cannot be determined then I set it to a value of “Error”
I’m trying to generate a report on all subnets where there is a device with a SeekList value of Error. I need to get the number of device on each subnet reporting error so that I can prioritize. Came up with this so far . . .
(
item 1 of it,
multiplicity of (item 1 of it)
)
of
(
values whose (it as string contains "_BESClient_Register_Affiliation_SeekList=Error") of results (item 0 of it, item 1 of it),
unique values of (values of results (item 0 of it, item 2 of it) )
)
of
(
bes computers,
bes property "Client Settings" ,
bes property "Subnet Address"
)
This returns a non unique list of subnets and the count is always 1. It looks something like this:
10.244.212.0, 1
10.164.248.0, 1
10.114.56.0, 1
10.55.155.0, 1
10.121.102.0, 1
10.77.232.0, 1
10.65.188.0, 1
10.8.96.0, 1
10.77.232.0, 1
10.246.37.0, 1
10.8.96.0, 1
10.224.136.0, 1
10.77.168.0, 1
10.135.16.0, 1
10.132.234.0, 1
10.224.45.0, 1
10.224.60.0, 1
10.132.226.0, 1
10.132.234.0, 1
10.132.226.0, 1
10.132.232.0, 1
10.224.136.0, 1
What I’d like to see is :
10.114.56.0, 1
10.121.102.0, 1
10.132.232.0, 1
10.135.16.0, 1
10.164.248.0, 1
10.224.45.0, 1
10.224.60.0, 1
10.244.212.0, 1
10.246.37.0, 1
10.55.155.0, 1
10.65.188.0, 1
10.77.168.0, 1
10.132.226.0, 2
10.132.234.0, 2
10.224.136.0, 2
10.77.232.0, 2
10.8.96.0, 2
The numbers counts are greater in production, I just wanted to show what I was looking for