Message Board

MouseTracks 2007 6.5 SQL Server Database update problems

elpalmer — Fri, 16 May 2008 15:08:30 GMT

I'm attempting to Install the newest version/update the database. The install works fine. I have exclusive access to the SQL Server database (all clients confirmed closed). I am using the correct sa userid and password.

When I press the final confirmation to go aheaed and update the database, I get the messsage

"The database can't be upgraded. You need to restore a backup copy of your database and try the upgrade process again. Contact GRITWARE support for further direction. To connect to another database, hold down the 'shift' key while starting Mouse Tracks. 5: Invalid procedure call or argument"

I have recovered the database from backup and tried this operation over again three times from two different machines. Any ideas?

Forum: Mouse Tracks

Attachment "indicator"

ian — Fri, 11 Apr 2008 19:47:18 GMT

We would like to know when we open a ticket if there is an associated attachment

If there could be some kind of indicator om the ticket info tab or turn the color of the text on the attachment tab a different color, say, red

Forum: Mouse Tracks

Opening Tickets

ian — Thur, 03 Apr 2008 14:49:11 GMT

Hi there
It would be neat to see a prominent button called "Open Ticket #" instead of scrolling down the ticket number column to find a previous case

we have over 3500 records to scroll though

Cheers~

Ian

Forum: Mouse Tracks

Enterprise/SQL Server on Vista error

elpalmer — Wed, 02 Apr 2008 15:18:02 GMT

I have MouseTracks 2007 enterprise, connected to an SQL server database. This works fine from our Windows XP clients. On both Windows vista workstations I've installed the MouseTracks 2007 software on, they can connect to the database and bring up the computer,software, or other listings. However, when you double click on an item to bring it up in detail, we get a pop-up message entitled "ado_CompDetail":

Data source name not found and no default driver specified.

We would really like to use this program on Windows vista. Thanks for any help you can provide!

Forum: Mouse Tracks

Ticket Type

ian — Wed, 26 Mar 2008 15:05:50 GMT

When a new ticket type is specified 'on the fly' I would like to be prompted for the e-mail address for the Web Tracks E-mail Target instead of having to add the Ticket Type in Manually via the data menu.

Forum: Mouse Tracks

Reporting on Custom Fields

dsirrine — Tue, 25 Mar 2008 20:16:27 GMT

When creating a report, how can I utilize fields created under the Custom Fields tab?

Thank you.

Forum: Mouse Tracks

Importing computers from a text file?

dsirrine — Wed, 27 Feb 2008 14:44:01 GMT

Is it possible to import data from a text file, creating new records in the computer list and also update existing records?
I would like to:
-enter computers on which I am not able to run the audit.
-update certain fields on existing records, such as warranty expiration.

Thanks!

Forum: Mouse Tracks

"suggest" bug still exists

tzingale — Wed, 20 Feb 2008 00:19:02 GMT

When we add new software, for the unique ID , the program always suggests "10000", and we have to type in our own.

See the attached. We thought this would be fixed in the new version..

Forum: Mouse Tracks

User Module - Custom Date Field

ian — Tue, 19 Feb 2008 17:59:15 GMT

Hi
I receive the following attached error when I click on the calendar icon to select a date. Note: I had copied a user prior to performing this operation so there was an existing date in the field. Once this error received, the entire app would close

I was able to assign a manual date

Forum: Mouse Tracks

Exporting Reports

dsirrine — Mon, 18 Feb 2008 15:10:23 GMT

Does anyone know the default path for exported reports? I am unsure if the export function is failing since I am unable to locate the export file.

Thanks!

Forum: Mouse Tracks

Error Disposing of Computers and Peripherals

thoese — Tue, 12 Feb 2008 21:16:25 GMT

Description
If your database was upgraded from a prior version of Mouse Tracks and the SA SQL account was not used to perform the upgrade you may experience the attached error when trying to dispose of a peripheral or a computer.

Cause:
Since SA wasn't used to upgrade your database the upgrade process created tables in your database that are not 'owned' by the default user account (DBO). When a computer or peripheral is removed from the database an error occurs when Mouse Tracks tries to cascade changes to related tables via a SQL Trigger.

Resolution
Change the Owner of the new tables to 'DBO'.

Step 1:
Open SQL Server Enterprise Manager and browse to your Mouse Tracks database.

Step 2:
Open SQL Query Analyzer from the Tools menu.

Step 3:
Execute the following statment in the Query window...

USE mtDatabase
GO
EXEC sp_changeobjectowner 'mtUser.periphAttach', 'dbo'
GO

WHERE mtDatabase is the Mouse Tracks database
WHERE mtUser is the current table owner
WHERE periphAttach is the name of the Mouse Tracks table which you are changing the owner.

Step 4:
Repeat step 3 for each table in Mouse Tracks where the owner isn't DBO. Only change the tableName (periphAttach above) for subsequent tables.

Applies to:
SQL Enterprise Edition Database Upgraded with the incorrect SQL user account

Forum: Mouse Tracks

Adding sub categories to Ticket Type

stacyt — Wed, 30 Jan 2008 20:28:24 GMT

It would be great to be able to add sub categories to Ticket Types and drill down to shorter list.

Example:

Printer
Jammed
Won't print
Lights flashing
Etc...

Forum: Mouse Tracks

Attachments

beanonline — Wed, 30 Jan 2008 15:53:49 GMT

Provide the ability to modify an attachment and save.

For example, I would like the ability to add to a word document and change configuration made and save it back to the database.

I believe Outlook can do this with Public Folder attachments.

Would most affect editable files such a word docs, spreadsheets, etc.

Forum: Mouse Tracks

WebTracks Version

cstanley — Tue, 15 Jan 2008 15:30:51 GMT

The only version listed on the Downloads page for WebTracks is the Mouse Tracks 2003. I have upgraded to MT2007. When I install WebTracks is states that the version 5.0 of the database is required. Is there a newer version available or will this version still work?

Forum: IIS Help Desk Interface

More Detectable Software

mhansen — Thur, 10 Jan 2008 01:01:26 GMT

Where can I find additional detectable software signatures?--Didrik

Forum: Mouse Tracks Audit 32