Instructions to upgrade to erwin Mart Server 2020 R2 SP1.
"Modified On" and "Created On" dates are inaccurate in the Mart catalog window in erwin Data Modeler 2020 R2
GDM-100 "Attempting to reference a deleted object" error when opening any Mart model from erwin Data Modeler
"Error 0" when trying to access erwin Mart Administrator after new install or upgrade of Mart Server
How to disable the JMX/RMI interface on the Mart Server to address CVE-2015-0225
When saving a model to the Mart Server I receive the following error: 'Expected a name but was END_OBJECT at line 28866 column 2681 path $[0].REPORT_CREATED_OBJECTS'
Mart 3 way merge - losing changes and how to overcome that.
Mart Server LDAP searching times out. Is there any parameter we can change to increase the searching time?
I've located a vulnerability in the Mart Server Tomcat error page
What are all the codes in the m9session table?

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