Video Screencast Help
Endpoint Management Community Blog
Showing posts tagged with Altiris Server Management Suite
Showing posts in English
robertser | 09 Sep 2008 | 1 comment

It is nice to be able to see who the primary user is in a report. Since the Primary User table is based on a given month you have to add that as a parameter to every report you want to see Primary User on.

With this SQL view you can easily join it to your custom reports and always have the Primary User for the current month without having to create parameters.

Copy the below code into a new view in your Altiris database. Name it something easy like vw_PC_to_PrimaryUser.

SELECT DISTINCT _ResourceGuid AS 'Guid', Month, [User], Domain
FROM     dbo.Inv_AeX_AC_Primary_User
WHERE   (Month = DATENAME(Month, GETDATE())) AND ([User] <> '')
SELECT DISTINCT _ResourceGuid AS 'Guid', Month, [User], Domain
FROM     dbo.Inv_AeX_AC_Primary_User AS Inv_AeX_AC_Primary_User_2
WHERE   (Month = DATENAME(Month, DATEADD(Month, -...
Screenbert | 05 Sep 2008 | 2 comments

I recently had someone ask the following after watching this Patch Management Video:

I have my environment ready to go I believe. But I'm wondering about the current Automatic Updates that they currently have. Does PM turn off the native MS auto updates that come down?

Altiris Patch Management does not turn off the Microsoft Automatic Updates. Both can run at the same time and whichever schedule is more agressive is the one that will patch first. If you want to turn this off, then you can use Group Policy to change this setting. You can also change the registry manually using a package through software delivery.

The key that will need modified is:


For the various...

MFINN | 04 Sep 2008 | 0 comments

One of the problems with the canned compliance reports is the lack of easily isolated Service Pack information, so I created a report that allows you to select Windows 2000, XP, or Vista and then filter out the most recent SP for that OS.

  1. Create a new report
  2. Give your report a meaningful name
  3. Enter SQL directly
  4. Copy and paste this SQL into the text box
  5. Click finish (testing won't work here, because we need to create a few parameters first)

*Continued below*

SELECT T0.[Name] AS 'Name', 
T0.[Domain] AS 'Domain', 
T0.[Last Logon User] AS 'Last Logon User', 
T1.[OS Name] AS 'OS Name', 
T1.[Service Pack] AS 'Service Pack' 

FROM [Inv_AeX_OS_Operating_System] T1 
RIGHT OUTER JOIN [Inv_AeX_AC_Identification] T0 
ON T1.[_ResourceGuid] = T0.[_ResourceGuid] 

WHERE T1.[OS Name] LIKE %...
jjesse | 28 Aug 2008 | 0 comments

When creating custom Linux Inventory scripts make sure they are executable or the inventory will not run correctly.

An example would be if the script is cust-genps, run the following command: chmod 755 ./cust-genps from the directory cust-genps is stored in.


CondorMan | 28 Aug 2008 | 0 comments

The DSWeb Console and NS Console require .Net Framework 1.1 to be registered with IIS.

A quick way to fix this (or script this for multiple installs) is to run the following command:

%SystemRoot%\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i -enable

MFINN | 27 Aug 2008 | 2 comments

Here's some SQL that'll query computers with MS Office 2003 without the Office 2007 compatibility pack. Just go to reports, create a new one, and select 'Enter SQL Directly', then copy and paste the sql into there.

SELECT T0.[Domain] AS 'Domain', T0.[Name] AS 'Name',
T0.[OS Name] AS 'OS Name', T1.[Name] AS 'Name' FROM 
[Inv_AeX_AC_Identification] T0 INNER JOIN 
[Inv_AeX_OS_Add_Remove_Programs] T1 ON 
T0.[_ResourceGuid] = T1.[_ResourceGuid] WHERE T1.[Name] 
LIKE 'Microsoft Office%' AND T1.[Name] LIKE '%Edition 
2003%' AND T0.[Name] NOT IN (SELECT T0.[Name] AS 'Name'
FROM [Inv_AeX_AC_Identification] T0 INNER JOIN 
[Inv_AeX_OS_Add_Remove_Programs] T1 ON 
T0.[_ResourceGuid] = T1.[_ResourceGuid] WHERE T1.[Name] 
LIKE 'Compatibility Pack for the 2007 Office system')

piyushnasa | 27 Aug 2008 | 5 comments

Many times I come across articles, where people discuss on which to choose WISE Script or VBScript while creating Custom Action in the package. Here are some advantages and disadvantages of both.

While WISE Script is easy to make, I mean takes less effort, VBScript can be very complicated. People who do not know VBScript often find themselves searching for, and copying code from net. WISE Script can be easily written once you have basic understanding of statements. I give this point as an advantage to WISE Script, but people who know how to code in VBScript, will always choose that as an easy option.

Personally, I prefer VBScript over WISE Script because it has some really good advantages. As you might know, we compile WISE Script to an exe and include that in a package. But in doing this, we lose the code which we have written...

sm4rt | 26 Aug 2008 | 0 comments

Some files or attributes are excluded in the Special Group. File names at the end of the list are not being captured. This useful article will show you the solution.

CondorMan | 25 Aug 2008 | 1 comment

To silently install .Net Framework 2.0 with SP1, follow these two steps.

  1. Download NetFx20SP1_x86.exe from Microsoft
  2. Distribute NetFx20SP1_x86.exe via Deployment Server or Software Delivery Solution with the command-line parameters: /q /norestart

If the silent install finishes with return code 3010, that means that a reboot is required.

CondorMan | 25 Aug 2008 | 0 comments

If you need to silently install the .Net Framework 1.1 to multiple computers, you can follow these two simple steps.

  1. Download the Microsoft .NET Framework Version 1.1 Redistributable Package (dotnetfx.exe)
  2. Crete a Software Delivery Task or Deployment Server Distribute Software Task that runs dotnetfx.exe with the command line parameters: /q:a /c:"install /q"