Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [query]

196 questions
3
votes
2 answers

Zabbix - Populate Item with SQL Server Query

I'm trying to track a process that locks up regularly. It's a funky program that we have no control over. I'm trying to find a good way to track when the program stops responding. I have a query which has a result... It comes back with 2 numbers: an…
WernerCD
  • 344
  • 2
  • 6
  • 18
3
votes
1 answer

Handler_read_rnd is too high (more than 2GB)

I am running an advertising program and there are some SELECT, UPDATE and DELETE queries when showing ads. Sometimes, displaying ads is fast but sometimes it is too slow. At this time, it is slow and Handler_read_rnd and Handler_read_rnd_next is as…
Prasad N
  • 145
  • 1
  • 2
  • 7
3
votes
1 answer

Should I be suspicious of this querystring?

I noticed in my application event log some errors: Exception message: A potentially dangerous Request.QueryString value was detected from the client (term="DTİNST32") Request URL: http://domain.com/url.aspx?term=DTNT AUTHORITY\NETWORK…
Brian
  • 303
  • 1
  • 3
  • 15
3
votes
2 answers

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 option instead of the Azure MySQL PaaS…
Sridharan Srinivasan
  • 31
  • 1
2
votes
2 answers

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 INDEX [] ON…
Owain Esau
  • 83
  • 7
2
votes
1 answer

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
jreinap
  • 23
  • 1
  • 4
2
votes
3 answers

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 answers fit my current configuration. view world { …
Sabri MJAHED
  • 35
  • 7
2
votes
1 answer

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 also have policies and apps that we want to apply…
mhouston100
  • 412
  • 1
  • 5
  • 20
2
votes
3 answers

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 complete. I've noticed that running an ANY query…
HippoMan
  • 222
  • 1
  • 10
2
votes
0 answers

WMI Query - First and Fourth IP octet

Is anyone aware of any WMI queries that could be used within group policy which only lists all IP address, which end in .200 and I have multiple sites, multiple networks, I only need to list the devices that end with .200 and start with 192. for…
AlexD
  • 21
  • 2
2
votes
0 answers

Show or log long queries with values instead placeholders

I have any very long sql query in postgresql. I tried show what postgress do with: select * from pg_stat_activity unfortunately I see something like: select some_fields from anytable1 anytable2 where \ ( anyfield1.anytable1=$1 )and(…
Znik
  • 348
  • 1
  • 3
  • 12
2
votes
1 answer

SCCM - Query Powershell Version

I am trying to create create a query in SCCM to show how many computers are installed with the different Powershell-versions. I suspect we have a mix of v2,v3 and v4, but I need to know how many and their computer names. Does anyone know how I can…
PowerShellGirl
  • 23
  • 1
  • 1
  • 5
2
votes
3 answers

How to filter a LDAP query for users which are authenticated?

I want to check if a user is authenticated right now for my Windows domain. For that I want to use an LDAP query. I learned that there is a group "Authenticated Users" (S-1-5-11) which might do the trick. But how to include it to a LDAP query?…
avh
  • 41
  • 1
  • 3
2
votes
1 answer

How do I query members of an Exchange distribution group using LDAP filter syntax?

I'm trying to use a couple of Exchange distribution lists for access to an application (the list, due to the culture at this particular enterprise, is kept more up to date with people moving in and out than many of the security groups). The problem…
Mikey T.K.
  • 1,417
  • 2
  • 16
  • 29
2
votes
1 answer

SCCM Collection Query- FullName

I found this page about using usernames to build a sccm collection query. http://jengeek.blogspot.com/2014/07/creating-sccm-collection-from-list-of.html?m=1 This works great! However, the list I got was in FirstName LastName format and not…
Benjamin Jones
  • 326
  • 1
  • 9
  • 23
1 2
3
…
13 14