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?
Does CVE-2020-1938 Affect Mart 2020r1?
Unauthorized operation attempted. For more information, please review the log file

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