tag:blogger.com,1999:blog-4421651675096124175.post4891082661571503722..comments2024-03-02T21:14:43.287-08:00Comments on Unified Communications Guerrilla: Finding Orphaned User Device Profiles for EMWilliam Bellhttp://www.blogger.com/profile/02559158040046322600noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-4421651675096124175.post-39721121425600668192016-08-11T22:07:32.704-07:002016-08-11T22:07:32.704-07:00Looks like, "Model Profile" for "Fi...Looks like, "Model Profile" for "Fixed Device" + pkid perhaps?Big Dhttps://www.blogger.com/profile/13510044856397770997noreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-32206234788218851702016-06-29T14:16:51.222-07:002016-06-29T14:16:51.222-07:00When I run this query against my CUCM cluster, I g...When I run this query against my CUCM cluster, I get device profiles that look like this:<br />ModelProfileForfd14444c-0593-0726-ba2e-ad7272e70f6<br /><br />What does that mean?Ryanhttps://www.blogger.com/profile/02041283781527209943noreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-46139495741175803412016-06-01T18:36:09.347-07:002016-06-01T18:36:09.347-07:00Yes. You can join the device table, devicenumplanm...Yes. You can join the device table, devicenumplanmap table, and numplan table. For example:<br /><br />http://www.ucguerrilla.com/2012/03/cucm-sql-queries-installment-3.html <br /><br />HTH<br />-Bill (@ucguerrilla)UC Guerrillahttps://www.blogger.com/profile/14454391786438461256noreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-43642521992839460272016-05-26T22:57:38.496-07:002016-05-26T22:57:38.496-07:00Hi - Is it possible to get the DN displayed along ...Hi - Is it possible to get the DN displayed along with above query<br />please let me know<br /><br />ThanksAravindanhttps://www.blogger.com/profile/18434952450253039991noreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-77922218879737504092015-06-11T05:59:29.137-07:002015-06-11T05:59:29.137-07:00just found the answer ...
run sql select d.name, ...just found the answer ...<br /><br />run sql select d.name, d.description from device d where (0=(select count(edm.pkid) from enduserdevicemap edm where edm.fkdevice=d.pkid)) and d.tkclass=254 order by d.nameDan SJKnoreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-82233489114427101492015-06-11T05:54:56.862-07:002015-06-11T05:54:56.862-07:00This is very handy, what would need to be added to...This is very handy, what would need to be added to the query to have it display both the device profile name and description?Dan SJKnoreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-88775779941350864442013-12-04T16:57:26.297-08:002013-12-04T16:57:26.297-08:00Could this be taken one step farther and only spit...Could this be taken one step farther and only spit out those profiles that are also not assigned as the logout profile on a device?Talonnoreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-13300671312575379492013-09-13T13:53:34.752-07:002013-09-13T13:53:34.752-07:00Joerg,
I believe I did respond to your question o...Joerg,<br /><br />I believe I did respond to your question on another comment thread. Check this link: http://www.ucguerrilla.com/2012/03/cucm-sql-queries-series.html?showComment=1378905199359#c5846732364553118504<br /><br />Let me know if there is a problem accessing the link. <br /><br /><br />-Bill (@ucguerrilla)<br />UC Guerrillahttps://www.blogger.com/profile/14454391786438461256noreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-43790811122970564192013-09-12T13:37:31.053-07:002013-09-12T13:37:31.053-07:00Works great!
Very timely. We have a conversion c...Works great!<br /><br />Very timely. We have a conversion coming up, and this will save us some trouble calls on conversion day.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4421651675096124175.post-77435755089961347652013-09-12T06:08:06.462-07:002013-09-12T06:08:06.462-07:00Hi, very good post. This is what I looking for als...Hi, very good post. This is what I looking for also. Have you time to check my other SQL Q about the never regsiter phones?<br /><br />Thx<br />JoergAnonymoushttps://www.blogger.com/profile/11551998056598955213noreply@blogger.com