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!
