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 } -------------------------------------------------------------------------------- 2026-01-27 17:04: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-01-29 06:16: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-02-03 02:19: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 } -------------------------------------------------------------------------------- 2026-02-08 06:25: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 } -------------------------------------------------------------------------------- 2026-02-12 10:54: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 } -------------------------------------------------------------------------------- 2026-02-18 20:19: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 } -------------------------------------------------------------------------------- 2026-02-20 18:33:59 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-02-23 12: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-02-23 12:26: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 } -------------------------------------------------------------------------------- 2026-02-24 07:52: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": "%Laptop%" } -------------------------------------------------------------------------------- 2026-02-24 07:58:49 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%" } -------------------------------------------------------------------------------- 2026-02-24 07:59:17 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%" } -------------------------------------------------------------------------------- 2026-02-24 07:59: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": "%Laptop%" } -------------------------------------------------------------------------------- 2026-02-24 08:14: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": "%Laptop%" } -------------------------------------------------------------------------------- 2026-02-24 08:22: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%" } -------------------------------------------------------------------------------- 2026-02-24 12:28: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": "%Laptop%" } -------------------------------------------------------------------------------- 2026-02-24 12:29:06 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%" } -------------------------------------------------------------------------------- 2026-02-24 12:29: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 AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%" } -------------------------------------------------------------------------------- 2026-02-24 12:44: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(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%" } -------------------------------------------------------------------------------- 2026-02-25 22: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-03-02 15:54: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 } -------------------------------------------------------------------------------- 2026-03-08 17:18: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 } -------------------------------------------------------------------------------- 2026-03-12 21:29: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-03-15 12:16: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) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Printer%" } -------------------------------------------------------------------------------- 2026-03-15 12:17: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Printer%", ":SerialNumber": "%CNBRR667M2%" } -------------------------------------------------------------------------------- 2026-03-15 12:17: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Printer%", ":SerialNumber": "%CNBRR667M2%" } -------------------------------------------------------------------------------- 2026-03-15 12:25: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 } -------------------------------------------------------------------------------- 2026-03-15 12:25: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(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":SerialNumber": "%VNC6H12385%" } -------------------------------------------------------------------------------- 2026-03-15 12:25: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(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":SerialNumber": "%VNC6H12385%" } -------------------------------------------------------------------------------- 2026-03-15 12:25: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": "%Printer%" } -------------------------------------------------------------------------------- 2026-03-15 12:27: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": "%Printer%" } -------------------------------------------------------------------------------- 2026-03-15 12:28: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(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Printer%" } -------------------------------------------------------------------------------- 2026-03-15 12:28:17 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-03-15 12:30: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": "%Printer%" } -------------------------------------------------------------------------------- 2026-03-15 12:32: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": "%Printer%" } -------------------------------------------------------------------------------- 2026-03-15 12:33:19 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-03-15 12:33: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": "%Printer%" } -------------------------------------------------------------------------------- 2026-03-15 12:33: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": "%Printer%" } -------------------------------------------------------------------------------- 2026-03-15 12:33: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": "%Printer%" } -------------------------------------------------------------------------------- 2026-03-15 12:35: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": "%Printer%" } -------------------------------------------------------------------------------- 2026-03-17 00:47:31 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-03-21 22:17: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 } -------------------------------------------------------------------------------- 2026-03-26 08:44: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 } -------------------------------------------------------------------------------- 2026-03-30 07: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-03-30 07:11: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-04-01 20:37: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 } -------------------------------------------------------------------------------- 2026-04-06 19:00: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 } -------------------------------------------------------------------------------- 2026-04-10 12:50: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 } -------------------------------------------------------------------------------- 2026-04-14 18:58: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 } -------------------------------------------------------------------------------- 2026-04-17 18:18:17 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-04-18 15:26: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 } -------------------------------------------------------------------------------- 2026-04-20 08:10: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": "%Mobile%", ":SerialNumber": "%7LYHCIBMY995GEM7%" } -------------------------------------------------------------------------------- 2026-04-20 08:12: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%ZY32LP5J57%" } -------------------------------------------------------------------------------- 2026-04-20 08:13: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%ZY22KGNVPM%" } -------------------------------------------------------------------------------- 2026-04-20 08:14:19 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": "%ZY22KGNVPM%" } -------------------------------------------------------------------------------- 2026-04-20 08:14:31 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": "%ZY22KGNVPM%" } -------------------------------------------------------------------------------- 2026-04-20 08:14: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%ZY32LP5J57%" } -------------------------------------------------------------------------------- 2026-04-20 08:15: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": "%ZY32LP5J57%" } -------------------------------------------------------------------------------- 2026-04-20 08:15: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%ZY32LP86JT%" } -------------------------------------------------------------------------------- 2026-04-20 08:15: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%ZY32LP86JT%" } -------------------------------------------------------------------------------- 2026-04-20 08:15: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%7LYHCIBMY995GEM7%" } -------------------------------------------------------------------------------- 2026-04-20 08:17: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%ZY22KGNVPM%" } -------------------------------------------------------------------------------- 2026-04-20 11: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-04-25 06:20: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 } -------------------------------------------------------------------------------- 2026-04-25 06:20: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 } -------------------------------------------------------------------------------- 2026-04-25 12:12: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 } -------------------------------------------------------------------------------- 2026-04-27 22:39: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 } -------------------------------------------------------------------------------- 2026-04-29 11:00: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-05-01 01:54: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 } -------------------------------------------------------------------------------- 2026-05-01 03:57: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 } -------------------------------------------------------------------------------- 2026-05-03 01:37: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-05-08 05:27: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 } -------------------------------------------------------------------------------- 2026-05-09 22:02: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 } -------------------------------------------------------------------------------- 2026-05-09 22:23: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 } -------------------------------------------------------------------------------- 2026-05-10 05:18: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%ZT322LRHBK%" } -------------------------------------------------------------------------------- 2026-05-10 05:18: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": "%Mobile%" } -------------------------------------------------------------------------------- 2026-05-10 05:19: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 AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%" } -------------------------------------------------------------------------------- 2026-05-10 05:22: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": "%Mobile%" } -------------------------------------------------------------------------------- 2026-05-11 00:32:06 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-05-11 14: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 } -------------------------------------------------------------------------------- 2026-05-12 05:15: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%" } -------------------------------------------------------------------------------- 2026-05-12 05:15: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": "%Mobile%" } -------------------------------------------------------------------------------- 2026-05-13 05:08: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-05-15 04:44: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 } -------------------------------------------------------------------------------- 2026-05-15 10:45: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 } -------------------------------------------------------------------------------- 2026-05-18 11:57: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-05-18 12:52: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 } -------------------------------------------------------------------------------- 2026-05-19 11:14: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(ProductCategory) LIKE LOWER(:ProductCategory) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) AND LOWER(BranchName) LIKE LOWER(:BranchName) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%15489375AA000651%", ":BranchName": "%Riyadh%" } -------------------------------------------------------------------------------- 2026-05-19 12:20: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) AND LOWER(BranchName) LIKE LOWER(:BranchName) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%15489375AA000651%", ":BranchName": "%Riyadh%" } -------------------------------------------------------------------------------- 2026-05-19 12:21: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 } -------------------------------------------------------------------------------- 2026-05-19 20:00:19 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-05-20 04:25:31 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-05-20 05:05: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": "%Mobile%" } -------------------------------------------------------------------------------- 2026-05-20 08:07: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%" } -------------------------------------------------------------------------------- 2026-05-20 10:09: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 } -------------------------------------------------------------------------------- 2026-05-21 13:07: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 } -------------------------------------------------------------------------------- 2026-05-23 15:58: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 } -------------------------------------------------------------------------------- 2026-05-26 15:40: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-05-27 14:16:31 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-06-02 05:32: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 } -------------------------------------------------------------------------------- 2026-06-03 08:02: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) AND LOWER(BranchName) LIKE LOWER(:BranchName) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Printer%", ":BranchName": "%Al-Khobar%" } -------------------------------------------------------------------------------- 2026-06-03 08:02: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) AND LOWER(BranchName) LIKE LOWER(:BranchName) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Printer%", ":BranchName": "%Al-Khobar%" } -------------------------------------------------------------------------------- 2026-06-03 08:06: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 } -------------------------------------------------------------------------------- 2026-06-05 11:02: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 } -------------------------------------------------------------------------------- 2026-06-08 09:08: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 } -------------------------------------------------------------------------------- 2026-06-09 05:03: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%" } -------------------------------------------------------------------------------- 2026-06-09 05:15: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%", ":SerialNumber": "%NXKTEM00G425007B93400%" } -------------------------------------------------------------------------------- 2026-06-09 05:15: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%", ":SerialNumber": "%NXKTEM00G425007B93400%" } -------------------------------------------------------------------------------- 2026-06-09 05:15: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 } -------------------------------------------------------------------------------- 2026-06-09 05:15: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": "%NXKTEM00G425007B93400%" } -------------------------------------------------------------------------------- 2026-06-09 05: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-06-09 05:36: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 } -------------------------------------------------------------------------------- 2026-06-09 05:37:06 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%" } -------------------------------------------------------------------------------- 2026-06-10 12:09: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 } -------------------------------------------------------------------------------- 2026-06-11 02:16: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 } -------------------------------------------------------------------------------- 2026-06-11 13:06: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": "%POS%" } -------------------------------------------------------------------------------- 2026-06-14 00:09: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 } -------------------------------------------------------------------------------- 2026-06-14 12:06: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 } -------------------------------------------------------------------------------- 2026-06-18 17:52: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-06-21 13:02: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%" } -------------------------------------------------------------------------------- 2026-06-21 13:04: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": "%Laptop%" } -------------------------------------------------------------------------------- 2026-06-24 14:44: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 } -------------------------------------------------------------------------------- 2026-06-25 04:44: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 } -------------------------------------------------------------------------------- 2026-06-25 06:09: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 } -------------------------------------------------------------------------------- 2026-06-25 18:41: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 } -------------------------------------------------------------------------------- 2026-07-04 12:49: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 } -------------------------------------------------------------------------------- 2026-07-07 18:41: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 } -------------------------------------------------------------------------------- 2026-07-08 04:35: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 } -------------------------------------------------------------------------------- 2026-07-08 20:52: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 } -------------------------------------------------------------------------------- 2026-07-09 16:54: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 } -------------------------------------------------------------------------------- 2026-07-10 15:32: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 } -------------------------------------------------------------------------------- 2026-07-15 00:27: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 } -------------------------------------------------------------------------------- 2026-07-20 10:31: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 } -------------------------------------------------------------------------------- 2026-07-22 23:43: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 } -------------------------------------------------------------------------------- 2026-07-24 21:40: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-07-30 01:00: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 } -------------------------------------------------------------------------------- 2026-08-02 04:22: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 } -------------------------------------------------------------------------------- 2026-08-02 11:13: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-08-08 00:46: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 } -------------------------------------------------------------------------------- 2026-08-08 22:05: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 } -------------------------------------------------------------------------------- 2026-08-10 21:18: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 } -------------------------------------------------------------------------------- 2026-08-12 23:32:19 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-08-15 22:04: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 } -------------------------------------------------------------------------------- 2026-08-17 15:23: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-08-20 06:35: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 } -------------------------------------------------------------------------------- 2026-08-22 07:04: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 } -------------------------------------------------------------------------------- 2026-08-22 11:28: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 } -------------------------------------------------------------------------------- 2026-08-23 03:43: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-08-24 12:59: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": "%POS%" } -------------------------------------------------------------------------------- 2026-08-24 13:01: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": "%POS%" } -------------------------------------------------------------------------------- 2026-08-25 09:04: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": "%POS%" } -------------------------------------------------------------------------------- 2026-08-25 09:09: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": "%POS%" } -------------------------------------------------------------------------------- 2026-08-25 09:11:17 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-08-27 21:24: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 } -------------------------------------------------------------------------------- 2026-08-28 02:25: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 } -------------------------------------------------------------------------------- 2026-08-28 03:15: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 } -------------------------------------------------------------------------------- 2026-08-30 21:54: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 } -------------------------------------------------------------------------------- 2026-08-31 13:35: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 } -------------------------------------------------------------------------------- 2026-09-01 10:22: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 } -------------------------------------------------------------------------------- 2026-09-02 01:02: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 } -------------------------------------------------------------------------------- 2026-09-02 12:49:17 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-09-03 04:58:45 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-09-06 05:04: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 } -------------------------------------------------------------------------------- 2026-09-07 12:39: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } -------------------------------------------------------------------------------- 2026-09-07 23:35: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 } -------------------------------------------------------------------------------- 2026-09-08 22:16: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 } -------------------------------------------------------------------------------- 2026-09-12 08:00: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 } -------------------------------------------------------------------------------- 2026-09-12 19:36:06 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-09-13 20:10: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 } -------------------------------------------------------------------------------- 2026-09-14 07:47: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(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":SerialNumber": "%ZY22KGNSX3%" } -------------------------------------------------------------------------------- 2026-09-14 07:47: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) AND LOWER(SerialNumber) LIKE LOWER(:SerialNumber) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Mobile%", ":SerialNumber": "%ZY22KGNSX3%" } -------------------------------------------------------------------------------- 2026-09-14 07:47: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%" } -------------------------------------------------------------------------------- 2026-09-14 09:11: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 } -------------------------------------------------------------------------------- 2026-09-14 12:17: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 } -------------------------------------------------------------------------------- 2026-09-15 07:02: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": "%Laptop%" } -------------------------------------------------------------------------------- 2026-09-15 07:06: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": "%POS%" } -------------------------------------------------------------------------------- 2026-09-15 07:23: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": "%Laptop%" } -------------------------------------------------------------------------------- 2026-09-15 07:39:59 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%" } -------------------------------------------------------------------------------- 2026-09-15 08:02: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": "%Printer%" } -------------------------------------------------------------------------------- 2026-09-15 08:06:06 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%" } -------------------------------------------------------------------------------- 2026-09-15 08:06:17 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%" } -------------------------------------------------------------------------------- 2026-09-15 08:10: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": "%Laptop%" } -------------------------------------------------------------------------------- 2026-09-15 08:36: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": "%Mobile%" } -------------------------------------------------------------------------------- 2026-09-15 08:41: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 AND LOWER(ProductCategory) LIKE LOWER(:ProductCategory) ORDER BY BrandId DESC { ":DepartmentId": 5, ":ProductCategory": "%Laptop%" } -------------------------------------------------------------------------------- 2026-09-16 23:27: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 } -------------------------------------------------------------------------------- 2026-09-19 18:49:59 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-09-20 11:16: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 } -------------------------------------------------------------------------------- 2026-09-21 11:05:19 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-09-23 02:34: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 } -------------------------------------------------------------------------------- 2026-09-25 07:18: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 } -------------------------------------------------------------------------------- 2026-09-25 11:00: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 } -------------------------------------------------------------------------------- 2026-09-25 19:45: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 } -------------------------------------------------------------------------------- 2026-09-27 05:54: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 } -------------------------------------------------------------------------------- 2026-09-27 09:21: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 } -------------------------------------------------------------------------------- 2026-09-28 20:30: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 } -------------------------------------------------------------------------------- 2026-09-29 15:00: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 } -------------------------------------------------------------------------------- 2026-09-30 09:09: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 } -------------------------------------------------------------------------------- 2026-10-01 18:14: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 } -------------------------------------------------------------------------------- 2026-10-02 13:58: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 ORDER BY BrandId DESC { ":DepartmentId": 5 } --------------------------------------------------------------------------------