Row count on samp_sw_product table currently synced to Content Library

[Matt W1]

Could someone with an instance currently synced to the Content Library please provide the number of rows in your samp_sw_product table?

I realize there are multiple ways this table gets populated, but I assume the bulk of data is coming from the Content Library.

I am working with a large on-premise ServiceNow instance managed by an IT Enterprise. There is some question as to whether or not we have been importing content library updates over the past several months/years.

A current row count on the samp_sw_product table could help my office determine approximately how current we are.

Thank you.

[Nikhil Bahurup1]

Hi Matt,

My instance synced to content library and the count in table samp_sw_product is 1388. You can check created,created_by,updated,updated_by field to get an idea if the data in this table is getting created/updated.

[Matt W1]

Nikhil, thank you very much for the response. 1,388 seems very low. Are you referencing data from a Prod instance? Most previous postings have referenced around 100k rows.

You are absolutely correct regarding the created_by and updated_by dates. With our on-premise instance, the timing of the data is known to lag. I guess I am trying to determine the amount of data potentially missing.

Thank you again.

[Nikhil Bahurup1]

Hello Matt,

The count was from my dev instance. Additionally, you can check below post, there is good explanation given by Evan Orgel about content library in SAM. 

https://community.servicenow.com/community?id=community_question&sys_id=963221bedbb59c10afc902d5ca96...

[Matt W1]

Nikhil, thank you for that posting as a reference. It is very helpful.