Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

A little help

Updated: 23 May 2010 | 5 comments
raymond.nickens@hoerbiger.com's picture
+2 2 Votes
Login to vote

Good day, I am trying to get some reports out of Altiris and our disgrutled admin has left with all the books and documentation and I just need some help.  If there are any books out there that explains the reporting features and package creation I would deeply appreciate it.  What I am trying to do is get a list of all machines that are not Vista compliant, but for only certain created containers, any help would be great.  Thanks in advance.

Ray

Comments

Troy's picture
06
Apr
2009
2 Votes +2
Login to vote

Reports

There is a built in report in the console that will give you this information I believe.

AdrianC's picture
07
Apr
2009
3 Votes +3
Login to vote

Sorry to hear that. I've

Sorry to hear that. I've posted a very useful link below.

Altiris Knowledgebase
https://kb.altiris.com

This link is the knowledgebase. Specifically It's the Notification Server (which hosts the reporting system) that you will be interested in for reporting.

Have a look. If you get stuck on something specific ask here. There are plenty of friendly people that'll help.

Eshwar's picture
07
Apr
2009
6 Votes +6
Login to vote

Altiris Reporting

Ray,
I'm currently working on generating Altiris reports from NS Console.

Once you are familiar with Altiris reports creation, try the following SQL query to fetch machine names and OS information.

SELECT  T0.[Name] AS [Machine Name],
               T0.[Domain] AS [Domain Name],
               T0.[OS Name] AS [OS Name],
               T0.[OS Revision] AS [OS Revision],
               T0.[OS Type] AS [OS Type],
               S1.[SiteCode] AS [OU]           
FROM    Inv_AeX_AC_Identification T0
JOIN       Inv_Mon_SM_Machine_Locale S1
ON         S1.[_ResourceGuid] = T0.[_ResourceGuid]             
WHERE  T0.[OS Name] NOT LIKE '%Vista%'
ORDER BY  T0.[Domain]    

The above query will give you the machine names without VISTA operating system on them.

I hope this helps. Letn me know if you need more information.

Thanks,
Eshwar
 

Thanks,
Eshwar

jharings's picture
08
Apr
2009
2 Votes +2
Login to vote

Thanks eshwar

You can further scope your results by adding a collection picker: https://kb.altiris.com/article.asp?article=24744&p=1

Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.

Eshwar's picture
09
Apr
2009
3 Votes +3
Login to vote

TRUE

You are right  Jim.
Whenever there is a need, I use "Collection picker" for computer collections. Otherwise i use dropdown list. 

Some time back i created an altiris report [we call it "Life Cycle Management Report"] which will sort out compliant and noncompliant machines.

We have a standard build environment with Windows 2K/2K3 SP2/XP SP2/SP3 OS and other standard softwares. My report will filter compliant and noncompliant machines accroding to the build standards. I used Drop Down lists for components [OS and Software] and compiance [Compliant Machines/Noncompliant machines].

Thanks,
Eshwar