Login to participate
Endpoint Management & Virtualization DownloadsRSS

Custom Inventory to Gather AD "Description" Field

KSchroeder's picture

On a recent forum thread, durkinr asked for a way to report on the "Description" found on his computer objects in Active Directory.  I put together the attached custom inventory XML file and a VBScript to populate the information into the registry.  To use this:

  1. Put both files in your Inventory Solution package (\\NSServer\NSCap\Bin\Win32\X86\Inventory Solution\)
  2. Update the AeXInvSolnAdm1.ini file (after making a backup first of course!) by adding the following two lines prior to the last line with AeXNSInvCollector.exe:
    wscript.exe //B GetADDescription.vbs
    aexcustinv.exe /in .\AeXADCompDesc.xml
  3. Save the AeXInvSolnAdm1.ini file

On the next update of the Inventory package and execution of that inventory task, you will begin gathering this data.  It will show up in the database in a table called "Inv_AeX_AD_Comp_Desc".  For a simple report utilizing this data:

SELECT vc.[Name], vc.[Domain], vc.[User], ad.[Description]
FROM vComputer vc
JOIN Inv_AeX_AD_Comp_Desc ad
ON vc.[Guid] = ad[._ResourceGuid]
ORDER BY vc.[Name] ASC

Hopefully this will come in handy for you if you do a lot of management of your computer objects within Altiris, or would like to report on them.