Video Screencast Help
Endpoint Management Community Blog
Showing posts tagged with Database
Showing posts in English
cnpalmer75 | 09 Aug 2007 | 0 comments

The AMS & CMS suites are probably the two most widely used combination of products available from Altiris. Once you've been working with them for a while, there comes a time in every boy's life where he needs to start looking under the hood.... Now I'm not talking about the whole birds & the bees thing. You're at the wrong website if you're looking for that information. I'm talking about how AMS & CMS all tie together on the back-end. This article is extremely helpful in painting that picture for you.

It represents each solution and shows the associated & related tables for each. The only drawback here is that the relationship between the tables is not depicted and that is because the Altiris DB is not a true relational DB, its more of a collection of tables that relies on the front-end console & interface to tie them all together. Either way, this is a very good reference when trying to figure out where to pull data from when writing reports. So take...

SK | 11 Jul 2007 | 1 comment

You all probably know that the AeXConfig.exe utility is used to run the database installation and removal side of our [Altiris] product installs, but did you also know that it can be used to install licenses, change the AppId, etc?

Here's the tool's full syntax. Knowing this is the first step to AeXConfig nirvana:

[/svcid user:<user name> password:<password>]  Sets the Application Identity
[/db dbserver:<server name> dbname:<database name> dbusername:<db user name> dbpassword:<db user password> dbtimeout:<db timeout>]  Database credentials
[/configure <Path to product installation xml file>]  Configure the database side of a product install
[/unconfigure <Product installation GUID> [/deleteitems] ]  Remove products database objects
[/installlicense <Path to license file>]  Installs licenses
[/validate <ProductInstallationConfigFile>]  Validate a product install
[/launchinstallwizard]  Opens http...
snowjgj | 21 Jun 2007 | 0 comments

A common problem people notice when building reports with the simple report builder using the asset type of "Computer" is that virtual machines do not show up in the results of the report. Here's a way to work around that problem.

Some Background Info

Inventory Solution 6.1 SP 1 introduced the Virtual Machine classification of machines. This means that any virtual machine that was previously displayed as a "Computer" will instead show as the new "Virtual Machine" classification of device.

When a user creates a new report using the simple report builder and clicks the finish button, the followinn piece of SQL code is appended to the query generated:

where/and 
[ResourceTypeGuid]  = '493435f7-3b17-4c4c-b07f-c23e7ab7781f'

The "where" exists if no other criteria have been defined otherwise "and" will be in its...

Scott Hardie | 13 Jun 2007 | 0 comments

If you ever wanted or needed to reset your Helpdesk Incidents back to start at 1 because of testing or an overhaul, you can do so by launching SQL Enterprise Manager or Microsoft SQL Server Management Studio (depending on your SQL version) and edit the Altiris_Incidents database by editing table workitem_next_number and changing the value to 0.

BRING | 31 May 2007 | 0 comments

No one likes to see too much fat anywhere. It is great when it lightly surrounds a New York strip steak, or slowly tenderizes a roast, but not in too many other places. It definitely does not belong in SQL transaction logs.

Unfortunately, some transaction logs get bigger and bigger, some by gigabytes a day, or even in hours. This is usually indicative of a problem.

The Altiris KB article entitled "Why is the SQL Transaction Log growing by Gigabytes Daily?" and found at https://kb.altiris.com/article.asp?article=35211&p=1
outlines one way that this can happen, and how to keep it from happening in the future.

SK | 29 May 2007 | 0 comments

Scott Wedekind, a member of the Altiris SWAT Team, has created a cool tool that will tell you which Altiris products have been installed onto a Notification Server (NS) as well as allow you to compare that report with similar results from other Notification Servers.

Please refer to https://kb.altiris.com/article.asp?article=32508&p=1 for full details as well as to obtain this very cool tool.

Joel Smith | 23 May 2007 | 0 comments

How does the Software Portal manage Tasks and Collections for Software Requests?

Get answers to these modern mysteries and a few extras thrown in for good measure.

Collections and Tasks
The Software Portal Creates hidden Tasks and Collections to manage the distribution of Requested Software to the target system.

Request Versus Deployment
When accessing the Software Portal, the Portal is constructed based off the Logged On User. The available packages are those the user had rights to within the Software Portal. Deployment Software switches the focus from the Logged On User to the Computer from where the request was initiated from.

Items created by a Software Portal Request

  • The Software Delivery Solution Agent (AeXSWDAppReqAgent.dll) contacts the Notification Server to have the items created.
  • A Task with the naming convention: Software Request: is created. For example, to bring back every...
SK | 01 May 2007 | 1 comment

Hello all,

I would like to make you aware of an issue I have experienced which also seems to be a problem with many other SQL Server 2005 users as well.

I installed SQL Server 2005 on two different Servers using the same installation files as well as the same installation configuration.

When opening the Database Tuning Advisor on both machines, I found that it connected successfully on one of them but failed to connect on the other as it could not find a require Stored Procedure.

Upon further investigation, I found that this SQL Server did not have any DTA Tables nor Stored Procedures.

For full details as well as the resolution to this problem, please refer to KBA34616.

https://kb.altiris.com/article.asp?article=34616&p=1

EWANG | 07 Mar 2007 | 2 comments

One of the best ways to learn how to create a customized report is to get familiar with the Altiris Database. The steps in this tip were written to get you started on the road to custom report creation.

Let's try to build a report from the simple report template. We'll use "Computer Asset" as an example.

Figure 1. Report Builder.

Click to view.

Select "Computer" for the Data Type.

Click on the "Fields" link and select the fields you wish to display. (for this scenario I decided to use Domain, Name, and perhaps IP address).

Figure 2. Field Selection...

BRING | 24 Jan 2007 | 0 comments

It can really be tough when you want to get your Patch Management system upgraded to the latest version, Patch 6.2. Especially if, throughout the history of your Altiris database, you have moved it, restored it, etc. without using the Altiris AppID account in those procedures.

Make sure that you remember log in as the Altiris APP ID to do any type of database maintenance, when installing or upgrading Patch or other solutions. This will make the upgrades to those solutions much easier.

For specific details on one particular issue, see

http://kb.altiris.com/article.asp?article=32047&p=3

Happy Patching!