Is there any table that stores data of the records created through platform?

Naveen Kumar
Tera Contributor

I need to know if there is any table that stores data of the records created in Platform. Records may be  incident, problem, ritms(req), change or ......

If there is any table that stores all these data which is created only through platform not from portal.

1 ACCEPTED SOLUTION

Bhaba
Tera Expert

Hi @Bharath Kumar,

You can check sp_log table to identify the records which are created from Portal. There's no specific table to identify data created through platform.

Also note that the table also keeps record of views and other activities in portal. 

Hope this solved your query.

Thanks.

View solution in original post

3 REPLIES 3

suvro
Mega Sage
Mega Sage

Unfortunately there is no such feature available in servicenow. 

Mohith Devatte
Tera Sage
Tera Sage

Hello ,

i don't think there is any table like that but what i can suggest as a work around is you can combine tables using data base views which are specifically used for reporting 

you can combine incident , ritms. problem and change it some or the other way they are related 

like having a field on incident form referring to problem or ritm , it just needs to have a relation ship .With this you can create a data base view 

refer below link for the process 

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/use/reporting/concept...

PLEASE MARK MY ANSWER CORRECT IF IT HELSP YOU

Bhaba
Tera Expert

Hi @Bharath Kumar,

You can check sp_log table to identify the records which are created from Portal. There's no specific table to identify data created through platform.

Also note that the table also keeps record of views and other activities in portal. 

Hope this solved your query.

Thanks.