How to Return Your erwin DM 9.8 or future releases License Code
How to check what specific processes or applications are accessing what ports on my Windows device?
How to Submit an Idea or Enhancement Request for your erwin Inc. product
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
I am trying to configure my Oracle mart and it is not working. My martserverupgrade.log file is responding ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

See more

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

Updated January 23, 2018 14:55

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