text: select * from DriveInfo;
  --script to retrieve the values in MB from PS Script output
  SELECT RTRIM(LTRIM(SUBSTRING(line,1,CHARINDEX('|',line) -1))) AS drivename
        ,ROUND(CAST(RTRIM(LTRIM(SUBSTRING(line,CHARINDEX('|',line)+1,
        (CHARINDEX('%',line) -1)-CHARINDEX('|',line)) )) as Float),0) AS 'capacity(MB)'
        ,ROUND(CAST(RTRIM(LTRIM(SUBSTRING(line,CHARINDEX('%',line)+1,
        (CHARINDEX('*',line) -1)-CHARINDEX('%',line)) )) as Float),0) AS 'freespace(MB)'
        ,ROUND(CAST(RTRIM(LTRIM(SUBSTRING(line,CHARINDEX('|',line)+1,
        (CHARINDEX('%',line) -1)-CHARINDEX('|',line)) )) as Float)/1024,0) as 'capacity(GB)'
        ,ROUND(CAST(RTRIM(LTRIM(SUBSTRING(line,CHARINDEX('%',line)+1,
        (CHARINDEX('*',line) -1)-CHARINDEX('%',line)) )) as Float) /1024 ,0)as 'freespace(GB)'
  FROM DriveInfo
  WHERE line LIKE '[A-Z][:]%'
  ORDER BY drivename
  