Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [query]

196 questions
2
votes
3 answers

"Delete query" not able to be completed

I have a very simple mysql script that is running. But it hangs, and runs forever without finishing. What are possible reasons, and how can I resolve them? delete from guid_target_infos where type_id = 1 and updated_at < '2010-03-14' limit 1 UPDATE:…
mingyeow
2
votes
1 answer

Simple SQL Server 2005 Replication - "D-1" server used for heavy queries/reports

We have two SQL 2005 machines. One is used for production data, and the other is used for running queries/reports. Every night, the production machine dumps (backups) it's database to disk, and the other one restores it. This is called the D-1…
Ricardo Pardini
  • 776
  • 7
  • 9
2
votes
1 answer

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 {{ tower_var_path }}/clusters.json register:…
BrillCom
  • 139
  • 2
  • 9
2
votes
2 answers

A more useful MySQL Query log that's suitable for tail -f'ing

In order to debug a webapp and mysql queries, I've enabled the mysql query log. However it's not a very good format to tail and grep through. Ideally I'd like to be able to only show queries from a certain user, or queries to a certain database. If…
Amandasaurus
  • 31,471
  • 65
  • 192
  • 253
2
votes
1 answer

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/kitset-kitchens?category=kitset-kitchens if I put…
Nikita
  • 123
  • 4
1
vote
1 answer

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 members resulting from nested groups? I want to be…
Hmmmmm
  • 113
  • 5
1
vote
2 answers

Event logs on multiple server

I am looking for tools that will allow me to aggregate and query event logs from multiple servers. In my case, this is a webfarm and I need to be able to query the event logs for all of them in one place. Can anyone recommend such a tool?
Oded
  • 267
  • 2
  • 16
1
vote
1 answer

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" sub="ips" name="Intrusion protection alert"…
marsh-wiggle
  • 2,145
  • 5
  • 29
  • 45
1
vote
1 answer

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? Or will the query be ignored until it reaches its…
David Breeden
  • 23
  • 3
1
vote
4 answers

The database at work has Unidata format, how do I access it?

I know just enough about database to get by - it's not normally within the scope of my job, but I think it's good for everyone to know a little bit. I'm trying to access some of the data in our DB here at work, which would be perfectly quick and…
NoCatharsis
  • 133
  • 2
  • 5
1
vote
0 answers

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 = 10000000 memqcache_expire =…
Kolyunya
  • 217
  • 1
  • 3
  • 9
1
vote
1 answer

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 v2.2 installed=> Query Rule Properties => Edit Query…
DSKyo
  • 153
  • 3
  • 6
  • 15
1
vote
3 answers

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 find anything in the error log I just updated…
patrickdamery
  • 113
  • 1
  • 5
1
vote
1 answer

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" & "ANSWER SECTION" with Microsoft DNS. Now I receive (with BIND) an "AUTHORITY…
JFA
1
vote
2 answers

WMI query to check for IP default gateway for OSD

I'm trying to add a condition for a command line, which should only be run if the condition is met. I'm doing this by using a WMI Query; Select * From Win32_NetworkAdapterConfiguration Where DefaultIPGateway="192.168.1.1" So, if the gateway for…
Saeed
  • 366
  • 3
  • 11
1 2 3
…
13 14