Ah, that's it. I'm having trouble getting the syntax right for this. I created a temp table for the catalog names and then tried to get the last processed date.

CREATE TABLE #TempCatalogs(

Catalog varchar(50)

)

insert into #TempCatalogs

SELECT *

FROM Openquery(SSASLocalInstance, 'SELECT [CATALOG_NAME] FROM $SYSTEM.DBSCHEMA_CATALOGS')

--Find last process date for specific row with value BI_PSoft_TimeCard_Cube

SELECT Last_Schema_Update As lst,*

FROM Openquery(SSASLocalInstance, 'SELECT * FROM $SYSTEM.mdschema_cubes') AS a

WHERE convert(varchar(50),cube_name) = 'BI_PSoft_TimeCard_Cube'

This returns no results.