This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Generating telephone numbers inside 1IM


Hello 1IM Community

We have a requirement to initially set the telephone numbers on Persons, so the phone number gets written to Active Directory and thus Skype for Business at the end. We have to define certain number blocks of phone numbers by locality/Building to pick numbers from automatically and manually when creating Identities. We need to have some blacklist of numbers for permanently unavailable numbers and we need to lock a phone number for 6 months when an employee leaves, so its assigned only after that time to another person.

I thought to have all possible phone numbers in the Company Scope (0000-9999) in one table and have all necessary phone number attributes on that table. E.G. numberblock ID,dial prefix,building,person holding the number,blocked permanently,blocked until date,etc.

Can you share a comment on this idea of approach and recommend a table inside 1IM that I could use to store phone numbers.
e.g. Locality (localities are also used for existing SAP localities, so I have some concerns to use this table for plain phone numbers) or
eventually QERResource, Workdesk or Hardware (we dont use those currently,
or create a Custom Table and all logic.

Any comment is greatly appreciated...

With very best regards,
Edi

  • Hi Edi,

    I did a similar thing for email addresses a long time ago in a galaxy far, far away.  Blocked/reserved addresses.  Addresses that cannot be reused etc.  Just do it with custom tables that you manage through SQL and processes.  Of course you could go crazy and create your own custom SQL triggers etc. but I found I was able to do it with simple templates, scripts and processes.

    Should be straightforward.

    HTH, Barry.