Report or Count of Every Phone Number Active in Skype

%3CLINGO-SUB%20id%3D%22lingo-sub-182105%22%20slang%3D%22en-US%22%3EReport%20or%20Count%20of%20Every%20Phone%20Number%20Active%20in%20Skype%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-182105%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20report%2C%20or%20PowerShell%2C%20that%20can%20be%20run%20to%20do%20a%20listing%20of%20every%20number%20in%20the%20Skype%20for%20Business%20system%3F%20My%20CIO%20would%20like%20to%20know%20total%20number%20of%20extensions%20that%20have%20been%20set%20up%20as%20we%20are%20considering%20charging%20back%20departments%20for%20phones.%20I%20know%20we%20have%20somewhere%20around%201%2C200%2B%20in%20the%20system%2C%20but%20I%20was%20curious%20if%20there%20was%20a%20way%20to%20get%20a%20listing%20or%20simply%20a%20report%20of%20numbers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20not%20come%20across%20anything%2C%20but%20wanted%20to%20double%20check.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-182105%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMonitoring%20%26amp%3B%20Reporting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EVoice%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-183972%22%20slang%3D%22en-US%22%3ERe%3A%20Report%20or%20Count%20of%20Every%20Phone%20Number%20Active%20in%20Skype%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-183972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35378%22%20target%3D%22_blank%22%3E%40Adam%20Berns%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7965%22%20target%3D%22_blank%22%3E%40Anthony%20Caragol%3C%2FA%3E%2C%20thank%20you!%20That%20is%20great%20information!%20I%20neglected%20to%20come%20back%20in%20and%20update%20the%20post%20that%20I%20did%20find%20some%20reports%20within%20the%20system%20that%20helped.%20I%20will%20check%20out%20the%20PowerShell%20scripts%20and%20reports.%20Those%20look%20great!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-183943%22%20slang%3D%22en-US%22%3ERe%3A%20Report%20or%20Count%20of%20Every%20Phone%20Number%20Active%20in%20Skype%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-183943%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20are%20some%20pre-written%20scripts%20too%20if%20you%20look%20in%20the%20gallery%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgallery.technet.microsoft.com%2FLync-Get-All-Assigned-8c1328a0%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgallery.technet.microsoft.com%2FLync-Get-All-Assigned-8c1328a0%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESome%20are%20nice%2C%20export%20to%20Excel%2C%20other%20HTML%2C%20easy%20to%20hack%20up%20and%20make%20it%20do%20what%20you%20want.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-183317%22%20slang%3D%22en-US%22%3ERe%3A%20Report%20or%20Count%20of%20Every%20Phone%20Number%20Active%20in%20Skype%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-183317%22%20slang%3D%22en-US%22%3E%3CP%3Ethere%20are%20a%20few%20ways%20to%20get%20this%20from%20powershell.%3C%2FP%3E%3CP%3EThere%20are%20a%20few%20places%20that%20numbers%20are%20stored%3C%2FP%3E%3CP%3Eyou%20can%20export%20these%20to%20csv%20with%20%7C%20export-csv%20c%3A%5Clogs%5Cusers.csv%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20with%20PS%20you%20could%20do%20something%20like%20this%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22pl-c1%22%3EGet-CsUser%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E%7C%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-c1%22%3ESelect-Object%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E-%3C%2FSPAN%3EProperty%20DisplayName%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ESipAddress%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ELineURI%2CPrivateLine%20%7C%20export-csv%20c%3A%5Clogs%5Cusers.csv%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22pl-c1%22%3EGet-CsAnalogDevice%3C%2FSPAN%3E%20%7C%20%3CSPAN%20class%3D%22pl-c1%22%3ESelect-Object%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E-%3C%2FSPAN%3EProperty%20DisplayName%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ESipAddress%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ELineURI%20%7C%20export-csv%20c%3A%5Clogs%5Canalogdevices.csv%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22pl-c1%22%3EGet-CsCommonAreaPhone%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E%7C%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-c1%22%3ESelect-Object%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E-%3C%2FSPAN%3EProperty%20DisplayName%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ESipAddress%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ELineURI%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22pl-c1%22%3EGet-CsExUmContact%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E%7C%3C%2FSPAN%3E%26nbsp%3B%20%3CSPAN%20class%3D%22pl-c1%22%3ESelect-Object%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E-%3C%2FSPAN%3EProperty%20DisplayName%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ESipAddress%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ELineURI%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22pl-c1%22%3EGet-CsDialInConferencingAccessNumber%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E%7C%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-c1%22%3ESelect-Object%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E-%3C%2FSPAN%3EProperty%20DisplayName%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3EPrimaryUri%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ELineURI%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22pl-c1%22%3EGet-CsTrustedApplicationEndpoint%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E%7C%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-c1%22%3ESelect-Object%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E-%3C%2FSPAN%3EProperty%20DisplayName%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ESipAddress%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ELineURI%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22pl-c1%22%3EGet-CsRgsWorkflow%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E%7C%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-c1%22%3ESelect-Object%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E-%3C%2FSPAN%3EProperty%20Name%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3EPrimaryUri%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ELineURI%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22pl-c1%22%3EGet-CsMeetingRoom%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E%7C%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-c1%22%3ESelect-Object%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22pl-k%22%3E-%3C%2FSPAN%3EProperty%20Identity%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ESipAddress%3CSPAN%20class%3D%22pl-k%22%3E%2C%3C%2FSPAN%3ELineURI%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

Is there a report, or PowerShell, that can be run to do a listing of every number in the Skype for Business system? My CIO would like to know total number of extensions that have been set up as we are considering charging back departments for phones. I know we have somewhere around 1,200+ in the system, but I was curious if there was a way to get a listing or simply a report of numbers.

 

I have not come across anything, but wanted to double check.

 

Thank you!

 

John

 

3 Replies

there are a few ways to get this from powershell.

There are a few places that numbers are stored

you can export these to csv with | export-csv c:\logs\users.csv

 

so with PS you could do something like this

Get-CsUser | Select-Object -Property DisplayName,SipAddress,LineURI,PrivateLine | export-csv c:\logs\users.csv

Get-CsAnalogDevice | Select-Object -Property DisplayName,SipAddress,LineURI | export-csv c:\logs\analogdevices.csv

Get-CsCommonAreaPhone | Select-Object -Property DisplayName,SipAddress,LineURI

Get-CsExUmContact |  Select-Object -Property DisplayName,SipAddress,LineURI

Get-CsDialInConferencingAccessNumber | Select-Object -Property DisplayName,PrimaryUri,LineURI

Get-CsTrustedApplicationEndpoint | Select-Object -Property DisplayName,SipAddress,LineURI

Get-CsRgsWorkflow | Select-Object -Property Name,PrimaryUri,LineURI

Get-CsMeetingRoom | Select-Object -Property Identity,SipAddress,LineURI

There are some pre-written scripts too if you look in the gallery: https://gallery.technet.microsoft.com/Lync-Get-All-Assigned-8c1328a0 

 

Some are nice, export to Excel, other HTML, easy to hack up and make it do what you want.

@Adam Berns and @Anthony Caragol, thank you! That is great information! I neglected to come back in and update the post that I did find some reports within the system that helped. I will check out the PowerShell scripts and reports. Those look great!

 

John