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?
After upgrade from Mart 9.x to 2018 R1 or 2019 R1, erwin Mart Administrator login page shows incorrect version
Is there a Mart report that audits a model, like when was it modified last, and by who?
My mart administrator is showing Bad request this combination of host and port requires TLS
erwin DM Mart -- Is there a way to purge or run a script to delete inactive sessions?
Is there a query that will pull the mart users and their permissions and ignore the versions?
Current ERwin version is not compatible with mart version 9.8

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