Christian_Boeck_57

List of all Object with Description

Discussion created by Christian_Boeck_57 on Mar 23, 2017
Latest reply on Mar 23, 2017 by Christian_Boeck_57
We need again a TSQL statement to get the following information from the Automic database: 
A list of all object and their description and Client, regardless if the description is null or not. 
Could a simple update Statement for the object, cause any Trouble? 
Goals is a easy-to-use-list to update all descriptions, to have a nice documentation state.

Answer:
All these information is store in the OH Tabelle. I only excluded Folder and deleted objects:

select OH_NAME as "object name", OH_Client as "Mandant", OH_Title as "Titel" from OH
where
OH_DeleteFlag = 0 and
OH_OTYPE not in ('FOLD')
order by 2, 1

Outcomes