Video Screencast Help
Endpoint Management Community Blog
Showing posts tagged with Reporting
Showing posts in English
Ives Ledegen | 08 Mar 2007 | 0 comments

I've noticed when using the Altiris Report Builder and adding user accounts to a report I sometimes end up with incorrect information. The reason is the Report Builder allows you to make a link between tables where information is not unique. This introduces some randomness into the relationship between the two tables and can result in unexpected results.

For Example:

Check out the results I get when I run this query and view the results using a query analyzer:

SELECT PU.*, PC.[Name]
FROM Inv_AeX_AC_Primary_User PU
INNER JOIN vComputer PC ON PC.[Guid]=PU.[_ResourceGUID]
WHERE PC.[Name]= 'pc_names_goes_here'


stebro | 26 Jan 2007 | 1 comment

Here's another very cool feature of Endpoint Security Solutions -- the reporting of files being copied to removable media.

As cool as this feature is, there is some confusion surrounding it. Read on to get a clear picture.

Removable Media Reporting

ESS focuses on data leakage which explains the approach the product takes. As of the 6.0 release, ESS reports file copies or moves to a removable storage device: USB flash drive, IPod, Fireware drive, etc.

On a related note, files burned to CD or DVD are not currently reported. Do not confuse removable storage with optical devices. The control settings are separate in a policy with only reporting options available for removable storage devices.

eorme | 15 Jan 2007 | 0 comments

Suppose you have a server that is having some heat issues or perhaps other problems that are related to its onboard sensors. If that server has a BMC (Base Management Controller), you can monitor its sensor values from any machine on its subnet in real time using sensor.exe included with Deployment Solution for Dell Servers.

I will use the example of monitoring the fan speed on a given server. First, I open a command prompt and browse to my Dell Directory (usually C:\Program Files\Altiris\eXpress\Deployment Server\Dell)

I then go into atools\power\ipmiutil

Inside that folder is a utility called sensor.exe. Using the following command I can print out all sensor values:

sensor -U root -P calvin -N

I then get a long printout of each sensor. I look through the list and locate the one I'm...

Dieselboi | 03 Jan 2007 | 1 comment

I have multiple leases associated with multiple resources. I have an Altiris report that will list which leases are due in X amount of days. I would like to expand that to actually list the resources associated with a lease that expires in X amount of days. How would I proceed with this? Ultimately, we would have these sent out as emails to remind us when systems are coming due. Thanks.

The following are some basic steps that I have used to accomplish this request.

  1. Browse to Reports tab > Assets and Inventory > Contract Management > Contract > and locate the report "Contracts Expiring in N Days."
  2. Right-click on the report and click "Clone" to make a copy of the report.
  3. Edit the report and under Global Parameters edit the Days Value from 1 to "60, 90, 120, etc." and also uncheck "Prompt user for value when report is run.
  4. Now, under Tasks you can create...
kyle_campbell | 29 Nov 2006 | 7 comments

Inventory Solution comes with a report that searches for Web Browsers that are installed on Clients. If you run the report, however, it doesn't show PCs with the newly released IE7. The reason is Microsoft got tricky and changed the naming a little bit.

What you need to do is make a clone of the query "Count of Computers by Browser, Version (Including IE7) and OS" located under: Reports Tab -> Assets and Inventory -> Inventory -> Windows -> Software/Applications -> Web Browsers. Then modify the level 0 query by locating the lines in the WHERE clause that searches for the browsers. The last line will look like this:

(UPPER(csw.ProductName) = ''INTERNET EXPLORER*''))

The modification you need to make to the query is to add an additional line after the "INTERNET EXPLORER*" search so that the last two...

John Doyle | 06 Oct 2006 | 7 comments

The HISTORY_LIST macro allows you to create a HTML table in e-mails that you send out from the Helpdesk containing the complete history of a workitem.

The following example, taken from the reference manual, shows how to create a simple table.


This table will contain the version number, the modification date and the name of the worker that modified the incident.

We can use the same format to output the comments:


However, if this is used in an e-mail to the users, they will see all the comments added to the incident including ones which were set as not visible to guests. In order to remove these comments I came...