2 Replies Latest reply on Mar 31, 2016 11:33 AM by khanwasimit

    SQL query filter




      Can you please help of SQL filer for Top 10 Volumes by Disk Space Used ,


      below syntax I check below syntext work but need to filter out Node name start from " 'SVRE-NL" but it not working,


      can someone help on filer out the node caption part, please


      (OS like '%Windows%' OR OS like '%ESX%') AND Server_Managed_by like 'Windows' AND Volumes.VolumeType='Fixed Disk'  AND (Nodes.Caption like'SVRW-NL-*'OR Nodes.Caption like 'SVRE-NL-*') and VolumePercentUsed >= Percentage_Threshold