Questions tagged [query]
The query tag has no usage guidance.
196
questions
0
votes
1
answer
957
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 ...
4
votes
1
answer
1k
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
0
answers
385
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
1
answer
792
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
0
answers
405
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
1
answer
13k
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
3
answers
771
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
0
answers
69
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
2
answers
10k
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
1
answer
705
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
1
answer
9k
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
1
answer
2k
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
1
answer
878
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
1
answer
1k
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
0
answers
1k
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
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 ...
0
votes
1
answer
237
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
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
3
answers
9k
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
2
answers
174
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
1
answer
319
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 ...
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 ...
0
votes
2
answers
711
views
bind cache not used?
i installed a classic bind9 dns server inside a local network, working as a forwarding dns server,
there is my config file (i just added my ISP DNS servers as forwarders):
options {
directory "...
0
votes
3
answers
20k
views
Restore SQL Database From BAK File using a SQL Query
I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so.
Here is my query:
ALTER DATABASE DBASE
SET SINGLE_USER WITH
...
-1
votes
1
answer
13k
views
Find Computers Recently Joined to Active Directory
How can I find Computers recently joined to Active Directory?
Edit:
I've searched google for the title phrase, and have also searched here, but can find nothing specifically about filtering on when ...
0
votes
1
answer
60
views
Diagnosing where all the queries are coming from
We have an issue where a site on a shared hosting account is going over the allowed query limit per user; that is set at 100k queries/hr. The site shouldn't be generating that amount of queries TBH ...
-1
votes
2
answers
1k
views
repeated mysql queries change execution time
I noticed that when I execute a query more than one time consecutively on my mysql machine, the execution time drops and changes significantly (40/50%) after the first execution, and that WITHOUT ...
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 ...
-2
votes
1
answer
103
views
0.5 TB SQL Server Database, is it possible to store in a standalone server? [closed]
We are facing the task of storing of 0.5 TB of data in a SQL Server 2008 Server.
Is it possible to do it in a standalone server?
Later we also want to query for generating statistics of the data (a ...
0
votes
1
answer
95
views
Anyone knows what 173lo.com is - top entry on my BIND DNS server
Administer a DNS server running BIND DNS. We use dnstop to monitor queries. I have 173lo.com as top query with highest count and I'm wondering what the domain is, I can't find really useful ...
2
votes
1
answer
9k
views
Search AD for empty sAMAccountName & userPrincipalName
I'm in the process of implementing a User privilege management solution and it needs to audit all users within our AD. It's currently falling over due to an account which has two blank attributes: ...
1
vote
2
answers
7k
views
apache - query string rewrite rule appends condition to URL
In trying to rewrite
site-search.html?searchword=search%20term
as
advanced-search#q=search%20term
I always end up with advanced-search#q=%3Fsearchword%3search%20term
The %3Fsearchword%3 ...
3
votes
1
answer
906
views
Expensive LDAP queries from Workstations
Troubleshooting high LSASS process on a DC found expensive queries originating from a few workstations.
Each query is as follows:
Visited Entries: 1Million+
Returned Entries: <50 (most of the ...
1
vote
1
answer
2k
views
Querying SCCM Server to get ADD/Remove Programs list of a specific computer
First of all, i'm sorry for my english.
I'm new in vbs scripting and wmi queries and I need your help.
My goal is to get the Add/Remove Programs list of a specific computer.
I saw many scripts which ...
2
votes
1
answer
698
views
OpenLDAP and range attributes
I am trying to query the "member" attribute of a groupOfNames object, and in AD, I can be sure to retrieve all of them, should they exceed the maximum of 1000 entries, by using ranged attribute ...
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 ...
1
vote
1
answer
1k
views
Nested/Joined SQL Query to Extract Phone Data From Cisco UCM Database
I need to query numbers of phones per site for Analog, and IP phones separately. I can do it with these two queries.
IP Phones:
select count(d.name) as IP_Phones, dp.name as DevicePool
from Device ...
0
votes
1
answer
401
views
Powershell - query non-standard group members in an OU?
I am looking to create a script which will only show users in an OU who are members of "non-standard" groups.
For example, all users in the "Accounting" OU will be members of at least one group with "...
1
vote
1
answer
4k
views
MySQL Queries taking too long to execute
I have a database table, with 300,000 rows and 113.7 MB in size. I have my database running on Ubuntu 13.10 with 8 Cores and 8GB of RAM. As things are now, the MySQL server uses up an average of 750% ...
4
votes
1
answer
5k
views
SCCM query for cluster (virtual) name
I'm trying to determine if the cluster name is stored in SCCM audit data. I see the host name in [v_R_System], and I'm able to identify cluster nodes here. What I need is the virtual name for the ...
-1
votes
2
answers
8k
views
SQL Server queries running more than the timeout values set in IIS 7.5 and SQL Server query timeouts
Which time out value does SQL server take into consideration while executing a query or stored procedure? The application timeout is set at 20 minutes. The SQL query/command timeout is set at 10 ...
1
vote
1
answer
776
views
Ldap query on single subOU for Alfresco
this is what my ldap looks like :
red.lan
Groups(OU)
Computers(SubOU)
Printers(SubOU)
Users(SubOU)
Some(OU)
Users(OU)
SomeOther(SubOU)
So, i'm ...
4
votes
2
answers
2k
views
What is the most efficient way to add a lot of data to a mysql database?
I have a batch of data that needs to be added to a mysql database every day consisting of about 100K queries.
START TRANSACTION;
INSERT IGNORE INTO info (Created, Modified, MType, Pform, Name, ...
-1
votes
1
answer
52
views
Apache File Query [closed]
I have an Apache server that has multiple files located on it. Each file is an updated version from the previous file. Eg. release-2013-07-20 is an older file and release-2013-07-25 is the newer file.
...
2
votes
1
answer
553
views
SCCM 2007 query to select users belonging to listed AD groups
Can somebody advice me on WQL query to select all users from specified AD groups? I tried to do this through query builder but without success.
I'm going to use these selecter user to further select ...
0
votes
1
answer
265
views
Why does this RewriteRule in httpd not work?
I tried to set this RewriteCond in httpd 2.4.4:
...
RewriteCond expr "%{QUERY_STRING} =~ /welcome/"
RewriteRule ^(.*)$ %1\.html
So, if I visit https://localhost/?welcome , for example, I should see ...
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/#...
6
votes
1
answer
7k
views
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, ...
1
vote
1
answer
395
views
Bind9 how stop to answer specific queries?
How I can make Bind9 to stop answering specific types of queries, let say NULL, WKS or TXT?
Thanks in advance.
12
votes
4
answers
50k
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 ...