Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

SQL query to find evaluation nodes

Created: 11 Apr 2013 • Updated: 15 Apr 2013 | 4 comments
This issue has been solved. See solution.

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.

Operating Systems:

Comments 4 CommentsJump to latest comment

jeremyboger's picture

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.

jeremyboger's picture

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.

The Gaffer's picture

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.

SOLUTION
jeremyboger's picture

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