SQL Query :
Select
SD.Name0 'Machine Name',
SD.User_Name0 'User Name',
LD.FreeSpace0 'Free Space'
From v_R_System SD
Join v_Gs_Logical_Disk LD on SD.ResourceId = LD.ResourceId
Where LD.DeviceId0 = 'C:'
And LD.FreeSpace0 < 1024
And SD.Client0 = 1
Tag : Web Report
Select
SD.Name0 'Machine Name',
SD.User_Name0 'User Name',
LD.FreeSpace0 'Free Space'
From v_R_System SD
Join v_Gs_Logical_Disk LD on SD.ResourceId = LD.ResourceId
Where LD.DeviceId0 = 'C:'
And LD.FreeSpace0 < 1024
And SD.Client0 = 1
Tag : Web Report
No comments:
Post a Comment