I need the solution about altiris report, from where i can get the data of Mac Address with hostname?
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!
Please mark your thread as 'SOLVED' with the answer that helps you.
Check this SQL query
Check the Forum
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]