Spent the last couple of hours looking into an issue with the Altiris 6 Helpdesk. As I couldn't find the issue reported elsewhere, and its bitten me before I thought I'd just pop this in the blog.

In summary,  be aware that for practical purposes the limit for attachment filenames in the Altiris Helpdesk is 63 characters.  If you are using Microsoft Exchange for your enterprise email services, internal users mailing into the helpdesk with attachment filenames exceeding this limit will have their attachment silently dropped.

The evidence of a ticket having a dropped attachment is found in ticket history: it will state that ‘the following attachments were added:’ in the incident update without stating the filename (as would normally be the case).

The workaround we put in place is to have helpdesk email going to an mailbox which is then automatically forwarded to the helpdesk. This allows our...

If you have ever needed to create a report but dont know what table you are looking for this might help you out. In my case I had to find something that had the "Publisher".

 To look for columns in view...

USE
Symantec_CMDB
SELECT
V.name AS View_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.views AS v
INNER JOIN sys.columns c ON v.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%Publisher%'
ORDER BY schema_name, View_name;

To look for columns in tables...

USE
Symantec_CMDB
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID...

Join us at CCIB in Barcelona October 4–6 to Surround Yourself with the kind of invaluable knowledge, quality interactions, and fun laid-back environment you'll only find at Symantec Vision 2011.

Sessions this year will start with the new Product Vision and Strategy Forum where our experts will discuss Symantec's strategic plans addressing today's challenges in building an agile Enterprise Infrastructure adopting key trends such as Virtualization, Cloud and Mobile architectures.

From there you'll have access to in-depth specialized knowledge tracks, technical sessions, hands-on labs, and one-on-one opportunities to choose from. You'll also be able to take advantage of discounted training and certification exams, and more.

The Systems and IT Management track features best practices to help you optimize client and server management processes, effectively control assets, reduce...

The Windows IT Pro, SQL Server Magazine and Dev Pro Connections readers choice awards have opened up for voting. There are a number of Symantec products nominated in each award program and if you’re up for it, I invite you to visit the voting site and cast your votes. In some instances, there are more than one Symantec product per category. Since you can only vote in each category once, please just pick your favorite Symantec solution in those cases.

Votes can be cast here:

Windows IT Pro:
http://www.surveymonkey.com/s/windowsitpro-communi...

SQL Server Magazine:
http://www.surveymonkey.com/s/...