Video Screencast Help
Endpoint Management Community Blog
Showing posts tagged with Altiris Client Management Suite
Showing posts in English
Eshwar | 13 May 2008 | 5 comments

You can find whether a software package is installed on computers on you network by querying the [Inv_AeX_OS_Add_Remove_Programs] table.

Here's how to find the machine name by joining the [Inv_AeX_AC_Identification] table.

QUERY:

SELECT DISTINCT(ACI.[Name]) AS 'Machine Name', ACI.[Domain] AS 'Domain', ARP.[Name] AS 'Application Name'
FROM  [Inv_AeX_AC_Identification] ACI 
INNER JOIN [Inv_AeX_OS_Add_Remove_Programs] ARP 
ON ACI.[_ResourceGuid] = ARP.[_ResourceGuid] 
WHERE ARP.[Name] LIKE '%Application Name%' 
ORDER BY ACI.[Name]

Eshwar | 12 May 2008 | 1 comment

Did you know you could retrieve hardware serial numbers and memory module information from your Inventory Solution data? It's possible by joining [Inv_AeX_HW_Serial_Number] and [Inv_AeX_HW_Memory_Modules] tables with [Inv_AeX_AC_Identification].

Here's the syntax:

QUERY:

SELECT DISTINCT(ACI.[Name]) AS 'Machine Name', AHS.[Serial Number] AS 'Serial Number', MM.[Size], MM.[Type]
FROM [Inv_AeX_AC_Identification] ACI
INNER JOIN [Inv_AeX_HW_Serial_Number] AHS ON ACI.[_ResourceGuid] = AHS.[_ResourceGuid]
JOIN [Inv_AeX_HW_Memory_Modules] MM ON MM.[_ResourceGuid] = ACI.[_ResourceGuid]  
ORDER BY ACI.[Name]

vortex0007 | 07 May 2008 | 0 comments

Active Directory and Altiris Notification Server seem to have a love hate relationship. The Active Directory connector loves to import user names and computer names, but it hates to do anything related to group membership. A common request has been the ability to incorporate user group information from Active Directory into collections in order to allow user based software delivery. In other words, install Quickbooks to all of the users who are in the Accounting OU. This tip steps through how to accomplish this.

The first step is to create a connection between the Microsoft SQL Server hosting the Altiris databases and the Active Directory. This is accomplished through a SQL concept known as "Linked Servers." There is a bit of black magic to making linked servers work and a full technical drill down into how they work is beyond the...

WiseUser | 01 May 2008 | 0 comments

Definition: A user profile is a group of settings and files that defines the environment that the system loads when a user logs on.

It includes all the user-specific configuration settings, such as program items, screen colors, network connections, printer connections, mouse settings, and window size and position.

How to copy the files to user profiles using wise script

A Profile can be roaming profile or a local profile.

We have to search for the following registry value to get hold of users My documents or app data folders.

Profile whose user profile is redirected to H :\

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders]
"AppData"="C:\\Documents and Settings\\{USER}\\Application Data"
"Cookies"="C:\\Documents and Settings\\{USER}\\Cookies"
"Desktop"="H:\\...
Terry Cutler | 30 Apr 2008 | 1 comment

In connection with Joel's article on Improving Load Performance in Real-Time Systems Manager, the following VBscript provides a shortcut to opening an RTSM page for a system.

REM Use to connect to Altiris system using RTSM

strAnswer = InputBox("Please enter the computer name of the system you wish to manage:","RTSM Quick View")

If strAnswer = "" Then
Wscript.Quit
Else
StrUrl = "http://localhost/Altiris/Resource/ResourceManagerConsole.aspx?Name="&strAnswer
Set objShell = CreateObject("Wscript.Shell")
objShell.Run(strUrl)
End If

For the sample script above, replace localhost with the appropriate Altiris NS server name or address. If LocalHost is used, this assumes the utility is being executed on the local system.

Two example screenshots below provide a summary of...

KSchroeder | 29 Apr 2008 | 0 comments

Do you ever look at your Recovery Solution job queue and wonder "I wonder how far along that Integrity Check/SSM job is?" Well I did, and was very frustrated since there wasn't a good way I had found to monitor the progress. Well, by using the following Stored Procedure, you too can find out about the progress of the job.

To install this, just load the attached .SQL file into Query Analyzer (or whatever tool is used in SQL 2005), select your Recovery Solution database, and execute it. It will add the spGetRSJobStatus Stored Procedure (SP) to the database. To run the query, just execute the SP from Query Analyzer:

EXEC spGetRSJobStatus

Note: I just attached a NS report you can use to run this without having to fire up Query Analyzer.

Note that this works best for checking the Integrity Check job's status as...

Terry Cutler | 23 Apr 2008 | 0 comments

Snippets of the keynote, Intel booth, and interviews are now available at the link below. From the humorous guessing of acronyms for vPro, to watching the intense action of the vPro challenge, or in hearing various perspectives on the technology - come enjoy the recap.

http://www.intel.com/go/managefusion

vortex0007 | 22 Apr 2008 | 6 comments

I'm always surprised to find how few customers take advantage of Altiris Inventory Solution's ability to inventory an application's installed serial number. This information can be invaluable when trying to tie copies of applications installed in your environment back to software license agreements.

Each time Altiris Inventory Solution scans are run, the serial numbers for installed applications are captured and stored in the Inv_AeX_OS_Add_Remove_Programs table.

It is impossible for us to list every single application that will report back a serial number properly, but testing in large environments has revealed at least 500 business applications that return this information properly, including most of the business applications from Microsoft, Adobe.

The following SQL query can be run against the Altiris database to find out...

pdeluca | 15 Apr 2008 | 1 comment

Some Microsoft Office Updates need a service to be loaded in workstations. The service name is "Office Source Engine" and in many workstations it is Disabled, so Microsoft Office Patches don't apply or don't work.

Here's a solution.

A good practice is to deploy a registry value that changes this Service to Manual State before Distributing the patches. The "Applicable" number of already distributed patches also change after the distribution of the registry value, so it´s useful to finally increase the "Installed" number.

The registry key and value are:

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ose]
"Start"=dword:00000003

Value:
3 = Manual
4 = Disabled

Simply copy the key and value to a .reg file and use Deployment to apply it inmediately.

TilakGovind | 14 Apr 2008 | 8 comments

There would be some situations where we need to call Batch file from Scripts. Here the script to call INSTALL.bat

  1. Copy the below code to Notepad.
    Function Tilak()
    dim shell
    set shell=createobject("wscript.shell")
    shell.run "INSTALL.bat"
    set shell=nothing
    
    End Function
    
  2. Save the file as .VBS
  3. Then use this VBscript in Wise Package Studio's CustomActions pane.