Zurück
-
Titel
Is there a way to get the space used in the topology_property_value table from the script console? A SQL Server repository is being used. -
Beschreibung
Is there a way to get the space used in the topology_property_value table from the script console? A SQL Server repository is being used. -
Lösung
The following script can be used to get the space available for the topology_property_value table in a SQL Server repository:
import groovy.sql.Sql;
import com.quest.nitro.service.util.JDBCHelper;
msg = new StringBuilder();
try{
sql = new Sql(JDBCHelper.getDataSource());
msg.append("topology_property_value Table Count: \n")
msg.append(sql.rows("exec sp_spaceused 'topology_property_value'"));
}catch (Exception ex){
msg.append("Exception"+ex);
}
return msg.toString();
Output like the following will be returned:
topology_property_value Table Count:
#160;[{name=topology_property_value, rows=3464 , reserved=1728 KB, data=560 KB, index_size=984 KB, unused=184 KB}