Managing Security Hardware Without Losing Your Mind

Security Operations

Managing Security Hardware Without Losing Your Mind

In the quiet war between expensive software and messy spreadsheets, reality usually hides in the rows.

“I need the passwords for the north gate turret by lunch.”

“The system says we do not have a camera at the north gate.”

“The system is wrong and the camera is there and I can see it from the window.”

Declan sat in his chair and he looked at the screen. The phone had rang at and a man had asked for a pepperoni pizza. The man was loud and the man was certain. Declan had told the man he had the wrong number and the man had argued with him for three minutes. Now it was and the office smelled like old coffee and the manager wanted a password.

Investment Audit

$14,620

The cost of the licensed asset-tracking software with a blue logo. Declan had not opened it since .

Declan did not look at the expensive software on the second monitor. The software was supposed to track every asset and every warranty and every IP address in the building. Declan had not opened the software since the month of . The software was a desert and nothing grew there.

The Living Ledger

He opened a file on his desktop. The file was named MASTER_CAM_LIST_FINAL_v4_2023.xlsx and it was a spreadsheet. It was a large file and it took to load. This spreadsheet was the heart of the company and it was the only thing that was true. Three different people edited this file and they did not always agree but they always typed. The spreadsheet had seven tabs and the tabs were color-coded.

ACTIVE INVENTORY

MAC ADDRESSES

NDAA AUDIT

CABLE RUNS

VENDOR HELL

REORG NOTES

PASSWORDS

The first tab was named ‘Active Inventory’ and it was green. Declan scrolled down the rows and he found the north gate. The camera was a turret model and it had an IP address ending in dot forty-four. The camera was installed in and the installer had left a note in column H. The note said the password was the same as the south gate but with a capital G.

Declan copied the password and he sent it in an email. He did not use the expensive software because the software did not know about the capital G. The spreadsheet was messy but it was alive. A tool is adopted by ease and it is not adopted by price.

Simplicity in the Rack

Declan looked at the second tab. This tab was named ‘MAC_Addresses_Bones’ and it was grey. It contained the physical addresses of every device on the network. He saw the list of poe cameras and he saw the dates they were added to the rack. These were the high-resolution units that ran on a single cable.

The Turret Standard

“Hard to knock out of alignment… they looked like small white stones.”

The PoE cameras were simple and they carried power and they carried data and they did not complain. They were like the spreadsheet. They did one thing and they did it well. Declan liked the turret models because they were hard to knock out of alignment and they looked like small white stones.

He thought about the fire cause investigator he met at a conference. Her name was Flora B. and she had silver hair and she wore a heavy coat. She told him something about the nature of evidence. The expensive software was a place people were paid to monitor. It had a dashboard and it had a pie chart and it had a progress bar.

The progress bar always said one hundred percent but the data was three years old. The spreadsheet was a place people forgot to clean and it was full of truth. It had names of employees who had been fired and it had passwords for routers that had been thrown away. But it also had the truth about the north gate.

The Audit of Forbidden Components

The third tab was yellow and it was named ‘NDAA_Compliance_Audit.’ This was the tab Declan had built himself. He had to make sure the cameras were on the right lists. He looked at the entries for the HELIX and AMLINK models. These were the cameras made with FOXLINK and they were clean of the forbidden components.

He had marked them in bold. The government wanted to know that the cameras were safe and Declan had to prove it. He did not look for this information in the licensed software. The software did not have a field for NDAA compliance and the software did not care about Taiwan. The spreadsheet cared because Declan made it care.

The Infrastructure of Truth

The fourth tab was named ‘Cable_Runs’ and it was blue. It had a list of every ethernet cable in the walls. It told him which cables were Cat6 and which cables were old. A camera is only as good as the copper that feeds it. If the cable is bad then the 4K image is a ghost. The spreadsheet knew which ghosts were real.

The phone on his desk chirped and it was the manager again. The manager thanked him for the password. The manager said the expensive software was a great investment because Declan was able to find the information so fast. Declan did not correct him. He did not tell the manager that the software was an empty shell. He let the manager believe in the fourteen thousand dollar lie.

Declan felt the lack of sleep in his eyes. The pizza caller had been very angry. The man had said that a world without pizza at dawn was a world of chaos. Declan thought about the chaos of the network. If the spreadsheet disappeared the company would stop.

The cameras would still record but nobody would know where the footage was stored. The NVRs would hum in the basement and they would hold their secrets. The spreadsheet was the map of the digital forest.

Tab 5: Vendor_Hell

Software Field

Tax ID #

Spreadsheet Note

“Helpful, but a thief.”

He looked at the fifth tab. It was named ‘Vendor_Hell’ and it was orange. It had the phone numbers of every salesperson who had ever sold them a switch. It had notes about who was helpful and who was a thief. It was a record of human behavior. The expensive software could not hold notes about who was a thief. It only had a field for ‘Vendor Name’ and a field for ‘Tax ID.’ The spreadsheet had room for the soul of the transaction.

A Conversation, Not a Lecture

A shared document is a conversation and a licensed program is a lecture. People want to talk and they do not want to be lectured. The spreadsheet allowed for mistakes and it allowed for quick fixes. If a camera was moved from the front door to the back door a person could change the text in .

In the management software the person had to delete the asset and create a new asset and link the asset to a new location and wait for the database to sync. Nobody has time for the database to sync. The world moves at the speed of a keystroke and the software moves at the speed of a committee.

Declan scrolled to the sixth tab. It was purple and it was named ‘2021_REORG_NOTES.’ It was a graveyard of ideas. It had a plan for a new server room that was never built. It had a list of cameras that were never bought. It was a reminder that plans are small things and reality is a big thing.

The seventh tab was the oldest. It was named ‘DO NOT DELETE – OLD PASSWORDS’ and it was red. It was a list of every password the company had used for . It was a security risk and it was a historical document. Declan knew he should delete it but he could not.

It was the only place that recorded the growth of the company. It showed when they moved from simple words to complex strings. It showed the moment they started to take security seriously.

He closed the spreadsheet and he saved the changes. He looked at the blue logo of the expensive software. He felt a sudden urge to open it. He clicked the icon and he waited.

The Blue Map

The software asked for his username. He typed his username. The software asked for his password. He typed his password. The software asked for a six-digit code from his phone. He looked at his phone and he saw a text message. He typed the code.

The map was beautiful and it was colored with soft gradients. The map showed the north gate. The map said the north gate was empty.

There was no icon for a camera. There was no IP address. There was no history. The software was clean and it was perfect and it was useless. Declan closed the software. He did not log out. He just clicked the X in the corner.

The sun was coming through the window and it hit the dust on his monitor. He thought about the PoE cameras out in the world. They were perched on the corners of buildings and they were watching the streets. They were collecting light and they were turning it into data. They did not care about spreadsheets or management software.

They only cared about the pulse of electricity and the flow of packets. They were honest machines. He decided he would go for a walk. He would go to the north gate and he would look at the turret camera. He wanted to see it with his eyes.

He wanted to confirm that the red note in column H was true. He stood up and his knees made a sound like dry wood. He walked past the server room. The server room was cold and it was loud. The lights on the switches were blinking green. Every blink was a piece of information moving through the dark.

The North Gate Verification

He walked out of the building and the air was cold. The parking lot was full of cars and the cars were silent. He walked to the north gate. He looked up and he saw the camera. It was there. It was white and it was clean and it was pointed at the road. It was exactly where the spreadsheet said it would be.

Declan felt a small sense of peace. He had found the truth in a world of expensive lies. He thought about the man who wanted the pizza at . Maybe that man was right. Maybe the world was a chaotic place and the only thing you could do was demand what you wanted until someone gave it to you.

But Declan had the spreadsheet and the spreadsheet was better than a pizza. It was a map. It was a history. It was a friend. He turned around and he walked back to the office. He had more rows to update. He had more cameras to audit for the NDAA list.

He would spend the afternoon typing in boxes and he would be happy. The management software would continue to sit on the server and it would continue to be perfect and empty. That was the way of things. The expensive things are for the managers to look at and the cheap things are for the workers to use. He opened the door and he went back to his desk. The spreadsheet was waiting.

End of Entry