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

    SQL query filter

    khanwasimit

      Hi,

       

      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