Is it possible to export email contacts?

mwalpole
Kilo Explorer

Is it possible to export all of the email addresses for the registered users from Service-now, without having to go into each user and copy their details?

I am presuming all the email addresses live in a table somewhere, but my digging around hasn't revealed where this list may be.

Can anyone help please?

Regards

Marc

4 REPLIES 4

Glenn Goldman2
Kilo Contributor

Check the User [sys_user] table. You should have the email field and any other user attributes that you are tracking there.


mwalpole
Kilo Explorer

Thanks for that GlennGoldman!

My next question is where do I find that? I have full admin rights on service now, but I haven't really looked at the table section before, as I mostly develop our service catalogue.

My manager has asked for a list of all the users email addresses, so we can email them out some information, and I figured there might be an easier way than copying all the users email addresses across one by one from the user section.

Marc


Glenn Goldman2
Kilo Contributor

You can get to the table via Reports, View/Run, Click New and then select the table and format you need.


mwalpole
Kilo Explorer

Thanks very much for the help. That works a treat!

Marc