Custom Inventory to Gather AD "Description" Field
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:
- Put both files in your Inventory Solution package (\\NSServer\NSCap\Bin\Win32\X86\Inventory Solution\)
- 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 - 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.