Need help to write a generic query to capture PII Data ( social security numbers / credit card numbers / email addresses ) from application log ?
There is no such thing as "generic PII data scan".
Firstly, you need to define what you want to find, then define how this data can be expressed, then you search for it.
And you'll always get false positives and false negatives. That's just how it is with automated searching for such loosely defined stuff.
The more precisely defined format, the better (like IBAN numbers).