The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
2answers
1k 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: ...
0
votes
1answer
20 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 ...
1
vote
2answers
1k 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 ...
13
votes
10answers
67k views

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 ...
4
votes
2answers
16k views

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 ...
0
votes
0answers
24 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 ...
0
votes
3answers
5k 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 ...
0
votes
1answer
41 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 ...
4
votes
1answer
84 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
25 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 ...
1
vote
0answers
11 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
575 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 ...
7
votes
1answer
359 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. ...
1
vote
1answer
320 views

How to generate test data from an sql query and a result set?

I am using an oracle database and want to generate test data from a live database, but I do not want to copy the whole database content. Given a database DB(S, D) consisting of the database schema S ...
0
votes
0answers
17 views

Trying to get a list of websites in IIS by filter, with some properties

Our billing department wants a report of the websites we host for a certain client. The NAME of their sites (what shows in IIS) are all set up to start with a certain string, i.e. "(CLIENT) ". They ...
2
votes
3answers
147 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 ...
1
vote
2answers
12k views

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: ...
0
votes
0answers
14 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
637 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 ...
0
votes
0answers
135 views

LDAP NET-IQ DRA (Active Directory) Group member of does not work

I am trying to list a couple computers, that do not have a specific group membership. This is what I have at the moment: ...
0
votes
0answers
211 views

find all memberOf groups, including cross-domain, of a group using LDA

I am trying to figure out how I can query AD for a group and find all the groups it is a member of including groups in another DC. So this is my configuration (simplified for the sake of simplicity): ...
2
votes
1answer
831 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
173 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 ...
9
votes
3answers
16k views

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 ...
0
votes
1answer
92 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
99 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
283 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
71 views

Is it possible to use workbench to connect to a linux server and send the output to a csv or text file?

I have a user that is using workbench to connect to a Linux MySQL Server and would like to have the query results sent straight to a csv or text file on his computer. I know how to do it if I were ...
2
votes
2answers
1k views

Can IP tables allow specific DNS queries based on domain name?

I have iptables blocking all UDP traffic at the moment, however I want to allow only certain DNS queries to get through. Let's use google.com as an example. I am trying to use string matching to ...
0
votes
0answers
77 views

MySQL frequently starts returning empty results on SELECT and throws no errors. After restart it starts working as expected

MySQL started frequently returning empty results to all queries on all databases until I restart it after which it again works as expected. No errors are thrown or logged and the MySQL server keeps ...
-1
votes
2answers
19k 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 ...
2
votes
4answers
2k 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 ...
0
votes
1answer
62 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
53 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
2answers
4k 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 ...
1
vote
1answer
3k 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 ...
-1
votes
2answers
97 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 ...
19
votes
3answers
13k 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 trigger ...
0
votes
3answers
4k views

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 ...
0
votes
1answer
101 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 ...
0
votes
2answers
75 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 ...
-1
votes
2answers
5k 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 ...
0
votes
1answer
71 views

How to use variables in inner queries?

I am trying to build a query that has something like this select id, (select top 1 create_date from table2 where table1id = t1.id and status = 'success') ...
0
votes
1answer
73 views

dns hierarchy not returning ip address

(DNS1 ,WWW1, Gateway1) (sub-internal network) (DNS0,WWW0,Gateway0) (internal network) DNS1: 192.168.250.3/24 WWW1: 192.168.250.4/24 Gateway1: 192.168.250.1 /24 (internal) :: 192.168.0.150 ...
-1
votes
1answer
123 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
2answers
639 views

how to see queries to oracle database

the database in question is Oracle 10g Enterprise software the tools available are Toad, SQL Developer, and other built in oracle tools I have an application server within the network, alongside the ...
0
votes
1answer
50 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
2answers
251 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 ...
3
votes
1answer
268 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 ...
-2
votes
1answer
72 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 ...