Share via

is it possible to output the trace using Invoke-ASCmd

Mina Kamel 101 Reputation points
2021-02-01T20:20:26.013+00:00

Hello,

trying to capture log processing cubes in tabular mood using Powershell script and we are using Invoke-ASCmd. I know it is possible to be done without Invoke-ASCmd.

thanks for all the help in advance.

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,499 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,403 questions
0 comments
Accepted answer
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-02-02T07:11:21.033+00:00

    Hi,

    You could use Invoke-AsCmd with Powershell to capture the log and other desired event.

    Take reference to this ServerMode: Tabular part code in blog : PowerShell Scripts for Collecting SSAS-related Perfmon and xEvent Trace Data

    See if it is what you needed.

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Darren Gosbell 1,466 Reputation points
    2021-02-02T04:50:48.93+00:00

    The processing details you see in the UI in tools like SSMS is being generated by trace events. According to the documentation for Invoke-AsCmd it has a -TraceFile parameter. I have not tried this myself, but I suspect if you set the TraceFile it should capture the information you are after.