anyone know anything about customizing reports in SCCM?

[Resolute 14]

I need to take a canned report: Hardware 01A - Summary of computers in a specific collection, and add a column that shows the IP Address of the system. I know absolutely nothing about SQL programming, and after two hours of frustration, am hoping someone here knows a bit about this.

[Shazam]

Just reverse the polarity of the neutron flow.

[Resolute 14]

Tried that, but I ended up crossing the beams and inadvertently destroyed half of finance.

[FanIn80]

SCCM? Is this anything like Crystal Reports?

Edit: Oh wait, never mind. I assume you're talking about http://technet.microsoft.com/en-us/c...r/default.aspx?

If it's a canned report, simply modifying the underlying SQL query won't do it on its own. You'll also need to add the extra field to the report itself. Or, have you figured that part out but you need help with editing the query itself?

Need more input, is what I'm basically saying.

[picard]

This doesn't modify your report but you could run the report:
IP - Computers in a specific subnet

and export the results to excel so you can sort etc.

[Resolute 14]

Originally Posted by FanIn80

SCCM? Is this anything like Crystal Reports?

Edit: Oh wait, never mind. I assume you're talking about http://technet.microsoft.com/en-us/c...r/default.aspx?

If it's a canned report, simply modifying the underlying SQL query won't do it on its own. You'll also need to add the extra field to the report itself. Or, have you figured that part out but you need help with editing the query itself?

Need more input, is what I'm basically saying.

I'm guessing then that I need to add the field to the report. I've only added one line so far, and end up with the error:

The multi-part identifier "v_RA_System_IPAddresses.IP_Addresses0" could not be bound.