Wednesday, November 17, 2010

SMS report to track SMS site systems with low disk space

select SUBSTRING(Sitesystem, CHARINDEX('\\', Sitesystem) + 2, CHARINDEX('"]', Sitesystem) - CHARINDEX('\\',
Sitesystem) - 3 ) AS siteSystem,
SiteObject,Sitecode,Role,BytesTotal/1024 as [Total disk space(MB)],BytesFree/1024 as [Free Space(MB)],
PercentFree as 'PercentFreespace',Downsince
from v_SiteSystemSummarizer where Role not like 'SMS SQL Server' and Percentfree <10

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home