Differences

This shows you the differences between two versions of the page.

--- kb:archi [2024/05/02 20:59] – yehuda
+++ kb:archi [2024/05/26 08:26] (current) – yehuda
@@ Line 16: / Line 16: @@
 </code>
+<code sql>
+select Elements.name, Properties.propvalue as softwareProdVersion  from Elements
+inner join Properties
+on Elements.id=Properties.conceptid
+where Elements.type='SystemSoftware'
+and Properties.propkey = 'softwareProdVersion'
+</code>

kb/archi.1714683551.txt.gz · Last modified: 2024/05/02 20:59 by yehuda

Back to top