All Database Sizes in SQL SERVER

DB sizes

 SELECT d.name, (ROUND(SUM(cast(mf.size as bigint)) * 8 / 1024, 0))/1024 Size_GB FROM sys.master_files mf INNER JOIN sys.databases d ON d.database_id = mf.database_id WHERE d.database_id > 4 -- Skip system databases GROUP BY d.name ORDER BY 2 desc

Adding a Server to Central Management Server(CMS)

-- to know the group name

--- to know the server group. 

select * from msdb.dbo.sysmanagement_shared_server_groups_internal ORDER BY 1 desc 

where name like 'groupname%'

select SERVERNAME  from SERVERLIST_PATCH

-- adding Servers into CMS 

SET NOCOUNT ON  

  declare @name sysname declare @sql nvarchar(max)  

  declare db_cursor cursor for select  distinct(   a.servername + ','  +convert(varchar(50),a.PortNumber))   FROM  tablename a

--order by a.tablename asc 

   open db_cursor 

    fetch next from db_cursor into @name 

--declare @cnt int =0

----set @cnt =0

    while @@FETCH_STATUS = 0 

    begin     

    Set @sql = '

DECLARE @CurrentServerGroup INT

INSERT INTO msdb.dbo.sysmanagement_shared_registered_servers_internal

  (Server_Group_ID, name, Server_name, description, Server_Type)

  SELECT 6'+','''+ LTRIM(RTRIM(@name)) +''''+','''+  LTRIM(RTRIM(@name)) +''''+','''+  LTRIM(RTRIM(@name)) +''''+','+ '0'

    print @sql     

execute(@sql)

     fetch next from db_cursor into @name 

--print @cnt

end  

     close db_cursor 

     deallocate db_cursor