Im trying to use PBM a bit, but came into a few problems.
Setting up a Min Memory setting policy, trying to find any servers that haven't been configured
Server Configurations @MinServerMemory > 0
But using this on a server with no configured min mem it returns 16???
WHERE [name] = 'min server memory (MB)'
I return 0.
Any ideas why?
I tried to use ExecuteSQL to run the above code (mainly to try and learn using executeSQL) I get the error:
'Property ExpressionNode is not set'
The Cell is:
ExecuteSql('Numeric', 'SELECT [value]
WHERE [name] = 'min server memory (MB)'')
Hope someone can help.