Get Database size using X++

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));
}
}