Mart Configuration: Data Access Error. The connection to the server, port 1433 has failed. Verify the server name and port number.
Error: "Mart DB version is not compatible with Mart Server" when connecting from erwin DM to a Mart installed on an Oracle database.
How to search Mart Models by table name
Unknown Error When making changes/saving Mart Model
Unable to start Mart Server Service after installing Mart on the same server as Data Intelligence Suite
Unable to create my Mart Server service - expecting Java_Home to be defined?
500 The call failed on the server error when accessing Permission Management in erwin Mart Administrator
How to enable SSL using ThirdParty Certificate in erwin MartServer
Unable to start Mart Server after upgrade
Using Report Designer, can I get a Mart Report of where a particular column is being used?

See more

SQL Server query that retrieves the Model Names, Versions and LastModifiedDate from the Mart Server

Updated November 01, 2019 13:48

SQL Server query that retrieves the Model Names, Versions and LastModifiedDate from the Mart Server:

SELECT ca.C_Name as ModelName_versionname,ca.C_Version,lm.LastModifiedDate FROM m9Catalog ca
LEFT OUTER JOIN (SELECT ca.C_Container_Id,ca.C_CreatedOn 'LastModifiedDate' FROM m9Catalog ca
WHERE ca.C_Id IN (SELECT MAX(C_Id) FROM m9Catalog GROUP BY C_Container_Id)
) lm ON
ca.C_Id = lm.C_Container_Id where ca.C_Type='D' or ca.C_Type='V'

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk