I need a query that shows all of the nodes that CAN have AppInsight for IIS (or any AppInsight application) applied.

spoofffed

Hello!

I need help finding a table that would show all of the nodes that can have AppInsght for IIS applied to query from.  The data has to be in database somewhere since it is in the list resources.  SWQL or SQL would work, I will use the query for a script that will auto add a SAM application.  

Seashore

The data in "list resources" are not long term stored in the database. So no, the data you are after is not in the database. 

If you do a discovery of your servers, that result though is stored in the database.