How to index a field in service now?

[BhaveshJain]

Hello All,

I want to add a filter on the source field of the syslog table.I want to remove the unwanted logs and check only the records where the source field is script.How do I check whether the source field is indexed or not?

Please help.

[HarshTimes]

var gr = new GlideRecord('syslog');
gr.addQuery('source','script');
gr.query();
while(gr.next())
{
gs.print(gr.message) // this will print the message corresponding to all the source - script.
}

[HarshTimes]

you can do one more thing.
follow the steps
1. go to the syslog table
2. take the mouse pointer to the source column
3. right click on the cell where source = script
4. select the 'show matching'.

this will show all the records that have the source = script

[BhaveshJain]

Thanks for the quick response.

I have already set the module default filter as Source = 'MyLog' .I am curious to know whether the source field is indexed or not.This indexing is similar to what we have in databases to enable quick search/filtering.

Hope I was clear this time.

[haret]

Hi Bhavesh,

You can check the database indexes present on the 'syslog' table, in the 'Tables & Columns' module, by selecting the 'syslog' table (probably with label 'Log entry'), and expending the indexes list in the 2nd column to the right hand side.

If you need an index created, you should raise an incident with ServiceNow.

Regards,

Hari Valean