Instance scan - Column type check

[shivaadapa]

Hi 

I am trying to serach for querying against 'sys_object_source' table in all the script fields in the instance. But the above code is not working please help me.
Help me to provide how to keep correct regular expressions.

[Mark Roethof]

Hi there,

Can you describe what you are exactly after, because there is more in the script.

If I look at the script, I think you are trying to search for matches on GlideRecord('sys_object_source')?

[Mark Roethof]

Untested, but I think below could work. Maybe do enhance the regex, so it accepts spaces around the braces, etc..

(function (engine) {

	// Remove code comments
	var commentsRegEx = /\/\*[\s\S]*?\*\/|([^:]|^)\/\/.*$/gm;
	var commentsRemovedValue = engine.columnValue.replace(commentsRegEx, '');

	var search_regex = /\bGlideRecord\(['"]sys_object_source['"]\)/gm;

	// Create scan finding
	if(!search_regex.test(commentsRemovedValue)) {
		engine.finding.increment();
	}

})(engine);

The code I'm sharing will also filter out commented code.

[Mark Roethof · Accepted solution]

O really small though essential typo I made, here is working tested code:

(function (engine) {

	// Remove code comments
	var commentsRegEx = /\/\*[\s\S]*?\*\/|([^:]|^)\/\/.*$/gm;
	var commentsRemovedValue = engine.columnValue.replace(commentsRegEx, '');

	var search_regex = /\bGlideRecord\(['"]sys_object_source['"]\)/gm;

	// Create scan finding
	if(search_regex.test(commentsRemovedValue)) {
		engine.finding.increment();
	}

})(engine);

[shivaadapa]

Hi @Mark Roethof 

I am not getting correct findings.