Identifying if a device was brought from Active Directory Import, found via Network Discovery, or sending Basic Inventory

Products

• IT Management Suite

Issue/Introduction

Is there a way to distinguish among machines that are loaded from Active Directory,  found via Network Discovery, and machines that are reporting based on having the version of the Symantec Management Agent (aka Altiris Agent)  installed?

Resolution

Answer

You should be able to "distinguish among machines that are loaded from Active Directory,  found via Network Discovery, Domain Discovery, and machines that are reporting based on having the Altiris Agent installed" using a series of queries using some joins.

All active computers will fall into the vComputer table. AeX_AC_Discovery contains the computers that were discovered via "Domain Discover", Browse List and "Network Discovery". AeX_OU_Membership would give you the computers found via active directory import and snmpdiscoveredmachines contains a list of computers found using "Network Discovery". The AeX_AC_Client_Agent will contain the versions of Altiris Agent installed on these computers. Of course, this information comes up from "Basic Inventory".

 

The following query is just an example. If the first DataClass that is returned is "AeX AC Discovery", then you can narrow down that it was brought from a network discovery for example:

 

select 
c.Name ComputerName, 
dc.Name DataClassName, 
    rus.[RowCount], 
    rus.CreatedDate, 
    rus.ModifiedDate, 
    rus.DataLastChangedDate, 
    c.Guid ComputerGuid, 
    dc.Guid DataClassGuid
from ResourceUpdateSummary rus
join vRM_Computer_Item c on c.Guid = rus.ResourceGuid
join DataClass dc on dc.Guid = rus.InventoryClassGuid
where c.Name like '%xClient123%'  --add the computer name here
order by c.Name, rus.CreatedDate asc