I have the below query which is used to get all the images added (in two of the paths) which were created between two dates.   SELECT * FROM [dam:Asset] AS a WHERE ((ISDESCENDANTNODE(a,[/content/dam/wknd/en/site])) OR (ISDESCENDANTNODE(a,[/content/dam/wknd/en/site2]))) AND a.[jcr:created] > CAST('...

@Nitin_laad  Thank you for this detailed reply. But my main question was around 95 requests per second on one server. Is that something valid to point out to get the budget for a second server along with the context as a back up server?

Can I get opinion on requests at the webserver level.? If frequently we approach over 95 requests per second on the single webserver, do you think I can use this as a speaking point to the need to add the second server to provide ongoing resilience and handle increased volumes of traffic.    Normal ...

Thank you @nitesh_kumar . Really appreciate your help.

Thank you @nitesh_kumar . That worked perfectly fine. If I need to add one more different path along with  /content/dam/wknd/en/site to this query, do I need to add to add another or and add the path? 

I have a requirement where I run a daily scheduler which picks all changed nodes to a dam location , say /content/test with changes made between today(when the scheduler is running) and  the last run(yesterday's date). Can someone help out on how the SQL query will be?   I have a basic query which c...

@digarg  Thank you. That fixed my issue.

@digarg  There are no metadata properties specific to excel and it is defaulting to the main custom schema and images, application are all inside that schema. I don't want excel to default to my custom schema since it is picking the mandatory properties i added for images. So my ask is how i can rem...

@digarg  I think i am not quite following you. I have a custom metadataschema with some properties as mandatory fields and that is applied to a folder. I have not defined any cutom application schema inside this metadata schema. pdf just came by default and omce you click on pdf, it is actually empt...

@digarg This is the screenshot of the application schema inside my custom schema I don't have excel in there. Are you saying to creating a custom application schema inside my custom schema for excel?