Releases: spaghettidba/XESmartTarget
1.2.1.0
1.2.0.0
Implemented GroupedTableAppenderResponse. You can now use this response type to aggregate data before merging it to a target table.
Here is an example .json configuration:
{
"Target": {
"ServerName": "MyServer",
"SessionName": "loginaudit",
"FailOnProcessingError": false,
"Responses": [
{
"__type": "GroupedTableAppenderResponse",
"ServerName": "MyServer",
"DatabaseName": "xedemo",
"TableName": "loginaudit",
"AutoCreateTargetTable": true,
"UploadIntervalSeconds": 10,
"Events": [
"login"
],
"OutputColumns": [
"client_app_name",
"server_principal_name",
"client_hostname",
"database_name",
"MIN(collection_time) AS firstseen",
"MAX(collection_time) AS lastseen",
"COUNT(collection_time) AS logoncount"
]
}
]
}
}Based on this configuration, XESmartTarget writes to the target table using the non aggregated columns to match any existing data and merge it, depending on the aggregation type.
In this case, it matches (client_app_name, server_principal_name, client_hostname, database_name) and updates the aggregated columns accordingly:
MIN(collection_time)is updated only if the new value is<existing valueMAX(collection_time)is updated only if the new value is>existing valueCOUNT(collection_time)is added to the existing value
The data aggregated on the target table looks like this:
| client_app_name | server_principal_name | client_hostname | database_name | firstseen | lastseen | logoncount |
|---|---|---|---|---|---|---|
| .Net SqlClient Data Provider | SQLCONSULTING\gsartori | SQLCLP01 | XEDemo | 2018-09-27 11:46:43.423 | 2018-09-27 12:21:24.427 | 220 |
| SQLServerCEIP | SQLCONSULTING\SQLCSRV04$ | SQLCSRV04 | master | 2018-09-27 11:48:15.847 | 2018-09-27 12:18:19.107 | 15 |
| SQLAgent - Job Manager | SQLCONSULTING\sqlservice | SQLCSRV04 | msdb | 2018-09-27 11:50:00.830 | 2018-09-27 12:20:01.193 | 16 |
| SQLAgent - TSQL JobStep | SQLCONSULTING\sqlservice | SQLCSRV04 | master | 2018-09-27 11:50:00.883 | 2018-09-27 12:20:01.060 | 4 |
| SQLAgent - TSQL JobStep | SQLCONSULTING\sqlservice | SQLCSRV04 | distribution | 2018-09-27 11:50:00.890 | 2018-09-27 12:20:01.163 | 4 |
| SQLAgent - Update job activity | SQLCONSULTING\sqlservice | SQLCSRV04 | msdb | 2018-09-27 11:50:00.913 | 2018-09-27 12:20:01.200 | 8 |
| Microsoft SQL Server Management Studio | SQLCONSULTING\gsartori | SQLCLP01 | master | 2018-09-27 11:57:10.723 | 2018-09-27 12:03:29.763 | 17 |
| sqlops-GeneralConnection | SQLCONSULTING\gsartori | SQLCLP01 | master | 2018-09-27 11:57:31.957 | 2018-09-27 11:57:39.767 | 4 |
| sqlops-languageService | SQLCONSULTING\gsartori | SQLCLP01 | master | 2018-09-27 11:57:32.243 | 2018-09-27 11:57:32.243 | 1 |
| sqlops-Dashboard | SQLCONSULTING\gsartori | SQLCLP01 | master | 2018-09-27 11:57:32.367 | 2018-09-27 11:57:33.307 | 2 |
| Core .Net SqlClient Data Provider | SQLCONSULTING\gsartori | SQLCLP01 | master | 2018-09-27 11:57:33.327 | 2018-09-27 11:57:33.327 | 1 |
| sqlops-Query | SQLCONSULTING\gsartori | SQLCLP01 | master | 2018-09-27 11:57:33.477 | 2018-09-27 11:57:33.477 | 2 |
| SQLAgent - Schedule Saver | SQLCONSULTING\sqlservice | SQLCSRV04 | msdb | 2018-09-27 12:01:42.050 | 2018-09-27 12:01:42.050 | 1 |
1.1.0.0
XESmartTarget now supports x86 and x64 builds, thanks to incorporating Smo dlls via Nuget.
From now on, select the installation package that matches your platform.
1.0.8.2
Introduced centralized assembly versioning via SharedAssemblyInfo
1.0.8.1
1.0.8.0
Fixed bug in XelToCsv. It didn't export missing columns properly.
v1.0.7.0
Minor fixes. I should probably say which ones, but screw that.
v1.0.6.0
v1.0.5.0
New Response Type: CsvAppenderResponse
Added command line utility XelToCsv to convert a .xel file to .csv. Used by DBATools
v1.0.4.0
Minor fixes. Made Response classes public for scripting purposes