Client Management Suite

Can someone help me to get a report that shows all computers and associated mac addresses with each?  

Thanks

Check this thread

https://www-secure.symantec.com/connect/forums/mac-address-query

I saw that link but it doesn't really address how to create a report in CMS 7 showing each machine with it's mac addresses.  Thanks anyway.

This SQl report we use may help you, it will display multiple rows for each computer where there is more than one interface:

SELECT DISTINCT vc.Guid, vc.Name, IP.[IP Address], IP.[MAC Address],

IP.[Subnet Mask], IP.[Default Gateway], vc.[OS Name], vc.[OS Version], va.Status, va.Manufacturer, va.Model, va.[Serial Number]

FROM dbo.Inv_AeX_AC_TCPIP as ip

Left Outer JOIN

dbo.vComputer as vc ON IP._ResourceGuid = vc.Guid INNER JOIN

dbo.vAsset as va ON vc.Guid = va._ResourceGuid

ORDER BY vc.Name, IP.[IP Address]

I did right click on reports, new SQL report and put that in under parameterized query but am getting

"This DataSource is not in a runnable state."

Am I doing something stupid?

You may have left the security scoping code in the report when you pasted the other report?

Try clearing everything in the Parameterized Query box and pasting in this:

DECLARE @v1_TrusteeScope nvarchar(max)

   SET @v1_TrusteeScope = N'%TrusteeScope%'

SELECT DISTINCT vc.Guid AS [_ItemGuid], vc.Name, IP.[IP Address], IP.[MAC Address],

IP.[Subnet Mask], IP.[Default Gateway], vc.[OS Name], vc.[OS Version], va.Status, va.Manufacturer, va.Model, va.[Serial Number]

FROM dbo.Inv_AeX_AC_TCPIP as ip

Left Outer JOIN

dbo.vComputer as vc ON IP._ResourceGuid = vc.Guid INNER JOIN

dbo.vAsset as va ON vc.Guid = va._ResourceGuid

WHERE

   (

      (ip._ResourceGuid IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))

   )

ORDER BY vc.Name, IP.[IP Address]

Clear the paramertized query before pasting the sql code in. The parameters are not required for this report.

@mark and @odami - thanks for the replies, i had cleared the parameterized query completely before pasting anything in.

I tried both code suggestions, but both resulted in "This DataSource is not in a runnable state."  

You haven't got Asset Management Suite installed so no vAsset.

You still get MAC address without those columns, don't forget to add the TrusteeScope as a Query Parameter:

DECLARE @v1_TrusteeScope nvarchar(max)


   SET @v1_TrusteeScope = N'%TrusteeScope%'


SELECT DISTINCT vc.Guid AS [_ItemGuid], vc.Name, IP.[IP Address], IP.[MAC Address],


IP.[Subnet Mask], IP.[Default Gateway], vc.[OS Name], vc.[OS Version]

FROM dbo.Inv_AeX_AC_TCPIP as ip


Left Outer JOIN


dbo.vComputer as vc ON IP._ResourceGuid = vc.Guid

WHERE


   (


      (ip._ResourceGuid IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))


   )


ORDER BY vc.Name, IP.[IP Address]

Thanks this worked great!  I wish reporting was more intuitive for people not familiar with the tables, etc.

There's always IT Analytics, a couple of good articles have been posted recently:

http://aka-community.symantec.com/connect/pt-br/articles/reporting-options-it-analytics-71

http://www.symantec.com/connect/articles/integrating-custom-inventory-data-it-analytics-71