Video Screencast Help

Dashboard report for Altirs CMS

Created: 19 Dec 2013 | 4 comments

Hi All

I'm designing report for Altiris .So on Altiris can we build one dashboard report like chart for total of machine install Agent, install Windows patch


Operating Systems:

Comments 4 CommentsJump to latest comment

Anton_Nejolov's picture


What you mean about "install Windows patch", for example?

telecomvn's picture

Hi Anton

I mean chart on dashboard report like how many machine install Windows patch, how many machine install agent,chart show total of machine is not connect to NS server for along time

Can we do that?


Anton_Nejolov's picture

SQL Query to find machines with Software Update Plug-in installed (Install Patch Agents):

select * from Inv_AeX_SWD_Execution_Summary
where AdvertisementName LIKE '%Software Update Plug-in%'

Inactive machine you can find in "Inactive Machines" report (Reports -> Discovery and Inventory -> Inventory -> Cross-Platform -> Inventory Agent -> Inventory Capture)

Or use the Qeuries suggested in this connect topic

SK's picture

There are many summary reports that you can add to a view as a web part.

If you are looking for agent/plug-in installs, you should use the Inv_AeX_AC_Client_Agent table, as it is populated by basic inventory and contains all of them.  It will also contain the SWVAgent if it was installed using the NS parameter, as well as DS 6.9 & earlier AClient/DAgent.

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.