Movi Version Reporting In VCS

[Tom Freeland]

Does anyone know of a good way to report on the differnt Movi versions that are running in you enviroment? As we have upgraded over the years, I would like to be able to know exactly how many people are not on 4.2 yet. I can run a script that reports the number of different versions that are currently logged in, but is there any way to tell the same over a recent hostory of time? Even better yet, is there a way to tell "who" is running the older versions?

Any useful scripts out there related to VCS or TMS in general would be greatly appreciated.

Thanks.

Tom

[awinter2]

Hi Tom,

this topic has already been discussed in fact (Second post from the top when searching for 'Movi version' :)), please check the following post for more details:

https://supportforums.cisco.com/message/3374282#3374282

Best regards

Andreas

[Tom Freeland]

Thanks. Yes, I was aware of the thread and reviewed it, but it doesn't address the question of reporting on people who are not logged in or registered. I am hoping that there is something out there that could report on the most recent login of every Movi user and the version when they logged in. That way i could track versions of users who have not logged in for weeks and remiond them to upgrade to the most recent version of Movi.

[awinter2]

Tom,

I don't think there is an automated way of collecting this information. The information you are looking for is however available in the LDAP database on TMS which holds all of the provisioning user information.

You can connect to this LDAP database with an LDAP browser and build a search set which will fetch the information that you need. One should use caution when doing this though, since you will have full access to the database while you are connected.

One browser you can use for this purpose is JXplorer, which you can get from jxplorer.org. Once installed, start the application, go to 'File > Connect' and populate the following fields:

Host: 127.0.0.1

Port: 389

Protocol: LDAP v3

DSML Service: Leave empty

Base DN: dc=provisioning

Security > Level: User + Password

User DN: cn=Directory Manager

Password: The password you have set for 'LDAP configuration password' in the 'Administrative tools > Configuration > TMS Agent settings' page in TMS (Defaults to 'TANDBERG')

Click 'OK' and a new page will open with a tree-based structure on the left hand side. Now, click on the 'Search' menu and select 'Return attribute lists'. Scroll through the leftmost list and select the entries 'SIPIdentitySIPURI', 'tt-version' and 'timeOfLastProvisioning' and move them over to the right-hand side using the arrow button. Once done, type 'Summary' in the 'Name' field and click 'Save'.

Next, click the 'Search' menu again and choose 'Search dialog'. In the 'Build filter' section, choose 'description' in the leftmost drop-down list, 'Equal to' in the middle drop-down list and 'movi' in the rightmost drop-down list (without quotes). Next, in the 'Information to retrieve' drop-down list, select 'Summary'. Finally, in the 'Start Searching From' field, type 'ou=devices,dc=provisioning' (without quotes) and click 'Search'.

You will now be presented with a list showing SIP URI's, their associated version numbers and the time and date these devices were last provisioned (e.g when they last logged in). This will be a raw list which you should be able to copy into Excel or similar to perform sorting if needed.

Again, please use caution when accessing the LDAP database with third-party tools. This is by no means an official howto or supported functionality, but more some general guidelines on how to fetch various information from the provisioning database. In other words, use at your own risk, since you can potentially wipe your provisioning database clean with a few mouseclicks

Hope this helps,

Andreas