www.blackholesurfer.com

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