How to get size of Database being used by AX ,below job can help you :
static void GetDBSize(Args _args)
{
LoginProperty loginProp;
ODBCConnection conn;
Resultset resultSet, resultSetCount;
Statement statement1, statement2;
str test;
real s;
SysSQLSystemInfo systemInfo = SysSQLSystemInfo::construct();
;
test = strfmt( “SELECT size FROM sys.master_files where name = ‘%1′”,systemInfo.getloginDatabase() );
loginProp = new LoginProperty();
loginProp.setServer(systemInfo.getLoginServer());
loginProp.setDatabase(systemInfo.getloginDatabase());
conn = new ODBCConnection(loginProp);
statement1 = conn.createStatement();
resultSet = statement1.executeQuery(test);
while (resultSet.next())
{
s = str2int(resultSet.getString(1));
s = s*8 /1024;
info(strfmt(“%1 MB”,s));
}
}
static void GetDBSize(Args _args)
{
LoginProperty loginProp;
ODBCConnection conn;
Resultset resultSet, resultSetCount;
Statement statement1, statement2;
str test;
real s;
SysSQLSystemInfo systemInfo = SysSQLSystemInfo::construct();
;
test = strfmt( “SELECT size FROM sys.master_files where name = ‘%1′”,systemInfo.getloginDatabase() );
loginProp = new LoginProperty();
loginProp.setServer(systemInfo.getLoginServer());
loginProp.setDatabase(systemInfo.getloginDatabase());
conn = new ODBCConnection(loginProp);
statement1 = conn.createStatement();
resultSet = statement1.executeQuery(test);
while (resultSet.next())
{
s = str2int(resultSet.getString(1));
s = s*8 /1024;
info(strfmt(“%1 MB”,s));
}
}
No comments:
Post a Comment