This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Two Custom Pollers - need to join into one table

hi, i have two custom pollers, one pulls a group of table headers from the multifunction copier/printer/scanner/fax/monstrosity, the other poller pulls the actual values. i'd like to join them into one table..

is there an easy way to do this?

poller one returns this:

prtMarkerSuppliesDescription - LabelprtMarkerSuppliesDescription
1.1Toner (Cyan)
1.2Toner (Magenta)
1.3Toner (Yellow)
1.4Toner (Black)
1.5Drum Cartridge (Cyan)
1.6Developer Cartridge (Cyan)
1.7Drum Cartridge (Magenta)
1.8Developer Cartridge (Magenta)
1.9Drum Cartridge (Yellow)
1.1Developer Cartridge (Yellow)
1.11Drum Cartridge (Black)
1.12Developer Cartridge (Black)
1.13Waste Toner Box
1.14Fusing Unit
1.15Image Transfer Belt Unit
1.16Transfer Roller Unit
1.17Ozone Filter
1.18Toner Filter
1.19Staple Cartridge

poller 2 returns this.

prtMarkerSuppliesLevel - LabelprtMarkerSuppliesLevel
1.199
1.2100
1.3100
1.499
1.599
1.699
1.799
1.899
1.999
1.199
1.1199
1.1299
1.13-3
1.1499
1.1599
1.1699
1.1799
1.1899
1.19-3

and i would like it to look display like this:

SupplyValue
Toner (Cyan)99
Toner (Magenta)100
Toner (Yellow)100
Toner (Black)99
(you get the idea)

any suggestions would be greatly appreciated.

  • If both pollers are from the same table, you should be able to select one OID as the polled value and the second as Label. Right click the custom poller in UnDP application and select Label. On edit page select the option "Use labels from a table column".

    Or you can edit the table resource on web and select more pollers for the same table resource.

  • I would also like to do something similar.  I most definitely want to use custom SQL report rather than the default custom poller resource though.