ossiejhmoore

Content Server : Query to View Distributed Agent Counts

Dec 23rd, 2014
441
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.37 KB | None | 0 0
  1. SELECT *
  2. FROM (SELECT COUNT(*) workerpackages FROM workerpackages)
  3. ,( SELECT COUNT(*) workerqueuepending FROM workerqueuepending)
  4. , (SELECT COUNT(*) workerqueue FROM workerqueue)
  5. , (SELECT COUNT(*) workerqueuecurrent FROM workerqueuecurrent)
  6. , (SELECT COUNT(*) workerqueuechildren FROM workerqueuechildren)
  7. , (SELECT COUNT(*) workerqueuecomplete FROM workerqueuecomplete);
Advertisement
Add Comment
Please, Sign In to add comment