Sending email via Python

Question

I tried one of the sample python code to send email to the active database user as part of the database maintenance procedure. But I have a problem in sending it because of the domain included in the username (e.g. xyz\username)...So, I want to remove the domain name and the backslash and retain only the username as the email list. (Please check the attached python code).

SDEMaintenance.py.zip

DanPatterson_Retired · Answer

Which is it? >>> a = [u"username1\xyz.com", u"username2\xyz.com", u"username3\xyz.com"] >>> emails = [name.split('\')[-1] for name in a] >>> emails ['xyz.com', 'xyz.com', 'xyz.com'] >>> emails = [name.split('\')[0] for name in a] >>> emails ['username1', 'username2', 'username3']‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ if the username (my list 'a') looks like line 1 above, then you would have had to split using line 5 above to get the first part of the split. once you have the parts as in line 7 above, you can concatenate what you want to it.. You will notice that they appear as email links... >>> emails ['username1', 'username2', 'username3'] >>> new = [e + "@yy.com" for e in emails] >>> new ['username1@yy.com', 'username2@yy.com', 'username3@yy.com']‍‍‍‍‍‍‍‍‍‍

JunCorvera · Answer

Dan, when I ran the code userList = [user.Name for user in arcpy.ListUsers(workspace)], it returns a list of users with the format 123456\xyz.com.sa. when I ran your suggested code emails=[name.split("\")[-1] for name in userList], it returns a list of username only but have a little problem there's a double quote at the end of the username....[u'123456"', u'6789"'].

DanPatterson_Retired · Answer

is user.Name returning the string in the format you showed why don't you show what the actual emailList looks like minus the "@xyz.com.sa" stuff because it can't be returning a simple string for user.Name I suspect that it is returning one of the two incarnations that worked in the sample that follows. If it does, then you just need to modify the split >>> a = "somedomain\xyz\username1" >>> b = "somedomain/xyz/username1" >>> c = "somedomain\xyz\username1" File "", line 1 SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 10-11: truncated \xyz escape ‍‍‍‍‍‍‍‍‍‍‍ It can't just be returning a string with a single backslashes in it eitherwise it would throw and error at some point. Notice that 'a' and 'b' are fine... either 'raw' format, double backslashes or a single forward slash will pass the test, not a single backslash a = ["somedomain\xyz\username1", "somedomain\xyz\username2", "somedomain\xyz\username3"] >>> emails = [name.split("\")[-1] for name in a] >>> emails ['username1', 'username2', 'username3']‍‍‍‍ or... >>> a = ["somedomain/xyz/username1", "somedomain/xyz/username2", "somedomain/xyz/username3"] >>> emails = [name.split("/")[-1] for name in a] >>> emails ['username1', 'username2', 'username3']‍‍‍‍