Database

This is a modified version of CondorMan's SQL trigger to sync your DS Computer group structure with your AD OU structure. So first off, I just want to give full credit and thanks to CondorMan on the original work that he posted HERE.

This VBScript will return the table sizes sorted by [Total KB] and then populate an Excel spreadsheet with the results. It will first ask for the servername you wish to connect to. The query is from KB Article: Article ID: 21310.

For those who have Provisioned Intel AMT Systems, you may wonder what takes place in the background. This article is for you! The process has often been covered at a high level, but here the technical details are provided. Hopefully this helps you understand the inner workings, and provide you information when troubleshooting Provisioning issues. And for those of you who are technically minded, it's also neat to know! This information was compiled working on issues and running through provisioning processes from Symantec Support.

How will you be able to remove old computers that were placed by resource discovery into the database? This tech tip will tell you how to do so.

Over time the helpdesk database becomes very laden with sludge. In our case, in over 3 years of heavy use the helpdesk has been in place, we have accumulated over 1.5 million incidents, 8500 obsolete contacts and 150 worker queues. With every passing month my users noticed the system getting slower and slower.

In part 1 of Installing Altiris Deployment Solution 6.9 - Advanced Setup, we downloaded and installed Microsoft .NET Framework 2.0 SP1, installed Microsoft IIS with ASP, downloaded and installed SQL Server 2005 Express Services with Advanced Services SP2, set the sa (systems administrator) password on the SQL Server, created a user account for Altiris, granted TCP Connections for Altiris, and granted the Altiris User Access to the SQL Database.

Want to recover the Recovery Solution cluster settings in the Notification Server database? This tip will tell you the method to do so.

One day I got a call from a frantic teacher. They told me that they were in front of a class and needed to get on the Internet to show their class something. The Internet was not working. They told me that their entire class revolved around getting access to the Internet. I decided that I needed to drop what I was doing and make my way to that teacher's classroom. Once I arrived I could see that the computer was having problems. I checked everything that I could think of to try and get the network working again. Finally I decided to check the devices on the computer. There was no network card listed. I decided that I needed to check the BIOS settings. I rebooted the computer, went into the BIOS, and started to check things out. Very quickly I found that someone had disabled the network card. I was pleased that was the problem, it is easy to fix. When I went to re-enable the network card the BIOS informed me that I needed the BIOS administrators password before I could do anything. I had never set a password. I then had to very quickly figure out how to set the password so I could help the teacher.