SELECT 'Addons installed in HANA environment - Data from the SARI table of the SBO-COMMON where Standard or Silent Installer used; if this Query does not list coresuite, then either the Lightweight Installer was used or we are dealing with an onDemand environment.' AS "Description Query (1) - see Result (2)" FROM DUMMY;

SELECT 
"AddOnId" AS "addon id"
,"AName" AS "addon name"
,CASE IFNULL("AddOnVer",' ') 
 WHEN ' ' THEN 'currently not installed'
 ELSE  "AddOnVer"
 END AS "addon version"
,CASE 
 WHEN "AddPlat" = 'N' THEN '32-bit' 
 WHEN "AddPlat" = 'X' THEN '64-bit' 
 END  AS "addon platform" 
FROM "SBOCOMMON"."SARI"
ORDER BY "AddOnId";

SELECT 'Addons assigned to Company incl. Company and SBO-COMMON version, addon status and startup method; if this Query does not list coresuite, then either the Lightweight Installer was used or we are dealing with an onDemand environment.' AS "Description Query (2) - see Result (4)" FROM DUMMY;

SELECT
T0."AddOnId" AS "addon id"
,CAST(T2."Version" AS NVARCHAR) AS "SBO-COMMON version"
,CAST(T4."Version" AS NVARCHAR) AS "company version"
,T3."CompnyName"AS "company name"
,(T0."AName" || ' ' || T0."AddOnVer" || ' ( '|| CASE WHEN T0."AddPlat" = 'N' THEN '32-bit' WHEN T0."AddPlat"= 'X' THEN '64-bit'END || ')') AS "addon assigned (incl. version and platform)"
,CASE 
 WHEN T1."AStatus" = 'Y' THEN 'Addon is set to active' 
 WHEN T1."AStatus" = 'N' THEN 'Addon is NOT active'
 END AS "addon status"
,CASE 
 WHEN T1."EGroup" = 'M' THEN 'Addon start set to MANUAL'
 WHEN T1."EGroup" = 'A' THEN 'Addon start set to AUTOMATIC' 
 WHEN T1."EGroup" = 'C' THEN 'Addon start set to MANDATORY' 
 WHEN T1."EGroup" = 'D' THEN 'Addon starts set to DISABLED' 
 END AS "general addon start"
FROM "SBOCOMMON"."SARI" T0 
INNER JOIN "OARI" T1 
ON T0."AddOnId" = T1."AddOnID",
"SBOCOMMON"."SINF" T2,
"OADM" T3,
"CINF" T4
ORDER BY T0."AddOnId";

SELECT 'Company Name and Version plus SBO-COMMON version for onDemand environment or when Lightweight Installer is used; this allows us to get those details which for Standard Installations are displayed in Query (2), and removes the factor that the SLD Database might be renamed or the access to the SLD for Database User is restricted.' AS "Description Query (3) - see Result (6)" FROM DUMMY;

SELECT
CAST(T1."Version" AS NVARCHAR) AS "SBO-COMMON version"
,CAST(T0."Version" AS NVARCHAR) AS "company"
,T0."CompnyName" AS "company name"
FROM 
"CINF" T0,
"SBOCOMMON"."SINF" T1;

SELECT '(4) Module sips available in the SWA_MODULES table in the Company DB incl. module versions and install status' AS "Description Query (4) - see Result (8)" FROM DUMMY;


SELECT 
DISTINCT "U_SipName"
,CAST("U_SipVersion" AS NVARCHAR)AS "module version"
,"U_ToInstall" AS "to install"
,"U_Hidden" AS "hidden"
FROM "@SWA_MODULES"
GROUP BY "U_DataId","U_SipName","U_SipVersion"
,"U_ToInstall" 
,"U_Hidden"
ORDER BY "U_DataId";

SELECT '(5) Modules installed in Company incl. installed module version and module status' AS "Description Query (5) - see Result (10)" FROM DUMMY;


SELECT 
"U_ProductName" AS "module"
,"U_ProductVersion" AS "module version"
,"U_IsActive" AS "status"
,"U_LicCount" AS "licenced"
,"U_DeletedF" AS "deleted"
  FROM "@COR_COR_MODULES"
  