Bill, I put a bunch of these queries on my blog site (see sig. block).
I used SQL queries to verify lab configs a fair amount. They are handy and quick. -Bill -- William Bell, CCIE #38914 blog: http://ucguerrilla.com twitter: @ucguerrilla On Oct 12, 2013, at 5:13 PM, Bill Lake wrote: > Does anyone know a good source for these type of searches or a good way to > create them? > > Bill > > Sent from my iPhone > > On Oct 12, 2013, at 11:40 AM, Martin Sloan <martinsloa...@gmail.com> wrote: > >> Hey Ryan, >> >> So the query isn't super simple but it's definitely something you could >> memorize for a quick look at user/device associations. The table that holds >> the relationship between the user and device is the enduserdevicemap table >> but all the records for user and device are references to the pkid's of the >> primary table so you have to join those in, the enduser and device table, to >> get the friendly names. Here's the query: >> >> run sql select enduser.userid,device.name from enduserdevicemap inner join >> enduser on enduser.pkid = enduserdevicemap.fkenduser inner join device on >> device.pkid = enduserdevicemap.fkdevice >> >> The results would give you something like this: >> >> userid name >> ====== =============== >> SBPH2 SEP1234567891236 >> HQPH2 SEP123456789125 >> SBPH1 SEP123456789124 >> HQPH1 SEP123456789123 >> >> HTH >> Marty >> >> >> >> On Sat, Oct 12, 2013 at 11:27 AM, Martin Sloan <martinsloa...@gmail.com> >> wrote: >> You could do a quick SQL query from the pub cli. I can't recall the table >> off hand but I will check it out when I get back to my computer. >> >> > On Oct 12, 2013, at 10:47 AM, Ryan Maxam <ryan.ma...@gmail.com> wrote: >> > >> > Is there a quick and easy way to see which device an End User is >> > associated with? Without having to run a report or going into the >> > individual End User configuration. It is not an offered search under Find >> > and List End User's. Thanks. >> > >> > Ryan Maxam >> > >> > Sent from my iPad >> > _______________________________________________ >> > For more information regarding industry leading CCIE Lab training, please >> > visit www.ipexpert.com >> > >> > Are you a CCNP or CCIE and looking for a job? Check out >> > www.PlatinumPlacement.com >> >> _______________________________________________ >> For more information regarding industry leading CCIE Lab training, please >> visit www.ipexpert.com >> >> Are you a CCNP or CCIE and looking for a job? Check out >> www.PlatinumPlacement.com > _______________________________________________ > For more information regarding industry leading CCIE Lab training, please > visit www.ipexpert.com > > Are you a CCNP or CCIE and looking for a job? Check out > www.PlatinumPlacement.com
_______________________________________________ For more information regarding industry leading CCIE Lab training, please visit www.ipexpert.com Are you a CCNP or CCIE and looking for a job? Check out www.PlatinumPlacement.com
