Generate txt file on ServiceNow with user records

Gaetano De Mitr
ServiceNow Employee
ServiceNow Employee

Hello everyone,

I should create a .txt file (as attachment) that contains user records with current columns:

Username,Created_date, "U" (static char)

Note: must be comma separated.

 

I have to generate the file everyday at 8.00PM.

Could I use a scheduled job script?

 

Thanks.

Gaetano

3 REPLIES 3

Adilakshmi Adap
Kilo Contributor

Hi Gaetano,

 

.txt export format is not supported OOB. 

You will find below post helpful.

https://community.servicenow.com/community?id=community_question&sys_id=5f360ba1db1cdbc01dcaf3231f961928

 

Regards,

Adilakshmi

asifnoor
Kilo Patron

Yes, you can use a scheduled job to run every day at 8.00 pm and call the script from there.

However, there is no direct txt export available. why don't you export to csv and then convert to txt from there?

Mark the answer as correct/helpful if this helps.

Hi Asifnoor,

Can you please help me with sample script for converting csv to txt after export?

Thanks!