Get instance name from Analysis Services such as @@ ServerName

Is there a way to get the current server name from an Analysis Services instance? Basically the same as SELECT @@SERVERNAME

but for SSAS.

I looked SELECT * FROM $system.DISCOVER_INSTANCES

, but it returns an error:

The 'INSTANCE_NAME' constraint is required but not present in the request. Consider using SYSTEMRESTRICTSCHEMA to provide constraints.

SYSTEMRESTRICTSCHEMA

I am getting the same error when trying to use . INSTANCE_NAME

I get the same error when trying to use . When trying to use SYSTEMRESTRICTSCHEMA

and pointing INSTANCE_NAME

, I get the same error.

Any help or understanding is appreciated!

+3


source to share


2 answers


You are facing an error because the required parameters are not provided for the functions. See here and here for how to pass parameters to these functions.



0


source


This will give you the server name:

select [Value] as ServerName from $SYSTEM.DISCOVER_PROPERTIES where [PropertyName] = 'ServerName';

      



You don't need $ system.DISCOVER_INSTANCES, but the syntax for this is:

select * from SYSTEMRESTRICTSCHEMA($SYSTEM.DISCOVER_INSTANCES, INSTANCE_NAME='MSSQLSERVER');

      

0


source







All Articles