Questions tagged [query]
The query tag has no usage guidance.
196
questions
0
votes
1
answer
328
views
AWS CLI : How to use "--query" to get output from nested JSON
I am using aws-cli v2 to get the --query output from AWS Describe-volumes. In this, I am trying to get the volume id, size, Instance ID, state. Instance ID is nested in the AWS Describe-volumes.
...
0
votes
0
answers
81
views
Prometheus query to identify active series if a datapoint is sent in the last 15-30mins
I am trying to identify my Prometheus active series if a datapoint is sent in the last 15-30mins.
As I understand it, this query prometheus_tsdb_head_series gives me active series if a datapoint is ...
- 1
1
vote
0
answers
38
views
Reduce Query Syntax for ends_with()
I have the following query:
--query "Contents[?ends_with(Key, 'jpg') || ends_with(Key, 'NEF') || ends_with(Key, 'nef') || ends_with(Key, 'CR2') || ends_with(Key, 'cr2')]"
Is there a way to ...
- 111
1
vote
2
answers
184
views
Nginx rewrite to specific part of requested uri
I am quite new to nginx rewrite concept and I can't figure out how to rewrite the requested_uri to a specific Uri. I am trying to make rewrites to specific js files.
For example, I have this ...
- 11
0
votes
1
answer
88
views
GCP- Alert for adding new user or service account to a project
I want to create an alert in my project in GCP that lets me know when a new user or service account is added to the project. I understand I need to use Logs Explorer and run a query but I am not sure ...
google-cloud-platform
0
votes
0
answers
35
views
Is there an API to query Windows Update Endpoints
is there any known API to query machine-readable endpoints for Microsoft Services (especially Windows Updates) other than https://endpoints.office.com/ for M365?
Reasoning is, that our Firewall is ...
- 1
2
votes
1
answer
1k
views
json_query help - not producing expected output
I am trying to build an array to use for with_nested, but I cannot get past why json_query isn't outputting the actual hosts assigned to each cluster:
Play:
- name: Index clusters.json
shell: cat {{ ...
- 139
1
vote
0
answers
154
views
SCCM collection evaluates major version numbers in unexpected way
Why do SCCM collections based upon the logic Installed Applications (64).Version is less than "100.0" not evaluate to true for applications of version 99.* and below?
The full WQL query ...
- 11
1
vote
1
answer
1k
views
AWS Athena Query 2 separate tables together
I have 2 Tables, and i need to query them together, for example.
From the first table i get results with my query:
InstanceID, title, status and etc...
From the second one:
key, value, region and etc.....
- 131
0
votes
1
answer
427
views
Why my simple searching query is too slow?
I don't know why searching in my "cities" table is so slow.
My query looking for a table "cities" located about 25km from the city.
I use this simple query and the database takes ...
- 3
0
votes
1
answer
487
views
SQL Developer queries are very slow if I am not connected as sys
I want to run my PL/SQL Queries on SQL Developer and created a new user connection. But if I run:
set serveroutput on size unlimited;
begin
dbms_output.put_line('Hello Oracle.');
end;
/
clear ...
1
vote
0
answers
628
views
Alternate method for caching mysql query (query_cache) on version above 8.0
On mysql version 8+ the query_cache support was removed.
I know why it is not a friendly thing with InnoDB when considering the CPU.
But I've some databases which really need this support where user ...
- 33
3
votes
2
answers
782
views
MySQL - Select queries 10x slower on Azure VM vs on-prem VM
We have been working on a project to migrate a MySQL database from an on-premise Linux server to a Windows VM on Azure (IaaS). (There's a specific reason because of which we have gone with the IaaS ...
0
votes
1
answer
533
views
Using SNMP to monitor windows RDP logons?
It is possible to monitor WIN RDP logons (user,login duration) using SNMP specific OID ?
- 1
0
votes
1
answer
159
views
Rule - Search for my name in outlook messages but ignoring the text inserted in replies
I get a lot of junk emails that require no action from me so I wanted to filter out those that have my name in the body/subject and put them into a special folder.
I realized after creating the rule ...
- 101
0
votes
1
answer
859
views
Strapi + Postgres: Cannot SELECT from table - syntax error
I am using strapi and postgres. I created two collections in strapi called "solutions" and "references".
When I run \dt I get the following output:
...more tables
public | ...
- 101
1
vote
1
answer
3k
views
Optimizing MariaDB Performance
I need a different set of eyes checking my MariaDB settings. During peak load times, the CPU can hit upwards of 600% or more, and slows down Wordpress application. I have used MySQLTuner to tweak a ...
- 11
1
vote
1
answer
884
views
Azure : How to process Azure Log events from Event hub and filter based on criteria
How to process Azure Log events from Event hub and filter based on criteria.
We are trying to filter specific critical or security related Diagnostic and Activity logs before feeding into our Onprem ...
- 11
-1
votes
1
answer
2k
views
AD query - get bitlocker active computers
I have query in Active Directory which should return all computers with bitlocker not active based on this script:
https://community.spiceworks.com/topic/1083065-bitlocker-status-on-all-computers
...
- 11
0
votes
1
answer
517
views
AD Query for non expiring password but filter only active users
I need to do query which filters users with non expiring password setup.
I have something like this:
(&(objectCategory=person)(objectClass=user)(userAccountControl:1.2.840.113556.1.4.803:=65536))...
- 11
2
votes
1
answer
1k
views
Nginx, rewrite get query
I would like to rewrite an url from
/shop/?category=kitset-kitchens
to
shop/category/kitset-kitchens
What I tried:
rewrite ^/shop.*$ /shop/category/$arg_category permanent;
goes to:
shop/category/...
- 123
1
vote
1
answer
216
views
Will a domain controller in the domain that a group is defined contain all member information?
Let's say I have a forest setup with many domains. If I were to pick an arbitrary security group from any of the domains, what is the best way to find ALL user members of that group, including user ...
- 113
2
votes
2
answers
169
views
Suggested indexes
I am new to indexing in general and have just started learning about query plans etc.
I am working on this one specific query that keeps advising me to create the following index:
CREATE NONCLUSTERED ...
- 83
-1
votes
1
answer
3k
views
DNS Fails to simple query test
I seem to have a real odd problem that seems to escape me. I have two servers - both of which are ad controllers. My Problem Child is Windows 2008 R2, My other is a Windows 2012R2 that runs no problem....
- 1
0
votes
2
answers
2k
views
MySQL query is very slow over internet
I'm having an issue with a very slow query in an C# WPF application.
The application connects to a MySQL-server.
As long as the application is used on my LAN, everything is going fast.
When i use the ...
- 1
0
votes
2
answers
333
views
Nginx rewrite query url, redirect and serve content
Apache user here so not very familiar with nginx :)
Eg url like this
testpage.no/products?test_category=434
How to redirect this url and its content to this url:
testpage.no/testcategory
is ...
- 101
0
votes
2
answers
717
views
Exchange 2016 New-Mailboxsearch KQL Query Help - Is this possible? (X or Y) not (Z unless also X)
Thanks in advance for reading & any help you can provide!
I'm trying to do a mailbox search against several mailboxes. I need to find all messages that mention some words AND don't mention ...
- 41
2
votes
1
answer
4k
views
filtering event logs with specific TIME range of ANY day
How can I query windows server events between two times of any day?
I have tried with PowerShell...
Get-EventLog -Logname xxxx -After 04:00:00 -Before 04:00:30
...but just returns today's events
- 23
1
vote
1
answer
3k
views
Suspicious DNS query leads to "Intrusion protection alert" on Sophos UTM
A customer Sophos-UTM reports Intrusion protection alert warnings INDICATOR-COMPROMISE suspicious .null dns query:
2019:01:15-11:54:13 utm-ba snort[31619]: id="2101" severity="warn" sys="SecureNet" ...
- 2,105
2
votes
3
answers
1k
views
Block any query in BIND
I've been trying to block ANY queries in my BIND server with no success.
I followed this post Block ANY request in Bind which says that I can use minimal-responses but it doesn't work.
None of the ...
- 35
0
votes
1
answer
2k
views
SCCM WQL Query Structure BIOS release date
So with this whole Meltdown and Spectre causing a huge fuss world wide. I have discovered a solution to mass deploy BIOS updates. The one thing is when checking compliance I am unable to locate ...
- 15
0
votes
1
answer
45
views
Slow SQL Queries over local net
Slow Queries for SQL over 1Gb link between servers using just SSMS
Server Configs:
Main SQL Node:
32GB Ram
16 cores
Sage Evolution Server:
16 cores
16GB ram
The config of the servers is that they ...
1
vote
1
answer
300
views
Does a DNS server intercept and respond to DNS requests even if it is not the intended DNS server of the requesting machine?
"A" wants to resolve google.com using DNS Server 1 or 2 (as set in IPv4 settings on the NIC). But DNS Server 3 is between "A" and either DNS Server. Will server 3 attempt to respond to the DNS query? ...
0
votes
0
answers
103
views
How to make daily database backups readily queryable
We have a production database that generates daily database backups that are uploaded to S3 in form of compressed .sql.bz2 files. We basically have a S3 bucket that has a large number of such backups, ...
- 101
3
votes
1
answer
6k
views
Update InfluxDB measurement names
Is there a way to update existing measurement names in an InfluxDB? When my system was originally set up we used measurement names like "CheckCPU" or "CheckLOAD" and have changed to all lower case ...
- 33
2
votes
1
answer
359
views
SCCM query based on Device Enrolment Profile
We are pre-configuring our mobile device fleet through Apple DEP into our hybrid InTune / SCCM instance.
We have a few different enrolment profiles based on what the device is used for. With this, we ...
- 402
2
votes
3
answers
626
views
dns: difference between ANY and A query for changed DNS record?
I have recently changed the IP address for a particular domain, call it example.com. I know that it takes time for the DNS change to propagate, and it's still early enough that the propagation is not ...
- 202
0
votes
1
answer
4k
views
ldap query active directory: all users with their assigned groups or groups with their members
I'm trying to make a ldap query which I can run in active directory tool, so I can have an overview of all users with their groups.
What do I need to add to this script to see the groups of these ...
- 1
-2
votes
1
answer
5k
views
How do I run specific queries in SCCM using Powershell
Could you advise how could I run query ID using command prompt? For example, I do not want to go to Monitoring-Queries-expand tree and search for the specific querry. I Just want to have script file, ...
- 1
0
votes
1
answer
770
views
"show processlist;" output - percent sign
In the output above, what does the % (percentage sign) mean ?
mysql> show processlist;
+------+--------+----------------------+----------+---------+------+--------------+---------------------------...
- 69
0
votes
1
answer
2k
views
MySQL query is NOT executed from bash, but works from MySQL client
Using UBUNTU 16.
MySQL query fails from bash, but works from MySQL client:
query=$(cat << EOF
CREATE DATABASE \`${mysql_local_database}\` /*!40100 COLLATE \'utf8_hungarian_ci\' */; use \`${...
- 334
0
votes
1
answer
1k
views
Large database table queries return empty set
I'm trying to understand a weird problem with a MySQL database on one of my websites.
When I loaded a big set of data from a CSV file (2,200,000 records with a single column, using LOAD DATA) into a ...
- 101
6
votes
1
answer
28k
views
openldap sizelimit. Can't receive more than 500 entries
I can't receive more than 500 entries, when I query my openldap-server.
Although I made the following changes:
slapd.conf
# This is the main slapd configuration file. See slapd.conf(5) for more
...
- 63
1
vote
0
answers
469
views
Pgpool-II would not invalidate query cache for user schemas
I've configured pgpool2 (v3.4.3) with postgresql (v9.5) to cache queries like this:
memory_cache_enabled = on
memqcache_method = 'shmem'
memqcache_total_size = 67108864
memqcache_max_num_cache = ...
- 207
-2
votes
1
answer
100
views
Filtering query on Nginx [closed]
Can I store a specific query in access_log file by filtering with an expression?
For example I want to deny storing queries related to www.mydomaine.com and then reject it ?
Best regards,
Nizar.
- 11
1
vote
1
answer
18k
views
Obtain a list of computers from SCCM on which a specific software is installed?
I have tried the below procedure to obtain a list of desktops that have software X, version 2.2 installed on them:
Device Collections => Create Device Collection => named it "Computers with X ...
- 153
0
votes
1
answer
1k
views
which table should I query for date & time in zabbix?
i need to query date and time in zabbix server. which table exactly stores these 2 parameters?
Actually there is a table named history and there are two fields in that table named "clock" and "ns", ...
0
votes
1
answer
865
views
Quering history of network interface in zabbix server return empty set?
I've installed Zabbix on Ubuntu.
Although I can see a "graph" and related "latest data" for all network interfaces in Zabbix front-end, there is no data for them when I directly query MySQL database!...
8
votes
1
answer
152k
views
How to use WMIC to connect to remote machine and output OS information to a file?
I want to know how to use WMIC to connect to remote host and output their PC's OS information(Installed programs list) to a file.
I tried
wmic /node: <IP address> OS get vendor, name > c:\...
- 91
1
vote
3
answers
2k
views
MySql query returns null on ocassions
I'm not sure what exactly is causing this but on occasions a mysql query that I know has to return results will sometimes return null as a result. I've seen this happen twice before but as I couldn't ...
- 113