none
Extract date modified from Azure Analysis Services with Powershell RRS feed

  • Question

  • Hi,

    I would like to know how to get the date modified from a model in Analysis Services with Power Shell.

    Thanks.

    Roberto E.

    Thursday, October 25, 2018 11:07 PM

All replies

  • Hi Roberto,

    You can write something like below

    [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") | Out-Null
    $server = New-Object Microsoft.AnalysisServices.Server
    $server.connect("PowerServer3\SQL2008")
    $DBID = "Adventure Works DW 2008"
    $database = $server.Databases.Item($DBID)

    $database.lastprocessed


    Cheers,

    Friday, October 26, 2018 3:08 AM