VLOOKUP for you to join table

Just now try to gather all the DB size from DB and SharePoint CA, to join the data from DB and sharepoint at excel i use the VLOOKUP :

From CA Content DB

Database Name	Database Status	Current Number of Sites	Site Level Warning	Maximum Number of Sites
Contend_DB1	Started	4	8	10

From SQL Query > use this command at SQL query exec sp_databases

DB name	Size	MB	GB
Contend_DB1	165860032	161972.69	158.1764526

Combine the data in one excel sheer : DB size GB with following VLOOKUP
 =VLOOKUP(A2(this is the data you want to match), [the rage of the SQL query data],4(which role want to return),FALSE)

Database Name	DB Size GB	Database Status	Current Number of Sites	Site Level Warning	Maximum Number of Sites
Contend_DB1	158.1764526	Started	4	8	10