Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [query]

The tag has no usage guidance.

-1
votes
0answers
14 views

Google Cloud Multiple database [closed]

Im sorry for my bad English. I have a high-traffic website. This site is a shopping site and therefore website with many queries (Almost 250 query per page). I have a very good server. Sometimes there'...
0
votes
3answers
48 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 ...
0
votes
0answers
27 views

Installing mysqlnd_qc plugin

As the title says, I need (I really need) to install the mysqlnd_qc plugin. But, however, this is not really simple. So, what I achieved yet is installing MySQL Native Driver, Apache etc. and that's ...
0
votes
1answer
277 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 ...
0
votes
1answer
30 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 ...
0
votes
0answers
61 views

How store time series data for resample / aggregation / querying data?

I'm looking at options for storing and resampling time series data. Ideally, It would be possible to store time series such as 1-minute samples and then be able to "resample" it. For instance, for ...
1
vote
1answer
181 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
0answers
59 views

Azure SQL Query Performance Insight not working

Been having this issues for weeks (months maybe). In the Azure dashboard and then into our Azure SQL DB we open "Query Performance Insight" to monitor performance but it never works. The monitor ...
0
votes
0answers
58 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, ...
1
vote
1answer
701 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 ...
2
votes
1answer
146 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 ...
1
vote
3answers
76 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 ...
0
votes
0answers
73 views

fetch json data from nagios hostgroup

I have a nagios server setup which monitors single hosts as well as host groups I want to have the current/live availability of all the hosts belonging to a host group in a json output. for example :-...
0
votes
1answer
328 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 ...
0
votes
0answers
61 views

Infor LN change current package when creating a report in query data?

So recently i am hired in industrial company and this company is using infor LN as an erp solution for daily task. my company is a subsidiary and we are not the owner of this infor LN. Yesterday i ...
-2
votes
1answer
2k 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, ...
0
votes
1answer
247 views

“show processlist;” output - percent sign

In the output above, what does the % (percentage sign) mean ? mysql> show processlist; +------+--------+----------------------+----------+---------+------+--------------+---------------------------...
0
votes
0answers
405 views

SCCM Status Messages Unable to Retrieve Stored Queries List

After upgrading from SCCM 2012 R2 SP1 to SCCM 1610, we have begun experiencing issues when running status message queries both on the site and components. When attempting to view the status messages, ...
0
votes
1answer
688 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 \`${...
0
votes
1answer
575 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 ...
2
votes
2answers
7k 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 ...
1
vote
0answers
226 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 = ...
-2
votes
1answer
45 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.
1
vote
1answer
11k 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 ...
0
votes
1answer
574 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
1answer
414 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!...
5
votes
1answer
48k 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:\...
1
vote
3answers
382 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 ...
0
votes
1answer
597 views

MSSQL query not working, even if there is data

Trying to run a more complex SQL query on an MS SQL server, but I get no data output. Logically should be fine, but I cant see why it doesnt work: SELECT D.NAME DATABASE_NAME,T.NAME TABLE_NAME,I.NAME ...
0
votes
0answers
75 views

Single LDAP Query that returns usernames starting with “X” on multiple different containers

I have an assignment to send a daily report of users starting with "X" (or whatever) on multiple different containers (ContainerA, ContainerB, ContainerC). I could simply create a Saved Query for ...
4
votes
1answer
781 views

SQL Azure insert query ten times slower on V12 than V11?

I noticed performance degradation about two weeks ago impacting one of our applications with an SQL Azure backend. It's running on V12 on tier S1 90% of the time, sometimes scaling to S2, S3 or P1. ...
2
votes
0answers
105 views

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 ...
0
votes
1answer
353 views

Finding list of fonts for each PC

I am trying to find the best way to find a list of clearview fonts on each PC on our domain. Questions: 1.) Should I use SCCM & how? I've create a Query but I am getting nothing right now. I was ...
2
votes
0answers
163 views

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 ...
2
votes
1answer
7k views

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 ...
2
votes
3answers
426 views

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

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 ...
0
votes
0answers
40 views

MySQL execute every query on a second server

I have a Web-application on a Linux Debian 8 Server saving in MySQL. I need a backup which is always the latest version(not even a minute behind) so the only way i could think off to archive this is ...
1
vote
2answers
5k views

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 ...
7
votes
1answer
586 views

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. ...
2
votes
1answer
5k views

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 ...
2
votes
1answer
1k views

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 ...
0
votes
1answer
359 views

whats the best practice to do a long query like deletion of big chunks in mysql

On production servers I need sometime to delete a few 100,000s of rows . The query is optimized but deleting at once will cause servers freeze so I do it manually in chunks deleting for example 5000 ...
0
votes
1answer
743 views

How to record/log query execution stats for long running SQL Queries?

I work on a system that comprises of a SQL Server 2012 DB server that is queried frequently with complex queries. Sometimes these queries take more than 2 or 3 mins to return. How can I record or ...
0
votes
0answers
760 views

LDAP Query Of All Users In Various Groups In A Specific ActiveDirectory OU

I need to configure Atlassian Crowd to query all the users in my AD server that are in various groups in a top-level OU. The DN for the OU is "OU=Atlassian,DC=NNNN,DC=com". The various groups would ...
1
vote
2answers
3k 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 ...
0
votes
1answer
90 views

I am confused about the Authoritative DNS Server actual definition

I search for this a lot and the answer is the same everywhere: Authoritative servers give either the answer or "NO", the host does not exist. Non-Authoritative servers use either cache or a ...
1
vote
2answers
66 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
3answers
5k views

ldap query with nested group

I try to build a ldap query to MS Active Directory. I found that there is a LDAP_MATCHING_RULE_IN_CHAIN type to do so. Which results in the follow syntax: (&(sAMAccountName=Benna)(memberof:1.2....
-1
votes
2answers
158 views

Who is responsible for performing the query EC2 or RDS?

Normally I run my own MySQL server (within EC2), but I was looking for the possibility's of RDS ( https://aws.amazon.com/rds/ ). As I understand RDS is (directly after setup) optimized for ...
0
votes
1answer
220 views

Concurrent MySQL processes

I have a file, let's call it a.php, which executes a long cycle of iterations, each one of them makes some queries to the database. To complete the cycle, it takes quite some time (some hours). My ...