Report for Network Related Information

Products

• Client Management Suite

Issue/Introduction

You would like to have a report that reflects the information shown in the Network tab of the Hardware Resource Manager section for all computers.  

 

Environment

Release: 8.6

Resolution

When viewing this information in the SMP console, the following query is executed:  

EXECUTE spGetBasicPageNetworkSection @resourceGuid='e6e4801e-98b3-436f-bcce-832e1ba6ccdb'

The resourceGuid is the GUID of the computer you're looking at.

Further queries are available for your review here:  Resource Manager Home Page Queries

This is great for one-off situations, but if you the need to have a report that shows all computers, you can use the following:

If you only care about TCPIP v4, you can use the following:

select vc.[Name], [Device], a.[MAC Address], a.[IP Address], a.[DHCPEnabled], a.[Subnet Mask], 
		a.[Subnet], a.[Default Gateway], a.[DNS Server 1], a.[DNS Server 2], a.[DNS Server 3],
		[Primary WINS Server], [Secondary WINS Server]
	from vRM_Network_Resource r
		LEFT OUTER JOIN Inv_AeX_AC_TCPIP a ON a._ResourceGuid = r.Guid 
		LEFT OUTER JOIN Inv_AeX_AC_Identification i on r.Guid = i._ResourceGuid
		join vcomputer vc on vc.Guid = r.Guid

If you would like to also include the TCPIP v6 information, you can use the following:

select vc.[Name], [Device], a.[MAC Address], a.[IP Address], a.[DHCPEnabled], a.[Subnet Mask], 
		a.[Subnet], a.[Default Gateway], a.[DNS Server 1], a.[DNS Server 2], a.[DNS Server 3],
		[Primary WINS Server], [Secondary WINS Server]
	from vRM_Network_Resource r
		LEFT OUTER JOIN Inv_AeX_AC_TCPIP a ON a._ResourceGuid = r.Guid 
		LEFT OUTER JOIN Inv_AeX_AC_Identification i on r.Guid = i._ResourceGuid
		join vcomputer vc on vc.Guid = r.Guid
	
	union
	select 
		vc.[Name], [Device], ipv6.[MAC Address], ipv6.[IP Address], [DHCPEnabled] = 0, [Subnet Mask] = '', 
		[Subnet] = '', [Default Gateway] = '', ipv6.[DNS Server 1], ipv6.[DNS Server 2], ipv6.[DNS Server 3],
		[Primary WINS Server] = '', [Secondary WINS Server] = ''
	from vRM_Network_Resource r
		RIGHT OUTER JOIN Inv_AeX_AC_TCPIPv6 ipv6 ON ipv6._ResourceGuid = r.Guid
		LEFT OUTER JOIN Inv_AeX_AC_Identification i on r.Guid = i._ResourceGuid
		join vcomputer vc on vc.Guid = r.Guid

This data returned using this query will show duplicates.  These are not truly duplicates, rather, it's showing you computers that have multiple network cards.

You can save the SQL query listed above into a new SQL report on your SMP server to create the report if desired.