I needed to create a report that did an inventory of several pollers that were assigned to many of my devices. I created the SQL (not SWQL) query below. Here are the steps on how to set it up. Create your custom pollers and write down the names. Add the names into the query below. They need to be added in a couple places. Once your done create a new report, chose table, then on the next screen choose advanced and insert this SQL. Choose SQL, not SWQL. finish creating your report and then your done.
I attached the query, it looked horrible when I pasted it here