[TEMPLATE] Service Issues

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	Q	R	S
1	Service Manager Issues															Service Manager Issues ~> Service Manager Issue Linked Properties
2	Service Manager Issue ID	Age	Create Date	Assigned To User ~> Name	Category ~> Name	Close Date	Close User ~> Name	Due Date	Hours	Is Closed	Priority ~> Name	Project ~> Name	Scheduled Date	Status ~> Name	Title	Service Manager Issue Linked Property ID	Property ID	Service Manager Issue ID

3	2	1174.20:57:01	2019-01-11 at 3:21 PM	Nikolai Federick	Maintenance	2022-03-31 at 12:18 PM	Chris Griesinger		0.00	TRUE	Low			Resolved	HVAC Maintenance	1	3	2
4	3	1147.02:26:16	2019-02-08 at 9:52 AM	Nikolai Federick	Maintenance	2022-03-31 at 12:18 PM	Chris Griesinger	2019-02-10	2.00	TRUE	Medium			Resolved	Pests in the Kitchen	2	6	3
5	4	1134.19:57:15	2019-02-20 at 4:21 PM	<Unassigned>	Emergency	2022-03-31 at 12:18 PM	Chris Griesinger	2019-02-21	0.00	TRUE	Emergency		2019-02-21 at 12:00 AM	Resolved	Significant leak in Unit 410S	3	6	4
6	5	19:21:45	2019-03-07 at 12:32 PM	Clare Casuto	Maintenance	2022-03-20 at 7:54 AM	Clare Casuto	2019-03-07	1.00	TRUE	High		2019-03-07 at 12:00 AM	Resolved	Toilet is clogged for Yates	5	3	6
7	6	1089.22:08:32	2019-04-06 at 2:09 PM	Nikolai Federick	Maintenance	2022-03-31 at 12:18 PM	Chris Griesinger	2019-04-10	0.00	TRUE	Medium			Resolved	Cracked living room window	8	13	10
8	9	1034.03:52:31	2019-06-01 at 8:25 AM	Nikolai Federick	Maintenance	2022-03-31 at 12:18 PM	Chris Griesinger	2019-06-05	0.00	TRUE	Medium			Resolved	carpet is pulling away from Wall in 1127 B	9	13	11
9	10	03:10:24	2019-01-03 at 1:20 PM	Michael Cobb	Electric	2022-03-11 at 2:31 PM	Michael Cobb	2019-01-03	0.00	TRUE	Medium		2019-01-03 at 12:00 AM	Resolved	Replace Non-Functioning Electrical Outlet	10	13	12
10	11	4.00:32:12	2019-02-06 at 9:53 AM	Michael Cobb	Maintenance	2022-03-12 at 9:58 AM	Michael Cobb	2019-02-10	0.00	TRUE	Medium		2019-02-10 at 12:00 AM	Resolved	Fix/Replace Door Knob	11	13	13
11	12	04:00:30	2019-03-09 at 7:35 AM	Nikolai Federick	Emergency	2022-03-12 at 10:42 AM	Michael Cobb	2019-03-09	0.00	TRUE	Emergency		2019-03-09 at 12:00 AM	Resolved	Tenant called in with Furnace Issues	12	13	14
12	13	6.01:57:37	2019-04-16 at 11:34 AM	Nikolai Federick	To do	2022-03-12 at 11:39 AM	Michael Cobb	2019-04-22	0.00	TRUE	Medium		2019-04-22 at 12:00 AM	Resolved	Install New Faucets in Bathroom	18	13	20
13	14	7.21:51:09	2019-05-02 at 12:39 PM	Nikolai Federick	Maintenance	2022-03-12 at 12:43 PM	Michael Cobb	2019-05-10	0.00	TRUE	Medium		2019-05-10 at 12:00 AM	Resolved	Replace Dishwasher (Not Working)	19	13	21
14	20	04:25:20	2019-06-09 at 10:40 AM	Nikolai Federick	Maintenance	2022-03-16 at 10:43 AM	Michael Cobb	2019-06-09	0.00	TRUE	Medium		2019-06-09 at 12:00 AM	Resolved	Toilet clogged	20	13	22
15	21	3.23:08:11	2019-06-18 at 10:43 AM	Nikolai Federick	Maintenance	2022-03-16 at 10:46 AM	Michael Cobb	2019-06-18	0.00	TRUE	High		2019-06-18 at 12:00 AM	Resolved	A/C Not Working	21	13	23
16	22	09:49:50	2019-07-04 at 11:40 PM	Michael Cobb	Property Wide	2022-03-16 at 11:44 AM	Michael Cobb	2019-07-05	0.00	TRUE	Emergency		2019-07-05 at 12:00 AM	Resolved	Firework Caused Minor Fire on Roof	22	2	37
17	23	8.04:00:02	2019-07-10 at 1:46 PM	Nikolai Federick	Maintenance	2022-03-16 at 11:50 AM	Michael Cobb	2019-07-15	0.00	TRUE	Medium		2019-07-15 at 12:00 AM	Resolved	Bed Bugs!	23	2	38
18	24	880.23:24:53	2019-11-01 at 12:53 PM	<Unassigned>	Maintenance	2022-03-31 at 12:18 PM	Chris Griesinger	2019-11-02	0.00	TRUE	High		2019-11-06 at 12:00 AM	Resolved	Leaking bathroom sink	26	9	41
19	25	7.00:04:56	2019-11-08 at 1:14 PM	<Unassigned>	Maintenance	2022-03-16 at 1:19 PM	Clare Casuto	2019-11-13	0.00	TRUE	Medium			Resolved	Clean of stop in rug that was stained prior to move in	27	10	42
20	26	3.00:04:24	2019-12-04 at 8:14 AM	Clare Casuto	Plumbing	2022-03-17 at 8:19 AM	Clare Casuto	2020-12-05	0.00	TRUE	High			Resolved	Leaking kitchen sink	46	25	43
21	27	1.00:08:24	2020-02-02 at 8:20 AM	<Unassigned>	Plumbing	2022-03-19 at 8:31 AM	Clare Casuto	2020-02-02	0.00	TRUE	Emergency		2020-02-02 at 12:00 AM	Resolved	Brandekamp 1127B toilet overflowed	29	17	44
22	28	00:01:08	2020-05-07 at 7:11 AM	Nikolai Federick	Maintenance	2022-03-20 at 7:13 AM	Clare Casuto	2020-05-07	0.00	TRUE	Medium			Resolved	Pest control	30	13	45
23	29	1.00:02:41	2020-07-04 at 11:40 AM	<Unassigned>	Plumbing	2022-03-20 at 11:43 AM	Clare Casuto	2020-07-04	0.00	TRUE	High			Resolved	Leak in Bathroom sink & Faucet not working	31	2	46
24	30	1.00:00:01	2020-08-04 at 8:41 AM	Clare Casuto	Plumbing	2022-03-23 at 8:49 AM	Clare Casuto	2020-08-04	0.00	TRUE	High		2020-08-04 at 12:00 AM	Resolved	Toilet is broken in 415S	32	2	47
25	31	2.00:02:43	2020-10-05 at 11:38 AM	Clare Casuto	Maintenance	2022-03-23 at 11:41 AM	Clare Casuto	2020-10-05	0.00	TRUE	High			Resolved	Need to relock & Key 415S	33	24	48
26	32	3.00:00:27	2020-11-02 at 12:27 PM	<Unassigned>	Maintenance	2022-03-23 at 12:28 PM	Clare Casuto	2020-11-04	0.00	TRUE	High			Resolved	Leaking bathroom sink	34	6	49
27	33	1.00:01:55	2021-02-04 at 2:46 PM	Nikolai Federick	Maintenance	2022-03-23 at 2:49 PM	Clare Casuto		0.00	TRUE	Medium		2021-02-04 at 12:00 AM	Resolved	Pest control	35	5	50
28	34	5.00:01:22	2021-07-03 at 7:19 AM	Nikolai Federick	Maintenance	2022-03-24 at 7:21 AM	Clare Casuto	2021-07-03	0.00	TRUE	Medium			Resolved	Pest control	36	2	51
29	35	1.00:00:17	2019-02-06 at 8:33 AM	<Unassigned>	Maintenance	2022-03-26 at 8:35 AM	Clare Casuto	2019-02-06	0.00	TRUE	Medium			Resolved	Leaking faucet	37	2	52
30	36	1.00:01:00	2019-03-02 at 9:15 AM	Nikolai Federick	Maintenance	2022-03-26 at 9:17 AM	Clare Casuto		0.00	TRUE	Medium			Resolved	Pest control	38	17	53
31	37	594.23:01:57.9599360	2022-03-31 at 11:08 AM	Nikolai Federick	Plumbing			2022-04-01	0.00	FALSE	High			New	Broken Shower Head	39	9	54
32	38	594.22:47:51.9599360	2022-03-31 at 11:22 AM	Nikolai Federick	Maintenance			2022-04-03	0.00	FALSE	Low			New	Pet stains on carpet	40	13	55
33	41	594.22:32:24.9599360	2022-03-31 at 11:38 AM	Julie Kelly	Maintenance			2022-04-03	0.00	FALSE	Medium			New	Broken bedroom door	41	17	56
34	42	594.22:23:58.9599360	2022-03-31 at 11:46 AM	Administrator	Maintenance			2022-03-31	0.00	FALSE	High			Work In Progress	Pest control - rats	42	25	57
35	43	594.22:21:56.9599360	2022-03-31 at 11:48 AM	Rae Bruns	Maintenance			2022-04-02	0.00	FALSE	Medium			New	Hole in wall	43	23	58
36	44	594.22:18:04.9599360	2022-03-31 at 11:52 AM	Nikolai Federick	Emergency			2022-03-31	0.00	FALSE	Emergency			Work In Progress	Water in kitchen	44	25	59
37	45	594.22:13:02.9599360	2022-03-31 at 11:57 AM	Clare Casuto	Maintenance			2022-04-01	0.00	FALSE	Medium			Work In Progress	Toilet continuously running	45	4	60
38	46	594.22:10:18.9599360	2022-03-31 at 12:00 PM	Nikolai Federick	Maintenance			2022-04-01	0.00	FALSE	Medium			New	Heat not working	47	7	61
39	47	594.21:40:53.9599360	2022-03-31 at 12:29 PM	Lindsey Urs	Plumbing			2022-04-01	0.00	FALSE	Medium			New	Clogged Garbage Disposal	48	7	62
40	48	594.21:29:01.9599360	2022-03-31 at 12:41 PM	Chris Griesinger	Maintenance			2022-04-03	0.00	FALSE	Medium			New	Excessive interior damage	49	7	63
41	49	594.21:24:10.9599360	2022-03-31 at 12:46 PM	Lindsey Urs	Maintenance			2022-03-31	0.00	FALSE	High			Work In Progress	No hot water	50	7	64
42	50	594.21:21:38.9599360	2022-03-31 at 12:49 PM	Nikolai Federick	Maintenance			2022-04-02	0.00	FALSE	Medium			Work In Progress	Roof Leak	51	7	65
43	51	594.21:16:13.9599360	2022-03-31 at 12:54 PM	Lindsey Urs	Maintenance			2022-04-03	0.00	FALSE	Medium			New	Party Damages	52	7	66
44	52	594.21:05:37.9599360	2022-03-31 at 1:05 PM	Nikolai Federick	Maintenance			2022-04-07	0.00	FALSE	Low			New	HVAC Maintenance	53	7	67
45	53	594.21:04:58.9599360	2022-03-31 at 1:05 PM	Brandi Collins	Electric			2022-04-03	0.00	FALSE	Medium			New	Lights going out unexpectedly	54	9	68
46	54	594.20:56:28.9599360	2022-03-31 at 1:14 PM	Nikolai Federick	Maintenance			2022-04-07	0.00	FALSE	Low			New	Broken refrigerator drawer	55	9	69
47	55	594.20:45:28.9599360	2022-03-31 at 1:25 PM	Michael Cobb	Maintenance			2022-04-07	0.00	FALSE	Low			Work In Progress	Countertop damage	56	9	70
48	56	594.20:42:23.9599360	2022-03-31 at 1:28 PM	Administrator	Maintenance			2022-04-01	0.00	FALSE	Medium			New	Window Leak	57	9	71
49	57	594.20:36:26.9599360	2022-03-31 at 1:34 PM	Administrator	Maintenance			2022-04-02	0.00	FALSE	High			New	Mold	58	9	72
50	58	594.20:34:12.9599360	2022-03-31 at 1:36 PM	Nikolai Federick	Emergency			2022-03-31	0.00	FALSE	Emergency			New	Gas Smell	59	9	73
51	59	594.20:31:19.9599360	2022-03-31 at 1:39 PM	Nikolai Federick	Grounds / Landscaping			2022-04-06	0.00	FALSE	Low			New	Perform Lawn Treatment	60	9	74
52	60	594.20:27:17.9599360	2022-03-31 at 1:43 PM	Nikolai Federick	Exterior - Building			2022-04-10	0.00	FALSE	Low			New	Repaint Exterior of Structure	61	2	75
53	61	14:54:43	2022-02-09 at 12:00 AM	Rae Bruns	<Unassigned>	2022-02-09 at 2:54 PM	Brandi Collins	2022-02-10	0.00	TRUE	<Unassigned>		2022-02-09 at 12:00 AM	<Unassigned>	Re-key Locks	62	2	76
54	62	1.14:57:01	2022-02-08 at 12:00 AM	Chris Griesinger	<Unassigned>	2022-02-09 at 2:57 PM	Brandi Collins	2022-02-10	0.00	TRUE	<Unassigned>		2022-02-10 at 12:00 AM	<Unassigned>	Clean Appliances	63	2	77
55	63	1.14:56:17	2022-02-08 at 12:00 AM	Lindsey Urs	<Unassigned>	2022-02-09 at 2:56 PM	Brandi Collins	2022-02-10	0.00	TRUE	<Unassigned>		2022-02-10 at 12:00 AM	<Unassigned>	Change furnace filter	64	2	78
56	64	14:55:20	2022-02-09 at 12:00 AM	Rae Bruns	To do	2022-02-09 at 2:55 PM	Brandi Collins	2022-02-10	0.00	TRUE	Low		2022-02-10 at 12:00 AM	New	Re-list Rental through ILS	65	2	79
57	65	1.14:56:45	2022-02-08 at 12:00 AM	Lindsey Urs	<Unassigned>	2022-02-09 at 2:56 PM	Brandi Collins	2022-02-10	0.00	TRUE	<Unassigned>		2022-02-10 at 12:00 AM	<Unassigned>	Replace batteries in smoke detectors	66	2	80
58	66	14:57:47	2022-02-09 at 12:00 AM	Chris Griesinger	Maintenance	2022-02-09 at 2:57 PM	Brandi Collins	2022-02-10	0.00	TRUE	Medium		2022-02-10 at 12:00 AM	<Unassigned>	Clean or Replace Carpet	67	2	81
59	67	14:56:01	2022-02-09 at 12:00 AM	Rae Bruns	To do	2022-02-09 at 2:56 PM	Brandi Collins	2022-02-10	0.00	TRUE	Medium		2022-02-10 at 12:00 AM	New	Change Gate Code (when applicable)	68	7	82
60	68	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Chris Griesinger	<Unassigned>			2022-04-01	0.00	FALSE	<Unassigned>		2022-04-01 at 12:00 AM	<Unassigned>	Re-key Locks	69	7	83
61	69	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Rae Bruns	<Unassigned>			2022-04-01	0.00	FALSE	<Unassigned>		2022-04-01 at 12:00 AM	<Unassigned>	Clean Appliances	70	7	84
62	70	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Nikolai Federick	<Unassigned>			2022-04-01	0.00	FALSE	<Unassigned>		2022-04-01 at 12:00 AM	<Unassigned>	Change furnace filter	71	7	85
63	71	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Administrator	To do			2022-04-01	0.00	FALSE	Low		2022-04-01 at 12:00 AM	New	Re-list Rental through ILS	72	7	86
64	72	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Brandi Collins	<Unassigned>			2022-04-01	0.00	FALSE	<Unassigned>		2022-04-01 at 12:00 AM	<Unassigned>	Replace batteries in smoke detectors	73	7	87
65	73	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Michael Cobb	Maintenance			2022-04-01	0.00	FALSE	Medium		2022-04-01 at 12:00 AM	<Unassigned>	Clean or Replace Carpet	74	7	88
66	74	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Michael Cobb	To do			2022-04-01	0.00	FALSE	Medium		2022-04-01 at 12:00 AM	New	Change Gate Code (when applicable)	75	3	89
67	75	27.15:04:25	2022-01-13 at 12:00 AM	Michael Cobb	<Unassigned>	2022-02-09 at 3:04 PM	Brandi Collins	2022-01-13	0.00	TRUE	<Unassigned>		2022-01-13 at 12:00 AM	<Unassigned>	Re-key Locks	76	3	90
68	76	672.10:10:45.9599360	2022-01-13 at 12:00 AM	Lindsey Urs	<Unassigned>			2022-01-13	0.00	FALSE	<Unassigned>		2022-01-13 at 12:00 AM	<Unassigned>	Clean Appliances	77	3	91
69	77	672.10:10:45.9599360	2022-01-13 at 12:00 AM	Nikolai Federick	<Unassigned>			2022-01-13	0.00	FALSE	<Unassigned>		2022-01-13 at 12:00 AM	<Unassigned>	Change furnace filter	78	3	92
70	78	27.15:04:58	2022-01-13 at 12:00 AM	Lindsey Urs	To do	2022-02-09 at 3:05 PM	Brandi Collins	2022-01-13	0.00	TRUE	Low		2022-01-13 at 12:00 AM	New	Re-list Rental through ILS	79	3	93
71	79	672.10:10:45.9599360	2022-01-13 at 12:00 AM	Chris Griesinger	<Unassigned>			2022-01-13	0.00	FALSE	<Unassigned>		2022-01-13 at 12:00 AM	<Unassigned>	Replace batteries in smoke detectors	80	3	94
72	80	672.10:10:45.9599360	2022-01-13 at 12:00 AM	Michael Cobb	Maintenance			2022-01-13	0.00	FALSE	Medium		2022-01-13 at 12:00 AM	<Unassigned>	Clean or Replace Carpet	81	3	95
73	81	27.15:05:42	2022-01-13 at 12:00 AM	Michael Cobb	To do	2022-02-09 at 3:05 PM	Brandi Collins	2022-01-13	0.00	TRUE	Medium		2022-01-13 at 12:00 AM	New	Change Gate Code (when applicable)
74	82	1.15:11:42	2022-02-01 at 12:00 AM	Brandi Collins	<Unassigned>	2022-02-09 at 3:11 PM	Brandi Collins	2022-02-01	0.00	TRUE	<Unassigned>		2022-02-01 at 12:00 AM	<Unassigned>	Re-key Locks
75	83	7.15:23:26	2022-02-01 at 12:00 AM	Nikolai Federick	<Unassigned>	2022-02-09 at 3:23 PM	Brandi Collins	2022-02-01	0.00	TRUE	<Unassigned>		2022-02-01 at 12:00 AM	<Unassigned>	Clean Appliances
76	84	4.15:18:38	2022-02-01 at 12:00 AM	Lindsey Urs	<Unassigned>	2022-02-09 at 3:18 PM	Brandi Collins	2022-02-01	0.00	TRUE	<Unassigned>		2022-02-01 at 12:00 AM	<Unassigned>	Change furnace filter
77	85	1.15:11:25	2022-02-01 at 12:00 AM	Chris Griesinger	To do	2022-02-09 at 3:11 PM	Brandi Collins	2022-02-01	0.00	TRUE	Low		2022-02-01 at 12:00 AM	New	Re-list Rental through ILS
78	86	4.15:19:32	2022-02-01 at 12:00 AM	Michael Cobb	<Unassigned>	2022-02-09 at 3:19 PM	Brandi Collins	2022-02-01	0.00	TRUE	<Unassigned>		2022-02-01 at 12:00 AM	<Unassigned>	Replace batteries in smoke detectors
79	87	653.10:10:45.9599360	2022-02-01 at 12:00 AM	Rae Bruns	Maintenance			2022-02-01	0.00	FALSE	Medium		2022-02-01 at 12:00 AM	<Unassigned>	Clean or Replace Carpet
80	88	1.15:18:22	2022-02-01 at 12:00 AM	Clare Casuto	To do	2022-02-09 at 3:18 PM	Brandi Collins	2022-02-01	0.00	TRUE	Medium		2022-02-01 at 12:00 AM	New	Change Gate Code (when applicable)
81	89	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Brandi Collins	<Unassigned>			2022-02-10	0.00	FALSE	<Unassigned>		2022-02-10 at 12:00 AM	<Unassigned>	Re-key Locks
82	90	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Nikolai Federick	<Unassigned>			2022-02-10	0.00	FALSE	<Unassigned>		2022-02-10 at 12:00 AM	<Unassigned>	Clean Appliances
83	91	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Michael Cobb	<Unassigned>			2022-02-10	0.00	FALSE	<Unassigned>		2022-02-10 at 12:00 AM	<Unassigned>	Change furnace filter
84	92	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Administrator	To do			2022-02-10	0.00	FALSE	Low		2022-02-10 at 12:00 AM	New	Re-list Rental through ILS
85	93	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Administrator	<Unassigned>			2022-02-10	0.00	FALSE	<Unassigned>		2022-02-10 at 12:00 AM	<Unassigned>	Replace batteries in smoke detectors
86	94	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Nikolai Federick	Maintenance			2022-02-10	0.00	FALSE	Medium		2022-02-10 at 12:00 AM	<Unassigned>	Clean or Replace Carpet
87	95	644.10:10:45.9599360	2022-02-10 at 12:00 AM	Brandi Collins	To do			2022-02-10	0.00	FALSE	Medium		2022-02-10 at 12:00 AM	New	Change Gate Code (when applicable)