SQL Query To Count Installed Resources By Site

 

This SQL query will display the count for resources installed on a site.

 

SQL Query:

 

Select Count(SS.ResourceID) Resources,

Sc.SiteCode 'Site Code'

 

From v_RA_System_SMSInstalledSites SS

Join v_Site SC On SS.SMS_Installed_Sites0 = SC.SiteCode

 

Group by Sc.SiteCode

Order By Resources

 

 

 

Published Monday, December 22, 2008 9:38 AM by dhite
Filed under:

Comments

No Comments