Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

Altiris report

Created: 13 Jun 2013 • Updated: 15 Jun 2013 | 5 comments
This issue has been solved. See solution.

I need the solution about altiris report, from where i can get the data of Mac Address with hostname?

Comments 5 CommentsJump to latest comment

Ambesh_444's picture

Hi,

When you navigate to Manage->Computers do you have the blue Silverlight UI?  If so, select All Computers and then next to the search field in the second column, select the little chevron to show the option "Add Search Criteria."  Click on it, and the select "Add Custom Criteria...."  When the windows comes up, under DataClasses, look for AeX AC TCPIP.  Select the box next to it.  On the ride hand side, under Columns, you should now see lots of different column names under AeX AC TCPIP.  Select the column "MAC Address."  Hit OK and the window should disappear.  Now, select Add Search Criteria again and choose "MAC Address" from the list of options.  In the empty white field, input the MAC Address for which you are searching.

*Note, if you navigate away from this page, the MAC Address custom search criteria will be removed.  Hit the blue "Save" icon so that you can easily search for this in the future.

Hope this helps!

 

Thank& Regards,

Ambesh

"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."

SOLUTION
Sachin Sawant's picture

try this query,

SELECT dbo.Inv_AeX_AC_Identification.[Name][Host Name]
, dbo.Inv_AeX_AC_Identification.[Os Name]
, dbo.Inv_AeX_AC_Identification.[System Type]
, dbo.Inv_AeX_AC_TCPIP.[MAC Address]
FROM
dbo.Inv_AeX_AC_Identification,
dbo.vHWComputerSystem,
dbo.Inv_AeX_AC_TCPIP
WHERE
dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_AeX_AC_TCPIP._ResourceGuid