Need Db audit info query in SQL server for these columns : Good day

will  you please provide a single  query in SQL Server to fetch Audit information of databases and tables in the server as below

Database audit should include records count in each table, tables size,  databases size and drives size  in the server including Server name 

Thanks in advance

