ok ,

My customer has made this kind of report by this manner :

• He has selected :

     Campus Manager >User Tracking>  Quick Report

                                                            > Seclect type , then he has chosen . ip phones

                                                                                                                  . Device name { where is the name of the switch who managed the voice vlan } ------------------> any ip-phones are  filled under the collumms

•      When he is doing a show mac adresses aor a show vlan : he saw  ip phones and vlan associated.

We have tried to do it under the prompt from /campus/bin:

> UT -cli  with - queryPhones

Richard

Thanks Michel.

Yes, that 's true , the VOIP management system is not CCM but an Alcatel one, and not entered under the devices list

But there is nothing viewed under the quick report:

Neither, the mac adresse nor the IpPhones:    

•      At least , i think that the report should  showed us the mac adresses.

Any idea ?

Should i open an SR for that ?

I think yes.

I think you may wish to check if the default gateway of the ipphones is managed by ciscoworks.

That is a requirement for user/phone tracking to work.

I think then at least you should see mac + IP.

The cisco ipphone should be seen via CDP as well I guess but I'm not sure when campus decides something is an ipphone

an SR is probably the fastest to get a sollution or definite answer as to wheter it may work.

Cheers

Michel

I have open an SR and did:

• Launch the "sample.txt " example , like it's explained under

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html to have , exactly, on the LMS server ( Windows) the Campus view .

I have requested to select the End_Hosts table. I have selected the following data:

VlanId, MACAddress, VLAN, IPAddress, LastSeen, HostName, Device

While the result of these output show us the variable filled up, the end hosts report under CAMPUS MANAGER, launched from LMS, don't show them.

Richard