General IAUG Discussion Forum

We are looking to output station information including the registered to IP address. We see the address in user registrations, and would like to use this to update location information as people move around.

------------------------------
Kathleen DeSantis
Telecommunications Manager
Maimonides Medical Center
Brooklyn NY
------------------------------

I assume you're talking about SIP stations (vs CM H323).  In System Manager under Elements \ Session Manager \ System Status \ User Registrations, there is an Export button at the top of the list (at least in my SMGR 8.1.3.2).

If you're looking to automate a change to the Home Location based on current IP, you'll want to check out the ASM APIs on DevConnect.  With the API calls, you can get the list of registered stations.  You'd then need to use the SMGR Web User Management APIs to change the location for the user.

A couple things to keep in mind: 

• Both the Export option and the API that returns registrations actually provides a list of all SIP accounts.  You must use the primReg and secReg fields to determine if that entry/row is actually registered (or could be ignored).
• Logins in the registration data can appear more than once if multiple devices are registered.  What logic you use to determine which should reflect the Home Location is up to you.

I'm curious what the driver is for keeping Home Location accurate?  The field isn't used a very many places.  Routing by location is based on Actual Location, not Home Location.  Network Regions in CM are associated to the actual IP address use in the call (or by matching the Network Region name to the Actual Location name).

Best of luck,

------------------------------
Sam Osheroff
UC Engineer
University of Washington
Seattle WA
------------------------------

Original Message:
Sent: 03-29-2022 03:19 PM
From: Kathleen DeSantis
Subject: Station report with IP addresses

We are looking to output station information including the registered to IP address. We see the address in user registrations, and would like to use this to update location information as people move around.

------------------------------
Kathleen DeSantis
Telecommunications Manager
Maimonides Medical Center
Brooklyn NY
------------------------------

Hi Sam. I came across your question about why we would want to use this. One consideration is for location information for 911 or emergency services. We have people moving between buildings and using shared phones/stations. Our subnets indicate the building and floor the device is on. I was just thinking of a way to discover and use this.

------------------------------
Kathleen DeSantis
Telecommunications Manager
Maimonides Medical Center
Brooklyn NY
------------------------------

Original Message:
Sent: 03-30-2022 10:37 AM
From: Sam Osheroff
Subject: Station report with IP addresses

I assume you're talking about SIP stations (vs CM H323).  In System Manager under Elements \ Session Manager \ System Status \ User Registrations, there is an Export button at the top of the list (at least in my SMGR 8.1.3.2).

If you're looking to automate a change to the Home Location based on current IP, you'll want to check out the ASM APIs on DevConnect.  With the API calls, you can get the list of registered stations.  You'd then need to use the SMGR Web User Management APIs to change the location for the user.

A couple things to keep in mind:

• Both the Export option and the API that returns registrations actually provides a list of all SIP accounts.  You must use the primReg and secReg fields to determine if that entry/row is actually registered (or could be ignored).
• Logins in the registration data can appear more than once if multiple devices are registered.  What logic you use to determine which should reflect the Home Location is up to you.

I'm curious what the driver is for keeping Home Location accurate?  The field isn't used a very many places.  Routing by location is based on Actual Location, not Home Location.  Network Regions in CM are associated to the actual IP address use in the call (or by matching the Network Region name to the Actual Location name).

Best of luck,

------------------------------
Sam Osheroff
UC Engineer
University of Washington
Seattle WA

Original Message:
Sent: 03-29-2022 03:19 PM
From: Kathleen DeSantis
Subject: Station report with IP addresses

We are looking to output station information including the registered to IP address. We see the address in user registrations, and would like to use this to update location information as people move around.

------------------------------
Kathleen DeSantis
Telecommunications Manager
Maimonides Medical Center
Brooklyn NY
------------------------------

One observation about exporting user registrations is that the CSV method will experience "Excel Side-Effects" if you use excel to open the CSV file. 

The simultaneousDevices field will be interpreted as a DATE if the user is registered.  1/4 becomes 4-Jan, for instance.  This does not occur when you use XML, or if you use a text editor to work with the CSV file.


------------------------------
Tom Lynn
Forum Moderator
------------------------------

Original Message:
Sent: 07-28-2022 01:56 PM
From: Kathleen DeSantis
Subject: Station report with IP addresses

Hi Sam. I came across your question about why we would want to use this. One consideration is for location information for 911 or emergency services. We have people moving between buildings and using shared phones/stations. Our subnets indicate the building and floor the device is on. I was just thinking of a way to discover and use this.

------------------------------
Kathleen DeSantis
Telecommunications Manager
Maimonides Medical Center
Brooklyn NY

Original Message:
Sent: 03-30-2022 10:37 AM
From: Sam Osheroff
Subject: Station report with IP addresses

I assume you're talking about SIP stations (vs CM H323).  In System Manager under Elements \ Session Manager \ System Status \ User Registrations, there is an Export button at the top of the list (at least in my SMGR 8.1.3.2).

If you're looking to automate a change to the Home Location based on current IP, you'll want to check out the ASM APIs on DevConnect.  With the API calls, you can get the list of registered stations.  You'd then need to use the SMGR Web User Management APIs to change the location for the user.

A couple things to keep in mind:

• Both the Export option and the API that returns registrations actually provides a list of all SIP accounts.  You must use the primReg and secReg fields to determine if that entry/row is actually registered (or could be ignored).
• Logins in the registration data can appear more than once if multiple devices are registered.  What logic you use to determine which should reflect the Home Location is up to you.

I'm curious what the driver is for keeping Home Location accurate?  The field isn't used a very many places.  Routing by location is based on Actual Location, not Home Location.  Network Regions in CM are associated to the actual IP address use in the call (or by matching the Network Region name to the Actual Location name).

Best of luck,

------------------------------
Sam Osheroff
UC Engineer
University of Washington
Seattle WA

Original Message:
Sent: 03-29-2022 03:19 PM
From: Kathleen DeSantis
Subject: Station report with IP addresses

We are looking to output station information including the registered to IP address. We see the address in user registrations, and would like to use this to update location information as people move around.

------------------------------
Kathleen DeSantis
Telecommunications Manager
Maimonides Medical Center
Brooklyn NY
------------------------------

Original Message:
Sent: 7/29/2022 2:45:00 PM
From: Tom Lynn
Subject: RE: Station report with IP addresses

One observation about exporting user registrations is that the CSV method will experience "Excel Side-Effects" if you use excel to open the CSV file. 

The simultaneousDevices field will be interpreted as a DATE if the user is registered.  1/4 becomes 4-Jan, for instance.  This does not occur when you use XML, or if you use a text editor to work with the CSV file.


------------------------------
Tom Lynn
Forum Moderator
------------------------------

Original Message:
Sent: 07-28-2022 01:56 PM
From: Kathleen DeSantis
Subject: Station report with IP addresses

Hi Sam. I came across your question about why we would want to use this. One consideration is for location information for 911 or emergency services. We have people moving between buildings and using shared phones/stations. Our subnets indicate the building and floor the device is on. I was just thinking of a way to discover and use this.

------------------------------
Kathleen DeSantis
Telecommunications Manager
Maimonides Medical Center
Brooklyn NY

Original Message:
Sent: 03-30-2022 10:37 AM
From: Sam Osheroff
Subject: Station report with IP addresses

I assume you're talking about SIP stations (vs CM H323).  In System Manager under Elements \ Session Manager \ System Status \ User Registrations, there is an Export button at the top of the list (at least in my SMGR 8.1.3.2).

If you're looking to automate a change to the Home Location based on current IP, you'll want to check out the ASM APIs on DevConnect.  With the API calls, you can get the list of registered stations.  You'd then need to use the SMGR Web User Management APIs to change the location for the user.

A couple things to keep in mind:

• Both the Export option and the API that returns registrations actually provides a list of all SIP accounts.  You must use the primReg and secReg fields to determine if that entry/row is actually registered (or could be ignored).
• Logins in the registration data can appear more than once if multiple devices are registered.  What logic you use to determine which should reflect the Home Location is up to you.

I'm curious what the driver is for keeping Home Location accurate?  The field isn't used a very many places.  Routing by location is based on Actual Location, not Home Location.  Network Regions in CM are associated to the actual IP address use in the call (or by matching the Network Region name to the Actual Location name).

Best of luck,

------------------------------
Sam Osheroff
UC Engineer
University of Washington
Seattle WA

Original Message:
Sent: 03-29-2022 03:19 PM
From: Kathleen DeSantis
Subject: Station report with IP addresses

We are looking to output station information including the registered to IP address. We see the address in user registrations, and would like to use this to update location information as people move around.

------------------------------
Kathleen DeSantis
Telecommunications Manager
Maimonides Medical Center
Brooklyn NY
------------------------------

Yes, that works too but you know most people are just going to double-click on the .csv file. 

:-)

------------------------------
Tom Lynn
Forum Moderator
------------------------------

Original Message:
Sent: 07-29-2022 02:45 PM
From: Sam Osheroff
Subject: Station report with IP addresses

Or use the import wizard to set all fields as text. 

-Sam

Original Message:
Sent: 7/29/2022 2:45:00 PM
From: Tom Lynn
Subject: RE: Station report with IP addresses

One observation about exporting user registrations is that the CSV method will experience "Excel Side-Effects" if you use excel to open the CSV file.

The simultaneousDevices field will be interpreted as a DATE if the user is registered.  1/4 becomes 4-Jan, for instance.  This does not occur when you use XML, or if you use a text editor to work with the CSV file.


------------------------------
Tom Lynn
Forum Moderator

Original Message:
Sent: 07-28-2022 01:56 PM
From: Kathleen DeSantis
Subject: Station report with IP addresses

Hi Sam. I came across your question about why we would want to use this. One consideration is for location information for 911 or emergency services. We have people moving between buildings and using shared phones/stations. Our subnets indicate the building and floor the device is on. I was just thinking of a way to discover and use this.

------------------------------
Kathleen DeSantis
Telecommunications Manager
Maimonides Medical Center
Brooklyn NY

Original Message:
Sent: 03-30-2022 10:37 AM
From: Sam Osheroff
Subject: Station report with IP addresses

I assume you're talking about SIP stations (vs CM H323).  In System Manager under Elements \ Session Manager \ System Status \ User Registrations, there is an Export button at the top of the list (at least in my SMGR 8.1.3.2).

If you're looking to automate a change to the Home Location based on current IP, you'll want to check out the ASM APIs on DevConnect.  With the API calls, you can get the list of registered stations.  You'd then need to use the SMGR Web User Management APIs to change the location for the user.

A couple things to keep in mind:

• Both the Export option and the API that returns registrations actually provides a list of all SIP accounts.  You must use the primReg and secReg fields to determine if that entry/row is actually registered (or could be ignored).
• Logins in the registration data can appear more than once if multiple devices are registered.  What logic you use to determine which should reflect the Home Location is up to you.

I'm curious what the driver is for keeping Home Location accurate?  The field isn't used a very many places.  Routing by location is based on Actual Location, not Home Location.  Network Regions in CM are associated to the actual IP address use in the call (or by matching the Network Region name to the Actual Location name).

Best of luck,

------------------------------
Sam Osheroff
UC Engineer
University of Washington
Seattle WA

Original Message:
Sent: 03-29-2022 03:19 PM
From: Kathleen DeSantis
Subject: Station report with IP addresses

We are looking to output station information including the registered to IP address. We see the address in user registrations, and would like to use this to update location information as people move around.

------------------------------
Kathleen DeSantis
Telecommunications Manager
Maimonides Medical Center
Brooklyn NY
------------------------------