Extract Random Records and share it as excel file in monthly basis

[DjahidB]

Hello ,

is there a way in service now to automatize a random Records and share it as excel file in monthly basis .

Regards

DB

[Dr Atul G- LNG]

Hi @DjahidB 

Could you please provide more detail, what is automatize random record?

[DjahidB]

Hi @Dr Atul G- LNG 
Imagine we have 5000 server in serviceNow with different attributes (Name , Vendor , Manufacture , Used for , Operational Status), we want to make a periodic check if those attributes are correctly filled. so on Monthly basis Snow will province a samples of 50 randomly extracted to excel file and sent to one checker email.

[Dr Atul G- LNG]

Hi @DjahidB 

No, mate, this approach isn’t feasible. Additionally, it’s ServiceNow (SN), not "SNOW."

Instead, you can leverage the Data Certification module in ServiceNow to handle specific classes or conditions more effectively. This module provides a robust way to ensure data accuracy and compliance based on predefined rules.

Let me know if you need guidance on configuring it! 😊

[Ankur Bawiskar]

@DjahidB 

I didn't get why you wish to send random records as excel. what business purpose will it solve?

you can automate this and leverage scheduled reports feature

1) create a report based on your table and filter condition which you want to show

2) create a scheduled report and link it with above report, define when it has to send (interval etc) and to whom it has to be sent (group, user etc) and of what type

Creating a Scheduled Report in ServiceNow 

If my response helped please mark it correct and close the thread so that it benefits future readers.