Modify methods to categorize device subscriptions

## Purpose
* Fixes https://roadmap.entgra.net/issues/11162
Co-authored-by: Kavin Prathaban <kavin@entgra.io>
Co-committed-by: Kavin Prathaban <kavin@entgra.io>

+package io.entgra.device.mgt.core.application.mgt.common.dto;

+package io.entgra.device.mgt.core.application.mgt.common.dto;

+package io.entgra.device.mgt.core.device.mgt.core.dto;

+/*
+ * Copyright (c) 2018 - 2024, Entgra (Pvt) Ltd. (http://www.entgra.io) All Rights Reserved.

         return operation;
     }
 
+    public static JSONObject convertBlobToJsonObject(Blob blob) throws SQLException {

+                        jsonString = new JSONObject(obj).toString();
+                    }
+                } catch (ClassNotFoundException e) {
+                    throw new SQLException("Failed to deserialize object from BLOB", e);

+                jsonString = new String(blobBytes, "UTF-8");
+            }
+        } catch (IOException e) {
+            throw new SQLException("Failed to convert BLOB to JSON string", e);

+
+        // Convert JSON string to JSONObject
+        if (jsonString == null || jsonString.isEmpty()) {
+            throw new SQLException("Converted JSON string is null or empty");

+                }
+            }
+        } catch (SQLException e) {
+            throw new DeviceManagementDAOException("Error occurred while retrieving owners and device IDs for owner: " + owner, e);

+                "JOIN DM_DEVICE d ON e.DEVICE_ID = d.ID " +
+                "WHERE e.DEVICE_ID = ? AND e.TENANT_ID = ?";
+
+        try (Connection conn = this.getConnection();

+                }
+            }
+        } catch (SQLException e) {
+            throw new DeviceManagementDAOException("Error occurred while retrieving owner and status for device ID: "

+                "FROM DM_ENROLMENT " +
+                "WHERE TENANT_ID = ?";
+
+        try (Connection conn = this.getConnection();

+                }
+            }
+        } catch (SQLException e) {
+            throw new DeviceManagementDAOException("Error occurred while retrieving devices for tenant ID: "

+                        "    AND g.TENANT_ID = ? " +
+                        "LIMIT ? OFFSET ?";
+
+        try (Connection conn = GroupManagementDAOFactory.getConnection();

+                }
+            }
+        } catch (SQLException e) {
+            throw new GroupManagementDAOException("Error occurred while retrieving group details and device IDs for group: "

     }
+
+    @Override
+    public OwnerWithDeviceDTO getOwnersWithDeviceIds(String owner) throws DeviceManagementDAOException {

+                "JOIN DM_DEVICE d ON e.DEVICE_ID = d.ID " +
+                "WHERE e.DEVICE_ID = ? AND e.TENANT_ID = ?";
+
+        try (Connection conn = this.getConnection();