Fog Creek Software
Discussion Board




Looking for some software

I am looking for software to do the following two tasks, does anyone know of anything that might suit?

1) Keeping track of help desk todo list/KB.
Our current system is a whiteboard, and a couple of folders on the harddrive.

2) Keeping track of firms hardware/software especially with reference with computer licenses. The current system is as follows:
An Excel spreadsheet has a list of all pieces of software, with license keys that we own. Someone has been using the 'notes' function of Excel cells to add little notes next to the license to advise whose computer it is installed on. You can imagine the nightmare that this would be when a machine is reformated. I know I could create an Excel or even a database to cross link it all together.
However just wanted to find out whether anyone knew of a low-end tool that would suit this purpose (before I spend hours knocking one up).

Aussie Chick
Wednesday, August 25, 2004

>1) Keeping track of help desk todo list/KB.
Our current system is a whiteboard, and a couple of folders on the harddrive.

I usually make this thing almost every place I go, as dog food. But I haven't been able to salvage it from the previous employers. I am currently making another one of this reminder utilities in my free time that I can use for myself. I have a habit of forgetting things. I mostly forget to have meals too. As soon as I am finished, I'll be glad to share it with you.

Sathyaish Chakravarthy
Wednesday, August 25, 2004

it's easy. you just build a forum and only you have the right to start a new thread.

for example:
You just post a new topic:
title:dell gx270
Content: ....

others can reply
title:Re:dell gx270
Content:its video card is rubbish!

as for the forum:
I strongly recommed web wiz forum (http://www.webwizforums.com/)because I have installed it on my site(http://www.d2ksoft.com/forum/default.asp)

redguardtoo
Wednesday, August 25, 2004

You could combine the two, where an entry for a license would just be a new item in the KB/help-desk.

Since each item is pretty short and doesn't require rich formatting, the easiest would probably be to use a web-based help-desk app like Mantis or Scarab:

http://www.mantisbt.org/
http://scarab.tigris.org/

Fred
Wednesday, August 25, 2004

>it's easy. you just build a forum and only you have the right to start a new thread.

Sorry but this wouldn't work. We want to be able to cross-reference the two lists.
ie Office2K license list
Hardware list

In this way we could 'delete' the software list for a particular machine if it were reformatted, thereby freeing up the licenses we want to be able to see this easily.

Aussie Chick
Wednesday, August 25, 2004

Having said that a forum hybrid might work.

ie Each computer have a forum topic, with an automated first post listing the OEM (ie unremovable) software licenses used by the machine. An automated second post listing other software licenses installed on the machine. This second post could have a link to a modify page (to add/remove software).
The posts from then on could just contain any information we feel necessary, ie Was serviced on 26/8/04

I have to admit that despite my dislike of web-based applications, I can actually see how this would be preferable to a desktop application.

Aussie Chick
Wednesday, August 25, 2004

the web-based solution comes from my experience, I have installed many OA systems for small companies (with little pay ...\\cry).

redguardtoo
Wednesday, August 25, 2004

REdguardtoo: I need something with a few more features, ie cross-referencing the software license.

Aussie Chick
Wednesday, August 25, 2004

license keys are just resources.
you can  put all those resources in a new "resouce" post  (fixed post? or hot post?) and everyone could edit it.

for the hyperlink to the resouce post, use some automated text-template in "computer" post. for example, automated signature. or considering my product, http://www.d2ksoft.com, ;)

If some complicated data analysis requried, you have to use database and sql.

If you just need some track-down and search feature, a forum is enough.

redguardtoo
Wednesday, August 25, 2004

cross-reference cross-reference cross-reference.

I want to save labor. So if I have two resources, ie software license, and nifty computer, as two different topics, how can I easily link them such that I can
a) delete all the software licenses from one machine, and
b) know exactly which machine a software license belongs on.

With no need for some sucker to have to search through all the topcis to delete all references to a computer when it dies.

I could do what you have said spreadsheet, we already have a spreadsheet, I am talking about something will a bit more strength.

Aussie Chick
Wednesday, August 25, 2004

Aussie Chic, don't you understand about relational databases?

.
Wednesday, August 25, 2004

I do get databases, I am sitting here planning one at the moment.

However once I have created a database, I will have to knock up a useable frontend etc....I can do this, however this is not what I do everyday, so it will take me a bit longer then alot of other people on this board.

What I was hoping was to find out if there was something floating around out there that would do the job. A message board might sound great, but it will need tailoring etc, I was wanting to find out if something exists that would do the job that I require. Surely this type of thing is done in lots of firms of this size (ie too small to pay big bucks, but big enough to need something to keep track of it all).

Aussie Chick
Wednesday, August 25, 2004

>1) Keeping track of help desk todo list/KB.

http://www.liberum.org

Anon
Wednesday, August 25, 2004

... all you need is IIS ...  eeeeyowwww.

How big is your requirement?

Have lo had a look at:
1) Outlook / Tasks?
2) Access / Query?

Quick and dirty is sometimes good.

trollop
Wednesday, August 25, 2004

>Quick and dirty is sometimes good.

Yes you could say today is quick and dirty day, I am designing a little database as we speak. We are a programming company so I should be able to borrow a bit of room on the SQL server, this is preferable to using Access as it will not require installing anything and everyone can access it. The database will be fairly decent underneath, then I think I will make calls from asp/php pages, you can be sure that they will be nothing flash at all.

Just thought I would post this while I worked....

Aussie Chick
Thursday, August 26, 2004

If you have an Apache server available, I recommend taking a look at dotProject. It handles clients, contacts, projects, and tasks quite well.

http://www.dotproject.net

There are also several useful modules (including inventory) available.

http://sourceforge.net/projects/dotmods

grog
Thursday, August 26, 2004

Here Cassandra, just for you.

http://www.vbforums.com/attachment.php?s=&postid=1771487

When I'm through I'll let you know. I plan to make it work for all the users on your LAN, so all of you can add reminders and it would give each user his or her own alerts at any time that is set by the user, and by any one of the methods:

(1) Beep
(2) MSN Messenger like pop-up that slides from the bottom of your screen, stays for a few seconds and then slides down.

as chosen by each individual user.  If you think you need another reminder for the same alert, you'll have a combo or some input field that you can say, "remind me again after x hours", or something like that.

Also, it would have a global hot key registered so you can minimize it to the systray just by pressing, say, the escape key or something.

Sathyaish Chakravarthy
Thursday, August 26, 2004

Cass,

I just learnt from someone that there's this Post It software that also has a free download for a lite version.

Scroll to the bottom of this page.

http://www.3m.com/market/office/postit/com_prod/psnotes/

Sathyaish Chakravarthy
Thursday, August 26, 2004

"However once I have created a database, I will have to knock up a useable frontend etc....I can do this, however this is not what I do everyday"

Isn't this where Infopath or Access could come in handy?

Just me (Sir to you)
Thursday, August 26, 2004

Yes, I was trying to avoid Access (and haven't heard of infopath). I really don't like designing forms in Access.

While this conversation went on this afternoon I drafted the schema for a database, and had a chat with one of the programmers who worked here to get a second opinion on my schema.

I would still prefer to have done it in using the SQL server and a php frontend, however have opted for the slightly quicker/slightly prettier when dirty Access database, if this becomes useful, I might migrate to the SQL/Php option.

Thanks for your input guys.

Aussie chick
Thursday, August 26, 2004

AC, I never intended to suggest your designing forms or reports in Access -  I have never been induced to repeat my initial exposure with either of those.

However, Access is BRILLIANT as a database design tool. you can build tables and maintain relationships, construct queries via QBE then view SQL, or vice versa, then once it's ready youu can hook it up to a REAL database and export results to Excel via Query.

It's handy to know. Runs rings round Excel as an analytical tool.

trollop
Thursday, August 26, 2004

I love when somebody links directly to a zip/exe file.


Thursday, August 26, 2004


Once again...


Check out dotproject (dotproject.net) ...

The inventory module will most likely support what you're looking for and you can always have a list of active/upcoming tasks.

KC
Thursday, August 26, 2004


While I don't have any personal experience with any of the products, doing a search on "inventory" at Sourceforge shows a number of hardware/software inventory options.

Bill Tomlinson
Thursday, August 26, 2004

*  Recent Topics

*  Fog Creek Home