cancelar
Mostrando los resultados de 
Buscar en lugar de 
Quiere decir: 
cancel
328
Visitas
5
ÚTIL
1
Respuestas
Luis Cruz
Beginner

Reporte de licencias y usuarios CUCM

Hola buen día, mi duda es:

 

¿Desde Cisco Unified Communications Manager se puede generar un reporte de licencias que tienen cada uno de los usuario?

 

Gracias por la ayuda.

 

¡Saludos!

1 RESPUESTA 1
dulfranc1
Beginner

Hola Luis para poder hacerlo podrías utilizar el siguiente comando

(Nota: Los comandos funcionan en versiones CUCUM 9.1 o posterior, incluyendo HCS Application Software que esta con una licencia en combinación de los paquetes de Cisco Essential, Basic, Foundation y Standars)

 

Comando para listar las licencias consumidas por cada usuario:

run sql SELECT EU.userid userid, EU.firstname firstname, EU.lastname lastname, LRU.em emenabled,  LRU.snr snrenabled, LRU.presence presence, (LRU.tin+LRU.copper+(CASE WHEN LRU.Telepresence>LRU.Bronze THEN 0 ELSE LRU.Bronze-LRU.Telepresence END)+LRU.silver+LRU.gold+LRU.unknowndevice) devicecount, (CASE WHEN ((LRU.tin+LRU.copper+(CASE WHEN LRU.Telepresence>LRU.Bronze THEN 0 ELSE LRU.Bronze-LRU.Telepresence END)+LRU.silver+LRU.gold+LRU.unknowndevice> 1))  THEN 'HCS Standard'  ELSE (CASE WHEN ((LRU.tin+LRU.copper+(CASE WHEN LRU.Telepresence>LRU.Bronze THEN 0 ELSE LRU.Bronze-LRU.Telepresence END)+LRU.silver+LRU.gold+LRU.unknowndevice=1) AND (((CASE WHEN LRU.Telepresence>LRU.Bronze THEN 0 ELSE LRU.Bronze-LRU.Telepresence END)=1) OR (LRU.unknowndevice=1))) THEN 'HCS Foundation' ELSE (CASE WHEN (((LRU.tin+LRU.copper+(CASE WHEN LRU.Telepresence>LRU.Bronze THEN 0 ELSE LRU.Bronze-LRU.Telepresence END)+LRU.silver+LRU.gold+LRU.unknowndevice=1) AND (LRU.copper= 1)) OR ((((LRU.tin=1) AND (LRU.tin+LRU.copper+(CASE WHEN LRU.Telepresence>LRU.Bronze THEN 0 ELSE LRU.Bronze-LRU.Telepresence END)+LRU.silver+LRU.gold+LRU.unknowndevice=1)) OR (LRU.tin+LRU.copper+(CASE WHEN LRU.Telepresence>LRU.Bronze THEN 0 ELSE LRU.Bronze-LRU.Telepresence END)+LRU.silver+LRU.gold+LRU.unknowndevice=0)) AND (LRU.snr='t'))) THEN 'HCS Basic' ELSE (CASE WHEN (((LRU.tin+LRU.copper+(CASE WHEN LRU.Telepresence>LRU.Bronze THEN 0 ELSE LRU.Bronze-LRU.Telepresence END)+LRU.silver+LRU.gold+LRU.unknowndevice=1) AND (LRU.tin= 1) AND (LRU.snr='f'))) THEN 'HCS Essential' END) END) END) END) licensetype, (CASE WHEN ((LRU.tin+LRU.copper+(CASE WHEN LRU.Telepresence>LRU.Bronze THEN 0 ELSE LRU.Bronze-LRU.Telepresence END)+LRU.silver+LRU.gold+LRU.unknowndevice> 1)) THEN (CAST((LRU.tin+LRU.copper+(CASE WHEN LRU.Telepresence>LRU.Bronze THEN 0 ELSE LRU.Bronze-LRU.Telepresence END)+LRU.silver+LRU.gold+LRU.unknowndevice+9) / 10 AS int)) ELSE 1 END) licenses FROM LicensingResourceUsage LRU, EndUser EU WHERE LRU.fkenduser IS NOT NULL and EU.pkid=LRU.fkenduser AND (((LRU.tin+LRU.copper+(CASE WHEN LRU.Telepresence>LRU.Bronze THEN 0 ELSE LRU.Bronze-LRU.Telepresence END)+LRU.silver+LRU.gold+LRU.unknowndevice) > 0) OR (((LRU.tin+LRU.copper+(CASE WHEN LRU.Telepresence>LRU.Bronze THEN 0 ELSE LRU.Bronze-LRU.Telepresence END)+LRU.silver+LRU.gold+LRU.unknowndevice) = 0) AND (LRU.snr = 't'))) AND ((my_lower(firstname::lvarchar) LIKE my_lower('%')  OR firstname IS NULL OR my_lower(firstname::lvarchar) = '')) UNION SELECT EU.userid userid, EU.firstname firstname, EU.lastname lastname, LRU.em emenabled, LRU.snr snrenabled, LRU.presence presence, ((CASE WHEN LRU.Telepresence>=LRU.Bronze THEN LRU.Bronze ELSE LRU.Telepresence END) + LRU.telepresence) devicecount, (CASE WHEN (LRU.telepresence>0) THEN 'TelePresence Room' END) licensetype, (LRU.telepresence) licenses FROM LicensingResourceUsage LRU, EndUser EU WHERE LRU.telepresence > 0 and LRU.fkenduser IS NOT NULL and EU.pkid=LRU.fkenduser AND ((my_lower(firstname::lvarchar) LIKE my_lower('%')  OR firstname IS NULL OR my_lower(firstname::lvarchar) = '')) ORDER BY  userid

 

Comando para mostrar los subtotales de licencias consumidas “User” vs “Dispositivo”

run sql SELECT name,value,uservalue,devicevalue FROM TABLE( FUNCTION LicenseTotals() )(pkid,name,value,UserValue,DeviceValue)

 

Espero sea de ayuda, saludos!

Content for Community-Ad