However - if someone knows how to extract just the info I want then I'm open to ideas / advice / etc ...
Not sure if this will help as I figured it out with the sql..
I loaded a poller and changed then names on the fields pulled and then used this sql to get the unique elements I was interested in.
select * from (
select n.sysname, n.caption, n.ip_address, cp.uniquename xx, cps.rowid unit, cps.status
from nodes n
inner join custompollerassignment cpa on cpa.nodeid=n.nodeid
inner join custompollerstatus cps on cps.custompollerassignmentid = cpa.custompollerassignmentid
inner join custompollers cp on cp.custompollerid = cpa.custompollerid
where n.caption like 'gf%'
pivot( max(status) for xx in ( [serialnumber],[model],[iosversion]) ) as crap
where unit > 0
that actual value for each element is in the cps.status field and the cp.uniquename is the name I assigned in the poller.
I could have used the existing value but it was longer than I wanted.
This did the joins to the custom poller information and created one line (in my case) for each switch that matched the
criteria. Pivot command is way way cool!!!
Ugh - pivot just makes me think of Excel and I don't understand it there either
I really need to find time to start digging in to and learning SWQL / SQL