Instead of explicitly putting each field in a query, is there a way to get all fields returned with a wildcard or such?
I'm currently doing something like this:
https://myserver/remote/core.executeQuery?target=RSDDetectedSystems&:output=terse&select=(select RSDDetectedSystems.FriendlyName RSDDetectedSystems.IPV4)
I don't have much experience with using execute Query in the webAPI...however, I do know that wildcards are not supported by the API. This could be different for that particular command but the best way to find out would be to test it.
I just tested the following URL:
This was the response:
Error 0 :
Invalid column name:*
If that is not what you meant in your question please clarify. Otherwise, it does not look like this will work.
Correct. Typically I would do a "select * from mytable" and return all records. I want to do the same thing on the EPO for each table. Otherwise I'll have to resort to direct database access. Thanks for any help.