1 2 3 Previous Next


64 posts
Share: |

It has been a few weeks since Engage and we are already starting to think about next year. I just wanted to take a moment to thank those that attended this years event. The feedback from everyone has been extremely positive and the overall feeling is that everyone learned a lot during the event. If you received a Survey from us, please fill it out as we are always looking to improve these events and your feedback helps.


Not only did everyone learn a lot, we all had a great time getting to know each other and getting some exercise as well. For everyone who attended, I hope you had a great time and can make it again next year.


For those who didnt make it, pre-registration for Engage 2016 has already begun so there is plenty of time to get approval from your boss to attend next year!


I am enclosing a few photos from this years event and I look forward seeing you all back at the Aria next year at Engage 2016.


2015-09-08 19.52.40 HDR-2.jpg20150909_061724.jpg20150909_063732.jpg2015-09-10 09.07.21.jpg

2015-09-10 20.52.31.jpg

Lance Paulauskas, Mike Johnson, Serena Lambiase, Nasrin Azari, Douglas Hynes, Matt Laurenceau, Mrinalini Wankhede

Share: |

Things are changing here with Track-It! and we have some good news to share with you today.


As you may already know, we are hard at work on a new version of Track-It! that is based on a completely new platform, is 100% browser based and will provide you the most significant increase in functionality that we’ve released in well over 5 years.


This is an extremely exciting development project for us and we would like you to be a part of it.


We are pleased to announce the start of our new Track-It! Developers Circle program.  This program replaces all of our legacy beta programs and will provide members with an unprecedented ability to influence the development of Track-It! going forward. We’ve designed the Track-It! Developers Circle to be very different than traditional beta programs.  Most beta programs provide customers with access to a product after its development is nearly complete and when the opportunity for significant customer input is limited.  The Track-It! Developers Circle, on the other hand, will give you access to the product, the developers, and the product managers throughout the process of designing, developing, and releasing the product.


If you are accepted into the program, the Track-It! development team will provide you access to new functionality as it is developed. This includes the new user interface, form customization tools, business rules, full browser based client, enhanced email integration and other components as they complete their initial development.  You will then have the opportunity to review and provide us with your thoughts on this new functionality and to help us make this upcoming version of Track-It! better than ever.


There is no cost to be part of this program and it is available to all Track-It! customers, regardless of size or how long you have been using the product. All we ask is that you try out new functionality as it becomes available and share your feedback with us.


If you are interested in joining this program, visit this link to sign up http://bit.ly/TIdevcircleNDA. After you submit your application, you will receive more information about the program in the coming weeks. If you have any questions about the program, email trackitteam@bmc.com.


This new program will provide you with unprecedented ability to influence the future of Track-It! and help us deliver an amazing product. We hope you will join us.


Thank you for your ongoing support of Track-It!




The information contained in this letter is the confidential information of BMC Software, Inc. and is being provided to you with the express understanding that without the prior written consent of BMC, you may not discuss or otherwise disclose this information to any third party or otherwise make use of this information for any purpose other than for which BMC intended.  All of the future product plans and releases described herein relate to BMC’s current product development considerations, which are at the sole discretion of BMC and are subject to change and/or cancellation at any time.  BMC cannot and does not provide any assurance as to whether these plans will result in any future releases of the nature described.  These future product plans should not be viewed as commitments on BMC’s part and thus should not be relied upon in customer purchase decisions.

Share: |

We are excited to inform you that Track-It! will be represented at BMC Engage for the 2nd year in a row. The Track-It! sessions for the 2015 BMC Engage User Conference have now been posted to the Engage website. We look forward to meeting you and helping you get the most out of Track-It!  Early bird registration pricing is still in effect until August 7th so register soon!

For information about Engage, a list of all the Track-It! sessions available or to register today, visit http://bit.ly/trackit_engage.


We hope to see you there!!

Share: |

SQL Server CALs are Client Access Licenses and are required by Microsoft licensing in order for client computers to access a SQL Server. Seems simple enough. However, you don't need CALs in some scenarios. Sometimes they are covered by Software Assurance. What's that you ask? It is like a free upgrade maintenance program for Microsoft software that you can subscribe to. Sometimes CALs are covered by MSDN subscriptions. Sometimes, you don't need CALs at all. If you use Server, Processor or Core based licensing, you may already have what you need. If you are using Core+CAL licensing or Server+CAL licensing for your SQL server, you may or may not need CALs depending on how many you already have and how many you need. If you are using SQL Express edition, you don't need Core, Server or CAL licenses because Express Edition is free.


Confused yet?  Most people are at this point.


In very general terms, SQL Server is a database server, which users can access directly or indirectly through an application. In either case, whether accessed directly or indirectly, users require licenses.


In the case of Track-It!, you have Help Desk Technicians and End Users. Those 2 groups of people access the SQL Server indirectly through either the Track-It! Windows Client, Track-It! Web Client or Track-It! Mobile Client. If you have 5 help desk technicians and 100 end users that they support, you will either need 105 CALs or a version of SQL Server that has Processor or Core licensing to cover those users. You might be curious about the Track-It! Audit or the Track-It! Discovery or other products. Those products collect data that is copied up to the Track-It! Server as XML and the Track-It! Server imports that data into the SQL server so you do not need CALs for all the systems being scanned or audited.


The best answer to this question is to contact a Microsoft dealer in your area or speak with whomever you purchase your Microsoft licenses from already.


If you don't know who to contact, visit the site below and chat with a Microsoft licensing expert who can help you.

SQL Server 2014 | Microsoft


Here is a great blog on Microsoft Licensing that also helps explain this.

Licensing How To: When do I need a Client Access License (CAL)? - Microsoft Volume Licensing Blog - Site Home - TechNet…

Share: |

There are some important changes coming for the Track-It! Support team that will allow them to take advantage of some of the infrastructure we have here at BMC. The full details of the changes are documented in the letter below from our director of Track-It! support.


April 2015 Changes to Track-It! Support Processes

Share: |

I receive this question from users periodically and I hate to start off by saying "It depends", but it does.


This type of setup, while fairly common, is not something to be taken lightly nor something that our Track-It! technical support team has expertise in. Please bear in mind that the things discussed in this article are necessary considerations for any public facing website that must interface with an internal network. These cautions and suggestions are not specific to Track-It! Web and involve a number of systems and settings that are outside of the context of Track-It! Web. There are many factors involved with setting up this type of scenario and doing so in a way that is appropriate and secure for your environment. The setup will involve important decisions and configurations in your environment which our technical support team will not have knowledge of or be able to answer for you. While they may be able to guide you in best practices and examples of what most people do, they cannot make the decision for you or configure the system for you.


To begin, there are several different ways you can accomplish this task depending on your technical ability, the resources you have available at your company/location, how you want to present this information to the users (raw IP address vs. pretty domain name) and how secure your system needs to be.


Generally speaking, this type of setup should not be attempted by someone without experience with these types of configurations as you could potentially expose your network and internal systems to external intruders. This type of setup normally requires assistance from someone who is experienced with advanced network security, working with a DMZ, IIS web server setup, domain registration, domain hosting, DNS configuration, Proxies, SSL and firewall/switch configuration. The process can be fairly involved depending on the configuration used.


Normally, working with someone with IIS Admin experience and network security, Track-It! Web is installed on a separate IIS Web server placed in a DMZ. That server is given an external IP address so that users out on the internet can access it. It is best practice to also obtain an SSL cert and install it on the web server so that all connections to the Track-It! Web site are performed securely over HTTPS. If you want a nice domain name like mycompany.com/helpdesk then you would need to work with a website administrator to get that URL/Domain setup and pointed to the public IP address or to add a /helpdesk virtual directory entry that points to your Track-It! Web server. The Track-It! Web server also has to have access to the Track-It! server and to the Track-It! SQL server. This can be done by opening ports, using proxies and other methods that people much smarter than I have come up with and understand how to set up. However you do it, at the end of the day, the Track-It! Web server needs to have a public IP address, be segregated outside your internal network for security and still have access to the SQL and Track-It! servers.

Once you have this set up, your users should be able to connect to the IP address or URL that you have setup in order to get to Track-It! outside your company network. Other things to consider are the Technician/Mobile Web site and the Self Service site.  You will need to have two different public links pointing to each of these if you are exposing both applications outside your network.

I know this article has not explained specific setup steps in order to set up this type of configuration but that is on purpose. Something like this should not be set up by someone who does not fully understand network security, the structure of the network and the policies and regulations of your company and/or industry. In the end I hope this information has been helpful.

Share: |

I am excited to announce that Track-It! 11.4 is now available! This release is another great step in improving the utility of Track-It! and the productivity of the people who use it. This release contains a few enhancements to existing features, some enhancements that were requested by Track-It! users in the Ideas area here on the Track-It! Community and some defect corrections. Here are some highlights of the release.


  • Self-Service ImprovementsTrack-It! Technician Client.png
    • Track-It! users can now save time by approving or rejecting change requests via email
    • Track-It! users can also request more information about a change request via email before approving/rejecting
    • The self-service portal can now be customized to hide features that administrators don’t want their end-users to use
    • The Password Reset Kiosk application has a new silent install feature allowing it to be easily distributed to end users computers


  • Administrative and Usability Improvements
    • Track-It! Survey add on was integrated into the Track-It! product to provide easier implementation/updates for customers who own this module
    • The user interface was updated with a newer flat look and feel to give the application a more modern look
    • Work order notes can now be shown chronologically in email notifications
    • Users can now quickly access work order tickets in Track-It! Web using direct URL links. These links are also included in email notifications
    • Support for TLS has been added for email communications
    • Help documentation was redesigned into a single source web help system which works on all screen types/sizes
    • The support integration feature allows Track-It! administrators to submit requests for technical support directly to the BMC Track-It! support team from within the product
    • Addressed all recently reported security vulnerabilities


Current Track-It! customers can download the 11.4 update from the support portal at support.numarasoftware.com.


Share: |

The purpose of this advisory is to inform you of recently discovered security vulnerabilities in Track-It! and how to address them.  


Please note that for an attacker to take advantage of any of these issues, the attacker must have direct access to the Track-It! application server. If the application server is not exposed to the internet, an attacker would first have to gain access inside your internal network in order to exploit them.  However, even if your Track-It! system is not exposed outside your firewall, we still recommend you take the necessary steps to secure the application as soon as possible.


Update to Track-It! 11.4

Due to the nature and complexity of some of the issues, a full version update is required to address all of them. The vulnerabilities in this bulletin are addressed in Track-It! version 11.4, which is now available on the Track-It! support site here.  Upgrading to 11.4 is the only way to address all of the discovered vulnerabilities.

Short term remediation

If for some reason you cannot immediately update to Track-It! 11.4, it is recommended to block all communications from untrusted networks (e.g. the Internet) at the firewall, specifically to TCP/UDP ports 9010 to 9020 and to the Track-It! Web webserver. Blocking the above mentioned ports/site to secure the server will also block the use of the Self Service feature and Track-It! Technician Web from external networks.  In other words, the Track-It! system will continue to function only within the Intranet network.


Due to the nature of issues 1, 2 and 6 below, we were able to produce individual hotfixes for Track-It! version 11.3. Since these hotfixes do not resolve all the identified issues, we strongly recommend upgrading your Track-It! system to the 11.4 version that includes fixes for all of the identified vulnerabilities.


Resolved Issues:

For more information on each of the items addressed, see the Knowledge Articles listed below.

  1. 1. Article ID TIA07453 - Arbitrary file download – Attackers can download files from the underlying server operating system remotely through the product.   
  2. 2. Article ID TIA07454 - Blind SQL injection – Insufficient input validation can allow attackers to inject SQL code and gain control of the underlying database engine.
  3. 3. Article ID TIA07455 - Hardcoded DB credentials - This issue is limited to demo install only.
  4. 4. Article ID TIA07456 - Credential disclosure - Domain administrator & SQL server user credentials.
  5. 5. Article ID TIA07457 - Code execution – Remote code upload and execution via file upload.
  6. 6. Article ID TIA07508Password Reset – Reset passwords of accounts with just the user ID.


If you have any questions regarding this security notification, please contact Track-It! Support by opening a case at: BMC Track-It! Support

Share: |

Since part 1 and part 2 of this series of blogs, I had been building up, reading and preparing for a post where I discuss the steps of building a report from scratch. However, in conversation with quite a few customers who wish to create their own reports, we often advise that they use one of the standard reports from the Track-It! Reports module.


Here’s a basic but useful report that contains both a graph to highlight activity that may need to be reviewed and detail to drill down to individual issues, Overdue Work Orders by Technician.

rep pg1.jpg

rep pg2.jpg

We can edit the report in Crystal. In Teach yourself Track-It!... Reports. Part 2 Crystal Reports and other useful tools I described where to obtain a licensed copy of Crystal Reports from your support profile, if you are a supported Track-It! customer.

In Track-It!, in the Reports module, with a report I wish to edit select, I can click Export Report from the Tasks list in the top left of the screen in the Technician Client and save to the desktop.


When we open the report in Crystal, this is what we see…


… perhaps a little daunting. Let’s go through what we are presented with here in some detail.


On the left is the Design tab. This is where we do the initial formatting and place objects in the sections you want them to appear in. You can configure how particular data is sorted, grouped and how totals are presented.

This is handled quite cleanly as the data is represented in the Design view, rather than having the data appear itself. It also means that while you are dragging groups around or calculating totals, the data is not actively being retrieved so you are not drawing on resources on the database server or the wider network when doing this.


By default, a report is divided into five areas. In the report we are working with, there are some sub sections in some of the sections – you can see, for example, that the Report Header in Overdue Work Orders by Technician has a Report Header divided into Report Header a, b and c. But as a simple summary of these sections you can refer to this;


Report Header

Usually the title or any information printed at the top of the first page. Track-it! reports use this section to return if no records are found when run (Report Header b) and to place the bar chart (Report Header c)

Page Header

Information repeated at the top of each page is placed in the Page Header. This section type is not in use in our example.


The main body of the report

Report Footer

This appears once at the end of the report. Used, for example, for “grand totals”.

Page Footer

Usually page numbers. Any other information that needs to be repeated at the foot of each page.


There are some additional sections used for groupings, summaries and subtotals, as follows;


Group Header

Printed once at the beginning of the group, use it for a title or for charts made of data held in the group

Group Footer

                Appears once at the end of the group. Can be used for charts and cross tabs.


Crystal Reports contains various “Expert” dialogue boxes to assist with organising various aspects of the report in one place. So in order to see a preview of the structure of the sections, click Tools in the menu bar and select “Section Expert”…

section expert.jpg

Another “Expert” view to look at, which leads in to my next post, click Database from the menu bar and select “Database Expert”. This is where we can add tables to our amended report via their data source (an ODBC connection to the Track-It! database). We can also see, in the Links tab, a visualisation of the matching of records of one table with the corresponding records of another table.

database expert links view.jpg

… and this is a nice link back to the tool I discussed in the last post in this series, the Entity Relationship Diagram of the Track-It! database. This gives us a similar visual representation of the relationship between the tables so that we are able to produce reports, such as this one showing data from “Table A” organised by data held in a “Table B” that has a direct correlation with “Table A” (in this case the WorkOrderStatusId, the numeric value given to Statuses in a Work Order).


So now we’ve seen some aspects of editing an existing report in Crystal Reports, next time I’ll develop this further by going through editing an existing report as a basis for a new report.

Share: |

A slightly belated Happy Easter to you! I hope you had as enjoyable break as I did!!


This month, I wanted to take the opportunity to hopefully bring to prominence some of the useful material that has been published in the Track-It! Product page that may take some scrolling to eventually find as more and more members of the Track-It! community post new discussions and ideas. So here’s a chance for you to bookmark some of these posts if you missed them first time round.


Customers with a maintenance contract will have access to our Knowledge Base at;



… although much has been posted here in the community with more of an emphasis on “how to” rather than publishing resolutions and work arounds to known issues. There is content I have used when investigating faults with customers, just to ensure I am being thorough, leaving no stone unturned and I have often sent links to some of these posts to customers who have logged a call with our Technical Support team. All the material I’d like to highlight today was published by members of the Support team or by Product Management.


If there is anything posted by a customer/end user that people use as a point of reference to help them with their everyday running of Track-It!, please do link to it in the comments section below this blog. Also, if anybody working with Track-It! has a particular approach or “aide-memoire” that they think would be useful to others, please do post a discussion. Even if it is something that has been covered in BMC Communities before, it still has value since we are all coming from our own unique perspectives.



I vaguely knew what this meant from my ceaseless addiction to American movies and TV. But I had to use Wikipedia to get a proper definition;


101 (term), The first course in a subject taught at a college or university in Australia, Canada, South Africa, or the United States. By extension, "Topic 101" is used generally to indicate the basics of any subject. Used this way, it is always pronounced "one-oh-one".

My colleague Keith Scarborough posted a series of "101s" on the Track-It! Inventory module. They are a really useful source of reference on the subject and while covering off the basics, they go some way to help develop a more advanced understanding of this module.

Track-It! Inventory 101


Track-It! Inventory 101 – Discovery


Track-It! Inventory 101 - Workstation Manager


Track-It! Inventory 101 - Initiating an Audit


Track-It! Inventory 101 - Audit and Merge


In a similar vein, last September I blogged about triggering audits externally from Track-It!, utilising Group Policies in Active Directory so that a user’s PC is audited each time they log in;


Next up, Keith and another colleague, Chris McLane have written some really useful notes and tips on the subject of incoming and outgoing email…

This is by Chris. I found it useful to refer to in a support call the other day, not for intended purpose but just as a reminder about how Track-It! appends replies to Work order notifications to the relevant Work Order when the Email Conversation feature is used;

E-mail replies cause new work orders to be created even though "RE:" rules are in place


This post serves as my reminder that;The "Use E-mail Monitor Address for e-mail" option should ONLY be enabled in environments where it is necessary to have multiple help desk e-mail addresses that are forwarded to the main E-mail Monitor inbox. Even then, the option should only be enabled if it is absolutely necessary to have notification e-mails appear to come from the address to which e-mails were originally sent."

Notification e-mails from Track-It! appear to be sent from a user rather than the address configured in the Administration Console


As for this setting – I didn’t know about this when I set out to draft this article. I usually advise customers that the Track-It! Event policies cover off most notification requirements and, on balance probably negate the need for an “auto-reply” to mails to the monitor. But now I have seen this setting in the config file, I can think of one or two recent conversations where this change to the config file will be of use;
How to disable the auto-response e-mail sent to the user after successfully appending additional information


Keith has made contributions about database and server management. This piece discusses the warnings generated by Track-It!;

Track-It! Database 101: Index Health Unsatisfactory warning


… this summarises some of the back-end configuration of the SQL database;Track-It! Database 101:

Transaction Logs and Recovery Model


… and here he devised a more user friendly way of moving a Track-It! installation to new hardware;

How to Move or Copy Track-It!; the newer, simpler method


Benny Morrison worked with the Track-It! Product for a number of years. I have enjoyed his whimsical blogs about Track-It! that he wrote before moving on to our Footprints Product team;

What is Track-It!?



Track-It! is our baby...


… as well as the more conceptual, high level articles he’s written about managing Help Desks in general and how Track-It! may fit into your plans

Getting organized with Track-It! - The top 3 myths about organizing your Help Desk



Cris Coffey is still very much involved in the Product Management of Track-It! and in driving this product page in BMC Communities. You can get a sense of his history with the product here;

15 years. How things have changed.


… and I wanted to emphasise this post Cris made to give you a sense of how important this community to the future evolution of Track-It! and how your Ideas are actively being selected to be integrated in future releases;

First Track-It! release after Ideas module



Finally, more from me. The latest version of Track-It! released is v11.2. If you are planning to upgrade to this version any time soon, you should consider the following;

The Pulse: Track-It! 11.2 Cool Stuff


The Pulse - Track-It! 11.2... Countdown to upgrade


The Pulse - Track-It! 11.x - Office 365 and SMTP and more general Notification troubleshooting tips


Share: |

The new Track-It! 11.3 release is now in Beta. If you are a current Track-It! customer and are interested in participating in the Beta program, it is not too late.


Just visit the document below to learn more about how to sign up for the program.


Track-It! Developers Circle (Beta) Signup

Share: |

This month I wanted to talk about Work Order Resolutions. In Track-It! 11.1, we introduced the ability to;



  • Create detailed, highly useful solutions using in line graphics, bullets colored fonts and more with new

Rich Text Solutions feature


  • Attaching new rich text solutions or formatting an individual Work Order resolution with rich text is now

easy with the Rich Text Resolution field


I’ve had numerous conversations with customers who upgraded from version 11 to version 11.2, missing that we’d added this feature. This has impacted these customers, whose Technicians have been used to entering Plain Text resolutions into a Work Order



… in previous versions, historic resolutions could be seen in their entirety if they only used 2-3 lines of text.


After v11.1, a Technician will only see a preview of the resolution entered and needs to click the “folder” icon to see the entire entry.




… we need to click the Edit icon (the folder in the top right of the resolution) to see the entire entry;

edit note.jpg

The new functionality is built in with the intent of giving us an end to end repository of solutions, available to both Technicians and end users in the Self Service front end. In this, we are striving to assist Track-It! customers in helping their users to help themselves. Let’s walk through how that might look…


I created a solution from the text from my previous blog post;




I just copied the article in its entirety, since we are pasting into a Rich Text editor, and all of the formatting and images were pasted from the clipboard.


Now, someone needs to configure Stop The Clock in Track-It!, the are able to search for that test in the Self Service front end;

self service solutions.jpg

Alternatively, that user logs a Work Order rather than searching Solutions in the Self Service portal, the Technician is able to resolve the Work Order and bring the article into the Resolution as the one they brought to the attention of the Requestor in the Resolution tab;

insert solution.jpg

So this is my interpretation of how we can use the Rich Text formatting to add value to our end users and to start the exercise of populating the Solutions with quality, easy to follow information. This enables us to encourage our end users to draw on this resource and query it for information before they log a call with the Service Desk.


In other news…


When I first joined the Track-It! team back in 2008, we had recently release Track-It! version 8.1. At the time, we were assisting quite a lot of customer with the transition from Track-It! versions 6 & 7 to the new release. Part of the challenge was with the changes to the look and feel of the product, which has now remained largely the same through the course of major releases since that point. As each year progress, it surprises me that we still have an amount of customers looking to upgrade from v7 to something more recent. With this in mind, Kevin Dort asked me to issue a reminder.


In Track-It! 7, the attachment repository folders were different. When a server backup takes place, these files are not included (\Track-It! Server\WOAttach). So we recommend to follow the steps to move the attachments into the default Track-It! 8 – 11 location, in the \Track-It! Services\FileStorageData\Repositories folders.


How to move the Track-It! attachments to another location
Article ID: TIA03046

Share: |

This month I wanted to elucidate clearly about configuring Work Order Event Notifications when email in your organisation is hosted in Office 365. I’ll also touch on more general notification troubleshooting advice which is valid if you use a mail solution in The Cloud or host your own.


Work Order Event Notifications and Office 365

The conversation we have in support with customers whose email solution is in the cloud is usually along the lines of “Office 365 requires TLS encryption but Track-It! only supports SSL”. I found a white paper, here, which confirms this;




“The use of TLS/SSL establishes a highly secure client-to-server connection to help provide data confidentiality and integrity between the desktop and the data center. Customers can configure TLS between Office 365 and external servers for both inbound and outbound email. This feature is enabled by default.”


If we go to the outbound email configuration, in Track-It! 11.2 this is in;


Tools > Administration Console > Configuration > Administration > E-mail Configuration > Outgoing E-mail Configuration


… indications are that this is not possible. There is not an option listed for a required TLS encrypted connectection (1).

outgoing e-mail configuration.jpg


This appears to be borne out when using the “Send Test E-mail” (2)and the resulting test email fails to be sent to it’s recipient.


Let’s try and clear some of this up.


Authenticate on your SMTP host but do not check the box for SSL and apply the changes. If you choose to click the Send Test E-mail and it fails, do not be disheartened. This is because this button is not using the configuration you have entered in this screen. It is checking whether it is possible to send a message via the SMTP host you have configured but it is doing that using the email settings associated with the Windows account you are logged into the computer with.


So in this scenario, please use this guideline to test your connection to your Office 365 SMTP host… once the above is setup and you have ensured that Track-It! is set to send these messages by its schedule - Tools > Administration Console > Configuration > Help Desk >  Work Order Events > Automated Schedule, then create a test Work Order and send a mail to your designated test recipient via the “Email Requestor” button.

email requestor.jpg

We usually find that notifications are sent successfully using the configuration and test outlined above.

Nb – If you have Track-it! configured to “Email Requestor” via your Outlook client, you will need to test outgoing email by matching a Work Order to the Event Policies.


If you continue to struggle with this setup and wish to engage with your local Support team its really useful for us to have a copy of these logs if you have encountered errors while testing;


More General Notification Troubleshooting via the Track-It! Database

While I am on the subject of logs and Notifications, I thought I would quickly share some bits and pieces about where the Notifications register on the Track-It! database. I have learned to rely on these tables when troubleshooting more challenging notification issues.


Open SQL Server Management Studio and connect to the instance where the Track-It! database resides. Expand it in the Object Explorer and then expand the Tables. Scroll down to the “N’s”.


There are three tables I will summarise in this post, NotificationMessage, NotificationStatus and NotificationError.


NotificationMessage contains a line for every notification email that was sent from Track-It!. For the purposes of today’s post, we are concerned with the NotificationStatusId column.



This is the “Automatically generated primary key of the NotificationStatus table”. Essentially, depending on whether the message is in the process of being sent, gets sent successfully, or fails, the NotificationStatus table holds the various statuses that are entered to this column. It is useful to cross reference NotificationMessage with NotificationStatus;



… so if you see a NotificationStatusID of 4 in your NotificationMessage table, you can see that this means “SendFailure” and that will prompt you to look at the NotificationError table;



Obviously, the NotificationMessageId column correlates to the message in the NotificationMessage table. It is easier to insert the cursor into that row’s ErrorMessage entry and select all its contents, copy and paste into Notepad or similar, rather than trying to read the error in SQL Server Management Studio. Here’s some examples;


The requested notification message failed to send. - The SMTP host was not specified.


The requested notification message failed to send. - Mailbox unavailable. The server response was: 5.7.1 Unable to relay for test@companyname.org


These errors may match to errors posted to the Service Management log file in C:\Windows\Temp but this method provides an “electronic paper trail” where you can follow through each step of the way for a specific message, rather than scrolling through up to 10 MBs worth of event logging, much of it not relevant to the errors you are looking for.


  Well that’s it for now but I will be posting again quite soon. I wanted to cover Track-It!’s Rich Text editor for Solutions and Resolutions, which some customers are finding irksome. So I will write that up over the next week or so. I just thought it was confusing to have two unrelated topics in this post. I will also be posting Part 3 in the series about Track-It! reports in the coming weeks. I would appreciate any comments to any of my posts, especially if there is anything you would like me to try and explain… I might even be able to coerce a colleague with a bit more specialist knowledge in that particular area to assist us!

Share: |

I recently posted a simple yet powerful means of reporting in Track-It!. The drawback with reports created from extracted data and formatted in Excel is that they are not integrated with the Track-It! application. You could not, for example, automate these reports so that they are sent on a scheduled basis or share these reports via the Reporting Module.


In order to do this with a custom report, it will need to be written in Crystal Report like all of the standard reports that are included in the off-the-peg application. In the coming weeks I intend to start to look at compiling reports using Crystal so by way of preparation, this post summarises the tools we will need to assist us in this task.


Supported Track-It! Enterprise customers are able to download a copy of Crystal Reports from their support profile at;




While visiting the support site, you can go to the Knowledge Base and bookmark http://downloads.numarasoftware.com/support/11erd/Track-It!_11.htm – The Track-It! 11 SQL Server Physical Data Model. Here you can see, which tables are used by a particular module and how they are connected to each other as well as definitions of each table and their columns.





Finally, you should already have SQL Server Management Studio installed. This will allow you to run SELECT queries so that you are able to compare and contrast with what is output by any report and keep a check on things as you make progress. Customers with a full version of SQL should have this tool already but those who installed SQL Express when they installed Track-It! will have needed to downloaded a copy for free from Microsoft;


SQL 2005 Express



SQL 2008 Express



… so while you are familiarising yourselves with all of this, I am going to identify some simple reports we can start with in my next post. If anyone has any ideas, please do leave a comment below.

Share: |

This month’s Pulse stays focused on the recently released version 11.2.


I detailed some of these features last month. This month, I wanted to pick up on the upgrade itself. Whether you are prepared to upgrade and what you should do immediately after the upgrade.


The Release Notes are published here. As I discussed last month, the main new features are changes to the email monitor and “stop the clock”. A customer I was speaking to recently suggested that this upgrade should have been a major release – Track-It! 12, his view was that revision was quite fundamental.


From customer to customer, Change Management policy varies quite a lot from what I can discern of the Track-It! customers I come into contact with. Some organisations are quite stringent, others less so. Such a policy along with factors such as time and resource both in terms of people and equipment, will inform the decision on how much testing of this release you can carry before upgrading your live Track-It! installation. It may be that the defects addressed in version 11.2 are rather forcing your hand to get this done sooner rather than later. However, the nature of the way features such as the email monitor work now means that how it interacts with your environment is a key facet. If you are able to build a test server, you can download or make a copy of your Track-It! license file and use that to test. If problems arise in your test environment, support will be able to assist without it affecting your service to your user base. You can keep live on the previous version until all issues are resolved in test.


So, even disregarding all of the above, you decide to run the upgrade with the minimal preparation. Well, early in the upgrade, we see this;

11.2 upgrade.jpg

… another opportunity to avail ourselves of information identifying what may be needed when the upgrade completes.


The first link is fairly standard stuff. When each version is released and Remote Control is updated, we provide updated installers for each of the mods customers can opt to use rather than the default setting, where an icon is displayed in the System Tray and users are asked to confirm that a technician can take control on connection to their PC. There are mods for you to change these options;



Option 1 - Hide the Remote icon, and keep the "Confirm Access" prompt (unless the computer is locked or a user is not currently logged on)

Option 2 - Hide the Remote icon, and disable the "Confirm Access" prompt.

Option 3 - Show the Remote icon, and disable the "Confirm Access" prompt (unless the computer is locked or a user is not currently logged on).

The next article linked to provides key information to most customers about changes to the email monitor. In previous versions, there was only a minority that used a POP connection in their email monitor configuration. Most used either the MAPI or Exchange options. Both of these required a client to be installed on the Track-It! server, whether that was the Microsoft Exchange Server MAPI Client and Collaboration Data Objects 1.2.1 or a full Outlook or Groupwise client.

If I was to discuss the most common configuration I come across, a customer would be using an in-house Exchange server and have set the email monitor to use the MAPI setting before upgrade to 11.2. I envisage that, in this scenario, customers would use the IMAP option and configure that from within the Administration Console on completion of the upgrade wizard. In this scenario, The Microsoft Exchange IMAP 4 service must be running on the Exchange server.

That about wraps up another Track-It! Pulse for this month. I will return soon with the next in my series covering Track-it! reports. The next Pulse blogspot will be out in around a month. In the meantime, I would be interested to hear about your experiences of Track-It! 11.2.

Filter Blog

By date:
By tag: