Listing SSAS cmdlets

This recipe lists the available SSAS cmdlets in SQL Server 2014.

How to do it...

Let's explore the code required to list the SSAS cmdlets:

  1. Open PowerShell ISE as an administrator.
  2. Add the following script and run it:
    Get-Command -Module SQLASCmdlets

    This will give a result similar to this:

    How to do it...

How it works...

A handful of SSAS cmdlets were introduced in SQL Server 2012 and carried over to SQL Server 2014. You can import the SQLASCMDLETS module to start using the new cmdlets.

To list the new AS cmdlets, simply use Get-Command:

Get-Command -Module SQLASCmdlets

You will notice that some of the common SSAS tasks have been wrapped in cmdlets, ...

Get SQL Server 2014 with PowerShell v5 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.