Questions tagged [query]
The query tag has no usage guidance.
197
questions
0
votes
0
answers
15
views
Initial patch install checking via SCCM query
I want to make a better query for Windows Server OS patching (2016 & 2019). The one listed below is what I wrote that my company currently uses. If a newly built servers OS install time is ...
1
vote
2
answers
6k
views
Create SCCM device collection based on last logged on users who are members of an AD security group
I'm trying to create a device collection in SCCM 2012 which contains only the devices who are used by the users who are members of a certain User AD Security Group. I tried to accomplish this by first ...
45
votes
3
answers
65k
views
Why multiple PTR records in DNS is not recommended?
I often read that using multiple PTR records in a DNS configuration is not recommended.
However, the reasons are often vague, or not so obvious, naming:
"it can cause problems",
"can ...
0
votes
0
answers
212
views
Inconsistent Clickhouse database query performance
Folks,
Clickhouse Server version: 22.8.21 (have tried a variety of 22.x and 23.x versions as supported by clickhouse-backup to restore my data with for testing, none seemed to improve the query ...
0
votes
0
answers
64
views
Which is the correct capability in Courier SMTP config to get user's password (encryption type)
MySql: 8.0.34-0ubuntu0.22.04.1
I have followed this guide: Postfix With Courier IMAP Mail Server Installation (unfortunately they do not answer questions).
I had to change the encryption method for ...
29
votes
3
answers
61k
views
AWS CLI Command Line: How to use "--query" to output multiple source lines
I am using aws-cli version 1.7.8 to get the --query output to create one record that is derived from multiple lines.
In this case I am trying to get specific information from describe-instances.
In ...
2
votes
2
answers
5k
views
How to create one update query (mysql) on multiple databases
I have several DBS on the same mysql server.
The DBS's structure and schema are exactly the same (only data is different)
the query on certain db works well like this (written in phpmyadmin)
UPDATE ...
1
vote
1
answer
4k
views
Restrict "Authority Section" on BIND
I just switched from Microsoft DNS to BIND 9.3 for a DNS acting as a Caching Nameserver.
Previously when I used "dig" to perform a lookup...I just got the "QUESTION" & "...
3
votes
2
answers
1k
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
1k
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
1
answer
234
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 ...
1
vote
2
answers
348
views
mysql slow query log
I am trying to write a script to parse the MySQL slow query log. I have seen 1 or 2 parser.
does anyone know how to extract the information from that log? I mean does anyone know the structure of the ...
1
vote
0
answers
70
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 ...
46
votes
4
answers
67k
views
How do I remove a specific bad plan from the SQL Server query cache?
We have one particular SQL Server 2008 query (not a stored proc, but the same SQL string -- executes every 5 minutes) that intermittently caches a very bad query plan.
This query normally runs in a ...
1
vote
2
answers
372
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 ...
1
vote
3
answers
3k
views
Mysql server high trafic makes websites really slow or unable to load
Lately we have been having a lot of problems with our mysql server, from websites being really slow or even unable to load them at all. The server is a dedicated server that only runs our mysql ...
-1
votes
1
answer
3k
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
...
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 ...
2
votes
1
answer
2k
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 {{ ...
1
vote
0
answers
247
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 ...
1
vote
1
answer
2k
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.....
0
votes
1
answer
792
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 ...
0
votes
1
answer
777
views
Using SNMP to monitor windows RDP logons?
It is possible to monitor WIN RDP logons (user,login duration) using SNMP specific OID ?
27
votes
18
answers
80k
views
Are there any good and lightweight LDAP querying tools? [closed]
As developers we sometimes need querying LDAP. Do you know useful tools for this task?
edit: I don't mean in code, I mean utility/tool (command-line or gui, mostly gui) for just to look/confirm data, ...
0
votes
1
answer
781
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 ...
12
votes
4
answers
51k
views
DNS searching with wildcards?
Anything like nslookup or dig offer the ability to search based on something contained in the name ... like a wildcard search or something?
I'm trying to make a little script with a GUI wrapper for ...
1
vote
0
answers
914
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 ...
4
votes
5
answers
26k
views
Query DNS for multiple domains at once
I have recently moved servers and want to query all of the accounts domains on the new server to check that they are all resolving to the correct NS.
I am currently using http://www.whatsmydns.net/#...
0
votes
1
answer
228
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 ...
0
votes
1
answer
1k
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 | ...
-1
votes
1
answer
4k
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....
19
votes
5
answers
59k
views
How to automatically kill slow MySQL queries after N seconds?
I am looking for a well tested bash script (or alternative solution) to do so, in order to avoid max_connection to be exhausted. I know that it is fighting the symptoms, but really need such script as ...
2
votes
3
answers
788
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 ...
3
votes
3
answers
6k
views
Can IP tables allow specific DNS queries based on domain name?
I have iptables blocking all UDP traffic at the moment, however I want to allow only certain DNS queries to get through.
Let's use google.com as an example.
I am trying to use string matching to ...
5
votes
3
answers
31k
views
Event Log > Filter Current Log > XML > where EventData contains text
I'm trying to search through the windows event log for anything where the event data contains the string TCP Provider, error: 0 as part of a longer error message. To do this I created the code below:
...
1
vote
1
answer
1k
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 ...
0
votes
1
answer
1k
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))...
2
votes
3
answers
62k
views
How To List All Computers Operating System On A Network In Powershell
I am looking for a script to show all the machines, hostnames, and OS versions on my domain. I have found a few scripts, but none of the scripts that I have found will do both.
Here is an example of ...
2
votes
1
answer
2k
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/...
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
vote
1
answer
358
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 ...
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
2
votes
2
answers
215
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 ...
0
votes
1
answer
9k
views
query from sql table via powershell
I've created a SQL Server database with a simple table on my local machine. I try to query some information from this table. Here is my code:
$connection= New-Object system.data.sqlclient....
1
vote
3
answers
109
views
Any solution for MySQL Servers to avoid rendering them unresponsive when running big queries?
I do run several mysql servers for several clients, there is a common problem I used to see. When I run some big query against big databases, for example:
I have a MyISAM table with several fulltext ...
0
votes
2
answers
958
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 ...
0
votes
2
answers
336
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 ...
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
votes
3
answers
2k
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 ...
10
votes
4
answers
44k
views
Why are my MongoDB queries really, really slow?
I've inherited a large MongoDB server at work, and have been tasked with figuring out why queries run against it are so slow. The DB contains tons and tons of records (on the order of 10^9) and takes ...