SQL Server PBM

  • I am trying to setup policy to check disk allocation size, I was hoping it will do the trick but apparently not. is this something wrong with the condition.

    IsNull(ExecuteWql('Numeric', 'root\CIMV2', 'select BlockSize FROM Win32_Volume WHERE FileSystem="NTFS" and DriveLetter ="E"'), 0)

  • I was missing : with the driveletter

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply