I’m just learning my way around NRQL but I don’t know how to go about formulating a query. I’ve read the docs, I know SQL, where I’m having a problem is knowing WHAT to query. As in SELECT * FROM ? Where can I find a list of the possible FROMs?
The specific issue: I currently have 2 servers with apps running that are being monitored. If I do SELECT * from SystemSample LIMIT 1, I only get a response for one server. I need LIMIT 2 to see both. Bigger limits just give me more responses for each server.
I’m eventually going to have many more servers, and that will be an unknown and likely a changing number. What I want to do is either 1) get a list of servers, then get the responses for each server, or 2) get ONLY the most recent entry for all servers.