Answered by:
Display IP Address in Collection view

Question
-
Hy!
I need modify collection view to display IP Address, but i can't do it.
I create a new collection from a custom query that includes IP address but the view don't show it.
The final idea is look/find (inside this collection) computers by IP and/or name.
Any ideas, how to do?
Regards, RenéThursday, February 12, 2009 2:50 PM
Answers
-
The answer (for clarity) is:
You *cannot* change what attributes are displayed in collections. You change a few of the default columns, but if not listed there, you *cannot* make other attributes, such as IP address, appear in the Collections node.
You need to do so through queries or reports, not the Collections node.
Wally Mead- Marked as answer by Wally (no longer at Microsoft) Monday, February 16, 2009 11:06 PM
Monday, February 16, 2009 11:06 PM
All replies
-
Hi,
I think it will be easier to create a prompted query. The IP address is not one of the default coloumns you can add.
This query will find computers based on IP address:
select SMS_R_System.Name, SMS_R_System.IPAddresses, SMS_R_System.ResourceId from SMS_R_System where SMS_R_System.IPAddresses = ##PRM:SMS_R_System.IPAddresses##
To find a computer based on the host name you just use the Look for field in any collection
Kent AgerlundThursday, February 12, 2009 4:32 PM -
Hy thanks!
I already create my custom query with IP, but after i apply/associate the query to the collection i don't see the IP column in the view.
I try modify current view (view --> Add/Remove colmuns) but IP is not there.
My idea is use the "look for" field with "IP" or "host name" to filter collection and operate the specified computer.
Regards, René
Thursday, February 12, 2009 7:51 PM -
Creating a custom query in a collection will not change the default coloumns that you can select in the collection. If you create a new query and paste my code you will be promted for the IP address. In the returned result you can distribute software, check inventory data etc.
Kent AgerlundThursday, February 12, 2009 7:58 PM -
Kent,
Everything you said work, but in "query" not in collection.
I'll activate SCCM Console to my System Support Team and the idea is they look inside of pre-defined collection (with rights) to access to all CM features (remote control, inventory, etc.)
I can do that?
(look for "host name" or "IP")
Regards, René
Thursday, February 12, 2009 8:24 PM -
Hy.
My collection is:
"TEST IP" and available fields for "look for"
http://img525.imageshack.us/img525/8968/sccm1bu2.jpg
Query Properties for this collection is:
http://img25.imageshack.us/img25/8753/sccm2hx5.jpg
I'll try to cusmotize View, but IP field is not available:
http://img502.imageshack.us/img502/4227/sccm3uq0.jpg
Regards, René
Thursday, February 12, 2009 8:47 PM -
Hi Rene,
Your query will have no effect on the coloumns you can add to the view. What you want can only be achieved in a query not in a collection.
Kent AgerlundSunday, February 15, 2009 6:39 PM -
The answer (for clarity) is:
You *cannot* change what attributes are displayed in collections. You change a few of the default columns, but if not listed there, you *cannot* make other attributes, such as IP address, appear in the Collections node.
You need to do so through queries or reports, not the Collections node.
Wally Mead- Marked as answer by Wally (no longer at Microsoft) Monday, February 16, 2009 11:06 PM
Monday, February 16, 2009 11:06 PM -
Thanks Guys!
I'll have queries to display and search for Computer IP.
Regards, René
Tuesday, February 17, 2009 5:23 AM -
You can customice SCCM and have a new overview with IP Address :) it is quite easy following this blog post http://idanve.blogspot.com.es/2015/03/add-custom-column-to-sccm-console-using.html
Thanks Idan!!!!!
I just updated from 2012 to CB and I replaced the 2 .xml modifyed for this propose in 2012 version, and they do work in CB :D i included: IP, Subnet, MAC, Last Logon TimeStamp, Last Logon userID, OB GUID, Creation Date... If you want the 2 .xml files msg me and ill send em.
- Edited by Maria Manilow Friday, October 20, 2017 8:40 AM
Friday, December 23, 2016 4:54 PM -
Hi Maria,
Can you share the 2 .xml <g class="gr_ gr_42 gr-alert gr_gramm gr_inline_cards gr_run_anim Style multiReplace" data-gr-id="42" id="42">file ?</g>
Thank You.
Regards,
Sam
wsamqi@outlook.com
- Edited by Wai Sam Qi Tuesday, November 21, 2017 4:05 AM
Tuesday, November 21, 2017 4:00 AM