Thursday 24 December 2015

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

 }

No comments:

Post a Comment