How to Return Your erwin DM 9.8 License Code from a Decommissioned PC
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
Mart Server Administrator: this application is out of date, please click the refresh button on your browser (Blocked attempt to access interface...)
Using a concurrent Workgroup license I am getting error: "License server machine is down or not responding"
Is there a sample database query or a way to extract specific Attributes from the Mart across all models?
mart version validation failed. Details: Mart Server is not reachable, please check network and mart server health.
gathering Usage statistics from the mart
I am getting the message, "License's End Date will expire in xx.x days. Please contact erwin Support to renew it."
What versions of the third-party tools does erwin currently support?

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