ADSM-L

Re: [ADSM-L] SQL command to query Sessions with MediaWait or Idle

2008-12-05 08:31:37
Subject: Re: [ADSM-L] SQL command to query Sessions with MediaWait or Idle
From: David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 5 Dec 2008 08:29:12 -0500
>>select avg(wait_seconds) from sessions where state='MediaW'<<

Is there a join that would give an average per library or devclass or domain?

David