locked
Adding v_GS_NETWORK_ADAPTER.MACAddress0 to sms_def.mof RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have a sccm 2007 report with v_GS_NETWORK_ADAPTER.MACAddress0.  But when I run it I get the error

    An error occurred when the report was run. The details are as follows:

    The multi-part identifier "v_GS_NETWORK_ADAPTER.MACAddress0" could not be bound.

    Error Number:

    -2147217900

    Source:

    Microsoft OLE DB Provider for SQL Server

    Native Error:

    4104

    What would the entry in the sms_def.mof look like?  We are setting up sccm 2012 in a lab, which has a configuration.mof, instead of sms_def.mof.  Are these compatible? I tried looking for MACAddress, but didn't find it.  I was hoping to copy the entry over to sms_def.mof.  Is there an editor to do this in sccm 2007.  It sure is an easy process in sccm 2012.

    Thanks again,

    Mark

    Tuesday, August 6, 2013 6:15 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    You don't have to do anything custom for mac address. Just open the sms_Def.mof and search for mac address. It may simply be set to false.

    John Marcum | http://myitforum.com/myitforumwp/author/johnmarcum/

    Tuesday, August 6, 2013 7:11 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    You don't have to do anything custom for mac address. Just open the sms_Def.mof and search for mac address. It may simply be set to false.

    John Marcum | http://myitforum.com/myitforumwp/author/johnmarcum/

    Tuesday, August 6, 2013 7:11 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Have you verified that the data does not exist in the DB?  MAC Address on the primary NIC is data I would expect by default in SCCM inventory.

    I would use SQL Studio to look at the data in the v_GS_NETWORK_ADAPTER table.

    You could have a SQL issue rather that a MOF data collection issue.

    Tuesday, August 6, 2013 10:10 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I searched through and changed every entry of macaddress to true and still get the same error.  I made the change yesterday and tried the report today.

    Thanks,

    Mark

    Wednesday, August 7, 2013 11:54 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    How often is you Hardware inventory reporting?

    Use this blog post to troubleshot Hardware inventory. http://be.enhansoft.com/post/2013/07/25/Troubleshooting-Inventory-Flow.aspx

    http://www.enhansoft.com/

    Wednesday, August 7, 2013 12:04 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Every 1 days.  But why do I have the error?

    Thanks,

    Mark

    Wednesday, August 7, 2013 12:13 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Have you confirm that any of the clients are reporting the change? When you made the edits to the SMS_def.mof are you sure that it is right.

    You only need to change one field only within the sms_def.mof. This assume that the field was not enabled in the first place.

    http://www.enhansoft.com/

    Wednesday, August 7, 2013 12:41 PM