Comments (4)
That's an interesting feature. I tried to achieve the same with SUBSTRING(CONVERT(collection_time,'System.String'),1,16)
but I understand that this depends on the time format of the machine where XESmartTarget is running.
The main problem is that the expressions are based on what the DataTable class can accept. It has its own syntax and there are things it can't do. I'll see if I can find a way.
Thanks for filing this issue!
from xesmarttarget.
Another option: the UploadIntervalSeconds
would be the bin
size, and I could have the option not to merge with the target table.
So it would still be grouped and aggregated within the XE Smart Target, but only appended to the target table.
from xesmarttarget.
Thank you! In that case, I think my second post could be used as a workaround - appending to the target table instead of merging and using the Upload interval as the time bucket (along with max(collection_time)
)
from xesmarttarget.
Sure, this can be done! Let me work out something and I'll get back to you
from xesmarttarget.
Related Issues (20)
- New-DbaXESmartTableWriter not writing to table HOT 9
- Aggregated column cannot have the same name as the underlying column in GroupedTableAppenderResponse HOT 1
- Column 'X' does not belong to underlying table 'events' HOT 11
- Add a mechanism to reconnect the session when error/disconnection is found
- Feature request - Add aggregate "LAST" to GroupedTableAppenderResponse HOT 1
- Allow loading configuration from URL
- Allow having multiple targets in the same config but still support old style config
- GelfTcpResponse not inserting "short_message" or "message" (as seen from Graylog GELF receiver machine) HOT 6
- Add Timeout to let XESmartTarget stop gracefully after it expires
- XelToCsv won't launch 1.4.9 HOT 6
- nuget package HOT 7
- XESmartTarget.Core.Utils.XELFileCSVAdapter does not export all events
- Error during start: Could not load file or assembly 'Microsoft.SqlServer.XEvent.Linq.dll' or one of its dependencies. HOT 1
- Add command line parameter to load a .sql file and create the session
- Setup: QMonitor Agent is copied to a separate folder
- Setup: upgrade should delete all local config files
- ConfigWizard: does not display service user name in the servers page
- Running XESmartTarget Continuously for 24/7 Monitoring HOT 1
- Missing column in the TableAppenderResponse created table
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from xesmarttarget.