flinox

requests
| extend timestampSP = datetime_utc_to_local(timestamp,'America/Sao_Paulo')
| where timestampSP > datetime("2024-03-19T20:00:00.000Z") and timestampSP < datetime("2024-03-20T10:00:00.000Z")
| where customDimensions["API Name"] == "<api-name>"
| distinct tostring(customDimensions["Operation Name"])

flinox

requests
| extend timestampSP = datetime_utc_to_local(timestamp,'America/Sao_Paulo')
| where timestampSP > datetime("2024-03-20T20:00:00.000Z") and timestampSP < datetime("2024-03-21T09:00:00.000Z")
| summarize TotalRequests = count() by tostring(customDimensions["API Name"])

flinox

union isfuzzy=true
    availabilityResults,
    requests,
    exceptions,
    pageViews,
    traces,
    customEvents,
    dependencies
| where timestamp > datetime("2024-03-21T00:26:50.333Z") and timestamp < datetime("2024-03-21T00:56:50.333Z")
| where customDimensions["API Name"] in ("<nome-api>")

flinox

requests
| where customDimensions["Request Id"] == "<request-id>"
| project customDimensions["Service ID"],timestamp,url,name,operation_Name,success,resultCode,customDimensions["Request Id"],performanceBucket,user_AuthenticatedId,client_IP,customDimensions["Subscription Name"]

flinox

requests
| where timestamp > ago(60m)
| summarize TotalRequests = count() by tostring(customDimensions["API Name"])

flinox

# ------------------------------------------------------------------------------
# v1.0 - 2019-08-13 - Created by: Fernando Lino Di Tomazzo Silva
# v2.0 - 2019-11-27 - Updated by: Fernando Lino Di Tomazzo Silva
#
# Script para realizar expurgo de registros logicamente inativos das BO's do MDM da INFORMATICA.
# Mais informacoes sobre MDM da INFORMATICA em: https://www.informatica.com/br/products/master-data-management.html
#
# ##### PRE REQS ######
# 1) Ter uma tabela criada que será usada para carregar os ID's dos registros para expurgar, Ex.:
#	create table CMX_ORS.TB_PURGE_AUX

flinox

Why Kafka is so fast ?

Why Kafka is so fast?

flinox

# Run Docker without sudo
sudo gpasswd -a $USER docker
sudo setfacl -m user:$USER:rw /var/run/docker.sock

flinox

select to_date('19700101','YYYYMMDD') + ( 1 / 24 / 60 / 60 / 1000) * <value_unix_epoch> from dual;

flinox

Select ServerProperty('Collation')