Event log -sql events request

[dougsyer]

Today sql server event class keys get created with the sql instance id appended on.

This is a pain because i have to use a default mapping to catch them all then a huge ugly transform to do things.

Otherwise is have something like:

SqlInstance1_eventSource1_eventid
sqlinstance2_eventSource1_eventid1

[dougsyer]

Duplicate event class mappings.

Even added to a stand alone transform file and organized it is unwieldy. We have hundreds of sql instances.

What i would propose is to strip the imdtance is off the event class key and create a sql instance event detail.

Then i could use that instance field to constrict a component or eventkey for clearing but still be able to simplify the transforms by having normal event class keys.