locked
Adding IPaddress column in Computers with a specific file Query RRS feed

  • Question

  • Hi,

    I am trying to use a builtin query for finding Computers with a specific file. I now want to add an additional column to display IP address. I googled a little bit and found that SYS.Netbios_Name0 will give netbios name and i did not get any results for getting IP Address. Can someone help me to do this ?

    thanks in advance

     

    • Moved by Garth JonesMVP Thursday, November 8, 2012 1:53 AM This is more of a reporting question. (From:Configuration Manager 2007 Inventory)
    Saturday, January 29, 2011 7:29 AM

Answers

  • Well.. This will point you in the right direction but you have been warned that this will cause you issues. Sometime you have to go back to the requester and say "No, this does not make sense and here is why."

    http://smsug.ca/blogs/garth_jones/archive/2011/01/23/why-you-should-not-use-ip-address-data-in-a-report.aspx

     


    http://www.enhansoft.com/
    Saturday, January 29, 2011 6:31 PM
  • Whenever I hear someone who asks me for a report that includes IP address, they usually say that it is so that they can work out the location of the clients.  However, displaying AD sites might be a better option if your AD sites have good descriptions.  And you cannot have multiple values for AD site, so keeps the report simple.
    Regards,
    Tom Watson,
    E-Mail: Tom_...@...
    Blog: http://myitforum.com/cs2/blogs/tom_watson
    Monday, January 31, 2011 2:36 PM

All replies

  • Hi,

    Can you paste the query code in your reply, then it will be easier to assist you.


    Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund
    Saturday, January 29, 2011 7:48 AM
  • Hi,

    Please find the below SQL Statement I am trying to use.

    select SYS.Netbios_Name0, SYS.User_Name0, SF.FileName, SF.FileDescription, SF.FileVersion, SF.FileSize, SF.FileModifiedDate, SF.FilePath
    From v_GS_SoftwareFile SF
    join v_R_System SYS on SYS.ResourceID = SF.ResourceID
    Where SF.FileName LIKE @variable
    ORDER BY SYS.Netbios_Name0

     

    Saturday, January 29, 2011 8:04 AM
  • I would never add IP address to this report as it will mean that you will receive lots of extra rows one for each IP address a PC has. In many cases that could be 5+ extra rows for each file! Why do you need IP address, when you have PC name?


    http://www.enhansoft.com/
    Saturday, January 29, 2011 4:06 PM
  • It is a requirement that I should display IP Address instead of machine name i.e, SYS.Netbios_Name0 . Please help.
    Saturday, January 29, 2011 5:33 PM
  • Well.. This will point you in the right direction but you have been warned that this will cause you issues. Sometime you have to go back to the requester and say "No, this does not make sense and here is why."

    http://smsug.ca/blogs/garth_jones/archive/2011/01/23/why-you-should-not-use-ip-address-data-in-a-report.aspx

     


    http://www.enhansoft.com/
    Saturday, January 29, 2011 6:31 PM
  • open resource Explorer of computer and look under hardware-->network adaper configutation--> IP address .I use IP enabled='1' in the query to get single values for IP address  since,my environment has a unique value with IP enabled option.

     Look at this report how you can use http://eskonr.com/2010/12/sccm-report-to-list-computers-with-ip-address-with-their-subnets-from-given-collection/ 


    My Blog @ www.eskonr.com

    Monday, January 31, 2011 7:59 AM
  • Whenever I hear someone who asks me for a report that includes IP address, they usually say that it is so that they can work out the location of the clients.  However, displaying AD sites might be a better option if your AD sites have good descriptions.  And you cannot have multiple values for AD site, so keeps the report simple.
    Regards,
    Tom Watson,
    E-Mail: Tom_...@...
    Blog: http://myitforum.com/cs2/blogs/tom_watson
    Monday, January 31, 2011 2:36 PM
  • You can modify the query to list only one IP per machine (and not list the machine names) and you could even go a step further by making sure it equals the first one, two, or three octets to ensure you get the intended IP address (instead of a WLAN or 0.0.0.0, etc). 

    Anyways only using IP addresses for reports will cause some headaches in that a lot of the usefulness of the canned reports revolves around machine names. 

    Wednesday, February 2, 2011 11:21 PM