2025-10-15 06:09:08 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Desktop PC%" } -------------------------------------------------------------------------------- 2025-10-15 06:18:30 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Desktop PC%" } -------------------------------------------------------------------------------- 2025-10-15 06:18:46 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Desktop PC%" } -------------------------------------------------------------------------------- 2025-10-15 06:18:48 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-15 06:19:04 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%DVR Recorder%" } -------------------------------------------------------------------------------- 2025-10-15 06:19:26 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 06:19:46 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 06:20:39 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 06:21:37 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":SerialNumber": "%ZY32LP5J57%" } -------------------------------------------------------------------------------- 2025-10-15 06:21:48 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(AssetId) LIKE LOWER(:AssetId) ORDER BY BrandId DESC { ":DepartmentId": 5, ":AssetId": "%ZY32LP5J57%" } -------------------------------------------------------------------------------- 2025-10-15 06:21:51 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":SerialNumber": "%ZY32LP5J57%" } -------------------------------------------------------------------------------- 2025-10-15 06:22:38 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-15 06:23:48 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(BranchName) LIKE LOWER(:BranchName) ORDER BY BrandId DESC { ":DepartmentId": 5, ":BranchName": "%Riyadh%" } -------------------------------------------------------------------------------- 2025-10-15 06:27:11 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%ID Printer%" } -------------------------------------------------------------------------------- 2025-10-15 07:20:11 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Desktop PC%" } -------------------------------------------------------------------------------- 2025-10-15 07:23:08 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%DVR Recorder%" } -------------------------------------------------------------------------------- 2025-10-15 07:23:11 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%IP Telephone%" } -------------------------------------------------------------------------------- 2025-10-15 07:23:14 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%" } -------------------------------------------------------------------------------- 2025-10-15 07:23:18 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 07:34:38 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Desktop PC%" } -------------------------------------------------------------------------------- 2025-10-15 07:40:22 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Desktop PC%" } -------------------------------------------------------------------------------- 2025-10-15 07:43:27 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 12:52:27 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 12:54:02 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-15 12:58:33 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 13:00:10 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-15 13:01:29 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-15 13:01:41 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-15 13:02:46 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-15 13:07:52 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-15 13:08:52 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-15 13:09:08 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 13:10:32 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 13:11:32 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 13:14:21 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 13:15:12 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 13:16:02 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 13:16:58 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 13:17:50 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 13:18:38 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 13:19:28 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 13:20:12 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-15 13:32:39 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-15 13:32:51 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-15 13:32:54 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%ID Printer%" } -------------------------------------------------------------------------------- 2025-10-15 13:32:57 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Desktop PC%" } -------------------------------------------------------------------------------- 2025-10-15 13:33:03 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(BranchName) LIKE LOWER(:BranchName) ORDER BY BrandId DESC { ":DepartmentId": 5, ":BranchName": "%Riyadh%" } -------------------------------------------------------------------------------- 2025-10-15 13:58:04 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND IsActive IN (:status0) ORDER BY BrandId DESC { ":DepartmentId": 5, ":status0": 1 } -------------------------------------------------------------------------------- 2025-10-15 13:58:37 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-15 13:58:43 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND IsActive IN (:status0) ORDER BY BrandId DESC { ":DepartmentId": 5, ":status0": 1 } -------------------------------------------------------------------------------- 2025-10-16 06:43:02 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-16 06:43:16 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%ZY22KKTT3K%" } -------------------------------------------------------------------------------- 2025-10-16 06:43:23 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-16 06:45:14 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 12:34:36 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-19 12:36:18 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Desktop PC%" } -------------------------------------------------------------------------------- 2025-10-19 12:36:26 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-19 12:36:33 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":SerialNumber": "%ZY32KXXJJJ%" } -------------------------------------------------------------------------------- 2025-10-19 12:42:05 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-19 12:49:36 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-19 12:50:28 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 12:52:56 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 12:59:21 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 12:59:22 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 12:59:26 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 13:01:00 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 13:01:43 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 13:05:07 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 13:06:40 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 13:12:53 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 13:14:55 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 13:19:30 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 13:23:05 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 13:40:16 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-19 13:44:33 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%ID Printer%" } -------------------------------------------------------------------------------- 2025-10-19 13:44:36 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%" } -------------------------------------------------------------------------------- 2025-10-19 13:44:43 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Desktop PC%" } -------------------------------------------------------------------------------- 2025-10-19 13:45:11 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Desktop PC%" } -------------------------------------------------------------------------------- 2025-10-19 13:46:14 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-26 10:21:29 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Desktop PC%" } -------------------------------------------------------------------------------- 2025-10-26 10:21:46 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-10-26 10:45:32 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-26 10:45:50 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-26 10:45:55 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-10-30 12:58:09 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Desktop PC%" } -------------------------------------------------------------------------------- 2025-10-30 13:06:16 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%" } -------------------------------------------------------------------------------- 2025-11-03 09:21:56 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-11-03 09:32:08 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Ink Toner%" } -------------------------------------------------------------------------------- 2025-11-03 09:34:21 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Ink Toner%" } -------------------------------------------------------------------------------- 2025-11-03 09:38:47 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Ink Toner%" } -------------------------------------------------------------------------------- 2025-11-03 09:38:51 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%" } -------------------------------------------------------------------------------- 2025-11-03 09:38:54 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Monitor%" } -------------------------------------------------------------------------------- 2025-11-03 10:41:29 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-11-03 10:43:58 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-11-03 10:46:30 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-11-03 10:48:24 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-11-03 10:48:32 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Ink Toner%" } -------------------------------------------------------------------------------- 2025-11-03 10:57:27 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Ink Toner%" } -------------------------------------------------------------------------------- 2025-11-03 10:59:44 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Drum Developer%" } -------------------------------------------------------------------------------- 2025-11-05 08:08:30 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-11-05 12:55:21 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:15 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:51 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:53 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:53 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:53 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:54 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:54 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:54 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:54 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:54 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:54 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:55 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:55 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:55 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:55 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:55 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:58:55 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-05 12:59:58 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Tablet%" } -------------------------------------------------------------------------------- 2025-11-06 05:18:12 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-11-06 06:33:01 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%POS%" } -------------------------------------------------------------------------------- 2025-11-06 06:36:02 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Firewall%" } -------------------------------------------------------------------------------- 2025-11-06 06:38:09 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Firewall%" } -------------------------------------------------------------------------------- 2025-11-06 06:38:11 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Firewall%" } -------------------------------------------------------------------------------- 2025-11-06 06:38:22 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Firewall%" } -------------------------------------------------------------------------------- 2025-11-06 06:40:42 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Storage%" } -------------------------------------------------------------------------------- 2025-11-06 06:40:52 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Storage%" } -------------------------------------------------------------------------------- 2025-11-06 06:47:54 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Storage%" } -------------------------------------------------------------------------------- 2025-11-06 06:53:24 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Storage%" } -------------------------------------------------------------------------------- 2025-11-06 06:53:34 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Storage%" } -------------------------------------------------------------------------------- 2025-11-06 06:59:32 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Server%" } -------------------------------------------------------------------------------- 2025-11-06 07:00:30 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Server%" } -------------------------------------------------------------------------------- 2025-11-06 07:00:40 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Server%" } -------------------------------------------------------------------------------- 2025-11-06 07:02:21 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Server%" } -------------------------------------------------------------------------------- 2025-11-06 07:03:42 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Server%" } -------------------------------------------------------------------------------- 2025-11-06 07:03:53 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Server%" } -------------------------------------------------------------------------------- 2025-11-06 07:04:01 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Server%" } -------------------------------------------------------------------------------- 2025-11-06 07:05:05 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-11-06 07:16:57 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-11-06 07:18:08 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-11-06 07:18:16 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Switch%" } -------------------------------------------------------------------------------- 2025-11-06 07:18:33 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Switch%" } -------------------------------------------------------------------------------- 2025-11-06 07:18:42 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Switch%" } -------------------------------------------------------------------------------- 2025-11-06 07:20:42 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Switch%" } -------------------------------------------------------------------------------- 2025-11-06 07:20:55 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Network Switch%" } -------------------------------------------------------------------------------- 2025-12-07 07:46:36 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-07 07:50:36 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-07 07:51:09 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-07 07:51:18 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-07 07:54:34 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-07 07:54:42 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-07 07:57:42 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-07 07:57:50 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-07 07:59:35 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-07 08:21:09 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%" } -------------------------------------------------------------------------------- 2025-12-07 08:21:20 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%" } -------------------------------------------------------------------------------- 2025-12-07 08:22:04 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%" } -------------------------------------------------------------------------------- 2025-12-07 08:22:22 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%" } -------------------------------------------------------------------------------- 2025-12-07 08:42:14 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%" } -------------------------------------------------------------------------------- 2025-12-07 08:42:24 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-12-07 08:42:39 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2025-12-24 12:04:01 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-24 12:04:15 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-24 12:50:30 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Printer%" } -------------------------------------------------------------------------------- 2025-12-24 12:50:39 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-24 12:50:56 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":SerialNumber": "%VNC6823414%" } -------------------------------------------------------------------------------- 2025-12-27 06:12:23 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%POS%" } -------------------------------------------------------------------------------- 2025-12-27 06:12:36 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%POS%", ":SerialNumber": "%N7A505078182%" } -------------------------------------------------------------------------------- 2025-12-27 06:12:56 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%POS%", ":SerialNumber": "%N7A505078182%" } -------------------------------------------------------------------------------- 2025-12-27 06:30:41 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2025-12-27 06:31:14 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":SerialNumber": "%N7A505078182%" } -------------------------------------------------------------------------------- 2025-12-27 06:53:22 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%POS%" } -------------------------------------------------------------------------------- 2026-01-04 15:32:23 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-01-05 11:28:29 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":SerialNumber": "%ZT322LF7B%" } -------------------------------------------------------------------------------- 2026-01-05 11:28:41 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2026-01-05 11:29:07 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%ZT322LRF7B%" } -------------------------------------------------------------------------------- 2026-01-05 11:29:12 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2026-01-05 11:32:27 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2026-01-05 11:32:39 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2026-01-07 07:49:03 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":SerialNumber": "%ZY22KGNSQR%" } -------------------------------------------------------------------------------- 2026-01-07 07:49:55 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":SerialNumber": "%ZY22KGNSQR%" } -------------------------------------------------------------------------------- 2026-01-08 23:59:24 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-01-13 23:40:24 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-01-14 05:40:28 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Printer%" } -------------------------------------------------------------------------------- 2026-01-15 13:23:13 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-01-18 22:33:57 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-01-24 10:01:10 SELECT BrandId, IsActive, AssetId, BrandProdId, ProductId, DepartmentId, DepartmentName, AssignedTo, AssignedDate, ProductCategory, BranchId, BranchName, BrandName, BrandDescription, SerialNumber, BrandRemarks, DateOfPurchased, DateEntry FROM vwGetBrandProdCat WHERE DepartmentId = :DepartmentId ORDER BY BrandId DESC { ":DepartmentId": 5 } --------------------------------------------------------------------------------