Oracle SQL Query to get Versions of Applicaitons from Remedy ARS

Covers topics on CMDB data structures (container definitions). Here you will find information on how to restore broken CMDB data structures, containers and more.
Forum rules
Keep it professional
Post Reply
hudatolah
Site Admin
Posts: 143
Joined: Thu Apr 04, 2013 8:10 pm
Are You a Headhunter?: Affirmative
Surfer?: Yes

Oracle SQL Query to get Versions of Applicaitons from Remedy ARS

Post by hudatolah » Tue Nov 22, 2022 6:22 pm

Code: Select all

SELECT
CASE 
WHEN Application_gUID = '3513b70c-a7a7-4b0c-a173-c6ea3df27f42' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = '3513b70c-a7a7-4b0c-a173-c6ea3df27f42' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'AA00C04FA081BAFAvORwCkKyMw3EYA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'AA00C04FA081BAFAvORwCkKyMw3EYA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'AB005056B5170DadofUA6YBmlAiUwC' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'AB005056B5170DadofUA6YBmlAiUwC' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'AE00C04F651D06Z2eLPQOYzG6waAIA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'AE00C04F651D06Z2eLPQOYzG6waAIA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'AI005056B5170D5P4XTA1qFVCQmg4A' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'AI005056B5170D5P4XTA1qFVCQmg4A' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'AI00C04FA081BAfFEOQwIjPVWw8gYA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'AI00C04FA081BAfFEOQwIjPVWw8gYA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'AI00C04FA081BARqAsSAwQwppQMToC' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'AI00C04FA081BARqAsSAwQwppQMToC' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'AN005056B5170DeLIrSwm_RTFwnyIA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'AN005056B5170DeLIrSwm_RTFwnyIA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'AP005056B5170Di7AJSg7d1IBQrgwA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'AP005056B5170Di7AJSg7d1IBQrgwA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'AP00C04FA081BA2Nm_PwBDU0IQQAAA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'AP00C04FA081BA2Nm_PwBDU0IQQAAA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'AR005056B5170DLd#JSQUZQNEQXRkA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'AR005056B5170DLd#JSQUZQNEQXRkA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'AS00C04FA081BAz9agQgsk1rQAUgEA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'AS00C04FA081BAz9agQgsk1rQAUgEA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'BMCVIRTUALAGENT' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'AA00C04FA081BAFAvORwCkKyMw3EYA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'CA00C04FA081BAittOQwXXR33Q1gQA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'CA00C04FA081BAittOQwXXR33Q1gQA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'CF00C04FA081BA0HvBSAiybkMw5VcA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'CF00C04FA081BA0HvBSAiybkMw5VcA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'CF00C04FA081BAkVaPQwpARY2QDAoA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'CF00C04FA081BAkVaPQwpARY2QDAoA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'CH00C04FA081BA[dagQgze9rQAUwEA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'CH00C04FA081BA[dagQgze9rQAUwEA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'CM00C04FA081BA2Md_QwpYSSnAxAgA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'CM00C04FA081BA2Md_QwpYSSnAxAgA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'CT00C04FA081BAGoZtQg8YEqLAGgEA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'CT00C04FA081BAGoZtQg8YEqLAGgEA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'CTGAA5V0FGVZ9AQUB6O6QTCPNZ978B' THEN (SELECT DISTINCT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'CTGAA5V0FGVZ9AQUB6O6QTCPNZ978B' )
WHEN Application_gUID = 'DL00C04FA081BAXEXCRQh7mbYw6yEG' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'DL00C04FA081BAXEXCRQh7mbYw6yEG' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'DM005056B5170DvWBITQ1PMJWgm2QF' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'DM005056B5170DvWBITQ1PMJWgm2QF' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'DWHAA5V0GETUSAOT6IQN345QEKBIDQ' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'DWHAA5V0GETUSAOT6IQN345QEKBIDQ' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'EE005056B5170DJSb7TQBxBdFAhDkK' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'EE005056B5170DJSb7TQBxBdFAhDkK' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'FI00C04FA081BAyQvxQg5fB86Q1QQA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'FI00C04FA081BAyQvxQg5fB86Q1QQA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'FN00C04FA081BA420fQwLB8zJA2QAA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'FN00C04FA081BA420fQwLB8zJA2QAA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'FS00C04FA081BA0ctmQg[tLiEQmgAA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'FS00C04FA081BA0ctmQg[tLiEQmgAA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'HD00C04FA081BArNagQgMcRqQAUQEA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'HD00C04FA081BArNagQgMcRqQAUQEA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'ID00C04F651D063b42125a0454854d' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'ID00C04F651D063b42125a0454854d' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'ID00C04F651D063b42125a04548561' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'ID00C04F651D063b42125a04548561' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'ID00C04F651D063b42125a045485c5' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'ID00C04F651D063b42125a045485c5' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'ID00C04FA081BA5xCWQwIeef8wbQoA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'ID00C04FA081BA5xCWQwIeef8wbQoA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'ID00C04FA081BA8LpNRwoCjwSQbdwC' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'ID00C04FA081BA8LpNRwoCjwSQbdwC' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'ID00C04FA081BA[hCWQwVS[g8wbgoA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'ID00C04FA081BA[hCWQwVS[g8wbgoA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'ID00C04FA081BAg7YTQwYNXncALwcA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'ID00C04FA081BAg7YTQwYNXncALwcA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'ID00C04FA081BAyBCWQwW2uf8wbAoA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'ID00C04FA081BAyBCWQwW2uf8wbAoA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'IM00C04FA081BAUcxmQg[8XkEQmwAA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'IM00C04FA081BAUcxmQg[8XkEQmwAA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'IT005056B5170D9ZhBUgAP2RzAYRgH' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'IT005056B5170D9ZhBUgAP2RzAYRgH' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'ITSMOOTBMULTITENANCYAWAREENV' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'ITSMOOTBMULTITENANCYAWAREENV' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'KM00C04FA081BAkzXdRAKRHW5AtFIB' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'KM00C04FA081BAkzXdRAKRHW5AtFIB' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'NG005056B5170DIcP#TwUZEjEwE4IB' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'NG005056B5170DIcP#TwUZEjEwE4IB' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'OB00C04FA081BABZlxQAmyflAg1wEA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'OB00C04FA081BABZlxQAmyflAg1wEA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'PB00C04FA081BABdegQgLx5sQAVAEA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'PB00C04FA081BABdegQgLx5sQAVAEA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'PD00C04FA081BA0SvxQgaxH66Q1wQA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'PD00C04FA081BA0SvxQgaxH66Q1wQA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'PD00C04FA081BAm3gnQwfv6cQw_AEA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'PD00C04FA081BAm3gnQwfv6cQw_AEA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'PM00C04FA081BAp8xmQghBbmEQnAAA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'PM00C04FA081BAp8xmQghBbmEQnAAA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'RA00C04FA081BAw09[QwtW_VlgtAgA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'RA00C04FA081BAw09[QwtW_VlgtAgA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'RA00C04FA081BAydPrRwNkQKqAbOMA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'RA00C04FA081BAydPrRwNkQKqAbOMA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'RB005056B5170DEi7VTQRAYMgA4zkJ' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'RB005056B5170DEi7VTQRAYMgA4zkJ' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'RC00C04FA081BA8s8VQwdzIbeQVAcA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'RC00C04FA081BA8s8VQwdzIbeQVAcA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'RC00C04FA081BACtTrRwD0QLqAg#MA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'RC00C04FA081BACtTrRwD0QLqAg#MA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'RL00C04FA081BA8j7yRw6t0cwQVQUB' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'RL00C04FA081BA8j7yRw6t0cwQVQUB' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'RM00C04FA081BAqsqGRwN5fVKAMu0D' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'RM00C04FA081BAqsqGRwN5fVKAMu0D' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'RO005056B5170DQnAlSgP5A#VgrnsA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'RO005056B5170DQnAlSgP5A#VgrnsA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'RR00C04FA081BA1E9[Qwl7XVlgtQgA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'RR00C04FA081BA1E9[Qwl7XVlgtQgA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'RS00C04FA081BAAuY2SQcUCnuQIyYB' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'RS00C04FA081BAAuY2SQcUCnuQIyYB' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'SBHAA5V0GETUSAPH5FYM5DCSLVBQ3B' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'SBHAA5V0GETUSAPH5FYM5DCSLVBQ3B' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'SLMOOTBMULTITENANCYAWAREENV' THEN (SELECT DISTINCT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'SLMOOTBMULTITENANCYAWAREENV')
WHEN Application_gUID = 'SMHAA5V0GETUSAPGLGL00MQZS9AJF4' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'SMHAA5V0GETUSAPGLGL00MQZS9AJF4' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'SMTIT4073beb410981200cf08b7494b9' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'SMTIT4073beb410981200cf08b7494b9' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'SR00C04FA081BA1vRjQgnQ3LBgQgAA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'SR00C04FA081BA1vRjQgnQ3LBgQgAA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'SR00C04FA081BAan7jRARJpi_QR3EB' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'SR00C04FA081BAan7jRARJpi_QR3EB' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'SR00C04FA081BAhH7jRAhf9i_QTHEB' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'SR00C04FA081BAhH7jRAhf9i_QTHEB' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'SRMOOTBMULTITENANCYAWAREENV' THEN (SELECT DISTINCT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'SRMOOTBMULTITENANCYAWAREENV' )
WHEN Application_gUID = 'TM00C04FA081BAtrVmQgYXmMEQlgAA' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'TM00C04FA081BAtrVmQgYXmMEQlgAA' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'VersionMapping' THEN (SELECT DISTINCT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'VersionMapping' )
WHEN Application_gUID = 'WS00C04FA081BAGJfqSAn7d21ApFsB' THEN (SELECT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'WS00C04FA081BAGJfqSAn7d21ApFsB' AND PROPERTY_Name = 'Name' )
WHEN Application_gUID = 'WS01C04FA081BAmpfqSAR7F41At1sB' THEN (SELECT DISTINCT PROPERTY_VALUE FROM SHARE_Application_Properties WHERE APPLICATION_GUID = 'WS01C04FA081BAmpfqSAR7F41At1sB' )
END "Application Name",  PROPERTY_Name"Property Name", PROPERTY_Value"Value"
FROM SHARE_Application_Properties
Order BY Application_Guid, PROPERTY_NAME ASC 
The Blackholesurfer. My surfboard has teeth.

Post Reply