NuRoN Consulting, INC.

Blog > SQL Tools > Databases > Util > Functions > FS.GetVolumeInfo_CLR

Dependencies for Assembly (CLR) table-valued function: Util.FS.GetVolumeInfo_CLR

ReferencingFQN	ReferencingType	ReferencedFQN	ReferencedType	Depth	RedHierarchy
Util.FS.GetVolumeInfo_CLR	Assembly (CLR) table-valued function	Util.UtilClr	ASSEMBLY	1	[Util].[UtilClr]

Assembly (CLR) table-valued function: Util.FS.GetVolumeInfo_CLR

CREATE FUNCTION [FS].[GetVolumeInfo_CLR]
()
RETURNS TABLE (
    [Volume] NVARCHAR(128) NULL,
    [Label] NVARCHAR(128) NULL,
    [CapacityGB] NUMERIC(20, 2) NULL,
    [FreeGB] NUMERIC(20, 2) NULL,
    [CapacityMB] NUMERIC(20, 2) NULL,
    [FreeMB] NUMERIC(20, 2) NULL,
    [Capacity] BIGINT NULL,
    [Free] BIGINT NULL,
    [FreePercent] NUMERIC(10, 2) NULL,
    [BootVolume] NVARCHAR(128) NULL,
    [SystemVolume] NVARCHAR(128) NULL,
    [FileSystem] NVARCHAR(128) NULL
)
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [UtilClr].[UtilClr.FileSystemFunctions].[GetVolumeInfo]

Description for Assembly (CLR) table-valued function: Util.FS.GetVolumeInfo_CLR

Todo