(imported topic written by PSanesi)
Hi everyone,
I’m trying to collect some data from multiple results properties.
Here is a brief example generated with excel connector:
( item 0 of it as string & “$x$” &
item 1 of it as string & "$x$" &
item 2 of it as string )
of (
(if (exists result (item 0 of it, item 1 of it) )
then (values of result (item 0 of it, item 1 of it))
else ("<none>")),
(if (exists result (item 0 of it, item 2 of it) )
then (values of result (item 0 of it, item 2 of it))
else ("<none>")),
(if (exists result (item 0 of it, item 3 of it) )
then (values of result (item 0 of it, item 3 of it))
else ("<none>")))
of (
bes computers,
bes property "Computer Name",
bes property "Network",
bes property "Subnet Address")
The problem here is that for every Network Adapter and every Subnet, the query will return a row.
E.g.: A wks with two Network Adapter ( and two Subnets), will generate 4 rows. I’m trying to achieve only rows whose value of Subnet is included in Network property (this property include Network Type, MAC, Gateway Address, IP, Netmask). A sort of pairing from the results of the two properties.
I need an output like this:
ComputerName - Network Type (preceding text of first “|”) - Subnet
with only the Network Type pertaining to the Subnet.
Is it this an achievable task (…and I don’t see the solution)?
Thanks everyone for possible suggestions!
Bye, Paolo