In case anyone finds it useful. This code updates a table with the db sizes
of all db's on the server.
Thanks for your help putting this together :-)
<CFLOCK Name="ServiceFactory" Type="Exclusive" TimeOut="10">
<CFSET Factory = CreateObject("java", "coldfusion.server.ServiceFactory")>
<CFSET Service = Factory.getDataSourceService()> <CFSET DataSources =
Service.DataSources>
<CFSET Datasources = StructKeyArray(Datasources)>
<CFSET Temp = ArraySort(Datasources, "textnocase", "asc")>
</CFLOCK>
<select name="datasource">
<CFOUTPUT>
<CFLOOP From="1" To="#ArrayLen(Datasources)#" Index="i"> <option
value="#Datasources[i]#">#Datasources[i]#</option>
</CFLOOP>
</CFOUTPUT> </select>
<CFLOOP From="1" To="#ArrayLen(Datasources)#" Index="i">
<cfstoredproc procedure="sp_helpdb" datasource="#application.dsn#">
<cfprocparam
cfsqltype="CF_SQL_VARCHAR" dbvarname="Name" type="In"
value="#Datasources[i]#">
<cfprocresult name="MyResult">
</cfstoredproc>
<cfoutput query="MyResult">
<cfset DBsize2 = #val(listgetat(Myresult.DB_Size, 1, " "))#>
<Cfquery datasource="#application.dsn#">
update tbl_sites
set DBsize = #dbsize2#
where DBname = '#Datasources[i]#'
</Cfquery>
</cfoutput>
<cfoutput>
</cfoutput>
</CFLOOP>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301893
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
