Client Management Suite

Anybody have a SQL query to find all the machines still using evaluation nodes in DS 6.9?  I still have 11 of them hiding among the 11,000+ clients in our DS console.  I'd like to just run a quick SQL query to find them if possible.  Searching through all the groups and clients in the DS console is a bit difficult.

After thinking about this for a minute, I finally realized I can just filter out All Computers in the console by "Status" and find all of the machines still showing they have trial licenses.

Well, that got me some of them but not all of them.  Still looking for 8 machines showing they have evaluation nodes.  I have the console set to automatically replace expired licenses, but these 8 are just not cooperating.  If anybody has any idea how I can locate them SQL query or otherwise, I'd appreciate it.  Trying to get our console cleaned up a little bit since we have so many machines.

You can try this:

SELECT [Name]
  FROM [computer]
 WHERE [limited_license]=1

I can't test it myself, but I seem to remember that this is how temporary licenses were recorded.

Spot on.  That's exactly what I needed.  Found the 8 machines I was missing.  Thank you.