AI Matrx Logo

IT asset tracking

Calderwick and Pryor Insurance Brokers · IT asset tracking · Hartford, CT

Tom Becker manages the computers for Calderwick and Pryor Insurance Brokers, a 200-person firm, and he uses this to load the device management tool's monthly export without creating duplicates and to see who holds which laptop.

Software and ITInventoryImports4 tables · 6 views · 1 form · 1 dimension set · 1 digest · 1 notification · 1 row action · 1 agent
Use this template

Device board

Devices
In stock7
Tovar Slate 13 — LT-1198LT-1198Laptop
Marrick T15 — LT-1207LT-1207Laptop
Aldine Work 14 — LT-1216LT-1216Laptop
Aldine Tower S — DT-1261DT-1261Desktop
Aldine Phone 8 — PH-1297PH-1297Phone
2 more
Assigned26
Tovar Slate 13 — LT-1009LT-1009Laptop
Marrick T15 — LT-1018LT-1018Laptop
Aldine Work 14 — LT-1027LT-1027Laptop
Tovar Slate 13 — LT-1036LT-1036Laptop
Marrick T15 — LT-1045LT-1045Laptop
21 more
In repair1
Tovar Slate 13 — LT-1225LT-1225Laptop
Retired2
Marrick T15 — LT-1234LT-1234Laptop
Aldine Tower S — DT-1270DT-1270Desktop

Tables

Devices

36 sample rows · 16 columns

Every laptop, desktop, phone, tablet and monitor the firm owns: who holds it, what it cost and when the warranty ends.

DeviceAsset tagKindModelSerial numberStatusHeld by
Aldine Tower S — DT-1243DT-1243DesktopAldine Tower SCP52165537AssignedOttilie Strandhagen-Achebe
Aldine Tower S — DT-1252DT-1252DesktopAldine Tower SCP52171668AssignedWilhelmina Strathmore-Obuya
Aldine Tower S — DT-1261DT-1261DesktopAldine Tower SCP52177799In stock—
Aldine Tower S — DT-1270DT-1270DesktopAldine Tower SCP52183930Retired—
Tovar Slate 13 — LT-1009LT-1009LaptopTovar Slate 13CP52006131AssignedOctavia Brightwater-Nwosu
Marrick T15 — LT-1018LT-1018LaptopMarrick T15CP52012262AssignedLucian Haldorsen-Reyes
Aldine Work 14 — LT-1027LT-1027LaptopAldine Work 14CP52018393AssignedThessaly Moorcroft-Boyd
Tovar Slate 13 — LT-1036LT-1036LaptopTovar Slate 13CP52024524AssignedBarnaby Ellsworth-Dube
Marrick T15 — LT-1045LT-1045LaptopMarrick T15CP52030655AssignedDelphine Kowalczyk-Adu
Aldine Work 14 — LT-1054LT-1054LaptopAldine Work 14CP52036786AssignedEverett Sundblad-Strand
Tovar Slate 13 — LT-1063LT-1063LaptopTovar Slate 13CP52042917AssignedSaoirse Fairweather-Obi
Marrick T15 — LT-1072LT-1072LaptopMarrick T15CP52049048AssignedIgnatius Okonkwo-Webb

24 more rows

Staff

24 sample rows · 10 columns

The people who hold devices: where they sit, which department and whether they are still with the firm.

Staff memberStaff numberDepartmentOfficeStatusOn payroll sinceMailbox
Anselm Ferreira-GainesS2256ClaimsRemoteActiveAug 11, 2025anselm.ferreira@calderwickpryorbrokers.net
Barnaby Ellsworth-DubeS2152UnderwritingStamford officeActiveJul 27, 2024barnaby.ellsworth@calderwickpryorbrokers.net
Casimir Voorhees-NairS2334OperationsHartford HQActiveJul 19, 2018casimir.voorhees@calderwickpryorbrokers.net
Cornelius Abernethy-RuizS2230OperationsStamford officeActiveFeb 28, 2024cornelius.abernethy@calderwickpryorbrokers.net
Dashiell Pennington-OkaforS2399SalesStamford officeDepartedJan 4, 2021dashiell.pennington@calderwickpryorbrokers.net
Delphine Kowalczyk-AduS2165SalesStamford officeActiveJul 23, 2021delphine.kowalczyk@calderwickpryorbrokers.net
Everett Sundblad-StrandS2178SalesRemoteActiveJan 3, 2025everett.sundblad@calderwickpryorbrokers.net
Gwendolyn Ashdown-AldridgeS2295SalesHartford HQActiveNov 20, 2023gwendolyn.ashdown@calderwickpryorbrokers.net
Hieronymus Salazar-LundS2360ClaimsHartford HQOn leaveMay 19, 2022hieronymus.salazar@calderwickpryorbrokers.net
Ignatius Okonkwo-WebbS2204FinanceHartford HQActiveJun 23, 2023ignatius.okonkwo@calderwickpryorbrokers.net
Leopold Whitlock-SorensenS2282UnderwritingHartford HQActiveDec 20, 2021leopold.whitlock@calderwickpryorbrokers.net
Lucian Haldorsen-ReyesS2126ClaimsHartford HQActiveAug 27, 2022lucian.haldorsen@calderwickpryorbrokers.net

12 more rows

Repairs

8 sample rows · 8 columns

Every time a device went to the repair shop, what it cost and whether it came back.

Repair numberDeviceOutcomeSent onBack onRepair shopRepair cost
RP-101Tovar Slate 13 — LT-1225At the shopSep 26, 2026—Harbor Bay Device Repair$0
RP-108Aldine Phone 8 — PH-1279RepairedSep 5, 2026Sep 7, 2026Harbor Bay Device Repair$75
RP-105Marrick T15 — LT-1126RepairedAug 26, 2026Sep 2, 2026Quarry Street Computer Service$95
RP-102Marrick T15 — LT-1234Beyond repairJul 27, 2026Aug 4, 2026Harbor Bay Device Repair$0
RP-104Aldine Work 14 — LT-1081RepairedJul 12, 2026Jul 17, 2026Quarry Street Computer Service$240
RP-103Aldine Work 14 — LT-1027RepairedJun 7, 2026Jun 17, 2026Harbor Bay Device Repair$185
RP-107Aldine Tower S — DT-1270Beyond repairMay 8, 2026May 15, 2026Harbor Bay Device Repair$0
RP-106Aldine Tower S — DT-1243RepairedMar 19, 2026Mar 29, 2026Quarry Street Computer Service$60

Forms and booking

Receive a device

Form
Receive a deviceWhat the help desk fills in when a new device arrives from the supplier.
What does the asset tag say? *The label on the case; the export uses it to match rows.
What kind of device is it? *LaptopDesktopPhoneTabletMonitor
What is the model?
What is the serial number?
What did it cost?
What day did it arrive?
What should it be called on the list? *
Add to stock

Also included

  • Devices in stockDigest
  • Sent to repairNotificationLets the IT manager know a device has left for the repair shop.
  • Send to repairRow action

Related templates