At the request of the Altiris community I am releasing the source code to reports I’ve written throughout out our implementation. This report will execute and retrieve all active endpoints and their corresponding Computer Name, Operating System, Primary User, Telephone, Email, Computer Model, Serial Number, Last Check-In Date, Status, and Barcode. Below is the SQL source code to run against your Symantec IT Management Suite 7.5 database either through SQL Server Management Studio or the built in reporting tool in the console. Always remember to backup your database before executing any code!