sql获取链接服务器磁盘占用信息(二)
trim(left(LTRIM(size),1)) as drive,
cast(replace(replace(replace(ltrim(RIGHT(rtrim(size),LEN(size)-2)),char(9),''''),char(10),''''),CHAR(13),'''') as bigint)/1024/1024 as [totalsizeMB]
from #totaldrives_temp
where size not like ''%DeviceID Size%'' and LEN(size) not IN (0,1)
) AS t
inner join #useddrives_temp f on t.drive=f.drive '
begin try
exec (@str1)
end try
begin catch
print N'错误'
--insert into #fdtest2 values(@serverNameDesc,0,0)
end catch
fetch next from @allLinkServer into @linkServer,@serverNameDesc
end
close @allLinkServer
deallocate @allLinkServer
select * from #alldriveres_temp