SmartMarine 3D - Get list of deleted objects by user, date and time

DB platform: MS SQL server

Product: SmartMarine 3D, SmartPlant 3D (SM3D, SP3D)

Task: Get list of deleted objects by specific user or/and on specific date and time

A list of the deleted objects is avalable from project's Reports database ( xxxx_RDB ).


| |
2013/12/09 14:48

SmartMarine 3D - Show recent objects in the work space

Database platform: MS SQL server Product: SmartMarine 3D, SmartPlant 3D (SM3D, SP3D) Task: Show in the work space all objects created or edited recently For troubleshooting and for monito


| | | |
2013/12/09 14:48

Smart Marine 3D beginners SQL quick start

Some simple SQL queries that can help new users start faster.

Applicable to: SmartPlant 3D , SmartMarine 3D and Smart 3D design systems.

Create equipment list including equimpment description. The information is stored in two different tables in projects' (plants' ) database - XXXX_MDB. The table view JNamedItem contain all items names and their IDs - oid. The equipment data is read from JEquipment. Table view JEquipment has information for the equipment ID but not for its name.


| | | |
2011/10/16 21:35

List registered SQL servers using C#

Applicable to: Smart Marine 3D, Smart Plant 3D using SQL 2005 client

Smart Plant/Marine 3D software require the SQL servers where projects/plants database is located to be registered on each client workstation. In the software version up to 9.1 HotFix: ANY it is required to have also SQL 2005 client installed on the workstation.


| | |
2011/10/16 21:35