Skip to main content

The IT Helpdesk

One of the custom programs we created when I first started working with my current employer was an IT Helpdesk.  This was a program we wrote (ASP classic with SQL Server backend) to help track and manage our IT tasks/work.

We managed our work into three categories: Production, Projects and List Items.  Production items were issues that needed to addressed right away ("on fire"), whether it be a system bug, a special report, etc.  Projects were larger tasks that would take a month or more to completes.  And list items where the requests that weren't really critical but could be worked on when Production and Projects were completed.

15 years ago it was more of a management tool for IT tasks, but now it has become a great resource for me when trying to figure out issues that have come up in the past.  This is especially helpful now that I'm the only developer/programmer here at my work.  When you have hundreds of pages and thousands of lines of code it's just hard to remember an issue/and or a question from 2 years ago.

Today I put every issue/request/question that comes up into our Helpdesk.  It has become a very valuable resource to me, and for anyone else that works here in the future it will be even more valuable!

Here are a few examples that have come up recently:

So my boss emails me the other day asking why 2 separate reports he was looking at were different.  Our IT Helpdesk has a really good search feature and I looked up the name of one of the reports.  Turns out I had the same question asked in 2016 explaining the exact reason why the companies numbers would differ. (one report was using a Sales order date while the other one uses an Invoice date).

Another example, our network guy emails me an error message from one of our warehouse users.  I look up the exact error message and boom, the answer is right there.  I just told him to reset the Calvin password and it should work again.

So what kind of helpdesk system or reference guide do you use?  If this is something you'd like to try just let me know and I can send you the source code and scripts to create the database tables.  There's several other features the software offers as well such as creating reports, search capabilities, and a few more.




Comments

Popular posts from this blog

Alexa Is Listening, Recording, and Sending!

Check out this story where a couple in Oregon was having a private conversation and Alexa recorded and sent the conversation to one of their contacts!  They were not aware until the contact contacted them about what had happened.  The couple contacted Amazon and they verified the series of events.  But what's even more bizarre is the couple wanted to return their Amazon home devices but Amazon has not agreed to return the costs for the devices! Check out the article here  by Bruce Brown on  Digital Trends

Nonclustered Index in SQL Server

So, I've run into an issue with one of my queries because it takes about 40 seconds to run and according to the Recent Expensive Queries section of the Activity Monitor in SQL Server, there is a section of code taking up about 51% of the query.  First, let me say that I've been writing Transact SQL for quite awhile but have never ventured into the Clustered and NonClustered areas of forming Indexes.  I do use indexes on all my tables but that's just the regular Primary Unique key.  We've been using this query for awhile and it does work but when the result set is about 5K records it takes a little while to run.  So here's the actual query itself SELECT PartNo , SerialNo , HeciCode , ScanDate , OrderType , PoNo , po . IssueDate , SoNo FROM ScanHistory sh WITH ( NOLOCK ) LEFT OUTER JOIN trkRWPOHeader po WITH ( NOLOCK ) ON sh . PoNo = po . PONum WHERE len ( PoNo ) > 2 AND ScanDate >

Staying Fit As a Software Developer

One of the things I love about John Sonmez's book Soft Skills is that he has an entire section dedicated to Fitness! Fortunately, I've always been someone who has been active.  I played sports in high school, intramural sports in college, and still stay active playing golf, basketball, softball, skiing and more.  I also workout almost every weekday.  How does this help me? Well, for starters it helps me stay in shape.  As a software developer you're sitting at a desk a lot!  You can't burn many calories sitting at your desk!  My usual weekly routine is to workout every weekday for about 45-60 minutes.  I'll mix in free weights and some circuit training.  I might run a few miles here and there, but usually when I run it's on the weekends.  I try and play basketball every Wednesday night, and this is the best workout ever!  (just try and not get injured!)  You can lose a lot of calories playing basketball! (if you don't like basketball try racquetball)