Questions tagged [query]
197 questions
47
votes
3 answers
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 trigger bugs in programs expecting a single answer": it's the…
Totor
- 3,048
46
votes
4 answers
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 few milliseconds, but with this bad query plan, it…
Jeff Atwood
- 13,264
31
votes
3 answers
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 the describe-instances command, we get lines /…
Chris Charles
- 311
27
votes
18 answers
Are there any good and lightweight LDAP querying tools?
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, or if possible to alter...
spinodal
- 373
20
votes
11 answers
Command line active directory query email address for username
On Windows XP in an Active directory environment - what is the easiest way for me to query a user's email address from AD given their username on the command line.
(Assuming I know where it is kept normally in tree).
(I know about net user…
Hawkeye
- 2,809
19
votes
5 answers
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 a short term solution.
alfish
- 3,217
13
votes
3 answers
bind would not work unless allow-query is "any"
I have this in /etc/named.conf, I commented the default values and set my own under it.
My domain would not load in browser unless I set allow-query to "any", is this OK, what should I edit? If is localhost or 127.0.0.1; 10.0.1.0/24; domain would…
adrianTNT
- 1,252
12
votes
4 answers
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 our helpdesk team. Ideally, I'd like them to be…
TryTryAgain
- 1,172
11
votes
1 answer
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: OS get vendor, name > c:\output.txt
but i got error "Node - Error: Description…
PYO
- 121
- 1
- 1
- 7
10
votes
4 answers
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 up about 300 GiB. At first, I thought that the…
Mark LeMoine
- 201
7
votes
1 answer
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
# info on the configuration options.
…
JMAD2016
- 73
7
votes
1 answer
BIND - increase in outgoing NS queries after upgrade to CentOS 6.7?
After upgrading BIND to 9.8.2rc1-RedHat-9.8.2-0.37.rc1.el6_7.2 in a few caching nameservers I've noticed it's doing lots of outgoing NS queries, without changes to incoming traffic volume or patterns.
As a result, the servers are consuming much more…
André Fernandes
- 1,019
6
votes
5 answers
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/#NS which is great.
However, it's rather a slow…
Solace
- 61
6
votes
1 answer
PostgreSQL raw query vs "Function returns TABLE" - insane difference in performance. Why?
I work with the PostgreSQL and it is used for reporting. The way it is configured currently is as follows:
There is a complex query which returns report data, like this:
select Column1 as Name1, Column2 as Name2
from sometable tbl
inner join…
Evgeny
- 213
6
votes
3 answers
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:
…
JohnLBevan
- 1,408
- 9
- 28
- 57