Identifying if a device was brought from Active Directory Import, found via Network Discovery, or sending Basic Inventory
book
Article ID: 184144
calendar_today
Updated On:
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