Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

RAAD Custom Inventory XML HELP

Created: 27 Feb 2011 • Updated: 08 Aug 2011 | 3 comments
This issue has been solved. See solution.

Hi!

I want to collect info about sub-agents on Managed agents, but can't find HELP about Custom Inventory XML.

where can I read about it?

Thanks

Comments 3 CommentsJump to latest comment

Cesar_echeverria's picture

This SQL query can help you, you can also use in the SMP report

 

SELECT dbo.vComputer.Guid, dbo.vComputer.Name, dbo.vComputer.Domain, dbo.vComputer.[User], dbo.vComputer.[IP Address], dbo.Inv_AeX_AC_Client_Agent.[Agent Name],

dbo.Inv_AeX_AC_Client_Agent.[Product Version], dbo.Inv_AeX_AC_Client_Agent.[Build Number], dbo.Inv_AeX_AC_Client_Agent.[Install Path],

dbo.Inv_AeX_AC_Client_Agent.[Agent Class Guid], dbo.Inv_AeX_AC_Client_Agent.[64 Bit]

FROM dbo.vComputer LEFT OUTER JOIN

dbo.Inv_AeX_AC_Client_Agent ON dbo.vComputer.Guid = dbo.Inv_AeX_AC_Client_Agent._ResourceGuid

where dbo.vComputer.ismanaged = '1'

order by dbo.vComputer.Name,dbo.Inv_AeX_AC_Client_Agent.[Agent Name]

Cesar Echeverria Castillo

Consultant Engineer

InterLAN Ltda, Medellin, Colombia

P.S.: If this works please let the community knows about it.

alramin's picture

Thanks! But I want collect info directly from agents.

KSchroeder's picture

Hello alramin,

Have a look at the Custom Inventory Samples KB articles and how-tos here: HOWTO9148, HOWTO10707 (each for NS6 custom inventory, which I believe is what RAAD wants), or have a look at HOWTO10487 and HOWTO10488 which are NS7/IS7-specific.

Thanks,
Kyle
Symantec Trusted Advisor

For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.

SOLUTION